Data Analyst

YAN YAN

RELOCATABLE ***.***@*******.***.*** 240-***-****

EDUCATION

University of Maryland, College Park, MD December 2019 Master of Science in Business Analytics

GPA: 3.97/4.0 Rank: 1/96

Graduate Teaching Assistant of Decision Analytics Course Beijing Jiaotong University, Beijing, China June 2018 Bachelor of Engineering in E-commerce

GPA: 3.80/4.3 Rank: 5/30

Vice President at Mathematica Modeling Association PROFESSIONAL EXPERIENCE

Customer Insights Consultant

Optoro, Washington, DC September 2019 – December 2019

• Provided actionable implementations to improve the business in general pricing strategy and business operations.

• Found factors leading customer churn in customer review between one-time and recurring customers with text analytics.

• Identified customer purchase patterns on categorical level, detected anomalies of Net Promoter Score in monthly trend. Online Marketing Analyst

Lubuto Library Partners, Washington, DC October 2019 – December 2019

• Brought website traffic increase by 310% and got 7 conversions from donors with a 3-week Google Ads campaign.

• Improved user experience by decreasing mobile users average loading time from 20 seconds to 4 seconds.

• Tracked and analyzed customer behavior with Google Analytics, worked in a team of 5 people to develop, implement, and execute marketing strategies; completed Google Search Advertising and Display Advertising certifications. Data Analyst

China Railway Container Transport Corp.,Ltd. September 2017 – March 2018

• Minimized repair fees by accurately identifying which containers are best suited to carry various cargo.

• Achieved 92% prediction accuracy with ordinal classification Deep learning model created in TensorFlow.

• Boosted data usability through extracted 20GB related data from 3TB data sources with SQL; preprocessed data with R; manipulated data and performed feature engineering with Python. PROJECTS

Identify Taxicab Problems in Washington DC Area March 2019 –April 2019 Deloitte Datathon Competition

• Awarded 3rd place in final by identifying several existing issues such as low supply of taxis in outer DC area.

• Categorized taxi ridership across 117 neighborhoods with geo json files in Python and visualized in Tableau to compare with bikeshare data in Washington DC area.

Exploratory and Predictive Analysis of 30-day Readmission February 2019 – May 2019

• Increased potential to reduce readmission rates and related fines while boosting patient satisfaction and operational efficiency by building a stacked model to predict patient readmission, improved accuracy from baseline by 2.5%.

• Listed profiles of returning patients based on exploratory data analysis; processed missing values in data with R. Database and Website Design for Houses and Apartment Around Campus August 2018 – December 2018

• Enhanced the ability of newly admitted students to find and compare campus housing by collecting, analyzing and visualizing housing data and building an interactive website with HTML and JavaScript.

• Mapped data structure from building ER mode; established database management system in Microsoft SQL server. TECHNICAL SKILLS

Python R Tableau SQL Statistics Modeling Data Mining Machine Learning Algorithms AWS Spark

Big Data HTML A/B Testing Spark Hadoop Google Analytics JavaScript Microsoft Office Suite C

Contact this candidate