Insurance Data

Yuhong Qian

*** ***** *** **, ********, WA ***** ● 206-***-**** ● ******@**.***

EDUCATION

Boston University, Boston, MA, USA May 2016

Master of Science, Actuarial Science

University of Washington, Seattle, WA, USA Jun 2014

Bachelor of Science, Mathematics of Science

TECHNICAL SKILLS

Analyst Skills: MS SQL, SAS, MS Excel, Access, R, VBA, Matlab and Java

Technical Skills:

• Practical Statistics with SAS

• Data Structures & Algorithms

• Regression and Time Series Mathematics

• Database Design and Implementation

• Actuarial and Financial modeling

• Linear & Discrete Optimization

WORK EXPERIENCE

Data Analyst Intern, PEACH COMPANY INC 12/14 – 01/15

• Successfully implemented a mathematical model that predicts customer behavior using multi-regression analysis and time series analysis. Limited the maximum residual to only 5 orders per workday.

• Completed analytical reports on 100 million customer orders based off random factors.

Senior Actuary Assistant Intern, CHINA-LIFE INSURANCE COMPANY 07/14 – 09/14

• Collaborated with Senior Actuaries to develop nonages education insurance product by using various Stat. techniques to predict vary rates. And successfully implemented math model to reserve the final premium for each policyholder.

• Performed insurance profit calculation based on various factors.

Project Analyst Intern, INDUSTRIAL AND COMMERCIAL BANK OF CHINA 07/11 – 09/11

• Interacted with managers on a regular basis and delivered client financial reports with cash flow information to ensure their ability to meet their short-term and long-term liabilities.

• Delivered risk management reports for client companies and risk resistance capacity for them.

PROJECTS

Ambulatory Health Center (AHC) Electronic Health Record System Design (SQL & Visio: top 10/50 project in class)

• Created relational database model to provide physicians with medical records, reduce patient’s wait time.

• Implemented entity-relationship model using Visio and map the conceptual design into Oracle database. Generated two indexes and several SQL Queries to ensure accurate data extraction.

Regression Analysis for Crime Related Data Among 50 Small Cities (R & Excel)

• Implemented Multi-Regression model in R to determine correlation between six independent parameters.

• Improved data accuracy using Stepwise selection and residual analysis.

Calculate Final Premiums for Mass. Car Insurance within 1000 policies data (MS Excel, Access, VBA)

• Created logical math function to accepts user input to generate reserved premium for car insurance.

• Also performed above calculation in Access, which is out of scope of the project. Delivered detailed reports on both tools to Prof Patashnick, and he spoke highly of me during class with grade A.

LEADERSHIP EXPERIENCE

Staff, Boston University Chinese Students & Scholars Association 09/14 – 06/15

• Hosted Annual Boston Seagull Entrepreneurship Contest

• Hosted Career Seminar for international students, and invited HR representatives from various company to perform mock interview sessions and resume writing sessions, and managed weekly meeting minutes.

Contact this candidate