Sign in

Data Analyst Life Insurance

Hartford, CT
May 22, 2020

Contact this candidate


Ziyu (Iris) Wang

860-***-**** • • Hartford, CT •


University of Connecticut, School of business Hartford, CT M.S in Business Analytics and Project Management, GPA:3.7 / 4.0 Aug.2018 – May.2020 Jiangsu University of Science and Technology Jiangsu, China B.S in Human Resource Management, GPA: 3.35 / 4.0 Sep.2013 – May.2017 SUMMARY

Detail-oriented and self-motivated Business Analytics Masters candidate with large datasets manipulation as well as strong team work, leadership and multi-task capabilities. Expertise in the technical analysis to identifying market opportunities to increase revenue and promoting innovative solutions. Ability to cooperate different functions of departments to understand and simplify complex business findings.


Technology: SQL, R, Python, Tableau, SAS, MS office, JMP, Hadoop, AWS(EC2, Athena), Google Analytics

Mathematics: Data Mining, Regression, Decision Trees, Clustering, Forecasting, Text Mining, Time Series, Web Analysis, Data Visualization

Management: Project Management, Leadership, Decision Making, Market Strategy EXPERIENCES

New China Life Insurance Company Ltd. Hangzhou, China Market Analyst Intern March.2018 – May.2018

Interacted with employees, acquired raw data of salary satisfaction and identified problems and expectations

Aggregated data from various sources and structured SQL queries daily. Automated routine report and data cleaning process with Python

Explore the impact of salary satisfaction on employees’ satisfaction by developing logistic regression models

Employed Tableau to visualize my analysis and report conclusions to superiors Sun Media Group Beijing, China

Market Research Intern May.2017 – Dec.2017

Worked cross-functionally to conduct healthcare market research. Organized and visualized market research data. Conducted analysis, and generated reports of product strategies and market insights to help SMG get into the market.

Visited advanced healthcare service across China to acquire competitive products’ sales status, market trend, and opportunities.

Using tableau to build dashboards and reports platform to get healthcare market strategic and insight ACADEMIC PROJECTS

Graduate Analyst – Grove Property Fund LLC (Real Estate) Aug.2019 – Dec.2019

Identified $15M of low risk/ high return industrial & flex property in Charlotte using data from COSTAR database

Built Python scripts over highly sparse data to resolve existing issue and investigate the quality of data

Engineered ML algorithm and deployed a predictive model to forecast property value over the next 5 years which can be updated monthly and quarterly basis using Python and reported to sponsor a convenient way to operate in excel

Developed a geospatial dashboard representing the profitable properties along with key insights graphs of demographics, market cap rate, vacancy rate, Stateline vs properties taxes and other metrics using Tableau

Adopted project management’s notions to create charter, RACI matrix, risk plan & status report for team efficiency FIFA Ranking Analysis - JMP Predictive Modeling (Modeling prediction) Sep.2018 – Dec.2018

Analyzed multiple datasets using EDA (exploratory data analysis) approach

Built different classification models (Logistic Regression, Neural Network and Bootstrap Forest) to understand the impact of team rank, player, age, and distance traveled on team performance in the FIFA world cup

Identified Logistic regression as the best model with a misclassification rate of 0.14 IMPROVE THE BUSINESS PROCESS OF OLACABS (SQL & Microsoft Visio) Nov 2018 – Dec 2018

Fulfill OLACABS’s customers real time booking needs by drawing swim-lane diagrams in Microsoft Visio

Designed a conceptual database by creating E-R diagrams, used SQL scripts to implement the database

Structured SQL queries to optimize business process with data reports, provided recommendations and insights

Contact this candidate