Oracle Cloud Integration Specialist with OIC Expertise

MOHIT YADAV

+91-962******* ************@*****.***

linkedin.com/in/mohit-yadav Lucknow, Uttar Pradesh, India PROFESSIONAL SUMMARY

Oracle Certified Application Integration Professional with 2+ years of proven experience in architecting and delivering enterprise-grade cloud integration solutions. Highly skilled in Oracle Integration Cloud (OIC Gen2/Gen3), designing scalable REST and SOAP APIs, and automating complex ERP business workflows. Specialized in Oracle Fusion FSCM and HCM integrations, FBDI data imports, BI Publisher reporting, and building robust, fault-tolerant integration frameworks. Successfully delivered mission-critical integrations processing 15,000+ daily transactions with 99.9 TECHNICAL SKILLS

Cloud Integration Platforms: Oracle Integration Cloud (OIC Gen2, Gen3), Oracle Fusion Middleware, Cloud Gateway Integration Patterns: App-Driven Orchestration, Scheduled Orchestration, Basic Integration, Event-Driven Architecture APIs & Web Services: REST API, SOAP Web Services, JSON, XML, API Gateway, Microservices, Webhook Integration OIC Adapters: REST Adapter, SOAP Adapter, FTP/SFTP Adapter, Database Adapter, ERP Cloud Adapter, HCM Adapter, File Adapter, Stage File Action

Oracle Fusion Cloud: FSCM (Financials, Supply Chain), HCM, Account Payable (AP), Account Receivable (AR), General Ledger (GL), Fixed Assets (FA)

Data Integration: FBDI (File-Based Data Import), BI Publisher (BIP) Reports, Data Mapping, XSLT Transformations, ETL Programming & Databases: SQL, PL/SQL, JavaScript, HTML, CSS, Oracle ATP, Database Triggers, Stored Procedures Integration Components: Connections, Orchestration Flows, Mapping, Lookups, Flow Control, Error Handling Frameworks

Operations & Support: Integration Monitoring, Fault Tracking, Payload Debugging, Reprocessing, SLA Management PROFESSIONAL EXPERIENCE

Oracle Integration Developer (OIC) Feb 2024 – Present Quaere e-Technologies Pvt. Ltd. (CMMI Level-3) Lucknow, India Client: OnSemi Corporation, USA (Offshore Delivery Model)

• Architected and delivered 20+ end-to-end integration solutions for Fortune 500 semiconductor manufacturer, automating Oracle ERP Fusion workflows with on-premise and cloud systems, reducing manual processing by 65% and saving 200+ operational hours monthly

• Designed and implemented comprehensive Oracle Fusion Account Payable (AP) integrations using ERP Cloud Adapter, leveraging FBDI templates and pre-defined Fusion REST/SOAP endpoints to process 5,000+ invoice transactions daily with 99.8% accuracy

• Engineered robust inbound and outbound integration flows using App-Driven and Scheduled Orchestration patterns, orchestrating data synchronization across REST, SOAP, FTP, File, Database, and ERP adapters with zero data loss

• Developed 15+ custom BI Publisher reports with complex SQL queries and data models, integrated seamlessly into OIC workflows for automated report generation and distribution, reducing report delivery time from 4 hours to 15 minutes

• Built enterprise-grade FTP/SFTP integration framework performing automated file operations (List, Read, Write, Move, Delete) on 800+ files daily, implementing retry logic and encryption protocols ensuring 100% data security and compliance

• Implemented Stage File Action processing for files downloaded from FTP adapter in OIC-managed staged locations, enabling complex file transformations and validations before ERP import, improving data quality from 87% to 99.5%

• Created reusable XSLT transformations for advanced flow control, conditional logic, and output formatting across 25+ integration flows, standardizing data transformation patterns and reducing development time by 40%

• Utilized advanced OIC mapper functions including String manipulation, Date formatting, Mathematical operations, and Integration Cloud Lookups for sophisticated data validation and transformation logic across enterprise systems

• Established comprehensive Error Handling Framework with custom fault policies, notifications, and automated recovery mechanisms, achieving 95% first-time fix rate and reducing mean time to resolution (MTTR) from 4 hours to 45 minutes

• Implemented proactive integration monitoring using OIC Monitoring Dashboard, tracking message flows, identifying performance bottlenecks, diagnosing payload failures, and performing reprocessing within stringent SLA requirements of 99.7% uptime

• Configured secure connections and authentication mechanisms (OAuth 2.0, Basic Auth, API Keys) for 30+ external systems, ensuring enterprise-grade security and compliance with data protection regulations

• Led technical design sessions and code reviews with cross-functional teams, created comprehensive integration specifications and technical documentation, reducing knowledge transfer time by 50% and improving team productivity by 35%

• Optimized integration performance through connection pooling, parallel processing, and payload compression techniques, improving throughput by 60% and reducing average response time from 8 seconds to 3 seconds

• Delivered production support with 24x7 on-call responsibilities, managing critical incidents, performing root cause analysis, and implementing permanent fixes within SLA commitments, maintaining 99.9% customer satisfaction rating

KEY PROJECTS & TECHNICAL ACHIEVEMENTS

OnSemi ERP Fusion Automation Suite: Led complete integration suite connecting Oracle Fusion FSCM with SAP, Salesforce, and legacy systems for global semiconductor operations, processing $1M+ in AP transactions monthly across 10+ countries with multi-currency support

FBDI Mass Data Upload Framework: Architected automated FBDI framework for bulk imports across GL, AP, AR, and FA modules, successfully migrating 150,000+ financial records from legacy systems with 99.9% accuracy and zero business disruption

Real-Time BI Reporting Engine: Developed automated BI Publisher reporting solution with scheduled orchestrations delivering 35+ critical financial and operational reports to stakeholders globally, improving decision-making speed by 70%

Enterprise FTP Integration Hub: Built centralized FTP/SFTP integration platform handling secure file transfers between Oracle Cloud and 20+ external vendors, processing 10000+ files monthly with automated error recovery and audit trails Error Handling & Monitoring Framework: Designed enterprise-wide error handling framework with custom fault handlers, automated notifications, and self-healing capabilities, reducing support tickets by 55% and improving system reliability to 99.9%

CERTIfiCATIONS

Oracle Cloud Infrastructure 2025 Certified Application Integration Professional Issued: Oct 2025 Oracle - Badge ID: Verified Professional Certification Valid Until: Oct 2027

• Validated expertise in leveraging Oracle Integration Cloud (OIC) to design and implement cloud and on-premises application integrations with proven knowledge of OIC architecture, use cases, and industry best practices EDUCATION

Bachelor of Technology (B.Tech) in Electrical Engineering Jan 2019 – Jan 2023 Ashoka Institute of Technology and Management Varanasi, Uttar Pradesh, India LANGUAGES & ADDITIONAL INFORMATION

Languages: English (Professional Working Proficiency), Hindi (Native) Professional Interests: Cloud Architecture, Enterprise Integration Patterns, API Design, Microservices Location: Varanasi, Uttar Pradesh, India (Open to relocation)

Contact this candidate