Praneeth Gaddam

• Architected and developed intricate integration solutions utilizing Oracle Integration Cloud (OIC), including orchestrating business processes, transforming data formats, and integrating disparate systems both on-premises and in the cloud.
• Engineered custom adapters and connectors using Java and JavaScript to extend the functionality of OIC and integrate with proprietary or legacy systems, ensuring seamless interoperability and data exchange.
• Optimized integration flows within OIC to enhance performance, reduce latency, and increase throughput, utilizing advanced techniques such as parallel processing, caching, and asynchronous messaging.
• Implemented robust error handling mechanisms and monitoring capabilities within integration flows, including exception handling, fault tolerance, and logging, to ensure data integrity and system reliability.
• Implemented CI/CD pipelines using DevOps practices and tools such as Jenkins and Git to automate build, testing, and deployment processes for OIC integrations, enabling rapid iteration and deployment cycles.
• Integrated security features such as OAuth authentication, SSL/TLS encryption, and role-based access control (RBAC) into OIC integrations to ensure data confidentiality, integrity, and availability in compliance with industry standards and regulations.
• Conducted performance tuning and scalability assessments for OIC integrations, analyzing bottlenecks, optimizing resource utilization, and implementing horizontal and vertical scaling strategies to meet growing demand and workload requirements.
• Technical Documentation and Knowledge Sharing: Produced comprehensive technical documentation, including design specifications, deployment guides, and troubleshooting procedures, to facilitate knowledge sharing and ensure smooth handover to operations and support teams.
• Successfully set up the OIC Gen 3 environment, replicating necessary configurations and ensuring compatibility with existing workflows.
• Executed the export of integrations from OIC Gen 2 and seamless import into OIC Gen 3.
• Updated and optimized endpoints and configurations to leverage new features and enhancements in Gen 3.
• Re-engineered complex integration flows to optimize performance and utilize new Gen 3 capabilities.
• Migrated and reconfigured connections for databases, SaaS applications, onpremise systems, and other endpoints to ensure seamless communication in the Gen 3 environment.
• Cross-functional Collaboration and Mentorship: Collaborated with cross-functional teams including business analysts, solution architects, and QA engineers to gather requirements, design solutions, and validate implementations, while providing mentorship and guidance to junior developers on OIC best practices and design patterns.
• Developed integrations using Oracle Integration Cloud (OIC) based on GEN-906 technical document.
• Developed and deployed custom integrations using Oracle Integration Cloud (OIC) to facilitate seamless communication between on-premise systems and cloud applications hosted on Azure.
• Leveraged Azure Data Factory and OIC to create automated data pipelines, ensuring efficient data synchronization and transfer between Oracle ERP and external systems.
• Implemented secure OAuth 2.0 and SAML-based authentication protocols for integrations between OIC and Azure-hosted applications, ensuring compliance with security policies.
• Designed and developed OIC utilities for Fusion ERP integrations.
• Created Unit test cases and testing document for integrations that I have developed.
• Interaction with Employee REST service of Oracle HCM Cloud for fetching employee details to submit employee expenses from Concur systems.
• Implemented Schema (XSD) design for different business processes.
• Worked on provisioning an Oracle Integration Cloud instance.
• Creating demo scenarios for client and preparing the design documents based on the client requirement.
• Understanding different Cloud and on-premises APIs and analyzing most common interfaces which are expected to be used by different clients.
• Developed OIC utilities for migration of OIC artifacts to UAT and Production.
• Involved in SR request for Bug fixing/Support activities.
• Worked on various integration and involved in SIT, UAT testing.
• Gathered requirements by interacting with the source and target system.
• Participated in go-live, migration and post-production deployment support.
• Tracked all deployment and implementation related issues on JIRA.
• Used SVN repository to store SOAPUI projects and java code co-ordination with the offshore & Onshore development teams to address technical or business requirements related.
• Environment: Oracle Integration Cloud (OIC), using various adapter like (SOAP, REST, FTP, DB, ERP cloud adapters), Oracle DB, SQL Server, MDS, XML, WSDL, XSLT, JSON, POSTMAN.

