All case studies Case 03 / 05
Part of: Delivery Governance System
Delivery Governance

Tools Creation

Three systems built from scratch to run the portfolio day to day — a resource calendar that evolved through three tools, a live reporting dashboard, and a three-technique estimation system.

Role
Head of PMO — designed and built every tool
Timeline
2025 — Sep 2026
Company
CRMiUM
Resource PlanningPower BIEstimation
01 — Context

One piece of the Delivery Governance System: the tooling layer — the systems that gave the PMO a shared calendar, a live reporting dashboard, and a repeatable way to estimate new work.

02 — My Role
Design & build

Designed and built each tool personally as Head of PMO, evolving them as the portfolio scaled.

03 — Challenge
01

No shared resource calendar or reporting dashboard — PMs tracked their own projects in their own spreadsheets, invisible to anyone else.

02

No consistent estimation method — every PM estimated differently, with wildly different accuracy.

04 — Solution

Resource Planning System + Project Calendar

A shared project calendar and resource plan that evolved through three stages as the portfolio scaled.

  • Google Sheets — manual tracking while the portfolio was still small
  • Jira + Activity Timeline plugin — a shared, always-current project calendar as it scaled
  • AI-assisted layer — the most recent iteration on top

RAG-Reporting System

RAG (Red/Amber/Green) status reporting aggregated into portfolio-level Power BI dashboards, giving C-level executives real-time visibility across the full project portfolio.

Estimation Approach

Estimation combined three techniques: PERT (three-point estimation) for the PM's own figure, analogous estimation against prior similar projects, and expert/group estimation (Delphi-style) to sanity-check the number before committing it.

05 — Results
0 tools built to run the portfolio
0+ projects tracked through them
06 — Skills
Tool DesignPower BIResource PlanningEstimation