Furqon E. Muhammad← Portfolio
Case Study 04 / 27Supply Chain Management / Project Controls / Business Intelligence

Awakmas Mine Procurement & Strategic Recovery Dashboard

Developed a Power BI command center for Procurement Trackers, Blocker Management, and an Action Plan Recovery Program.

04 — EPC & Mining AnalyticsAwakmas Mine Procurement & Strategic Recovery Dashboard
PT. Petrosea Tbk · Awakmas (MDA) · 2026
Problem

The site lacked a centralized mechanism to track supply chain delays, resolve roadblocks, and monitor recovery plans.

Solution

Developed a Power BI command center for Procurement Trackers, Blocker Management, and an Action Plan Recovery Program.

Impact

Drove completion of 31 critical recovery initiatives and clarified cross-party accountability.

Awakmas Mine Procurement & Strategic Recovery Dashboard04 / 27
A Executive Summary

Overview

04 / 27
Project No.
04
Client / Org
PT. Petrosea Tbk
Role
Project Controls BI Lead
Year
2026
Location
Awakmas (MDA)
Discipline
EPC & Mining Analytics

An intelligence suite eliminating execution bottlenecks—integrating Procurement Tracking, Blocker Resolution, and Action Plan Recovery.

Overview — Project Exhibits4 images · add up to 04.12
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.1
PT. Petrosea Tbk · 2026 · Exhibit 04.1
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.2
PT. Petrosea Tbk · 2026 · Exhibit 04.2
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.3
PT. Petrosea Tbk · 2026 · Exhibit 04.3
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.4
PT. Petrosea Tbk · 2026 · Exhibit 04.4
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.5
PT. Petrosea Tbk · 2026 · Exhibit 04.5
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.6
PT. Petrosea Tbk · 2026 · Exhibit 04.6
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.7
PT. Petrosea Tbk · 2026 · Exhibit 04.7
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.8
PT. Petrosea Tbk · 2026 · Exhibit 04.8
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.9
PT. Petrosea Tbk · 2026 · Exhibit 04.9
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.10
PT. Petrosea Tbk · 2026 · Exhibit 04.10
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.11
PT. Petrosea Tbk · 2026 · Exhibit 04.11
Awakmas Mine Procurement & Strategic Recovery Dashboard — exhibit 04.12
PT. Petrosea Tbk · 2026 · Exhibit 04.12
Executive Summary04 / 27
B Outcomes

Strategic Business Impact

04 / 27
01

Supply Chain Visibility & Risk Mitigation

Consolidated 220+ procurement items, isolating critical path items (Fire Pump Packages, Safety Showers).

02

Accountability & Roadblock Resolution

A 'Blockers' matrix assigning ownership for hurdles (TSF Design, water management).

03

Recovery Plan Execution

Monitored 60+ sub-initiatives, driving 31 actions to verified completion.

Strategic Business Impact04 / 27
C Delivery

End-to-End Ownership & Technical Execution

04 / 27
01

Data Integration & Modeling

Unified tracking logs from supply chain, engineering, and operations into one model.

02

UI/UX & Business Intelligence

Distribution charts, status color coding (At Risk, Delay, Hold), temporal slicers.

03

Process Standardization & Change Management

Embedded into weekly leadership reviews as a single source of truth.

Power BIProcurementRecovery PlanBlockersProject Controls
Technical Execution04 / 27
ContinueCase 04 / 27