Senior Oracle OIC Cloud Integrations Lead Consultant

MANIKANTA SRIRAMOJU

346-***-**** *********.***********@*****.*** Linkedin

Work Authorization: H1B Relocation: Open

Senior Oracle ERP Cloud Developer / OIC Lead Consultant

Oracle Fusion Cloud OIC SOA REST/SOAP HCM, Finance & SCM Integrations BI & Reporting VBCS

PROFESSIONAL SUMMARY

Senior Oracle Integration Cloud (OIC) Developer with 8 years of experience designing and delivering enterprise integrations across Oracle Fusion Financials, HCM, and SCM ecosystems. Extensive expertise building secure, scalable integrations using Oracle Integration Cloud (OIC), REST/SOAP APIs, FBDI, HDL, and file-based interfaces connecting Oracle Fusion with third-party enterprise systems.

Strong experience supporting core financial business processes including Order-to-Cash (O2C), Procure-to-Pay (P2P), and Record-to-Report (R2R) through integrations involving AR invoices, customer master data, receipts, credit/debit memos, AP invoice processing, supplier payments, and financial journal interfaces.

Proven ability to design high-volume integration architectures, resolve journal posting failures, accounting derivation issues, and financial data mapping inconsistencies, close sub-ledger-to-GL reconciliation gaps, and optimize XML/XSLT/JSON transformations for performance and reliability.

Experience working with Oracle Fusion Expenses module including expense report integrations, validations, and reimbursements processing.

Strong hands-on experience in SQL and PL/SQL for data validation, reconciliation, and performance tuning.

Expertise in BI Publisher (BIP) reporting and financial data extraction

Hands-on experience working with Oracle PaaS stack including OIC, VBCS, and exposure to PCS (Process Cloud Service), ATP (Autonomous Transaction Processing), and IDCS for identity and access management in cloud-based integrations.

TECHNICAL SKILLS

Integration & Middleware: Hands-on experience working with Oracle PaaS stack including OIC, VBCS, and exposure to PCS (Process Cloud Service), ATP (Autonomous Transaction Processing), and IDCS for identity and access management in cloud-based integrations.

Oracle Fusion Cloud: Financials (GL, AP, AR, FA), SCM, and HCM

HCM Integrations: HCM Extracts, HDL, Worker, Assignment, Payroll, Benefits

Reporting & Documents: BI Publisher (BIP), OTBI, Payment Outputs

Low-Code Development: Oracle Visual Builder Cloud Service (VBCS)

Databases: Oracle PL/SQL, SQL

Architecture: Integration patterns, orchestration, event-driven integrations

Tools: Git (CI/CD exposure), SFTP, PGP Encryption

Migration: CRP, UAT, Project Costing, Project Billing, Capital Projects, Data Migration (FBDI/ADFDI), Functional Design

ORACLE PAAS EXPERTISE

• Designed end-to-end Oracle PaaS solutions leveraging OIC, VBCS, and database services.

• Exposure to Process Cloud Service (PCS) for workflow automation and approval-based processes.

• Experience integrating OIC with Autonomous Transaction Processing (ATP) for high-performance data operations.

• Knowledge of Identity Cloud Service (IDCS) for secure authentication and user role management.

• Strong understanding of Oracle Cloud architecture, integration patterns, and security best practices.

PROFESSIONAL EXPERIENCE

Senior Oracle Fusion Integration Consultant (OIC)

Cantor Fitzgerald – Investment Banking

Oct 2024 - Present

Location: USA

Delivered 50+ Oracle Integration Cloud (OIC) integrations across Oracle Fusion Financials, HCM, SCM, and Fixed Assets modules supporting high-volume enterprise transactions.

Implemented event-driven integrations using Oracle HCM ATOM Feeds in OIC, enabling real-time processing of worker lifecycle events (hire, update, termination).

Designed end-to-end Oracle PaaS solution integrating OIC, VBCS, PCS, ATP, and IDCS for workflow automation, secure data processing, and user interface enablement

Implemented workflow-driven integrations using Oracle Process Cloud Service (PCS)

Configured authentication and authorization using Oracle Identity Cloud Service (IDCS)

Designed and utilized Oracle Autonomous Transaction Processing (ATP) for integration data staging and processing

Designed and implemented approval workflows and human task flows using Oracle Process Cloud Service (PCS) integrated with OIC

