SUMMARY:

• 14 years of expertise experience across implementation on Oracle Apps and Fusion Apps Support and Oracle Cloud Integrations.
• Worked for AP, AR, and GL Modules.
• Having good exposure for Fusion payment integration with SFTP/HTTPS/IPP protocols.
• Having vary good exposure on integrating different fusion cloud applications using Rest API’s and SOAP webservices.
• Having exposure across XML Publisher (RTF and e - text Template Development).
• Having exposure SLA Customization, PPP setup.
• Equipped with knowledge on performance tuning.
• Having Knowledge of SOA, BPM, ADF components
• Having Knowledge of SOA, BPM.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
• Good Technical Knowledge on Cycles like Order Management (Order to Cash), Purchasing (Procure to pay), TCA(Trading Community Architecture)
• Development experience in various modules like Oracle Payables, Oracle Receivables, Order Management, Oracle Purchasing, Oracle General Ledger, Oracle Inventory.
• Very good Exposure of developing and customizing the shell scripts.
• Very good Understanding about multiple clouds, integrations, and third party Integrations.

TECHNICAL SKILLS:

ERP: Oracle Fusion Application cloud( Start from Version Rel10 to Till Release 13) and Oracle Apps 11.5.10 (PO, GL,AP,OM,INV,WIP),Oracle Apps 12.1.3 (WMS,OM,Payment,AR)

Front-end Tool: Forms 6i,Forms 10g,Oracle Workflow

Languages: SQL, PL/SQL, C, C++, Core Java

Reports: Reports 6i,Oracle Discoverer 4i, XML Publisher

Tool: Toad, Dream Coder, SQL Developer, Developers 11.1.1.5

Fusion Technology (11G): SOA,BPM,WEBCENTER,BPEL,ADF

Operating System: UNIX

Cloud: Oracle IaaS/PaaS/SaaS

Experience:

Confidential, Colorado Springs, CO

Product Customer support

Responsibilities:

• This is ongoing Oracle Product “Oracle Fusion Application” customer support for each problems related to product technical components
• Resolve post-sales customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for Electronic Support Services
• Serve as technical interface to customers, Original Equipment Manufacturers (OEMs) and Value Added Resellers (VARs) for resolution of problems.
• Procure-to-pay lifecycle with setting up and managing Payables/Cash Management/Accounts Receivables, managing Accounts Payable for Day to day Business problems and on time solution offerings.
• Product offers multiple integration offerings with bank’s Visa card integration, we support for all these issues with coordination of all parties.
• Expertise knowledge in Approval rules for Payables and Expenses.
• Working for imaging support for oracle preparatory product OFR/IPM.
• Having Very good exposure on Integrations between different ERP applications.
• Expertise knowledge in setting up Approval Workflow rules for Payables and Expenses as per business need. Expertise on Oracle Fusion payments Integration using SFTP/HTTPS/IPP protocols for bank files transmission and retrieval and check printing.
• Having exposure to troubleshoot Rest API and SOAP web service based integrated applications.
• Worked for OIC/EPM/ERP SaaS Integration across multiple products. Worked on CMK (Collaboration Messaging integration) with SaaS application and possessing good knowledge.
• Worked role customization and SSO integration for expense mobile app and debugging issues with customers.
• Having good exposure on Cash management (Bank statement upload/Auto reconciliation/Parsing Rules)
• Works on Auto lock box/Customer upload/Supplier/Bank Account etc. FBDI uploads. Having sound knowledge on SLA customization as per customer need and good understanding on Accounting and SLA data model and debugging issues on these areas.
• Having good exposure on Tax configuration setup and their issues on calculation.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Performing analysis, modification, and daily support of the Oracle E-Business Suite and other ADF and SOA applications.
• Analyzing impact of upgrade on User hooks MTL INTERCOMPANY INVOICES.GET TRANSFER PRICE.
• Redesigning and coding for payment-automated process for intercompany transactions from document selection/removal/rebuild payment request/format/Confirm payment request/create AR transmission/Validate/Post Quick Cash/Confirm payment/Create accounting.
• Worked for custom view remediation with new table.
• Automating process of Payment request submission with custom logic to generated user define name for Payment request.
• Development of report to generate AR Lockbox text file for intercompany process.
• Customized API ARP LOCKBOX HOOK.CURSOR FOR MATCHING RULE hook to match the receipt using matching number that is passed in the lockbox file.

Confidential

Oracle Apps Techno-Functional Consultant (Oracle Applications R11 - SCM)

Responsibilities:

