We provide IT Staff Augmentation Services!

Integration & Data Migration Lead Resume

St Louis, MO

EXPERIENCE SUMMARY:

  • I am a skilled professional in Information Technology with over 23 years of IT Consulting experience across multiple industries, technologies, and database platforms in the CRM space.
  • I have been involved in numerous packaged software systems developments and implementations (On - Premise and Cloud Solutions) and have achieved masterly levels of experience in areas of integrations, data migrations, data conversions, and package software solutions and development.
  • I have used this broad spectrum of knowledge and previous experiences to adhere to the development standards and best practices to implement reusable solutions which has led to a strong track record of successful implementations and deployments.
  • I also have great communication and interpersonal skills which enables me to effectively interact with co-workers and client personnel of diverse backgrounds and levels of experience.

SKILLS:

  • Siebel Application Software C Oracle Database Platforms
  • Siebel Tools Visual Basic Oracle SQL Loader & SQL Plus
  • Siebel EAI Architecture SQL, PL/SQL, T-SQL Oracle Import & Export Utilities
  • Siebel EIM Integration Batch Scripting MS SQL Server Database Platforms
  • Siebel VB Script & eScript Batch Integration MS SQL Server DTS Package Design (ETL)
  • Siebel Workflow & Asgn Mgr Database Design MS SQL Bulk Copy Utility (BCP)
  • Systems Integration AutoSys Job Scheduler IBM DB2 Database Platforms
  • Application Development MS Access Programming MS Access Database
  • FirstLogic IQ8 Cleansing/Matching Software Data Mapping
  • FirstLogic IQI Data Audit Informatica (ETL) MS Visual Source Safe
  • Oberon Prospero (ETL) Data Junction (ETL) Salesforce
  • Alteryx Designer MS Dynamics Salesforce Apex Data Loader
  • SDLC (Software Development Life Cycle)

EXPERIENCE:

Confidential, St. Louis, MO

Integration & Data Migration Lead

Responsibilities:

  • Worked on a Salesforce Sales & Marketing Implmentation utilizing the Agile Delivery Methodology.
  • Led and asssited the integration effort for new/updated integrations between Salesforce and SAP, eCommerce (utilizing Alteryx Designer), and SAP Quote and Order Headers w/ MicroServices.
  • Managed the data migration activities and provided input and advice when when necessary.
  • Documented the field mappings compilation across each Salesforce Environment Sandbox to ensure the correct Salesforce fields were propogated to Salesforce Production.
  • Created Integration Approach & Design Document, detailed Integration Test Plans, and Test Scripts.

Confidential, Chicago, IL

Integration Lead (Salesforce)

Responsibilities:

  • Led the integration effort for enhanced and new integrations for an existing Salesforce environment.
  • Worked with the business to gather the technical requirements for the integrations.
  • Created and provided the Integration Design documents for the first phase of the implementation which detailed the enhanced integrations, the new integrations, and the targeted data field mappings.

Confidential, Harrisburg, PA

Data Migration Analyst (Salesforce)

Responsibilities:

  • Created and updated User Stories for the Salesforce business requirements.
  • Modified, compiled, tested, and executed Data Migration SQL Procedures.
  • Worked and communicated directly with the client to achieve the desired solution.
  • Documented and provided knowledge transfer information regarding the data migration for turnover and furture and use.

Confidential, Parsippany, NJ

CRM Data Conversion Analyst

Responsibilities:

  • Worked on a Global Country CRM Data Migration Deployment as a Data Conversion Analyst for a MS Dynamics Cloud implementation which included data migrations from various Countries and CRM source systems such as Siebel, Salesforce, Veeva, Teams, eSalesWeb, EpiServer, etc.
  • D ocumented the data analysis results of hundreds of source data files from multiple countries and application systems, which was thorugh, detailed and specific.
  • Created, developed, and provided specific data mapping documents to the development team required for the coding and development of the data migration processes via MuleSoft and Talend ETL.
  • Led meetings with the Off-Shore Team to track progress and assist with migration trouble-shooting.

Confidential, Minneapolis, MN

Data Migration Lead (Salesforce)

