We provide IT Staff Augmentation Services!

Crm Etl Developer / Etl Tester Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • 2+ years of hands - on experience in analysis, installation, configuration, development, customization, testing and extension of Web and Windows applications using Microsoft technologies like MS Dynamics CRM and SQL Databases.
  • Experience in working with teams comprising of IT Project managers, Supervisors, Software Developers, Quality Assurance Analysts, Product Owners, Business and Technical Analyst covering the entire life cycle of a project’s planning, implementation, testing & delivery.
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) & SQL Server Integration Services (SSIS) with the ability to write and interpret queries written by others.
  • Experience in MS Dynamics CRM Data Integration towards import/export of data using SSIS.
  • Designed and developed SSIS packages for data migration into MS CRM 2016/2015/2013 from different sources systems such as XML, Flat files, MS Excel files, using custom Data Migration utility Visual Studio and Kingsway Soft SSIS Integration Toolkit for MS CRM.
  • Involved in creating test data files to verify the functionality of the ETL process by verifying data from Source to Stage, ODS and Data Mart.
  • Worked in all Project Management (Agile, Scrum) teams and used TFS and Azure to manage projects.

PROFESSIONAL EXPERIENCE

Confidential

CRM ETL Developer / ETL Tester

Responsibilities:

  • Worked with other Business and Technical Analyst developing queries and store procedures in SQL to help identify, stop, and delete the duplication of records in the database.
  • Facilitated requirements-gathering meetings and problem resolution meetings with internal teams and product owner.
  • Involved in creating test data files to verify the functionality of the ETL Process by verifying data from Source to Stage, ODS, data warehouse.
  • Designed ETL Solutions including preparation of detailed design documents, test plans and deployment strategies.
  • Created source to target mapping and ETL design for integration of new/modified data streams into the date warehouse data.
  • Worked hands-on with data using SQL, CRM Dynamics, Visual Studio, Kingsway Software, Active Batch, to extract analyze, visualize data an schedule and execute SSIS package to migrate data from different sources to other data bases and CRM Dynamics.
  • Checked daily report for Active Batch process to make sure all ran with no errors. When errors occurred created bugs in MS Azure.
  • Involved in Data migration testing, created test cases and executed test scripts using MS Azure and MS Excel.

Environment: MS Outlook, Skype, MS Excel, MS Word, MS Azure, SQL Server 2012, Dynamics CRM, Visual Studio 2016, XRM Toolbox, Kingsway Software, Active Batch, SQL Server Integration Services SSIS, SQL Services Management Studio SSMS.

Confidential, Phoenix AZ

ETL / Dynamics CRM Developer

Responsibilities:

  • Gathered business requirements from stakeholders and converted them into Use Cases and activity diagrams.
  • Work closely with other Business Analyst, Project Manager, CRM & ETL developers, to create comprehensive solution approaches.
  • Prepared mapping documents to migrate the data from legacy CRM application and SQL Databases to Dynamics CRM 365.
  • Configure and Customize the Dynamics CRM 365 using out of the box functions.
  • Developed complex SQL scripts and store procedures to identify and eliminate duplicate records in the databases.
  • Migrated the data into Dynamics 365 from various databases and other CRM applications by creating and deploying SSIS Packages and KingswaySoft Dynamics 365 connection manager to integrate the data from sources to new CRM to make data available to the end users.
  • Gained exposure of working on Agile Scrum Methodology.
  • Experienced in the preparation of test scenarios, test cases and execution

Environment: MS Outlook, Skype, MS Excel, MS Word, MS Azure, MS PowerPoint, SQL Server 2012, Dynamics CRM 365, Microsoft CRM 2013, Visual Studio 2016, XRM Toolbox, Kingsway Software, Active Batch, SQL Server Integration Services SSIS, SQL Services Management Studio SSMS.

We'd love your feedback!