The client is an ancillary benefits management company. Through its comprehensive network, customer service support, and claims management services, the company assists health benefits plan sponsors expand the range of provider choices available to their payers while reducing overall ancillary benefits costs.
A centralized data repository to improve reporting.
Experiencing a period of rapid growth, the client added many new companies—and, in particular, larger companies—to its roster of customers. To deliver the value these customers expect, the company must be able to produce clear, compelling reports that document potential cost savings.
To produce these reports, employees utilized separate billing, provider, and payer systems—each of which wrote similar types of information to independent underlying databases within the company’s SQL Server environment. This duplication of data produced some inconsistency in reporting, depending on the database used to develop a particular report.
The client sought to develop a centralized repository for all of its data—one that would enable the company to:
For assistance, the client turned to West Monroe Partners, which offered extensive experience in business intelligence—including data warehouse development and customized reporting needs.
Current, accurate, and consistent data—every day.
The West Monroe Partners project team began by:
In the course of completing these analyses, West Monroe Partners recognized that the client’s employees referred to common data elements by different names. To address this issue, West Monroe Partners worked with the organization to develop a new and consistent naming convention, or “data dictionary,” for all key terms. Then, the project team: