Zhao Xmin

· Established and renovated data infrastructure for Farmers Fast Quote project by partnering with IT, marketing, legal, and data management teams, to improve ingestion and utilization efficiency of information.

· Generated several A/B tests for Farmers Fast Quote web application with Google Optimize and Adobe Target to optimize visitor experience, increase 1200 quotes compare to the original quote process

· Developed automating Python scripts to integrate data extraction (from Google BigQuery into Python), data cleaning, EDA.

· Generated A/B test results analysis including Chi-square test and logistic regression into Excel worksheet, to reduce human error, improve the precision of data analysis and save the team over 200 hours on reporting the result for all the lines of business.

· Designed ad-hoc data analysis by generating visualization with python Matplolib.

· Presented the results to the management group, helped the management group to make business decisions, and improved web page user experience

· Performed EDA exploratory research and built rating models with R to provide more fair insurance prices for customers.

· Created one-way data analysis in Excel of the new variables that were selected by the decision tree model.

Extracted opportunities from new variables and implemented them into the new model that brought a positive impact on determining which variable to use in the future credit model.

· Built a GLM and a decision tree model in R to segment customers who have a higher possibility to churn in the next policy term, which increased 13% of the second quarter of 2021 customer retention rate.

· Updated customers’ credit information and reassigned them into different tiers or company placements through series SAS jobs.

· Refunded $21000 of overcharged premium for 184 affected policies in Mississippi.