Case Study: Nasdaq achieves streamlined data warehouse management with PM AM Corporation

Nasdaq - Customer Case Study

The client, a Nasdaq-listed insurance group, faced significant challenges after a period of inorganic growth through acquisitions. They inherited a complex IT landscape with multiple databases and applications, including SQL, Oracle, and flat files, that were costly and tedious to maintain. This disparate data environment prevented a unified view of their business, hampering reporting and decision-making. PM AM Corporation was engaged to design a comprehensive data warehouse management system to consolidate all data into a single source and eliminate the dependency on numerous legacy systems.

PM AM Corporation developed and implemented an automated solution built around the Argo data warehouse (DWH). Their approach involved creating a new, de-normalized data structure, developing ETL statements to feed data from all business units into the Argo DWH, and building a suite of decision-support reports and dashboards. This solution provided the client's senior management and underwriters with critical, consolidated reports on KPIs, earnings, and claims activity. The results for the client included minimized manual efforts, eliminated upgrade costs for multiple legacy databases, reduced operational costs, and faster access to integrated information for proactive decision-making.

Nasdaq