• Providing and implementing integrations among different cloud applications and on-premises application using Oracle Integration Cloud.
• Designed and developed end-to-end integrations using Oracle Integration Cloud (OIC Gen 2) leveraging App Driven Orchestration, Scheduled Orchestration, and File-based patterns.
• Configured and utilized ERP Cloud Adapter, REST Adapter, SOAP Adapter, FTP Adapter, and Stage File actions to integrate SCM and Financial modules.
• Built Sales Order import integrations using Order Import REST APIs and FBDI templates, invoking ESS jobs such as Import Orders and Process Order.
• Developed shipment and fulfillment integrations using Shipment Confirmation APIs, synchronizing order status with external systems.
• Implemented Inventory integrations using Inventory Transaction Interface and triggered ESS jobs for material transactions and adjustments.
• Designed Purchase Order integrations using PO Import FBDI template, invoking Import Purchase Orders ESS job and handling supplier validations.
• Built Supplier and Supplier Site integrations using Procurement REST APIs to automate vendor master synchronization.
• Developed BOM integrations using BOM FBDI templates and Item Structure REST APIs, supporting multi-level component hierarchy and revision control.
• Implemented Engineering Change Order (ECO) integrations impacting BOM revisions and component updates across manufacturing organizations.
• Designed incremental load strategies using watermark-based processing to handle delta updates for Orders, Inventory, and BOM structures.
• Developed cross-reference mappings and lookup transformations for item validation, supplier mapping, UOM conversion, and organization assignments using OIC mapper.
• Designed and implemented GL Journal integrations using GL Journal Import FBDI template, invoking ESS jobs such as Import Journals and Post Journals.
• Integrated SCM transactions with Subledger Accounting (SLA) ensuring accurate accounting generation and proper interfacing to General Ledger.
• Built reconciliation logic to validate operational SCM transaction totals against GL journal entries for financial accuracy and audit compliance.
• Implemented robust error handling using Scope-based fault handlers, Raise Fault, Retry logic, and Business Identifiers to manage high-volume transaction failures.
• Utilized Stage File (Read File in Segments, Write File, Zip/Unzip) for processing large FBDI files and optimizing performance.
• Secured integrations using OAuth 2.0, Basic Authentication, certificate-based security, and Connectivity Agent for hybrid cloud communication.
• Monitored and tracked integration instances using OIC monitoring dashboard, activity stream logs, and ERP ESS logs for proactive issue resolution.
• Supported quarterly Oracle ERP Cloud upgrades by validating API changes and ensuring backward compatibility of SCM and GL integrations.
• Provided production support, enhancements, and environment migrations (DEV, TEST, PROD) using IAR package deployments and version-controlled release management.
• Designed cross-reference mappings and transformation logic to ensure accurate Supply Chain data synchronization between external systems and Oracle ERP Cloud.
• Involved in production Support and worked with on-site and offshore model.
• Provides project leadership with enhancements and operational activities.
• Assist client in all integration process and design various architecture programs for all application layers.
• Evaluated business processes, technical architecture, and system objectives in response to user requests.
• Worked on technical specifications to independently develop, modify and maintain complex software products.
• Environment: Oracle Integration Cloud (OIC), using various adapter like (SOAP, REST, FTP, DB, ERP cloud adapters), Oracle DB, SQL Server, MDS, XML, WSDL, XSLT, JSON, POSTMAN.

