SUMMARY

• 16+ Years of total IT experience in Oracle EBS (R12) and 11i applications.
• 5 Years of experience with Oracle Fusion (SAAS/PAAS) Applications and Oracle Integration Cloud (ICS/OIC/VBCS).
• Working on Oracle Integration cloud (ICS/OIC) with SOAP services, REST API’s and Agents.
• Worked on Adapters like REST/SOAP/File/FTP/Database/Oracle ERP Cloud/EBS/SalesForce in OIC.
• Integrated REST API’s with Python scripting on AWS environment with lambda functions
• Oracle Fusion (Cloud) Financials as Techno Functional consultant involving in implementations and support as Financial/SCM/Procurement/PPM cloud consultant in the BI reports/OTBI reports/OTBI Analysis/ FBDI/ADF DI.
• Worked on Data Migration (AP Invoices/Suppliers/Customers/Banks & Branches/Purchase Orders/GL Journals/Fixed Assets data) through FBDI/ ADF DI Templates.
• Experienced Procurement Cloud offering (Purchasing, Supplier Portal, Self Service Procurement)
• Involved troubleshoot procurement functional issues in Production and provide quick resolution
• Guide the users for any navigational and training issues in Oracle Procurement Cloud
• Excellent Knowledge on defining ESS jobs for custom BI Publisher Reports in various modules.
• Having well exposure on code migration from one instance to another instance by using ARCHIVE and UNARCHIVE the files in Oracle Fusion.
• Experience in SmartView and FRS (financial reporting studio) Reports.
• Knowledge on WebCenter for Image Processing through OCR/ODR
• Worked (EBS) on BPEL process activities, Decision Service, Partner Links and Adapters (File/FTP/Database/AQ/JMS Adapters) for developing custom business processes to integrating with different systems.
• Good experience on Fusion Middle products APM, IDM, BPM.
• Defining Chart of Accounts, Ledgers, Data Access Sets, Business unit.
• Created users and assign appropriate roles to user and Custom roles creation in fusion.
• Define Value sets and creation of data models.
• Responsible for day to day issues related to accounting, schedule process, Transactions.
• 10+ Years of experience in EBS(R12),11i applications and Oracle SQL/PLSql.
• With specific exposure to Implementation, R12 Upgrade, enhancement, testing and support projects in Oracle Application(11i/R12).
• Expertise in preparing a Technical Design documents and Unit Test Plan documents for RICE and WebADI’s.
• Expertise in BI Publisher (XML Reports) with Barcoding and registered FONT in the application.
• Developed BI reports for Oracle Projects with XML Data definition file and template in the .xls file.
• Expertise in development of interfaces (Inbound and Outbound), Conversions, Reports Development and Customization and Alerts and I have good knowledge of Oracle SQL/PL - SQL.
• Expertise in generating outbound files in XML standard format with UTL Utilities.
• Expertise in creating Event Alert and Periodic Alert to send mails, submit programs and etc.
• Good knowledge of AOL (System Administrator, Application Developer) components and creating AOL components like value sets, lookups, concurrent programs and etc.
• Experience with Oracle Utilities: TOAD, SQL-Developer, SQL*Plus & SQL*Loader and other tracking tools like BMC Remedy, BMC, PPM, SNOW, WINSCR3, MAXIMO, RAT, RPM, PVCS and Service Now.
• Created PO’s, Invoices, Payments and posted to GL (P2P Cycle) for testing the new reports and outbound interface data and Good knowledge on Order to Cash(O2C) Cycle.
• Download/Upload ldt files using fndload for Reports, Alerts, Interfaces programs & AOL components.
• Technical expertise in RICE objects for Financials & Procurement modules using Oracle’s AIM/OUM methodology.

TECHNICAL SKILLS

ERP: Fusion (Oracle Cloud SAAS/PAAS) & ICS/OIC/VBCS, R12(EBS)

Functional Modules: Fusion (AP, AR, GL) and Procurement, GL, AP, AR, Pricing, CM, OM

Database: Oracle 9i, Oracle 10g, 11g and 12C

Programming Languages: SQL, PL/SQL and Shell Scripting

Development Tools: Oracle Reports Builder 6i/9i and 10g, SOA 11g

