We provide IT Staff Augmentation Services!

Functional Consultant Resume

Sunnywale, CA

SUMMARY

  • Around 7.6 years of IT experience with Oracle e - Business Suite (EBS) 12i and 11i experience.
  • 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 AP, OM, PO, INV and Spares management (CSP).
  • Used Oracle AIM (Application Implementation Methodology) and other custom methodologies for Implementation and Up-gradations.
  • 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.
  • Extensive experience with PA Costing and Billing (R12),
  • 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.
  • Developing 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 Software Development Life Cycle (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)

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, Sunnywale, CA

Functional Consultant

Responsibilities:

  • Design of various MD050 for the suggested solution related to OM module.
  • Developed and functionally tested 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.
  • Managing and performed the 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.
  • Participated in Integration, Regression and User acceptance testing cycles.
  • Input and developed 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.
  • Coordinated 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, resolved business critical issues (P1) in Order Management and Shipping that occurred due to releases.
  • 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.

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

Confidential - Atlanta, GA

Functional Consultant

Responsibilities:

  • Managed and coordinated the resolution of TARS during the implementation.
  • Preparing 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 Purcha sing
  • 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, AOL, System Administrator, PL/SQL, TOAD, PL/SQL Developer and Workflow Builder.

Confidential, Redwood City, CA

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.
  • Troubleshooting and analyzing issues, performing root cause analysis, identifying bugs / enhancements and proactive system monitoring.
  • 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 stucked 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 that were occurring for multiple customers and fixed the BUG considering the fact that the issue will never occur in future (Regression Testing).
  • Worked 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
  • Involved in 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, Redwood City, CA

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, 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.
  • Interacting 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 Upgradation 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.

Hire Now