• Designed and developed end-to-end integrations in Oracle Integration Cloud (OIC) between external systems and Oracle ERP Cloud modules including Order Management (OM), Inventory (INV), and Procurement (PO).
• Built REST and SOAP-based integrations to automate order import, fulfillment status updates, inventory adjustments, and purchase order creation using ERP Cloud public APIs and FBDI interfaces.
• Configured and optimized OIC ERP adapters to invoke Order Import, Shipment Confirmation, Inventory Transactions, and PO Import processes.
• Implemented transformation mappings and cross-reference lookups for item validation, customer mapping, supplier mapping, and chart-of-accounts derivation across OM, INV, and PO modules.
• Designed asynchronous orchestration integrations to process high-volume order and procurement transactions with retry mechanisms, fault handling, and error notifications.
• Developed file-based integrations using Stage File and FTP adapters to load bulk OM and PO data via FBDI templates and automate ESS job submission.
• Maintained and enhanced existing integrations by implementing change requests, performance tuning, payload optimization, and version-controlled deployment using IAR packages.
• Implemented real-time inventory synchronization between third-party warehouse systems and Oracle Inventory module using OIC REST integrations.
• Configured business event subscriptions in ERP Cloud to trigger OIC integrations for order status updates, shipment confirmations, and PO approvals.
• Built custom logging, exception handling, and audit frameworks in OIC to track transaction lifecycle across OM, INV, and PO flows.
• Coordinated with functional teams to validate order lifecycle scenarios, PO approval workflows, and inventory transaction postings.
• Managed Dev, Test, and Production migrations of integrations using export/import of IAR files and environment-specific configurations.
• Troubleshoot production issues including stuck orders, failed inventory transactions, and PO import errors by analyzing OIC tracking logs and ERP ESS job reports.
• Designed secure integrations using OAuth, Basic Auth, and certificate-based authentication mechanisms for ERP and third-party system connectivity.
• Built REST-based integrations to create, update, and validate BOM structures, components, and revisions using Oracle ERP Cloud Item and BOM public APIs.
• Developed file-based integrations using FBDI templates for bulk upload of BOM headers, component details, and effectivity dates into ERP Cloud.
• Supported quarterly Oracle ERP upgrades by validating integration compatibility and adapting to API changes across OM, INV, and PO modules.
• Environment: Oracle Integration Cloud (OIC), using various adapter like (SOAP, REST, FTP, DB, ERP cloud adapters), Oracle DB, SQL Server, MDS, XML, WSDL, XSLT, JSON, POSTMAN.

• Designed and built Integrations like Get Property, Create and Update Extended Checklist details in OIC.
• Designed and built Complex AR Self Service extension using VBCS, PCS and Integrations in OIC.
• Developed AR Self Service app user interface using VBCS, and it had some complex pages to create/update/view/delete invoice requests etc.
• Complex multi-layer & conditional approval process is designed in PCS with email notification, escalation, and expiration features. Invoice requests submitted via this VBCS app needs to go through this complex approval route.
• Once invoice request is approved, it needs to be sent over to ERP cloud and created as AR Invoice/Credit Memo and status of invoice also needs to be updated back on VBCS app as approved.
• Designed and built FBDI automation integration in OIC to automate the load of GL Journals feed from EBS System to ERP Cloud daily.
• Built Callback Integration to upload the log and output files to SFTP and send notification email to user about Import status.
• Developed Business Event Subscription Based integration for Item updates in OIC.
• Built Scheduled Integration to automate the data load into HCM Cloud using HCM Data Loader service.
• Designed and built an Integration in OIC to Create/Update customers in ERP cloud using fusion standard web services like Location Service, Organization Service and Customer Account Service.
• Built Integrations in OIC to connect Salesforce CRM System with Oracle ERP Cloud
• Designed and built FBDI automation integration in OIC to automate the load of GL Daily Exchange rates from EBS System to ERP Cloud daily.
• Designed and built Outbound flow (BIP Extract) for employees and assignments data of HCM Cloud.
• Designed and developed an AR Invoice Integration in OIC, which accepts xml payload, generates FBDI file from xml and triggers bulk import to create AR invoices in ERP cloud.
• Built an Integration to achieve the data sync between SaaS and On-Premises application using connectivity agents in OIC.
• Environment: OIC (Oracle Integration Cloud), VBCS, PCS, CX, ERP Cloud, HCM Cloud and EBS Payroll.