Oracle Forms: Builder 6i/9i and 10g, OAF, Oracle Alerts, Toad, SQL*Plus, IBM Maximo, IBM Rational Portfolio Manager, Alfresco, PPM, BMC Remedy, Reflections X, Relfections FTP, XML Publisher Reports, ALM, Service Now and Web ADI Python script, Lambda functions, AWS environment.

Operating System: Windows XP and UNIX

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle Cloud Technical & Integration Consultant & BIP Developer

Environment: Oracle Fusion Financials, SCM, PPM Cloud, OIC Integration (SaaS), BI Reports, OTBI Reports and AdHoc reports.

Responsibilities:

• Primary focus will be on configuration, integration of Oracle with several applications and third parties, reporting, and user support.
• Provide production and ad-hoc reporting and interface solutions to complex query needs of the business using a variety of reporting tools.
• Worked on OTBI reports on Financials and Project modules.
• Enhancements for existing OTBI and BIP reports.
• Developed OIC outbound OIC Integration to Chrome River/Anaplan external system.
• Developed OIC Inbound Integration from Epay to Oracle Fusion Application.
• Actively engage with Architects and functional staff to ensure ideal design of systems.
• SFTP setup done for OIC outbound/Integrations.
• AP ACH file customization for PNC bank and payment file setup done for the same PNC ACH file processing
• Work with third party systems and vendors that require integration with Oracle ERP Cloud.
• Developed Supplier and Supplier Bank outbound integration from OCF to external systems.
• Developed GL Balances report
• Developed Project Cost and Revenue report.

Confidential, North Canton, OH

Oracle Cloud Technical & Integration Consultant & BIP Developer

Environment: Oracle Fusion Financials, Procurement, SCM, PPM modules, OIC Integration (SaaS/PaaS), BI Reports, OTBI Reports and AdHoc reports.

Responsibilities:

• Primary focus will be on configuration, integration of Oracle with several applications and third parties, reporting, and user support.
• Work with third party systems and vendors that require integration with Oracle ERP Cloud.
• Provide production and ad-hoc reporting and interface solutions to complex query needs of the business using a variety of reporting tools.
• Determine when and how to use the different tools for integrations, reporting, and data conversions.
• Resolve technical problems of supported applications. Engage Oracle Support and other technical resources to research and resolve issues.
• Worked on OTBI reports on Financials and Procurement modules.
• Enhancements for existing OTBI and BIP reports.
• Developed OIC outbound OIC Integration to external system.
• Developed OIC Inbound OIC Integration to Oracle Fusion Application.
• Actively engage with Architects and functional staff to ensure ideal design of systems.
• Created procedures, functions & packages to validate the data in PAAS environment to support OIC integrations.

Confidential, Dania Beach, FL

Oracle Cloud Technical & Integration Consultant & BIP Developer

Environment: s: Oracle Fusion, Procurement, SCM & HCM modules, BI Reports, OTBI Reports and AdHoc reports.

Responsibilities:

• Primary focus will be on configuration, integration of Oracle with several applications and third parties, reporting, and user support.
• Work with third party systems and vendors that require integration with Oracle ERP Cloud.
• Provide production and ad-hoc reporting and interface solutions to complex query needs of the business using a variety of reporting tools.
• Determine when and how to use the different tools for integrations, reporting, and data conversions.
• Resolve technical problems of supported applications. Engage Oracle Support and other technical resources to research and resolve issues.
• Worked on OTBI reports on Financials and Procurement modules.
• Enhancements for existing OTBI and BIP reports.
• Developed purchase orders OIC outbound Integration to HighJum external system.
• Created Inventory Transfer Orders OIC inbound service which is receiving data from Mercury external system.
• Actively engage with Architects and functional staff to ensure ideal design of systems.
• Python scripting to integrate Sale Shipments through REST API on AWS with Lambda functions into Oracle Cloud.
• Python scripting to integrate Transfer Orders through REST API on AWS with Lambda functions into Oracle Cloud.
• Export Invoice and AR Transaction Business Data in Visual Builder Cloud Service (VBCS).
• Created custom On-hand Quantity web application with REST service in Visual Builder Cloud Service (VBCS).

Confidential, Durant, OK

Oracle Cloud Technical & Integration Consultant & BIP Developer

Environment: s: Oracle Fusion, Procurement, HCM modules, BI Reports, OTBI Reports and AdHoc reports.

