Koh Ying
Actuarial Consultant
Talent
SingaporeMember since June 22, 2026
Prophet ModellingIFRS 17 and RBCT supportExcel VBAPower QueryAlteryxPythonActuarial data processing and reporting automation
·
Hire this person
Send a job offer directly to this candidate
Prophet ModellingIFRS 17 and RBCT supportExcel VBAPower QueryAlteryx
About
Actuarial Consultant with 3 years of experience in Prophet modelling and actuarial automation using Excel VBA, Power Query, and Alteryx. Experienced in model enhancement, supporting IFRS 17 and RBCT model runs, and optimizing actuarial reporting processes. Known for being efficient, high-performing, and collaborative.
Experience
Consultant - ACTBuilder Actuarial Solutions
(2025-10)
Associate Consultant - ACTBuilder Actuarial Solutions
(2023-07 - 2025-10)
- Enhanced Prophet model efficiency by integrating RBCT and IFRS 17 runs, reducing manual processing time and overall operational workload.
- Modified Prophet models to support new insurance products and improve model efficiency.
- Automated reinsurance contribution calculations using Excel (Power Query and VBA), improving accuracy and reporting timeliness.
- Processed and summarized large datasets from multiple systems using Alteryx, aligned with ICG classification for actuarial and management reporting.
- Developed a valuation and roll-forward model in Python, improving processing speed through workflow optimization.
- Assisted in actuarial model runs using Prophet Enterprise and DCS.
Technical Support - ACTBuilder Actuarial Solutions
(2023-05 - 2023-07)
Education
Bachelor of Science (Honours) - Actuarial Science - Universiti Tunku Abdul Rahman (UTAR), Sungai Long (2020-06 - 2023-05)
Skills
Actuarial Consultant