Experience

Capital Logistics

• Australia
• Transportation, Logistics, Supply Chain and Storage
• 1 - 100 Employee

• Business Analyst

  • Jun 2021 - Present



New Oriental Education & Technology Group

• China
• Education Administration Programs
• 700 & Above Employee

• Junior Data Analyst(Remote Work)

  • Jul 2020 - Jun 2021

  - Complete the delivery of regular reports with charts or text descriptions by Tableau, R, etc. - Apply SQL, Python, etc. to analyze and present insights & finding, helping define the right approach in the promotions and service division - Use Hadoop/Spark system to regularly sort out the temporary data requirements, and to optimize the data content with high demand frequency into regular reports - Assist senior data analyst with writing regular review analysis reports and temporary thematic analysis reports - Put forward suggestions on data system optimization or special report research - Responsible for data training sessions - Support the other departments with data analysis work



ByteDance

• China
• Software Development
• 700 & Above Employee

• Data Analyst Assistant

  • Dec 2019 - Feb 2020

  - Data analysis of advertising businesses (TikTok/Toutiao/Watermelon Video) of ByteDance by using SQL, Excel, etc. - Implement A/B experiment analysis in business, evaluate the optimization effects and analyze the variation of core indicators - Cooperate with product/research department, promote the implementation of optimization plans - Data analysis of advertising businesses (TikTok/Toutiao/Watermelon Video) of ByteDance by using SQL, Excel, etc. - Implement A/B experiment analysis in business, evaluate the optimization effects and analyze the variation of core indicators - Cooperate with product/research department, promote the implementation of optimization plans



BlueFocus

• China
• Advertising Services
• 300 - 400 Employee

• Project Manager

  • May 2017 - Jul 2018

  - Lead and manage a team to deliver customed advertisement plans to domestic companies (e.g., AIR CHINA, OPPO) - Execute the whole process of advertising work, including the contract process before advertising, communication with customers during advertising, and expense settlement in the end - Prepare periodical summaries, such as monthly summaries, advertisement product update training, quarterly summaries - Participated in bidding projects, including planning the marketing project, arranging related qualifications, confirming the budget - A wide range of Data Analytical tasks via VBA, Microsoft Excel, etc. - Complete the project settlements and contract renewal work for clients - Conduct MS Excel training & Data Visualization sessions for local and other departments - Assisting other departments & clients with various data & report tasks



GroupM

• United States
• Advertising Services
• 700 & Above Employee

• Project Supervisor

  • Nov 2015 - May 2017

  - Build Python framework to analyse advertising & user data and deliver customer advertisement insights - Prepare and delivery of HUAWEI advertising project plan and periodical forecast information to HUAWEI head office - Analysis of HUAWEI advertising performance at operating sector and consolidated level - Support Project Team with ongoing project budget analysis, reporting, forecasting, budgeting, change management - Specific technical responsibilities related to budget analysis, product & marketing research - Huawei P10 promotion project won the Tiger Roar Award - integrated marketing category - Huawei “Enjoy Young” Campus Marketing Case won the Best Mobile Integrated Marketing Case Award