OIC and MuleSoft Integration Architect

Vivekananda Rao Kantamaneni

Career Summary

Having 19 plus years of experience in software industry, analysis, design, development, testing and support of Business Integration and application development using Anypoint API Designer, Cloud Hub, Anypoint Studio, BPEL, ESB, Mediator, OSB, BAM, B2B, ESS, MFT, WebServices technologies by using Oracle Fusion components like Oracle SOA Suite 10g, 11g and 12c, Oracle AS 10g, Weblogic server, JDeveloper 10g,11g&12c, AIA, ODI, PIP 11.1, OIC (Oracle Integration Cloud), Oracle Fusion Cloud, MuleSoft, Dell Boomi

● 5 years of focused experience delivering Oracle Fusion Cloud ERP Financials integrations across General Ledger, Payables, Receivables, Expenses and Project Portfolio Management as part of full-cycle Oracle Cloud implementations.

● Strong hands-on expertise with Oracle Fusion Financials inbound and outbound patterns: FBDI

(File-Based Data Import), ERP Integration Service (importBulkData, exportBulkData), Fusion REST/SOAP APIs, BI Publisher and OTBI reports, UCM file uploads, ESS job scheduling and callback-based status tracking.

● Good functional understanding of the finance data lifecycle, including the Record-to-Report (GL), Procure-to-Pay (AP) and Order-to-Cash (AR) flows

● Have been part of different phases of software development lifecycle ranging from System analysis, Requirement gathering, Design, Development and Support.

● Enterprise Integration Architecture – have good knowledge on implementing integration solutions based on various Middleware Technologies.

● Have good domain knowledge in SCM, CRM, HCM, Oracle Inventory, Purchasing, Receivables.

● Familiar with Sales force, Oracle Cloud ERP, Oracle EBS, Oracle ATG, WMS systems.

● Involved extensively in client interactions and converting business functionalities into SOA models across heterogeneous IT environments and sound knowledge in implementation of SOA methodology.

● Experience in agile methodology and waterfall methodology.

● Worked on ITSM and tools like Service Now and HPSM.

● Experience in implementing iPaaS integration solution strategy.

● Well versed with application integration across legacy systems and SaaS applications.

● Have good communication skills and interpersonal skills, also attentive in communicating with client on understanding the requirements and delivering the solutions

● Have good leadership qualities and capable of managing a team, assigning tasks and preparing the status reports

Skills Summary

Technical:

Integration

Technologies

MuleSoft, Oracle Fusion(10g,11g,12c), BPEL, OSB, Mediator, B2B, BAM, PIP, AIA, OIC, Oracle SOA Gateway, Dell Boomi

Oracle Fusion Cloud

Financials:

General Ledger, Accounts Payable, Accounts Receivable, Expenses, Project Portfolio Management (Project Costing, Project Control), Oracle Fusion HCM

Page 1

Oracle Fusion

Integration Tools

FBDI, ERP Integration Service (importBulkData, exportBulkData, getESSJobStatus), Oracle ERP Cloud Adapter, Oracle HCM Cloud Adapter, Fusion REST/SOAP APIs, BI Publisher, OTBI, UCM, ESS Jobs, ERP Business Events, HCM Data Loader (HDL), HCM Extracts Oracle Apps Oracle E-Business Suite (Oracle PIM, Oracle Inventory, OM, Finance, Service Contracts and Oracle HRMS), Oracle Cloud (HCM and ERP) RDBMS Oracle, MYSQL

Languages & Scripts Java, XML, XSLT, Python, JSON

Tools Anypoint Studio, SQL Developer, ANT, Splunk, GitHub, Maven, Eclipse, JDeveloper, Microsoft VISIO, StarTeam, Subversion, Quality Center, ServiceNow, JIRA, Confluence, Altova XML spy, EDI Notepad, Jenkins, Postman, SOAP UI, WinSCP

Messaging Platform JMS, Oracle AQ, IBM MQ

APIs SOAP over HTTPS, FTP, RESTful XML/JSON

Web Technology JSP, Servlet, JavaScript

Testing HPQC and JIRA

Certifications:

● Oracle Cloud Platform Application Integration 2023 Certified Specialist

● Boomi Associate Developer Certification 2022

● Boomi Professional Developer Certification 2022

● Boomi Associate Master Data Hub Certification 2022

● Mulesoft Certified Integration Architect – Level1

● MuleSoft Certified Developer - Level 1

● Oracle SOA Suite 11g Certified Implementation Specialist Professional Experience

Employer: Apps Associates LLC

Start Date: 04/15/2021

End Date: 03/15/2026

Roles and Responsibilities:

Oracle Fusion Financials Integrations

● Designed and developed OIC integrations as part of Oracle Fusion Cloud ERP Financials and HCM implementations, covering GL, AP, AR, Expenses and PPM.

