Business Analyst

Xinxin Jiang

**** ********** **. *** #***

Denver, CO 80202

Tel: 720-***-****

Email: ******.*****@********.***

QUALIFICATIONS

Proficient in Excel, SQL, R, Python, Predictive Analytics, Simulation, Optimization (CPLEX and Gurobi), Data Visualization

AWS Certified Solutions Architect – Associate (06/2018)

SAS® Certified Base Programmer for SAS®9 (11/2015)

EXPERIENCE

Performance Measurement Analyst, State of Colorado, Denver (09/2018 – Present)

Integrated SQL and SAS to extract and analyze raw data for Department performance reporting. Utilized Power BI, Tableau, & Google Analytics for a compiled graphic display to interpret performance data for strategic planning. Developed team balanced scorecard for team dashboard to achieve continuous improvement. Designed a Customer Success Story Board for Lean Process Improvement practices.

Peak Performance Intern, City and County of Denver, Denver (06/2017 – 08/2017)

Processed raw data from DMV using R and generated key metric such as Average Wait Time. Generated an interactive dashboard in Power BI with Bullet Chart and Gantt Chart through collaboration with analysts from 311, 911, and Public Works. Compiled performance data and progress report for a new prototype of Denver Mayor’s Dashboard.

Math Tutor, University of Colorado Denver, Denver (08/2016 – 12/2016)

Worked in a casual but innovative atmosphere to facilitate learning for undergraduate students. Tutored students on Calculus courses and shared pragmatic approaches to learning. Helped build problem-solving skills and ignited intellectual curiosity in students.

EDUCATION

Master of Science, Business Analytics, University of Colorado Denver, Denver (08/2016 – 05/2018) GPA: 4.0/4.0

Bachelor of Arts, Economics (Math Minor), University of Colorado Denver, Denver (08/2012 – 12/2015) GPA: 3.99/4.0

ACADEMIC PROJECTS

Personal Loan Interest Rate Forecast (Fall 2017)

Performed data modeling using Predictive Analytics techniques. Treated missing values and outliers for the best model performance with incomplete information. Reduced the model dimension using EDA and domain knowledge. Designed 7 forecast models with machine learning tools like Random Forest, and Neural Networks. Optimized parameters in each model and used cross validation to ensure generalizability and select the best model.

Denver Children’s Hospital Wait Time Analysis (Spring 2017)

Led a four-person research team to simulate the patient flow of a neurology clinic in Simio with real data. Implemented algorithm that estimate the budget for alternative test room capacity and number of doctors. Tested 10 scenarios and conducted a bottleneck analysis. Chose the best scenario and reduced the maximum time in waiting room from 52 min. to 8 min.

COMMUNITY SERVICE

Volunteer Society Nepal (VSN), Kathmandu, Nepal, Volunteer (07/2013)

Took care of the local orphans in the Everest Foundation Children’s Home. Provided help to local dairy and mushroom farms and increased productivity.

Contact this candidate