Portfolio

All work

16 projects across data engineering, machine learning, and analysis. Filter by category, or open any project for the full write-up.

14Data Engineering

SMILE Platform (UNDP for Kemenkes)

National immunization logistics system in production across all of Indonesia — streaming CDC + batch analytics platform.

AWS RDSDebeziumKafkaRisingWave+7
16Data Engineering

LidValid — Unified Data Validation Platform

Full-stack data validation platform with Tiered Validation — cheap aggregate checks across every table, then precise row-level checks only where they fail.

FastAPISQLAlchemyReactVite+8
15Data Engineering

Dataklin — AI-Powered Data Quality & Entity Resolution

Data quality and entity-resolution platform that profiles, validates, deduplicates, and standardizes datasets before handoff — with LLM-generated rules.

Next.jsFastAPIPostgreSQLpgvector+4
10Data Engineering

Real-Time Fraud Detection

End-to-end real-time fraud detection pipeline: Flask UI → RabbitMQ → Kafka → Flink → ClickHouse → Grafana.

FlaskRabbitMQKafkaApache Flink+2
09Data Engineering

Multi-Source Data Pipeline (Sales)

Full-stack sales data pipeline integrating five source databases through Kafka, Flink, Spark, Airflow and Hadoop to Power BI.

KafkaApache FlinkApache SparkApache Airflow+8
08Data Engineering

Flink Streaming Pipeline + Dashboard

Real-time sales streaming pipeline: Kafka → Flink ETL → ClickHouse → Grafana dashboard.

KafkaApache FlinkClickHouseGrafana
12Data Engineering

Database Validation Tool

Data-validation tool from a real AWS Athena → Alibaba MaxCompute migration — detects missing IDs and value discrepancies across sources.

AWS AthenaAlibaba MaxComputeOraclePostgreSQL+1
06Data Engineering

Airflow Data Pipeline

Synthetic sales pipeline with Kafka + Airflow + PostgreSQL — full-load batch plus real-time streaming.

KafkaApache AirflowPostgreSQL
07Data Engineering

Spark Pipeline (Sales)

Streaming & batch ETL with Kafka + Spark, stored in Delta Lake, scheduled with Dagster.

KafkaApache SparkDelta LakePostgreSQL+1
11Data Engineering

KSQLDB Streaming Pipeline

Streaming ETL with Kafka + KSQLDB and a custom Kafka Connect sink — Postgres to Postgres.

KafkaKSQLDBKafka ConnectPostgreSQL
13Data Engineering

Pentaho ETL Pipeline

Multi-source ETL into dimension tables with Pentaho, loaded to ClickHouse.

PentahoClickHouseMySQLOracle+3
01Machine Learning

Rice Leaf Disease Classification (CNN)

CNN image classification of rice leaf diseases with a custom model plus AlexNet, VGG19, and DenseNet — deployed on Flask.

PythonTensorFlow / KerasCNNAlexNet+3
02Machine Learning

JKII Stock Price Prediction

Jakarta Islamic Index price forecasting with LSTM, XGBoost, SVR and more — evaluated on 5 metrics, deployed on Streamlit.

PythonLSTMXGBoostSVR+3
03Data Analysis

Airbnb Singapore Analysis

Merged 3 datasets via SQL, then cleaned and ran EDA on price, reviews, neighbourhood, host, and room type.

SQLPythonPandasEDA
04Data Analysis

Credit Risk Modeling

EDA plus five models (XGBoost, ANN, Random Forest, Decision Tree, SVM) with a Streamlit prediction app.

PythonXGBoostANNRandom Forest+3
05Data Analysis

Motorized Vehicle Sales Analysis

Car sales analysis in Indonesia (Gaikindo data) using SQL and Python.

SQLPythonPandas

Other projects

  • Customer 360 Dashboard (insurance)
  • Market Sales Dashboard
  • Realtime Streaming with Debezium + Kafka
  • OCR Engine — PDF → Database
  • AWS → Alibaba Big Data + Tableau migration
  • Airflow Pipeline
  • ETL Streaming with Flink
  • Pentaho Pipeline