Xiaosong Fan Email & Phone Number

Toronto, ON, CA

Toronto, Ontario, Canada

Regina, Saskatchewan, Canada

• Completed new month end and year end tasks with tight deadlines for group products in Long Term and Short Term Disability using
• Provided internal data for an auditing request from Quebec Drug Insurance Pooling Corporation ensuring our claims accuracy
• Carried forward previous responsibilities as an actuarial analyst and provided training to new staff

Regina, Canada

• Created tools and calculators in MS Access and R Studio to capture exposure data for trend studies in multiple group insurance products
• Completed month end and year end tasks using Excel and MS Access for group products such as Life, GCI and AD&D
• Recommend pricing charges for group product quotes and renewals
• Conduct studies to update pricing tables and present findings to multiple teams

Calgary, Canada Area

• Creating an executable program on Python that reads PDF files and converts tables into a DAT file schema
• Deployed and debugged tools in Microsoft Access and SQL Server that manages AER’s metadata
• Provided data entry and ISC/Confidentiality checks for over 100 AER information assets

Calgary, Canada Area

• Analyze metrics and identify trends to improve team member performance by creating a Google Data studio dashboard for customer care
• Develop multi variable regression models in R Studio for statistical analysis and present findings to leaders

Bachelor Of Science - Bs, Actuarial Science, Minor In Economics

Bachelor Of Science - Bs, Mathematics And Statistics