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:

Client: Confidential, Santa Clara CA

Role: Senior Oracle EBS Technical Consultant

Description: Maintaining Hitachi Data Systems Oracle application production instance and provide support for production issues and also work on additional enhancements related to SCM Modules. Worked on the design of Customer questionnaire tool which will integrate with BI Aries system to allow the Sales team to create Questionnaires for the approved Quotes.

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

Client: Confidential, Mountain view CA

Role: Senior Oracle EBS Technical Consultant

Description: Confidential announced the split of the company into two parts in 2015. The Information Security business will remain with Confidential . The Information Management business will be known as VERITAS Technologies Corporation (VERITAS). VERITAS Technologies Corporation will be its own publicly traded company which will not be associated with Confidential . The separation of the companies is expected to be completed by January 1, 2016. As part of the separation project, a new EBS R12 (12.1.3) instance is setup for Confidential “Information Management” business unit (VERITAS). Customer, service contract, install base, fixed asset, Items, Pricelist and other ERP business entities needs to be converted from its current source EBS R11 (11.5.9), EBS R12 (12.1.3), CDHA (R12), OCM (R12) and EDW to the newly setup EBS R12 (12.1.3).

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 Confidential 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.

Client: Confidential, Hanover MD

Role: Lead Oracle Apps Technical Consultant

Project: Ciena SRV4 Install Base Support

Description: Providing support to Install base and service contract modules which is closely integrated with ciena’s in-house applications CPODS and CCDB.

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.

Employer: Confidential

Role: Lead Oracle Apps Technical Consultant

Project: KCI Systagenix Migration

Description: Kinetic Concepts, Inc., (KCI) is a global corporation that produces medical technology related to wounds and wound healing. KCI produced the first product developed specifically for negative pressure wound therapy.

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

Employer: Confidential

Role: Lead Oracle Apps Technical Consultant

Project: Oracle R12 Upgrade - SCM/Finance

Description: This project was primarily upgrading Ciena’s system to R 12 from 11 i. They also needed some custom modules to be retrofitted as well, which was integrated with oracle

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

Employer: Confidential

Role: Lead Oracle Apps Technical Consultant

Project: SRV4 Install Base Implementation

Description: The purpose of the project is to provide L3 technical production support for Ciena applications i.e. Oracle EBS, Agile, MCS, B2B and CIT Applications. The support team formation is as per the request from Ciena in defined areas for a specified time period.

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 Ciena) 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

Employer: Confidential

Role: Oracle Apps Technical Consultant

Project: SRV2 Service Contract Implementation

Description: Confidential is a United States-based global supplier of telecommunications networking equipment, software and services that support the delivery and transport of voice, video and data services. Its products are used in telecommunications networks operated by telecommunications service providers, cable operators, governments and enterprises. Purpose of this project is to implement oracle service contract module for Ciena to retire the In-house applications Entitlement tracker and SNMT

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

Employer: Confidential

Role: Oracle Apps Technical Consultant

Project: Oracle apps 11i Support

Description: The purpose of the project is to provide L3 technical production support for Ciena applications i.e. Oracle EBS, Agile, MCS, B2B and CIT Applications. The support team formation is as per the request from Ciena in defined areas for a specified time period.

Responsibilities:

• Provide Support to all the IExpense, OM, Inventory and Finance Issues
• Managing the OM Incidents raised by the Ciena 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

Employer: Confidential

Role: Oracle Apps Technical Consultant

Project: DTS Harmonization – Rel 12 Finance

Description: Each verticals of GE has a common General Ledger (Uniform – non Oracle) which was used for GL related activities. The data used to flow from Local GL to Uniform. But there were a lot of transactions which was directly done in Uniform. The goal of this project is to isolate Uniform so that only Local GL can be used hence fourth and all the GL data was to be converted to Local GL (Oracle).

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)

Employer: Confidential

Role: Oracle Apps Technical Consultant

Project: UTC FS EMEA ROLLOUT

Description: The Purpose of this project was to manage the invoice designs for various categories/interfaces using Bills presentment architecture (BPA) in Oracle receivables and also create an interface program to move these invoices to a third party document retention tool.

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

Client: Confidential

Role: Oracle EBS Technical Consultant

Description: Tactical Reporting project has been developed to provide an insight into the Business from the Management Perspective which will help the management to make strategic decisions.

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