We provide IT Staff Augmentation Services!

Sr. Dell Boomi Integration Consultant Resume

Houston, TX

PROFESSIONAL SUMMARY:

  • Sr. IT Professional have 14+ years of experience in Analysis, Design, Development, Testing and implementation of Enterprise Application Integration (EAI) solutions architecture in Cloud, B2B, A2A, Data warehousing and Business Intelligence architectural frameworks technologies.
  • 5 years of experience in Cloud Integrations using Dell Boomi, Informatica Cloud Services, Informatica Cloud Real Time (ICRT) and Salesforce.com via SOAP API and REST API.
  • Hands on experience in engineering Real Time, Batch and ETL Data Integration solutions between On - premise to on-premise, Cloud to on-premise and Cloud to cloud based applications.
  • Worked with Subject Matter Experts (SME), Business Analysts, Product Owners and Developers to perform development activities across all phases of project development lifecycle.
  • Have Excellent System level design, development and implementation of software applications that includes EAI & B2B integrations and extensive Data Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling.
  • Good exposure in gathering Business requirements by interacting with the business Users and perform gap analysis and feasibility study for the given requirements.
  • Accountable for providing end-to-end solutions and owned Proof of Concepts (POCs) to implement Dell Boomi new features.
  • Good knowledge in Business process analysis and data discovery experience, to be able to unlock data insights and translate that into business decisions.
  • Expertise in development of B2B Integration processes using Dell Boomi (iPaaS).
  • Good knowledge in building Boomi SOA listeners to consume when sending data into Salesforce.com via SOAP API and REST API.
  • Good Exposure on EDI (Electronic Data Interchange) Documents and X12, EDIFACT, HL7 ADT EDI Standards and experience with HIE (Health Information Exchange).
  • Hands on experience in processes Inbound and Outbound HL7 ADT Message Types: A04, A08, A28 and A31 etc. to integrate Salesforce.com with third-party applications like Athena etc. using Trading Partners in Dell Boomi.
  • Deep expertise with designing, implementing, and administering large volume Dell Boomi Integrations, Atoms and Molecules.
  • Demonstrable SaaS Integration experience with enterprise business applications such as Salesforce, UltiPro, NetSuite, Azure, Amazon AWS and Oracle fusion.
  • Hands on experience in Creating Custom Scripts for Boomi in Groovy and Java Script to handle unsupported Boomi Architecture.
  • Experience in extracting the data from different data sources i.e. Text / CSV, XML, JSON, Database, EDI and manipulating XML/JSON, and flat file documents using Java Script.
  • Good experience in Expense details information processing from UltiPro to Concur using PGP encryption, FTP and SFTP in Boomi.
  • Expertise in Salesforce REST API with OAuth 2.0 Authentication configuration setup in Dell Boomi Atomsphere and Salesforce.com.
  • Proven hands-on experience in Deploying Dell Boomi code to various environments using Environment Extensions to different Boomi Atoms.
  • Good knowledge in preparing SOQL (Salesforce Object Query Language) and data validation utilities like Salesforce Workbench and Salesforce Inspector.
  • Hands-on experience in Informatica Cloud Real-time (ICRT) with Salesforce.com to consume when sending data into Salesforce.com via Legacy Data bases like Oracle, SQL Server, DB2 and Tera Data.
  • Experience in working with different technologies like SOAP, REST, XML, WSDL and JSON.
  • Hands-on experience in implementing ETL using either native database utilities and/or third-party tools ( Informatica, Data Stage, SQL, T-SQL, PL SQL packages) in an enterprise environment with a relational database backend.
  • Experience in working with RDBMS OLTP or OLAP data stores, such as Oracle, SQL Server, DB2 and Teradata.
  • Hands-on Relational database development experience and proficiency with advanced SQL concepts such as Stored Procedures, Functions, Complex Joins, Triggers, Cursors, Correlated Sub Queries and analytic functions using SQL and T-SQL.
  • Good knowledge and work experience in extraction of SAP ECC data, RFC and R/3 generation of ABAP program and SAP BW process chain using Informatica.
  • Good knowledge and experience in Cloud and ETL Integrations Performance Tuning.
  • Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed jobs.
  • Experience in designing Slowly Changing Dimensions.
  • In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing in Dell Boomi, Informatica Cloud and On-premise Integrations.
  • Monitor the Daily Cloud and On-premise Integration Loads in Production Batches.
  • Ability to work calmly and constructively under pressure and deliver on commitments.
  • Excellent problem-solving skills with good interpersonal skills, quick learner and excellent team player.
  • Good knowledge in understanding of Agile, Scrum methodologies and Sprint plans.

