Yuting Qiao

Experience

• 

  Rutgers Chinese Student & Scholar Association (RCSSA)

  Sept 2013 - Apr 2014

  Vice-Minister of P.E Department/ Member

  Co-organizing basketball games, soccer games and card games for all Chinese faculties, staffs and students in Rutgers University.Co-organizing Spring Festival Gala Evening for all Chinese faculties, staffs and students in Rutgers University.

• 

  HSBC

  Jun 2014 - Aug 2014

  Summer Intern

  · Managed daily work assignments, recorded and analyzed data of customers’ preferred walk-in hours· Analyzed customer preferred walk-in hours and the most popular services at different time by developing a dashboard with the summary of customer personal information, preferred services, and purchase behaviors to improve customer satisfaction from 3.5star to 4.5 star· Optimized and created a better service shift schedule by simulating with the simulation software Arena, resulting in saving cost of 60,000RMB ($10,000)/yr· Understood bank operations by communicating with different departments and reviewing meeting materials Show less

• 

  Meitu

  Jul 2015 - Aug 2015

  Summer Intern

  · Built communication between users and engineers by developing Quality Function Deployment (QFD) to match projects’ objectives with customers’ feedbacks, increase MeituPic’s popularity in terms of downloads on the APP Store by 14%· Analyzed customer preferences on 15 MeituPic functions and the root causes of the differences with the help of Ishikawa Chart (fish-bone diagram) by cooperating with other departments and summarizing customer behaviors· Quantified a positive relationship (R2=87%) between the crashes of App and uninstalls of APP by using hypothesis testing and regression analysis through Minitab software. Found two KPIs (# of crashes and data usage of APP) of APP uninstallation by using hypothesis test and logistic regression through Minitab, decreasing the uninstallation rate by 10% Show less

• 

  Swire Beverages

  Jun 2016 - Jul 2016

  Intern, Consumer Marketing Department

  ·Targeted new prospects, initiated effective campaigns and optimized costs to achieve the KPI in sales, resulting in exceeding the original goal by 107% (4,200,600 vs. 4,493,823 Unit Cases)·Designed and measured the promotion events, such as sharing your photos with your dad on Father’s Day, by tracking and calculating the lift of the events in sales, number of participants, and sold units; attracting 70,000 new customers in this event·Predicted the daily sales by using the previous sales data and communicating to local sales departments to optimize daily supplies, saving 20% of the cost Show less

• 

  BMW Group

  Jan 2018 - Jul 2018

  Safety Engineering Intern

  Developed bi-weekly reports using SQL, Access and Warranty Data Warehouse to track several statistics about completion rates for each specific recall campaign, availability of replacement parts, and customer statistics. Conducted statistical analysis of the Recall reports and created an interactive dashboard to present the findings NHTSA (traffic regulation and safety agency in the US)Implemented analytical and business models which facilitated more efficient reporting structures that allowed the end users to run queries and run data sets for analysisConceived, developed and evaluated cutting-edge technologies to power future mobility services Show less