Executive Risk Dashboard

Drove operations executive decision-making through agile data system development

Impact by the Numbers

50+ FTE Hours/week Time Savings

$1MM+ ARR Service Contract Signed

10+ Source Systems Reconciled

Skills Demonstrated

  • Data Analytics
  • Agile System Development
  • Team Management
  • Executive Facilitation
  • Operations Management
  • Business Case Creation

Context

Deloitte was engaged to support a large-scale operations transformation for a large oil & gas pipeline company ($35B+ ARR). In the wake of recent safety incidents, the company was looking to overhaul their asset reliability systems, processes, and organizational structure for managing risk & safety across 18,000+ miles of pipe, 300+ employees, and 7 primary risk vectors.

My Role

As an operations transformation consultant, I was assigned ownership of a core pillar associated with the transformation: Risk Analytics. I began by interviewing 10+ functional group managers to understand their current pain points and needs as it related to gathering, processing, reporting, and acting on risk & operations data, organizing them into user stories to build out an agile backlog. I also performed analysis across 10+ source data systems to identify sources of truth and flow of information across the organization to better inform the future state system architecture.

With a clear understanding of the current state, I worked with my team to mock up 40+ potential metrics, designed to rapidly convey the state of operations & risk management to an executive audience. I then led a team of 5 operations executives through a series of workshops to refine and prioritize the most impactful metrics. I also worked with our client sponsor to develop a business case for a dedicated team to develop a data system to support the dashboard on an ongoing basis, representing a service contract of $1MM+ ARR.

With the business case approved, I led a first-of-its kind agile team of 6 analysts, designers, data engineers, and solution architects to develop, test, deploy, and refine the dashboard and underlying data system based on regular user feedback. As we implemented and iterated on the dashboard, our executive audience incorporated it into their weekly operations review meetings (total usage grew from 0 to 10+ weekly viewing hours amongst executive users). Additionally, the dashboard and underlying data system saved 50+ FTE hours/week previously spent to gather, analyze, and report on operational risks.