Data Migration ETL using SSIS
Collaborated on an asynchronous ETL application (Extract Transform Load) to routinely migrate financial transactions for a government entity handling statewide financial data
Features:
- Orchestrated multiple SSIS packages to asynchronously migrate ~1M financial and transactional records daily
- Indexed relevant columns and followed best practices in table normalization to optimize query performance
- Configured Change-Data-Capture (CDC) to monitor data changes and replace existing triggers impacting performance
- Created user functions and staging tables to accommodate time zone differences in UTC and to track changes
- Collaborated with Database Administrators to implement High Availability and Disaster Recovery (HADR) redundancy

Notice: compact(): Undefined variable: limits in D:\home\site\wwwroot\wp-includes\class-wp-comment-query.php on line 853
Notice: compact(): Undefined variable: groupby in D:\home\site\wwwroot\wp-includes\class-wp-comment-query.php on line 853