TECHNICAL SKILLS:

Cloud Integration Tools: Dell Boomi Atomsphere, Informatica Cloud (ICRT), Azure APIM, Logic Apps, Data Factory, Cast Iron

Data Integration Tools: Informatica, IBM Data Stage, SSIS, Talend

Databases: SQL Server, Oracle, DB2, Teradata

SaaS Databases: Salesforce.com,NetSuite, SAP SuccessFactors, Azure, UltiPro, LDAP, Amazon AWS, Anaplan, Pegasystems

Modeling: Kimball, Inman

BI/Data Discovery Tools: OBIEE, Cognos

Tools: and Utilities TOAD, SSMS, Oracle SQL Developer, Eclipse, SQL LoaderPostman, WinSCP, Putty, SoapUI

Languages: SQL, PL/SQL, T-SQL, My SQL, SOQL

Web Technologies: Java Script, Groovy

Operating Systems: Windows, UNIX

Scheduling Tools: Control-M, UC4, TIDAL, TWS, DAC

Data Tools: Erwin, Microsoft Visio

Web Services: APIs, WSDL, SOAP, REST API, EDI, XML, JSON

Tracking Tools: JIRA, Service Now, HP Quality Center

PROFESSIONAL WORK EXPERIENCE:

Confidential, Houston, TX

Sr. Dell Boomi Integration Consultant

Responsibilities:

  • Design, Development, Deployment and management of multiple cloud Integration Processes using Dell Boomi Atomsphere.
  • Day to day client interactions in order to collect Business requirements, Analyze and implement the solutions within the scope of Dell Boomi.
  • Created different components like Connections, Connector Operations, Cross Tables, Document Caches, Mappers, Profiles and Processes using Create Component.
  • Owned Proof of Concepts (POCs) to implement or add any new features with Boomi in current project.
  • Developed and extracted various types of data/documents using Profile formats like Flat File, DB and JSON to translate documents from Source to Destination using Mapper and HTTP Restful API pay-loads.
  • Developed Custom Scripts for Boomi in Groovy and Java Script to handle unsupported Boomi Architecture.
  • Loaded different types data / documents in Boomi internal memory using Add to Cache and applied unique Index to fetch the documents from Boomi memory (Load from Cache).
  • Spited the complex business logic processes into sub processes using process call shape and make the flow easier to team and for trouble shooting the issues.
  • Applied and utilized Boomi in-built features like set process property, set dynamic document property and set dynamic process property to store the documents and set wherever required to call these document property values.
  • Used Data Process Shape in various scenarios like split the document, combines the documents, search and replace, PGP Encryption and BASE 64 Encode and Decoding purposes to transform documents from Source to Destination.
  • Applied Exception Handling logic to capture process level or document level errors for one or more documents that fail during the execution using its Document Property Meta Data Base options in Try/Catch Shape.
  • Followed Boomi API management standards to send REST API calls to MCBU system like Token creation and supply relevant parameters to different HTTP API calls like GET, POST, PUT and DELETE.
  • Deployed Boomi code to SIT, UAT and Production environments using Environment Extensions feature for different Boomi ATOM’s to use unique Boomi code and configured connection details in Atom Management.
  • Performed Unit Testing after Developing Boomi code in TEST mode.
  • Scheduled the deployed Boomi Processes using in-built Scheduling feature in Atom Management to automate the process executions on based on priority.
  • Extensively used most of the Dell Boomi shapes like Route, Branch, Add to Cache, Try/Catch, Exceptions, Flow Control, Business Rules, Decision, Cleanse, Message, Process Call, Program Command, etc. for various processes.
  • Prepared Unit Test Plans and executed the Test Results.
  • Monitor the Boomi processing log for any errors to reprocess.
  • Worked with QA team in Integration Testing, System Testing and UAT teams to analyze and resolve opened defects.
  • Created Boomi support tickets and interact with Dell Boomi support team based on priority tasks.
  • Followed trust.boomi.com for Boomi Release Management, Atom cloud statistics and other notifications to alert the system monitoring team if any major changes / releases.

