Case Study: Multinational Insurance Company achieves consolidated reference-data management and improved data quality with erwin Mapping Manager (erwin)

Taking banking to the next level with metadata-driven automation

Multinational Insurance Company, a Sydney‑headquartered insurer operating across Australia, New Zealand and Asia, faced unmanageable data warehouse mappings and fragmented reference data stored in Excel, making it difficult to track ETL impacts, manage code sets, and enforce standards across monthly releases. They turned to erwin and its Mapping Manager product to standardize code set management and build repeatable processes to reduce complexity, time and cost.

By implementing erwin Mapping Manager (part of erwin Data Catalog), the Multinational Insurance Company consolidated all enterprise codes and reference data into a single repository, imported legacy data via database and Excel scanners, versioned code sets and crosswalks, and applied validation rules to cleanse data before publishing. erwin’s solution delivered immediate business value — considerable cost and time savings from standardized reference data management, streamlined legacy-to-enterprise conversions, improved governance and traceability of ETL changes, and higher data quality and trust.