Company - This healthcare organization runs one of the largest hospital organizations in the world. With ivy-league affiliation, they manage 6 large hospitals and over 25 realted centers.
Project - This hospital had little analytics or an overall strategy toward the $1 billion they spend in labor-related costs. While much of this area is governed by various work rules, regulations, and subject to ongoing labor negotiation, Finance wanted to ensure efficiency in this area.
Strafford engaged to assist with a comprehensive "framework" that could be used for evaluation of labor spend, from the CFO's office right through to the nursing shift supervisors. Our Business Intelligence practice, utilizing Strafford's proven "Front to Back" process and healthcare expertise, was able to work with functional areas across the organization to build a comprehensive metrics framework. This framework needed to integrate data automatically from multiple systems and allow focused reporting and analysis at various levels of the organization as well as across different departments with varying business rules and calculations.
As with any large organization, this healthcare organization had a multitude of sources systems and data spread across the enterprise. Concurrent with iterating to a data model driven "framework", we completed analysis of the types and quality of data across the numerous systems used to plan labor, record time and attendance, as well as track expenses between employees and a number of contract organizations. Working with the internal team, a "proof of concept" was successfully run that was transitioned into production.
While work in labor analytics can be an ongoing process, this organization now has a comprehensive framework, a production system, and a direction toward increased analysis and "performance management" in the labor-spend area.