Master Data Management Case Studies & Success Stories - CMA

Master Data Management Success Stories

Looking for Master Data Management case studies? With goals that include breaking down silos, improving performance management, and avoiding extra cost, CMA’s Master Data Management (MDM) work includes developing, maintaining, and operating MDM platforms. We possess more than 15 years of experience in MDM, including the following project.


Master Data Management Case Study: Office of Mental Health, State of New York

The NYS Office of Mental Health (OMH) required the integration of 14 different systems, including various OMH patient registration systems and Medicaid, into a single Enterprise Master Person Index (EMPI).

The Solution

Data was extracted from Oracle Data Warehouse tables as well as flat files. There were unique challenges with integrating the diverse sources including poor population of demographic data and lack of unique identifiers across the enterprise. Tools from the Informatica suite were used to accomplish the task. Informatica Data Analyst was used to interrogate the data sources including data population, data quality and domain analysis. Informatica Power Center mappings were used to implement business rules and standardize data across the Enterprise. This included the use of Address Doctor, which is part of Informatica Data Quality, to standardize and validate addresses. In addition, Informatica mappings were employed to do pattern analysis. This analysis allowed critical data identifiers embedded in text fields, such as address and alias, to be extracted and used in the matching process. Pattern analysis was also employed to provide data quality scores of data fields, at a person level, so that only data of a reasonable quality was used in the matching process.

The architecture of the Informatica process was designed so that the resulting standardized data feeds could be easily fed into a variety of EMPI systems. Initially, the Nextgate EMPI system was configured to utilize the standardized data feeds; at a later date the process was migrated to the IBM Initiate EMPI product with minimal conversion effort.

The Results

The EMPI is employed by the Mental Health Background Check (MHBC) system, which is used by sheriffs across NYS to process pistol permit applications. It is also employed by a variety of other critical systems designed to support quality improvement and clinical decision-making in the New York State (NYS) Medicaid population (PSYCKES & MAPP) as well as overall performance management and evaluation for OMH programs.

Informatica Identity Resolution was also employed to match vendor and provider records so that a Golden record could be provided as part of a state-wide vendor conversion process. In addition, on a pilot basis, matching results using Identity Resolution were compared against the matching results of the Nextgate and Initiate EMPI. The results compared quite favorably; in addition, Identity Resolution was a much easier tool to configure and thus took much less time to implement a matching routine.

To learn about the approach CMA recommends, download our whitepaper, “Creating a Master Data Environment: An Incremental Roadmap for Public Sector Organizations.”

Request the Whitepaper