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 projects.

Master Data Management Case Study: Department of Social Services, State of Connecticut

The Department of Social Services (DSS) in the State of Connecticut required advisory and technical resources to support tMaster Data Management Logohe enhancement, management, and operations of the Enterprise Master Person Index (EMPI) platform.

EMPI, and the supporting Master Data Person Index infrastructure, is intended to provide a single gateway to link citizens more effectively to a broad range of DSS programs and services. EMPI supports the State’s vision of a “No Wrong Door” to provide access to services and to implement technical capabilities to maintain consistent and accurate client information between agencies, and to breakdown “silos” between various programs to provide a holistic view of a client’s experience, to improve outcomes, and to avoid costs.

The Solution

CMA applied an incremental approach to the project. MDM is a complex and time consuming process. The key to success is to implement MDM incrementally, so that the organization realizes a series of short-term benefits while the complete project is a long-term process. No MDM project can be successful without the support and participation of the business users. IT professionals do not have the domain knowledge to create and maintain high-quality master data. Any MDM project that does not include business changes to the processes that create, maintain, and validate master data is likely to fail.

The Results

The EMPl project established a cross-agency team tasked with data ·governance and stewardship, and is planned as a core component of the Connecticut’s Enterprise Master Data Management platform. CMA currently supports the integration of Connecticut’s Eligibility and Health Exchange systems into the existing Nextgate EMPI. CMA plans to be advising Connecticut on its future EMPI architecture and the integration of other systems into the EMPI.

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