Microsoft Office Data

XILIN ZHANG

*******@*****.*** 734-***-**** ****, Cass Ave, Detroit, 48201

EXPERTISE/TOOLS

Skills Applications

Data Queries Machine Learning Algorithms R Studio SPSS

Optimization Data Mining and Visualization SQL/Hive Eviews

Predictive Modeling Decision Analytics Microsoft Office Suite Tableau

Agile Training Business Intelligence Microsoft Visio, SharePoint Power BI WORK HISTORY

Jun 2017 – Present Quicken Loan Affiliate

Business Intelligence Analyst Detroit, MI

Business o Operation Analysis

Creating a first Title health report in a digestible format by monitoring existing metrics and working across the organization to make actionable intelligence available to business stakeholders

Performing SQL data pulls and Ad-hoc work supporting the re-invention of business operation

Providing decision support for VP to identify factors to decrease pipeline, turn time and age of orders Automation Integration Impact (API) Analysis

Propose building a generic API to automate the BPO manual typing via web-portal and save turn time

Conduct financial and scenario modeling to calculate ROI of APIs for 4 business processes

Work with IT team to help them test the messages from Black Knight and other tech-ready BPOs

Present the impact analysis to C-level Executives (verbal and written) and the project get approved Jan 2017 – Apr 2017 Michigan Institute for Data Science Graduate Research Assistant Ann Arbor, MI

Commercial Cost Analysis and Predictive Modeling

Discovered a classification tree model with 98% test accuracy by using R to identify predictors (car model, maintenance job) were prone to incur the commercial cost

Suggested the City of Detroit add capacity to certain job type to minimize the maintenance cost Exploratory Analysis of Detroit Vehicle Data

Condensed the analysis by filtering and matching 0.2 million datasets from vehicle table and job maintenance table to 65k datasets based on client needs by using R and Excel

Explored the data structure within the maintenance histories of police fleets by using PCA, MDS ADDITIONAL PROJECTS

Machine Learning-Spam Email Classification Project (2017)

Implemented parametric classification algorithms (LDA, QDA, Logistic, KNN) and non-parametric

(SVM, NN) techniques to train classification models after identifying data frames using R

Conducted Cross Validation to output the prediction with the highest accuracy (99%) Water Resource and Economic Growth Study Based on Panel Data (2014)

Built an Econometric Model with Water Shortage Index and economic factors to demonstrate that water scarcity limited Chinese regional economies using SPSS and Eviews

Won the best student poster by presenting at the 1st International Workshop on Urbanization EDUCATION

UNIVERSITY OF MICHIGAN, GPA: 3.6/4.0 Ann Arbor, MI Master of Science, Sustainable System Certificate: Data Science Sep 2015 - May 2017 Relevant Coursework: Statistical Learning, Applied Business Analytics, Probability & Stats, Hybrid Electric Vehicle HUAQIAO UNIVERISITY, GPA: 3.5/4.0 Xiamen, China

Bachelor of Engineering, Environmental Engineering Sep 2011 - Jul 2015

Contact this candidate