
Work Experience
Business Analyst II - Buyer Abuse Prevention, Data Science Team
AMAZON2021 – Present
• Designed reusable analytical framework using Python to conduct hypothesis testing on investigators performance metrics and identified the best hiring methods at different regions, streamlining recruitment process and saving recruitment time by 50%. • Created weekly business report pipeline. Leveragged dimension tables to create fact tables using SQL and ETL tools, defined metrics funnel and backfilled data, launching and maintaining reports of 4 new programs. • Created QuickSight dashboards to enable self-serve deep dive analysis includes granularity metrics, trends analysis, anomaly detection, outlier detection and key metrics ranking, reducing the need of ad-hoc requests and improving analysis efficiency. • Developed operational mechanisms to manage metrics goals and track dashboards progress to get alignment between stakeholders.
Data Scientist - Service Quality, Data Science Team
RTS2020 – 2020
• Scoped down high-level business problems, identified and collected internal and external data, designed an analytical framework. • Defined quality metrics at different levels, and built dashboards using Tableau to visualize 5 years' accident and drivers behavior data, finding behavioral and accident trends by time series decomposition, resulting in decreasing the accident by 18%. • Conducted causal analysis by features engineering and logistic regression, identified the pattern between the driver behaviors and the accident rate, initiating business strategies and improving the internal management efficiency.
Data Analyst Intern - Customer Advocacy, Data Analytics Team
DEXCOM2020 – 2020
• Defined and refined business metrics to measure business impact, queried metrics using advanced SQL and python. • Built the quality assurance dashboard by Tableau, generating periodic trending reports, improving the efficiency of management. • Conducted an ad-hoc root causes analysis, found the causation for the surge in complaints volume, solved the crisis in time and minimized negative impact. Initiated business strategies, reducing complaints volume by 15% and preventing potential risks. • Developed ETL pipeline using Python to automate the uploading process for 10GB historical data, reducing 25% redundant data. • Designed and developed a web-based search engine using, Bootstrap, HTML, CSS and JavaScript, allowing non-technical employees access and search for data files from the Mysql database easily and securely, reducing the search time by 90%.
Data Science Consultant - Data Management Team
SODUS BAY JUNIOR SAILING ASSOCIATION2019 – 2020
• Created ER diagram and the relational schema to organize 20000+ transactional data from 10 tables related to 3 years' operations. • Designed and generated the Mysql database, consolidating data maintenance and slashing data retrieve time by 40%.
Business Analyst Intern- Retail Analytics Team
NIELSEN2019 – 2019
Designed and implemented A/B testing to evaluate different versions of notification wording, concluded that notification with a shorter wording significantly improved the click-through rate by 5%, providing strategies to the product manager. • Sized potential opportunities of 3 marketing campaigns using historical data, delivering analysis results to product manager. • Applied PCA & K-MEANS to do marketing segmentation, drew customer personas and targeted customers with offers and incentives personalized to their demand using the STP marketing model. Improved monthly margin growth by 18% in 3 months.
Education
Master of Science
UNIVERSITY OF ROCHESTERMaster of Science