SUMMARY

• 7+ years of IT experience with Oracle e - Business Suite (EBS) R12 and 11i.
• Proficient in system implementation including gathering business requirements, process mapping, GAP analysis, solution design, building RICE (Report, Interface, Extension) components, configuration, setups, user training. Developed business scenarios and rules and functional specifications, test scenarios and other project deliverables.
• 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.
• Proficient in functional aspects of Oracle Modules such as General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CE), Inventory (INV), Purchase Order (PO), Sys Admin, iExpenses and iProcurement.
• Experienced in Implementation, Up-gradation, Conversion and Production Support of Oracle Application 12i and 11i.
• Lead the offshore team and worked with onsite/offshore development team to provide quality deliverables.
• Expertise in end-to-end business flows like ‘Order to Cash’ and ‘Procure to Pay’.
• 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.
• Excellent problem solving, communication, analytical and interpersonal skills.
• Team contributor with strong analytical, problem solving, interpersonal, leadership and client-facing skills.
• Supporting and solving day to day end Users problems and Performing Week/Month end Reconciliation’s between GL to Sub-Ledgers.
• Strong communication & leadership skills with an ability to interact with business users and lead business projects.
• Create and maintain user manuals and provide multiple user training sessions for large group of users.

TECHNICAL SKILLS

ERP Systems: Oracle R12 (12.1.3, 12.0.4, & 12.0.6) and Oracle 11i (11.5.9 & 11.03)

EBS Modules: General Ledger, Oracle Payables, Oracle Receivables, Purchasing, Inventory, iProcurement, iExpense, Order Management, Advanced Pricing, Oracle Human Resources, Cash Management, Order Entry, Advanced Supply Chain Planning, System Administration, FSG reports, and Fixed Assets.

Operating Systems: Windows XP/2003/Vista, UNIX, Linux, MS DOS.

Databases: Oracle 11g/10g/9i.

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

Methodology: Most of the implementations were carried out broadly on the guidelines of AIM Methodology.

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Oracle Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the Procure to Pay Business flows including AP, AR, GL, iExpense, iProcurement, and Cash Management modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for AP, AR, GL, iExpense, iProcurement and Cash Management.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Worked on Auto Accounting in the AR module
• Worked on the Auto Invoice Process in AR Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work. iProcurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment. iExpense - Configured iExpense module including setting up of Payables Lookup Types for iExpense, Setting up Credit Card expense types, Expense check reimbursement address, Expense reporting template for Connected and Disconnected expense reporting, Defining the expense clearing account, establishing the multi-currency setup, setting up itemization in iExpense, Setting of iExpense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate iExpense access, assigning signing Limits, etc.
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues.
• Implementation and support of Accounts Receivables and Account Payable Module.
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Work with the customers to understand their existing business process and prepare various requirement gathering documents.
• Perform Gap analysis between business requirements and Standard functionalities of Oracle ERP application.
• Involved in change management to follow up the necessary changes which have been made as per the business flow in day to day activities.

Confidential, Sandiego, CA.

Oracle Procure to Pay Functional Consultant

Responsibilities:

• Design and configure PO, iProcurement, iExpense, iSupplier, Inventory, Accounts Payables as per business requirements.
• Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions
• Involved in dealing with all the stakeholders on the project to gather requirements, firm up the requirements and then get the signed off by the stakeholders for each functional track.
• Involved in designing the Project Plan for the individual modules
• Involved in developing the Process flows for the Quote to Cash and Procure to Report modules.
• Involved in the Functional Analysis of designing and developing a custom licensing module called e-licensing, which was primary designed to provide license keys for products sold and tie back to Install Base.
• Purchasing - Worked on the configuration of the Purchasing module including the setups of the Approval hierarchies, Purchasing Options, Setting up Matching, etc.
• Worked on the complete setup of iProcurement module including the setups of the Approval Rules using AME, setting up the Approved Supplier Lists, Auto Sourcing, Customized the Requisition import process form iProcurement to Purchasing.
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology
• Worked on designing the power point presentations for the business requirements and solutions for the GAPs that were identified.
• Worked with Oracle support for Oracle functionality issues by raising Service Requests.
• Was involved in developing Use Cases for testing of the Quote to Cash business process
• Was involved in designing the communication plan for any changes that were made to the system, any changed that were made to any of the functional processes.
• Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.

Confidential

Oracle Functional Consultant

Responsibilities:

• Worked on Setup and Configuration of OM, INV, PO, BOM, AP, and AR modules.
• Involved with migration of historical data for Accounts Payables and Accounts Receivable.
• Conducted end-user meetings to review current business processes and requirement gathering
• Prepared the various requirement gathering and functional design documents
• Set up Account Payables to create invoices by using ‘Oracle Pay-on-Receipt Option’
• Defined payment terms, invoice approval codes and payables look-ups
• Provided post production support.
• 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.
• Full involvement in day-to-day activities of system and Support users by solving their problems related to day-to-day Activities.
• Prepared functional design documents (MD050) and Coordinated with technical team for the development of various RICE objects.
• Setting up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks and Transaction Sources.
• Setting up of Item Templates and Item Categories.
• Setting up Order Management with Order Transaction Types, RMA types with various kinds of Order Holds utilizing credit check
• Order entry & Order booking - Use defaulting rules and processing constraints to help through order entry.
• Design and develop MD050 and BR100 in SCM instance based on the new solution going forward.
• 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 bugs resolution & testing application functionality for new patches.
• Troubleshoot and analyze issues, perform root cause analysis, identify bugs / enhancements and proactive system monitoring.
• Created user manuals and user procedures
• Conducted training to users and super users.
• Involved in change management to follow up the necessary changes which have been made as per the business flow in day to day activities.
• 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.