Work Experience

• Senior ETL Developer - People Data, Agoda Services Co., Ltd.

  Mar, 2025 - May, 20252 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.

  • Built end-to-end pipelines for O’Reilly data using Python and Talend, automating daily SQL Server delivery and removing manual handoffs.

  • Upskilled five analysts in Python through focused mentoring sessions, enabling their contribution to internal Python development tasks related to ETL.

• Mid-Data Engineer, PT Allo Bank Indonesia Tbk

  Sep, 2024 - Feb, 20255 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.

  • Refactored 20 legacy Python SFTP feeds into a streamlined dbt workflow, trimming runtime from 60 minutes to 38 minutes, enabling full data lineage and auto-generated documentation.

  • Configured secure ZIP creation in the reporting pipeline with centrally managed credentials, enabling sensitive reports transmitted securely over email and meeting 100% compliance with internal reporting policy.

  • Collaborated with the Data Operations team to enhance data quality monitoring, successfully improving anomaly detection accuracy by 20% through a dashboard and automated daily ingestion comparison alerts.

• Data Engineer and Analytics, PT Krom Bank Indonesia Tbk (Kredivo Group)

  Dec, 2023 - Sep, 20249 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.

  • Productionized a POC PII-masking algorithm across critical tables to protect sensitive information while preserving key attributes for Product and Infosec analytics.

  • Engineered an auto-schema propagation function that forwards new API-source columns into L0 and L1 tables, eliminating column-mismatch job failures and significantly enhancing data quality.

  • Developed reusable ingestion pipelines from various sources with parameterised Jinja templates, cutting development time for similar data sources by two days.

• Data Engineer and Analytics, PT FinAccel Teknologi Indonesia (Kredivo Group)

  Jun, 2022 - Dec, 20231 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.

  • Built a comprehensive monthly collector-cost table consolidating expenses from multiple sources, reducing manual reconciliation and establishing a single source of truth.

  • Delivered five OJK compliance reports via BigQuery before the regulatory deadline, coordinating closely with the Collections and Operations teams.

Skills

Education

Awards

Volunteer Work

Interests

References