Python, SQL, Excel, Stats

Jack (Changqing) Ye

San Francisco, CA 415-***-**** ****@*******.*** linkedin.com/in/jack-ye

P ROFILE

M.S. in Business Analytics student with 2 years professional experience in data analytics. Seeking Analytics positions to utilize my skills to help improve products and support business decisions. Specialties: Statistical Exploration, Business Decisions Supporting, Metrics Building and Evaluation Technologies: SQL, Python, R, Tableau, Stata, MongoDB, Spark Certifications: AWS Certified Cloud Practitioner, Tableau Desktop Specialist E DUCATION

University of California, Davis San Francisco, CA

M.S. in Business Analytics (GPA: 3.68) June 2020

Highlighted Coursework: Data Management, Data Visualization, Machine Learning, Advanced Statistics (A+), Data Design & Representation, Big Data Analytics, Organizational Issues in Implementing Analytics. Shanghai University of Finance and Economics Shanghai, China B.A. in Quantitative Economics June 2019

P ROFESSIONAL E XPERIENCE

Sumo Logic -- Practicum Project Redwood City, CA

Data Analyst Oct 2019 – Jun 2020

• Designed an ETL pipeline to combine its petabyte-scale platform’s usage data and CRM data for 2,000+ customers

• Built logistic regression and random forest models by Python to identify 7 metrics that indicate churn or expansion

• Communicated with people from 3 different functions and understood their needs

• Created visualizations by Tableau and told engaging stories with actionable recommendations to executives, which were adopted by them and forwarded to 60 sales managers China UnionPay Data Shanghai, China

Data Analyst Intern Jan 2018 - May 2018

• Extracted data from the database by SQL and analyzed credit card sales for over 30 mid-size banks

• Automated the data visualization process using Macros and VBA in Excel, cutting the time by 60%

• Scraped 40,000+ stores information in 20+ cities from a review website in the Smart Business District project J. D. Power Shanghai, China

Business Analyst Intern Aug 2017 - Oct 2017

• Identified key metrics to be improved for auto stores’ service out of 100+ metrics in the customer survey database

• Helped consultants propose advise to clients, increasing their Customers Service Index by 3% on average P ROJECTS

SAP Marketing Mailing Predictive Analytics May 2020

• Built a logistic regression model by Pyspark to predict which customers would respond to the marketing mailing

• Improved the response rate from 5% to 34% and cut the marketing mailing cost by 76% Venmo Social Network Analysis May 2020

• Used PySpark on Databricks to calculate social network metrics for 3M+ users at each lifetime point

• Built a linear regression model to predict each user’s number of transactions after using Venmo for a year Yelp Review NLP Analysis for Chipotle Mar 2020

• Applied word clouds, topic modeling, and sentiment analysis to analyze Chipotle’s 9,000+ reviews by Python

• Published the article on Towards Data Science, which received 146 claps and was selected in its April Edition

Contact this candidate