YUQING (ALICE) YANG

adikqv@r.postjobfree.com New York, NY 949-***-****

EDUCATION

Columbia University, New York, NY

MS in Applied Analytics: GPA:3.6/4.0 December 2020

• Relevant Coursework: Data Visualization, SQL, Strategy and Analytics, Storytelling with Data, Marketing Strategy University of California, Irvine, Irvine, CA

BA in Business Economics: GPA: 3.6/4.0 December 2018

• Relevant Coursework: Statistics, Probability, Business Decision, Social Sciences, Mathematics, Economics, Accounting

• Honors: Dean's Honor List (2016/2017/2018)

PROFESSIONAL EXPERIENCE

MindWire, New York, NY September 2020 - Present

Business Analyst (Capstone)

• Constructed and presented actionable insights and recommendations to improve retention rate for MindWire, a SaaS firm

• Employed a Random Forest Regression on several data types, including usage behaviors and contract features, to investigate variables correlated with retention using R; Performed ad-hoc analysis to further understand customer behaviors

• Segmented customers by industry, length of contract, and account activity; Compared retention rate in different segments and established benchmarks to measure customer retention; Developed strategies to improve retention by 15% McKinsey&Company, Shanghai, CN September 2020 - November 2020 Part-time Analyst

• Devised loss rate reduction plan and strategic solutions for client based on market research, pain points, and challenges

• Collected data on commercial health insurance industry in China over the past ten years and predicted a three-time market growth in the next five years; Identified major pain points for client that will jeopardize profit margin growth

• Analyzed insurance claims and patient data to assess risk of diseases and illnesses with high paid costs

• Structured healthcare management strategies to enhance disease prevention, and therefore reduce loss rate Enlight Global Consulting, New York, NY May 2020 - October 2020 Digital Marketing Specialist

• Formulated online marketing strategies and campaigns to increase sales by 89% and account subscribers by 72% in Q3

• Designed email campaigns with A/B tests and structured KPIs to improve conversion rate and marketing effectiveness

• Coordinated with consultant team to standardize customer service process to optimize working efficiency RELEVENT PROJECTS

NYC Federal Job Posting Project, Columbia University, New York, NY June 2020 - August 2020

• Developed a relational database for Career Center to store federal job postings to guide students towards target positions

• Built database schema based on 3NF and performed ETL (Extract, Transform, and Load) on dataset using SQL and R

• Analyzed federal job market hiring needs and visualized analytical procedures and results in a Metabase dashboard Airbnb Rental Price Prediction, Columbia University, New York, NY October 2019 - December 2019

• Cleaned raw data of 35k records with 91 variables by imputing missing data and deleting redundant variables in R

• Selected variables using Feature Selection methods to build price prediction model

• Implemented tree-based models to predict Airbnb prices in New York and calculated RMSE to test the accuracy EXTRA CURRICULAR ACTIVITIES

2020 Bain Competition: SUPERMONKEY Strategy in Mainland China, New York, NY May 2020 - June 2020 Team leader of Semi-Finalist

• Led a 4 people team to device business and financial strategic plans for SUPERMONKEY to elevate market share

• Forecasted overall fitness market trend evolve in the next five years in China and determined key drivers

• Evaluated market position of SUPERMONKEY by conducting competitive analysis, customer profiles and KPC, etc SKILLS

Computer: SQL, R, Python, Tableau, Microsoft Office Suite (Word, Excel, PowerPoint), MailChimp, Google Analytics Specific Skills: Data Visualization, Data Cleaning and Analysis, A/B Testing, Business Planning and Strategies Languages: English (Fluent), Mandarin Chinese (Native)

Contact this candidate