SUMMARY:

• Around 8 years of experience as Oracle Applications EBS Techno functional Consultant
• Experience in Order to Cash (OTC), Procure to Pay (P2P) Accounts receivables (AR), Accounts Payables (AP) and GL business flows,
• Good Knowledge and work experience in Order Management (OM), Service Contract, Install Base, TCA Architecture, Account Receivables (AR), Purchasing (PO), Inventory(INV), Account Payables (AP), General Ledger (GL) Modules.
• Technical expertise in SQL, PLSQL, Oracle Reports 6i/10g, BI/XML Publisher Reports, Oracle BPA reports, OAF Development, Personalization and Extension, Business Events, Oracle Workflow, Oracle Alerts.
• Participated in multiple CRP(s), including UAT and go - live phases of the projects. Provided support during Go-Live and post Go-Live activities.
• Worked as Team Lead at onsite and offshore delivering complex solutions in different Implementation, Upgrade & Support projects.
• Experience in Onshore-Offshore model Implementation and commitment to excellence proven by an outstanding career track
• Experience in creating Development Requirements, Technical Designs, Conversion Mapping Documents, User training manuals, Test procedure document preparation
• Experienced in writing AIM Documents - MD050, MD70, CV040, CV60, MD120, TE020
• Worked with Oracle support to resolve seeded application issues. Created service requests (SRs) with oracle support and tracking them to closure.
• Experience with the following tools: TOAD, SQL Developer, Putty, Win SCP, SVN, and Kintana.

TECHNICAL SKILLS:

ERP: Oracle E-business Suite (11.5.10 and R12), B2B

Modules: Order Management, Account Receivables, Purchasing, Account Payables, General Ledger, Inventory (INV), Service Contract, Install Base

Primary Skills: Oracle EBS Technical Development (RICEF Components), Interface (Inbound and Outbound), Conversions, Extensions, Oracle Application Framework (OAF), Form Personalization, Workflow builder, XML Reports, Oracle Alerts and Business Events.

Database: Oracle 9i/10g, Oracle 12C, Mongo DB

Languages: SQL, PL/SQL, UNIX, Shell Scripting

Tools and Utilities: TOAD, SQL Loader, SQL Developer, Winscp, Pentaho Data Integrator

Configuration Tools: VSS, Kintana

Documentation: MD70, MD120, CV60, CV70, CV040, TE020

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara CA

Senior Oracle EBS Technical Consultant

Responsibilities:

• Worked on Oneveiw project to integrate Salesforce with Oracle modules - Automation of Sales order and RMA order creation from SFDC quotes. Mule soft is used as the integrator between Oracle and SFDC which will build the payload to SFDC based on the data provided by Oracle
• Involved in the IT testing of Oneview project to ensure that oracle orders are created from SFDC quotes and are progressed successfully through WMS system. Used barcode VT to pick, assemble, pack and ship the orders
• Maintain integration between Siebel and Oracle Order management and related production issues
• Worked on B2B project, to enable the Back to back order process. Created Blanket Purchase Agreements and Approved Supplier list. Modified the Assignment set to attach the ASL Item to sourcing rule.
• Created custom program to Upload Approved supplier list from SQL loader program
• Worked on production issues to solve Purchasing document approval issues. Good working knowledge of document approval hierarchy is setup(Position Hierarchy and Employee Supervisor Hierarchy)
• Modified the supplier setups to make use of “Pay on Receipt AutoInvoice Program” to automatically create Invoices from PO receipt.
• Handled production issues for Invoices created from Purchase orders. Good knowledge of invoice validation, Create accounting, journal import and journal posting process
• Worked on customer questionnaire tool project where the Configuration team will get the details in advance when the quote is created and approved
• Development and maintenance of Jobs and Transformations using Pentaho Data Integrator BI tool to integrate different Oracle Instances. Worked on Oracle 12 C database and integration of 12C with 11G database
• Worked on Mongo DB to develop JSON Objects which will be used directly by angular application
• Design & customization, RDF and XML Publisher Reports, Oracle Workflows, Form Personalization’s and OAF.
• Development using Reports 10g, BI Publisher and XML Publisher Report, Forms 10g, Workflows. Extensions, Conversions, Interfaces, UNIX Shell Scripting.

Environment: Oracle Applications R12, PL/SQL, TOAD, Oracle Order Management, Oracle Purchasing, Account Payables, warehouse management system, Oracle Workflows, PVCS, Kintana, Pentaho

Confidential, Mountain view CA

Senior Oracle EBS Technical Consultant

