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