Responsibilities:

  • Successfully lead the Salesforce Data Migration Deployment effort while quickly gaining the confidence and assurance of the team and client by displaying my knowledge, skill set, and abilitities.
  • Provided data migration assistance for the next deployment phase by developing and testing Salesforce Data Loader for the additional data object loads required for the next phase.

Confidential, Atlanta, GA

Data Migration Lead (Salesforce/ServiceMax)

Responsibilities:

  • Managed the data migration effort and activities for a mult-country deployment and worked with the business to define, confirm, and finalize the data object scope for each country deployment.
  • Developed source-to-target data mappings with transformation rules and Salesforce Apex Data Loader Processes to migrate various data objects into Salesforce and created a Data Migration Plan document.
  • Designed, developed, and implemented a business process to enable and automate a Cusomter Mass Load procedure using Apex Data Loader and used Report Manager to analyze the results.
  • Created ‘Lessons Learned’ documents after each country release to improve upon the data migration process for future Salesforce/ServiceMax Data Migration Deployments.
  • Provided Post-Data Migration Support to address and resolve any data migration issues encountered.

Confidential, Waukesha, WI

Integration Lead (Salesforce/ServiceMax)

Responsibilities:

  • Documented a complete, thorough, and in-depth analysis of the current Siebel integration platform and how it will transform to the future Salesforce/Servicemax integrations for the Field Services release.
  • Worked with the client’s Integration SME to gain an uderstanding of the current integration platform and architecture and to asses the integration transistion from Siebel to Salesforce/ServiceMax.

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

  • Worked on a Siebel 7.8 Enhancement as a Business Analyst to analyze defects and enhancements and used the Agile Scrum Methodology to quickly resolve the defects and implement the enhancements.
  • Led work sessions with Subject Matter Experts to define, confirm, and validate business requirments.
  • Created Use Cases and Functional Design Specifications, and worked with developers to resolve defects and implement enhancements in different functional areas which varied in complexity.
  • Created Test Scripts for UAT Sessions to test essfully complete UAT activities while providing the users with a high level of confidence that the solutions would meet their business needs.

Confidential, Washington, DC

Data Migration Analyst

Responsibilities:

  • Worked on an implationation to upgrade the client’s current MS Dynamics PRM 2011 Application to a Dynamics PRM 2013 System for deployment on a MS SQL Server 2012 Database platform to increase user adoption and provide an enhanced set of featrues to manage customer and provider relationships.
  • Conduted a complete data analysis of the client’s current data set and documented the analysis results, data anomalies, and bad data occurences in a detailed Data Migration Stategy document that also provided a strategy for migration with the necessary analysis needed to make informed decisions.
  • Developed solution with MS SSIS as the data migration ETL based on source-to-target compatibility.
  • Created a Data Goverance Rules document to provide direction for cleansing the data.

Confidential, WI

Data Integration Analyst

Responsibilities:

  • Worked on a warranty solution implemented with PTC iWarranty software and deployed on an Oracle 11g Database platform which allowed the client to standardize and manage their warranty processes.
  • Responsible for all mapping exercises and created detailed CSV & XML data mapping documents for the integrations between the target system (iWarranty) and the source ERP systems (JDE 7.1 & 8.1).

Confidential, Mooresville, NC

Siebel Data Consultant

Responsibilities:

  • Worked on Siebel Call Center & Sales 8.1.1 Implementation releases deployed on a DB2 platform.
  • Designed, development, tested, and the deployed the Siebel EIM Data Conversion & On-Going Daily Integration Processes for all releases in addition to creating the Zena Job Automation Unix scripts.
  • Created the data mappings and technical designs, and worked with a 3rd-Party Integrator to ensure the mainframe data extraction processes where built according to the data mappings documentation.
  • P articipated in the deployment planning and production rollout of all releases and managed the data migration integrity check-points of the data load processes and provided post-production support.

Confidential

Senior Siebel EIM Conversion Consultant