Responsibilities:

• Worked on the Order header workflow Customization to send the Order Acknowledgement report to customer after an order is successfully booked.
• Worked on Customer conversion to bring the data from Symantec R12 instance to new VERITAS R12 instance
• Accounts conversion
• Contacts conversion
• Profile conversion
• Customer conversion also includes the Multibyte character conversion for bill to and ship to site addresses for Japan.
• Relevant documentation for Code migration to various environments throughout the project lifecycle.MD070, CV60
• Participate in CRP2/Integration Testing & User Acceptance Testing (including test script development).

Environment: Oracle Applications R12, PL/SQL, TOAD, Oracle CDH, Oracle Order Management, Oracle workflows.

Confidential, Hanover MD

Lead Oracle Apps Technical Consultant

Responsibilities:

• Migration of missing 20K serial Numbers to Install base from Legacy Systems
• Automation of populating Installation details on RMA Sales Orders
• Monitoring RMA Orders to make sure that Install base and Warranties are updated correctly
• Develop XML Publisher Reports to Generate the weekly Update Summary of Contracts created and updated by RMA Orders
• Handle Production issues for Service contract and Install base modules
• Perform Unit testing and participate in testing with SME(s)
• Participate in UAT and Deployment process
• Logging/following up Service Requests with Oracle Support.
• Prepare Technical design specification documents for the customization and relevant data conversion objects.

Environment: Oracle Applications R12, PL/SQL, Oracle Forms, Reports, TOAD, UNIX.

Confidential

Lead Oracle Apps Technical Consultant

Responsibilities:

• Understanding the current 3rd party interfaces which were primarily in SQL Server integrated with Oracle
• Understanding and later assisting in Month/quarter end processes.
• Taking part in day to day calls and prioritizing the tickets and enhancements. Also, assist team in doing UAT
• designed and developed AP Invoice interface and payment interfaces for FedEx & Amex
• Created complex XML reports which had different layouts for different operating units. Report bursting was required to mail the reports to specific stakeholders.
• Form customization to enhance validations during period end processes
• Created reports (XML) whose data was used to validate the period/quarter end processes.
• Creating high level designs for various customizations and making sure that the components are delivered by the offshore team on time.

Environment: Oracle Reports 10g, BI Publisher, Oracle SQL Developer, PL/SQL, Winscp, UNIX, Accounts Receivables, Account Payables, Oracle Purchasing, Order management, GL

Confidential

Lead Oracle Apps Technical Consultant

Responsibilities:

• Analyzed the custom code components in proc to pay process and retrofitted custom PL/SQL Packages, Reports, Forms, and Workflows to make them work in R12. Personalization and Extension of OAF pages in various modules.
• Retrofitted custom PL/SQL interfaces - import Suppliers, Banks, Payable Invoices, Requisitions, Purchase Orders, and Receipts.
• Development of custom payment extract and formatting programs in R12 for Maybank and Hong leong Bank.
• Retrofitted XML Publisher and D2k Reports - Purchase Order Print Report, Change Order Report, and RFQ report, Accrual Maintenance Summary Report, Check Print on preprinted stationary report, Duplicate Payment Report, Payable Trial Balance Report, Developed Multi language payment remittance advice.
• D2k form personalization of Purchasing and Invoice workbench.
• Retrofitted shell scripts used for loading data files using sql*loader and developed shell script for delivering/retrieving files via FTP and moving files between directories.
• Retrofitted customized PO Approval, PO Document Create workflows.
• Modifying service contract and Install base objects.
• Unit testing and System integration testing.
• Preparation of installation files. Migrating and installing code to higher instances.
• Writing scripts to convert open invoices from legacy systems

Environment: Oracle Applications 11.5.10, R12.1.3, Oracle 10g, TOAD, UNIX, XML Publisher, Workflow

Confidential

Lead Oracle Apps Technical Consultant

Responsibilities:

• Prepare Technical design specification documents for the customization and relevant data conversion objects.
• Relevant documentation for Code migration to various environments throughout the project lifecycle.
• Development including data conversion, testing & migration of data for Install base. Migrated around 5M serial Numbers to install base and developed an Interface to create Warranty Contracts Automatically from the Sales Order Shipments.
• Created More than 100K Warranty Contracts as a part of Data migration from SAP and Entitlement Tracker Systems
• Developed an Interface Between Network Tracker(Custom Application for Confidential ) and Oracle Install base/Service Contract Modules to show the Warranty Information to the end users when the Serial Number is Returned for Repair or Replacement.
• Developed Interface Between OM and Install base to create Item Instances in Install base for Order Lines which are not shipped (for Software order lines)
• Closely worked with the BI Team and helped them to Generate Reports which will give Information about warranty contracts which are newly created for a customer or contracts to be expired.
• Development of identified technical Components as mentioned in technical scope section.
• Participated in CRP2/Integration Testing & User Acceptance Testing (including test script development).
• Transition to production support team & participation in go-live activities.
• Post Go live support for 2 weeks as per staffing plan)
• Developed various UNIX scripts such as Archiving of the files, moving them to different servers etc.

