Yingchen Guo Email & Phone Number

Toronto, ON, CA

加拿大 安大略 多伦多

Reserving

加拿大 安大略 多伦多

• Actuarial Analyst, Commercial Lines - Underwriting Analytics
• Developed a VBA tool to handle a dataset of over 10000 records, enabling rapid search capabilities for underwriting advisors. Took the initiative to restart and successfully complete a project that had been delayed for.
• Extracted and analyzed quote data using SAS and SQL, creating indicators to provide actionable insights and facilitate decision-making
• Successfully identified and addressed key issues in the Activity Catalogue, demonstrating critical thinking and attention to detail, ensuring compliance and accuracy in underwriting practices

加拿大 安大略省

• TA for course Math 1F03 (Intro to Calculus) in Fall 2023
• TA for course Math 1LS3 (Calculus for Life Sciences I) in Spring 2024
• TA for course Math 2XX3 (Advanced Calculus II) in Summer 2024

中国 北京市

• Updated weekly Net Asset Value (NAV) of private equity funds of the underlying observation pool of the product
• Used VLOOKUP function to append historical NAVs of new funds not from the original pool
• Used CORREL function to calculate the correlation between each pair of products
• Used Ctrl+F shortcut to update weekly, monthly, and yearly yield, excess yield, and drawdown rate of products

加拿大 安大略省 多伦多

• Participate in testing and reconciling policies during the rebuilding of a tool used by actuaries
• Provide insights on discrepancies between the source system and the data extract
• Learned about SQL and wrote code to help build loss-cost model for actuarial pricing for commercial fleet
• Learned about R packages and how to summarize information for loss-cost modelling
• Validated and reconciled the data from different sources
• Calculated summary statistics for the old data extract and compared with the new version