Yichi Zhang
Strategy & Performance Analysis Intern II · AARP
College Park, MDWork Experience
Strategy & Performance Analysis Intern II
AARP2018 – 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. Ltd2016 – 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. Ltd2014 – 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 & Sciences2016
Bachelor of Science in Apparel Merchandising
Master of Science in Business Analytics
University of Maryland, R. H. Smith School of Business2018
Master of Science in Business Analytics