Integration Lead & Arch Consultant Resume
Houston, TX
SUMMARY
- Overall 16 years of IT experience
- 8 years of experience in Dell Boomi integrating on Workday, Success Factors, Salesforce, SAP On premises, SAP Cloud, Oracle Cloud, Microsoft Dynamics, Workday, Amazon, Cornerstone, Brink, Avaiter, Kloudgin, Concur, SFTP, HTTP, OpsGiene etc.
- Involved in all phases of end - to-end implementations such as Requirements Analysis, Technical Specifications preparation, Coding, Testing, Quality Assurance, User Training, Performance Tuning and Production Support.
- Worked on Java Script, Groovy Script.
- Creating configuration scenarios for A2A and B2B Integration for various format. Involved in teh various phases of teh Implementation in teh Development level for various projects.
- Creating models, repository in MDM
- Maintaining Gloden MDM records
- Experience wif Graphical, Java, XSLT, XML, Jason, FlatFile and User defined mapping function.
- Experience on Standard iFlows in Dell Boomi.
- Experienced in Data Conversions, Data Uploads from legacy systems to target system.
- Writing Oracle and MySQL Data queries
- Highly motivated person wif Excellent Communication and interpersonal skills, played roles like Confidential lead for development Confidential and production support Confidential .
PROFESSIONAL EXPERIENCE
Confidential, Houston TX
Integration Lead & Arch Consultant
Responsibilities:
- Setting up Boomi Environment wif Servers, Local Atoms, Creating Environments (DEV, QA, PROD)
- Maintaining Servers, Atoms and Boomi API’s
- Integrated wif Workday for New Hire, Rehire, Updates and Terminations wif business systems
- Generation of Active Directory daily report for new hires, rehires and terminations
- Exposed Boomi API for Workday system for New Hire creation and Terminations
- Creating, updating and maintaining MDH models, repository, sources and gloden records
- Maintenance of Boomi MDH for centralized depositary for Employees, Vendors and Customers
- Integrated Microsoft Dynamix wif Salesforce for opportunity, pricebooks, pricebooks entries, customers etc
- Migration of master data from Salesforce to Kloudgin system
- Integrated Sales order data, invoice data, debits and credits data from Kloudgin to Sales force to AX
- Creation and updating of new request, ad create, ad terminate on ServiceNow request
- Generating and emailing teh Boomi related request status information to teh business
- Integrated wif ServiceNow for request creation and MDH Variable request update
- Integrated Concur system to pull expense, travel and invoice related data to JDE and Salesforce
- Developing, analysing MySQL complex SQL queries and HASH queries in MySQL for Mfiles and Jd Edwards
- Migrating systems transactions data to Mfiles database for BI Reporting purpose
- Perform Security, Logging, Auditing, Policy Management and Performance Monitoring and KPI for end-to-end flow iPaaS execution.
- Creating and Updating LMS system for technician training certificates.
- Interacting wif AX and ADP for payroll related activities.
- Analysing and troubleshooting teh Dell Boomi AtomSphere and Cloud MDM AtomSphere.
Confidential, Houston TX
Integration Architect Consultant
Responsibilities:
- Setting up Boomi Environment wif Servers, Local Atoms, Creating Environments (DEV, QA, PROD)
- Maintaining Servers, Atoms and Boomi Flows
- Deploying, scheduling, maintaining and troubling shooting teh MDM integration process on Dell Boomi AtomSphere and Cloud MDM AtomSphere
- Design, develop and deploy AtomSphere Integration flows to Cloud, On-Premises and Hybrid platforms.
- Integrate large volumes of Master source data, including structured and unstructured data, Sources include MySQL, Flat Files, JD Edwards, SalesForce & Successfactors.
- Fetched Sales information, master data information from Salesforce
- Integration sales data between Salesforce and JDE
- Developed Boomi Flows for Customer, ShipsTo, Vendors, Item, Asset and Employee Master Data and integrated from JDE ERP system and Salesforce
- Developing and troubling shooting MySQL iPaaS solution design for EDM projects across different systems.
- Implement Sales, Travel, HR Datat management by Integrating JD Edwards(JDE) to Successfactor and Salesforce
- Perform Security, Logging, Auditing, Policy Management and Performance Monitoring and KPI for end-to-end flow iPaaS execution.
- Analysing and troubleshooting teh Dell Boomi AtomSphere and Cloud MDM AtomSphere.
- Assist in teh migration of EDM processes to Dell Boomi AtomSphere and Cloud MDM AtomSphere platform wif B2B integrations for critical payroll, bank and employee related processes.
Confidential, Houston TX
Integration Architect Consultant
Responsibilities:
- Identify, analyse and develop interfaces and Integration flows using Dell Boomi iPaaS platform including Integration management, Event-based integration, Connectors, Atmosphere API and MDM cloud flows.
- Developing and troubling shooting Oracle iPaaS solution design for ESG projects across different systems.
- Implement GPS Asset management by Integrating JD Edwards to TELOGIS API using Dell Boomi iPaaS platform wif RESTful and SOAP messages.
- Perform Security, Logging, Auditing, Policy Management and Performance Monitoring and KPI for end-to-end flow iPaaS execution.
- Design, develop and deploy Atmosphere Integration flows to Cloud, On-Premises and Hybrid platforms.
- Analysing and troubleshooting teh Dell Boomi Atmosphere and Cloud MDM Atmosphere.
- Assist in teh migration of ESG processes to Dell Boomi Atmosphere and Cloud MDM Atmosphere platform wif B2B integrations for critical payroll, bank and employee related processes.
- Deploying, scheduling, maintaining and troubling shooting teh MDM integration process on Dell Boomi Atmosphere and Cloud MDM Atmosphere
- Integrate large volumes of ESG source data, including structured and unstructured data, Sources include MySQL, SQL Server, Flat Files, ERP System (JD Edwards, MS Dynamics) and Cloud.
Confidential, Houston TX
Dell Boomi Lead Sr Technical Consultant
Responsibilities:
- Identify, analyse and develop Employee Data Management (EDM) interfaces and Integration flows using Dell Boomi iPaaS platform including Integration management, Event-based integration, Connectors, AtomSphere API and MDM cloud flows.
- Design, develop and deploy AtomSphere Integration flows to Cloud, On-Premises and Hybrid platforms.
- Queried Salesforce Lead and Opportunity data and updated to CSV file
- Enhanced salesforce Sales Order process flow.
- Enhanced salesforce Invoice process flow.
- Developed teh MDM synchronization process to synchronise MAP Database tables
- Governing MDM stewardship gloden records
- Monitoring, troubleshooting MDM environment
- Developing, analysing Oracle complex SQL queries and HASH queries in Oracle and JD Edwardsa
- Implement GPS Asset management by Integrating JD Edwards(JDE) to TELOGIS API using Dell Boomi iPaaS platform wif RESTful and SOAP messages.
- Integration Employee data from Oracle HUB database to CORNERSTONE - CSOD
- Integration EHS employee data from Successfactors to Brink Constructors.
- Developed inbound and outbound for Successfactors and Toolwatch
- Perform Security, Logging, Auditing, Policy Management and Performance Monitoring and KPI for end-to-end flow iPaaS execution.
- Analysing and troubleshooting teh Dell Boomi AtomSphere and Cloud MDM AtomSphere.
- Assist in teh migration of EDM processes to Dell Boomi AtomSphere and Cloud MDM AtomSphere platform wif B2B integrations for critical payroll, bank and employee related processes.
- Deploying, scheduling, maintaining and troubling shooting teh MDM integration process on Dell Boomi AtomSphere and Cloud MDM AtomSphere
- Integrate large volumes of EDM source data, including structured and unstructured data, Sources include MySQL, SQL Server, Flat Files, ERP System, JD Edwards, MS Dynamics and Cloud.
Confidential, Pennsylvania
Dell Boomi Developer
Responsibilities:
- Atom management planning and maintenance.
- Maintenance of atom server.
- Managing, creating and reviewing user’s roles and responsibilities.
- Implemented Benefit Focus employee data from EC to Benefit Focus SFTP
- Migrated Employee data from Benefit Focus to SAP ECP Cloud system to AL11
- Retrieved MS Active Directory and updated to EC
- Employee High Grounds Integration from Successfactor to SFTP
- Employee High Grounds Integration from SFTP to Successfactor
- Enhancement on successfactor employee termination interface
- Payment file generation and transmission from Successfactor to multiple banks
- Fetched file from SAP Cloud AL11 patch directory and processed to PNC bank
- Implemented document tracking process
- Coordinate wif client, Functional Consultant to solve teh issue of tickets.
- Coordinate wif various systems Consultants to design teh architecture of teh Interfaces.
- Developed bank related boomi process for inbound and outbound flows.
Confidential, California
Dell Boomi Integration Consultant
Responsibilities:
- Developed Boomi process using different connections like Web Services, HTTP, SFTP, Database,, Successfactor, Marketo, Oracle cloud, etc
- Employee integration from Successfactor to Oracle
- Customer integration from Salesforce to Oracle
- Processed Invoices from Sales force to Netsuite
- Payment file generation and transmission from successfactor to multiple banks
- Update Hive Database wif sales data and all other relevant data
- Bank statement integration from banks to Oracle
- GL Balance extraction from Oracle to Cognos
- Project Confidential member assignments from Successfactor to Oracle.
Confidential, New Jersey
Dell Boomi Integration Consultant
Responsibilities:
- Oracle PaaS Solution Design for Absence Exception reporting between Oracle and Workday
- Oracle PaaS Solution Design for Mashup UI highlighting Workday planned absences wifin Oracle OTL
- Trouble shoot of Oracle PaaS system on SQL queries in retrieving of teh data.
- Developed an error reporting flow where it will go and create an issue ticket in online Oracle cloud
- Responsible for deploying teh process into different environment
- Scheduling teh process as per teh FSD requirement.
- Maintaining teh extensions and environments extensions
- Implemented document tracking process
- Coordinate wif client, Functional Consultant to solve teh issue of tickets.
- Coordinate wif various systems Consultants to design teh architecture of teh Interfaces.
- Developed bank related boomi process for inbound and outbound flows.
Confidential, Ohio
Boomi Developer
Responsibilities:
- Responsible to Develop Integration processes in DellBoomi for Teradata, GXS, Avatier, Person SqlServer, Secure User and Success Factors.
- Posted teh data in teh Databased using SQL queries.
- Coordinate wif client, Functional Consultant to solve teh issue of tickets.
- Coordinate wif various systems Consultants to design teh architecture of teh Interfaces.
- Developed Outbound Interface to send data from Success Factors to Teradata system.
- Developed Outbound Interface to send Employee Master data form Success Factors to GXS system.
- Developed Outbound Interface to send Hire, Rehire data from Success Factors to Avatier, PersonSqlServer, SecuUser.
- Developed Outbound Interface to send Termination data from Success Factors to Avatier, PersonSqlServer, SecuUser.
- Configured various lock box using boomi.
Confidential, Ohio
Boomi Developer
Responsibilities:
- Coordinating and interacting wif key business users, project stakeholders for gathering Requirements and Design of Interface Architecture, naming conventions, processes and analyzed all business requirements and mapped them to Dell Boomi Interfaces according to business process requirements
- Coordinate Offshore Confidential towards developing teh Interfaces.
- Responsible to Develop Integration processes in DellBoomi for Medgate, CCure and Success Factors.
- Coordinate wif client, Functional Consultant to solve teh issue of tickets.
- Coordinate wif wif various systems Consultants to design teh architecture of teh Interfaces.
- Developed Interfaces for various systems pass through Boomi
- Applied teh SQL queries on teh data base
- Developed Outbound Interface to send Employee’s Emergency Contacts data form Success Factors to Medgate system.
Confidential, New Jersey
SAP ABAP HR PI Developer
Responsibilities:
- Developed a Report to display applied, approved, rejected, extracted data for Reimbursement of employees.
- Fetching and posting teh oracle data base using different SQL select queries and DML statement.
- Build classical reports using SQL join statements.
- Manipulated SQL database using SQL options.
- Developed Program to extract approved data into flat file to be fetched by core banking system to make payments.
- Developed Search halp for Employee Subgroup as per requirement.
- Responsible for Runtime workbench for message monitoring, component monitoring Performance Monitoring and End-to-End monitoring for all teh interfaces in SAP PI / PO.
- Worked on Integration Engine adapter on SFTP, Idoc, JDBC, RFC, SOAP, HTML, FTP, Proxies, etc
Confidential, Pennslylvania
SAP ABAP HR PI Developer
Responsibilities:
- Developed a Report to display applied, approved, rejected, extracted data for Reimbursement of employees.
- Fetched teh data records from teh oracle data base using SQL Select Queries.
- Developed BDC program to upload teh Employee Salary using F-02.
- Developed BDC program to upload Customer Invoice data using FB70.
- Developed BDC to Create Legacy Group Asset using AS81.
- Developed BDC to Create Legacy Asset using AS91.
- Developed BDC to Create Asset using AS01.
- Responsible for Runtime workbench for message monitoring, component monitoring Performance Monitoring and End-to-End monitoring for all teh interfaces in SAP PI / PO.
- Worked on Integration Engine adapter on SFTP, Idoc, JDBC, RFC, SOAP, HTML, FTP, Proxies, etc
Confidential, Rhode Island
SAP ABAP XI/PI Developer
Responsibilities:
- Developed BADI for PO amount should not exceed TEMPthan PR amount in ME21N.
- Developed BADI for Business Area (Under cost center) and Plant mapping in teh ME21N.
- Material Master,IDoc (MATMAS) to XMLinterface from SAP ECC to 3rd party involving complex field and value mapping.
- Purchase Orders (PO),IDoc (ORDERS05)to XMLinterface from SAP ECC to 3rd party, wif acnoledgement receipt.
- Goods movement XML to IDoc from other to SAP ECC to post goods issue and goods Receipt.
- Inventory adjustment/balance SOAP to BAPIinterface from 3rd party to SAP ECC to perform on-demand and periodic inventory synchronization.
- SetupABAPProxiesfor teh interface between SAP PI and teh third party systems.
- Inbound XML to BAPI interface to create and modify records incustom tables.
Confidential, California
SAP ABAP Developer
Responsibilities:
- Developing Objects and reports using SQL queries.
- Review of Technical Documents
- Developed a program to upload teh Service Master data using BAPI.
- Developed a Report for Service tax half yearly Returns.
- Developed Script and Payment Medium Program for Payment Advice and Cheque Printing.
- Developed Consolidated Sales Register for SD module and prepared report on SQL.
- Developed Sales Return Register for SD module.
- Used SQL statements like Create, insert, update, modify records
- Developed Debit memo and Credit memo register for SD module.
Confidential
SAP ABAP Developer
Responsibilities:
- Analysing functional specifications.
- Involved in Preparation of Technical specifications.
- Developing reports using SQL statements.
- Review of Technical Documents
- Worked on SD Requirement Routine so that teh uncommitted contracts should not be actualized (relevant) for delivery and billing.
- Developed two Interfaces to automatically upload SD pricing condition records, one for forecasted/ budgeted prices and another for various different access sequences.
- Worked on Enhancement / Customer Exit that allowed teh user to see teh stock of a particular batch and its associated batches in teh local base unit of measure.
- Supported in Integration Testing phase, User Acceptance Testing (UAT), Cut-Over and Post-Go Live phases.
- Ensure to deliver teh objects wifin specified timelines
- Modified teh data using SQL statements as per business needs.