MS in Applied Analytics - Seeking Business Analyst or Data Analyst Rol

Michelle Huang

advng8@r.postjobfree.com 917-***-**** LinkedIn New York, NY (open to relocate) PROFILE SUMMARY

A passionate problem solver with excellent presentation skills and a solid data analytics foundation across multiple core platforms from data- querying (SQL), machine Learning and statistical modeling (Python & R) to visualization (Tableau & Power BI) EDUCATION

Columbia University New York, NY

M.S. in Applied Analytics (STEM major); GPA: 3.86/4.0 Sep 2021 – Dec 2022 Relevant Coursework: Managing Data, Python for Data Analysis, Data Analytics Using SQL, Strategy and Analytics, Storytelling with Data, Computer Programming, Data Structure and Algorithm, Probability and Statistics, Linear Analysis University of Washington Seattle, WA

B.A. in Communication and Math Minor; GPA: 3.61/4.0 (Dean’s List 2018-2020) Sep 2017 – Dec 2020 PROFESSIONAL EXPERIENCE

Huawei Technologies Co. (leading global provider of ICT infrastructure serving over 170 regions) Shenzhen, China HR Data Analyst Intern May 2021 – Aug 2021

• Evaluated the effectiveness of Huawei's global campus recruitment by synthesizing past recruitment data using Excel and SQL on resume submission, interviews, and onboarding – detecting position matching as the weak link in the process

• Developed a new global campus recruitment plan for Huawei’s largest department and presented the recommendation to the Head of Human Resources – resulting in implementation of the plan and increase in conversion rate by 12%

• Spearheaded reaching out to 1,000+ upcoming graduates in target majors and successfully managed 5 college recruitment Q&A communities – leading to a 26% increase in the size of the candidate pool Limitless Shares (startup that have received angel round investments) Shenzhen, China Marketing Business Analyst Intern Feb 2021 – May 2021

• Conducted a SWOT analysis of the top 30 beverage brands in China to create a blue ocean canvas for a new beverage brand – resulting in a unique brand concept and implementation strategy for the initial phase

• Executed a competitive market action plan with visualizations through analysis of the top-selling beverage brands, including brand concept, target customer, advertising strategies, pricing, and market evaluation Tencent (world-leading internet and technology company, world's largest video game vendor) Shenzhen, China Business Data Analyst Intern July 2020 – Oct 2020

• Analyzed the content operation plan for each game's official account using Excel and visualization to optimize video purchases with high ROI and predictive traffic – leading to a 9% increase in customer retention rate

• Developed launch plans for upcoming games by analyzing release strategies and competing games in the same genre – resulting in successful game launches with high user adoption rate of 65%

• Identified the optimal resource ratio for major game marketing platforms using the lpSolve package in R based on earnings calls, financial reports, and user data – leading to more effective marketing campaigns and higher ROI PROJECTS EXPERIENCE

Data Analyst, Demand Forecast Capstone Project Sep 2022 – Dec 2022

• Conducted data cleaning and exploratory data analysis, using Python and Power BI to identify seasonal and sales trends

• Generated demand forecasts for 14 months – resulting in a 5,000 pack/month reduction in forecast error per product

• Evaluated and improved the current machine learning model by testing 5 different models (Moving Average, Seasonal ARIMA, Prophet, Long Short-Term Memory, and K-Means Clustering) – resulting in a 15.28% error reduction in MAPE Research Data Analyst, Bitcoin Price Change Analysis Jan 2022 – Apr 2022

• Conducted sentiment analysis using BING and AFINN lexicons from R on Twitter data to predict bitcoin price

• Visualized the analytical findings using ggplot2 to find no correlation between the tweets' emotions and price change Marketing Research Analyst, Tesla’s Market Performance in The Chinese Market Sep 2021 – Dec 2021

• Conducted market research to understand Tesla's competitive market position in Chinese EV market and visualized the insights using Tableau to develop strategic plans to gain market share targeting underserved consumer groups LEADERSHIP EXPERIENCE

Vice President, University of Washington Chinese Students and Scholars Association May 2019 – Jun 2020

• Coordinated the "2019 The Voice of UW"; led a team of 30 to accomplish a 10-week preliminary planning and held a 3-week event; attracted 1000+ audiences and reached a peak of 3000+ on live session for the Finale Event Coordinator, 2019 University of Washington Spring Career Fair Feb 2019 – Apr 2020

• Negotiated (increased $620 for one package) and signed contracts with 8 sponsors, and ensured all the rights were fulfilled on the event day with feedback recorded

• Planned and supervised recruiting events for 5 employers and a 3-hour panel discussion event with 10 industry professionals CERTIFICATES & SKILLS

• Certificates: edX Business Analytics ColumbiaX Micro Master

• Skills: Machine Learning and Statistical Modeling – Python, R; Data Query – SQL; Visualization – Tableau, Power BI; Microsoft Suites (Excel, PowerPoint, Word), Project Management, Effective Communication and Presentation Skills

• Interests: Scuba Diving (PADI Advanced Open Water), Singing (Semi-finalist in the 2018 Voice of UW)

Contact this candidate