SUMMARY

• 8.5 years of IT experience with Oracle e - Business Suite (EBS) R12 and 11i.
• Instrumental in large engagements and involved in Business user interactions, Business Process Requirement (BR100), Functional (MD50), Conversion (CV40) and Installation (MD120) specification documentation with TEMPeffective business noledge transition to the application development teams.
• Experienced in Implementation, Up-gradation, Conversion and Production Support of Oracle Application R12 and 11i.
• Involved in Full Life cycle Implementations, Upgrades, GAP analysis, Production Support, Testing, Data Migration from legacy system to Oracle Order to Cash Cycles.
• Lead the offshore team and work with onsite/offshore development team to provide quality deliverables.
• Strong Production Support experience in Order-to-Cash and Procure-to-Pay Processes.
• Involved in the Operational and Non-Operational Setup of OM, PO, INV, BOM, AP and Spares management (CSP).
• Used Oracle AIM (Application Implementation Methodology) and other custom methodologies for implementation and upgrade.
• Extensive experience in understanding and gathering the client requirements, translating them into various process alternatives, mapping into feasible solutions in Oracle Applications, managing functional setups related to Oracle applications.
• Experience in Unit, Smoke, Integration, System, Performance, and User Acceptance testing the system.
• Worked on various assignments that dealt with operations, quality assurance, Production Implementation, Support and maintenance using various QA methodologies.
• Developed the Solution Design that includes standard oracle functionality and extensions/customizations as needed, resolving issues, providing production support, patching and system upgrades and maintenance.
• Expertise in various stages of SDLC - gathering & analyzing the requirements, converting specifications into functional & technical design documents, code development, quality assurance and product documentation.
• Experience with Oracle Production Support for P1 and P2 severity TAR (SR) on production issues and providing all details on Production issues and patches.

TECHNICAL SKILLS

ERP Systems: Oracle Applications 12.1.3/12.0.4/12.0.6 / 11.5.10.2 / 11.5.9 / 11.03

AOL Functions: Oracle Workflow, AOL and SYSADMIN

Oracle EBS Modules: Order Management (OM) Oracle Payables(AP) Shipping(WSH) Purchasing (PO) Order Inventory (INV) Oracle Spares Management (CSP) Bill Of Materials (BOM)

Operating Systems: Windows XP, Windows NT/2000

Languages: SQL, PL/SQL

Databases: Oracle 11g /10g/ 9i

Tools: /Utilities: TOAD, PL/SQL Developer, SQL*Loader, SQL*Plus

Development Tools: Oracle Forms 10g / 6i, Reports 10g / 6i, Oracle Workflow Builder

PROFESSIONAL EXPERIENCE

Confidential, MD

SCM Functional Lead

Responsibilities:

• Design of various MD050 for the suggested solution related to OM, PO, BOM and INV module.
• Creation of New Inventory Orgs and implementing the new BOM items as developed by Otsuka in Oracle.
• Provide solutions to the end user and educate them in Oracle end-to-end processes.
• Develop and functionally test TE40 based on the different business scenarios and maintain the same in Quality Center repository.
• Full involvement in day-to-day activities of system and Support users by solving their problems related to day-to-day Activities.
• Design and develop MD050 and BR100 in SCM instance based on the new solution going forward.
• Participate in Integration, Regression and User acceptance testing cycles.
• Responsible for designing & documenting the functional specifications for various customizations and extensions as part of the business process gap analysis.
• Coordinate with Oracle support on TAR's, bugs resolution & testing application functionality for new patches.
• Troubleshoot and analyze issues, perform root cause analysis, identify bugs / enhancements and proactive system monitoring.
• As a Functional consultant, resolve business critical issues (P1) in Order Management, INV, PO, BOM, Shipping that occur due to releases.
• Diagnose and resolve issues in Order Management using tools such as OM debug files, log files, trace and tkprof.
• Support all user issues for the day to day business relating to Oracle Apps R12 modules OM, Shipping, AR, AP, GL, Inventory, Oracle Reports with Customizations and Workflows( Oracle, Business specific and customized). Data fixes or program modifications done to fix user issues.

Environment: Oracle Applications (12.1.3) OM, INV, PO, BOM, AOL, System Administrator, PL/SQL, TOAD, PL/SQL Developer.

Confidential

SCM Functional Lead

Responsibilities:

• Design of various MD050 for the suggested solution related to OM module.
• Develop and functionally test TE40 based on the different business scenarios and maintain the same in Quality Center repository.
• Full involvement with system and support users by solving their problems related to day-to-day Activities.
• Manage and perform end to end testing in case of enhancement or new development.
• Design MD050 and BR100 in SCM instance based on the new solution going forward.
• Participate in Integration, Regression and User acceptance testing cycles.
• Input and develop BR100 setup document for the OM and INV Components
• Responsible for designing & documenting the functional specifications for various customizations and extensions as part of the business process gap analysis.
• Coordinate with Oracle support on TAR's, bugs resolution & testing application functionality for new patches.
• Troubleshooting and analyzing issues, performing root cause analysis, identifying bugs / enhancements and proactive system monitoring.
• As a Functional consultant, resolve business critical issues (P1) in Order Management and Shipping that occur due to releases.
• Diagnose and resolve issues in Order Management using tools such as OM debug files, log files, trace and tkprof.
• Support all user issues for the day to day business relating to Oracle Apps 11i modules OM, Shipping, AR, AP, GL, Inventory, Oracle Reports with Customizations and Workflows( Oracle, Business specific and customized). Data fixes or program modifications done to fix user issues.

