+1 571 446 0890

Home » Portfolio » Enterprise Data Integration

Enterprise Data Integration

EDI and ETL implementations to facilitate Data Source Integration.

Approach:

  1. Documented fields from the LOB data that needed to be consumed by the Reporting Dashboard.
  2. Developed Report Data Interface to facilitate development of EDI end point and integrated with LOB Data using MS SQL Server.
  3. Implemented ETL Scripts using SSIS / BizTalk and SQL Stored Procedures to facilitate load of LOB Data into Custom Application
  4. Designed and Developed Jobs to execute in a timely fashion to execute the ETL Scripts and load data.

Key Achievements:

  1. Standardized Data interfaces facilitate extensibility across organization and disparate data sources.
  2. Performance Improvements of ETL Scripts ensured near Real time Data availability.