PROFESSIONAL SUMMARY

• 8 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 effective business knowledge transition to the application development teams.
• Experienced in Implementation, Up-gradation, Conversion and Production Support of Oracle Application 12i and 11i.
• Involved in Full Life cycle Implementations, Roll Outs, 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

PROFESSIONAL EXPERIENCE

Confidential

Role: SCM Functional Lead R12 Support

Confidential operates three pharmaceutical companies in Confidential, dedicated to creating and promoting new products and innovative solutions for better health worldwide. This company focuses on four specialty areas: neuroscience, oncology, cardio-renal, and medical devices. My role is of SCM Functional Lead for Oracle EBS R12 Migration/Enhancement/Implementation Order Management, Inventory, Purchasing, iSupplier and Accounts Payable.

Role 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 MD050 and BR100 in SCM instance based on the new solution going forward.
• Participate in Integration, Regression and User acceptance testing cycles.
• 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.
• 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, iSupplier, 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

Role: SCM Functional Lead

Confidential creates innovative products storage systems and software that help customers around the world store, manage, protect, and retain one of their most precious corporate assets: their data. Confidential is recognized throughout the industry for continually pushing the limits of today's technology so that customers never have to choose between saving money and acquiring the capabilities they need to be successful. In project Everest QE, my role was of Business Analyst and Functional consultant for Oracle EBS 11i to R12 Migration/Enhancement/Implementation Order Management, Inventory, Purchasing

Role 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

Role: SCM Functional Lead

My role was of Lead Functional consultant for SCM modules responsible for onsite and offshore objects delivery and user client interaction on CEMLI and RICE requirements, definitions, design and solution. Following are the highlighted activities:

Role 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 NCR 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

Role: Functional Consultant

My role was of Functional consultant for SCM and Finance modules responsible for supporting the metalink TAR created by the users across the Globe. Following are the highlighted activities:

Role 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.
• Inventory issues.
• Order stuck and Sourcing Rule/ASL Issues.
• Accounting issues
• Most of the time involved in resolving business critical issues like :
• 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.
• Diagnosed and resolved issues in Order Management using tools such as OM debug files, log files, trace and tkprof.
• As a Functional consultant, resolved business critical issues P1 in Order Management and Shipping that occurred due to custom code changes.
• Troubleshoot and analyze issues, perform root cause analysis, identify bugs / enhancements and proactively monitor system.
• 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.

Additional Responsibilities:

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

Role: Techno-Functional Consultant

My role was of a SCM Functional consultant responsible for client interaction on definition, design and solution. Following are the highlighted activities:

Role 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

Role: Techno-Functional Consultant

My role was of Order-To-Cash techno-functional consultant responsible for requirements definition, identification of business process scenarios, gap analysis, configuration, creation of test scripts, CRP and UAT testing and implementation of 11.5.10

Role 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 i.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.