Environment: Oracle Applications 11.5.10, Oracle 10g, Oracle Developer Suite 10g, TOAD, UNIX, XML Publisher, OAF, Oracle Workflow Builder

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed an Interface for service contract module to automate the creation for service contracts from sales orders.
• Involved in Service Contracts Conversion
• Modified the Order line workflow to allow the billing to happen through service contracts using Billing schedules
• Created a custom QA Checklist for Service Contract Module
• Created form personalization.
• Have good Functional knowledge in this Module.
• Prepared Technical design specification documents for the customization and relevant data conversion objects.
• Relevant documentation for Code migration to various environments throughout the project lifecycle.
• Participate in CRP2/Integration Testing & User Acceptance Testing (including test script development).
• Transition to production support team & participation in go-live activities.
• Post Go live support for 2 weeks (as per staffing plan)

Environment: Oracle Applications 11.5.10, PL/SQL, TOAD, UNIX, Oracle workflow builder

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Provide Support to all the IExpense, OM, Inventory and Finance Issues
• Managing the OM Incidents raised by the Confidential Users
• Created 3 Complex OAF Pages for Revenue Recognition Module which included Partial page rendering functionality
• Work with Client’s respective SME(s) / IT Team to understand the requirements
• Work closely with Onsite counterpart(s) for seamless coordination and follow ups
• Write design document and build the requirements
• Perform Unit testing and participate in testing with SME(s)
• Participate in UAT and Deployment process
• Logging/following up Service Requests with Oracle Support.

Environment: Oracle Applications 11.5.10, Oracle 10g, Oracle Developer Suite 10g, TOAD, UNIX, XML Publisher, OAF, Oracle Workflow Builder

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Interfaced with client on business requirements to provide a solution to derive the delta data for GL Conversion
• Provided guidance to offshore team on development activities
• Developed file formats and concurrent programs to automatically derive the pre conversion data, delta records and post conversion data. This helped in doing the conversion analysis
• Form personalization in Journal Entry form to force custom rules for manual JE
• Doing peer review for the GL conversion technical objects
• Customizing Oracle Workflow to make custom approvals for Manual journals
• Taking part in cut over plans to discuss the black out, code migration, set ups and other activities.
• Creating metric reports (XML publisher) for data validations
• Made OAF customization to custom error correction OAF pages.

Environment: Oracle Applications R12.1.3 - General ledger (GL), XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Form Personalization, Oracle Workflow, Oracle Application Framework (OAF)

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Worked as a senior system Analyst for Oracle R12.1.3 development of BPA (AR) invoices and design and building of Document retention interface.
• design and development of Integration between AR and AGIS (Intercompany system) Modules
• Involved in development of complex RICEF objects in accordance with technical development standards.
• Worked on Bill Presentment Architecture (BPA) and Advanced collections
• Created BPA Invoices using XML Publisher
• Designed and built interfaces between Oracle AR and 3rd party file retention system using PL/Sql and Unix SFTP

Environment: Oracle Applications R12.1.3 - Account Receivables (AR), AGIS, XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Form Personalization, UTL FILE package

Confidential

Oracle EBS Technical Consultant.

Responsibilities:

• Being a technical consultant involved in all the custom components of the modules OM, INV, PO, and Pricing.
• Developed inbound interfaces on PO receipt creation, sales order import and sales person conversion.
• Developed and customized RICE components like Reports, Forms, Interfaces, Conversions, Extensions and Workflows as per client requirements.
• Experience in BI/XML Publisher Reporting Tool
• Worked with SQL * Loader, UTL File for outbound and inbound interfaces
• Developed custom forms for common error handling framework mechanism for the capturing the errors in all the components including inbound and outbound interfaces.
• Worked on form personalization on receivables transaction form.
• Coding the requirements as per the standards
• Experience in customizing standard Oracle forms with the use of CUSTOM.PLL and Form Personalization

Environment: Oracle 10g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher, BI, RICE, UTL, CUSTOM.PLL