We provide IT Staff Augmentation Services!

Dell Boomi Consultant Resume

ChicagO

PROFESSIONAL SUMMARY:

  • Around 3+ years of experience in Cloud IAAS (Integration as a Service) i.e. Development, Configuration of Dell Boomi Integration with Success Factor Employee Central.
  • 8 + years of work experience in Development and Implementations of Data Warehousing solutions.
  • Has worked in capacity of Solution Architect, solution feasibility analysis, Technical design Auditor, Consultant and Integration Lead for different projects and clients. Also, has extensive experience in handling projects in onshore - offshore model.
  • Strong Cloud Integrations experience in Dell Boomi.
  • Involved Developing SQL queries and scripting languages.
  • Working experience on Dell Boomi Connectors called Success Factors, Net Suite, SAP and Atmosphere API.
  • Having hands on experience in developing of complicated Integration problems.
  • Working experinece on Dell Boomi Connectors called Disk, FTP, Mail, Database, SFTP, Sales force, Web,SAP Idocs,Listner process,LDAP Conncetor.
  • Working experience on Dell Boomi Connectors called Success Factors, Net Suite, SAP and Atmosphere API.
  • Working experience on Dell Boomi connectors called Disk, FTP, Mail, Database, Sales force, Web services listener, HTTP client, Web Services SOAP, REST clients, Success Factors, Trading Partner.
  • 8 +years of experience in SAP BODS Development as well as Administration.
  • Dealing with WEBI and CR reports. Rectifying all the issues related with scheduling, connection and database connectivity problems.
  • Setting rights and privileges on objects, folders, connections depending upon the requirement. Creating and maintaining different user groups as per the business need.
  • Installation experience of Business Objects Data Services 4x.
  • Implementation of Open Database Connectivity (ODBC) and query development for flexible information exchange between organization’s proprietary Unix based application and end user desktop applications such as Excel and Access.
  • Involved in BODS Upgrade activities.
  • Worked on ETL tool SAP Business Objects Data Services 4x/3x and on all transforms of Data Services (Data Integrator, Platform & Data Quality transforms).
  • Managed BODS objects like Installation of BODS, Creation of new Repository, Schedule of Batch Jobs, Data stores, Addition of repositories to Designer, Setting Job server, Flat file formats and Excel/Xml file formats.
  • Used in-built functions of BODS, Custom functions, Conditional workflows, BODS scripting language, debugger to debug the BODS Job in debug mode.
  • Exposure on BODS Management Console.

KEY COMPETENCIES & SKILLS:

Operating System: Unix and Windows

Designer Tools: BODS Designer, Dell Boomi

ETL Tools: SAP BODS

Database Tools: Teradata, Oracle, SQL Server, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Dell Boomi Consultant

Responsibilities:

  • Analysed the existing development (Mainly Interfaces) in SAP HR Global Instance for business logics and developed functional and technical specifications to be developed in SF EC system.
  • Developing the integrations which includes processes, maps, connectors and many other components/steps to transfer the data from one system to other systems by performing required validations.
  • Installing Dell Boomi Atom at client location.
  • Extracting data using SFAPI & ODATA API using Dell Boomi.
  • Enabling API in Success factor Employee central.
  • Getting the data from third party connectors like Success factors to SAP using cloud integration and performing the tasks as per the client requirement.
  • Involving in different phases like build, deploy and manage.
  • Worked on POC, technical feasibility and build.
  • Developed various iflows to map the different vendor systems.
  • Developed Iflow to map the Ceridian payroll system for USA/CA Employees.
  • Developed ifow to map the ADP payroll system for Europe Employees.
  • Developed Global integration iflow for Merrill Lynch Employee data
  • Developing the integrations which includes processes, maps, connectors and many other components/steps to transfer the data from one system to other systems by performing required validations.
  • Getting the data from third party connectors like Success factors to SAP using cloud integration and performing the tasks as per the client requirement.
  • Involving in different phases like build, deploy and manage.
  • Getting the data from third party connectors like Sales force, database and performing the tasks as per the client requirement.
  • Involving in converting the Data Formats from one to another based on client requirement.
  • Involved in developing of critical mapping problems depends on client requirement
  • Well versed in monitoring the Boomi Processes using the Manage Dashboard on Boomi Platform.

Tools: Dell Boomi,SAP ECC,SAP BW, SQL Server, SAP HANA

Confidential

Team Lead/L3 Support Engineer

Responsibilities:

  • Implemented Load Balancing technique at BODS and SAP ECC level.
  • Involved in production support activities.
  • Building of the BODS Jobs, Workflows, Data Flows as per the Mapping Specification.
  • Implements Open database Connectivity (ODBC) to allow MS Excel database to access Oracle compliant data sources
  • Used Push-Down, Bulk Loader in BODS to transform the data from CSV File to Staging area and Staging to EDW tables.
  • Used various transformations like Query, SQL, Case, Map Operation, Table Comparison, Pivot, Merge, etc.
  • Used BODS Script and Global Variables.
  • Preparation of the Unit Test documents and capturing the results in UTP.
  • Working as a L3 Support Engineer.
  • Involved in BODS Jobs and database code tuning
  • Hands on experience with Third party schedule tool Tivoli to manage the jobs as per dependency.
  • Setting rights and privileges on Repositories. Creating and maintaining different User groups as per the business need.
  • Created batch jobs using SAP BODS to transfer data from SAP ECC,SAP BW,Oracle,DB2,Oracle,SQL Server DB,XML and Flat files to Teradata
  • Data migration from different data source to different target database.
  • Support and maintenance of existing jobs.

Confidential

ETL Object Developer

Responsibilities:

  • Developer from ETL Development side.
  • Interacting with the client for the enhancements requirements gathering.
  • Developing design strategy for loading the data mart tables as per the request received from the client.
  • Development of Workflows, dataflows, r/3 flows (pulling data from SAP, sequential files, oracle etc.)And sequencing them into the existing jobs as per requirement for loading the data into the data warehouse as per the specified design.
  • Implements Open database Connectivity (ODBC) to allow MS Excel database to access Oracle compliant data sources
  • Reviewing of the jobs created by others
  • Maintaining the existing application by monitoring the loads, resolving the production issues in very quick turnaround time and also resolving the queries asked by the different users who use the data.
  • Schedule the jobs as per the request received from the client
  • Prepared mapping documents according to the specifications.
  • Designed various mappings for extracting data from various sources involving flat files and relational tables.
  • Maintaining standards (naming convention) and Quality.
  • Using designer to create source definitions, design targets, create mappings and develop transformations.
  • ALE, BAPI and I Docs inbound and outbound interfaces creation, maintenance and testing
  • Involved Date Migration Activates using LSMW ( Legacy System Migration Workbench ).

Hire Now