Harold Zhou

Experience

• 

  China Merchants Bank

  Jul 2021 - Sept 2021

  Data Analyst

  • Data Preprocessing: Used SQL to extracted and cleaned 30k sales data collected monthly by online sales platform using outlier detection and missing data.• Build Evaluation Model: Used PCA to downscale the sales metrics to identify the five sales products that most impact sales performance. Provided sales strategies to the marketing department based on factor loadings. Used R to build a fully automated sales evaluation system to improve sales performance by 15% in the following month.• Business Performance Analysis: Participated in producing monthly, quarterly, and semi-annual business performance reports using Excel. Visualized 100+ outputs and 10+ dashboards using Tableau, analyzed gaps in business performance with competing companies and succeeded in supporting sales department performance growth. Improved next month's performance by 5% and 8% respectively. Show less

• 

  Nielsen

  Oct 2021 - Dec 2021

  Data Analyst

  • Market Survey Data Analysis: Developed evaluation metrics and model for market survey projects. Cleaned and analyzed tens of thousands of market survey data using SQL and Excel. Visualized 30+ dashboards using Tableau. Used before and after test to summarize the brand performance. Used t-test in Python for advertising effect evaluation. Produced 10+ analysis reports to help Party A improve sales performance.• Industry Research: Collected financial data and sales channel information of 20+ target companies, analyzed the companies’ financial performance by annual report and third-party research reports. Summarized their marketing methods, located target customers, produced 5+ reports to support Party A’s market strategy.• Interview Design: Designed interview framework and contents based on required data, classify evaluating metrics, produced 20+ research reports to support follow-up analysis. Show less

• 

  EY

  Jun 2022 - Jul 2023

  Cybersecurity Data Consultant

  • Compliance Risk Assessment Project: As a core member of the project, provided due diligence services to a large multinational pharmaceutical company on its domestic terminal retailers. Responsible for information query, quantification of indicators, data security analysis and risk assessment. Based on domestic and international security-related laws, regulations and security standard framework, firstly identified potential risks based on the retailer's credit records, actual operation conditions and data security management capability, and then quantified their risk level, produced more than 50 investigation reports, which created a value of more than 100,000 CNY for the company.• National Cybersecurity Insight Consulting Project: As a core member, we provided insight consulting services on cybersecurity and privacy protection in target countries for an international ICT giant. Responsible for the insight work on top-level strategies and policies, institutional mechanisms, legislation and regulatory requirements. Produced four complete insight reports to assisted the person in charge of cybersecurity and privacy compliance management in key countries to carry out more efficiently, identified key communication contents such as regulators, industry organizations, etc., gained insights into the cybersecurity and privacy protection profiles of the key countries.• Data cross-border security assessment consulting project: As a core member of the project, responsible for sorting out the company's data cross-border business scenarios and related systems, evaluating the risk of data security protection capability, internal management system and legal documents, identifying the risks and providing rectification opinions. The areas include data classification and grading, data leakage prevention, and emergency incident handling, etc. Helped two international enterprises succeed in data cross-border declaration. Show less

• 

  Capital One

  Sept 2024 - now

  Senior Business Analyst