Oracle Integration Cloud Consultant - OIC & ERP Cloud Expert

Deepa Agrawal

Oracle Integration Cloud (OIC) Consultant

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

LinkedIn URL: https://www.linkedin.com/in/deepa-agrawal-727a4219b

PROFESSIONAL SUMMERY

I am Deepa, an IT professional with 3.3 years of experience in IT consulting, specializing in Oracle technologies.

My expertise includes Oracle Integration Cloud (OIC), Oracle ERP Cloud, Platform as a Service (PaaS), and EBusiness Suite implementation and support. I bring a strong problem-solving mindset with a proven ability to identify, analyse and resolve complex issues to enhance customer satisfaction. Since joining Infosys in October 2022, I have been working as an Oracle Integration Consultant, delivering scalable integration solutions for enterprise clients.

TECHNICAL SKILLS

•Extensive experience in designing and developing integrations (ICS) using Oracle Integration Cloud (OIC).

•Proficient in designing end-to-end integration flows between Oracle and non-Oracle systems and implementing them efficiently within OIC.

•Specialized in building Scheduled FBDI automation integrations with callback functionality in OIC.

•Developed integrations leveraging business event subscriptions to ensure real-time data synchronization across applications.

•Built and maintained integrations across multiple Oracle Cloud applications, including Oracle ERP Cloud, HCM Cloud, and Sales Cloud.

•Deep understanding of OIC lifecycle management, including fault handling, encryption, component migration (via packages), lookups, versioning, and cloning.

•Strong experience in designing outbound and inbound flows using OIC for seamless data extraction and transmission, with hands-on expertise in both SOAP and REST APIs.

•Working knowledge of Oracle HCM concepts such as HCM Extracts and HCM Data Loader (HDL)

•Developed BI Publisher (BIP) reports with RTF layouts and bursting capabilities.

•Hands-on experience with Oracle E-Business Suite (EBS) in a techno-functional role, particularly in the SCM module.

PROJECT EXPERIENCE

Client Name: - Confidential

Roles & Responsibilities: -

•Designed and built FBDI Integration in OIC to automate the load of Exchange Rates received from third party vendor in ERP Cloud on daily basis.

•Built Callback Integration to upload the log and output files to SFTP and send notification email to user about Import status.

•Developed Business Event Subscription Based integration in OIC to send Fusion Updates to downstream systems

•Built Outbound flow integration to do bulk extraction of data using BIP Report and send it to downstream systems.

•Built Purchase Order REST API to Import PO’s into SCM Cloud

•Involved in migrating integrations from one OIC Instance to another using archive files

Client Name: - Confidential

Roles & Responsibilities: -

•Built Scheduled Integration to automate the data load into HCM Cloud using HCM Data Loader service.

•Built Scheduled Integration to automatically get the updates from HCM Cloud using Atom Feeds feature in OIC.

Client Name: - Confidential

Roles & Responsibilities: -

•Built Complex Journal Import SOAP Service to import journals in ERP Cloud.

•Built GL Integration using Oracle Integration Cloud to import journals in ERP Cloud using JournalImportService and ERPIntegrationService.

•Built Integrations in OIC to connect Salesforce CRM System with Oracle ERP Cloud.

•Designed and built an Integration in OIC to Create/Update customers in ERP cloud using fusion standard web services like LocationService, OrganizationService and CustomerAccountService.

EDUCATION

B. Tech (SSVPS's COLLEGE OF ENGINEERING, DHULE) 2018-2022

CERTIFICATION

•Oracle Cloud Infrastructure 2025 Generative AI Professional.

•Oracle APEX Cloud Developer Professional.

•Oracle Cloud Infrastructure 2025 Certified Foundations Associate.

Contact this candidate