Summary:

• Thirteen years of experience as a Oracle Applications/EBS Consultant actively involved in Analysis, Design, Development, Testing, Documentation and Implementation of business applications using Oracle Application/Oracle E-Business suite 11.5.8/11.5.10/12.1.3 in diverse areas.
• Over five years of experience as a Techno-Functional Consultant designing, developing, testing and documenting extensions for upgrade projects from 11.5.10 to R12.
• Worked through the project life cycle SDLC Software Development Life Cycle , starting from high level design to system/integration testing.
• Worked extensively in Analysis of Business Requirements, Preparation of Functional Specification Documents, Review/Preparation of Design Specification Documents, Development/Guiding the developers in the development process, Preparation of Test Cases/Test Plans, Unit/Component Integration/Systems Acceptance/User Acceptance Tests.
• Worked on several RICEW objects such as customization/modification of Reports using Oracle Reports XML Publisher, various Interfaces such as GL and AP interfaces, Conversion of data from R11 to R12, customization of Order Line workflow, create of custom packages and procedures etc.
• Have worked on various modules such as Accounts Payable, Payments, Accounts Receivable, General Ledger, Cash Management, Order Management, Shipping, Inventory, Spares Management, WMS, Flow Manufacturing etc.
• Extremely motivated team player with solid organizational and time management skills. Have very good communication and interpersonal skills.

Skills:

• Oracle Application/E-Business suite: Release 12.1.3, 11.5.10, 11.5.8:
• Accounts Payable, Payments, Accounts Receivable, General Ledger,
• Cash Management.
• Order Management, Shipping, WMS, Inventory, WIP, Flow Manufacturing,
• BOM, Spares Management.
• Application Object Library.
• Design Tools: Oracle SQL Developer, SQL Navigator, Toad, Oracle Reports, Oracle
• Forms, Oracle BI Publisher, Workflow Builder,
• Loftware Label Designing.

Project Experience:

Confidential

Sensata Technologies are the world's leading supplier of sensors and controls across a broad range of markets and applications. The company was Re-Implementing Oracle E-Business Suite 12.1.3 from 11.0.3 version of Oracle ERP. I was part of the technical team involved in Conversion of data from R11 to R12.

Responsibilities:

• Review the Conversion scripts and Technical Validation/ Data cleansing Scripts created for validating the converted data relating to AP Suppliers, AP Supplier Sites, AP Invoices, GL Balances, GL Journals, Open Purchase Orders etc and fix issues observed.
• Co-ordinate with the Subject Matter Experts and Business Analysts.
• Provide oversight and guidance to the offshore development team.

Oracle Financials

• Symphony IRI Group provides analytics, business intelligence solutions, consulting services and subject matter expertise to the world's leading CPG, retail and healthcare companies to drive their insights. The company enters the Customer data and Orders information in Siebel. Through custom interfaces, the Customer data is interfaced into Oracle Receivables and Orders information are interfaced into Oracle Projects. Invoices are created from Oracle Receivables and Oracle Projects.
• The company uses the following Oracle Application modules 11.5.8 version:
• Accounts Receivables, Accounts Payables, Oracle Projects, General Ledger, Oracle Financial Analyzer, Fixed Assets Cash Management.
• Responsibilities:
• Managing a team of off-shore consultants for providing support for maintenance
• of the Oracle Applications modules.
• Interact with the users of the applications to understand their requirement and
• document the same.
• Guide the off-shore team in making necessary modifications to fix the issues
• observed.
• Help in testing the fixes provided and co-ordinate with the users for testing the
• same in the Test environment and get the same moved to the Production
• environment.
• Monitor the Remedy tickets created by the users for the issues observed and
• ensure that the issues are attended and fixed by the off-shore team in a timely
• manner.

Oracle R12 Upgrade Project

The project involves upgrading the client's ERP system from Oracle 11.5.10 to 12.1.3. The client specialize in kiosk products for the retail, financial, travel, healthcare, food service, entertainment, gaming and public sector industries. Their main products are self-service kiosks, point-of-sale terminals, automated teller machines, check processing systems, barcode scanners and business consumables. They are also one of the largest providers of IT maintenance support services.

Responsibilities:

• Identifying modifications to be made to the custom programs for
• sending extracts from various tracks of ERP to EDW due to structural changes of
• various tables in R12, preparation of Functional and Design Specification
• documents, mentor the developers for modifying the PL/SQL programs for creation of extract files to be sent to EDW, reviewing the codes, co-ordinating with the EDW team and testing of the extracts processes.
• Responsible for identifying the modifications to be made to the client's RICEW
• components such as custom processes and custom reports in Accounts Payable based on the changes in the functionalities in R12 viz. introduction of Invoice Lines, integration with E-Business Tax, Suppliers/Supplier Sites migrated to TCA parties, Banks and bank branches migrated to TCA parties and introduction of Subsidiary Ledger Accounting SLA , preparing Functional Specification documents, guiding the developers in the development process and testing the development.
• Analysing the client's existing Payments process using e-Commerce
• Gateway, Identifying the modifications to be made to the layout design due to changes in R12, identifying the changes to be made to the custom programs for creation of EDI820 Payment output files, prepare the functional/design specifications documents, modify the PL/SQL packages/procedures for creation of the EDI820 payment output files to be sent to the payment banks, preparation of test plans, testing the payment process and providing post-deployment support.
• Identifying the modifications to be made to the custom Oracle Reports rdf
• due to changes in table structures in R12, preparing the functional/design specification document for the changes, mentor the developers for making modifications to the custom reports and test the changes made.
• Raise Oracle Service Requests wherever necessary and work with the Oracle
• personnel to get the fix implemented.

