Experience

PwC Shanghai Acceleration Center

• China
• IT Services and IT Consulting
• 300 - 400 Employee

• Business Intelligence Analyst

  • Dec 2020 - Present



Overseas Student Service Corp

• United States
• Consumer Services
• 1 - 100 Employee

• Data Analyst

  • Oct 2019 - Jul 2020

  • Visualized monthly trend of overall department profit using Tableau, analyzed users’ conversion rate and retention reasons.• Analyzed user’s behavioral data using SQL, completed the target customer group portrait based on purchase urgency. Built surgical promotion strategies for 3 different segments. Increased conversion rate by 14%.• Analyzed the renting and sale performance of real estate agents, optimized resource allocation with employee incentives and mentor/mentee pairing. The monthly department's profits increased by 10%.



Jiashu Data Consulting

• Data Analyst

  • May 2018 - Oct 2018

  • Designed and established data warehouses for new projects and completed the ETL process in a team of 4.• Generating KPIs, disassemble projects into tasks and providing solutions.• Used statistical techniques for hypothesis testing. 70% of the experiments designed showed significant results at a 95% significance level and 80% power.• Integrated data between SQL and Tableau, provided data visualizations and analysis reports. Presented data and conclusions to the team in order to improve strategies and operations.