SUMMARY:

• 7.3 years of IT experience as a Functional Consultant in Oracle e - Business suite.
• Very good understanding of Oracle Apps Modules Oracle Financial Modules like AP, AR, e-Business Tax, i-Expense GL , Sub Ledger Accounting and Distribution modules like OM, INV, PO, i-Procurement, i-Supplier, Advance Pricing and Shipping modules.
• Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) including AIM/Agile/Scrum approaches
• Have good experience in Software Testing Life Cycle and its phases like Functional, Regression, System, Integration, Performance, E2E, BAT and User Acceptance Testing.
• Extensive experience in Quote to Cash Cycle (Order Management, Accounts Receivables, Cash Management, General Ledger), Supply Chain management (SCM) and Trading Community Architecture (TCA)
• Working experience in Procure to pay cycle (Purchasing, Account Payables, Fixed Assets), Advance Collections.
• Extensive experience with training of end users using Oracle Tutor, Power Point presentations, Webinars, etc.
• Extensive experience in preparing Training Material and End User Guides
• Extensive experience in conducting UAT and CRP
• Performed End-to-End system testing manually and c losely worked with Cross Flow Teams
• Involved in different kinds of meetings with the developers, team members to discuss about the Test entry criteria, Test exit criteria, status of testing and statuses of the defects.
• Hands On Experience in Onsite offshore coordination, offshore onsite coordination and Customer coordination
• Experience in SQL queries to perform Backend testing and data mining.
• Worked extensively in testing of Reports/Concurrent Programs, Forms in Oracle Applications.
• Able to work under self-direction with minimal supervision and guidance, prioritizing own work and coordinating with other team members and business users.
• Capable of quickly learning new technologies and adapting to a new environment.
• Excellent interpersonal skills, ability to interact with people at all levels, good communication and presentation skills

PROFESSIONAL EXPERIENCE:

Confidential, Taunton, MA

Oracle Functional Consultant

Responsibilities:

• As a Functional Analyst Implemented the Oracle Modules - AR, e-Business Tax, AP, GL, PO, INV and OM on Release 12.1.3
• Worked on functional enhancements for AR, AP, GL, PO, OM, & INV module
• Worked on the setups of the Payment Manager in Oracle AP Module
• Worked on the Revenue Recognition process in AR module.
• Worked on the functional design of the customization to the “Create Customer Product” form in Install Base module.
• Worked on setting up of Revenue Recognition process in AR Module
• Worked in configuring the Approval Hierarchies in PO module
• Configured the e-business Tax module for AR and AP modules - set up the Tax Codes, Tax Rates, Default Tax rate, Tax exemptions, Tax exceptions, Tax Determination services, etc.
• 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.
• Configured AR, AP, GL, FA, PO modules from scratch and simultaneously created BR100 documentation for the setups.
• Worked on the Localizations for Europe (Netherland, Spain, Italy), UK, Mexico, Latin America, Japan, China
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for WVI (World Vision International) by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in Order to Cash, OM, AR, GL, AP, CM, FA.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, Chicago, IL

Functional Analyst

Responsibilities:

• Studied the existing Order to Cash process - “As is Analysis” and Testing the Data Conversion
• Interacted extensively with the end-users to understand and define a precise accounting flex field structure in Oracle General Ledger (non Production instance)
• Worked on the Revenue Recognition process in Oracle AR - worked on defining the accounting and invoicing rules, setup event based revenue recognition, rule based revenue recognition, worked on deferred COGS, etc.
• Configured the AR, AP, GL, OM modules including setups and business processes definition
• Worked on the Setup of suppliers and the entire Purchasing Module.
• Configured the Setup Account Payables, Setup Payment terms, invoice distribution, matching process of invoices against PO
• Setup the Auto Invoice modules, Banks, Dunning letter, Auto Lockbox functionality in AR Module
• Setup employee expense templates and distribution sets in oracle AP.
• In the INV Module, setup the INV Master Orgs, Child Orgs, Defined custom transaction types, setup sub inventories, locators, serial numbers, Min Max Planning, Re Order point Planning, Physical Counting and Cycle Counting, etc.
• Worked on the Ledger Setups in GL, Primary and Secondary, Setup Ledger Sets, Data Access Sets, Accounting Flex Field, Cross Validation Rules and Security Rules, Worked on the Translation and Revaluation process.
• Created suppliers, tax codes, and banking information.
• Defined financial and payable options.
• Developed training material and provided end user training.

