Client: leading national healthcare insurer - Long Covid Research and Predictive Model | Python, R• Led a team of 5 in collaborative problem-solving and agile management• Identified 10+ key demographic characteristics and 14 diagnosis features from original 1.42M claim data and member data to analyze the likelihood of random COVID-19 patients developing Long Covid by conducting data cleansing, feature engineering, and exploratory data analysis • Improved prediction recall by 9% by reweighting target variable, applying multiple algorithms (Logistic Regression, Random Forest and Light GBM), and algorithm tuning• Pioneered a novel lead method to handle racial bias using feature selection, leading to a total 34% improvement of racial balance for minority in decile level

Client: leading education company - Test Score Disparity Analysis | Python, SQL, R, Tableau• Identified patterns of testing performance disparity in the test marketplace and its potential drivers, and visualized the disparity in state level in Tableau to develop actionable steps to help achieve higher persistence rates• Quantified the casual impact of test resources on regional test scores using regression analysis, providing particular recommendations for test services of individual states to improve their candidates’ performance• Built a 95% accuracy predictive model using user data and ACS data to predict test performance outcomes to prioritize test resources effectively for different potential groups in candidate levelClient: leading US-based airline - Customer Segmentation and Insight Analysis | Python, SQL• Identified 4 distinct customer segments by developing a robust Gaussian Mixture Model, and leveraged their key characteristics to enhance membership engagement• Conducted causal inference analysis to uncover the impact of current marketing strategies on customer behaviors using propensity score matching and A/B testing, refining the airline company's marketing programs

• Created monthly balance scorecards and optimized Tableau dashboards for B2C business by integrating 1M+ data through Azure Cloud Services by collaborating with global cross-functional teams• Defined and analyzed 40+ KPIs for sales team, including direct profitable growth from sales volume and indirect benefits from newly-won business opportunities, providing a comprehensive performance evaluation• Conducted time series forecasting and clustering analysis to perform ad-hoc data analysis requests, delivered customized reports for sales team, increasing business scale by 124% in lubricant market for Chinese mainland • Led ExxonMobil's internal quarterly newspaper for North Asia-Pacific; conducted interviews with campaign hosts, collated key information, and presented marketing results to provide actionable insights for headquarters stakeholders

• Analyzed retailers’ sell-in and sell-out data to plan stock orders by developing demand forecasting models for TV set sales, cutting inventory costs by 23%• Gained 34% market penetration among 7+ brands in East China TV market by conducting competitive analysis to design targeted sales promotions focused on key competitors• Collaborated with Costco team to devise market strategies and optimize product positioning for inaugural entry into China using sales trend analysis and customer behavior analysis, achieving a 4x growth in quarterly revenue

• Spearheaded team-building activities and outdoor education programs that were first-of-its-kind in the community targeting young teenagers, achieving a increasement by 20% in revenue over projected targets within the first year• Conducted NPS survey analysis to generate customer satisfaction and loyalty insights for network expansion• Designed targeted marketing strategies by leveraging digital channels, increasing customer engagement by 30%