SUMMARY

• Over 10+ years of IT experience in System Analysis, Design, Development, implementation, Upgrade, Customization, production support and testing of Integration Cloud, VBCS, PCS and Oracle EBS.
• Certified as Oracle Cloud Platform Application Integration 2021 Specialist.
• Rich experience in designing and building Integrations (ICS), processes (PCS) and applications (VBCS) using Oracle Integration Cloud.
• Expert in designing end to end integration flows between various systems (Oracle and Non Oracle) and implementing them in Oracle Integration Cloud.
• Expertise in building Scheduled FBDI Automation integrations with Callback functionality in OIC.
• Designed Integrations to connect SaaS and On Premise applications using connectivity agents in OIC.
• Built Integrations using Business Event Subscription to achieve data sync between applications.
• Developed integrations to connect multiple Oracle Cloud applications such as Oracle ERP Cloud, HCM Cloud, and Sales Cloud etc.
• Designed and built integrations to connect cloud applications from different vendors such as Salesforce and Oracle ERP Cloud.
• Expert in lifecycle management of OIC Components, fault handling and encryption in OIC, migration of OIC Components using packages, lookups, versioning and cloning of integrations.
• Designed, Developed & Published - Mobile and Web App using Oracle Visual Builder Cloud Service (VBCS) along with ORDS, Rest API and Oracle SaaS APIs.
• Having knowledge on BI and OTBI Reports in ERP Cloud application.
• OIC integrations to setup inbound and outbound transactions flow using SOAP and REST APIs
• Good understanding of the functional flow in Oracle Application on Procure to Pay (P2P) and Order to Cash (O2C)
• Strong knowledge and understanding in interface table, base tables of Account Payables(AP), Account Receivables(AR), General Ledger(GL), Oracle Purchasing (PO), Order Management(OM),Oracle Inventory(Inv).
• Review the functional specifications and develop technical design documents for RICE (Reports, Interfaces, Conversions and Form Extensions) objects, Coding in SQL, PL/SQL, Migration of legacy data to oracle using SQL*Loader, UTL FILE, Open Interfaces and APIs
• Involved in AOL, Application Developer and System Administration activities including creation of KFFs, DFFs, users, responsibilities, menus, form functions, concurrent programs, request sets, request groups, value sets.
• Expertise in preparing AIM documents like MD50, MD70, CV60 and TE20
• Prepare & Review Test Plan, Test scope Documents and Test cases, Key resource in successful execution of - UT (Unit Testing), FIT (Functional Integration Test), SIT (Systems Integration Test) and UAT (User Acceptance Test)
• Driven multiple implementation projects from client locations(Dubai, Malaysia) as Onsite Technical Lead and have good experience in working with end-users/clients.
• Strong problem solving, issue resolution &technical skills coupled with confident decision make for enabling effective solutions lead to the high customer satisfaction
• In-depth experience in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

TECHNICAL SKILLS

Databases: Oracle

Programming Languages: SQL, PLSQL

Applications: Oracle Integration Cloud (OIC), VBCS, PCS, Oracle EBS R12.2

Tools: SQL*Plus, TOAD, SQL*Loader, Oracle Developer Suite (Forms, Reports), Oracle Workflow, Oracle XML Publisher, Oracle Application Framework, Oracle JDeveloper, BI, OTBI.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Senior OIC Developer

Responsibilities:

• Designed and built Integrations like Get Property, Create and Update Extended Checklist details in OIC.
• Designed and built Complex AR Self Service extension using VBCS, PCS and Integrations in OIC.
• Developed AR Self Service app user interface using VBCS and it had some complex pages to create/update/view/delete invoice requests etc.
• Complex multi-layer & conditional approval process is designed in PCS with email notification, escalation and expiration features. Invoice requests submitted via this VBCS app needs to go through this complex approval route.
• Once invoice request is approved, it needs to be sent over to ERP cloud and created as AR Invoice/Credit Memo and status of invoice also needs to be updated back on VBCS app as approved.

Environment: OIC (Oracle Integration Cloud), VBCS, PCS, CX, ERP Cloud, HCM Cloud and EBS Payroll

Confidential, Ohio

Oracle Application Developer, OIC Developer

Responsibilities:

