YAN (CAROL) XIE
Unit ****, *** Leeward Glenway, North York, ON
416-***-****, *****.******@*****.***
____________________________________________________________________________________
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