Praneeth

Oracle Integration Cloud (OIC)

PH: +1-469-***-****

Email: ad22ci@r.postjobfree.com

Professional Summary

8+ Years of strong knowledge and work experience in APPS Implementation and Supporting.

Experience in Oracle integration Cloud using FTP, SOAP, REST, FBDI, BIO report, SaaS, PaaS including experience with working on-premises integration and 3rd party applications to oracle cloud.

Hands on experience in using Oracle integration cloud – OIC Instance Setup, FTP, SOAP, REST, BIP Report, PaaS Application.

Extensive experience in data conversion from legacy to oracle cloud – includes identifying business rules / requirements, data extractions, cleansing, pre- validation and loading into oracle cloud application.

Extensive experience in developing Interfaces, Conversions, OAF (JDeveloper), Forms, Reports, Web ADI, Workflows and XML Publisher.

Strong experience in AP, AR, GL, PA, PO, CHRM, OPM& AOL Modules.

Good knowledge in Procure to Pay (P2P), Order to Cash (O2C) Cycles.

Experience in Oracle E-Business Suite R12, Oracle 10g Database, Oracle 10g Forms, Oracle 10g Reports, XML Reports and Oracle Tools.

Excellent perspective on converting the functional specifications into technical design and development using SQL, PL/SQL and Developer 10g (Forms, Reports), BI Publisher

Hands on experience in Form Personalization and Alerts.

Hands on experience in OAF Personalization and extensions.

Exposure in devising a project plan for small scale implementation

Post Production support, bug fixing and enhancement experience

Good knowledge of various technical aspects of Oracle Applications including OM, Pricing, PO, INV, HRMS, PA, OPM, BOM, WIP, System administrator and Application Object Library (AOL)

Experience in System analysis, design, development, documentation, testing, implementation, technical support and maintenance of information systems.

Planning and execution of system Integration (SIT), and User Acceptance Testing (UAT) through the development of test scripts

Technical Skills

ERP Application

e-Biz (R12.1.3, 12.2.5 and 12.2.9)

ERP Modules

OM, AP, AR, GL, PA, PO and CHRM

ERP Business Flow

SCM - Order to Cash (O2C), Procure to pay (P2P)

Languages

SQL, PL/SQL and Java

Database

Oracle 9i/10g/11g/12c

Operating System

Windows NT, UNIX and Linux

Version Control tools

SVN

Tools/Utilities

JDeveloper 10g/11g, TOAD 10.5/9.0, SQL*Loader, Workflow Builder,

Developer 2000/6i/10g, SQL*PLUS, Core FTP, Putty, SQL Developer, Reports 10g, Forms 10g, Forms Personalization, Custom.pll, BI Publisher and XML Publisher

Fusion Apps

BIP, OTBI, FBDI, HCM Extract, Extract using BI Publisher, FBDI manual approach by using UCM and Automation of FBDI by using OIC

Professional Experience:

Fifth Third Bank, Cincinnati, Ohio Sep 2021 to Present

Senior Oracle Cloud Technical Consultant

Responsibilities:

Extensive experience in integration with various systems like Oracle financial modules, Salesforce, Oracle E-Business Suite and other third parties using OIC.

Worked on integrating transactional data from source to destination systems by using OIC

Design and develop integrations in OIC to Oracle ERP Cloud including making REST and SOAP calls, FBDI File Uploads

Worked on Outbound integrations from Oracle cloud to other applications using OIC

Developed Generic Logging Integration in OIC

Worked on creating Rest based services, SOAP based services. Have used several adapters like DB adapter, File Adapter, Rest, SOAP

Worked on call back services

Worked on error handling framework on global level as well scope level

Developed BIP Reports in fusion based on Business Requirements

Prepared technical design documents based on functional design documents

Worked in provisioning an oracle integration Cloud instance.

Worked on various integrations and Involved in SIT, UAT.

Supported integrations and PROD environment releases.

Environment: Fusion Applications (GL and HCM), OIC, BIP, OTBI.

PNC Bank, Pittsburgh, Pennsylvania Jan 2020 to Aug 2021

Senior Oracle Cloud Technical, PASS Developer

Responsibilities:

Worked on integrating data from HCM to On-premises system.

Creating demo scenarios for client and preparing the design documents based on the client requirement

Developed Customer, Items and daily rates integration by using OIC

Worked Customer and items conversion activity to cloud application by using OIC

Worked on error handling framework in OIC

Outbound from Cloud to on Premise application using OIC Agents configuration

Worked on design, develop, testing and deployment of Customer conversion using FBDI process from oracle R12 to cloud. Involved in analysis of data, mapping, and documenting.

Worked on transferring files from One FTP Server to another by using Oracle Integration (OIC)

Developed BIP, OTBI Report in Fusion based on Business Requirements