Environment: Dell Boomi Atomsphere, REST API, JSON, Flat files, CSV, Postman App, Java Script, Boomi API Management, Groovy Script, SQL Server, T-SQL, Stored Procedures, Anaplan, Pegasystems, SAP, JD Edwards, Azure API, APIM

Confidential, Houston, TX

Sr. Dell Boomi Integration Consultant

Responsibilities:

  • Design, Development, Deployment and management of multiple cloud Integration Processes using Dell Boomi Atomsphere.
  • Day to day client interactions in order to collect Business requirements, Analyze and implement the solutions within the scope of Dell Boomi.
  • Created different components like Connections, Connector Operations, Cross Tables, Document Caches, Mappers, Profiles and Processes using Create Component.
  • Owned Proof of Concepts (POCs) to implement or add any new features with Boomi in current project.
  • Developed and extracted various types of data/documents using Profile formats like Flat File, XML and JSON to translate documents from Source to Destination using Mapper and HTTP Restful API pay-loads.
  • Developed and imported different types of Salesforce Operations like Query, Create, Update and Upsert to Get and Send actions using different types of Salesforce objects in Confidential.
  • Developed Custom Scripts for Boomi in Groovy and Java Script to handle unsupported Boomi Architecture.
  • Built different types of Custom Map Functions to combine more business logics.
  • Loaded different types data / documents in Boomi internal memory using Add to Cache and applied unique Index to fetch the documents from Boomi memory (Load from Cache).
  • Spited the complex business logic processes into sub processes using process call shape and make the flow easier to team and for trouble shooting the issues.
  • Applied and utilized Boomi in-built features like set process property, set dynamic document property and set dynamic process property to store the documents and set wherever required to call these document property values.
  • Used Data Process Shape in various scenarios like split the document, combines the documents, search and replace, PGP Encryption and BASE 64 Encode and Decoding purposes to transform documents from Source to Destination.
  • Applied Exception Handling logic to capture process level or document level errors for one or more documents that fail during the execution using its Document Property Meta Data Base options in Try/Catch Shape.
  • Configured e-mail connector to alert for integrations, system monitoring and business teams if any exceptions occurred during the execution.
  • Applied Error handling mechanism to alert System or Business errors to Salesforce Queue Manager.
  • Followed Boomi API management standards to send SOAP API calls to Cardinal system like Token creation and supply relevant parameters to different HTTP API calls like GET, POST, PUT and DELETE.
  • Built Boomi SOA listeners to consume when sending data into Salesforce.com via SOAP API and REST API.
  • Developed Salesforce REST API with OAuth 2.0 Authentication configuration setup in Dell Boomi Atomsphere to integrate with Salesforce.
  • Deployed Boomi code to SIT, UAT and Production environments using Environment Extensions feature for different Boomi ATOM’s to use unique Boomi code and configured connection details in Atom Management.
  • Performed Unit Testing after Developing Boomi code in TEST mode.
  • Used utilities like Salesforce Workbench and Salesforce Inspector for Salesforce data validations and generate SOQL query to verify both systems.
  • Scheduled the deployed Boomi Processes using in-built Scheduling feature in Atom Management to automate the process executions on based on priority.
  • Developed Reconciliation process reports in Boomi to sync both source and destination systems.
  • Extensively used most of the Dell Boomi shapes like Route, Branch, Add to Cache, Try/Catch, Exceptions, Flow Control, Business Rules, Decision, Cleanse, Message, Process Call, Program Command, etc. for various processes.
  • Prepared Unit Test Plans and executed the Test Results.
  • Monitor the Boomi processing log for any errors to reprocess.
  • Worked with QA team in Integration Testing, System Testing and UAT teams to analyze and resolve opened defects.
  • Created Boomi support tickets and interact with Dell Boomi support team based on priority tasks.
  • Followed trust.boomi.com for Boomi Release Management, Atom cloud statistics and other notifications to alert the system monitoring team if any major changes / releases.

