Data Handling, Analysis, Validation & Migration

Client Overview

4000+ Bankers Data is required to be updated for 500+ line items at a frequency of Quarterly, Daily, On Demand basis.

Challenges / Business Problems

Build product with features like

Ability to download the data at a frequency of daily, quarterly, ad-hoc & manually.

Import 5000+ 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.

Soluion Overview

4000+ 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.
Validate the Data.
Generate post data migration operations.
Validate the overall data & results.
Manage Products and pricing retailer wise.
Manage discount for retailers

Schedule

2-4 weeks Sprint – iterative method

Agile iterative development cycle

Team Size

3 Experts

Developers, Analysts & QA Engineers

User Overview

Region

USA

Industry

Banking

Technologies

MS Visual Studio 2017

MS SQL Server 2019

.NET Framework 4.5

LINQ

WCF – Windows Communication Foundation

MS FxCop, MS Excel, MS Word, MS Project