Responsibilities:

• Worked on AP Payment check print customization
• Worked on AP ACH file customization
• Customized PO document/BPA/CPA reports
• FBDI: Suppliers/Journal Imports/Import Supplier Bank Accounts/FA Mass Additions Loaded
• Created AdHoc report to show the Suppliers/Journal Import interface errors & Created AdHoc report.
• Created ICS service through REST API to load purchase orders from JD Edwards to Oracle Cloud.
• Loaded Requisitions REST through REST API from JD Edwards to Oracle in Dev instance
• Imported historic data for Journalthrough ICS with REST API services.

Confidential, Eden Prairie, MN

Oracle Cloud Technical & Integration Consultant & BIP Developer

Environment: s: Oracle Fusion, Procurement & SCM modules, BI Reports, OTBI Reports & ICS/OIC.

Responsibilities:

• Created Integration service to create AP Invoice Installments through REST API
• Created ICS service through REST API to load AR Transactions from Navisphere to Oracle in Dev instance
• Loaded Payable Invoices through REST API from Navisphere to Oracle in Dev instance
• Imported historic data for Payable Invoices through ICS with SOAP services.
• Imported historic data for Journals through ICS with csv file.
• Created Integration service to load Receivables Invoice through SOAP Services.
• Created Integration service to Create/Update supplier with SOAP Adaptor.
• Update Installments using Payables Invoice Management SOAP service.
• Created Oracle Integration service to submit custom ESS Job.
• Placed report output files in the UCM through Oracle Integration service.
• Integration issues resolved and updated JSON code and Added parameters in the XXSUBMIT ORACLE ESS JOB integration.
• Base64 issue resolved while uploading sample files to UCM
• Worked on Data Migration (AP Invoices/Suppliers/Customers/AR Transactions data) through FBDI Templates.
• Developed and customized the BI reports, OTBI reports and OTBI analysis as per business requirement.
• Developed the AP Invoice aging report with as of date.
• Lock Down Fields After Record Creation with Groovy Scripts
• Querying Custom Object Records Using RESTful Web Service Calls In Groovy Scripts
• Created users and assign appropriate roles to user and Custom roles creation in fusion.
• Define Value sets and creation of data models.
• Requirement gathering of this project and act as a technical and functional resource.

Confidential, Cleveland, OHIO

Oracle Fusion Techno-Functional Consultant & BIP Developer

Environment: s: Oracle Cloud Finance, Procurement, SCM & HCM modules, BI Reports and OTBI Reports.

Responsibilities:

• Worked on Data Migration (AP Invoices/Suppliers/Customers/Banks & Branches/Purchase Orders/GL Journals/Fixed Assets data) through FBDI Templates.
• Imported historic data for Payable Invoices and Journals.
• Requirement gathering of this project and act as a technical and functional resource.
• Developed and customized the BI reports, OTBI reports and OTBI analysis as per business requirement.
• Developed “XXSW AP Payments Extract” and busted the output to the respective emails
• Developed “XXSW AR Cash Applied Extract” and busted the output to the respective emails
• Created “XXSW GL Flexi Trial Balance” ESS job for the Trial Balance BIP report in Dev instance
• Developed sales order details report and created ESS job as per requirement.
• Customize the Receivable Transaction report
• Developed the Purchase Order Document Template.
• Developed the Supplier list reports.
• Developed the AP Invoice aging report with as of date.
• Developed the Unpaid check report.
• Created users and assign appropriate roles to user and Custom roles creation in fusion.
• Define Value sets and creation of data models.
• Responsible for day to day issues related to accounting, schedule process, Transactions.

Confidential

Oracle Fusion Techno-Functional Consultant & BIP Developer

Environment: s: Oracle Fusion Finance, Procurement, SCM & HCM modules, BI Reports and OTBI Reports.

Responsibilities:

