EDI and ETL implementations to facilitate Data Source Integration.
Approach:
- Documented fields from the LOB data that needed to be consumed by the Reporting Dashboard.
- Developed Report Data Interface to facilitate development of EDI end point and integrated with LOB Data using MS SQL Server.
- Implemented ETL Scripts using SSIS / BizTalk and SQL Stored Procedures to facilitate load of LOB Data into Custom Application
- Designed and Developed Jobs to execute in a timely fashion to execute the ETL Scripts and load data.
Key Achievements:
- Standardized Data interfaces facilitate extensibility across organization and disparate data sources.
- Performance Improvements of ETL Scripts ensured near Real time Data availability.
