Work
Open-source pipelines I built to learn the modern data stack, plus the professional work behind them.
Personal · 2026
A remote MCP tool that screens EVM tokens and Solana mints before a trade (honeypot and tax flags, liquidity lock, mint authority, holder concentration) and ends in a one-line verdict. Pay-per-call with x402 USDC micropayments on Base: no account or API key.
Personal · 2026
A real-time fraud detection pipeline for Indonesian banking transactions: a Python generator streams IDR transactions into Kafka, Spark Structured Streaming flags suspicious ones, Airflow and dbt build the marts in PostgreSQL, and a Streamlit dashboard shows the alerts. Runs fully locally with Docker Compose.
Personal · 2026
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.
Personal · 2026
A Python ETL pipeline that reads a messy CSV, deduplicates and normalizes the rows, loads clean and rejected records into separate DuckDB tables, and exports the results to JSON and CSV. Dockerized and covered by 17 unit tests.
Personal · 2026
A daily ELT pipeline that helps Indonesians decide when to exchange IDR to foreign currency, sending 5-level Discord signals (STRONG BUY → STRONG WAIT) based on percentile rank and multi-window z-score analysis. Built with Airflow, dbt, BigQuery, and Terraform.
Professional · 2025
Developed and maintained 40–50 stored procedures and ETL pipelines using SSIS and SQL Server for Permata Bank's Antasena platform, covering 6 projects in enterprise banking environments.
Professional · 2021
Developed an Indonesian text corrector using IndoBERT transformer model to improve labeling accuracy for Government Sentiment Analysis on social media data.
Professional · 2021
Contributed to COVID-19 data mining pipeline for PeduliLindungi, a government contact tracing app used by millions of Indonesians during the national pandemic response.