Data Consolidation Case Study

A leading Fortune 100 financial services firm with $450B+ AUM, considered the top provider of retirement services nationwide to non-profit organizations.

Challenges:

To improve the accuracy, timeliness and consistency of information distributed across the organization, the Client is consolidating a large number of disparate internal and external data sources – each with their own deficiencies – into one central data warehouse.  Interim solutions had to be developed in collaboration with Operations.  Oversight and project management was needed for work streams that have been established to define the technical solution’s long-term as well as short-term requirements.  A Test Plan had to be developed in addition to coordinating the user acceptance testing with the various work streams.  IT functional requirements and deliverables had to be monitored and reviewed.

IKINDI Solution:

IKINDI provided project management, business requirements analysis and definition, leadership in user acceptance testing, and the required interface with IT and business management.

Results:

IKINDI’s solution, in particular project management and leadership in user acceptance testing, contributed to the successful deployment of Phase 1 of two tactical solutions involving various external data sources resulting in:

• 73% increase in data elements available for reporting
• 57% increase in funds available for reporting
• Enhanced data integrity, accuracy, reliability and timeliness of data (including AUM and market value data)
• Improved overall automation, leading to increased internal staff productivity.

IKINDI delivered significant improvements and efficiencies at a scaleable cost with lasting solutions offering great value to the firm.