Shirley Deng
Los Angeles,CA
Overview
3
3
years of professional experience
Work History
Data Analyst | Practicum Project
Engage3
09.2022 - 06.2023
- Led a team of 5 members as the project manager, responsible for project timeline management and task delegation
- Developed and implemented complex queries to extract, transform, and load dataset of over 26,000 records within Snowflake
- Performed data preparation using Python to eliminate insignificant variables and handle duplicate and missing values
- Collaborated with cross-functional team to understand data requirements and deliver tailored solutions using SQL queries
- Built a simple Linear Regression model and employed cross-validation to check over-fitting
- Employed SMOTE for data augmentation and increase the model performance rate by 40%
- Utilized Exploratory Data Analysis techniques to visualize feature distributions
- Developed a multi-criterion scoring algorithm to produce a ranked list of predictions categorization
- Increased the company's customer retention rate by an estimation of 18.3% as direct outcome of the project.
Business Analyst Intern
ByteDance
05.2021 - 07.2021
- Developed predictive models using Python to anticipate user interactions with short videos
- Implemented strategies and enhanced user engagement for informed content recommendations
- Employed visualization to detect outliers and establish data thresholds for each feature to remove outliers and address missing values
- Utilized data analysis techniques to evaluate feature correlations and decrease the multicollinearity issues by 47.5%
- Leveraged regression models to predict user behaviors based on video quality features and user engagement metrics
- Categorized video qualities, enhancing the ability to optimize content delivery strategies and increase user satisfaction rate by an estimate of 24.7%
- Led an A/B test to compare two user interface icons and boosted user engagement rate by an estimate of 5.6%
- Conducted statistical analysis (Paired T-test) to determine the icon variation with a 13.04% increase in click-through rate.
Business Analyst Intern
Tencent
07.2020 - 09.2020
- Collaborated with Game Strategy Team to formulate activity strategies
- Applied data exploration using R on history activities logs with corresponding user behaviors data
- Conducted web scraping using Python (Beautiful Soup) to extract game update events and created a data set over 2000 data
- Built logistic regression model to assess the influence of activities on live data
- Made data-driven decisions and increase Daily Active User count by an estimate of 5.6%
Education
Bachelor of Science - Managerial Economcis
University of California, Davis
06.2022
Master of Science - Business Analytics
University of California - Davis
06.2023
Timeline
Data Analyst | Practicum Project
Engage3
09.2022 - 06.2023
Business Analyst Intern
ByteDance
05.2021 - 07.2021
Business Analyst Intern
Tencent
07.2020 - 09.2020
Bachelor of Science - Managerial Economcis
University of California, Davis
Master of Science - Business Analytics
University of California - Davis