Ziqian Zhang

Data Product Analyst at Code Willing
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
New York, New York, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Data Product Analyst
      • Mar 2023 - Present

      Data Science Team: Migrate Terabytes level financial data from traditional RDBMS to DataLake Data Science Team: Migrate Terabytes level financial data from traditional RDBMS to DataLake

    • United States
    • Higher Education
    • 700 & Above Employee
    • Data Analyst
      • Oct 2021 - Dec 2022

      • Predicted student retention using XGBoost algorithm on 10-year cohort data from different departments, and provided watch lists for college stakeholders for early interventions, which enhanced student retention rate by 2.8%. • Addressed imbalanced target variable problems with oversampling method, and utilized Bayesian Optimization approach (HyperOpt) to improve model performance by 30% F1 score on average. • Designed a semi-automated data processing and modeling package (Python, Git) to streamline coding tasks for team members. • Developed and migrated dashboards from local Excel Pivot Table to Tableau Online server, which automated the process of monitoring students’ weekly learning status. Show less

    • United States
    • Computer Games
    • 1 - 100 Employee
    • Data Scientist (Capstone)
      • Jan 2022 - May 2022

      • Coordinated with a group of 5 as technical lead, initiated and managed data processing and modeling pipeline on Google Colab. • Built predictive models to forecast player satisfactions based on 70+ in-game metrics for Knockout City video game. • Applied Logistic Regression model (Statsmodels) on different player segmentations to understand drivers of player satisfactions. • Generated dynamic dashboards (Tableau) and business reports based on subgroup analysis towards 300,000+ in-game matches. Show less

    • China
    • Software Development
    • 700 & Above Employee
    • Data Analyst
      • Nov 2020 - Jan 2021

      • Established a user funnel model for WeChat Work Microdocument product, and monitored key metrics such as retention rate and conversion rate to evaluate A/B test results. • Analyzed DAU and usage frequency differences between drive users and doc users, and visualized results at company level and industry level (Matplotlib, Seaborn). • Implemented Word2Vec and K-means algorithm to extract user preference topic by clustering monthly user data. • Established a user funnel model for WeChat Work Microdocument product, and monitored key metrics such as retention rate and conversion rate to evaluate A/B test results. • Analyzed DAU and usage frequency differences between drive users and doc users, and visualized results at company level and industry level (Matplotlib, Seaborn). • Implemented Word2Vec and K-means algorithm to extract user preference topic by clustering monthly user data.

Education

  • Rensselaer Polytechnic Institute
    Master's degree, Business Analytics
    2021 - 2022
  • Hefei University of Technology
    Bachelor of Engineering - BE, Information Management and Information System
    2017 - 2021

Community

You need to have a working account to view this content. Click here to join now