Qi (Stella) He
Waltham, MA 336-***-**** adbk8h@r.postjobfree.com www.linkedin.com/in/qihe
EDUCATION
Brandeis University International Business School Waltham, MA Candidate for Master of Science in Business Analytics (STEM-Designated) – GPA: 3.8 12/2020 Core Coursework: Analyzing Big Data, Python and Applications to Business Analytics, Applied Econometrics, Information Visualization, Healthcare Data Analytics and Data Mining, Forecasting in Finance and Economics, Computer Simulations and Risk Assessment, Machine Learning Wake Forest University, School of Business Winston-Salem, NC Master of Science in Accountancy (Passed CPA exams) 05/2019 Bachelor of Science in Finance, Minor in Psychology – GPA: 3.66 05/2018 Core Coursework: Applied Quantitative Financial Analysis, Financial Management, Financial Accounting, Managerial Accounting, Fixed Income, Financial Derivatives, Marketing WORK EXPERIENCE
CreditEase Beijing, China
Analyst Intern 06/2019 - 08/2019
• Cleaned and analyzed over 200,000 rows of user data using both Excel and R, identified patterns between user default rate and factors such as loan amount, pay frequency and interest rate
• Visualized data into intuitive graphs and charts to enhance team’s understanding of patterns
• Researched into economic conditions and private debt industry worldwide, analyzed information and data from various sources, and wrote a professional report providing financial trend prediction IDG Capital Beijing, China
Analyst Intern 07/2018 - 08/2018
• Investigated current logistics industry in China; analyzed and interpreted data to draw conclusions for investment strategies, and proposed two ideal cities for future logistics real estate investments out of 29 possible cities
• Conducted forecast for operations of listed companies using data given in proposals to determine investment opportunities; carried out field research alone on four real estate projects Hua Chuang Securities Shenzhen, China
Audit Intern in an IPO project 05/2017 - 07/2017
• Inspected warehouses and took stock of 126 different kinds of inventory to ensure veracity of financial reports; checked vouchers and invoices with corresponding journal entries
• Located key data from financial statements, calculated main financial indicators including current ratio, quick ratio, accounts receivable turnover and inventory turnover, and improved efficiency of audit process SELECTED PROJECT
Grocery Shopping Behavior Analysis Project (Python, SQL)
• Created and populated database based on the understanding of given consumer data; imported database into MySQL with SQLAlchemy and joined tables together to build database schema
• Analyzed consumer shopping frequency, loyalism to certain retailers and items bought based on demographic data such as household size, residence type and family income; designed various visualizations with Matplotlib package
SKILLS
Technical Skills: SQL, Python, R, SPSS, Tableau, Alteryx, Microsoft Access, Excel, PowerPoint, Wind, Bloomberg Language: Chinese (Native), English (Fluent)