Somil
Noida
Summary
Oracle Integration Cloud (OIC) Consultant with 5 years of experience, including 3.5+ years of hands-on expertise in designing, developing, and supporting enterprise integrations. Proven experience working with Oracle EBS, Fusion ERP, CRM, EMS, and Okta. Skilled in REST/SOAP APIs, FBDI, FTP/File-based integrations, and data transformation using XML, JSON, and XSLT. Strong expertise in synchronous and asynchronous orchestration, error handling, retry mechanisms, and API security (OAuth). Experienced in delivering scalable, high-performance integrations with robust monitoring and fault tolerance.
Overview
5
5
years of professional experience
Work History
Consultant
Genpact
06.2025 - Current
• Developed and enhanced event-driven asynchronous integration between Oracle ERP and Monaco manufacturing system using Oracle Integration Cloud (OIC), enabling seamless routing and production data synchronization.
• Built synchronous and asynchronous orchestration flows to handle real-time and batch processing scenarios.
• Performed root cause analysis (RCA) and resolved integration failures, improving system reliability by 30%.
• Implemented error handling, retry mechanisms, and logging frameworks for better monitoring and fault tolerance.
• Developed REST and SOAP-based integrations for secure and scalable system communication.
• Collaborated with cross-functional stakeholders to deliver scalable integration solutions
EMS Technical Analyst
Vertiv
01.2024 - 06.2025
• Designed and implemented EBS to EMS integration to automate entitlement creation based on order lifecycle events.
• Developed EMS to Okta integration for automated user onboarding, group assignment, and access management.
• Built API orchestration workflows to provision users and entitlements, reducing manual effort by 40%.
• Implemented FBDI-based bulk data integrations for invoice processing, including file generation, FTP upload, and UCM import.
• Developed complex transformation logic using XML, JSON, and XSLT for multi-system data mapping.
• Implemented validation rules and business logic to ensure data accuracy before downstream API calls.
• Designed fault handling and retry mechanisms using OIC scopes and global fault handlers.
Integration Engineer
Acidaes Solutions (BusinessNext)
04.2021 - 01.2024
• Developed integrations for BFSI clients including ADIB and Bank Danamon to enable seamless data exchange between CRMNext and banking systems.
• Coordinated with stakeholders to gather requirements and prepared technical design and mapping documents.
• Implemented REST and SOAP API integrations to connect CRMNext with upstream and downstream applications.
• Built database integrations using SQL and stored procedures for reliable data synchronization.
• Supported integration development and testing using Oracle Integration Cloud (OIC) to ensure smooth system communication.
Education
Bachelor of Technology - Computer Science
Lovely Professional University
07-2021
Skills
Oracle Integration Cloud (OIC Gen2/Gen3)
Oracle EBS, Fusion ERP, CRMNext, EMS, Okta
REST APIs, SOAP Web Services, OAuth 20
FBDI, UCM Upload, FTP, File Adapter, Stage File
XML, JSON, XSLT, Data Mapping
SQL, Stored Procedures, Database Adapter
BI Publisher (BIP), OTBI (Basic Reporting)
Synchronous & Asynchronous Integrations
Error Handling, Retry Mechanism, Fault Handling, Parking Lot
Connectivity Agent, Integration Monitoring, Logging
Bulk Data Processing, API Orchestration
Projects
• Oracle ERP to Monaco Integration:
Developed event-driven asynchronous integration using OIC to transfer routing data from Oracle ERP to Monaco for manufacturing processing, leveraging business events, data transformation, and database exchange mechanism.
• EBS to EMS Integration:
Automated entitlement creation based on order completion using OIC, including node extraction and API orchestration.
• EMS to Okta Integration:
Implemented user provisioning flow, including group assignment and activation email using Okta APIs and OIC orchestration.
• CRMNext Banking Integrations:
Delivered integrations for Rehab, Retention, KAR (Locker Access),Stop Cheque Payment and Customer 360 for BFSI clients, enabling seamless system communication.
Timeline
Consultant
Genpact
06.2025 - Current
EMS Technical Analyst
Vertiv
01.2024 - 06.2025
Integration Engineer
Acidaes Solutions (BusinessNext)
04.2021 - 01.2024
Bachelor of Technology - Computer Science
Lovely Professional University