SUMMARY

• 9+ years of total experience including 7 Years of experience as an Oracle E - Business Suite Apps Financial Functional which includes Implementation, upgrade, Testing and Production support on Oracle EBS 11i, R12.
• Expertise in modules such as General Ledger(GL), Account Payables (AP), Account Receivables (AR), Cash Management (CM), Fixed Assets (FA), Purchasing (PO), iProcurement (IPROC), iExpenses, and System Administration (SA).
• Conducted requirements gathering workshops, prepared AS-IS and TO-BE process, GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted UAT sessions and user training for accounting professions and users using AIM methodology.
• Strong Configuration experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org.
• Experienced on RICE, SQL PLUS.
• Worked in Onsite and Offshore model projects including coordinating and leading offshore team
• Experience in project go-live and post-implementation support.
• Excellent understanding of Oracle Applications base tables, Oracle Financials schema, views, data elements, Workflows and interfaces for the troubleshooting & resolution of Production issues.
• Prepared Test cases TE-020,030,040 for Financials modules (AP, AR, FA, CM, PA and GL).
• Familiar with system development life cycle (SDLC).
• Worked extensively with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).

TECHNICAL SKILLS

ERP: General Ledger, Accounts Payable, Accounts Receivables, Fixed Assets, Cash Management, Purchasing, Inventory, Application Object Library, SLAM, iExpenses, iProcurement, System Administration.

Packages: E-Business Suite Oracle Applications R12, 11i (11.5.3 - 11.5.10.2 ).

RDBMS: Oracle (10g, 9i, 8i)

Tools: /Utilities: FSG, Web ADI, SQL * Loader, SQL * Plus, Oracle Work flow, AdventAxys, FACTSET

LANGUAGES: SQL, PL/SQL

Office Tools: MS Word, Excel, Power Point, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Hightstown, NJ

Sr. Oracle Apps Functional Consultant

Environment: Oracle EBS Applications R12 (AP, GL, AR, PO, Sys-Admin) Oracle 10g, (SQL, PL/SQL)

Responsibilities:

• Worked with R12 implementation team in GL, AR, AP & PO modules in Multi-Org Environment.
• Involved in study of existing system, preparing the functional design to extract data from legacy system into Oracle Applications open interface tables.
• Created functional specification documents for customized interfaces, reports and extensions.
• Reviewed existing interface designs and made modifications to fit R 12 specifications.
• Created AIM based documents like BR100, MD050, TE020 and CV40’s etc for legacy conversions to Oracle EBS applications.
• Prepared documents for Setup configuration, Training Manuals for all the modules as per AIM methodologies.
• Conducted user testing, identifying test scenarios, and writing test scripts with users for the Payables, Receivables and General ledger.
• Performed functional testing and working with offshore teams to resolve the issues.
• Provided functional support in UAT, Conversion and Go-Live and Production environment
• Configured the setups for General Ledger module using Accounting Setup Manager (ASM) and AGIS for AP and AR.
• Updated the setups for the Account Receivables such as collectors, customer profile class, bank accounts.
• Extensively worked on Receivables and configured setups for organization structure, Auto invoice, Auto Accounting, Receivables Activities, Application of Receipts to transactions and invoice printing with remit address.
• Define Invoice Attributes- Payment Terms, Distribution sets, Pay groups, Special calendars for Recurring Invoices, Entering Vendor and Site Information.
• Define Payment Attributes- Payment formats, Bank Accounts and Payment Documents.
• Provided functional support to business users in payables, receivables, purchasing, Inventory and general ledger modules.
• Involved in resolving functional issues and setup issues as per Companies specific requirement.
• Worked on GL Chart of Accounts for configuring and maintaining as part of BAU.

Confidential, West Des Moines, IA

Oracle Apps Functional Consultant

Environment: Oracle EBS Applications R12 (GL, AP, FA, PO, iProcurement, iExpenses), Oracle 10g (SQL, PL/SQL, Web ADI)

Responsibilities:

