Case Studies

Data Download, Analysis, Validation & Migration

Solution Overview

• 5100+ Bankers Data is required to be updated for 500+ line items at a frequency of Quarterly, Daily, On Demand basis
• The application is required to re-update the data that is updated at the source on a daily basis.
• Methodology
  • Download the Data
  • Validate the Files
  • Read the Raw Data
  • Convert the data from Year-to-Date (YTD) format to Quarterly
  • Migrate the data to main database.
  • Generate post data migration operations
  • Validate the overall data

Challenges / Business Problem

Build product with features like:

• Ability to download the data at a frequency of daily, quarterly, ad-hoc & manually.
• Import 6500+ data file.
• Validate the file & generate a log.
• Extract 500+ line items from the raw data.
• Convert the data from YTD to Quarterly.
• Migrate the data.
• Validate the overall data and generate a status report.
• Perform post update operations.