At Badan Pengelola Keuangan dan Aset Daerah (BPKAD) Kabupaten Lampung Tengah, I consolidated and audited budget and asset data across 26 regional operational units. I also automated reporting workflows and built Power BI dashboards, reducing monthly reporting time by 75%.
At BPKAD, I analyzed discrepancies across IDR 2.8+ trillion in annual regional spending and developed validation and reconciliation checks that reduced reporting errors by 90%. I presented fiscal summaries and recommendations to department directors and cross-functional teams.
On my Omnichannel Retail Supply Chain Analytics Engine project, I designed a PostgreSQL database for 609,769 transactions and optimized queries to reduce latency by 98.3%. My SQL analysis also identified margin and sales recovery opportunities across inventory, vendor penalties, and delivery economics.
I’ve also developed Power BI and Python analyses for multi-branch restaurant profitability and a Monte Carlo investment feasibility simulator, pairing an interactive Streamlit app with an executive Power BI scorecard.
