FHLB New York – Database Platform Migration

Helped the client successfully test and migrate from its legacy Sybase Database platform used by a large number of applications over to SQL Server. Thus, reducing operational/migration risks, and zero downtime with smooth transitioning during the migration process.

  • Planned and coordinated testing of all applications and reports.
  • Defined a detailed Test Strategy to mitigate the risk for the bank by ensuring all the applications and reports are validated and tested.
  • Performed ETL testing covering all database tables.
  • Comparative analysis of the tables to include data comparison to ensure minute difference or discrepancy are identified and triaged during the testing phase.
  • Shared with clients the detailed and accurate status reporting on different work items thus reflecting the overall health on real time basis.

Outcome

  • Performed comparative analysis of over 256 QlikView and Crystal Reports.
  • Performed ETL validation of over 669 dataflows.
  • Reviewed/Analyzed/Executed and validated different UNIX scripts and Tidal Jobs to validate expected behavior and ensuring that all the defects encountered are reported to ensure database transition.
  • Reporting all the defects or discrepancies in a detailed pre-defined standard format to ensure minimal ambiguity and precise details to help ensure efficient root cause analysis
  • Develop test strategy for Database, Functional, ETL Testing, Automation Testing using HP UFT, Report Testing
Share This
Industries
Capabilities
Scope Of Service