● General Ledger: Built inbound journal integrations from third-party and legacy systems using the GL Journal Import FBDI template, uploading to UCM and submitting the Import Journals ESS job through the ERP Integration Service. Implemented pre-validation of chart of accounts segments, ledger, accounting period status and balanced debits/credits to reduce import failures.

● Accounts Payable: Developed AP invoice inbound integrations using the Payables Invoice Import FBDI template and the Import Payables Invoices process, including validation of suppliers, supplier sites, business units and distribution combinations before load.

● Accounts Receivable: Built AR invoice integrations using the AutoInvoice FBDI template (RA Interface Lines) and the AutoInvoice Import process, with handling of transaction sources, transaction types and customer account/site references.

● Customers: Developed customer account and site integrations using Fusion REST APIs and bulk import for synchronizing customer master data with external systems.

● Expenses: Built integrations to create expense reports in Oracle Fusion Expenses from third-party sources.

● Project Portfolio Management: Developed integrations to import project costs (Import Costs FBDI), project progress and project tracking updates, supporting accurate project accounting and reporting.

Page 2

● Supply Chain: Developed Sales Order, Work Order and Inventory Transaction integrations with Oracle Fusion Cloud.

● Implemented callback-based status tracking using ERP Integration Service callbacks and getESSJobStatus to capture load results, parse interface error reports and route rejected records back to source teams through email notifications.

● Developed outbound finance data extracts using BI Publisher reports invoked from OIC (via the BI Publisher report service), delivering GL balances, invoice and payment data to downstream systems.

● Wrote Oracle SQL for custom BI Publisher and OTBI reports used for integration reconciliation, validating that source totals matched Fusion interface and base table data.

● Supported month-end and period-close activities by monitoring scheduled finance integrations, resolving load errors and ensuring timely posting of journals and invoices. Oracle Fusion HCM Integrations

● Developed HCM integrations for employee updates, 401(k) updates and timecard imports using the Oracle HCM Cloud Adapter, REST APIs and HCM Data Loader. OIC Platform & Architecture

● Provisioned Oracle Integration Cloud instances and created multiple environments (DEV, TEST, PROD); worked on OIC instance creation and updates for Oracle Integration for SaaS.

● Built App Driven and Scheduled Orchestrations using the SOAP, REST, Oracle ERP Cloud, Oracle HCM Cloud and FTP adapters.

● Created reusable mappers, lookups and common error-handling frameworks in OIC.

● Worked on a range of Oracle Fusion SOAP/REST ERP and HCM APIs and FBDI-based bulk import solutions.

MuleSoft & Boomi

● Integrated Salesforce, SAP HANA and SimpleMDG applications using MuleSoft; designed and implemented Mule APIs on the Anypoint Platform with deployment to CloudHub.

● Integrated Oracle Cloud, ADP and Active Directory using Boomi; designed and implemented Boomi integration processes.

Delivery & Leadership

● Analyzed and transformed business requirements into scalable integration solutions, working closely with finance functional consultants and business users.

● Established integration and data standards and maintained efficient operationalization of all integrations, including error handling.

● Created prototypes, technical specifications (MD50/MD70-style design documents) and migration documents.

● Prepared customer and development requirements documents and presented them to business and IT users for approval.

● Supported SIT and UAT cycles with finance users and performed sanity testing in QA and Production after deployment.

● Handled knowledge sharing and onsite–offshore coordination. Employer: Teknest (Yankee Candle(USA))

Start Date: 11/29/2017

End Date: 04/14/2021

Roles and Responsibilities:

● Experience in Mule soft Anypoint API platform on designing and implementing Mule APIs, development and deployment in Cloudhub.

Page 3

● Designed and developed Mule ESB Projects using various connectors like Salesforce, File, Database, JMS, Transformers and Data Wave for integrating various applications which are on-premises and hosted on the cloud using synchronous and asynchronous Mule flows.

● Worked on developing batch integrations to transfer data in bulk between enterprise applications using Mulesoft Enterprise Service Bus.

● Experience in building Mule flows, scopes and Error Handling strategies, Message filters, Validation, Transformation, Message Enricher and Flow Controls.

● Good Exposure to Continue Integrations and Delivery tools surrounding Anypoint Platform. Used tools like Maven, MMC and Anypoint Runtime Manager.

● Having experience Oracle SOA L3 Support

● Having experience on OIC (Oracle Integration Cloud) to integrate on-premise EBS application and Oracle Demand Management cloud.

● Having experience on OIC (Oracle Integration Cloud) App Driven Orchestrations and Scheduled Orchestrations.

● Having experience in creation of mappers and Lookups in OIC.

● Designed and developed BPEL processes, created XSDs for projects and transformed complex business processes by using different components like SOAP Adapter, REST Adapter, JMS Adapter, File Adapter, DB Adapter.

