🙋♀️ Hi I'm April Yang! This Portolio is a compilation of all the Data Science and Data Analysis projects I have done for academic, self-learning and hobby purposes. This portfolio also contains my work experience, skills and certificates.
- Email: april03yyw@gmail.com
- LinkedIn: Yuwen(April)Yang
- Please feel free to connect with me or contact me!
Tools: Python
Built a Wordle Game Simulator in Python, where users can guess the answer in 6 attempsts with hints on correct letter and correct position
📈 Equity Research Analyst @ Burkenroad Reports
Tools: Bloomberg, Excel
Performed equity valuation and operated P/TBV ratio and 3 statement pro-forma models to forecast revenue streams; Presented investment recommendation conclusions to over 20,000 institutional and individual investors
- Professional: Python, SQL, R, Tableau, Adobe Premiere Pro, Bloomberg
- Language: English(Native), Mandarin Chinese(Native)
- Certificates: Google Data Analytics Specialization
Data Analyst Intern @ Kantar
- Conducted market research reports using SQL for six brand clients across multiple industries, including Heineken, New Balance, Continental, Shangri-La, OSM and Abbott, generating strategy to improve brand awareness on specific mediums and audience groups
- Created data visualization using Tableau with the data above; Produced six reports analyzing brand performance, campaign impact and benchmarking against competitor, providing strategic recommendations that boosted brand power scores by 15% on average
Private Equity Analyst Intern @ Guotai Junan Securities
- Wrote two in-depth industry research reports about Hydrogen Fuel Cell and Advanced Driver Assistance System
- Presented industry research reports to the team (including Investor Relations Manager); My recommendation of not investing in Shanghai Shen-Li High Tech Co., Ltd because of poor government policy, low production efficiency, and high related-party transaction was implemented by the company, preventing a potential loss of $50 million
Financial Planning and Analysis (FP&A) Intern @ Wuxi Biologics USA
- Extracted data from the 10-K reports of four competitors in the Contract Development and Manufacturing Organization (CDMO) industry; Calculated gross profit and EBITDA benchmarks and provided profit improvement recommendations, including strong M&A or follow the industry trend to provide integration of AI/Machine Learning in preclinical drug development
- Built two advanced Excel models to analyze profitability using 4-year revenue and cost data; Presented findings to the Finance team to inform future budget forecasting and decision making
Master of Science(M.S.) in Business Analytics (MSBA) @ UC Davis
Core Modules: Machine Learning and Artificial Intelligence, Analytic Decision Making, Big Data, Advanced Statistics and Forecasting
Bachelor of Science in Management @ Tulane University
Major: Finance, Minor: Marketing
Core Modules: Business ANalytics, Research and Analytics, Financial Modeling, Equity Analysis