Ziyu (Iris) Wang
860-***-**** • adddg6@r.postjobfree.com • Hartford, CT • linkedin.com/in/ziyuwang-iris/
EDUCATION
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.
SKILL SET
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