YZ

Yichi Zhang

Strategy & Performance Analysis Intern II · AARP

College Park, MD

Work Experience

Strategy & Performance Analysis Intern II

AARP

2018 – Present

Lead membership analysis team prediction projects using machine learning models; Conduct data ETL and visualization reports for Social Engagement Community (SEC), Advocacy, and Multicultural teams • Collected and transformed raw data (230K rows) from state branch into national office's database and conducted data preprocess using Python NumPy and Pandas packages, including accuracy verification, imputing missing value, text format standardization • Extracted customer email information (15,000,000 rows) for analytics team from Redshift using SAS queries • Predicted membership acquisition response rate with direct mailing channel for 3Q18 - FY19 using Time Series model for analyst team to plan marketing acquisition budget • Predicted events return rates with Linear Discriminant Regression and Random Forest using Python scikit-learn based on events' (100,000 events, 30 features) historical data and achieved 86.4% accuracy, and drafted events promotion strategy reports for marketing team • Raised relevancy score of results returned from company internal search by 62% by creating guidance of step-by-step tagging and keyword search lists

Data Scientist Associate

CITIC Co. Ltd

2016 – 2017

• Trained 1,000 local store managers and associates in 220 stores in China for data logging to improve data quality • Cleaned sales and transaction data using SQL queries for over 600,000 raw data collected from off-line and on-line channel • Implemented a "customer shopping footprint" dashboard based on over 450,000 customers' profile and purchase behavior with Navicat Premium (SQL database), Tableau, HTML5 as the prototype for engineering team • Drafted reports for analysis of typical PERSONA for off-line customers and presented to stakeholders

Operation Analyst Intern

ELLASSAY Fashion Co. Ltd

2014 – 2014

• Collected sales performance data of 239,000 SKUs including current sales, stock turnover, and customer satisfaction • Optimized the inventory distribution plan based the data above to maximize total revenue • Summarized the Fashion Trend for 2015 F/W by collecting statistics of the clothes' materials, colors, patterns, silhouettes and themes and reported to the director of design department

Education

Bachelor of Science in Apparel Merchandising

Indiana University, College of Arts & Sciences

2016

Bachelor of Science in Apparel Merchandising

Master of Science in Business Analytics

University of Maryland, R. H. Smith School of Business

2018

Master of Science in Business Analytics