Data Migration ETL using SSIS

BuiltĀ  an asynchronous ETL application to migrate entire company’s CRM data from Goldmine to on-premise Dynamics
using SSIS

Features:

  • Collaborated on asynchronous ETL application that leveraged SSIS to migrate ~1M emails
  • Configured Change-Data-Capture (CDC) feature in SQL to maintain data integrity
  • Leveraged KingswaySoft SSIS plugin to assist in data-mapping
  • Developed custom plugins to increase email tracking visibility and record ownership
  • Adapted existing Goldmine data model to Dynamics CRM to maintain business processes in entities, workflows, views
    and dashboards
  • Collaborated with network administrators to debug deployment and connectivity issues