Data Migration ETL using SSIS

Migrated entire company’s CRM data from Goldmine to on-premise Dynamics CRM with Outlook using SSIS and Kingswaysoft to create asynchronous ETL application .

Features:

  • Collaborated asynchronous .Net ETL application that leveraged SSIS to migrate ~500K emails
  • Leveraged Kingswaysoft SSIS plugin to assist in data-mapping
  • Configured Outlook to sync with Dynamics CRM and be optimized for duplicate detection
  • Adapted existing Goldmine data model to Dynamics CRM to maintain company business logic complete with development of entities, workflows, views and dashboards
  • Developed custom plugins to increase email tracking visibility and record ownership
  • Collaborated with Network administrators to debug deployment and connectivity issues
  • Conducted training program on interfacing Dynamics with Outlook