Shengjie “Alvin” Qiu

www.linkedin.com/in/alvinsq • 614-***-**** • acx29p@r.postjobfree.com • Los Angeles, CA EDUCATION:

University of Southern California, Marshall School of Business, Los Angeles, CA Dec 2016 Master of Science in Business Analytics

The Ohio State University, Fisher College of Business, Columbus, OH Bachelor of Science in Business Administration

Honors: Fisher College of Business Undergraduate Program Fee Scholarship, Dean’s List WORK EXPERIENCE:

Deloitte May-Aug 2016

Risk Analyst

Designed 30 risk factor customer surveys and created 4 survey collection models for Bank of Tianjin to determine appropriate risk factors for modelling in 4 retail business sectors

Applied Excel VBA to create Analytic Hierarchy Process survey model in 4 retail business sectors to calculate the weight of selected risk factors from bank employees’ survey results

Utilized selected risk factors to create 4 types of information collection models, allowing bank employees to input data for 550 past customers

Generated and adjusted 4 types of AR, KS, PSI, and LGD models to evaluate the overall model’s performance and the individual factor’s effectiveness

Motive Institute Jan-March 2016

Business Development Analyst

Utilized Google Analytics to track website traffic and analyzed customer segmentation to deliver customized marketing email to target group of customer

Used Squarespace to customize and optimize website content to increase page views Bank of China June-Aug 2013

Risk Analyst and Banker

Evaluated, predicted mortgage application risk to identify the default rate leading to low risk mortgage offers

Applied marketing techniques to sell financial products to potential customers increasing sales by 3% ALANTRA Dec 2012

Researcher

Analyzed the daily news on the Merger-Market website to propose potential projects to the supervisor

Researched target companies in capital IQ database to review financial calculation in the merge acquisition proposal BUSINESS ANALYTICS PROJECT EXPERIENCE:

Kaiser Permanente Feb-May 2016

Supply Chain Management Workforce Planning Analyst

Studied Full Time Employee(FTE) prediction model and aggregated tables based on the FTE by month and location

Explored the correlation of variables associated to the FTE distribution and selected 3 predictors to build the model

Performed the linear regression and random forest model decreasing 7 percent Mean Square Error in FTE prediction LA City Government Workers’ Compensation Feb-May 2016 Student Analyst

Updated dataset provided by the city administration, aggregating datasets by claim and payment

Visualized the datasets using Tableau and presented patterns of behavioral practices from workers' compensation claimants resulting in increased and/or inflated costs to the program EXTRACURRICULAR INVOVLEMENT:

Ricepo Oct 2014-May 2015

Co-Founder & Data Analyst

Negotiated with managers of local Chinese restaurants to initiate the lunch box delivery service in the Ohio State University and in the Columbus area

Analyzed weekly sales data and discussed the analysis result with co-founders to adjust sales and logistics strategy keeping weekly sales at the range of $2200 to $2500 SKILLS & CERTIFICATION:

Software: Microsoft Office, Tableau, Excel(VBA), R, SAS, SQL Certification: CFA Level II Candidate, SAS Base Programming for SAS 9, Business Analytics Industry Cluster (Ohio State University)

Contact this candidate