• Providing and implementing integrations among different cloud applications and on-premise application using Oracle Integration Cloud.
• Creating demo scenarios for client and preparing the design documents based on the client requirement
• Understanding different Cloud and on-premise APIs and analyzing most common interfaces which are expected to be used by different clients.
• Involved in decision making on choosing Integration platform based on client requirements.
• Worked on configuration steps to provision an Oracle Integration Cloud instance.
• Designed and created complete business processes for orchestration using Oracle Integration Cloud (OIC).
• Prepared Technical design document based on the FDD
• Worked on different cloud applications like ERP cloud (OM and Service Contract Module), Workday, Concur.
• Worked with Functional team closely to understand the requirement.
• Decision Making on choosing Integration platform based on client requirements.
• Worked on configured DB agent & installing certificates in OIC
• Worked on creating common call back service with other developers
• Integrated various cloud based SAAS and On-premises applications like Salesforce, Workday, Oracle HCM Cloud, ERP Cloud, Success Factors, Concur, Ariba, ServiceNow, Siebel, Oracle EBiz. And SAP systems using Oracle Integration Cloud (OIC).
• Worked on error handling framework on Global level as well as scope level.
• Prepared technical design document based on functional design document
• Worked on different modules on OIC (GL,AP,FAH).
• Provide hands on development of solutions
• Worked on document issues resolution & provide status reports to key members
• Completely understand the Cloud data model on worked on it
• Supported integration and PROD environment release.
• Involved in production Support and worked with on-site and off-shore model
• Provides project leadership with enhancements and operational activities
• Assist client in all integration process and design various architecture programs for all application layers
• Evaluated business processes, technical architecture, and system objectives in response to user requests
• Worked on technical specifications to independently develop, modify and maintain complex software products
• Learned and adopts new development methods and techniques
• Stored the code to SVN repository
• Environment: Oracle Service Bus 11g, Oracle BPEL, Oracle SOA Suite 11g, Oracle SOA Suite 12c, Oracle BPM 12C and JDeveloper 12.2.1.3

• Creating technical specification document based on Function document provided by business Functional people.
• Designing & developing various interfaces using Middleware technology in Oracle SOA/OSB 12c.
• Developed both REST/SOA based Interfaces/ Webservices
• Developed SOA composite services using JMS topics/Queues, File Adapter, Database Adapter, web services.
• Developed different type of interfaces which integrate legacy systems with RMS, EBS using Oracle 12c
• Implemented XPath, XQuery and XSLT's to get the data and transform as per the requirements in SOA composite & OSB Proxy.
• Create Design standards, guidelines and best practices around SOA/BPM technology areas with Oracle 12c SOA suite
• Custom development using the identity management API’s to automate user provisioning and user creation
• Configured Assign activity to define the copy rules and add expressions in a BPEL process.
• Responsible to create Database objects required for specific interface as per tech spec document.
• Used EBS suite to Provide robust, consistent integration framework with extensive infrastructure based on SOA principles
• Involved in few SOA administration tasks such as creating and modifying JNDI/Connection Factories and managing data source
• Responsible to create deployment document for migration of component from dev environment to upper environments.
• Used service components like Mediator, BPEL and Human Task
• Redesigned application developed in 11g,12c by using new requirements and SOA 12c interface
• Built SOA composites using BPEL/OSB/Mediator components that exposed some EBS sales order processing functions as web services accessible by all technology platforms in the enterprise through SOAP/WSDL interface.
• Configured JNDI, Integration Connections, DB Connections on Oracle Application Server.
• Worked on messaging, alerts, transformation, and Fault Handling such as Catch and catch all
• Migrated services to 12c from 11g by using existing OSB and SOA components
• Used repository (MDS) to store all the artifacts composites such as XSD, Fault Policy, Fault Binding, and DVM.
• Prepared SOA/OSB Configuration files to handle deployment in higher environment
• Prepared POM Profiles for CI/CD Deployments using Jenkins.
• Responsible to create SOA/OBS WebLogic server configuration document for deployment task.
• Created Unit Test cases for developed interfaces to validate the functionality.
• I had daily discussion with offshore functional & technical people on open issues, requirement understanding etc.
• Worked on creating command line scripts, JIL auto scripts for automatic execution of jobs.
• Configuring Business and Proxy services for various inbound and outbound interfaces in OSB
• Environment: Oracle SOA 12c, OSB 12c, Weblogic Server 12c, JAVA7/8, Oracle DB 12, REST, SOAP, XML, JSON

