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.