Support Operations Automation
Engineered a Python/Django Command Center dashboard for real-time health tracking and automated reporting.
Reduced manual reporting time by over 75%, establishing a centralized issue-logging database to accelerate bug resolution.
Boosted support workflow efficiency through automated PDF generation and helpdesk analytics.
Deployed a containerized environment replacing local static files.
Local-First Business System
Developed a full-stack web application enabling menu management and an expenses module.
Reduced order processing time from 5 mins to <1 min, and decreased order and expenses errors from over 10% to near-zero.
AI-Powered Customer Analytics
Integrated generative AI and NLP to automatically extract sentiment, keywords, and executive summaries from complaints.
Engineered robust two-way Google Sheets sync and Mekari Qontak API integration for seamless data pipelines.
Implemented AI clustering using Gemini and Groq to calculate impact metrics and auto-generate product recommendations.
Production Database Reverse-Engineering
Mapped an undocumented 5–7 year old PostgreSQL schema from scratch — no ERD, no documentation, just production data.
Filtered 162 total tables down to 77 actively used ones using pg_stat_user_tables, isolating real production entities from legacy noise.
Extracted all foreign key relationships via information_schema, producing a complete relational map of the system.
Generated both .mermaid and .dbml files — immediately usable in mermaid.live and dbdiagram.io.
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.
Covered Jan 2024 – Apr 2026 across 8 schools, handling partial payments, multi-billing transactions, and variable admin fees per payment method.
Cross-validated against the payment gateway reference report with a 99.76% transaction match rate — all 47 differences accounted for.
ERD mapping through SQL query to dashboard integration — done in under one working day, outside of job scope.
