Data Analyst Sales

Linan Xu

Boston, MA(willing to relocate to anywhere in US), USA; 774-***-****, adjsco@r.postjobfree.com

https://www.linkedin.com/in/linan-xu-897063128/

EDUCATION

Worcester Polytechnic Institute (WPI) Worcester, MA Master of Science in Information Technology Sep 2016 - May 2018 Ningbo University (NBU) Ningbo, China

Bachelor of Science in Information Management and Information System Sep 2012 - Jun 2016 SKILLS

Programming Languages: Advanced SQL (PL/SQL), Python (NumPy, Pandas, scipy, plotly, Matplotlib, scikit-learn), R Analysis Techniques: TensorFlow, Keras, Time Series Analysis, LASSO Regression, XGBoost, Elastic Net Regression, Kernel Ridge Regression, LightGBM, SVM, Naive Decision Tree, Random Forest, KNN, K-means, Ensemble modeling Tools: Jupyter Notebook, Oracle, Tableau, Advanced Excel (V-lookup, Pivot Table), Google Analytics (advanced certification), Teradata, MySQL, SQL Server, WordPress, GitHub, Spark, Access, SharePoint, Jupyter Notebook, AWS WORK EXPERIENCE

Data Analyst, Homesite Insurance, Boston, MA Oct 2019 - Present

• Responsible for identifying, evaluating, and optimizing product opportunities to revolutionize Homesite’s sales and distribution strategy, and provide data-driven solutions to help leadership make better decisions, collaborated with cross-functional teams to put strategy into action

• Built different types of machine learning models to identify anomalous results by comparing current metrics (QS, DNQ, Yield) to past behavior, and automatically email notices to appropriate stakeholders with summarizing results using SQL, Python, R, and Tableau

• Implemented different classification machine learning models to predict property loss performance using historical quotes, policies, and vendor data (~400M records) from different data platform including CSV, JSON files, query results from AWS and SQL Server, and achieved 20%+ improvement compared with average level

• Utilized SQL, Python to query, manipulate, and analyze property vendor data to identify valuable contributors to pre- filled data, which enables customer can quote with limited information

• Designed and performed strategic data and gap analysis to identify product opportunities to improve profitable yield within sales and distribution framework for above $1 M potential cost saving after deployment within one year

• Support the development and implementation of new digital products and platforms designed to bring innovative solutions in the insurance marketplace

Strategic Analytics Consultant, CVS Health, Woonsocket, Rhode Island Mar 2019 – Aug 2019

• Managed key sales & ExtraCare Card user (more than 80M active users) engagement driving programs ($100M + increm.sales) from strategic planning to performance analysis

• Refined the restructure program audience segmentation based on reachability, engagement and redemption activity

• Analyzed and provided insights for Front Store OAR offer assignment strategy, convey key findings, trends, risks, and suggested business solutions to director and other partner teams

• Cooperated with multiple channel strategy, Data Scientist team to provide channel/campaign/coupon level analysis and machine learning model performance measurement

Data Analyst Intern, Elbum LLC, New York, NY Jun 2018 – Feb 2019

• Built classification models to predict customer churn with 87% recall rate using Python and Jupyter Notebook

• Built multiple machine learning models and improved recall from 79% to 87% by utilizing Model Stacking with Random Forest, SVM, and XGBoost

• Utilized Python (plotly, Matplotlib, Seaborn) to visualize analytical result IT Analyst Intern, CA Technologies, Framingham, Massachusetts Jun 2017 - Sep 2017

• Cooperated with IT team to translate business requirements into SharePoint site design

• Preprocessed data for analysis by data cleansing, feature transformation and standardization using Python and Excel

Contact this candidate