• Worked with R12 implementation team in AP, PO, GL, FA and iExpenses modules in Multi-Org Environment.
• Troubleshoot the issues related to different interface like GL interface, AP/FA invoice interface.
• Supported users to import journals using Web ADI
• Prepared the Test scripts for Regression testing in AP, PO, GL, FA
• Estimated efforts for regression testing, enhancement, development and get it approved.
• Managed the testing team and finished the testing on schedule
• Implemented General Ledger which include setup of chart of accounts, Mass Allocations, recurring Journals, cross validation rule, security rule, define Ledgers using Accounting Set Up Manager, calendar, Document sequencing, key Flex Fields and descriptive Flex Fields.
• Configured I expenses module set up as part of business process requirement.
• Prepared Functional design document (MD50) and Functional Setup documents (BR100), Test Scripts (TE020) as per AIMS Methodology.
• Defined the custom lookup values in AOL and assigned dependent value sets to achieve the specific business processes.
• Reported and resolved Defects using Quality Center.
• Supported Procure to pay and FA issues with month end and additional configurations.
• Participated in user testing and helped in migration to production for BAU activities.
• Providing production support of Oracle financials, including following up SR’s with Oracle Meta link.

Confidential

Sr. Business Systems Analyst

Environment: Oracle EBS Applications 11i (GL, AP, AR, CM, PO, iProcurement and iExpenses), Oracle 10g (SQL, PL/SQL)

Responsibilities:

• Mapped client business requirements to Oracle functionality and identify the gaps based on the study and preparation of the Application setup documents (BR100) and setup application in development and production environment.
• Preparing RD20 Requirement documents, Functional Design documents (MD050), BR100 Setup documents, BR150 Business Gap documents for AP, FA modules as per Oracle AIM methodology
• Implementation of Oracle Payables modules using AIM methodology which includes Payment Options, Payment terms, Distribution Set, Payment Format, Internal Banks, Recurring Invoices, Prepayments, Expense Report Templates, Interest on Invoice report, Matching options.
• Worked on cash management module that included designing bank statement interface,which needs customization for Receivables-Cash-management integration and Paybales-cash management .
• Conducted UAT sessions and Successful Go Live of Application system.
• Involved in the transition of Application to the support group for Maintenance of the application.
• Provided support to users during and after go-live for month end activities and also involved in BAU activities.
• Lead a variety of tasks focused on stabilizing the system prior to final testing and preparing for final cutover to production. This includes work to troubleshoot and resolve open issues, testing, providing functional expertise needed by the team to complete the system readiness tasks.
• Prepared standard Operating Procedures (SOPs) for the end-users and handled SRs.

Confidential

Oracle Functional Consultant

Environment: Oracle EBS Applications 11.5.9 (AR and AP), SQL*Loader

Responsibilities:

• Functional consultant responsible for the implementation of Accounts Receivable and Account Payable modules
• Defined setup steps of the AR module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes. Exemptions were defined, as products were not subject to tax in all states.
• Configured Receivables Auto Lockbox and involved in the vertex tax configuration.
• Set-ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval Management.
• Prepared and updated BR100 and MD 50 for all RICE components
• Defined new responsibilities, menus, hierarchies, security rules, approval groups for Release 11i users. Also included, restricting users access to certain forms and form functions using function security.
• Unit/Integration test and review of deliverables Ensuring knowledge building sessions at regular intervals for the team members.
• Day-to-day basis co-ordination with Functional users and Oracle Metalink for support, maintenance and issue resolution for Base and Localization functionalities.

Confidential

Oracle Functional Consultant

Environment: Oracle EBS Applications 11.5.9 (GL, AR, AP, PO, FA and Sys Admin)

Responsibilities:

• Responsible for set-up steps for the successful implementation of the Accounts Receivable and Fixed Assets module
• Interacted with the Business and analyzed existing business practice and prepared business requirement document and identified Gaps.
• Assisted and prepared Process diagrams for AS IS / TO BE scenarios.
• Worked with the business to come up with the future business process. Designed a Prototype (Demo) configuration as per client’s request
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depriciation methods, security profile, asset calender, fiscal year, quick codes and system controls.
• Conducted UAT and trained end users for AR, FA Modules and assisted for other financial modules.
• Participated in unit and integration testing and created use cases & test plans and presented to the business for the sign off.
• Liasoned between the technical staff and the users. Was also responsible for interdepartmental coordination between the various teams involved
• Worked extensively with technical team for data conversion for payable, receivable and Fixed Assets activities.