QI SHENG TAN
Kuala Lumpur
Summary
Detail-oriented and highly motivated professional with over 2 years of actuarial valuation experience and 3 years of data analytics expertise in the general insurance field.
Thorough team contributor with strong organizational capabilities. Experienced in handling numerous projects at once while ensuring accuracy.
Currently seeking an actuarial role in Singapore.
Overview
8
8
years of professional experience
Work History
Actuarial Analyst
Tune Protect Malaysia
01.2023 - Current
- Collected and analyzed the data provided by various departments, conducted periodic valuations (monthly, quarterly, year-end), and prepared detailed reports and presentation slides.
- Prepared data template and uploaded it to IFRS17 software and perform comparison and reconciliation of the results against IFRS4.
- Conducted risk margin calculations and expense analysis to support valuation processes.
- Assisted to update Financial Condition Report (FCR) and stress test scenarios.
- Automated UPR and claims reconciliation processes to eliminate manual computations and ensure zero human interference, by applying the knowledge of ETL and the help of automation tool.
- Conducted ad-hoc projects such as development of PowerBI dashboard for Appointed Actuary.
Senior Data Analyst
Tune Protect Group
02.2022 - 12.2022
- Understood the process flow of raw data from front-end systems to back-end databases.
- Designed ETL pipelines to transform raw data into a format suitable for analysis by using SQL and Microsoft SSIS automation tool.
- Performed audit checks and analysis on the finalized data, effectively communicating results to stakeholders.
- Developed reports based on users’ requirements and scheduled to distribute it periodically.
- Created PowerBI dashboards to help management to get insights and make decisions.
- Mentored and provided guidance to Junior Data Analysts.
Data Analyst
Tune Protect Group
10.2019 - 01.2022
- Understood the process flow of raw data from front-end systems to back-end databases.
- Extracted sample data for analysis from databases
- Prepared consolidated sales reports for monthly closing.
- Developed reports based on users’ requirements and scheduled to distribute it periodically.
IT Analyst
DXC Technology
01.2018 - 09.2019
- Supported and ensured uninterrupted service for users.
- Provided expert support, troubleshooting complex technical problems for end-users in a timely manner.
Intern
AmGeneral Insurance Berhad
10.2016 - 12.2016
Education
Bachelor of Science - Actuarial Science
Universiti Tunku Abdul Rahman
Sungai Long, Selangor06-2017
Professional Certificate - Google Data Analytics Specialization
Coursera
04-2022
Certificate - Microsoft Power BI - Business Intelligence For Beg
Udemy
04-2022
Certificate - SAP BI /SAP Business Objects Web Intelligence
Udemy
10-2021
Certificate - Mathematics For Machine Learning Specialization
Coursera
08-2021
Certificate - Data Scientist With R Track
Datacamp
11-2020
Certificate - Behavioral Finance
Coursera
05-2020
Certificate - Machine Learning With TensorFlow On Google Cloud P
Coursera
01-2020
Certificate - From Data To Insights With Google Cloud Platform S
Coursera
12-2019
Skills
- Excel spreadsheets
- SQL and database knowledge
- Data engineering
- Data visualization mastery
- Python coding
- SQL server integration services
Additional Information
- SOA Exam P
- SOA Exam FM
- SOA Exam MFE
- SOA Exam C
- CAS MAS-1
- 3 VEEs
Timeline
Actuarial Analyst
Tune Protect Malaysia
01.2023 - Current
Senior Data Analyst
Tune Protect Group
02.2022 - 12.2022
Data Analyst
Tune Protect Group
10.2019 - 01.2022
IT Analyst
DXC Technology
01.2018 - 09.2019
Intern
AmGeneral Insurance Berhad
10.2016 - 12.2016
Bachelor of Science - Actuarial Science
Universiti Tunku Abdul Rahman
Professional Certificate - Google Data Analytics Specialization
Coursera
Certificate - Microsoft Power BI - Business Intelligence For Beg
Udemy
Certificate - SAP BI /SAP Business Objects Web Intelligence
Udemy
Certificate - Mathematics For Machine Learning Specialization
Coursera
Certificate - Data Scientist With R Track
Datacamp
Certificate - Behavioral Finance
Coursera
Certificate - Machine Learning With TensorFlow On Google Cloud P
Coursera
Certificate - From Data To Insights With Google Cloud Platform S
Coursera
Similar Profiles
Aizat HassanAizat Hassan
Senior Executive- Digital solutions/System support at Liberty Insurance MalaysiaSenior Executive- Digital solutions/System support at Liberty Insurance Malaysia
Manoj Kumar DasManoj Kumar Das
Senior Lead Data Engineering Manager at Tune Protect GroupSenior Lead Data Engineering Manager at Tune Protect Group
Kathirvan PramasivamKathirvan Pramasivam
Full Stack Developer at Tune Protect Group (Fintech/Insurtech)Full Stack Developer at Tune Protect Group (Fintech/Insurtech)