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