Implemented OAuth 2.0 based authentication and token-based security using Oracle Identity Cloud Service (IDCS)

Worked on Oracle Fusion Expenses integrations including expense report processing, validations, and reimbursement workflows

Contributed to full lifecycle Oracle Fusion ERP implementations including design, configuration support, testing, data migration, and post go-live support for PPM modules.

Optimized data processing using Oracle ATP including SQL tuning, indexing strategies, and performance optimization

Subscribed to HCM business events via ATOM feeds and orchestrated downstream integrations with external systems using OIC.

Designed enterprise integration architecture using OIC orchestration patterns (scheduled, event-driven, and app-driven integrations) supporting financial and operational workflows.

Implemented integrations across Order-to-Cash (O2C), Procure-to-Pay (P2P), Record-to-Report (R2R), and Fixed Assets business processes.

Architected enterprise integrations across General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), HCM, and SCM modules

Built outbound XML integrations for AR invoices and credit memos to third-party billing systems including PDF generation and downstream bank transmission.

Implemented secure banking integrations including encrypted payment file generation (PGP), SFTP transmission, bank acknowledgement processing, and automated payment status updates in Fusion via REST APIs.

Developed Lockbox integrations for receipt creation, bank statement imports, payment application, credit memos, write-offs, and AR adjustments.

Integrated AP invoices with Fixed Assets (FA) for asset capitalization, mass additions (FBDI), CIP-to-Asset conversion, depreciation validation, and FA-to-GL reconciliation

Resolved journal posting failures, accounting derivation issues, and sub-ledger-to-GL reconciliation gaps using SQL-based financial analysis.

Designed and implemented OIC integrations for Oracle Project Portfolio Management (PPM) supporting Project Costing and Project Billing processes.

Built integrations to import project costs from external time and expense systems into Oracle Fusion Project Costing using FBDI templates through OIC.

Implemented integrations to extract project billing and revenue data from Fusion PPM and transmit invoice details to downstream financial and reporting systems.

Developed OIC integrations to process project expenditure items including project number, task number, expenditure type, and cost amounts for project cost import.

Triggered ESS jobs such as Import Costs and Generate Project Invoices using ERP Adapter within OIC to automate project financial processing.

Developed BI Publisher (BIP) and OTBI reports supporting finance reconciliation, asset reporting, and compliance dashboards

Collaborated with functional teams to support configuration and validation of Oracle Fusion PPM modules including Project Costing and Billing.

•Participated in requirement gathering sessions for project financial processes and integration design.

•Supported UAT, data reconciliation, and validation of project financial data during implementation cycles.

•Assisted in mapping project accounting processes from legacy systems to Oracle Fusion.

Involved in multiple full lifecycle Oracle Fusion ERP implementations including design, development, testing, and production support

Provided L2/L3 production support including performance tuning, root cause analysis, and month-end close stabilization.

Led functional validation and configuration support for Project Costing and Billing modules ensuring alignment with business requirements.

Played a key role in end-to-end PPM implementation including requirement analysis, configuration support, testing, and go-live.

Oracle Integration Cloud (OIC) Developer

Client: Barclays

Sep 2023 - Sep 2024

Location: USA

Designed and delivered 30+ OIC integrations across Oracle Fusion Financials and HCM in a banking environment.

Implemented integrations supporting O2C, P2P, and R2R processes including AR invoices, receipts, credit/debit memos, write-offs, and AP invoice processing.

Experience working with Oracle application integration patterns applicable to both Oracle Fusion and Oracle EBS environments

Designed real-time HCM integrations triggered by business events (hire, transfer, termination) using OIC and ATOM feeds

Exposure to Oracle Process Cloud Service (PCS) for designing workflow-based approvals and integrating with OIC orchestration flows.

Utilized Oracle Autonomous Transaction Processing (ATP) for backend data handling and integration staging.

Developed HDL, HCM Extract, and FBDI-based integrations supporting employee lifecycle and financial transactions.

Implemented secure payment file integrations including encryption and banking interfaces.

Supported Fixed Assets integrations including capitalization, depreciation validation, and FA-to-GL reconciliation.

Developed VBCS extensions integrated with OIC for operational and collections reporting.

Performed SQL-based reconciliation and resolved financial interface and journal posting failures.

