SUMMARY:

• An Oracle Financials Functional Consultant with over 10 years of functional accounting, business analysis in various industries and sectors of the economy in Oracle Applications expertise. Possess strong verbal and written communication skills. A strong team player, and adaptable to a variety of roles in the Corporate Information System area has great working knowledge of Client/Server technology, and financial applications. Also possess the ability to analyze situations and offer innovative cost effective solutions.
• 9 years of experience in Accounts Receivables (AR), Accounts Payables (AP), I - Expense, i-Procurement, i-Receivables, Advance Collections, General Ledger (GL), Purchasing (PO), Project Accounting (Costing, Billing, Project Resource Management), Oracle Time and Labor (OTL), Oracle Order Management (OM), Inventory (INV), Fixed Assets (FA), Oracle Federal Financials, AOL and System Admin and integrated custom applications. Experience with Oracle User Productivity Kit (UPK) and Oracle Tutor
• Conducted and evaluated several Business Process Reviews (BPR) and GAP Analysis to resolve business requirements not addressed by the application.
• Competent in various modules in Oracle Financials 11i.
• 2 Full Life Cycle in Release 12
• Very good experience in the Order to Cash, Invoice to Report and Procure to Pay flow.
• Competent in understanding the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Prepared Business Requirements Definition (RD) and Module Design (MD) documents required under the AIM methodology.
• Developed test case, test plan and resting process and conduct core team and end user training.
• Experience with Vertex Tax Software integrating it with Oracle AR Module.
• Conducted several UAT’S and CRP’S in Oracle Applications
• Good working knowledge and interpretation of financial statements such as retained earnings and balance sheet statements
• Configured and implemented applications as per the clients request and the business requirements.
• Extensive experience with EDI Gateway and e-Commerce Gateway including the following
• Created Use-Manuals for programs and user procedures.
• Provided post production support.
• Interacted with Oracle Support to resolve application issues.
• Developed business process flows, identified risk points and suggested risk mitigating control measures.
• Good knowledge and understanding of general accounting principals “GAAP”.
• Excellent planning and organizational skills.
• Team oriented, self-motivated and a disciplined individual.

TECHNICAL SKILLS

Functional: Business Requirements Analysis, Gap Analysis, Process mappingand Oracle Applications functional setup

ERP: Oracle Financials (12.0.5, 10.7 and 11i), Oracle Financials (10.0.711.03 and 11i) - i-Procurement, i-Receivables, iExpense, OracleAccounts Payables

Modules: Accounts Payables (AP), Accounts Receivables (AR)Purchasing, Payroll, Advance Collections, General Ledger(GL), Fixed Assets (FA)and Purchasing.

Methodology: AIM (Applications Implementation Methodology)

Business Intelligence: Working knowledge of Oracle Discoverer

Language: Reasonable understanding of SQL

Oracle and Other Tools: Data loader, ADI, Web ADI and MS-Office tools including Visio / MS Projects

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Functional Consultant

Responsibilities -

• Actively involved in implementation of E-business suit for SGP Operating Unit including gathering the requirements from the user and understanding their business model the modules worked on includes: i-Expense, GL, AP, Advance Collections,OM, PO, i-Receivables & FA of Oracle e-Business Suite.
• Worked on all the Business Analysis of developing the GAP Analysis, Business Requirement Documents (BRD’S), Functional Specification Documents (FSD), MD050, BR100, TE020, Te030, etc.
• Performed all of the setups for the AR Module including the setups Lock Box, Auto Invoice, Revenue Recognition Process, Invoicing and Accounting rules.
• I-Expense - Configured i-Expense module including setting up of Payables Lookup Types for i-Expense, 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 i-Expense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate iExpense access, assigning signing Limits, etc.
• Developed the Functional Specification Documents (FSD) and Technical Specification Documents (TSD) for all of the customizations and data conversions.
• Worked on the configurations of Manufacturing AR, OPM, BOM, WIP, AP and GL module.
• Reviewing Functional Specifications / Change requests with the client.
• Worked on the Revenue Recognition process in AR Module.
• Communicating the requirements to the technical team
• Preparing design document as per the functional requirements
• Preparing System / Integration Test cases and carrying out Integration testing
• Supporting the users with the User Acceptance Testing (UAT)
• Taking part in the review of test cases and giving necessary inputs.
• End-user training
• Updating the client on the status of the project at offshore, almost everyday.

Confidential, Seattle, WA

Oracle Finance Functional Consultant

Responsibilities

• As a Business Analyst Supported the financial modules: GL, Advance Collections, AP, AR, OPM, BOM, WIP & FA Release 12.1.3
• Lead Conversions & Enhancements for OM, AR, Advance Collections and INV module
• I-Expense - Setup iExpense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, Setting up iExpense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
• Worked on setting up of Revenue Recognition process in AR Module
• Defined the Accounting and invoicing rules to be used in Revenue Recognition process in AR.
• Worked on the setup of Advance Collections module by setting up the Collection Engine, Collection Rules, Collectors and Dunning Plans.
• Worked on data mapping, design, file structure validation, e-Commerce Gateway configurations for EDI transactions like 810, 852, 832, 826, 850 file formats.
• 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 OM, Advance Collections, AR, OPM, BOM, WIP, INV and GL modules from scratch and simultaneously created BR100 documentation for the setups.
• 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, NJ

Functional Business Analyst

Responsibilities:

• Worked in the configuration of OM, WMS, INV, PO and AR modules.
• Performed Requirement and GAP analysis.
• Configurations and Setups for AR, AP, GL, Advance Collections, Sub Ledger Accounting
• 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.
• 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 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.

Environment - Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US and Canada OM, AR, OPM, BOM, WIP, AP, GL,EDI, Advance Collections, INV and PO modules

Confidential, LA, CA

Oracle Financials Functional consultant

Responsibilities:

• As a Functional Consultant implemented the Order to Cash Business flows including OM, AR, AP, GL, INV and Pricing
• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, OM, Advance Collections, GL and AP 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 EDI Transactions for Inbound and Outbound PO, Inbound Sales Order, Inbound Invoice, etc.
• 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 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, Sunnyvale, CA

Oracle Apps Functional consultant

Responsibilities

• As a Functional Consultant implemented the following modules: AR, AP, GL, 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.

Confidential

Order to Cash Functional Consultant

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
• Defined Accounting Flex field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Performed all the setups for PO, AP, CM, Project Accounting (Costing, Billing), FA, INV, i-Procurement, i-Expense
• Defined Journal Sources, Journal Categories, Shorthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feedbacks.

Environment: Oracle Applications - 11.5.10

Computers, Bangalore

Oracle Financials Functional Consultant

Responsibilities:

• Defined Accounting Flex field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Defined Journal Sources, Journal Categories, Shorthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feedbacks.
• Requirement gathering developed Functional Specifications for new development/enhancements/Change requests
• Functional Activities- Gap Analysis to identify the gaps based on Business requirements - Involved in Capturing and Documenting As-Is process & to-be business processes
• Configuration Set up of Oracle Financial Modules (AP/AR/GL/FA/CM)
• Provided support to users during go-live and Rollout by way of problem solving and instructions- Post Production issue resolution and support including Month/Quarter/Year End Close Support

Environment: Oracle Applications (11.5.9)