Oracle Integration Cloud (OIC) Developer - Immediate Joiner

YASHWANT LOHARI

Oracle Integration Cloud (OIC) Developer

****************@*****.*** +91-845******* Pune, India

Oracle Integration Cloud Oracle Fusion ERP

Professional Summary: - Oracle Integration Cloud (OIC) Developer with 2 years of experience in designing and deploying integrations across Oracle Fusion ERP, Salesforce and On-premises Applications. OIC Application Integration Certified Specialist skilled in VBCS, REST/SOAP APIs, FBDI-based automation, and OCI services such as ATP Database, OCI Streaming, and OCI Object Storage. Hands-on experience in code deployment.

Professional Experience: -

Over 2 years of experience in designing, implementing, and managing Oracle cloud integration and application using OIC and Oracle VBCS

Developed and supported custom integrations using OIC for seamless data flow between Oracle Fusion modules and external systems.

Worked on Financial module such as AP, GL by using FBDI and FAH Approach.

Have good knowledge of Web Service, WSDL, SOAP, XML, REST API,ORDS, XSLT

Strong Knowledge on using various adapters like REST, SOAP, FTP, DB, ERP.

Worked on end-to-end Implementation of the OIC Project

Integrated VBCS applications with Oracle Fusion ERP using Oracle Integration Cloud (OIC) for real-time data synchronization across modules like Financials, HCM, and Procurement.

Worked with Oracle ATP databases for storing application data, optimizing queries for enhanced performance.

Designed and implemented custom applications using VBCS to enhance user experience and optimize business workflows.

Performed data migrations using FBDI ensuring accurate data transfer and integrity

Troubleshot and resolved technical issues, providing production support and maintaining system stability.

Worked on OCI streaming Services Object Bucket, Bastian Connectivity with help of OCI services.

Technical Skills: -

OIC (Oracle Integration Cloud)

Rest full API Integration

Soup UI, Postman, WIN-SCP, FILE ZILLA

Inbound and Outbound Interfaces

VBCS VB Studio Role Based Security

Git / Git Hub

FBDI (File Based Data Import)

Oracle Reports (BIP)

P2P and O2C Cycle

Languages: JavaScript, SQL, PL/SQL

Tools & Technologies: Oracle Integration Cloud, Visual Builder Cloud Service, Oracle Fusion ERP, REST, SOAP, Web Services

Platforms: Oracle Cloud Infrastructure, Oracle Autonomous Database. Certifications:

Oracle Cloud Infrastructure Foundations 2025 Certified Associate

Oracle Cloud Platform Application Integration 2025 Certified Specialist

Oracle Cloud Infrastructure Generative AI Certified Professional

Oracle AI Agent Studio Certified Professional

Academics Details:

Govt. College of Engineering Chandrapur - (2023)

Bachelor of Engineering in Electronics and Telecommunication.

(7.23 CGPA)

Work Experience: –

IntegrationWings Consultancy India PVT LTD Pune, 411057

(From Jan 2024 to Dec 2025)

Project Experience: -

Project – 1:-

Client Name: General Eastern Insurance Malesia (GE) Project Name: Deloitte

Roles and Responsibilities:

● Worked on AP Invoice Integrations utilizing the FBDI (File-Based Data Import) process to load and import AP invoices into Oracle Fusion Applications

● Designed and implemented an FBDI-based integration to automate the end-to- end AP Invoice import process in Oracle Cloud.

● Developed a PL/SQL package to load data from source files into staging tables, followed by procedures to move validated data into interface tables.

● Created a dedicated data validation package to ensure accuracy and completeness of the invoice data before processing.

● Built integrations for multiple source systems such as DCMS and BACA, designing separate processing logics to handle source-specific formats and business rules.

● Developed two independent code modules to process files based on the respective source type.

● Implemented AP Common Import to upload data into Fusion, along with a call- back mechanism to fetch the status of successfully validated and imported invoices.

● Involved in migration activities across environments, ensuring smooth deployment and configuration setup in each stage.

● Prepared and maintained comprehensive Technical Design Documents (TDDs) covering all functional and technical aspects of the AP FBDI integration. Environment: Oracle Fusion Cloud Applications, ATP Database, BIP, Oracle SQL Developer, Postman, XML, BI Publisher, WinSCP, Excel, Outlook, etc.OCI Bastian

Project – 2:-

Client Name: Affine Bank Malesia

Project Name: Deloitte

Roles and Responsibilities:

