Social Network

data handling - thinkinno

Data Handling, Analysis, Validation & Migration

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

    • Web Apps

 Solution Overview

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

Challenges / Business Problem

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

 

Enquire Now