• Involved setups in the Oracle Financials Cloud modules and prepared documents for the further support.
• Developed data extracts in BI Publisher and setup FTP Connections with third party systems.
• On call Support end to end business within Oracle Financials Cloud.
• Followed Oracle Unified Methodology for all the documents in the implementation.
• Customized AP Check format to cater business requirement.
• Customized ACH File format to cater business needs.
• Worked on FBDI template Load for Suppliers and invoice data.
• Worked on ADF DI Spreadsheet loads for Journal, invoices, Daily rates.
• Custom DFF and Value Sets Creation.
• Worked on IDM and APM modules for creation of roles, user maintenance.
• Raising SR to Oracle to get support on specific issues.
• Configuring test and production environments using FSM.
• Production support on Fusion Financial Applications.
• Developed a custom form in SAAS environment using application composer with Groovy Script.
• Making Fields Conditionally Required/ Updatable with Groovy Script
• Using Println Function and adding Validations to Fields with Groovy Script
• PM Customer Statement Report
• Print Receivables Transactions MD070 v1.0
• Perform - Further AR Invoice Changes & Bug fixes
• FBDL-Payable Invoice Import
• FBDL-Fixed Asset Mass Additions Import
• Silterra PO Receipt History
• Req PO report from 11i to Fusion
• Provide support for issues encountered by end users such as period close issues and provided clarifications of user queries.

Confidential

Oracle EBS Technical Lead & BIP Developer

Environment: s: EBS (R12.2.5), Procurement, AP, AR, CM, GL, INV, OM, Service Contract, Pricing, SOA 11g, PL/SQL and Reports XML publisher.

Responsibilities:

• Expertise with the following RICEW objects.
• Prepared R12 GAP analysis doc for the RICE objects in the R12 upgradation projects.
• Discussion with the Client to understand their technical needs.
• Design and development of Outbound and Inbound interfaces using SOA 11g and PLSQL.
• Design and development of Order Details, Order Line Details and Order Ship Confirm web services using SOA apps adapter.
• Integrated PAUP application with SOA services which fetches Order information and Saves data back to custom tables on ship confirm.
• Created PLSQL APIs to support webservice calls
• Design and development of Order Details and Order Process web services using SOA apps adapter.
• Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues.
• Validated the code as per the naming standards which is developed by the other team members.
• Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend.
• Developing New Conversions and Interfaces for upgradation of R12.
• Development of New Reports and Customization of Existing Reports and Peer code reviews.
• Developed in the Sales Order Lines WEB ADI.
• Creating Event Alert and Periodic Alert to send mails, submit programs and etc.
• Creation of Technical Specifications, Unit Test Plan Documents.
• Created various PL/SQL procedures/packages according to the Client requirements.
• Worked for enhancements and support cases/incidents for the RICE Objects.
• Preparing data fix scripts for data manipulation and delete the Orfhan records.
• Helping to the BI team to make them understand the apps data modeling and functionality.
• KT and training on BMC Remedy, PPM Migration tools and application to the new joiners.

Confidential

Oracle EBS Technical Lead & BIP Developer

Environment: s: Oracle Applications R12, PO, AP, AR, GL, Service Contract, Pricing, INV, OM and PL/SQL, BIP Reports.

Responsibilities:

• Expertise with the following RICEW objects.
• Review / Analysis / Creation of Technical Specifications, Unit Test Plan Documents.
• Discussion with the Client to understand their technical needs.
• Developing New Conversions & Interfaces.
• Developing Conversions and Interfaces for up gradation of R12.
• Development of New Reports and Customization of Existing Reports.
• Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend.
• Creating Event Alert and Periodic Alert to send mails, submit programs & etc.
• Created various PL/SQL procedures/packages according to the Client requirements.
• Managing and delivering the Change Requests (CR) and Incident Records (IR) within the time of SLA.
• Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues.
• Trained on BPEL process activities, Decision Service, Partner Links and Adapters (File Adapter, FTP Adapter, Database Adapter, AQ Adapter, JMS Adapter) for developing custom business processes to integrating with different systems using OSB
• Designed and developed a Payable Invoice Interfaces to the BPEL Process Manager utilizing the Oracle SOA.

Confidential

Oracle Apps Technical Consultant

Environment: s: Oracle Applications 11.5.10, R12, PO, AP, AR, GL, INV, OM and PL/SQL, XML Reports.

Responsibilities:

• Review / Analysis / Creation of Functional Specifications, Technical Specifications, Unit Test Plan Documents
• Discussion with the Client to understand their technical needs.
• Developing conversions for up gradation of R12.
• Developing, supporting, and enhancing Inbound/Outbound interfaces, RDF reports, PL/SQL components of almost all modules implemented in the project.