Back to Projects
Back to featured work
Case Study — Growth Systems

Pertamina FUA Auditor Dashboard

Developed an automated Excel/Web database script parsing Pertamina hierarchical business units into standard compliance follow-ups, eliminating human error.

Client / Focus
Pertamina
My Role
Full Stack Systems Engineer
Core Metric
70% Reporting Time Saved
Technologies
Python, OpenPyXL, Excel, Data Processing

The Challenge

Pertamina's compliance team manually tracked FUA (Follow-Up Action) items across 200+ business units using inconsistent spreadsheet formats, leading to missed deadlines and audit failures.

The Solution

Built an automated Python + Excel script that parses the hierarchical business unit structure and generates standardized FUA checklists with proper tracking columns, formulas, and color-coded status indicators.

Results

Eliminated 100% of manual data entry errors, reduced compliance reporting time by 70%, and standardized tracking across all business units.

Coordinate a Similar Rebuild

Project Visual Gallery

Explore the custom visual layout grids and interface variations developed for the platform:

Active Mockup View
Mockup 1 Mockup 2 Mockup 3

Core Deliverables

  • Business unit hierarchy parser
  • Automated Excel checklist generator
  • Color-coded status indicators
  • Multi-sheet template system

Key Accomplishments

  • 100% elimination of manual entry errors
  • 70% reduction in reporting time
  • Standardized tracking across 200+ units