Overview
Work History
Skills
Languages
Timeline
Generic

Qianzhi (Tina) Bao

Los Angeles

Overview

5
5
years of professional experience

Work History

Economy Analyst Volunteer

Easley-Dunn Productions
07.2023 - Current
  • Enhanced in-game UI design using Figma, collaborating with teams to create a more user-friendly interface and engaging player experience, resulting in a 15% increase in user engagement and a 10% improvement in overall player satisfaction.
  • Conducted detailed data analysis of hero stats, creating comprehensive data visualizations using Excel, which informed game balance adjustments, contributing to overall improvements in gameplay quality.
  • Developed in-game economy model encompassing various metrics, such as tier upgrade pattern, player spending patterns and virtual currency balance, which provides valuable insights into player behavior and spending habits.

Data Analyst Intern

Harb Data
06.2021 - 12.2021
  • Tracked and conducted clickstream analysis on website user visits, routing, and staying behaviors for a 500,000 user base using pivot tables and conditional formatting in Excel to identify primary audience groups, enabling targeted marketing.
  • Analyzed live shopping sales performance data and identified high-impact engagement metrics based on Gross Merchandise Value (GMV) per million, resulting in a remarkable 10% increase in sales.
  • Conducted end-to-end strategy and implemented A/B testing to enhance advertising campaign performance, achieving data-driven insights for improved Return on Investment (ROI).

Algorithm Intern

Alibaba Cainiao Group
10.2020 - 12.2020
  • Performed data cleaning on a dataset containing consumer and transactional information for a vehicle maintenance store, utilizing Python pandas; designed visualization reports using Python plotly/seaborn/matplotlib and presented insights.
  • Transformed raw data for features engineering in preparation for supervised machine learning models, improving the accuracy of 8%.
  • Predicted vehicle mileage using XGBoost model with a 86% accuracy, which improved by 20% compared to the baseline model; monitored model performance and tuned parameters for optimization.
  • Delivered analytical reports showcasing model performance, metric insights, and business recommendations using matplotlib.

Data Analyst Intern

China Telecom
06.2020 - 08.2020
  • Provided assistance by ERP system with stakeholders including data and marketing promotion team, as well as seeking out potential end-users.
  • Managed customer database utilizing Hadoop for distributed storage collaborating closely with the IT department to ensure optimal data handling and accessibility.
  • Analyzed user information on plans, developed segments by groups and purchase behavior(heavy data users/budget-conscious users/social media users), and visualized segment findings using Tableau in preparation for precision marketing in Q4 2020.

Skills

  • Analytical thinking
  • MS Excel
  • SQL
  • Data cleaning
  • SQL databases
  • Analytical problem solving
  • Statistical analysis
  • Tableau
  • R programming
  • Data validation
  • Database management
  • Machine learning

Languages

English
Full Professional

Timeline

Economy Analyst Volunteer

Easley-Dunn Productions
07.2023 - Current

Data Analyst Intern

Harb Data
06.2021 - 12.2021

Algorithm Intern

Alibaba Cainiao Group
10.2020 - 12.2020

Data Analyst Intern

China Telecom
06.2020 - 08.2020

Similar Profiles

CREATE PROFILE
Qianzhi (Tina) Bao