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.
Overview
Client & Users
Region : USA
Industry : Banking
Project Overview
- Schedule : 2-4 weeks Sprint – iterative method
- Team Size : 3
Technology
Dev Tools
- MS Visual Studio 2013
- MS SQL Server 2012
- .NET Framework 4.5
- LINQ
- WCF – Windows Communication Foundation
- MS FxCop
- MS Excel
- MS Word
- MS Project