Environment: Dell Boomi Atomsphere, Salesforce.com, XML, REST API, SOAP API, SFTP, JSON, Flat files, CSV, Postman App, SOQL, Java Script, Groovy Script, WinSCP, SQL Server, T-SQL, Stored Procedures, Service Now

Confidential, Dublin, CA

Sr. Dell Boomi Integration Consultant

Responsibilities:

  • Design, Development, Deployment and management of multiple cloud Integration Processes using Dell Boomi Atomsphere.
  • Day to day client interactions in order to collect Business requirements, Analyze and implement the solutions within the scope of Dell Boomi.
  • Created different components like Connections, Connector Operations, Cross Tables, Document Caches, Mappers, Profiles and Processes using Create Component.
  • Owned Proof of Concepts (POCs) to implement or add any new features with Boomi in current project.
  • Developed and extracted various types of data/documents using Profile formats like Flat File, JSON, XML and EDI to translate documents from Source to Destination using Mapper and HTTP Restful API pay-loads calls.
  • Developed and imported different types of Salesforce Operations like Query, Create, Update and Upsert for Sparkle care project through Get and Send actions using different types of Salesforce objects like Authorization, Appointments, Charge Entries, Patients and Practitioners etc.
  • Developed Custom Scripts for Boomi in Groovy and Java Script to handle unsupported Boomi Architecture.
  • Built different types of Custom Map Functions to combine more business logics.
  • Loaded different types data / documents in Boomi internal memory using Add to Cache and applied unique Index to fetch the documents from Boomi memory (Load from Cache).
  • Spited the complex business logic processes into sub processes using process call shape and make the flow easier to team and for trouble shooting the issues.
  • Applied and utilized Boomi in-built features like set process property, set dynamic document property and set dynamic process property to store the documents and set wherever required to call these document property values.
  • Used Data Process Shape in various scenarios like split the document, combines the documents, search and replace, PGP Encryption and BASE 64 Encode and Decoding purposes to transform documents from Source to Destination.
  • Applied Exception Handling logic to capture process level or document level errors for one or more documents that fail during the execution using its Document Property Meta Data Base options in Try/Catch Shape.
  • Configured e-mail connector to alert for integrations, system monitoring and business teams if any exceptions occurred during the execution.
  • Applied Error handling mechanism in Sparkle care project to alert System or Business errors to Salesforce Queue Manager.
  • Followed Boomi API management standards to send SOAP API calls to Athena system like Token creation and supply relevant parameters to different HTTP API calls like GET, POST, PUT and DELETE.
  • Tuned existing Boomi processes to avoid unnecessary HTTP API calls consumptions.
  • Integrated Dell Boomi Atomsphere with Salesforce.com and Athena.
  • Built Boomi SOA listeners to consume when sending data into Salesforce.com via SOAP API and REST API.
  • Developed various EDI profiles to processes HL7 ADT Message Types: A04, A08, A28 and A31 etc. to integrate Salesforce.com with third-party applications like Athena etc. using Trading Partners in Dell Boomi to Add / Register Patient and Update Patient in Athena.
  • Similarly created EDI profiles for HL7 SIU Message Type: S12 (Schedule Appointment) and HL7 MFN Message Type: M02 (Create Providers) using Trading Partners.
  • Developed Salesforce REST API with OAuth 2.0 Authentication configuration setup in Dell Boomi Atomsphere to integrate and upload UltiPro Practitioner’s information into Salesforce.
  • Deployed Boomi code to SIT, UAT and Production environments using Environment Extensions feature for different Boomi ATOM’s to use unique Boomi code and configured connection details in Atom Management.
  • Performed Unit Testing after Developing Boomi code in TEST mode.
  • Used utilities like Salesforce Workbench and Salesforce Inspector for Salesforce data validations and generate SOQL query to verify both systems.
  • Built various Boomi Processes to send Salesforce data to Athena Billing Systems and vice versa using HTTP client, Salesforce, Trading Partners, etc.
  • Scheduled the deployed Boomi Processes using in-built Scheduling feature in Atom Management to automate the process executions on based on priority.
  • Developed Reconciliation process reports in Boomi to sync both Salesforce and Athena and alert the Management team.
  • Developed Employee Expense report details process in Dell Boomi from UltiPro to Concur using PGP encryption, FTP and SFTP for HRIT project.
  • Built various Boomi processes using UltiPro to Active Directory (AD) using LDAP connector and Employee Terminations in AD for HRIT project.
  • Configured different Connectors to interface with multiple data sources like UltiPro, LDAP, Sales Force and Athena to integrate with Dell Boomi and ICRT.
  • Extensively used most of the Dell Boomi shapes like Route, Branch, Add to Cache, Try/Catch, Exceptions, Flow Control, Business Rules, Decision, Cleanse, Message, Process Call, Program Command, etc. for various processes.
  • Prepared Unit Test Plans and executed the Test Results.
  • Monitor the Boomi processing log for any errors to reprocess.
  • Enabled and added various options in Boomi Atom Management to improve ATOM performance and Purge scheduled logs history under Properties and Settings & Configurations.
  • Worked with QA team in Integration Testing, System Testing and UAT teams to analyze and resolve opened defects.
  • Created Boomi support tickets and interact with Dell Boomi support team based on priority tasks.
  • Followed trust.boomi.com for Boomi Release Management, Atom cloud statistics and other notifications to alert the system monitoring team if any major changes / releases.

