SUMMARY

• 17 years of overall extensive IT experience in all aspects of Oracle Applications Analysis, Design, Development, Production Support, Testing, Migration, Conversion, Customization, Implementation, Upgrade and documentations.
• 9 years of work experience on Techno Functional knowledge on Oracle E - Business Suite Application in Supply Chain /CRM modules Order Management(OM), Pricing, Shipping, Purchasing(PO), Inventory(INV), BOM, WIP. Also, worked on Account Payables(AP) & GL custom solutions.
• Worked in Oracle Corporation for 7.7 Years.
• Expertize in customization of Oracle Forms/Reports, Data Conversions, Real time Interfaces, Customizations, Extensions (RICE) on Oracle Applications R12 and 11i.
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality.
• Experience in Oracle Application upgrades from 11i to R12 releases and 12.2.6 to 12.2.9.
• Experience working on complex applications using Oracle SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes, worked on Script development using UNIX and Shell Scripts.
• Knowledge of code migration tool Kintana (HP PPM), Clearcase, SVN, GIT CMD and AIM Methodology.
• Onsite Site Post PROD Support, Enhancements & new solution development experience of Oracle Apps eBusiness Suite 11i & R12
• Post PROD Support, Enhancements & development of OTBI report experience in Oracle Cloud Application 22C (11.13.22.07.0 ).
• Participation in varied roles ranging from Team Lead, Techno Functional and Technical Consultant.
• Over 4 years of experience in managing and leading a team as a team leader and onsite-offshore coordinator.
• Expertise in preparing AIM(Application Implementation Methodology) Documents and User Manuals Functional Specification Document (MD050), Technical Design Document (MD070/CV060) and Conversion Mapping Document (CV040).
• Good experience in Oracle Applications Application Object library (AOL).
• Identified product gaps, coordinated with other Teams by creating Service Requests (SR) and obtained one-off fixes. Managed and monitored SRs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
• Experience in Application System Administration activities like Managing Concurrent managers, Application User set up, defining responsibilities, Value sets, Flex Fields, Registering menus and providing support to Apps end users.
• Good international experience of working in four different countries. USA, Malaysia, Singapore and India.
• Out-of-the-box thinking and creative problem solving.
• Excellent communication and interpersonal skills. Very good client relationship track. Good Leadership qualities with go-get abilities.
• Knowledge on TCA architecture.
• Distribution Centre/Hosting Provider migration from DATA Intensity to Syntax.
• Supplier Payments processing via APRO tool

TECHNICAL SKILLS

