SQL, Tableau, Machine Learning, Python, SQL, R, A/B Testing

Jingyan Xu

Seattle, WA 857-***-**** **.******@************.*** linkedin.com/in/jingyanxu

Summary of Qualification

• MS of Analytics with 4 years’ experience in analytics and modeling, business intelligence, and go to market strategy

• Core Skillsets:

• Database: MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Hive

• Programming: Python, SQL, R, Shell, C, C++

• Data Visualization: Tableau, Excel (Vlookup, Pivot Table), PowerPoint, MS Project

• Big Data Engineering: Hadoop, Spark

• Machine Learning

• Supervised Learning: Linear Regression, Logistic Regression, Decision Tree, Random Forest

• Unsupervised Learning: KNN, K-means Clustering, Principle Component Analysis

• Cross Validation, Regularization (L1, L2)

• Hypothesis Testing & Experiment Design: A/B Testing Working Experience

Cloudflare Apr 2020 - Jul 2020

Data Analyst Intern San Francisco, US

• Used Python and SQL to process and analyze data, provided the team with quantitative insights on marketing campaign performance of different campaign types, including estimated number of marketing touches needed to acquire new customers and the average period of sales cycle throughout marketing conversion funnel

• Built a real-time Tableau dashboard for operational monitoring and analytics on streaming event data from Kafka, which requires complex SQL, including filtering, aggregation, joins, and window function, contributed to the org’s 7% revenue growth Forkaia Jan 2020 – March 2020

Data Scientist Intern Irvine, US

• Conducted multiple A/B tests to determine the optimal channel, frequency, and cost spent on social media marketing, provided operational strategies for our clients - small app developers, improved CTR by 10%

• Automated analysis and authorized pipelines via SQL and Python based ETL framework, built and optimized scalable data products to provide timely insights to drive better product metrics and meaningful monetization experiences for our clients Lear Inc. Aug 2015 - Mar 2019

Sales Analyst Shanghai, China

• Applied data-driven methods researching and analyzing market trends, product roadmaps, manufacturing footprint, industry status, competitors, client demand, and proposed strategies for acquiring new projects. Analyzed cost of sales, operating income, gross margin, ROI along with other financial indicators to deliver quotes to OEMs

• Led a team of 12 partners, provided intent customers with price quotes, contributed a total of $8 million sales revenue growth in 2018 fiscal year

Projects:

National Diabetes Analysis and Predicting Jul 2019 - Sep 2019

• Leveraged ML techniques to generate accurate, reliable and high-quality data sourced from National Diabetes Datasets. Discovered the main causes of diabetes using data exploration and linear regression, achieving 98% classification accuracy Sustainable Development Goal of Children Oct 2019 -Dec 2019

• Created Tableau dashboards to visualize UNICEF data, contextualized and analyzed mortality rate of children under five in Bangladesh, Japan, and Korea over time, presented the causes of death for children to audiences EDUCATION

• Master of Science in Analytics Northeastern University Boston 2019.04 -2020.12

• Bachelor of Science in Electrical Engineering and Automation East China University of Science and Technology Shanghai 2011.09 - 2015.06

Contact this candidate