Cornell University
- 2018-2020
- Master of Engineering in Operations Research and Information Engineering concentrating in Data Analytics
Lastest internship: John Hancock Life Insurance Company
- Published KPI dashboards tracker by Tableau to keep track of the performance of digital campaigns; performed A/B testing on conversion rate and other metrics analysis and wrote analysis reports to 200 senior managers.
- Established data automation pipelines/workflows for databases; Created brokerage distribution mapping database by SQL, enhanced sales efficiency and impact 200,000 producers worldwide.
- Looked into drivers of positive and negative performance of the insurance sales through time series modelling; Reduced time needed to prepare the report by 25%.
- Built a text analytics/topic modeling capability for customer feedback Data; generated word clouds and topic models for each of the data sets that help analyze large text data sets by using NLP models with Python.
- Built data automation pipelines/workflows for brokerage hierarchy mapping. Saved 30% of the time.
Equifax Project: Credit risk evaluation machine learning
- Used SQL to extract and transform data; constructed customer clustering using K-means model with Dynamic Time Wrapping (DTW) algorithm, leading an initiative which impacted dynamic clustering field.
- Conducted feature selection to select top 3 most relevant variables among 1000 features from 15 million customer dataset; performed Wavelet Transformation to turn multiple time-series variables into static ones.
- Adopted machine learning models to separate good payment behavior from bad; improved accuracy by 10% and provided Equifax with a more accurate credit evaluation model to better safeguard funds from investors.
- Held weekly meetings with directors to discuss the progress; gave a final presentation in front of all managers.
Statistics Internship: National Statistical Bereau
- Integrated and cleaned the 10-year agricultural commercial data according to different standards; visualized data with Excel Pivot Table and Tableau.
- Participated in analyzing dynamic data and composited indicator; improved agricultural economics profit forecasting through machine learning methods: Logistic Regression, Multiple Linear Regression and Decision Tree. Improved the accuracy rate to 95.4%.
