Sign in

SAS, SQL, MATLAB, VBA, Microsoft Office Applications

Dearborn, Michigan, United States
January 17, 2018

Contact this candidate


Jiani Wang

Dearborn, MI 615-***-****


Florida State University (FSU) Graduation May 2017 Tallahassee, FL M.S. Financial Mathematics GPA: 3.17

M.S. minor Statistics GPA: 3.58

Middle Tennessee State University (MTSU) Graduation May 2014 Murfreesboro, TN B. S. Actuarial Science GPA: 3.16

Minor: Insurance


SAS Programing and Data Analysis Certificate May 2017 Society of Actuaries Exam P/Casualty Actuarial Society Exam 1 (Probability) March 2014 RELEVANT COURSEWORK

Time Series and

Forecasting Methods

Model for Fin. Math

Probability and Statistics

Monte Carlo Methods

Applied Regression Methods

Advanced SAS

Machine Learning

Theory of Interest

Derivative Market


China Life Insurance Company Limited Ningbo, China Health & Benefits Actuarial Intern May 2016-August 2016

§ Designed an Excel annuitization quote tool to calculate premiums based on individualized personal information

§ Improved Excel skills in pivot tables and other functions when creating the annuitization quote tool

§ Collaborated with senior actuaries in detailed processes and verified premium and surrender value in production annual statements for clients

§ Assisted senior actuaries with pricing the premiums of annuity products for new clients Florida State University Statistics Department Tallahassee, FL SAS/Math Lab Teaching Assistant September 2015-May 2016

§ Implemented different SQL models such as prediction queries and content queries for more efficient use of data

§ Provided demonstrations of the SAS DATA step for programming tasks such as data manipulation, cleaning and editing, and data restructuring

§ Generated data reports using PROC REPORT

§ Helped undergraduate students solve math, algebra and calculus problems China Life Insurance Company Limited Ningbo, China Actuarial Science Intern May 2013-August 2013

§ Gained experience in modeling, valuation, and pricing while working with Actuarial team members

§ Evaluated frequency, severity, and premium trends for purposes of projecting future losses based on historical loss data

§ Managed several projects simultaneously in the Actuarial department organized by priority

§ Familiarized myself with using and understanding insurance manuals and principles RELEVANT PROJECTS

Monte Carlo Project Jan 2017 – May 2017

Project Title: Monte Carlo Methods in Financial Mathematics

§ Compared the Black-Scholes method, Monte Carlo method and Binomial method in solving different financial options’ (American and European) valuations

§ Used MATLAB to plot out the data to better visualize the trends and determine the convergent points Multiple Linear Regression Project Jan 2016 – May 2016 Project Title: Network Traffic Measurement

§ Generated a Linear Regression Model with SAS of Inbound Total Traffic (ITT) as a tool to help maintain a secure, efficient and stable network

§ Investigated the important parameters contributing to ITT and the correlations between them

§ Determined the qq plot as the plot with the best linear fit with the data Financial Mathematics Project Jan 2016 – May 2016

Project Title: The Internet Finance and Traditional Finance

§ Researched the advantages and disadvantages between online payments and traditional payment options

§ Compared the main players in Internet Finance for China (Alipay) and the US (Paypal) and their impacts to their respective markets

Time Series Project Jan 2015 – May 2015

Project Title: Traffic Signal Timing Model

§ Collected data on the number of cars that went through the street at each lane per hour

§ Forecasted the duration of the different traffic signals at various times of the day

§ Generated a model which helped determine how to control the rate of traffic more efficiently COMPUTER SKILLS

Software: SAS, SQL, MATLAB, VBA, Microsoft Office Applications Languages: C++, C, Python


Future Seminole Actuaries, FSU August 2014-Present Member of Actuarial and Insurance Association in MTSU August 2012- August 2014

Contact this candidate