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 5 years, enhancing efficiency and decision-making in underwriting.• 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•Created plots for total premiums through years for the old data extract and the new version