Data Analyst Sales

Yang Chen

Sunnyvale, CA • 669-***-**** • **************@*****.***

• linkedin.com/in/yang-chen-641aa416b/ • Tableau Portfolio: public.tableau.com/profile/yang.chen2042#!/ Education

University of California San Diego San Diego, CA

Master of Science in Business Analytics 08/2018 – 09/2019 Shanghai University of International Business and Economics Shanghai, China Bachelor of Finance 09/2012 – 06/2016

Work Experience

Housecall Pro San Francisco, San Diego, CA

Data Scientist Intern (SaaS Start-up, Home Service Industry) 06/2019 – 11/2019

• Website Flow optimization (Data quality and Analysis): Conducted website data quality assurance, integrated data using SQL via Snowflake, built statistic analysis to inspect conversion contribution and removal effect of each page.

• Upsell features recommendation (Statistical Analysis): Conducted a correlation analysis on features and performed a feature usage prediction to discover feature recommendations and target cohorts.

• Marketing attributions Analysis (Analysis and Reporting): Extracted metrics using SQL via Snowflake, analyzed on metrics such as marketing spends, CPL, Enrollments, and built dashboards using Tableau.

• Churn Prediction (Predictive Modelling): Built churn model predicting churn probability over time using Neural Network (LSTM) via Keras, TensorFlow, visualized time to churn estimation via Tableau.

• LTV Analysis (Root Cause Analysis): Used SQL and Pandas(Python) to extract and analyze the metrics to conduct hypothesis based analysis to inspect trends of LTV via cohort analysis.

• Lead Scoring Experiment Analysis : Used SQL and Python to extract and analyze the metrics, comparing metrics before/after experiment and control/treatment groups during the experiment. Jam City Carlsbad, CA

Product Analyst Capstone project (Mobile Game Industry) 03/2019 – 06/2019

• Cohort Analysis: Aggregated, joined game data using Spark SQL, conducted cohort analysis to discover user patterns.

• Behavior Prediction: Built statistical models to predict win rate and booster usage patterns for level tune decisions.

• Data Visualization and Reporting: Built dashboard to update metrics (DAU, win-rate) and progression curve via Tableau. KPMG Shanghai, China

Consultant 10/2016 – 04/2018

• Data Analytics and Visualization (Marketing Optimization): Performed linear regression in R to analyze client’s sales data in Philippines area, built geographic visualization via Tableau, explored new opportunities worth $1M in sales.

• Supply Chain Optimization: Designed a linear optimization model using R lpsolve for logistics cost optimization and material planning strategy, achieved $50,000 in cost savings.

• Statistical Analysis (Game Sales Audit): Performed regression analysis on in-game currency charging and consumption log, and analyzed charging pattern of heavy users to detect fraudulent sales or revenue. General Electric Shanghai, China

Data Analyst Intern (GE Healthcare) 07/2015 – 01/2016

• Data Visualization and Reporting: Performed exploratory analysis using SQL on machine log data, report key metrics

(error, utilization rate, procedure) to provide insights on asset usage pattern and predicted customer needs. Siemens

Data Analyst Intern 03/2015 – 07/2015

• ETL and Reporting: Extracted 300M data of internal billing report from online portal to SQL server and generated reports. Projects

Driver Churn Analysis for ride-sharing company 02/2019 – 02/2019

• Predictive Modeling: Define driver churn, synthesize features, and predict churn using Random Forest model via Python.

• Factor Analysis: Uncovered 2-side marketplace insights from factor importance, designed hypothesizes for retention, estimated opportunity size, customer life value, projected to churn decrease by 8%.

• Experiment Design: Designed an A/B testing to test the new strategy in order to decrease driver churn. Customer Analysis: Customer Response Analysis for Intuit - QuickBooks 01/2019 – 02/2019

• Predictive Modeling: Predicted email offer response using statistical models (Logistic regression, Neural Network, XGBoost, ensemble models) via R, applied techniques such as cross validation, grid search.

• Data and Business Analytics: Evaluated model performance by Lift & gain and profit analysis via R, achieved 15% engagement increase in the test data.

Skills and Courseworks

• Python, R

• SQL (MySQL, PostgreSQL, Snowflake)

• Experiment Design

• Spark(pyspark)

• Machine Learning, NLP, Recommendation System

• Linear Algebra, Calculus, Probability, Statistics

• Tableau

Contact this candidate