Participated in go-live, migration and post – production deployment support

<These responsibilities are for EBS r12>

Worked on the development of interfaces, Data Conversions, developing new WebADI, Reports In order to Cash cycles touching various modules such as AP, AR, GL and CHRM.

Implemented AP Invoice Import through Payables Open Interface Import Program.

Implemented Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them into base tables using TCA APIs

Developed Inbound Interface Between ITC and OM.

Loaded the vendor’s information from legacy system by using API's

Developed AR Invoice, AR Receipt, and Pricelist Conversion Programs to load data from legacy system.

Customized AR Receipt CE Bank Reconciliation Program

Actively participate in technical design meetings and decide on best practice and approach. Work with the functional team to list out technical tasks and estimate efforts.

Developed OAF Pages and OAF Personalization’s

Developed Pricing Modifier WebADI

Developed Pricelist WebADI

Worked on Workflow Customizations

Developed XML Reports

Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.

Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes

Involved in Conversion activities during SIT,UAT and PROD

Job Monitoring and production bug fix (day to day Activity) during Hypercare Support.

Environment: Oracle Applications R12.2.5, (OM, AP, AR, GL, CE, CHRM and Pricing), Oracle 11g, Workflow, Reports 10g, SQL, PL/SQL, XML, WebADI, OAF, Fusion Applications (AP, AR, GL and HCM), OIC, BIP, OTBI

GMF, Arlington, Texas Aug 2018 to Dec 2019

Technical Consultant

Responsibilities:

Troubleshooting issues raised by Client as part of Support

Preparing the Data fixes based on issues.

Defect the fixing and Implementing change requests

Job Monitoring and production bug fix (day to day Activity) for various modules like AP, AR, GL, OM etc.

Customization on AGIS process

Developed FAC Approval OAF Pages

Developed Payment Verification interface

Used Version Control (tortoise subversion) to maintain code changes.

Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.

Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes

Worked on Enhancements as per Business requirements

Created Custom Views to fetch the data for third party systems.

Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.

Developed XML Reports

Environment: Oracle Applications R12.2.3, (AP, AR, GL), Oracle 11g, Forms 10g, Reports 10g, SQL, PL/SQL, XML, LINUX

oriental trading company, India Aug 2016 to Dec 2017

Technical Consultant

Responsibilities:

Developed OAF Pages for creating invoices and Receipts.

Customer Invoice/ Credit memo Creation from Transfer Of units screen using AR Invoice API.

Supplier creation from Siebel

Developed XML Reports

Worked on bank Reconciliation Process.

Developer GL Interface for balancing the accrual account.

OAF Control extension on customer page.

Worked on Alerts and Form Personalization.

Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances

Developed new forms using Oracle Forms Builder.

Developed BOQ File upload page using OAF.

Developed XML Reports

WIP Job creation for Aluminum Assemblies using Interface.

Payable Invoice Creation from Subcontract Payment Certification for Supplier.

Customer Invoice/ Credit memo Creation from Project Billing screen using AR Invoice API.

Developed approvals in custom forms using workflow builder.

Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances

Environment: Oracle Applications R12.1.3, (AP, AR, GL, CE), Oracle 11g, Forms 10g, Reports 10g, XML, SQL, PL/SQL, LINUX

A3 IT Solutions Ltd, India Sep 2013 to Jul 2016

Technical Consultant

Responsibilities:

Involved in integration of the data from Third Party Tool (HHT) with ERP which includes Inbound Interfaces tightly integrated to GL and AR Modules which involves AR Invoice, Receipt, Receipt Application and Invoice Adjustment API creation.

HHT Integration with EBS in creation of Customer details.

Coordinating with Team in Loading Customers, Suppliers and AR/AP Opening Balances.

Created File Loading (CSV Files) into server using OAF Page.

Worked on OAF Personalization and extensions.

Moved concurrent Programs from one instance to another using FNDLOAD

Post LIVE Support.

Developed Reports (XML) in Finance and Project modules.

Worked on Alerts, Form Personalization, and Interfaces.

Used SQL *Loader program to load data from excel to custom oracle tables and then to Standard tables through Interface scripts.

Created Approval Hierarchy and Action History OAF Pages.

Developed OAF search and Transaction Pages in Transportation Custom Module.

Worked on OAF extensions like changing LOV in Work Order and displaying GL Accounting Description in PO Buyer Work center.

Registration of Concurrent Programs and defined Value sets

Moved concurrent Programs from one instance to another using FNDLOAD.

Environment: Oracle Applications R12.1.1, (AP, AR, PO, WIP and ICX), Oracle 11g, Forms 10g, Reports 10g, SQL, PL/QL, OAF, XML

Certification

Oracle Cloud Platform Application Integrations

Education:

Bachelors in Computer Science Engineering from JNTU, India

Masters in Computer Science from UTA.

Contact this candidate