Information Governance & Data Quality
The Company is an insurance holding company that is among the largest commercial lines writers in the United States and operates worldwide in two segments of the property casualty insurance business: Insurance and Reinsurance. Each of the operating units within the corporation participates in a niche market requiring specialized knowledge about a territory or product.
Information within the transactional database requires “checks and balances” to ensure that the data quality of the records is maintained. These checks include areas related to mapping, dependency, financial integrity, formatting, general ledger, linking and population. The errors are classified as fatal, critical and quality and any items with a fatal status require immediate action to fix the problem.
These checks are needed across the many companies within the organization and the many users within each company. A centralized web portal was needed to standardize the data quality rules across all companies and for each company to manage the quality improvements within their database.
The strategy included the implementation of the IBM Information Governance solution. The information governance data warehouse was installed including the “out of the box” metadata tools and standard IBM Cognos reports.
Using the default installation did not satisfy the data quality process for the company so a project was defined to create a customized solution. This solution included customizing the metadata in the Framework model and creating a central Data Quality Dashboard with a series of linked reports with drill throughs for end user access. The Data Quality Dashboard included an approval process that allowed users and managers to review reports and request changes to improve the quality of the data. An approval process was developed using stored procedures that tracked the approval process of each company’s report. Users and managers would then work together in an iterative approach to identify fatal and critical errors and use the approval functionality to correct the issues.
Once the Data Quality Dashboard was developed and tested, the current development team would be trained to maintain the Information Governance solution.
Results and Benefits
The Data Quality Dashboard allows the users to retrieve the data quality information they need, in a format that meets their needs, and eliminates the complexity of the underlying data. All companies can now manage their data quality from a centralized site and use the approval process to continually improve the information in their systems.
Users could now see trends in the data and identify quality gaps that would re-occur more frequently than others. This benefit gave the user the vital information to prevent future data entry errors as they manage the system records.