Leading investment advisory firm with more than 10,000 employees and greater than $1 billion in revenue—a major player in the financial services industry.
The client’s IT group struggled to keep their governance and planning efforts moving at the pace of business. They’d attempted to centralize their data sources and generate more actionable reporting, but their outdated infrastructure couldn’t meet increased information demands or integrate effectively with their BI reporting. To solve these issues, the client was tasked with moving their data warehouse to a more modern solution.
The Ironside Information Management team worked hand-in-hand with the client’s database engineers to move the warehousing infrastructure out of the current obsolete environment to a more modern data warehouse. Our solution required us to:
Develop a Migration Plan
Outline a plan that addressed pain points occurring between the data warehouse and the Cognos BI reporting layer, increased query efficiency, and enabled timely analytics
Include recommendations for storing historical point-in-time data for more accurate referencing of past events
Document and Test
Document existing warehouse logic, including extracts, transformations and schedules
Serve as the solution architect for a proof of concept of the data warehouse redesign
Test data handling and report output using POC system
Bring together approximately 20 tables from an array of data sources, including TM1, A-Track, Remedy, Oracle GL, and Excel, into an IBM PureData for Analytics (Netezza) implementation capable of meeting and exceeding client requirements
Reengineer both the ETL processes used to move and transform all the different information streams and the reporting layer making that information available for analysis
KEYS TO SUCCESS
The modernizing of the data warehouse has enabled the client to:
Improve ease of use and performance in Cognos reporting
Enable time comparison reporting, such as evaluating last month’s data against today’s data
Increase performance approximately 60 times faster than with the previous environment—reports that used to take two minutes to run are now taking two seconds
Ironside helps companies translate business goals and challenges into technology solutions that enable insightful analysis, data-driven decision making and continued success. We help you structure, integrate and augment your data, while transforming your analytic environment and improving governance.