• Designed and Developed interoperable OSB Services & BPEL processes with insight of future considerations using Oracle OEPE & Oracle SOA suite 11g.
• Handled JDE Real Time Events using OSB proxy services.
• Responsible for deliverables of application deployments into QA & Production.
• Managed design, development and deployment of SOA projects using Cruise Control Tool.
• Created FTP adapters for SFTP through secured layer in order perform to exchange Sales and Purchase order invoices.
• Created best BPEL design to handle transferring of huge documents from AS/400 to Windows file location.
• Created Unit/Integration test scenarios for the developed web services and tested them using SOAP UI/ Rest API and Load UI tool.
• Designed, Developed, and deployed a module that has Oracle OSB service, BPEL process into PROD.
• Enhanced & Customized Oracle Worklist as per the requirements.
• Excellent Knowledge in Installing, Trouble shooting, and Configuring of Oracle SOA/OSBOEPE 11.1.1.7, JDeveloper Admin Server/Enterprise Manager on Web logic Application Server 10.3.6.
• Fine-tuned existing OSB services, File Adapters and JMS adapters in QA and PROD.
• Coordinated with offshore in order to fulfill the requirements.
• Involved in DEV/QA deployments. Acted as POC for production related issues, performance issues and External system integration issues.
• Developed Build scripts for Oracle SOA Composites and OSB Proxy Service for deployment into DEV /UAT / PROD.
• Active participation in defining the process, the scope and maintaining overall customer expectations.
• Adhering to coding standards & best practices of OSB-SOA implementation.
• Managing deliverables within stipulated timelines and assigning work to teammembers.
• Installed the fix packs for the problems to get solved with the Application Server and updating the latest fix packs as per requirement.
• Environment: Oracle SOA 11g, Oracle Weblogic Application Server 10.3.6, Java/J2SE 1.6, JEE 5, JDeveloper 11.1.1.7, Eclipse OEPE 3.6, ADF, Oracle 11g, XSL, XSLT, XPATH, XHTML, XML, XQUERY, OSB, SOA, RTE, BSSV, JMS, JNDI, JDBC, Unix, SVN, CSS.

· Configuring Business and Proxy services for various inbound and outbound interfaces in OSB.

· Developed SOA composite services using File Adapter, Database Adapter, web services.

· Implemented XPath, XQuery and XSLT's to get the data and transform as per the requirements in SOA composite & OSB Proxy.

· Configuring Proxy services to handle various integration patterns for File to File, Database to File, File to Database and Database to Web services.

· Build and test Oracle SOA suite based applications using JDeveloper

· Worked on creating OSB Services (wsdl based, xml based, any soap).

· Worked on developing OSB services supporting various protocols including JMS, file.

· Implemented Content-Based and Dynamic Routing using OSB proxy service message flows.

· Configured Database adapter in Jdeveloper using JNDI to retrieve data and exposed service in OSB as business service using JCA protocol.

· Handled exceptions in BPEL process using Catch and Catch All activities and defined appropriate action using error framework.

· Designed and Implemented BAM report as per the requirement.

· Experience in defect resolutions and configuration management change processes to support applications in PROD and integration testing environments.

· Supported UAT and PROD environment release.

· Involved in production Support and worked with on-site and off-shore model.

Environment: SOA 11g, OSB 11g, Oracle JDeveloper 11g, Eclipse 11g, OEPE, WebLogic Server, WSDL, XML, XSD, XQuery, XSLT.