Senior Analyst/Techno-

The Enterprise Services Project of the client involved upgrading from Oracle Application 11.5.8 to Oracle E-Business Suite 12.1.3 and implementation of new modules like Field Service, Service Contracts, Spares Management, Tele Service, Install Base etc.

Responsibilities:

• Analysis of Business Requirements and Preparation of Functional Specification
• documents for following requirements:
• --In-transit shipment transactions at the Central Warehouse for shipment of parts from Suppliers/Regional Warehouse to the Custom Engineers. Creation of a custom form for performing in-transit receipts/shipment, consolidation/splitting of shipments at the Central Warehouse for shipment of spare parts from suppliers/Regional Warehouse to the Custom Engineers and Return of excess/defective spare parts from Custom Engineers to the suppliers/Regional Warehouse.
• --Automation of Pick Release process for Emergency orders for shipment of spare parts by customizing the Order Line Workflow process using Workflow Builder. The order line workflow was customized to include pick release process and automatic printing of pick ship labels immediately after the automated Pick Release process.
• --Interfacing with external applications and interfacing with external web applications using Service Oriented Architecture SOA Enterprise Service Bus.
• Review the Design Specification documents and codes developed for the various
• development processes and guiding the off-shore developers.
• Prepare Test Plans and Test Scripts for testing the developed processes.
• Perform Unit tests and Component Integration Tests and provide support for Systems Acceptance and User Acceptance Tests.
• Design and develop Payment formats Nacha format rtf file for creation of
• Payment files to be sent to banks and test the same.
• Design and develop pick ship labels for printing of labels for shipment of parts.
• Design and develop custom 'Collect Revenue recognition Information' program, customized Material Accounts Distribution Detail report.

Systems Analyst Oracle

Was a key member of the development team of the client's ERP Project for upgrading from Oracle Applications 10.7/11.03 to Oracle Applications 11.5.8/ 11.5.10.

Responsibilities:

• Analysis of Business Requirements and Preparation of Functional Specification
• and Design Specification documents for interfacing journal data and invoice data from external systems into GL and Payables tables, creation of custom interface tables, creation of Control files for loading data from flat files into custom interface tables, creation of PL/SQL procedures for Conversion of the data from legacy/external systems and performing validation/enrichment of the data and creation of PL/SQL procedures for loading the data from the custom interface tables to GL INTERFACE and Payables Open Interface tables.
• Design and develop implementation of Cash Management module Interfacing
• for loading of Bank Statements, creation of scripts for loading the bank statements into Bank Statement Open Interface tables, creation of PL/SQL procedures to perform conversion of data/enrichment of the data and perform unit tests for loading bank statements in Cash Management tables.
• Prepared Design Specification document and Designed and developed various
• labels in Loftware. Developed PL/SQL procedures and Concurrent Programs in ERP for creating XML files containing the data to be sent to Loftware for printing the labels.
• Design and develop several customized reports such as Shipping Manifest,
• Summary Shipping Manifest, Bill of Lading, Summary Bill of Lading, WIP Pick Slip, Structured Costed BOM report, Costed BOM comparison report, Quantity on-hand report, Account Distribution report etc using Oracle Reports 6i. Design and develop various SQL PLUS reports in 11.5.8/11.5.10 such Quantity on-hand report which lists on-hand inventory with both LPN and Serial Number details, SMD Account Distribution report which captures inventory and WIP transaction details.
• Created custom Concurrent Programs and Executables, Unix Shell Scripts for executing PL/SQL procedures, moving of files etc.
• Design and develop a few custom forms using Oracle Forms Developer 6i based
• on the business requirement.
• Prepare Test Plans and perform Unit Tests/Component Integration Tests.
• Provide support for Systems Analysis/ User Acceptance Tests and provide post-deployment support for the above processes.

Oracle Application

• Was a key member of the development team for upgrading Oracle Projects from 10.7 to 11.03. The responsibilities included the following:
• Designing and developing the process for upgrading Project Accounting data, creation/conversion of projects using the Oracle Projects Activity Management Gateway APIs and conversion of Transaction data in respect of active projects.

Systems Analyst

• Designed and developed Forms and Reports for developing a system for Human Resources Development. Work involved designing forms and reports and creation of PL/SQL procedures.
• Sep 1997 - Apr 2000: Systems Analyst - Agri Development Finance Tamil Nadu Ltd., Chennai, India
• Designed and developed the system for computerization and maintenance of data relating to sanction and disbursement of loan to customers for hi-tech agro projects using Oracle 7.3 and Forms 4.5 in Windows environment.