Intern in risk strategy team
AIA Thailand
- Visualized equity indices for market dashboard.
- Summarized other insurance companies CAR ratio.
- Improved and fixed errors inside the SAA scenario generator Excel-based tool.
- Automated financial data collection process by built web scraping VBA Macro.
- Designed and developed video training materials for eGRC system training purpose.
- Constructed bond key rate duration calculator and validator Excel-based tool.
Intern in valuation team
Krungthai-AXA Life
- Prepared input data for Excel-based IBNR calculation tool.
- Translated reinsurance guidance document from English to Thai.
- Improved Excel template used for preparing and cleaning reinsurance data.
- Cleaned data using Excel, Access, and DCS to input in the reinsurance system and extracted
the output using MS SQL server to summarize result in an Excel report.
Intern in Client & Policy Services department
AIG Insurance (Thailand)
- Updated department’s work status using Salesforce.
- Reviewed insurance documents for completeness and accuracy.
- Automated invoice issuing process by built an Excel-based tool for rearranging and
formatting policy data and input into the appropriate Excel invoice template.