● Developed Exception Handling architecture in BPEL for the whole project to handle all the exceptions and alerts like sending emails.

● Understanding complex business processes, designing, coding and testing as per the business requirements.

● Created BAM DO and Alerts.

● I worked on Oracle B2B.

● Designed and developed custom error hospital for monitoring and reprocessing all exceptions.

● Configured partner setups in B2B console for Trading partners to receive or send EDI documents.

● Developed and configured FTP/File Adapters for file transfer over SFTP.

● Developed a custom solution for MFT operations using BPEL.

● Worked with Java Embedding Activity for integrating java code into BPEL.

● Implementing the functional and technical setups to develop the desired functionality.

● Troubleshoot SOA composite applications by performing corrective actions such as fault recovery.

● Preparation of customer requirements and development requirements documents and presenting them to business and IT users for getting approvals.

● Involved in maintenance of Production instances and fixing bugs in code changes.

● Performed sanity testing on QA, Stage and Production environments after deployment.

● Deployment of SOA and OSB applications, EAR, WAR, JAR files.

● Involved extensively in client interactions and converting business functionalities into SOA models across heterogeneous IT environments and sound knowledge in implementation of SOA methodology.

● Managing and monitoring service engines and updating the state of SOA composite applications in the Production environment as part of daily monitoring activities.

● Knowledge sharing and onsite – offshore coordination. Employer: Tata Consultancy Services Ltd (TCS)

Start Date: 11/16/2011

End Date: 11/28/2017

Roles and Responsibilities:

● Developed integration solutions using Oracle SOA Suite, OSB and ODI Page 4

● Developed different services (SOAP/RESTful/Messaging) and Web Services using WSDL, SOAP, XSD, and JDeveloper 12c&11g.

● Conduct business review meetings to discuss change requests and enhance existing services.

● Enabled automated alert mechanism in customer MDM-PIP application and took necessary actions to get the customer accounts synchronized across various applications integrated to MDM-PIP.

● Designed and developed BPEL processes, created XSDs for projects and transformed complex business processes by using different components like JMS, MQ Adapter, SOAP Adapter, File Adapter, DB Adapter.

● Analyzing the existing business flow and proposing new business flow

● Knowledge sharing and onsite – offshore coordination.

● Preparation of customer requirements and development requirements documents and presenting them to business and IT users for getting approvals.

● Configured Data Sources and connection Pools by using web logic admin console.

● Involved in performance tuning and Exceptions/Fault Policy Management for the BPEL process

● Development and code review of different components as a part of interfaces.

● Active interaction with the peers to ensure synchronization among the team.

● Customization of AIA PIP integration packs.

● Well experienced in the configuration of Proxy and Business services in OSB – SOA integrations.

● Implementation of Fault Management Framework in complex scenarios and developed fault scenarios for BPEL integrations especially with Catch and Catch All activities.

● Expertise with Meta Data Services, exporting, importing and deploying the MDS artifacts into the server.

● Developed and enhanced changes in Oracle ESB and BPEL projects as per the business requirements.

Employer: Intelligroup Asia Pvt Ltd (NTT DATA)

Start Date: 02/21/2011

End Date: 11/15/2011

Roles and Responsibilities:

● Took care of end-to-end project assignments which included requirement gathering, designing, develop, test, deploying and supporting the integration assignments.

● Interact with the clients and showcase what has been done. Help them understand how the product can be leveraged to improve their business.

● Configured JNDI, Email notifications, Exception handling and Error notifications.

● Worked with functional teams during the end-to-end testing cycle.

● Developed technical documents and release documents.

● Deployment of BPEL interfaces using ANT scripts. Employer: Tech Mahindra Ltd.

Start Date: 02/18/2011

End Date: 03/12/2007

Roles and Responsibilities:

● Analyzing the mapping of the data with the end-System Schema.

● Preparing the review log, query log & other documents related to the process for the project.

● Analysis of the product structure models on Windchill and Oracle PIM (Oracle e-business Suite).

● Analysis of the migration process to be performed for the migration of the products. Page 5

● Writing Java and BPEL code as per the specification.

● Developed the scripts in Java using Windchill APIs for the user to automate the process of creating, deleting, updating the products on Windchill.

● Created custom User Interfaces using JSP.

● Customer interaction for various inputs and activities.

● Installation and configuration of Oracle SOA Suite 10g on Windows XP.

● Involved in understanding the BT product structure and their feasibility in PIM.

● Understanding the BT routers functionality.

● Implemented log messaging concept for entire SOA and ESB services.

● Involved in client-side scripting (JavaScript)

● Assist the recruiters in recruiting and help them build offshore practice. Education

Andhra University, Visakhapatnam, India Mar 2004

M.Sc., Information Systems

Nagarjuna University, Guntur, India Mar 2002

B.C.A (Bachelor of Computer Applications)

Page 6

Contact this candidate