POOJA CHAUHAN

• Designed, developed, and deployed enterprise integrations using Oracle Integration Cloud (OIC) across Oracle EBS, Oracle Fusion, WMS Cloud, Salesforce, and third-party systems.
• Developed and consumed REST and SOAP services, including payload design, mapping, enrichment, and transformation.
• Performed Oracle EBS technical validations using standard tables, interfaces, concurrent programs, and APIs.
• Worked with PL/SQL procedures and packages for backend validations, data extraction, and reconciliation.
• Built and scheduled BI Publisher reports using XML, RTF templates, and SQL queries.
• Developed and analyzed OTBI reports for Oracle Fusion across SCM and financial modules.
• Designed fault handling frameworks, tracking, reprocessing, and notification mechanisms in OIC.
• Prepared technical design documents (MD050), functional documents, deployment plans, and handover documentation.
• Provided L2/L3 production support, root-cause analysis, and performance tuning.

Major Integration Projects

Salesforce – Oracle EBS Integrations

• Developed OIC integrations for Sales Order Creation, Order Line Updates, Order Cancellation, Payment Creation, and Item Master synchronization.
• Implemented Customer, Bank, Contact, and Contact Site integrations from Salesforce to Oracle EBS.
• Designed robust validation logic and fault handling to ensure data accuracy and reliability.
• Reduced manual data entry and improved order processing efficiency.

Salesforce – Oracle Fusion Integrations

• Built integrations between Salesforce and Oracle Fusion for Sales Order creation and customer data synchronization.
• Used Oracle Fusion REST services and OIC integration patterns for transformation and routing.
• Supported testing, deployment, and post-go-live stabilization.

WMS Cloud – Oracle EBS Integrations

• Implemented integrations for Sales Orders, Vendor Creation, Work Orders, and Inventory updates between WMS Cloud and Oracle EBS.
• Designed real-time and scheduled integrations to ensure warehouse and ERP data consistency.
• Supported cutover activities and hypercare support.

Infinite – Oracle EBS Sales Automation

• Automated inbound sales order creation from Infinite system to Oracle EBS.
• Implemented pricing, item, and customer validations.
• Significantly reduced manual intervention in sales order processing.

MENAITech – Oracle EBS Financial Integrations

• Created APIs to automate GL Journal creation from MENAITech to Oracle EBS.
• Ensured accounting compliance and accurate financial postings.
• Implemented error handling and reconciliation mechanisms.

Vonoy – Oracle E-Business Suite (EBS) Integrations

• Implemented end-to-end bi-directional integrations between Vonoy and Oracle Business Suite to automate sales orders, return orders, picked orders, and invoicing processes.
• The solution enabled real-time and batch synchronization of transactional data, reducing manual intervention and ensuring data accuracy across systems.

Amazon EDI (AS2) - Oracle Integration Cloud

• Implemented Amazon EDI integrations using AS2 protocol through Oracle Integration Cloud.
• Configured OIC B2B Trading Partner Management for Amazon.
• Managed AS2 certificates, OCI certificates, encryption, and secure connectivity.
• Implemented inbound and outbound EDI flows for Invoices,Advance Shipment Notices (ASN).
• Resolved issues related to multiple AS2 connections, certificate mismatches, and endpoint validation.
• Led integration of enterprise software systems to streamline operations and enhance data accuracy.

• Generated various Outbound Interfaces and Custom reports.
• Developed technical MD70, MD120 and Functional MD50 document for application customization and enhancement.
• Creation and Customization of existing Reports for different Modules like(AP, AR, PO).

• Worked on integration and support projects.
• Developed PL/SQL, BI/XML, RDF Reports for various modules like AP, AR, CRM, INV, GL.
• Developed Inbound interfaces and Outbound by using different platforms like .Net/Jason/OIC/Postman. Fetched the data from third party and creation of AP/AR/Sales Order Interface.