SUMMARY

• With around Total 7+ of experience out of which 5+ Years as Functional consultant in E - Business Oracle Applications 11i/R12 SCM in Implementation, Production Support, Enhancement and Testing
• Having 5 years of Experience in Functional expertise in Oracle Purchasing, Inventory and Order Management modules.
• Expertise in Oracle distribution modules having excellent functional experience in enhancement, testing, production support, customization, user, analyzing business requirement.
• Having very good functional hands on experience in purchasing & inventory functional setup based on business requirement in the distribution modules.
• Domain expertise in ERP in Oracle Application with having very good working knowledge in functional as well as technical in purchasing as well as inventory setups.
• Capable of working independently and as well as a part of a team.
• Ability & highly keen on to learn grasp and deliver both individual and also as proactive team member.
• Functional feasibility study of new business opportunity interacts with end customer on functional issues and resolves the issues as per priority.
• Preparing the detail process flow for functional requirement.
• Preparing test plan and relative test scripts.
• Interact with customer on feasibility outcome issues.
• Good presentation, Communication and Analytical Skills.
• Very good knowledge in R12 SCM module.
• Involved actively on weekend drives for taking interviews in the interview panel.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications11i (11.5.9, 11.5.10.2), R12 (12.1.3)

RDBMS: ORACLE 8.x, 9.x,10g Enterprise Edition

Reporting Tools: Developer 2000(6i&10g),XML Publisher

Utilities Tools: TOAD, SQL *Plus, Data Loader

Operating System: Windows NT 4.0/95/98/2000 DBMS Packages Oracle 9i/10g,Oracle Reports

Programming Languages: SQL, PL/SQL, XML

PROFESSIONAL EXPERIENCE

SCM functional consultant

Confidential

Responsibilities:

• Client interaction for gathering requirement and analysis.
• Mapping business requirement and control undertaking quick gap analysis.
• Coordinating with the development team for development and customization of software.
• Providing all kinds of production support for application and software.
• Providing end user for the change process and help them to solve their issue.
• Providing to the user on P2P process.
• Involve in various testing.
• Worked on PO, INV, and OM module.
• Worked with Oracle to getting support on Oracle Standard components(Raised SR,attend SR call)
• Perform the action plan given by the SR generated by debug file, trace file etc.
• User acceptance testing and extending post go live support. Including traing support to end user.
• Handling different kinds of PO, INV, OM related cases.
• Coordinate with third party team and fix the issue.
• Handling weekly status meeting.
• Involve in month end closing to drive successfully month end close.
• Configuring Key and descriptive flex field in raw instance.
• Defining UOM.
• Defining different sub inventories.
• Handling different inventory transactions.
• Min Max inventory planning.
• Basic setup.
• Suggesting document type according to the Business requirement.
• Various types of purchasing document.
• Sourcing Rules and automatic document sourcing.
• Setup purchasing, financial receiving and receiving controls.
• Approval hierarchy setup etc.
• Basic OM Setup.
• Defining different order transaction types.
• Defining price list.
• Defining Transactions types.
• Handling different sales order issue.

Confidential

Environment: Oracle Applications 11i,Data Loader

Functional Consultant

Responsibilities:

• Closely interacting with onsite team and users deriving delivery dates of components and deriving team in a direction to achieve the same deadlines and conducting technical review and code walk through.
• Functional support for Oracle purchasing, Inventory, Order management related issue.
• Handling user issues in Oracle Purchasing, Oracle Inventory.
• Creating of users, set the profile Option, Responsibility Assignments, Month end responsibility assignments, Reset the user id and passwords registering the concurrent programs run the diagonists for TAR management etc.
• Setup Operating units and inventory organizations.
• Set up purchasing option, receiving option, financial option, approval hierarchy and different document types approval groups and approval assignment.
• Providing access to users based on there hierarchy based on there department roles.
• Analysis of PO and receipt stuck in the approval process or workflow.
• Interact with user about there Pos, receipts and invoices which are in process or waiting for approval.
• Involved in various testing, Unit testing & integration testing after fixing the issue and while moving the customization and extensions of components to move to production smoothly.
• Worked with Oracle for getting support for standard oracle standard issue which handle through SR and SR calls.
• Working as offshore team member closely with onsite team and client.
• Production support activity including analysis of the issues and providing with the solutions.
• Discussed with Users to gather requirements/Changes.
• Involve in Month end closing activity.
• Prepare weekly status report and update to the Instance manager.
• Identifying the RCA for long pending issues and drive the case to closure.
• Responsible for regression testing.
• Working closely with Oracle,DBA and 3rd party teams for regular Patch Applications, Outages, data fix, code fix.
• Scheduling of several scheduled requests/Program.
• Involved in Performance testing for Order to cash life cycle and Procure to Pay Life Created Test scripts.
• Defining or Modifying Responsibilities, Request Groups, Reports, Concurrent Requests, Request Sets and Procedures as per the Issue/Ticket.

