SAS, SQL, Python, Excel, VBA,R

Yunlan Hu

Tele:+1-647-***-**** Email: ******.*******@*****.***

Education

University of Toronto

• Double Major: Actuarial science & Statistics

• Related courses: Basic Reserving Methods For P&C Insurance and Ratemaking EDX Online Courses

• Python in data analysis IBM

Actuarial science exams

Pass Exam P/Probability Theory May, 2018

Pass Exam FM May, 2019

SAS Certification June,2019

Sitting on Exam IFM October,2020

Sitting on exam CAS November, 2020

Internship

• Data analyst in skills assessment center China, summer of 2017 Responsible for analyzing and modifing candidates’ grading reports to client companies using Excel and VBA.

• China Life Insurance Company Limited

As Insurance product developer China, summer of 2018 Analyzing data to get development triangles and ratios like frequency, severity ratios and on level ratio. Using expected, BF, BS and frequency-severity methods to estimate reserves incorporating expense and profit. And analyzing MFAD,PFAD and financial report to finalize.

• YiAn Online Insurance Company

As personal insurance consultant. China, April-September 2019 Help customers find appropriate insurance plan according to their needs, cover the insurance inspection service set up.

• Wehire Inc. Toronto, September-January 2019

As secretary

Contact people who consulted for our job hunting service. Schedule appointments for them.

• UofT Teaching Assistant in ACT240. Toronto, November 2019

• In progress of Citibank, N.A. virtual intern in InsideSherpa As equity risk analyst

Give advise to the clients on how they should be positioned in order to track the performance of the ASX200 into year-end.

Projects

Software: Excellent in Excel, Python,VBA and PPT. SAS 1. Use Python to write a program for hanging man game, and bike sharing. 2. Use Excel to do a project about life insurance for Canadian Industry Life Contingencies. 3. Use Excel and R to do a project about P&C for automobile(specifically collision and disability income.)

4. Use machine learning to attend a competition for forecasting a company’s stock price in 6 months.

Volunteer

•AIESEC voluteer organization Hainan,China

Contact this candidate