Yiyao(Lucia) Yang

Experience

• 

  BMW China

  Jun 2017 - Aug 2017

  Market analytics Intern

  • Conducted quantitative analysis on reviews and net promoter score data to identify customer preferences that helped BMW develop loyal customer base in Chinese market• Led research project on market segmentation for customers buying a second private car, which resulted 15% increase in sales by targeting divided customers on need-base• Created daily Chinese automotive industry analysis report and presented to 16 marketing employees, providing updates and insights about BMW’s market position• Published visualization reports using daily and historical sales data, which worked as critical reference for current and future performances Show less

• 

  Kernel Labs

  Oct 2018 - Jun 2019

  Data Science Intern

  • Built predictive data model based on 390+ factors to for prediction of King County residents’ migration in future 3 to 5 years • Implemented Regression analysis, classification model and Xgboost model using R and Python on datasets with 1M observations• Cleaned datasets on government websites such as American Housing and the US Census• Generated weekly reports for sales manager and CEO on our prospective customers with higher moving score• Researched on Case Shiller index, learned methodology and developed an index model on historical data Show less

• 

  Panopto

  Mar 2019 - Jan 2019

  Competitive Research Analyst

  • Identified 600+ potential leads for the sales team by finding university users who use competing products• Response rate raised to 55% and migration rate increased from 15% to 35% due to the targeted list• Formed a magic quadrant figure, visualized our leading market position and attracted potential buyers• Created a research pattern using Excel and pivot table for sales team to decide which factors of contactlead to highest sales conversion

• 

  EY

  Aug 2019 - Oct 2020

  Consultant（Financial services）
• 

  DiDi

  Oct 2020 - Sept 2021

  Quantitative Financial Risk Manager