Responsibilities:

  • Worked on a Siebel Field Service 7.8 enhancement implemented on a Unix/Oracle 10g platform.
  • Developed Siebel EIM Conversion Processes for converting existing Activities into Service Requests, SR Details, Notes, and Attachments which translated into the conversion of nearly 11 million records.
  • Programmed Oracle PL/SQL scripts to extract, transform, and load conversion data into the target Siebel EIM Tables and created EIM Configuration Files (ifb) to import the data as parallel processes.
  • Worked with DBA to implement best performance practices for migrating large volume data loads.

Confidential

Senior Siebel CRM Consultant

Responsibilities:

  • Developed, tested, and deployed multiple Enhancement Projects for a Marketing Database Services Implementation which included processing Campaign Responses from additional sources.
  • Performed data conversions of Account, Contact, Campaign, and Lead data into a marketing database.
  • Technology Utilized includes SQL Server 2000 Database, SQL Server T-SQL Stored Procedures, SQL Server DTS Packages, and Batch Scripting for error handling and automated execution.

Confidential, Chicago, IL

Senior Siebel EIM Conversion Consultant

Responsibilities:

  • Worked as the Conversion Team Lead on this full life-cycle Siebel Automotive 8.0 Project on a Windows/Oracle 10g database to enhance Confidential ’s Sales, Collections, and Repossession processes.
  • Collaborated with client SMEs to identify the source data needed for the conversion technical design.
  • Created SQL Scripts to extract data files from the DB2, MS SQL Server, and Oracle source databases.
  • Programmed SQL Loader to load extract files into the Siebel EIM Tables.
  • Created PL/SQL Scripts for transformations and Siebel EIM scripts to import the data into base tables.
  • Converted data for the Dealer, Customer, Contact, Vehicle, Repossessions, and Activities data entities.
  • Responsible for managing 1 Extraprise personnel.

Confidential

Senior Database Marketing Consultant

Responsibilities:

  • Participated as a Data Marketing Analyst, Designer, and Developer on a Database Marketing Services Implementation to enhance Business Insight, Campaign Management, and Strategic Marketing.
  • Conducted a data analysis and audit of Lawson’s data from legacy sources and provided input for designing the Lawson Marketing Datamart data model and creating the technical design.
  • Developed code for custom marketing database and executable programs for data conversions, batch interfaces, FirstLogic Cleansing Routines, T-SQL Stored Procedures, and SQL Server DTS Packages.
  • Performed UAT Testing, debugging, and provided Post-Production support.

Confidential

Senior Database Marketing Consultant

Responsibilities:

  • Worked on a Marketing Database Services Project to assist the client with improving sales effectiveness through the delivery of higher quality Leads, Opportunities, and Campaign Management.
  • Developed, tested, and deployed code (T-SQL sp, DTS Packages, Batch Scripting for error handling and automated execution) on a MS SQL Server 2000 Database for loading Leads and Opportunities.

Confidential, San Francisco, CA

Senior Siebel Consultant

Responsibilities:

  • W orked on an implementation to upgrade from Siebel 6.2 to Siebel eConsumer Goods Call Center 7.7.
  • D esigned and developed a data migration process to migrate data from Siebel 6.2 to the Siebel 7.7 database on an Oracle 8i database platform.
  • Leveraged prior Siebel EIM expertise to develop EIM as the primary migration tool, and Oracle PL/SQL scripts and Oracle Import/Export Utilities to successfully migrate the delta data.

Confidential, Chicago, IL

Senior Siebel Consultant

Responsibilities:

  • Worked with the client Enterprise Architects to gather requirements for redesigning the Approval Process within a Siebel Sales 7.7 Implementation on a Windows/Oracle 9i database platform.
  • Delivered a technical design which included detailed design specifications for interfaces, database extensions, UI configuration, Workflows, Business Components, and Business Services.
  • Managed the team’s contributions to the technical design to ensure all input was valid.

Confidential, New York, NY

Senior Siebel Consultant

Responsibilities:

  • Worked on an Integration Assessment the of Bowne’s desired CRM platform to upgrade from Siebel Sales 6.3 to Siebel 7.7 which included scope, effort, and integration approach and methods.
  • Facilitated meetings with client subject matter experts to acquire system knowledge and to identify the future integration touch-points between the client’s corporate systems and the Siebel Sales 7.7 system.

Hire Now