YAN (CAROL) XIE

Unit ****, *** Leeward Glenway, North York, ON

416-***-****, i4gb0t@r.postjobfree.com

____________________________________________________________________________________

EDUCATION

University of Waterloo, Waterloo, ON, August 2009

* Master of Mathematics in Actuarial Science

* GPA: 91/100

* Awards: Math Graduate Experience Scholarship, International Master's Student Award

Renmin University of China, Beijing, China, June 2008

* Bachelor of Economics in Statistics with concentration in Risk Management and Actuarial Science

* GPA: 3.6/4.0

* Awards: Scholarships on Excellent Student Affairs

SOA Exams Passed: P (10/10), FM (7/10), M (10/10) and C (8/10)

Software Skills: Excel, Access, VBA, SPSS, Matlab, C#, etc.

WORK EXPERIENCE

Actuarial Intern, Sino-US MetLife Insurance Company, Beijing, China, December 2007 - January 2008

* Extracted and calculated data to perform monthly reserving for over 40 products using Excel

* Worked with underwriting and accounting department to monitor the consistency of reserving data

* Summarized data from more than 800 sheets to support the financial reporting using pivot table

* Modified 20 pricing models using VBA and processed data with 2,000 spreadsheets to update pricing models

* Worked hard to meet the deadlines of year-end audit while preparing for final exams

Actuarial Intern, Sino-US MetLife Insurance Company, Beijing, China, March - April 2007

* Set up a database of 5,000 customer feedbacks in Excel to help improve their customer service

* Worked with customer service department to maintain thousands of claim entries in spreadsheets

Teaching Assistant, University of Waterloo, Waterloo, ON, Canada, September 2008 - August 2009

* Graded assignments and tests and used Excel spreadsheets to track grades for over 200 students

* Offered extended office hours to help students’ understanding of course material

PROJECTS & PRESENTATIONS

* Evaluation of OBBI and CPPI Strategy, Research on GMWB

* Application of VaR and CTE in Deciding Optimal Retention Levels

* The Density of the Time to Ruin in the Classical Poisson Risk Model

ACTIVITIES & INTEREST

* Tutor, Beijing, China, March - May 2005

* Chinese Young Volunteers Association, Member, September 2004 - June 2006

* Statistical Investigation Association, Member, September 2004 - June 2006

* International Development and Exchange Association, Member, September 2004 - June 2006

* Interests include reading, volleyball, cooking and learning languages