A global financial services
client’s growth was quickly exceeding the capacity of their database
infrastructure. Further, the costs of
maintaining the existing environment was increasing at a rate greater than the
value received. To this end, the client
determined that if many of the existing data exchange and integration
applications in question were replaced and then decommissioned it would not
only reduce the operations costs but also reclaim much of the business value
lost to the struggling platform and processes.
Solution:
CapTech conducted an
assessment of the legacy data exchange and integration applications to
prioritize the top 100 of the most critical data exchange and integration
applications that must be replaced and decommissioned. In addition to this priority list, CapTech
provided the project management, overall strategic direction, risk management,
and detailed planning for the effort, as well as the system analysts of the
functionality provided by the legacy applications, managed the migration queue
based on business priority, and wrote design documents for the new data
exchange and integration applications.
While leading this effort to decommission these legacy applications and
data structures, CapTech performed the test planning for the project, wrote
test cases, generated test data, and validated the results for each migrated
application.
Tools:
Unix Korn shell
Oracle
Teradata
Microsoft Project
Ab Initio
Microsoft Visio
Mercury TestDirector
Results:
Reduced
system maintenance and support cost based on decommissioning of legacy ETL
applications.
Reduced
system maintenance and support cost based on reduction of disk capacity
required for ETL applications.
Stable ETL
production environment that supports the growing needs of the client.