Welcome — glad you're here 👋

Hi, I'm Gusta

Actuarial Officer · Jakarta, Indonesia

I turn uncertainty into insight — specializing in reserving, liability valuation, and IFRS 17 compliance, powered by Python, SQL, and VBA automation.

View Experience Get In Touch Download CV

ASAI

8 Exams Passed

Years Experience

70%

Process Time Reduced

3.97

GPA · Best Graduate

ASAI8 Exams
Passed

About Me

Actuarial Professional with a Passion for Data

I'm an Actuarial Officer at Heksa Solution Insurance, Jakarta, specializing in reserving, liability valuation, and regulatory compliance within the life insurance industry.

I apply the actuarial control cycle to monthly reserving, assumption setting, experience studies, and reconciliation — while developing VBA automation and interactive dashboards that reduce cycle times and enhance cross-departmental reporting.

Awarded Best Graduate at Brawijaya University (GPA 3.97), I combine actuarial expertise with advanced technical skills in Python, SQL, and Excel to deliver impactful, data-driven solutions.

Actuarial Modelling IFRS 17 Python SQL Excel VBA Reserving Liability Valuation Dashboard Design

What I Do

Skills & Expertise

A blend of actuarial science, data analytics, and automation tools built through real-world insurance experience.

📐

Actuarial Modelling

Building and validating actuarial models for reserving, pricing, and experience studies within the insurance lifecycle.

Proficient

Reserving Pricing Experience Study Actuarial Control Cycle

📋

IFRS 17

Implementing IFRS 17 standards through liability calculations and reporting under multiple measurement approaches.

Competent

Reporting GMM PAA Liability Calculation

📊

Excel & VBA

Designing advanced dashboards and macro automation tools that significantly reduce manual processing time and errors.

Proficient

VBA Macros Dashboard Automation Data Modelling

🐍

Python

Applying Python for data analysis, actuarial automation, and machine learning research presented at national conferences.

Competent

Data Analysis Automation Machine Learning Pandas

💻

Actuarial Software (RAFM)

Using RAFM for actuarial modelling workflows including model development, evaluation, and project execution.

Advanced Beginner

Developing Model Evaluate Running Project

🎤

Communication & Leadership

National conference speaker, teaching assistant for 50+ students, and cross-functional team collaboration across departments.

Competent

Public Speaking Team Leadership Mentoring Cross-functional

Portfolio

Projects & Work

Key actuarial and data projects I've built — from automation tools to analytical dashboards.

📋

Series

IFRS 17 PSAK 117 Education GMM

IFRS 17 Explained

A multi-episode educational series breaking down IFRS 17 / PSAK 117 for Indonesian insurers — covering LRC, CSM, GMM, PAA, and more with step-by-step examples.

View Series Episode 1

📊

1 Episode

Experience Study Mortality Lapse Education

Experience Study

A multi-episode series on actuarial experience studies — covering mortality, lapse, and expense investigations with step-by-step methodology for Indonesian life insurers.

View Series Episode 1

Career

Work Experience

My professional journey in actuarial science and insurance.

2024 — Present

Actuarial Officer

Heksa Solution Insurance · Jakarta, Indonesia

Performs monthly reserving ensuring compliance with OJK regulations and IFRS 17 standards.
Conducted mortality and lapse experience studies to validate assumptions and improve reserving accuracy.
Developed actuarial models for GPV, UPR, unit-linked fund accumulation, and IBNR claim reserves using triangle methods.
Designed VBA automation tools reducing processing time by 70% (from one full day to 3 hours).
Built an interactive Excel dashboard for product performance monitoring — adopted cross-directorially.
Supported IFRS 17 implementation: BEL, RA, CSM calculations using GMM, PAA, and VFA methods.

2023

Marketing & Policy Processing Intern

BCA Insurance · Indonesia

Prepared and distributed insurance policies ensuring accuracy and timely delivery.
Maintained policy records and conducted recapitulation of renewed and non-renewed policies.

2023

Python Programming Teacher

Algorithmics Indonesia

Taught Python programming to children aged 6–17, adapting lessons to different skill levels.
Evaluated student progress through projects and presentations in both Indonesian and English.

Highlights

Key Achievements

Milestones that reflect my impact in actuarial work, academia, and beyond.

🏆

Best Graduate Award

Awarded Best Graduate at Brawijaya University (2024) with a GPA of 3.97, recognizing academic excellence and leadership.

⚡

70% Process Time Reduction

Developed VBA macro automation for reserving, cutting processing time from one full day to just 3 hours and saving 8+ staff hours per cycle.

📈

Cross-Directorial Dashboard

Built an interactive Excel dashboard monitoring monthly premium, loss ratio, and claim ratio — adopted across departments by management.

🎤

National Conference Speaker

Presented ML research (Random Forest for Diabetes & Stroke prediction) at KNM XXI, Indonesian Mathematical Society (Oct 2022).

📚

Lecture Assistant · 4 Courses

Served as teaching assistant for Data Analytics, Mathematical Statistics, Programming, and Numerical Methods — supporting 50+ students each.

🎓

8 ASAI Modules Completed

Completed all 8 Associate modules of the Society of Actuaries of Indonesia (PAI): CF1–CF4, TA1–TA3, PM1.

Credentials

Education & Certifications

Academic background and professional qualifications in actuarial science.

🎓

Bachelor of Actuarial Science

Brawijaya University · 2024 · GPA 3.97

📜

ASAI Certificate

Society of Actuaries of Indonesia (PAI) · 8 Exams Passed

🐍

Python Intermediate Certificate

Sololearn · 2024

🗣️

TOEFL ITP 560 · B2 Level

English Proficiency · Professional Working Level

Get In Touch

Let's Connect

Interested in collaborating or have an opportunity to discuss? I'd love to hear from you.

kmagusarta@gmail.com

Phone

+62-877-9686-7875

Location

Jakarta, Indonesia

linkedin.com/in/kaa-wijaya