Jiayi

Jiayi

Data Analyst
United States of America

About Me

Data analyst with experience in SQL, R, Python, Tableau, and statistical analysis. Holds a Master of Science in Business Analytics from Carnegie Mellon University and a Bachelor of Arts in Applied Statistics (Data Scienc…

Experience

Data Analyst

ByteDance, Shanghai, China

<p>Analyzed large sets of data in pivot tables to forecast daily sales targets for TikTok campaigns.<br>
Extracted real-time data using SQL and analyzed 20+ acquisition, activation, and app usage metrics to track sales performance.<br>
Continuously ensured the satisfaction of ROI and GMV targets.<br>
Ensured dashboard accuracy.<br>
Worked with IT to address data discrepancies and manage data access control.<br>
Analyzed low Product Detail Page (PDP) conversion rate using Hierarchical Regression and successfully identified two issues: high delivery fees and poor PDP design.<br>
Adjusted strategies to boost GMV by 15%.<br>
Built dashboards with Tableau and collaborated with cross-functional teams to conduct post-campaign recaps and presentations.<br>
Attracted 7000+ new users to the channel within 2 months.</p>

Equity Analyst

Sick Economics, Charlottesville, VA

<p>Analyzed and visualized data based on 8 financial metrics, including debt-to-equity (D/E) ratio and price-to-earnings (P/E) ratio, to examine potential dividend growth for S&P 500 stocks.<br>
Identified top and bottom 10.<br>
Conducted research and analysis of past performance, stated business strategies, and forecasts for profitability for 3 market leading companies.<br>
Authored 8 articles on the company’s website.<br>
Achieved a 23% increase in pageviews.</p>

Operations Analyst

Jiamei Dental, Beijing, China

<p>Extracted 10+ metrics including GDP, clinic density, and patient visit.<br>
Created heatmaps using R to dynamically visualize the data.<br>
Performed preliminary screening to effectively narrow the target city list by 50%.<br>
Performed presentations with clear graphs and helped make timely business decisions.</p>

Skills

Python SQL Database Tableau SQL Tidyverse ggplot2 dplyr stringr lubridate MS Office SAS Stata MongoDB AWS Power BI Excel Data Analysis KPI Tracking Data Quality Root Cause Analysis Dashboard Reporting Collaboration Financial Analysis Market Research Business Strategy Data Reporting Data Visualization Communication Statistical Analysis Predictive Analysis Model Improvement Factor Analysis Machine Learning Regression Analysis Hierarchical Regression Latent Dirichlet Allocation Euclidean Distance Exploratory Factor Analysis Linear Regression Regression Trees Support Vector Regression Ensemble Modeling
Report this Profile?