SUMMARY

• 12 years of experience in IT as Functional Consultant, Analyst /Team Lead mainly in the areas of Supply Chain Management (SCM) - Oracle Order Management(OM),Oracle Advanced Pricing(QP),Account Receivables (AR),Oracle Purchasing(PO),Oracle Inventory (INV),Account Payables(AP).
• Good exposure to AIM methodology, extensive exposure in preparing MD50, MD70.
• Knowledge of business processes across the E- Business Suites, Order to Cash (O2C), and Procure to Pay (P2P).
• Experience of working as a Functional Consultant OM (Order Management), Oracle Advanced Pricing (QP).
• Diversified experience in all phases of software development life cycle.
• Proven Expertise in business process mapping, analysis, design and configuration, customization & workarounds, functional issue resolution, System Integration and Acceptance Testing as a part of Implementation& Upgradation
• Ability to handle full life cycle implementation going through Analysis, Design, Conference Room Pilot (CRP), User Acceptance Test (UAT), User training, Go-live and Post Production support.

PROFESSIONAL EXPERIENCE:-

Confidential, Pittsburgh, PA

Oracle Apps Functional Consultant.

Responsibilities:

• Worked as an Oracle Applications Functional Consultant; responsibilities included writing FDD (Functional Design Document) for detailed business requirements.
• Worked very closely with Business users and stakeholders extensively on day to day basis in collecting business requirements to prepare Design Documents. Also involved in integrated testing and UAT.
• Involved in doing system setups for Oracle Advanced Pricing (QP) and Order Management Modules (OM). Also involved in maintaining setup document (AP322) for these modules.
• Also involved in Analysis and Design of IR-ISO (Internal Requisition/Internal Sales Order) Processes.
• Also involved in Analysis and Design of Intercompany Invoices Process.
• Performed pricing Setups for Internal Purchase Requisition/Internal Sales order and Inter- Confidential Relationships, Shipping network.
• Also involved in trouble shooting various post production issues in full Order to Cash cycle.
• Also involved in setup of various Advanced pricing entity (Price Lists, Modifiers, Formulas, Attributes Management), Order Management Setups in various testing cycles.
• Also involved in performing requirement gathering, fit/gap analysis, functional specification design, unit and integration testing, data conversion, documentation, user training, production and post production support activity.
• Extensively involved in Unit Testing, System Integration Testing, end to end Functional Testing, User Acceptance Testing, Regression Testing, preparing Test cases, documenting Test Scripts.
• Experience in preparing Configuration documents, Process Mapping documents, user guides, write ups for communications to user.
• Also involved in End-to-End implementation of Order to Cash cycle.

Confidential, North Carolina

Oracle Apps Functional Consultant.

Responsibilities:

• Worked as an Oracle Applications Functional Consultant; responsibilities included writing
• Functional Design Document for detailed business requirements.
• Analyzed the various Pricing business scenarios to understand the pricing & discounting requirement of the client.
• Implemented various pricing & discounting measures based on product hierarchy & pricing attributes.
• Defined various price lists, pricing contexts, attributes & attribute values to meet the business requirement of the customer.
• Analyzed user requirements to 12.0.6 functionalities & mappings within order management, purchasing & advanced pricing modules.
• Also involved in coordinating onsite and off-site team for issue resolutions and query.
• Worked as a Team-lead, which includes providing technical/Functional solutions for business requirements and assigning works to team mates.
• Involved in writing BULK Import of Price Lists interface, Also involved in setting up formula.
• Extensive Experience of working on Reports, Interfaces on Oracle Order Management (OM) modules.
• Also Analyze/developed custom List Price Catalog (LPC) application which is used for Publication of Price lists in Advanced Pricing.
• Extensive experience of Oracle Advanced Pricing (QP) setups like Setting up Context, Attribute Linking and Mapping, Modifier Setups, Qualifier Setups. Also involved in Pricing Formula setups.
• Experience of working on Price modifications and Rules in Advanced Pricing (QP).
• Experience of customizing QP CUSTOM in Advanced Pricing.

Confidential, Atlanta-GA

Oracle Apps Functional consultant.

Responsibilities:

• Worked as an Oracle Applications functional Consultant; responsibilities included Key in Preparing the Functional Specification Documents (FSD), Business Requirement Documents (BRD) and Functional Testing Documents.
• Responsible for creating, Internal Sales Order and complete Order Cycle setups from order entry to ship confirm to support business requirements.
• Involved in Analysis and Design of Sales Order Interface in Order Management (OM).
• Also involved in customization of Autoinvoice program in Receivables.
• Involved in map and gap analysis of upgrading 11.5.8 to Oracle R12.
• Worked on Return Material Authorization (RMA) Process in Order Management Application.
• Responsible for creating, Internal Purchase Requisition/ Sales Order and complete Order Cycle setups from order entry to ship confirm to support business requirements
• Involved in Co-ordination between the Client, Onsite Team and the offshore team

Confidential

Oracle Apps Techno Functional consultant.

Responsibilities:

• Worked as an Oracle Applications Techno functional Consultant; responsibilities included writing technical specifications for the functional requirements, responsible for developing/testing/ and implementing the technical requirements using Oracle Applications (11.5.10) tools. These tools include PL/SQL, SQL, Forms, Reports, Interfaces, and AOL.
• Responsible for the quality of technical analysis, design, and development of all customer upload interface.
• Worked with the onsite people and other functional team members on getting requirements, creating fit gaps and ensuring that the business provided enough information for a good design.
• Responsible for writing test plans and executed them for the developed code.
• Responsible for the customization of customer upload interface which included writing technical specifications, mapping of all the interface tables’ fields with the legacy system, and writing PL/SQL code to populate interface tables.
• Worked on Oracle Trading Community Architecture (TCA) API to upload customers.
• Worked on FND Load utility to migrate AOL objects.
• Responsible for developing custom report in General Ledger (GL) for Carlson Corporation. Also responsible for writing Control M scripts for scheduling concurrent programs.
• Responsible for writing and executing Test Cases in Mercury’s Test Director.
• Designed and developed custom package for creating OPM Formula. GMD FORMULA PUB, GMD STATUS PUB API were used for creating OPM formula.
• Designed and developed custom enhancements in Invoice on Hold (AP) seeded report.
• Designed and developed custom PL/SQL code to fill the gaps of FA Mass addition CER tracking number.
• Designed and developed a conversion program, custom PL/SQL code to import open sales orders from the Legacy system into Order Management using Order Import.
• Designed and developed custom enhancements in Pick Slip seeded report.
• Involved in the study of the existing system, prepared the functional (MD50), technical (MD70) design document and conversion mapping document (CV40) to extract data from two Oracle Application instances of RICOH.
• Designed and developed the custom form for maintaining and publishing unusual demands for RICOH international.
• Developed conversion programs, staged tables and customized PL/SQL API and interfaced for BOM Import and Open Sales Order Import.
• Also responsible for development of Requisition Import (REQIMPORT) interface in Oracle Purchasing.
• Experience of working on Multi Org/MRC (Multi Reporting Currency) reports for Carlson Corporation. Developed General Ledger (GL) reports using MRC.
• Worked on OM (Order Management) cycle, Experience of creating full Order cycle.
• Successfully Implemented P2P (Procure to Pay) cycle with all the setups.
• Extensive experience of configuring SQL queries in TOAD.
• Experience of analyzing PL/SQL code in Oracle Purchasing and Oracle Inventory schemas.

Confidential

Oracle Apps Technical Consultant.

Responsibilities:

• Worked as a Technical Consultant for building interfaces; wrote database packages, and customized reports of Oracle inventory/PO/WIP/MRP.
• Responsible for the customization of forms and PL/SQL.
• Responsible for the customization of the following interfaces:
• Open Item Interface. Item Categories Interface. Purchase Document Open Interface (PDOI) Requisition Import (REQIMPORT) Scheduled group Update interface in WIP. BOM Upload.
• Responsible for customization as well as new development of reports. Gained experience in OAI (Oracle Application Interconnect) tool which was used as a kind of Middleware software between Legacy system and Oracle Application.
• Responsible for the registration of custom concurrent programs for the developed components as well as value set definitions and registration of form, function, and menu.
• Worked on Forms customization and Report customization.
• Handled a separate module, which was bolted-on to Oracle Applications.
• Worked on Chainlink as well as post implementation support activity.
• Worked on Remedy as a supporting tool and Appworx as a scheduling tool.
• Involved in interacting with onsite functional people regarding queries.
• Involved in the exposure of Oracle XML Publisher reporting tool.
• Involved in giving technical solutions to client for certain requirements.
• Responsible for the customization of Oracle Alerts.
• Responsible for giving support in the UAT (Users Acceptance Testing) phase.

Confidential

Oracle Apps Technical Consultant.

Responsibilities:

• Responsible for gathering the requirements for a change and successfully implemented those requirements.
• Responsible for complex validation of forms and reports.
• Responsible for the kind of outbound interface and sent e-mails through UNIX.
• Responsible for writing PL/SQL code for the requirements.
• Designed, developed, and implemented various customizations for Oracle Manufacturing modules like BOM, MRP, Order Entry, Purchasing, and Costing.
• Involved in giving technical solutions over the requirements.
• Interacted with the functional people to know the business process.

Confidential

Team Lead

Responsibilities:

• Responsible for understanding old form logic and designed that form in Forms 6i; also understood the old code and converted that code to PL/SQL. Created the form library for validation and reuse.
• Responsible for understanding the old report logic and converted that report into Reports 6i, and designed the layout and code.
• Responsible for writing test plans for the converted code and checked that functionality was as per the old system.
• Wrote complex and reusable logic in database package and procedures.

Confidential

Techno Functional Consultant

Responsibilities:

• Responsible for handling 5 to 8-member teams.
• Involved in database design for the complete project; designed the system and explained to the team members.
• Used PL/SQL extensively for coding and writing complex database triggers, stored procedures, and packages.
• Involved in creating users, roles, and profiles and granted and revoked the privileges to the users.
• SQL*Loader was used for data loading; the old data was loaded in temporary tables and then transferred to new tables by using insert scripts (Anonymous PL/SQL blocks).
• Extensive testing was done on the programs for achieving accuracy and timely processing of data.
• Wrote test cases for forms and reports.
• Involved in designing the screens and reports. Coded many important forms (screens) such as Group type, Subgroup type etc., Master forms and assets register, depreciation schedule, opening depreciation calculation, deletion of assets etc., and transaction forms using Oracle Forms 6i.
• Involved in the creation of all the menus in this application.
• Developed many important reports such as Fixed Assets Schedule, Asset Card Printing etc. using Oracle Reports 6i.
• Involved in discussions with the clients regarding the screen appearance and their new requirements, complaints, suggestions etc.
• Involved in the development of property classes, PL/SQL libraries etc

TECHNICAL SKILLS

ERP: Oracle Applications 10.7/11.0.3/11.5.9 & 11.5.10,R12 SCM(INV,PO,Order Management(OM),Advanced Pricing(QP),Accounts Receivables(AR))Tools: SQL Plus, SQL Loader, Oracle Developer (Forms 6I, Reports 6I)

Languages: JAVA 2, C, C++, JAVA, SQL, and PL/SQL.

RDBMS: Oracle 7.3/8 and Oracle 8i (8.1.6/8.1.7).

OS: MS Windows, HP UNIX, and Windows NT.