• Demonstrates in communicating while developing processes and solutions leveraging tools within the Oracle E-Business Suite
• Provides design documents and translates into component-level designs to accelerate development.
• Participates in business process work sessions, project meetings and joint applications development sessions
• Architectural design to retrofit Atheros functionality in current QCT system for Sales Order Form.
• Workflow for Order line needs to retrofit for achieving auto scheduling for ISO in Atheros process and manual schedule process for QCT.
• Provide directions on resolving Service Requests in collaboration with Oracle Support
• Performance tuning for views of CEQ portal ( CORP and QCT).
• Modification on ADF application for CEQ portal as per new changes.
• Process design for OM model and Order entry of Atheros into QCT system. Worked for Order related Standard and Custom PLL's.
• Credit Memos created using Auto Invoice program should be put on hold on invoice, which need to manually release by user to complete credit memo.
• Extensively worked for standard and custom PLL and personalization’s.
• FNDLOAD for DFF/KFF/Value Set
• WebADI macro Modification.
• Objects migration-using Kintana into multiple instances.
• Trade management Quote/Offer creation and claim creation interfaces.
• Worked for issues on Test cycle 1/2/3.
• Worked on BPEL/SOA 11.1.1.6(For development of claim upload process)
• OIM (Oracle Identity Manager) and EBS integration for Resource creation, Resource update, Employee Update and Employee Termination.
• Trade management production issue resolution for Offer/Claim/Adjustment
• Noetix view customization and View profiling for performance of discoverer report.
• Event Subscription addition for Customer/Party creation process which will populate custom Tables for group customer and members in-group.
• ADF

Confidential

Oracle Apps Techno-Functional Consultant (Oracle Applications R11 - SCM)

Responsibilities:

• Developed a web service to pick data from iMES into EBS and Custom form to provide cancellation functionality through workflow.
• Design and developed architecture to capture data using triggers and transfer to iMES to process work orders and send response to EBS. This architecture is fully verified and used into below outbound interfaces.
• Sub inventory Transfer from iMES system to EBS
• Following Outbound Interfaces to send information from EBS to iMES system through Oracle SOA
• WIP Work Order
• BOM
• ITEM
• Item Category
• Inventory Interface to send following details to iMES
• (Item/Quantity/UOM/Sub Inventory/Locator/Lot number/Owner)
• MD70, MD120, TE20 Preparation and Unit Test Case Prep ration for all above contents.

Confidential, Denver CO

Oracle Apps Technical Consultant (Oracle Applications R12 - FIN/SCM)

Responsibilities:

• Proactively work with business to identify technology initiatives to drive productivity opportunities, operational efficiencies, or increases in customer satisfaction.
• Perform systems analysis of submitted business requirements to define optimal technical solutions.
• Every day to assign tickets to resources based on the precedence.
• Provides work level estimates for projects to establish work plans with the business.
• Lead, design and develop enhancement efforts to the Corporate Applications platforms
• Matrix manage contract development resources (both on-shore and off shore).
• Assign the work to resources and explain the business requirement.
• Lead prioritization of initiatives with business units.
• Worked as a liaison between developers, users
• Develop project plan and manage releases/release calendar.
• SLA Customizations to replace Account Generator oracle workflow and preparation of all test cases and analysis of work and estimation.
• Created workflow to release hold of AP Invoices for approval through mail and attachment of invoice details to release holds.
• Creation and modification around 40 SQL scripts.
• Creation of custom forms for WMS module and analysis of work and estimation.
• Creation of custom form to see Open orders, Lines from Oracle and MES (Third party system on SQL server) details allow to change quantity and Send approval message to users using workflow.
• Standard Check Printing for following banks

Confidential

Responsibilities:

• Developed No bin assignment new report in XML Publisher.
• Developed Pick Pack Slip Report in XML Publisher that has to run with document set and Task should be printed in font 3 of 9 Barcode.
• Developed integration process for FedEx server to oracle apps Server to print and re-print Labels in shipping and retails. For printing label at Quick Ship page is customized.
• Development of receiving worksheet report, which will be called from MSCA Screen. It will display the drop ship orders for a enter PO.
• OM order lines workflow customization for GIFT ORDERS Miscellaneous issue should happen for all items.
• OM Order Lines workflow customization for POS Lines in this miscellaneous issue should happen except for KIT Item.
• OM Order Lines workflow customization for drop items, process should update the order line from external to internal and items should be shipped to warehouse not to end customer.
• PO Approval Workflow needs to be customized to update the Attribute values and if EDI validation fails then PO should not approve.
• MSCA (Mobile Supply Chain) Quick Ship Page is extended to Call FedEx Server on Ship Confirm and print labels.
• MSCA (Mobile Supply Chain) New Page is developed to Re-print Labels based on Delivery ID and Tracking number.
• MD70, MD120, TE20 Preparation and Unit Test Case Prep ration for all above contents.
• Check Printing in XML Publisher for Wells Fargo Bank format in RTF and e-text Templates.
• Creation of Template and Setup for Positive pay report which has to deliver to wells Fargo bank server.
• Customization of API like PO INTERFACE S.

Environment: Oracle Apps R12.1.3 Implementation

Confidential

Oracle Apps Technical Consultant (Oracle Applications 11.5.10 - FIN/SCM)

Responsibilities:

• Developments of XML Publisher Report based on data Template will show custom attribute values.
• Copy Multiple po’s to apps, in this component one form has developed to query for existing PO then it will get copied and into another organization.
• Copy Requisitions from warehouse to other organizations.
• Development of shell scripts to distribute CDR’s in Domain/country/product/profile.
• Development of shell to create domain account.
• Development of shell scripts for pulling and distributing in country hierarchy from FTP server to DB server.
• Determining the web manager server static’s and prepares the html file of statistics and sends the mail.
• Preparation of report for db connections and send that report through mail.
• Preparations of LLD’s (Low Label Design Documents), preparing the Technical document.
• Development of new forms on Template.fmb for Setup.

Environment: Oracle Apps 11.5.10 Support and Customization