Implemented OIC integrations supporting Oracle Fusion Project Portfolio Management (PPM) for project cost import, billing data extraction, and financial reconciliation.

Built integrations to load project expenditure transactions into Fusion Project Costing using FBDI and REST APIs.

Developed outbound integrations extracting project billing events and revenue details for downstream financial systems.

Supported SIT, UAT, production releases, and hyper-care stabilization

Senior Analyst – Oracle Cloud Integration Developer

Accenture Client: Manpower Group

Sep 2022 – Jun 2023

Developed and maintained inbound and outbound integrations using OIC, integrating Oracle Fusion with third-party systems using REST and SOAP (similar to PeopleSoft Integration Broker patterns)

Designed and implemented OIC integrations supporting Oracle HCM employee lifecycle events, including employee creation, updates, and data synchronization across enterprise systems.

Developed integrations supporting Order-to-Cash (O2C) processes including customer onboarding, AR invoice synchronization, credit/debit memos, and receipt processing.

Implemented high-volume FBDI integrations for bulk data processing including customer creation, financial data imports, and transactional data loads into Oracle Fusion.

Developed integrations to create customers in Oracle Fusion using FBDI templates, enabling large-scale onboarding of customer master data.

Implemented secure integrations for bank payment file transmission using PGP encryption, ensuring compliance with enterprise security and banking standards.

Designed integrations to upload PDF attachments to AP and AR invoices, enabling automated document management and invoice validation processes.

Monitored scheduled and real-time integration jobs, implemented error handling, logging, and alert mechanisms, and resolved issues to maintain system stability and data integrity.

Collaborated with functional teams and business stakeholders to gather requirements, document technical solutions, and deliver scalable integration architectures.

Supported System Integration Testing (SIT), User Acceptance Testing (UAT), and production deployments, ensuring smooth releases and stable integration performance across environments.

Infosys Limited (Client: UK Councils & Telecom)

Technology Analyst – Oracle Middleware / Integration Developer

Sep 2018 - Sep 2022

Designed and supported OIC-based integrations in multi-client enterprise environments across public sector and telecom domains.

Designed and implemented integrations supporting Oracle HCM employee lifecycle events, including employee creation, updates, and data synchronization across enterprise systems.

Built outbound integrations to transmit Accounts Receivable (AR) invoice due data and developed inbound interfaces for customer data updates using JSON, XML, and CSV formats.

Designed and developed integrations between cloud and on-premises applications using OIC and configured Connectivity Agents to enable secure hybrid integrations.

Designed and developed VBCS applications with integration to OIC for real-time data visualization and user interaction.

Built end-to-end Oracle PaaS solutions combining OIC, VBCS, and database services to support business workflows.

Implemented integrations supporting AP invoice creation, invoice printing, dunning letters, and encrypted payment file generation to streamline financial transaction processing.

Utilized Oracle Fusion REST APIs to perform operations such as updating customer bank account details, and processing write-offs, credit memos, debit memos, and receipt creation in Fusion Receivables.

Developed Visual Builder Cloud Service (VBCS) screens to display collections cases and real-time financial data, improving visibility and user interaction.

Supported integrations involving Oracle Fusion Project Portfolio Management (PPM) including project cost data processing and financial reporting integrations.

Built VBCS interfaces to trigger OIC integrations and display integration responses in tabular format, enabling immediate operational analysis.

Monitored scheduled and real-time integrations, implemented error handling, logging, and alert mechanisms, and resolved issues to ensure data integrity and system reliability.

Collaborated with functional teams, business analysts, and project managers to gather requirements, document technical designs, and deliver integration solutions.

Supported SIT, UAT, and production deployments, ensuring seamless releases and smooth integration performance across environments.

Stayed current with emerging features in Oracle Integration Cloud and VBCS, applying best practices to enhance solution design and integration efficiency.

CERTIFICATIONS

•Oracle Cloud Infrastructure 2025 Certified Application Integration Professional

•Oracle Cloud Infrastructure Application Integration Professional (1Z0-1042-23)

•Oracle Cloud Platform Application Integration Professional (1Z0-1042-22)

•Oracle Cloud Platform Application Integration Certified Specialist (1Z0-1042-21)

•Oracle Cloud Infrastructure AI Foundations Associate (1Z0-1122-23)

•Infosys Certified Oracle Integration Cloud Consultant

Contact this candidate