Confidential, Canton, OH

Functional Consultant

Responsibilities:

• Worked in the configuration of AR, AP, GL, PO, Service Contracts, Install Base, OM, i-Procurement and INV modules.
• Performed Requirement and GAP analysis.
• Worked on the setups of the AP Module - like setting up all of the options of the Payment manager, worked on Invoicing process, Setup the ACH process with the bank for payment process, setup all of the transaction types, etc.
• Worked on the e-Business Tax module to setup the Tax Codes, Tax Rates, Tax elements and Tax determination services.
• 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 the localizations of US, Mexico, New Zealand, Australia and Canada.
• Involved in the Setups of Revenue Recognition including the setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up the Daily Revenue Rule that are new in R12.
• Worked on the Setup of OM module - including defining of Transaction Types, Price Lists, Defaulting Rules and Processing Constraints.
• Worked on the setup of the Internal Requisition Internal Sales Order (IRISO) process.
• Worked on the Auto Lock box process in Oracle AR module.
• Worked on Auto Accounting in the AR module
• Worked on the Auto Invoice Process in AR Module.
• Worked in a team in understanding the integration of Advanced Pricing with OM process
• 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.

Confidential, Denver, CO

Functional Analyst

Responsibilities:

• Managing the project end-to-end. Management responsibilities include planning, coordinating, executing, tracking, reporting, Issue resolution, dependency/risk management/Mitigation, change management and quality assurance.
• Implemented financial modules: GL, AP, AR, FA & CE along with PO integrated with internal e-Procure system, Release 11i of oracle (11.5.10.2).
• Implemented 14 SOB’s (20 Operating Units) using multi org structure, multi currency along with Consolidation SOB.
• Worked on Revenue recognition in AR.
• Implemented the TCA including setting up Parties, Customer Accounts, Party Relationships, etc.
• Setup document validation, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Implemented Automatic upload & Bank Reconciliation functionality in CM.
• Implemented Auto Lock box Functionality in AR.
• Implemented Outbound interfaces for AP for creating bank payment outbound file (Electronic Fund Transfer Interface) for uploading banks HSBC, BOA & SCB.
• Customization done on CFD’s like AR Customer Invoice for pre-printed stationery and using XML feature, inter Company Customer Invoice, AP -Remittance Advice.
• Implemented Corp & Tax books in FA.
• Lay down the process for centralized month end & year-end period closing in Oracle.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.

Confidential, Los Angeles, CA

Functional Analyst

Responsibilities:

• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, AP, Service Contracts, Install Base, GL, & FA modules
• Worked on the setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined the Auto Lock Box process in AR module
• Defined the Auto invoice process in AR module
• 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 the setup of i-Procurement module including the setting up of Catalogs, Categories and Uploading Items into i-Procurement, Punch-out’s both transparent and direct.
• Worked on the setup of Purchasing Options, Financial Options and Document Types in PO 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.
• 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
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, Mountain View, CA

Oracle Functional Consultant (Financial Modules)

Responsibilities:

• As a Functional Consultant implemented the following modules: AR, AP, GL, Service Contracts, Install Base, PO, OM, INV, Shipping and Advance Pricing modules.
• Worked on the Functional mapping of data Conversions & Enhancements for OM, INV, PO, AR, AP and GL 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.
• Configured Oracle AR - Including the setups of Revenue Recognition process, defining of Accounting and Invoicing rules.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for SCEA by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in GL, AR, WMS, OM, INV and Shipping Modules.

Environment: Oracle e-business Suite 11.5.8, Quality Center, Quick Test Pro, Load Runner, Test Director, Windows 2000

Confidential, San Diego, CA

Oracle Functional Consultant (GL, AP, AR, CE)

Responsibilities:

• Requirements gathering from end users, Requirement analysis
• Mapping the functionality in Oracle product and performing Gap analysis
• Configuring the product in the system
• Key user training and user manual preparations
• Preparation of test methodology, test guidelines
• Preparations of System test plans and integration test plans
• Preparing BRD document, BR100, CV040
• Preparing Functional Specification document for Extension, Customization & Reports
• Assisting Conversion team with data analysis and data preparation
• Post Production support

Environment: Oracle E-Business Suite 11.5.10, Manual Testing, Windows XP, UNIX, Ms-Office, Load Runner, QTP and Test Director.