Hanlin (Eric) Xiao

Experience

• 

  Haitong Securities

  Jul 2017 - Aug 2017

  Wealth Management Intern
• 

  TWT Studio

  Jun 2018 - Jun 2019

  News Center Director
• 

  Bohai Securities Co., Ltd.

  Jul 2018 - Dec 2018

  Investment Banking Intern

  · Supported preparation of TEDA Group’s Asset-Backed Security project proposal by providing analysis of market overview, development of cash flow model, and writing case studies on REITs, CMBS and supply chain finance ABS.· Audited the semi-annual reports of 9 listed companies as part of continuing supervision obligations.

• 

  Deloitte

  Jan 2019 - Mar 2019

  Risk Advisory Intern

  · Provided compliance consulting services and designed internal control framework for sales department of an automobile company, assisted in developing dealer credit evaluation system and provided guidance on structuring of sales incentive programs.· Participated in the enhancement of existing vehicle, vessel, and purchase tax subsidy calculator by updating business-specific rebate calculations using Python and Excel.

• 

  Nielsen Marketing ROI

  Sept 2019 - Dec 2019

  Intern, Quantitative Analysis Department - Auto Vertical

  · Led a team of 3 interns to launch a brand perception project for Mercedes-Benz which involved analyzing 2000+ questionnaires worth of data with R and drafting a final report.· Developed case study using desk research and expert interviews to analyze Mercedes’ strategy of repositioning its brand from one that focused on comfort to one that exudes a sense of technological excellence.· Analyzed new energy automobile market in China through macro factor analysis and development of PEST model. 收起

• 

  滴滴

  Dec 2019 - Apr 2020

  Product Growth Intern

  · Tracked key indicators to provide support for the premier vehicle service’s city-fencing region scheduling strategy and optimized dynamic scheduling strategy using SQL and Python, resulting in a 10% quarter-on-quarter increase in customer satisfaction score.· Extracted and analyzed data for premier vehicle services in 53 cities to prepare daily briefing updates and also evaluate the effectiveness of business operations using Tableau. Helped Gross Merchandise Volume(GMV) increase 30%+ in March after impact of COVID-19.· Designed membership system and points exchange rules to promote the upgrading of ordinary users. 收起

• 

  NTUC Enterprise Co-operative Limited

  Nov 2020 - May 2021

  Data Science Intern
• 

  Kuaishou Technology

  Jun 2021 - Nov 2021

  Data Analyst Intern

  livestream e-commerce