Address

Registered Office
B-602, Radha Apt, Ranisati Road,
Malad (East), Mumbai - 97.

Contact Us

Email: info@thinkinno.com
Phone USA: +1-331-333-6829
Phone India: +91-932-268-9919

Social Network

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
Enquire Now