Insurance Life

YINGZHOU NI

******@********.***

*** * **** **, *** 26J, New York, NY 10036 • 646-***-****

EDUCATION

Columbia University, MS in Actuarial Science May 2017 University of Rochester, BA in Statistics and Financial Economics; GPA: 3.4, Major GPA: 3.68 May 2015 PROFESSIONAL EXPERIENCE

Foresters Financial, New York, New York May 2016 - Dec 2016 Actuarial Data Analysis Intern

Participated in the term insurance repricing project; recalculated the net single premium by changing assumptions; conducted profit analyses and sensitive tests based on the updated factors

Generated life insurance products’ quotes every day using the Excel models; added macros to the models to improve the data entry efficiency

Assisted actuaries with the proposal for variable life products by running financial models in GGY AXIS, an actuarial data software

Prepared monthly reserve reports for various actuarial products based on raw client data and presented the results to the supervisor

Ernst & Young, Shanghai, China Dec 2015 - Jan 2016 Advisory Intern

Assigned to life insurance projects from various insurance companies across Asia and tested assumptions, calculations, and reserve valuation using Excel

Utilized Excel VBA to conduct the sample crosscheck between the reserve results calculated by the insurance companies and by our company

Created a VBS application that enabled merging thousands of Excel tables automatically

Organized various life products’ features into standard format RELEVANT EXPERIENCE

Derivative Options Pricing Project May 2016

Introduced two ways to price the Walt Disney company’s stock options: Asian Option and Barrier Option

Used the Monte Carlo simulation in Excel to get discounted average value and find the call/put option prices

Tested the method by comparing the simulated prices and the actual prices Business Valuation for NIKE Inc Jan 2015

Built a DCF model in Excel to evaluate NIKE Inc. based on our assumptions including coverage ratio and revenue growth

Used Competitive analysis to find the company’s strength by introducing the porter’s 5 forces

Made suggestions on the trading strategies based on the DCF price per share, financial performance, and the response to the main competitors

2004 Cars and Trucks Analysis Project May 2015

Created multivariate analysis for new cars and trucks made in 2004 using R and developed a linear model to predict vehicles’ retail prices

Identified the variables exhibiting the strongest correlation with retail prices were the engine size, the horse power, and the rear wheel drive

HONORS

Graduated with distinction

Dean’s Honor List

Member of the URSO (University of Rochester Symphony Orchestra) SKILLS

Data collection and analysis using advanced Excel techniques, R, Stata, Java, SAS, SQL, Latex

Contact this candidate