Skip to content
All projects

AURORA — SSPE Monitoring & Governance Platform

  • Next.js
  • TypeScript
  • PostgreSQL
  • Prisma

Enterprise monitoring, analytics, and FID governance platform built end-to-end for Pertamina Regional 1's Subsurface Performance & Engineering team.

AURORA — SSPE Monitoring & Governance Platform — screenshot

AURORA (Advanced Upstream Repository Orchestration & Reliable Analytics) is an enterprise web platform I designed and built end-to-end for Pertamina Regional 1's SSPE team. It consolidates drilling, workover, well intervention, production reconciliation, and FID governance data — previously scattered across many Excel files — into a single, searchable dashboard used for day-to-day monitoring and management decision-making.

As System Designer & Full-Stack Developer I was responsible for the application architecture, PostgreSQL schema and Prisma data layer, authentication and access control, KPI dashboards with drill-downs and chart visualizations, tiered FID approval workflows with audit trails, and a phased Excel ETL pipeline (upload, preview, commit, recompute) with enterprise-grade validation. The stack: Next.js 16, React 19, TypeScript, Tailwind CSS 4, TanStack Query, Zod, and Docker for deployment.

The project is private and proprietary, so source code, real screenshots, and operational data cannot be shared. The full sanitized case study is available on request.

Visit project