Selected Work · 2022 — 2026

Projects.

Things I've built — from tools for grassroots communities to systems that move data for thousands of users. Each one shipped, measured, and still running.

5Projects
5671+Users maintained
12+Schools involved
3+Industries
01

Support Operations Automation

Engineered a Python/Django Command Center dashboard for real-time health tracking and automated reporting.

Open Demo
Interactive Demo
View Interactive Demo
Impact
Reporting Time
75% DROP

Reduced manual reporting time by over 75%, establishing a centralized issue-logging database to accelerate bug resolution.

Workflow Efficiency
+40%

Boosted support workflow efficiency through automated PDF generation and helpdesk analytics.

Architecture
Robust

Deployed a containerized environment replacing local static files.

Django Docker PostgreSQL Nginx
02

Local-First Business System

Developed a full-stack web application enabling menu management and an expenses module.

Open Demo
Interactive Demo
View Interactive Demo
Impact
Processing Time & Error Rate
80% FASTER

Reduced order processing time from 5 mins to <1 min, and decreased order and expenses errors from over 10% to near-zero.

03

AI-Powered Customer Analytics

Integrated generative AI and NLP to automatically extract sentiment, keywords, and executive summaries from complaints.

Open Demo
Impact
Data Integration
Real-time

Engineered robust two-way Google Sheets sync and Mekari Qontak API integration for seamless data pipelines.

Insight Generation
Automated

Implemented AI clustering using Gemini and Groq to calculate impact metrics and auto-generate product recommendations.

04

Production Database Reverse-Engineering

Mapped an undocumented 5–7 year old PostgreSQL schema from scratch — no ERD, no documentation, just production data.

Impact
Tables Mapped
77 Active

Filtered 162 total tables down to 77 actively used ones using pg_stat_user_tables, isolating real production entities from legacy noise.

FK Relationships
157 Relasi

Extracted all foreign key relationships via information_schema, producing a complete relational map of the system.

Output
ERD Ready

Generated both .mermaid and .dbml files — immediately usable in mermaid.live and dbdiagram.io.

PostgreSQL DBML Mermaid
05

Payment Data Reconciliation

Wrote a multi-CTE SQL query against an undocumented schema to extract and reconcile 2 years of payment transactions across 8 schools.

Impact
Transactions Processed
19,480

Covered Jan 2024 – Apr 2026 across 8 schools, handling partial payments, multi-billing transactions, and variable admin fees per payment method.

Total Payment Value
IDR 21.5B+

Cross-validated against the payment gateway reference report with a 99.76% transaction match rate — all 47 differences accounted for.

Time to Complete
< 1 Day

ERD mapping through SQL query to dashboard integration — done in under one working day, outside of job scope.

PostgreSQL Django Python