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

TECHNICAL SKILLS:

Oracle Application/E-Business suite: Release 12.1.3, 11.5.10, 11.5.8

Design Tools: Oracle SQL Developer, SQL Navigator, Toad, Oracle Reports, Oracle Forms, Oracle BI Publisher, Workflow Builder, Loftware Label Designing.

PROFESSIONAL EXPERIENCE:

Technical Consultant

Confidential, Attleboro, MA

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.

Senior Techno Functional Team Lead

Confidential

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.

Senior Techno Functional Team Lead

Confidential, NCR, Atlanta.

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/ Functional Analyst

Confidential

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

Confidential

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

Techno-Functional Analyst

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

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

Systems Analyst

Confidential

Responsibilities:

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