Environment: Dell Boomi Atomsphere, Salesforce.com, XML, REST, SOAP, JIRA, UltiPro, LDAP, NetSuite, SFTP, JSON, Flat files, EDI Profiles, Cognos, Postman App, SOQL, Java Script, Groovy Script, WinSCP, Putty, CSV, UNIX, Informatica Cloud, Amazon AWS S3, Athena Health Systems

Confidential, Atlanta, GA

Sr. Dell Boomi Integration Consultant

Responsibilities:

  • Grasping the functional requirements and understanding the detailed low-level design document.
  • Involved in preparing the technical design document based on the inputs from functional team.
  • Design, Development, Deployment and management of multiple cloud Integration Processes using Dell Boomi Atomsphere.
  • Worked on Proof of Concepts (POCs) to implement or add any new features with Boomi.
  • Developed and extracted various types of data/documents using Profile formats like Flat File, JSON, XML and Database to translate documents from Source to Destination using Mapper and HTTP Restful API pay-loads.
  • Developed and imported different types of Salesforce Operations like Query, Create, Update and Upsert through Get and Send actions using different types of Salesforce objects like Accounts, Product, Dispenses, Pharmacy and Patients etc.
  • Created different components like Connections, Connector Operations, Cross Tables, Document Caches, Mappers, Profiles and Processes in Boomi.
  • Applied Add to Cache and Load from Cache shapes to store Boomi Internal temporary memory and fetch data from same memory.
  • Applied Boomi in-built features like set process property, set dynamic document property and set dynamic process property to store the documents and set wherever required to call these document property values.
  • Used Data Process Shape in various scenarios like split the document; combine the documents, search and replace, BASE 64 Encode and Decoding, ZIP and Unzip purposes to transform documents from Source to different Destinations.
  • Created Custom Scripts for Boomi in Groovy and Java Script to handle unsupported Boomi Architecture.
  • Built different types of Custom Map Functions to combine more business logics.
  • Spited the complex business logic processes into sub processes using process call shape and make the flow easier to understand the flow to team members.
  • Applied Exception Handling logic to capture process level or document level errors for one or more documents that fail during the execution using its Document Property Meta Data Base options in Try/Catch Shape.
  • Configured e-mail connector to alert for integrations, system monitoring and business teams if any exceptions occurred during the execution.
  • Applied various Error handling mechanisms in Data Hub to Inbound Dispense project to alert System or Business errors to Connect Source (Salesforce).
  • Followed Boomi API management standards to send SOAP REST API calls to other third-party system like Token creation and supply relevant parameters to different HTTP API calls like GET, POST and PUT.
  • Integrated Dell Boomi Atomsphere with Teradata, Salesforce.com and Oracle.
  • Built Boomi SOA listeners to consume when sending data into Salesforce.com via SOAP API and REST API.
  • CDC based extraction on large volumes of data using Boomi and implemented Boomi’s Find changes shape to capture the changed records.
  • Worked with Functional SAP/ERP teams closely to understand the gaps, coordinated with business on specific business rules.
  • Configured Connectors to interface with multiple data sources like Oracle, Teradata, Salesforce.com, SAP ECC to integrate with Dell Boomi and Informatica Cloud.
  • Extensively used logic shapes like Route, Branch and Exception in our processes.
  • Extensively worked with Flat files such as .CSV, XML by configuring FTP creations in Dell Boomi.
  • Deployed Boomi code to SIT, UAT, Pre-Prod and Production environments using Environment Extensions feature for different Boomi ATOM’s to use unique Boomi code and configured connection details in Atom Management.
  • Prepared SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints and Sequences.
  • Involved in writing Functions, Stored Procedures, Database Triggers and cursors based on requirement.
  • Created indexes for faster access of data to load the data into target system.
  • Performed Unit Testing after Developing Boomi code in TEST mode.
  • Used utilities like Salesforce Workbench and Salesforce Inspector for Salesforce data validations and generate SOQL query to verify both systems.
  • Scheduled the deployed Boomi Processes using in-built Scheduling feature in Atom Management to automate the process executions on based on priority.
  • Developed Reconciliation process reports in Boomi to sync both Salesforce and Teradata and alert the Management team.
  • Developed complex SQL queries using Case Logic, Sub Queries, Inline Views, and Union to validate the source and target data.
  • Implemented Slowly Changing Dimensions Type 1 and Type 2.
  • Designed and Developed mappings using Informatica Cloud Data Synchronization to sync Salesforce.com and Oracle processes using Informatica Secure Agent.
  • Involved in loading of data sets from the Oracle databases using several kinds of tools such as SQL Loader and TOAD.
  • Prepared deployment guide with all the code that must be migrated to QA/Production environment.
  • Monitor the Boomi processing log for any errors to reprocess.
  • Prepared Unit Test Plans and executed the Test Results.
  • Worked with QA team in Integration Testing, System Testing and UAT teams to analyze and resolve opened defects.
  • Created Boomi support tickets and interact with Dell Boomi support team based on priority task delivery.
  • Extensively used most of the Dell Boomi shapes like Route, Branch, Add to Cache, Try/Catch, Exceptions, Flow Control, Business Rules, Decision, Cleanse, Message, Process Call, Program Command, etc. for various processes.
  • Enabled and added various options in Boomi Atom Management to improve ATOM performance and Purge scheduled logs history under Properties and Settings & Configurations.
  • Followed trust.boomi.com for Boomi Release Management, Atom clod statistics and other notifications to alert the system monitoring team if any major changes / releases.

