John (Zheng QI)
Data Analyst
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for providing valuable insights.
Overview
5
5
years of professional experience
10
10
years of post-secondary education
5
5
Languages
Work History
Data Analyst
Hoyoverse
Shanghai, China
12.2020 - 09.2022
- Project: Genshin Impact, Honkai 3rd Impact.
- Established the data reporting infrastructure, including the selection of monitoring metrics and the automation of outputs using Python, SQL and Excel, to provide real time insights into the product, UA performance and business KPIs.
- Revealed high correlation between the behaviour of stop paying and user churn rate, shifted the target of user loss prevention model one step forward and enhanced the model performance by 20%.
- Conducted specialized analysis on operational topics including: Surgeoning regional MAU, ARPU inconsistent with estimation, Quantification of influence from competing products etc.
- Designed the data platforms (including metrics selection and visualization) for operational use.
- Collaborated with business-unit leaders from marketing, commercialization, server side, sdk, and game design to identify and prioritize problems.
Web Analyst
DXOMARK
Paris, France
01.2020 - 07.2022
- Responsible for web data collection, processing and analysis, tools such as Google Analytics, Meltwater and prevailing SEA platforms are daily used.
- Produce dashboards and reports and render key points to SVP and department directors.
- Monitor performance of the main website, social medias and online presses.
- Create and classify target online press list, get in touch with major ones for SEO cooperation.
Marketing Manager Intern
Singulart
Paris, France
05.2018 - 11.2018
- Successfully opened markets of Japan, mainland China and Taiwan
- Collaborated with team members to help expand marketing channels especially in East Asia.
- Maintained documentation, detailing assignments, in-progress work and completed project milestones.
- Performed market analysis and researched latest trends.
- Redesign sub-websites' functionalities according to local users' preferences (promotion banners, chatbots, etc.).
- Analyze ads/website performance in 26 global markets via Google analytics, Baidu statistics, Adalysis, etc.
- Competitive benchmarking via web scraping and similarweb.com.
Education
Master of Science - General Management
EM Lyon
Lyon, France 09.2017 - 02.2021
Master of Management - Economics and Management
Tohoku University
Sendai, Japan 10.2015 - 06.2017
Language Studies - Japanaese language and culture
JCL Foreign Language School
Kyoto, Japan 10.2014 - 07.2015
Exchange - Economics
University of California, Berkeley
Berkeley, USA 08.2013 - 06.2014
Bachelor of Science - Auditing
Nanjing University of Finance and Economics
Nanjing, China 09.2010 - 06.2014
Skills
Data analysis
Business needs analysis
SQL and Excel expertise
Data visualization
Python
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Data Analyst
Hoyoverse
12.2020 - 09.2022
Web Analyst
DXOMARK
01.2020 - 07.2022
Marketing Manager Intern
Singulart
05.2018 - 11.2018
Master of Science - General Management
EM Lyon
09.2017 - 02.2021
Master of Management - Economics and Management
Tohoku University
10.2015 - 06.2017
Language Studies - Japanaese language and culture
JCL Foreign Language School
10.2014 - 07.2015
Exchange - Economics
University of California, Berkeley
08.2013 - 06.2014
Bachelor of Science - Auditing
Nanjing University of Finance and Economics
09.2010 - 06.2014