Open to opportunities

Mario Caesar

@mariocaesar

Message

Senior ETL Developer with expertise in data engineering and analytics.

Indonesia

Message

What I'm looking for

I am looking for a role that fosters innovation, encourages collaboration, and offers opportunities for professional growth.

I am a Senior ETL Developer with extensive experience in data engineering and analytics, specializing in optimizing ETL processes and enhancing data quality. My journey has taken me through various roles in leading companies, where I have successfully revamped data pipelines, significantly reducing processing times and improving data accessibility for stakeholders.

At Agoda Services, I transformed the Greenhouse pipeline, cutting its runtime from 2.5 hours to just 45 minutes, while mentoring analysts in Python to foster a collaborative environment. My tenure at PT Allo Bank saw me re-engineering core ETL processes, delivering insights faster and enhancing compliance with internal policies. I am passionate about leveraging technology to drive efficiency and ensure data integrity.

With a Master’s degree in Data Science and Business Analytics, I am committed to continuous learning and sharing knowledge. I have mentored aspiring data engineers and presented at industry conferences, demonstrating my dedication to the field. I am excited to bring my skills to new challenges and contribute to innovative data solutions.

Experience

Work history, roles, and key accomplishments

Senior ETL Developer - People Team

Agoda Services Co., Ltd.

Mar 2025 - May 2025 (2 months)

Revamped the Greenhouse pipeline from Talend to Python, reducing total running time from 2.5 hours to 45 minutes and enabling consistent ingestion of ~8 GB CSV files into 33 SQL Server tables. Refactored Bridge ETL scripts by replacing one-by-one API fetches with an SQL pre-fetch layer and parallelized requests, simplifying the pipeline architecture and cutting runtime from 3 hours to 30 minutes.

Python SQL Server ETL API Integration Data Ingestion

Mid-Data Engineer

PT Allo Bank Indonesia Tbk

Sep 2024 - Feb 2025 (5 months)

Re-engineered core business summary ETL from Pandas to dbt, adding end-to-end lineage and delivering same-day insights 2 hours earlier to business stakeholders. Developed dbt data marts for non-lending, telemarketing, credit risk, and operations teams, achieving a 60% runtime improvement through optimized staged processing, CTE refactor, and join-tuning.

DBT Pandas ETL Data Marts

Data Engineer and Analytics

PT Krom Bank Indonesia Tbk (Kredivo Group)

Dec 2023 - Sep 2024 (9 months)

Implemented 15-minute latency CDC streams from multiple RDBMS to BigQuery using Confluent, providing near-real-time data readily available for stakeholders. Managed PII tagging policies for new tables and columns in BigQuery according to PII regulations, achieving compliance with strict SLA under one day, and the latest columns were fully masked.

BigQuery Confluent PII Masking Data Quality

Data Engineer and Analytics

PT FinAccel Teknologi Indonesia (Kredivo Group)

Jun 2022 - Dec 2023 (1 year 6 months)

Applied a fully automated Freshdesk data stream via Cloud Functions and webhooks, streaming ticket events into a dedicated RDBMS for real-time analytics and reporting. Created Airflow-orchestrated pipelines to process the Operations and Collection team data, trimming the ETL time needed from 30 minutes to 18 minutes.

Google Cloud Functions Webhooks Airflow ETL RDBMS

Automating Kaggle Datasets Updates

Kaggle

Jul 2023 - Aug 2023 (1 month)

Implemented a daily ETL workflow using Yahoo! Finance API and Kaggle CLI to publish up-to-date stock price datasets for the Kaggle community.

ETL Yahoo! Finance API Kaggle Data Automation Python

Loan Applicant Data Warehouse

GitHub

Jan 2021 - Jan 2022 (1 year)

Established ETL workflows for two CSV files, generated a data warehouse structure in an SQL Server with a fact table and three dimension tables. Constructed a Tableau dashboard to visualize total payments and overdue loans monthly and yearly.

Pentaho SQL Server Data Warehousing Tableau ETL

Education

Degrees, certifications, and relevant coursework

Asia Pacific University

Master of Data Science and Business Analytics, Business Intelligence

2021 - 2022

Grade: 3.70/4.00 - Merit

Focused on Business Intelligence, gaining expertise in data analysis and business intelligence tools. Achieved a GPA of 3.70/4.00, earning a Merit.

Bina Nusantara University

Bachelor of Information Systems, Business Intelligence

2015 - 2019

Grade: 3.53/4.00 - High Merit

Specialized in Business Intelligence, acquiring foundational knowledge in information systems and data management. Graduated with a GPA of 3.53/4.00, achieving High Merit.