Confidential

Environment: Oracle Applications 11i,Data Loader

Functional Consultant

Responsibilities:

• Customization of form based upon client.
• Involved in the business requirement gathering for oracle purchasing, inventory, order management and iprocurement from the client.
• Understanding the existing business process and designing the future process and standard oracle functionality.Documenting the business process as finalized with client.
• Setting up the application module with profile option, value sets, flexfield and other parameter as per clients requirement.
• Implementing:
• Approval heirarchy for approval and funds check of purchase order.
• Standard Purchase Order, Blanket Purchase Order,RFQ and Quotation.
• Internal sales order in Order Management.
• Move Order according to the Planner approval in oracle inventory.
• Iprocurement setup.
• Preparing MD-50 according to functional requirement.
• Preparing BR-100 document.
• Documenting the gap analysis document between the legacy system and oracle application.
• Preparing TE-40 which cover the total testing phase based upon functional requirement.
• Configuring Oracle application in PO, Inventory and Order Management Modules in the test and development and prepared walk through setup documents.
• Identifying report requirements documents to guide technical team in developing reports, interfaces and forms.

Confidential

Environment: Oracle Applications 11i,blisherTOAD, Oracle10G

Senior Test Lead(SCM)

Responsibilities:

• Handling the system testing of Oracle 11.5.10 in Oracle Purchasing, Oracle Inventory and Order management modules.
• Hands on experience of functional decomposition, test case writing, execution, defect logging and defect tracking.
• Involved in reviewing of test case scenarios.
• Experience in creation of test plans and test specifications, complying with the quality standards for automated and manual software testing and also involved in emergency releases.
• Experience in carrying out Functional Testing, System Testing and regression testing across various projects.
• Experience a team building, handling clients, queries and providing effect response to the client queries.
• Writing a test script in PO, INV and OM module according to the requirements given in URS.
• Collecting requirements such a Test data, Test environment and other setup requirement for the revision of design steps and respective functional track leads.
• Download the user requirement specification from ‘My Work shop’ and analyse the requirement based on the extension specified SIT Matrix.
• Download the design steps from the quality center, then revise the design steps and map the gap between the business requirements present in the URS and the design steps.
• After the design steps are revised it is sent for approval from the functional owners and get it approved by the validation manager so that it can be uploaded in quality center.
• Mapping the test scripts according to the requirement traceability matrix and system integration testing matrix.

Confidential

Environment: Oracle Applications 11i, XML PublisherTOAD, Oracle10G, PL/SQL, Oracle Reports, Discoverer, WinSCP.

Technical Consultant

Responsibilities:

• Closely interacting with onsite team and users deriving delivery dates of components and deriving team in a direction to achieve the same deadlines and conducting technical review and code walk through.
• Functional & Technical support for Oracle purchasing and order management related issue.
• Setup Operating units and inventory organizations.
• Set up purchasing option, receiving option, financial option, approval hierarchy and different document types approval groups and approval assignment.
• Providing access to users based on there hierarchy based on there department roles.
• Analysis of PO and receipt stuck in the approval process or workflow.
• Interact with user about there Pos, receipts and invoices which are in process or waiting for approval.
• Involved in various testing, Unit testing & integration testing after fixing the issue and while moving the customization and extensions of components to move to production smoothly.
• Worked with Oracle for getting support for standard oracle standard issue which handle through SR and SR calls.
• Working as offshore team member closely with onsite team and client.
• Production support activity including analysis of the issues and providing with the solutions.
• Discussed with Users to gather requirements/Changes.

Confidential

Environment: Oracle Applications 11i, XML PublisherTOAD, Oracle9i, PL/SQL, Oracle Reports.

Technical Consultant

Responsibilities:

• As a team member responsible for customization of modules PO and OM with following contributions.
• Successfully deliver enhancement request of the client
• Analysis providing with custom solutions for any specialized requirement.
• Involved in minor and major up gradation of SQL Reports.
• Responsible for customized development of manufacturing and inventory Modules.
• Developed technical document for process improvement.
• Responsible for unit testing.
• Production Support Activities including analysis of issues reports and providing with solutions.
• Coordination with ORACLE Support Services in getting patches/fixes.
• Preparation of document for weekly status call and monthly status call.
• Preparation of Technical Document MD200.