VENKATA PRASAD SAKHAMURI

S.V. Degree College, Atmakur

B.Sc (Computers) · Computers

N/A – June 30, 2023

Altimetrik

OIC Developer

June 1, 2023 – May 1, 2026

India

Oracle Fusion ERP Finance & SCM Integration Implementation

June 1, 2025 – May 1, 2026

The client is a leading global enterprise using Oracle Fusion ERP Cloud to manage its Finance and Supply Chain Management (SCM) operations. The project focused on implementing and supporting end-to-end integrations for Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Procurement, Purchase Orders, Supplier Management, Inventory, Bank Statement Processing, and Customer Data Management using Oracle Integration Cloud (OIC). Roles & Responsibilities: Developed end-to-end inbound and outbound integrations using Oracle Integration Cloud (OIC) for Finance and SCM modules. Built App-Driven, Scheduled, and File-Based integrations using REST, SOAP, FTP, Database, and ERP Cloud adapters. Prepared and processed FBDI files for AP Invoice Import, AR Transactions, GL Journal Import, Supplier Import, Purchase Order Import, and Inventory integrations. Performed UCM upload and submitted ESS Jobs for successful data import into Oracle Fusion ERP Cloud. Developed and consumed REST/SOAP services based on business requirements and integration needs. Created BI Publisher (BIP) reports for outbound integrations and business reporting requirements. Designed complex data mappings, XSLT transformations, lookups, enrich activities, and fault handling mechanisms. Scheduled integrations using iCal expressions and monitored execution using OIC monitoring dashboard. Migrated integrations across DEV, TEST, and PROD environments using OIC import/export functionality. Supported Procure to Pay (P2P) and Order to Cash (O2C) business process integrations across Finance and SCM modules. Performed unit testing, SIT, UAT support, and production issue resolution for critical business integrations. Prepared Technical Design Documents (TDD), integration specifications, and deployment support documentation. Worked closely with functional consultants and business users to understand requirements and deliver scalable integration solutions.

Oracle Fusion ERP Financial Integrations Project

June 1, 2023 – May 1, 2025

Altimetrik is a global digital engineering and technology solutions company providing services in digital transformation, cloud, data engineering, and enterprise application integration. The project focused on implementing and integrating Oracle Fusion ERP Cloud Finance and SCM modules by migrating AP, AR, GL, Supplier, Purchase Order, Inventory, and Bank Statement data from legacy systems into Oracle Fusion using Oracle Integration Cloud (OIC), REST/SOAP services, FBDI, UCM, and ESS Jobs to automate P2P and O2C business processes. Roles & Responsibilities: Configured and managed secure connectivity between Oracle Cloud and on-premise legacy systems using OIC Connectivity Agent for seamless integration. Designed and developed complex BI Publisher (BIP) reports using Excel and RTF templates, enabling dynamic, data-driven reporting with advanced multi-parameter filtering. Engineered automated OIC workflows to programmatically invoke and retrieve BI Publisher reports to meet real-time business reporting requirements. Implemented a robust, centralized error-handling framework using scopes and global fault handlers to ensure comprehensive tracking and monitoring of failed transactions. Orchestrated large-scale data migrations from Oracle EBS to Oracle Fusion Cloud using REST, SOAP, FBDI, and OIC integrations, ensuring data integrity and seamless transition. • Developed and optimized critical financial integrations for AR Receipts, AP Invoices, and AP Payments, successfully processing high volumes of transactional data. Leveraged a diverse range of OIC adapters, including REST, SOAP, FTP, Database, and Oracle ERP Cloud, to build scalable and maintainable integration solutions. Streamlined end-to-end business processes across SCM and Financial modules by enhancing both pre-built and custom cloud integrations. Executed data loading strategies using FBDI processes, managing the end-to-end lifecycle from file generation to interface table validation. Expertly utilized technical components such as XSLT transformations, XSD, and WSDL to manage complex data mapping between disparate systems. Created multiple BI reports to get AR Receipts and Transaction data from fusion Called the BI reports from OIC integration using SOAP WSDL.