Building IDR FX Advisor: An Automated FX Signal Pipeline with Airflow, dbt, and BigQuery
How I built a daily ELT pipeline that helps Indonesians decide when to exchange IDR to foreign currency using percentile rank and multi-window z-score analysis.
Loading...
SG-EDTS, AMARTEK, Telkom — from enterprise banking to enterprise digital technology services.
Academic background and ongoing studies.
Universitas Bina Nusantara (BINUS), Jakarta, Indonesia
GPA 3.72 / 4.00 · Specialization in Big Data
Universitas Bina Nusantara (BINUS), Jakarta, Indonesia
GPA 2.98 / 4.00 · Specialization in Artificial Intelligence
Professional certifications and training.
Anthropic · Jun 2026
Anthropic · Jun 2026
HackerRank · Jun 2023
SQL · Extract, Transform, Load (ETL)
HackerRank · May 2023
SQL · Extract, Transform, Load (ETL)
HackerRank · Jul 2023
Python
Dicoding Indonesia · Nov 2022
Machine Learning · Python
ETL pipelines, data transformations, and infrastructure-as-code, from enterprise banking to side projects.
A medallion-architecture (Bronze → Silver → Gold) ETL pipeline for coal mining ritase (hauling trip) data, orchestrated with Apache Airflow and processed with PySpark over MinIO object storage, landing aggregated marts in a PostgreSQL warehouse. Fully Dockerized.
Building pipelines, choosing tools, and lessons from production data engineering.
SQL Server, SSIS, dbt, Airflow, BigQuery, Python — the tools I use to build data pipelines.
Design and optimize complex queries, stored procedures, and data transformation logic for enterprise banking environments.
Write advanced T-SQL including window functions, CTEs, and dynamic SQL for large-scale data pipelines.
Build and maintain ETL pipelines using SQL Server Integration Services for production banking data workflows.
Design and optimize production-grade data pipelines handling large-scale transformation and loading for enterprise clients.
Develop data processing scripts, NLP models, and machine learning solutions using Python and its ecosystem.
Work with relational databases for data storage, querying, and analytics in various project environments.