Customer Success Story

Hospital and Health Plan System Modernizes HR Data and Analytics Framework to Enable National Labor Negotiations

How We Created Value

  • Automated manual data ingestion from PeopleSoft into Cognos, retiring MS Access

  • Developed a uniform data view of wage and benefit expenses for all regions and unions

  • Created data-informed narratives and financial story for Regional CFOs and labor leadership as starting point for negotations

Industry

Healthcare

Technology

PeopleSoft, Microsoft Access, Cognos Analytics, SAS

Strategic Challenge

A trusted national brand aimed to expand its auto repair business by opening five locations per year but, relying on traditional decision-making, shrank from two locations to one unprofitable site over four years.

Mergers & Acquisition (M&A) was a key element of the inherited strategy, however there was no plan to integrate operating systems or data across locations.

Solution

We refreshed the strategic plan - operations strategy, market strategy, and data strategy - emphasizing data analysis, insights, and evidence-based reasoning. We prioritized tactics based on the agreed upon strategy to deliver value for the organization, driving 143% CAGR over the ensuing four years. Our key successes were:

  • Creating operational alignment across locations, successfully integrating multiple operating systems (OS) and databases into one scalable OS and one data warehouse.

  • Developing a culture of data-informed decision making as the catalyst for real estate and M&A business cases to be approved and expanding the footprint from one metropolitan area into five.

  • Innovating digital customer experience based on common understanding of business opportunity across operations, marketing, and finance, driven by data analysis.