YI ZHANG

Experience

• 

  Bnbtrip 趣住啊

  Jun 2016 - Aug 2016

  Marketing Intern

  1. Interpreted and synthesized data obtained to locate potential customers2. Communicated with local hosts to help improve product diversity and customer satisfaction3. Translated house information to make product visualization better

• 

  Randstad

  Sept 2016 - Jan 2017

  Financial Services Intern

  1. Helped in composing accounting vouchers with supporting materials2. Updated company’s financial system by inputting related commercial invoices data and helped with Excel table classification

• 

  Nielsen

  Sept 2017 - Dec 2017

  Market Data Analyst

  1. Conducted monthly error-check and template revision for marketing data, and identified possible reasons causing data deviation2. Mastered Nielson Answers Builder Module for screening and analyzing data e.g. value sales, value shares3. Dealt with daily requests for clients, realized data visualization via graphics to make user-friendly results and practiced data interpretation in business reality

• 

  Niagara Bottling

  Jan 2019 - May 2019

  Data Analyst Practicum

  1. Used SQL to fetch data with millions of observations and 50 variables2. Conducted data cleaning and feature engineering of the large dataset in python3. Conducted exploratory data analysis and realized data visualization in Tableau4. Applied regression, decision tree and XGBoost models to predict missed pickups and late deliveries in python

• 

  Ctrip.com

  Aug 2019 - Sept 2020

  Data Analyst

  Daily Work:1. Analyze data for hotels with TB’s database by SQL, establish daily data monitoring and reporting system, find the cause of fluctuation and solve the problem2. For hotel incentive mall, establish a monitoring system for indicators such as activity visit rate and registration rate, visualize the result by BI tools and cooperate with operation team to design plans3. Test incentive activities by A/B test, evaluate incentive effect by hypothesis testing, maximize ROI4. Automate application, review and reward process for hotel incentive programs to increase efficiency Fake Hotel Project: 1. Intend to recognize fake hotels to reduce huge amounts of cost2. Cooperate with risk control, finance, operation teams to explore data with different dimensions, conduct data mining, summarize the feature of fake hotels and finally sort out 50 important variables 3. Use python to apply machine learning methods (decision tree, k-nearest neighbor, XGBoost) to predict fake hotels and reach an accuracy of 87%4. Apply the model to all hotels in inventory, predict, check and close fake hotels to avoid costOverseas Five Star Hotel Coverage Project: 1. Overseas five star hotels need to be standardized due to different criteria2. Use web crawler to consider star information from each OTA, sort out five star hotels on the market3. Apply model (decision tree) to recognize five star hotels, cooperate with operation team to check hotel stars and conclude with a high-quality hotel list for business team to explore 4. Monitor overseas five-star hotels’ availability (increase 10% compared with beginning) Show less

• 

  天翼电子商务有限公司

  Nov 2020 - Apr 2021

  Data Analyst

  1. For Chine Telecom 5G Mini-Program, participate in the design of data collection process, establish data monitoring and reporting system, analyze user behavior and find methods for growth2. Analyze the cost efficiency of marketing activities to improve ROI3. Participate in the design of project plan together with product and operation team, evaluate the effect, find issues from data perspective and promote improving strategies to increase conversion rate

• 

  Trip.com

  May 2021 - now

  数据分析师