Environment: Oracle Applications (12.1.3) OM, INV, PO, BOM, AOL, System Administrator, PL/SQL, TOAD, PL/SQL Developer.

Confidential

SCM Functional Lead

Responsibilities:

• Managed and coordinated the resolution of TARS during the implementation.
• Prepared functional (MD050) and implementation (MD120) specifications; provide recommendations to implement process and system modifications.
• Responsible for creating custom menus and responsibilities for super users and user communities.
• Prepared Business setup documents and process mapping documents.
• Worked on the Customizations in the OM, INV and Purchasing
• Preparation of Test Scripts and participation in the CRPs, System Integration and UAT.
• Created TAR (SR) on pre-go live issues and worked with Oracle Production Support for P1 and P2 on Client Production issues and patches.
• Weekly reporting with management for activities involved with offshore team.
• Independently handle the deployment and support activities on Finance and SCM modules.
• Conducted entire P2P and O2C cycle training for Confidential employees.
• Performed the Operational and non-operational setups for different countries in UAT and Production Environment.
• Performed setups for OM, PO, INV, CSP, AP, AR and GL and also prepared questionnaires for APAC and EMEA countries.

Environment: Oracle Applications (12.0.6) OM, INV, PO, BOM, AOL, System Administrator, PL/SQL, TOAD, PL/SQL Developer and Workflow Builder.

Confidential

Functional Consultant

Responsibilities:

• Worked as Support Analyst for Clients in Oracle Financials and SCM modules OM, PO, INV and AP.
• Resolved nearly 500 Service requests over a period of 19 months.
• Designed and tested various test business case scenarios for OM and Shipping.
• Creation of configuration documents to be used as a reference for the client.
• Troubleshoot and analyze issues, perform root cause analysis, identify bugs / enhancements and proactively monitor system.
• As a Functional consultant, resolved business critical issues (P1) in Order Management and Shipping that occurred due to custom code changes.
• Diagnosed and resolved issues in Order Management using tools such as OM debug files, log files, trace and tkprof.
• Supported all user issues for the day to day business relating to Oracle Apps 11i modules OM, Shipping, AR, AP, GL, Inventory, Oracle Reports with Customizations and Workflows( Oracle, Business specific and customized). Data fixes or program modifications done to fix user issues.
• Most of the time involved in resolving business critical issues like:
• Accounting issues
• Order stuck and Sourcing Rule/ASL Issues.
• Inventory issues.
• Trial Balance issues
• Integration issues between Purchasing and AP (matching issues)
• Payables open interface issues
• Data Corruption
• Patch Impact Analysis
• Root cause analysis
• Order to Cash Issue.
• Involved in root cause analysis for the issues and Regression Testing.
• Work on business critical issues that affect the go-live year-end period closing issues
• Handling escalated issues and resolving the same
• Helping team members on long pending service requests
• Verifying the data fixes
• Mentoring and recruitment for new resources.
• Conducting and coordinating Interviews to select correct candidate for the Organization
• Took around 100+ interviews for dis project
• Conducted extensive training sessions for New Hires.
• Prepared the Support document which is still being followed in Oracle to guide the fresher.

Environment: Oracle Applications (11.5.10/11.5.10.2 /12.0.4/12.0.6/12.1.3 ) AP, PO, OM, WSH, INV, AOL, System Administrator, PL/SQL, TOAD, PL/SQL Developer, Oracle Workflow Builder.

Confidential

Techno-Functional Consultant

Responsibilities:

• Author of functional (MD50) specifications.
• Creation of configuration documents to be used as a reference for the client.
• Perform testing of applications with a view to modified set-up.
• Created TAR on some issues and worked with Oracle Support.
• Involved in writing the test case document, design document and Installation document by using AIM templates.

Environment: Oracle Applications (11.5.8/11.5.9/11.5.10/11.5.10.2/12.0.4/12.0.6 ), INV, PO, OM, BOM, AOL, PL/SQL, TOAD, Forms 6i, Reports 6i.

Confidential

Techno-Functional Consultant

Responsibilities:

• Captured the business processes in form of scenario matrix for testing various process alternatives followed as part of order management/shipping.
• Interact directly with customer and gathering the requirements
• Project Estimation, Planning, Tracking and Reporting
• Responsible for designing & documenting the Functional and Technical specifications for various customizations as part of the business process gap analysis.
• Coordinated SIT, UAT, Go-Live and provided initial post go-live support
• Involved in AIM documentation me.e. CV060, MD070 and Unit Test Plans for the developed objects.
• Analyzed and documented current business processes for Order to Cash (OTC cycle) for existing plants on OM/Shipping implementation.
• Write functional (MD50) specifications; provide recommendations to implement process and system modifications.
• Unit tested various business case scenarios related to Inventory, Order Management and Shipping.
• Worked on Upgrade of standard Oracle reports like Purchase Price Variance, Open Purchase Orders and Requisition Detail Report in PO, Invoice on Hold report, and Trial Balance - Detail Report in GL.
• Creation of configuration documents to be used as a reference for the client
• Preparation of Test Scripts and participation in the CRPs and UAT.
• Upgrade test scripts writing and completed unit testing, System and Integration testing to successfully deliver the Final system.

Environment: Oracle Applications (11.5.10/11.5.10.2 ) PO, OM, WSH, INV, AOL, PL/SQL, SQL*Loader, TOAD, Forms 6i, Reports 6i.