Environment: Dell Boomi Atomsphere, Informatica 9.6.1, Informatica Cloud, Oracle 10g, SQL, PL/SQL, Tera Data, Azure, SAP ECC, Salesforce.com, XML, REST, SOAP, TWS, TOAD, HP Quality Center, JSON, SFTP, Java Script, Groovy Script, Win SCP, UNIX, SOQL

Confidential, Zurich, Chicago

Senior Dell-Boomi Integration Consultant

Responsibilities:

  • Involved in preparing the technical design document based on the inputs from functional team.
  • Design, Development, Deployment and management of multiple cloud Integration Processes using Dell Boomi Atomsphere.
  • Day to day client interactions in order to collect Business requirements, Analyze and implement the solutions within the scope of Dell Boomi.
  • Extraction, Transformation and Loading of the data using ETL Transformations.
  • Extraction of SAP ECC data using Informatica.
  • Built Custom Scripts for Boomi in Groovy and Java Script to handle unsupported Boomi Architecture.
  • Used Boomi Web Services SOAP Client to integrate with on premise applications.
  • Used CDC based extraction on large volumes of data using Boomi and implemented Find changes shape to capture the changed records.
  • Spited the complex business logic processes into sub processes using process call shape and make the flow easier to team and for trouble shooting the issues.
  • Applied Exception Handling logic to capture process level or document level errors for one or more documents that fail during the execution using its Document Property Meta Data Base options in Try/Catch Shape .
  • Configured e-mail connector to alert for integrations, system monitoring and business teams if any exceptions occurred during the execution.
  • Followed Boomi API management standards to send SOAP REST API calls to other third-party system like Token generation and supply relevant parameters to different HTTP API calls like GET, POST, PUT and DELETE.
  • Tuned existing Boomi processes to avoid unnecessary HTTP API calls consumptions.
  • Integrated Dell Boomi Atomsphere with Salesforce.com.
  • Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator and update strategy etc.
  • Built Boomi SOA listeners to consume when sending data into Salesforce.com via SOAP API and REST API.
  • Deployed Boomi code to SIT, UAT and Production environments using Environment Extensions feature for different Boomi ATOM’s to use unique Boomi code and configured connection details in Atom Management.
  • Performed Unit Testing after Developing Boomi code in TEST mode.
  • Used utilities like Salesforce Workbench and Salesforce Inspector for Salesforce data validations and generate SOQL query to verify both systems.
  • Scheduled the deployed Boomi Processes using in-built Scheduling feature in Atom Management to automate the process executions.
  • Created mappings, sessions, workflows and run those using workflow manger and monitor jobs using workflow monitor.
  • Prepared various SQL JOINS like Equal, Inner, Left Outer, and Full Outer Joins to validate the data between source and target systems.
  • Built Reconciliation process reports in Boomi to sync all systems.
  • Created SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints and Sequences.
  • Built SQL Functions, Stored Procedures, Database Triggers and cursors.
  • Prepared indexes for faster access of data to fetch / load the data from source and target system.
  • Applied parallel hints and analyzing the table for tuning of SQL queries.
  • Prepared Unit Test Plans and executed the Test Results.
  • Participated in Code Review and Performance Tuning.
  • Created Boomi support tickets and interact with Dell Boomi support team based on priority tasks.
  • Involved in SIT and UAT testing and supported the Production fixes after go-live.
  • Daily Job Monitoring and Bug fixing.
  • Involved in working on Change Requests.
  • Responsible for given KT for new team members in Project.

En vironment: Dell Boomi Atomsphere, Informatica Power Center 9.5.1, DB2, Oracle, SAP ECC, TWS, Move IT, Service Now, Salesforce.com, UNIX, REST, SOAP, SQL, PL SQL, TOAD, Cognos

Hire Now