• Designed and built FBDI automation integration in OIC to automate the load of GL Journals feed from EBS System to ERP Cloud daily.
• 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 for Item updates in OIC.
• Built Scheduled Integration to automate the data load into HCM Cloud using HCM Data Loader service.
• Designed and built an Integration in OIC to Create/Update customers in ERP cloud using fusion standard web services like LocationService, OrganizationService and CustomerAccountService.
• Built Integrations in OIC to connect Salesforce CRM System with Oracle ERP Cloud
• Designed and built FBDI automation integration in OIC to automate the load of GL Daily Exchange rates from EBS System to ERP Cloud daily.
• Designed and built Outbound flow(BIP Extract) for employees and assignments data of HCM Cloud.
• Designed and developed an AR Invoice Integration in OIC, which accepts xml payload, generates FBDI file from xml and triggers bulk import to create AR invoices in ERP cloud.
• Built an Integration to achieve the data sync between SaaS and On-Premises application using connectivity agents in OIC.

Environment: OIC (Oracle Integration Cloud), VBCS, PCS, ERP Cloud, HCM Cloud and EBS Payroll

Confidential, Houston, TX

Technical Lead

Responsibilities:

• Involved in business application analysis and Understanding.
• Involved to resolve in regular basis issues and daily activities of issues and client interaction.
• Providing results of bug analysis along with appropriate solutions.
• Providing supportive documents for issue closure and issue tracking.
• Review completeness of root cause and recommend resolution and workarounds.
• Providing estimation for new and major enhancements and involve in design and development activities.
• Responsible to ensure Problem Analysis and Impact Analysis.
• Worked on Issue fixes, enhancements and development in XML reports and Oracle Forms.
• Worked on Issue fixes and enhancements in Workflows, OAF.
• Worked on Form Personalizations, Oracle EDI for AP invoices, Barcode Reports, Business events and UNIX Shell Scripting.
• Worked on Issue fixes, Custom validations on Oracle MSCA application.
• Worked on Outbound interface for Items onhand quantity using UTL FILE.

Environment: Oracle EBS R12i SCM & Financial module - GL, AP, AR, OM, PO, INV Oracle 11g database, Toad 11.5.0, SQL*Plus, SQL, PL/SQL, Oracle Developer Suite (Forms, Reports), Oracle WorkflowOracle Application Framework.

Confidential, Detroit, MI

Technical Lead

Responsibilities:

• Involved in business application analysis and development.
• Developed reports using Oracle BIEE tool.
• Redeveloped 11i RDF reports into R12 BIEE, BI and XML reports.
• Converted 11i OAF forms, Oracle forms into R12 BIEE and XML reports.
• Upgraded 11i oracle forms into R12 Oracle forms.
• Upgraded 11i RDF reports into R12.
• Providing Technical support solutions to the customers in RLM, OM, HRMS, AP, AR, PO, GL and INV Modules.
• Extensively involved in writing PL/SQL stored procedures, functions and packages.
• Registration of concurrent programs and creation of value sets to AOL.
• Involved in preparation of technical documents like MD070 and TE020.

Environment: Oracle EBS R12i& 11i SCM & Financial module - GL, AP, AR, OM, PO, INV Oracle 11g databaseToad 11.5.0, SQL*Plus, SQL, PL/SQL, Oracle Developer Suite (Forms, Reports), Oracle Workflow.

Confidential

Technical Lead

Responsibilities:

• Involved in bug fixing of various technical components that were created during the implementation of Oracle Applications.
• Responsible to ensure Problem and Impact Analysis on Projects proper technical plans in place for all production changes.
• Coordinating with the Application Support team for preparing the feasibility report. Submitting it to the IT Manager with specific recommendations/ action plans to be taken.
• Mapping clients’ requirements and providing them best solutions involving evaluation and definition of scope of project and finalization of project requirements.
• Responsible for meeting the agreed SLA for support call and Client Management.
• Responsible to ensure completeness of Problem Determination and Resolution.
• Supported the Month end closer activities and worked with the different stakeholders in case of issues.
• Actively discussed requirements with client and estimated efforts accordingly.
• Involved in developing critical enhancements and major bug fixes.
• Worked on bug fixes and enhancements in Interfaces and Oracle PL/SQL Concurrent Programs.
• Worked on Issue fixes, enhancements and development in XML reports and Oracle Form.
• Worked on Issue fixes and enhancements in Workflow, business events.
• Worked on Form Personalizations and UNIX Shell Scripting.
• Worked on Issue fixes on Oracle MSCA application.
• Worked on Oracle Applications Framework(OAF) Customization.

