Oracle Cloud Integration Architect (OIC)

Mohit Yadav

************@*****.*** +91-962******* Lucknow,India mohit-yadav-2610aa258

SKILLS

• Cloud Platforms: Oracle Integration Cloud (Gen2/Gen3), Oracle Fusion Middleware, Cloud Gateway

• Integration Architecture: App-Driven Orchestration, Scheduled Orchestration, Event-Driven Architecture, ETL, FBDI

• APIs & Web Services: REST API, SOAP, JSON, XML, API Gateway, Microservices, Webhooks

• OIC Adapters: REST, SOAP, FTP/SFTP, Database, ERP Cloud, HCM, File, Stage File Action

• Oracle Fusion Cloud: FSCM (Financials, Supply Chain), HCM, Accounts Payable (AP), Accounts Receivable

(AR), General Ledger (GL), Fixed Assets (FA)

• Programming & Databases: SQL, PL/SQL, JavaScript, XSLT, Database Triggers, Stored Procedures

• Data Integration: BI Publisher, FBDI, Data Mapping, XSLT Transformations, ETL, Data Cleansing

• Security & Compliance: OAuth 2.0, Basic Authentication, API Keys, Data Encryption, Compliance Protocols

• Operations: Integration Monitoring, Error Handling, Fault Tracking, SLA Management, 24x7 Production Support

WORK EXPERIENCE

Quaere e-Technologies Pvt. Ltd.

Oracle Integration Developer (OIC) 05/02/24 - 20/01/26

• Architected 20+ end-to-end integration solutions automating Oracle ERP Fusion workflows for Fortune 500 clients, reducing manual processing by 65% and saving 200+ operational hours monthly.

• Designed Oracle Fusion AP integrations using ERP Cloud Adapter and FBDI templates, processing 5,000+ invoice transactions daily with 99.8% accuracy across $1M+ monthly transactions.

• Engineered robust integration flows using App-Driven and Scheduled Orchestration with REST, SOAP, FTP, Database, and ERP adapters, achieving zero data loss and 99.9% uptime.

• Developed 15+ custom BI Publisher reports with complex SQL queries integrated into OIC workflows, reducing report delivery time from 4 hours to 15 minutes.

• Built enterprise FTP/SFTP framework automating file operations on 800+ daily files with retry logic and encryption, ensuring 100% data security and regulatory compliance.

• Created reusable XSLT transformations for flow control and conditional logic across 25+ integrations, standardizing patterns and reducing development time by 40%.

• Established Error Handling Framework with custom fault policies, achieving 95% first-time fix rate and reducing MTTR from 4 hours to 45 minutes.

• Configured secure connections with OAuth 2.0, Basic Auth, and API Keys for 30+ external systems, ensuring enterprise-grade security compliance.

• Delivered 24x7 production support managing critical incidents with root cause analysis, maintaining 99.9% customer satisfaction and meeting SLA commitments. SQL Developer Intern September 2023 - January 2024

• Developed complex SQL queries and stored procedures for data extraction, transformation, and reporting across multiple database systems.

• Created automated BI reports and performed ETL operations for data cleansing, validation, and migration, improving data accuracy by 30%.

PROJECTS

OnSemi, USA – Offshore 4/01/25 - 06/05/25

• Automated ERP Fusion processes integrating multiple on-premise and cloud solutions to streamline financial workflows.

• Designed and developed 20+ integrations using Oracle OIC, implementing App-Driven and Scheduled Orchestration patterns.

• Integrated Oracle Fusion Account Payable module with OIC using ERP Cloud adapter, leveraging FBDI templates and pre-defined Fusion REST/SOAP endpoints.

• Built custom BI Publisher reports and integrated them into OIC workflows for automated financial reporting and analytics.

• Implemented FTP adapter operations (List, Read, Write, Move, Delete) to retrieve and process files from external systems.

• Developed Stage File Action integrations to perform advanced transformations and validations on FTP-downloaded files in staged locations.

• Utilized multiple OIC adapters including REST, SOAP, FTP, File, Database, and ERP Cloud adapters for comprehensive integration coverage.

• Applied mapper functions (String, Date, Mathematical, Lookup) for complex business logic, data transformations, and validations.

• Implemented XSLT transformations to define flow control, conditional logic, and structured output formats.

• Monitored integration performance and health using OIC monitoring features, ensuring 99.8% transaction accuracy and zero business disruption.

DANA, USA – Offshore 10/6/2025 - 15/10/25

• Automated EB portal processes to streamline ERP Fusion workflows with on-premise and cloud-based applications.

• Developed App-Driven Orchestration integrations for CRUD operations, enabling real-time data synchronization across systems.

• Built scheduled integrations for stored procedure execution and ESS (Enterprise Scheduler Service) Jobs scheduling.

• Integrated BI Publisher reports into OIC workflows for automated reporting and data distribution.

• Implemented FTP/SFTP operations with Stage File Actions for advanced file processing and transformation.

• Utilized REST, SOAP, FTP, and Database adapters to connect heterogeneous systems and ensure seamless data flow.

• Applied XSLT transformations for complex data mapping and conditional routing logic.

• Leveraged OIC mapper functions for data validation, cleansing, and business rule enforcement.

• Monitored integration instances using OIC tracking and monitoring capabilities, reducing processing time by 60%.

DANA, USA – Offshore 25/10/25 - 20/01/26

• Architected automated FBDI framework to facilitate large-scale data migration from legacy ERP systems to Oracle Fusion Cloud.

• Designed and developed integrations for bulk imports across General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), and Fixed Assets (FA) modules.

• Integrated Oracle Fusion modules using ERP Cloud adapter with FBDI templates and REST/SOAP endpoints for data loading operations.

• Built scheduled orchestrations to automate batch processing and ESS job submissions for data import validation.

• Developed Stage File Action integrations to validate, transform, and prepare legacy data before ERP import.

• Created reusable FBDI templates and validation mechanisms to standardize data import processes across multiple modules.

• Implemented comprehensive error handling and data quality checks, achieving 99.9% migration accuracy with zero downtime.

• Utilized FTP adapter for file retrieval from legacy systems and performed List, Read, Write, and Move operations.

• Applied XSLT transformations for complex data restructuring and mapping legacy formats to Oracle Fusion data models.

• Leveraged OIC mapper functions for data cleansing, lookup operations, and business rule validations.

• Monitored migration progress using OIC monitoring dashboards, reducing migration time by 75% compared to manual processes.

• Provided technical documentation and knowledge transfer, enabling rapid deployment for future migration projects.

EDUCATION

Ashoka Institute of Technology and Management

Bachelor of Technology (B.Tech) in Electrical Engineering - 7.210.0 20 Jan 2019 - 20 March 2023 CERTIFICATE

Oracle Cloud Infrastructure 2025 Certified Application Integration Professional

• Validated expertise in OIC architecture, cloud/on-premises integrations, and enterprise best practices LANGUAGE

English Fluent

Hindi Fluent

Contact this candidate