Experience

Metrodata Tech Co., Ltd.

• China
• Information Technology & Services
• 1 - 100 Employee

• Data Analyst

  • Oct 2020 - Jan 2021

  Shanghai, China • Used the collaborative UI design tool “Figma” to modify the template of a platform for information collection of citizens of a street in the Pudong New Area of Shanghai. Adjusted its fields, data verification logic, and system jump logic based on the table used for the 7th National Census of China. • Assist software engineers in building a mini program (a plug-in) in WeChat for local social workers to record data based on templates. • Programmed in Python with Pandas and NumPy Libraries… Show more • Used the collaborative UI design tool “Figma” to modify the template of a platform for information collection of citizens of a street in the Pudong New Area of Shanghai. Adjusted its fields, data verification logic, and system jump logic based on the table used for the 7th National Census of China. • Assist software engineers in building a mini program (a plug-in) in WeChat for local social workers to record data based on templates. • Programmed in Python with Pandas and NumPy Libraries to do data cleaning of the CSV format citizen data gather table. The total number of population information handled was more than 300,000. • Participated in meetings with the first party aiming at understanding what information platforms were available and the necessary data required in each department to build an all-in-one information platform and realize the integration of the network and management. • Maintained databases and worked with developers to maintain consistency within data sets. Show less



PepsiCo

• United States
• Food and Beverage Services
• 700 & Above Employee

• Sales data processing summer intern

  • Jun 2019 - Sep 2019

  Shanghai, China • Collected sales and marketing data from SAP and RPM database. • Analyzed and presented data including sales growth rate, net profit growth rate, and dealer growth rate clearly through tables and charts in over 20 weekly and monthly reports, which helped sales managers to understand the latest sales situation easily and adjust sales plans accordingly. • Supported over 5 sales managers covering different districts to collect and present valuable data. • Built a model base in excel… Show more • Collected sales and marketing data from SAP and RPM database. • Analyzed and presented data including sales growth rate, net profit growth rate, and dealer growth rate clearly through tables and charts in over 20 weekly and monthly reports, which helped sales managers to understand the latest sales situation easily and adjust sales plans accordingly. • Supported over 5 sales managers covering different districts to collect and present valuable data. • Built a model base in excel which contains over 30 calculation models and formulas to analyze data. This increased data processing efficiency by nearly 50%. • Participated in the brainstorming held by the marketing department, topics including advice on the naming, taste, logo design and pricing for 6 new products targeting college students. Show less