preloader
Thinkinno Technologies Pvt. Ltd.
Thinkinno Technologies Pvt. Ltd.

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

Solution 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.
More About

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.

User Overview

Region

USA

Industry

Banking

Project Overview

Schedule

2-4 weeks Sprint – iterative method 

Team Size: 3

Technology

Dev Tools

  • 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

X