ERP: Oracle Cloud Application 22B Payables & Payments, Oracle Application R12 and 11i (Order Management, Shipping Execution, Inventory, Purchasing, BOM, WIP, Account Payables, Payments, Oracle Workflow, iProcurement, AOL, SYSADMIN, XML Publisher Administrator, Integrated SOA Gateway and OIC

Programming Language: PL/SQL, SQL, Unix Shell Scripts

RDBMS: Oracle 9i, Oracle 10g, Oracle 11g and Oracle 12c

Development Tools: XML Publisher

Desktop Applications: PL/SQL Developer, SQL Developer, TOAD, SQL*Loader, Oracle Forms 6i and Reports 6i, Oracle Developer Suite 10g, Workflow Builder

Other Tools: Putty, SSH, WinSCP, PVCS, Clear Case, Kintana, SVN, Fiddler and GIT CMD

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in all escalations call till issue resolutions, make sure to deliver the quality solutions on time, weekly status call with Customer/Stakeholders.
• Development and Enhancements of Oracle Account Payables Reports, BI Publisher Reports, Interfaces, Conversions, Extensions, Workflows
• Form Personalization, WEBADI & Complex PLSQL.
• Provide technical guidance for Development & Enhancements of RICEW objects.
• Understand business requirement and prepare MD.070 document for enhancements to existing customizations/extensions
• Interacting directly to client by conf. call and BlueJeans meeting.
• Co-ordinate with Tax team for invoice tax issues.
• Was involved in getting solution (Data fix/Break fix) from Oracle Product support team for standard oracle issues via SR’s.
• Add users in approval setup for Payment Batch Approval.
• Worked with Bank, APRO & Supplier Management Team for Payment rejections.
• New OU setups Payables option, Financial options, Payment Reasons & Invoice holds creation.
• H2H setup to create new bank accounts in Oracle, work with APRO to get payment formats as per bank requirements & setup bank accounts in APRO tool for payment processing.
• Create test payment files for bank validation before PROD migration.
• Worked with APRO team for format changes requested by bank to process payments as per bank specifications & testing the fix by creating payment files for bank validation.
• APRO upgrade to new version testing in UAT prior Prod migration.
• Worked with DBA team for Payment file transfer issue due to finhub-sendfile fail.
• Datafix to add new OU & LE to AP period close automation.
• Datafix to process missing invoice attachments.
• Provide the support on call production deployment, Job failures and data issues
• Work on Prod, Non-Prod issues on the Intern ticketing system and provide resolutions to meet the SLA.
• Provide Implementation support with deployment plans and environment validation strategies.
• Provide data extract for Unapplied Prepayment Invoices, Unreleased Invoice Holds from EBS to Fusion implementation team for data conversions.
• Collaborate with business and technical SME's to identify data integration requirements
• Oracle EBS half yearly DR Exercise & also part of quarterly Security Patch testing in UAT & PROD.
• Involved in smoke testing of Quarterly planned DC switchovers
• AP Audit control execution test cases execution for 12.2.9 Pre Go Live & also semi annual execution of the same as per Audit requirement.
• Global Disbursement Payments for EMEA, LATAM and APAC via Fusion.
• Also involved in the development and enhancement of below technical components:
• Inbound Interface for processing MDSL Brazil invoices into Integrated Receiving.
• Custom logic to apply hold US WHT Review for NORAM invoices based on PO purchase categories.
• New custom API to update invoice approval status from Intern to Oracle.
• MDSL inbound interface to process PO & Non-PO invoices to Oracle.
• MDSL Inbound Interface logic to retain a dash (-) in the invoice number for Peru TEM invoices.
• Modified the logic to fix data integrity issue from Oracle to MDSL Outbound Payment File Issue.
• Create new WEBADI Direct Debits template similar to exiting Pre-Approved template with additional fields PO exemption category and Payment method
• Form personalization to sync Remittance Message 1 mismatch between invoice header & scheduled payment tab in Oracle.
• Enhancement to check the Country Code as US for the Primary LE Address Country, in addition to the existing check for OU/LE Country as US while applying Tax Classification Code SALES TAX RATE.
• For Fusion AP Payment Batch Approval, capture payment batches submitted in Oracle for approval in custom table in INITIATED status, so that Intern team can Sync batches ready for approval in Intern.

Environment: Oracle Apps 12.2.6/12.2.9/ Oracle Cloud Application 22B (PO and AP/Payment modules), PL/SQL procedures/Unix Shell Scripts, WEBADI, Oracle database 19c, SQL Developer, Oracle Reports, XML Publisher Reports, OTBI Reports, Intern Tasks User Ticketing tool, GIT CMD, APRO, WinSCP and Putty

Confidential, Vista, CA

Technical Lead

Responsibilities:

• Provide technical guidance for DC Migration and Oracle Upgrade project
• Environment and data migration validations and signoff
• Lead code retrofit for custom objects, unit test and regression testing
• Assist CRPs, resolve issues
• Plan and lead SIT, resolve issues
• Co-ordinate 3rd party vendor integrations and testing
• Support go-live and hyper-care
• Integrate and co-ordinate EBS upgrade with Data Center migration activities
• Assist in creating schedule and project timeline
• Change Management - ensure seamless integration of active projects with EBS upgrade
• Provide technical guidance, applying strategies and standards to ensure project success
• Identify and help manage project risks, develop contingency plans as necessary

Environment: Oracle Apps R12, PL/SQL procedures/Unix Shell Scripts, Oracle database 11g/12c, TOAD, Oracle Reports, XML Publisher Reports, ITNow User Ticketing tool, SVN, WinSCP and Putty

Confidential, Richmond, VA

Oracle Sr. SCM Techno Functional Consultant

Responsibilities:

• Understand business requirement and prepare MD.070 document for enhancements to existing extensions
• Review the packages contents and ensure that change has properly done as per requested, tested and documented
• Explaining the action items to the offshore team
• Helping in closing related critical issues.
• Guiding team time to time whenever it is required and helping them out in case of any issue/bug
• Interacting directly to client by conf. call and Web-ex meeting.
• Taking the ownership of any object where it is required.
• Involved in all escalations call till issue resolutions, make sure to deliver the quality solutions on time, weekly status call with Customer/Stakeholders.
• Resolved multiple issues pertaining to Cancelled sales order and implemented the permanent solution for the same.
• Implemented a permanent solution to fix Preferred Access intermittent Automatic Reservation issue during Sales order booking.
• I was part of testing Preferred Access functionality for Oracle EBS Annual DR Exercise & also part of Q4 Patch testing.
• Also, Responsible for the Development/Enhancement of following Technical Components

Environment: Oracle Apps 12i (OM, INV, PO, and AP modules), PL/SQL procedures/Unix Shell Scripts, Oracle database 10g/11g/12c, TOAD, Oracle Reports, XML Publisher Reports, BMC Remedy User Ticketing tool, SVN, WinSCP and Putty

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Solved PROD issues pertaining to Order to Cash cycle like Order Import, RMA, ISO, OM Scheduling, Workfow, Pick release, Pick Confirm, Ship confirm
• Receipt, LPN and Pricing issues. Also involved in MEC activities like clearing pending transactions.
• Worked on Development/Enhancement of following Technical Components

Environment: Oracle Apps 12i (Modules -OM, INV, WSH, AP, PO and GL), PL/SQL procedures/Unix Shell Scripts, Oracle database 9i/10g, TOAD, Oracle Reports and BMC Ticketing tool and Putty

Confidential

Oracle SCM Techno-Functional Consultant and Team Lead

Responsibilities:

• I was part of War-room team during R12 upgrade project.
• Resolved many critical issues like Tax Group Setup for AP, AI- Future Date Issue, Agilent Shipment Details Report
• AP Hold notification not working, Rejection Hold not in place after rejecting the invoice through IOH notification which were show stopper for R12 go-live
• Being part of the ON-SITE/OFFSHORE development/support team, responsible for the following Technical components.
• Involved in all SCM/FO Escalation and work the issues till Closure.
• Took part in handling the customer level performance escalations and help them to fix the issues at the earliest.
• Involved all Top Priority Issues and Month End Closure Activity, co-ordinate with Business Users and resolve the issues priority.
• Involved in solving various issues in OIC
• Co-ordination between Product Support and the Client with respect to Setup related issues.
• Was involved in getting solution (Data fix/Break fix) from Product support team for standard oracle issues.
• Involved in solving various tickets regarding Order Import, RMA, ISO, OM Scheduling, Workfow, Pick release, Pick Confirm, Ship confirm, Receipt issues. Also involved in Pricing issues.
• Involved in Various Serial Number, LPN, Min-Max Planning issues.
• Involved in solving various iProcurement and Direct Procurement issues like PR, BPA, PO, and IRQ.
• Involved in Various customization issues regarding the data flow from Oracle - FUSION - SIEBEL.
• Involved in Various customization issues regarding the data flow from Oracle - FUSION - Nextlink.
• Got Appreciation's from Client from both Onsite (Penang-Malaysia) as well as Offshore (Bangalore-India) for solving Various issues in time and meeting the Deadlines.
• Impact Analysis of the corrections to be implemented on the system. Impact analysis of Oracle Product Patches.
• Change Request Processing.
• Was involved in MEC activities like clearing transactions stuck in MTI, RTI and MMTT.
• Was involved in enhancement of RICE components.

Environment: Oracle Apps 11i/R12 (Modules - OM, PO, INV and OIC), PL/SQL procedures/Unix Shell Scripts, Oracle database 9i/10g, TOAD, Oracle Reports, Oracle XML Publisher, OVSD Ticketing tool, WinSCP and Putty

Confidential

Oracle Techno-Functional Consultant & ON-SITE Co-Ordinator

Responsibilities:

• Reviewing CV60’s and Data Migration Codes and to make necessary changes required in technical documents and data migration codes.
• Was involved in coordinating with offshore Data migration Team for DM activities and helping them in resolving issues related to DM.
• Involved in optimize the performance and Enhancements of CEMLI objects.
• Involved in enhancement and testing of Confidential Interface.
• Involved in setup related change requests.
• Involved in Post Production Support of Technical issues of CEMLI objects till stabilization.
• Involved in all of the Test Cycles.

Environment: Oracle Apps 11i (Modules -INV, PO and OM), PL/SQL procedures, Oracle database 9i/10g, TOAD, SQL Developer, WinSCP, Putty, Kintana, Clearcase and OVSD ticketing tool.

Confidential

Oracle Technical Consultant

Responsibilities:

• This Task mainly involves the development of Extracts which would inturn be used for Data Conversions.
• Involved in the Upgradation Performed by the Confidential from 11.5.5 to 11.5.10
• Involved in the development of following data conversions

Environment: Oracle Apps 11i (Modules - Inventory, PO and OM.), PL/SQL procedures, Oracle database 9i/10g, PL/SQL Developer and SQL Loader.

Confidential

Oracle Technical Consultant

Responsibilities:

• Items Conversion.
• Conversion of item default locators.
• Customization of PO Form TO Ensure No PO Is Created for Less Than US$1000.
• Custom Report for Purchase Orders with Matching Type by Supplier, By Period.
• Sales Orders and RMA Outbound Interface by Salesperson, By Customer.

Environment: Oracle Apps 11.5.7(Modules - INV, PO and OM), PL/SQL procedures, Oracle 9i, TOAD and SQL Loader.

Confidential

Oracle Technical Consultant

Responsibilities:

• Implement zoom in the sales order form to view the item definition information Passing Item As Parameter.
• Report on Unused Items (not transacted in the past X days and not on any PO in the past X days) by inventory org, by buyer, by category.
• Item ABC Codes Migration.
• Item Categories and category assignments conversion.

Environment: Oracle Apps 11i (INV, OM & PO), Reports 6i, TOAD, SQL Loader.