Qi Cai
**** ******** ******, ************, ** ***04 • 267-***-**** • *****@***.*****.***
PROFESSIONAL EXPERIENCE
Penn Wharton Budget Model Philadelphia, US
Application Developer 10/18 – Present
Main Responsibility:
• Designing, developing and implementation of web applications and operating systems in compliance with requirements in Python, C# and JavaScript
• Developing tools in Python to improve metadata capture and resolve issues in the staging database to ensure the reliability and quality of pipeline data flowing towards production Project: Upload Sheet UI
• Designing Python Flask UI for a data API to ingest data from spreadsheets to SQL database
• Constructing JSON schema using object-oriented programming
• Improving usability by developing auto-checking upload results function in JavaScript and creating functions enabling re-upload options for users
Project: Excel Plugin
• Developing Time Series and Machine Learning models (ARIMA, VARX, Random Forest, SVM) utilizing statsmodel, scikit-learn in Python and designing the corresponding UI classes in C#
• Implementing functions identifying monotone patterns of models’ parameters to reduce runtime by 50%
• Executed full lifecycle (design, build, document, unit & functional test and deploy) of a license API through Flask to generate licenses for the product
Project: Source Change Monitor
• Designed a monitoring system to catch newly released data from 500+ web sources
• Deployed the system on Linux server to update changes on a daily basis
• Applied multithreading to increase the productivity of the system by 60% Guosen Securities Co., Ltd. Qingdao, China
Intern Securities Analyst 6/16 – 8/16
• Performed fundamental analysis, market trends research and financial analysis in technology and energy sectors
• Built financial models for valuation and revenue forecast using Discounted Cash Flow and Comparative Analysis
• Followed up policy changes, analyzed market conditions and developed analysis reports of securities EDUCATION
University of Pennsylvania Philadelphia, US
M.A., Applied Mathematics and Computational Science, GPA: 3.67/4.00 8/16 – 5/18
• Programming Languages and Techniques: object-oriented design of games and systems in Python, Processing and Java, and implementation of Test-Driven Development on codes
• Algebraic Techniques: focused on the numerical aspects of linear algebra, computed QR, SVD and advanced topics in MATLAB
• Data Analytics and Statistical Computing: Conducted data simulation and analysis, including statistical inference
(Bootstrap) in R
King’s College London London, UK
B.Sc., Mathematics with Management and Finance, GPA: 3.96/4.00 9/13 – 7/16
• Ranked #1 in academic achievement, awarded Best Graduating Student Prize, Math with Management and Finance Prize and Florence Hughes Exhibition Prize
SKILLS SUMMARY
• Programming Languages & Systems: Python, C#, Java, Processing, MySQL, JavaScript, Linux, Azure, R, MATLAB
LEADERSHIP EXPERIENCE
KCL Chinese Students and Scholars Association (CSSA) London, UK Secretary 9/14 – 2/16
• Kept records of the society, arranged meetings and set agendas and facilitated internal communications
• Collaborated with other departments in organising activities and developing 20+ new business partnerships