Aug 25 - Present
System Designer & Full-Stack Developer (Project-Based)
PT. Pertamina Hulu Rokan
Built AURORA — an enterprise SSPE (Subsurface Performance & Engineering) monitoring and governance platform for Pertamina Regional 1, consolidating drilling, workover, well intervention, production, and FID governance data into a single dashboard (Next.js 16, React 19, TypeScript, PostgreSQL, Prisma 7).
- Designed the application architecture, database schema, and data integration patterns end-to-end
- Developed responsive, data-intensive dashboards with KPI cards, drill-downs, interactive tables, and Excel export
- Built FID governance workflows: submissions, tiered reviews, approvals, audit trail, and progress monitoring
- Implemented a phased Excel ETL pipeline (upload, preview, commit, recompute) with enterprise-grade data validation
- Delivered APIs, authentication, access control, migrations, seeding, and deployment configuration (Docker)