● Worked on the Ramco Payroll Integrations based on FAH

● Integration is based on the Financial Accounting Hub to Import the GL in Oracle Cloud.

● They have different entity code as like (ABB,ABS,AHIB,AHTB)

● The GL report should be generated in text file format with the file naming format of <OUCode>_HR_YYYYMMDD.txt where,

• OU Code- System to fetch the Code applicable for the OU (legal entity)

• HR – Default HR always

• YYYYMMDD should be the posting date at the time of report generation in YYYYMMDD format.

● According to this Entity code we have developed the 6 OIC integrations for each entity code.

● According to OU code we have different different sample files to processed each file and import the GL data into Oracle Cloud

● Worked on the Migration from test to UAT environment.

● Worked on the mentaining the technical design document for the Ramco Payroll integration.

Environment: Oracle Fusion Cloud Applications, ATP Database, BIP, Oracle SQL Developer, Postman, XML, BI Publisher, FileZilla, WinSCP, Excel, Outlook, etc.

Project - 3:

Client Name: NETAPP

Project Name: Elevate. Law

Roles and Responsibilities

● Designed and implemented OIC integration in between Oracle CDM and Salesforce.

● Designed and implemented Oracle Integration Cloud (OIC) integrations between Oracle Customer Data Management (CDM) and Salesforce.

● Developed and delivered 8 outbound integrations based on the publish-subscribe model, as per business requirements.

● Configured integrations to be automatically triggered by Oracle Cloud Infrastructure (OCI) Streaming Services, eliminating the need for scheduled execution.

● Acted as an integration architect by leading the design and documentation of integration solutions.

● Collaborated on the implementation and configuration of OCI Streaming components to facilitate real-time data delivery.

● Successfully completed code development, performed Functional Unit Testing

(FUT), and migrated the solution to the System Integration Testing (SIT) environment.

Project – 4:

Client Name: Mastek

Project Name: Camden Gen 1 Gen2

Roles and Responsibilities:

● Worked on the AP Invoice FBDI Integration.

● Worked on the Read Fixed length File Format.

● Import Bulk data of AP Invoices with help of AP payment file

● Worked on the AP Integration by using various adapters like REST, SOAP, FTP, DB, and ERP.

● Experience in using tools like WINSCP, Postman, and SOAP UI.

● Worked on end-to-end Implementation of the Project. Environment: Oracle Fusion Cloud Applications, ATP Database, BIP, Oracle SQL Developer, Postman, XML, BI Publisher, FileZilla, WinSCP, Excel, Outlook, etc.

Project - 5:

Client Name: Deloitte

Project Name: Tantranzam

Roles and Responsibilities:

● Developed Redwood-compliant UI pages for Sub-Inventory creation and transaction management using Oracle VBCS.

● Customized VBCS components (input forms, tables, switches, dropdowns

● Created and configured Business Objects and Service Connections to fetch data from Oracle Fusion via REST APIs and Web Services.

● Integrated BI Reports in OIC, fetched data from Fusion Applications, and posted it dynamically to VBCS pages.

● Designed and deployed two core Redwood-styled pages on Oracle Fusion through Fusion Sandbox, enabling users to manage sub-inventory transactions directly from Fusion UI.

● Have good knowledge of Web Service, WSDL, SOAP, XML, REST API, ORDS, and XSLT.

● Experience in using tools like, Postman, and SOAP UI.

● Worked on end-to-end Implementation of the Project. Environment: Oracle Visual Builder, Oracle SQL Developer, XML/BI Publisher, Excel, Outlook, etc.

Project -6:

Client Name: Digile

Project Name: Integration Design for PIL

Roles and Responsibilities:

● Worked on Oracle Integration Cloud (OIC) for SCM Module integrations.

● Developed BIP Reports to support integrations.

● Designed integrations for PIL (Creating item structure for work order, Creating, Updating,

● Experience in using various adapters like REST, SOAP, FTP, DB, and ERP.

● Worked on Oracle Integration Cloud (OIC) for SCM Module integrations.

● Developed BIP Reports to support integrations.

Environment: Fusion 12c BIP, PaaS, Oracle SQL Developer, XML, Excel, Outlook.

Field of Interest: -

Oracle Fusion Technical

Solution Architect

Database Management

HCM

Strength: -

Positive Attitude

Quick Learner

Problem Solving Skills

Declaration: -

I hereby declare that the above information is true and correct to the best of my knowledge and belief.

Yashwant Lohari

Contact this candidate