Environment: Oracle EBS R12i SCM & Financial module - GL, AP, AR, OM, PO, INV Oracle 11g database, Toad 11.5.0, SQL*Plus, SQL, PL/SQL, Oracle Developer Suite (Forms, Reports), Oracle WorkflowOracle Application Framework.

Confidential

Senior Technical Consultant

Responsibilities:

• Involved as off-shore technical team in design, development and implementation
• Involved in unit testing and performance testing for reports
• Developed XML Reports, PL/SQL reports, Interfaces, Form Customizations as per the Client requirement
• In Inventory, PO, AP,AR,OPM, HRMS and SCM modules
• Developed Customizations for Inventory and Purchasing Modules
• Extensively involved in writing PL/SQL stored procedures, functions and packages.
• Developing sql*loader scripts to load data from flat file’s to temporary tables .
• Developing custom programs to load data from temporary tables to interface tables using open interface
• Analyzing the Interfaces performances and providing the Short-term Fix as well as Long-term Fix if there is any issue
• Registration of concurrent programs and creation of value sets, DFF’s to AOL
• Involved in preparation of various documents like MD070,CV060 and TE020
• Providing Data fix/Mass Data fix for Data Corruption issues/for which client may not know how to reproduce/user errors/customer specific issues
• Involved in offshore maintenance and support of Oracle Apps

Environment: Oracle EBS R12i SCM & Financial module - GL, AP, AR, OM, PO, INV Oracle 11g database, Toad 11.5.0, SQL*Plus, SQL, PL/SQL, Oracle Developer Suite (Forms, Reports), OracleWorkflow.

Confidential

Senior Technical Consultant

Responsibilities:

• Understanding the business Process
• Providing Technical support solutions to the customers in AP, AR, PO, GL and INV Modules.
• Developing the SQL Scripts to extract the Data from 11i Instance to temporary tables
• Extensively involved in writing PL/SQL stored procedures, functions and packages.
• Developed SQL Scripts for Suppliers, Customers, Purchase Orders, AP Invoices, Item Master, GL Trial Balance, AR Invoices Data Extraction.
• Registration of concurrent programs and creation of value sets to AOL
• Analyzing the Interfaces performances and providing the Short-term Fix as well as Long-term Fix if there is any issue
• Involved in preparation of technical documents like MD070,MD0120 and TE020

Environment: Oracle EBS R12i SCM & Financial module - GL, AP, AR, OM, PO, INV Oracle 11g database, Toad 11.5.0, SQL*Plus, SQL, PL/SQL, Oracle Developer Suite (Forms, Reports).

Confidential

Technical Consultant

Responsibilities:

• Understanding the business Process
• Providing Technical support solutions to the customers in Inventory, HRMS and OPM Modules.
• Involved as off-shore technical team in design, development and implementation
• Involved in unit testing and performance testing for reports
• Developed XML Reports, Forms as per the Client requirement
• Developed Customizations for HRMS and OPM Modules
• Extensively involved in writing PL/SQL stored procedures, functions and packages.
• Registration of concurrent programs and creation of value sets to AOL
• Involved in preparation of various documents like MD070,CV060 and TE020
• Developed Sales Summary Report using Discoverer
• Developed Daily Shipment Report, Invoice payment detail Reports
• Developed Sales order Acknowledgement Report, Inventory Item Detail Report.
• Developed GL Inbound Interface to import the Journals data from Legacy to Oracle applications GL base tables using the standard program ‘Journal Import’
• Developed PO Interface Program to synchronize the data between existing Legacy system and Oracle Database.
• Developed outbound interface to load Item Transaction Details into flat file using UTL FILE

Environment: Oracle EBS R12i SCM & Financial module - GL, AP, AR, OM, PO, INV Oracle 11g database, Toad 11.5.0, SQL*Plus, SQL, PL/SQL, Oracle Developer Suite (Forms, Reports).