SUMMARY:

• An Oracle Financials Functional Consultant with over 8.9 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.
• 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 .
• 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.
• 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 mapping and Oracle Applications functional setup

ERP: Oracle Financials (12.0.5, 10.7 and 11i)

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, Orange County, CA

Oracle Order to Cash Functional

Responsibilities:

• As a Functional Consultant implemented the following modules: Inventory, Order Management, AR, General Ledger, Global Order Promising, Shipping, Advance Pricing
• Worked on the Functional mapping of data Conversions & Enhancements for Inventory, Order Management modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on Inventory setups - defining the Organization Structure, defining the Sub Inventories, Catalogs, Categories, Planning (Min Max and Re Order Point Planning), Defining Cost Groups, ABC Analysis, Cycle Counting, Physical Inventory and Item Import Program
• Worked on the AR Setups - defining the Auto Invoice, Auto Lock Box, Revenue Recognition process, Accounting and Invoicing rules, Transaction Types, etc.
• Worked on the Refund functionality in Oracle AR
• Worked on the AR/AP Netting process in AR
• Worked on the Bank Setups in AR module.
• Worked on the setups of OM Module - Defining the order and line workflows, defining the transaction types, setting up Processing constrains and Defaulting rules.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful to the users in Inventory, Global Order Promising, General Ledger, AR, Shipping, Order Management, AR, Shipping and Advance Pricing Modules.

Environment: Oracle Apps Release 12.2.7 e-Business suite (Inventory, Global Order Promising, General Ledger, AR, Shipping, Order Management, Advance Pricing)

Confidential, Ada, MI

Oracle Order to Cash Business Analyst

Responsibilities:

• Lead numerous requirement gatherings, designing, documenting and unit testing of various RICE components for R12 Customizations.
• Working on Order to Cash area using Oracle Apps R12 (Order Management, Inventory, Purchasing)Designed new processes for Forward Logistics, Inbound Logistics, Reverse Logistics and Return to Contract manufacturer (R2A).
• Worked on the setups of the Approval rules in AME - attributes, rules, actions, parallel approval, etc.
• Worked on configuration of the Purchasing module - defining the Buyers Workbench, Purchasing Options, Document Types and Styles, etc.
• Worked on the setups of punch out’s in Oracle i-Procurement module
• Loaded the catalogs into Oracle i-Procurement
• Worked on the content zone setups in Oracle i-Procurement
• Responsible for implementation tasks including Requirements Gathering, Solution Design, System Configuration, Conference Room Pilot, Data Migration, Testing and Post Production Support.
• Worked on the configuration of the Payment Manager in Oracle Accounts Payable module - defining the payment process profiles, configuring the payments methods, payment modes, etc.
• Implemented Inventory, Accounts Payables, Order Management and Supply Chain modules using Oracle E-Business Suite R12.1.3.
• Analyzed the current and new business process like Business Requirements Document (RD050) and Solution Design (MD050) using Oracle AIM methodology.
• Responsible for Configuration of Inventory and Shipping modules to support the various Business solution
• Involved in defining Shipping Key Flex field, Lookups, Transaction Types, Organization Parameters, Sub inventories and Shipping Networks.
• Worked with development team to provide expertise and ensured successful delivery of extensions, reports and interfaces.
• Worked on different EDI interfaces likeEDI4B2, 3B18, 3B2 Ship Confirm and 3B3 Milestone messages from partners and process the same for transactions in Oracle APPS Supply Chain Deliver Track.
• Worked with various Cross Functional Tracks to resolve technical and data issues.
• Responsible for BR100 setups to support deliver track solution as well as business setups planned for each release.
• Coordination with offshore team to enable them to understand the process and to familiarize them with the issues that normally generate and the probable ways of resolving them.
• Participated in ongoing Process Enhancements and Change Management meetings and Deep Dive sessions with Business and Doing impact analysis.
• Worked on Defects logged in HPQC, and ensured that they were fixed on time with the technical team.
• Created Test Plans as per business scenarios and planned testing strategies.
• Wrote Test Cases and Test Scripts (TE040) forfunctionaltesting.
• Tested and implemented the requested changes in existing environment.
• Performed Root Cause Analysis of Month end related issues and provided a solution to reduce the month end Services.
• Worked with development teams with Water Fall Model and Agile Methodology.
• Worked on Sprint Approach to support the Receiving Lite Disposition for reverse Logistics to be being implemented using PEGA (PEGA Business Rules)

Confidential, Houston, TX

Order to Cash Business Analyst

Responsibilities:

• Design and configure OM, INV, PO, AR, Shipping as per business requirements.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process evaluation, testing, conversions, customizations and documentation.
• Maintained proactive interaction with the client to understand business practices to aid in system configuration.
• Configured the Accounts Receivables modules with functional specifications
• Worked on EDI Inbound and Outbound Interfaces for 850, 861, 810, etc.
• Understand the specific issues and problems faced by business user in the area of accounting (SLA) and (Financials Accounting Hub) due to upgrade and provide the solution to resolve the same by configuring SLA and Financials Accounting Hub.
• Identify the business requirements and process improvements that can be achieved through SLA and e-BTax.
• Setup new Trading Community Architecture (TCA) to meet specific accounting requirements of various business units.
• Setup Supporting Balances to enable inventory balances by items and payable account balance by vendor.
• Suggest SLA setup to do multi currency and multi GAAP accounting for Switzerland and France.
• Prepared the test scripts and performed the SIT Testing. Documented the setups and business process flows. Prepared the material and trained the users the functionality of the financial modules.
• Involved in the conversions of the legacy data into the Account Receivables and Payables modules, code migration and cutover activities.
• Developing detailed functional design specifications based on business requirements for interfaces and extensions to provide seamless integration between Oracle Applications and Custom Applications.
• Developing functional design specifications for custom reports based on business requirements. Prepared the Oracle Tutor documents explaining the usage of Operational Reports to assist manufacturing personnel. Review and approve technical design specifications for custom objects and ensure that the design meets business requirements.
• Design and develop standard operating procedures using Oracle Tutor.
• Perform unit testing of various RICE elements and review the same for compliance with the Technical design specifications.
• Identify test data requirements and organize for test data collections. Also design various test sets to simulate different business scenarios in Test director and perform integration testing for the same. Trained the Super users using the UPK kit.
• Post Production Support Post Go-Live adhering to SLA’s based on the Severity of the Help Desk Tickets.

Environment: Accounts Receivable, i-Procurement, i-Expense, E-Business Tax, Inventory, Purchasing, Order Management, BOM, WIP, I-store, I-supplier, Sales Incentive, PL/SQL, SQL, Toad, Linux, Windows XP, Vertex Software. Web ADI, Discoverer.

Confidential, Milpitas, CA

Order to Cash Functional

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 includesOM, INV, PO, AR, Shipping Modules
• 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.
• Developed the Functional Specification Documents (FSD) and Technical Specification Documents (TSD) for all of the customizations and data conversions.
• Worked on the configurations of OM, INV, PO, AR, Shipping 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
• Updating the client on the status of the project at offshore, almost everyday.
• Reviewing and giving inputs on all the developed components, Unit test Plan and Unit test report.

Confidential, NJ

Oracle O2C Functional Consultant

Responsibilities:

• As a Business Analyst Supported the financial modules: OM, INV, PO, AR, Shipping in Release 12.1.3
• Lead Conversions & Enhancements for OM, INV, PO, AR, Shipping module
• 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 AP module - worked on the ACH Process with the bank, defined the AP transaction types, worked on payment terms, worked on interfacing AP data with external systems.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured AP, GL, i-Procurement, i-Supplier, i-Expense, PO 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.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful to the users in AP, GL, i-Procurement, i-Supplier, i-Expense, PO.
• 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, San Jose, CA

P2P Functional Business Analyst

Responsibilities:

• As a Business Analyst implemented the AP, GL, i-Procurement, i-Supplier, i-Expense, PO modules
• Worked in the configuration of AP, GL, i-Procurement, i-Supplier, i-Expense, PO modules.
• Performed Requirement and GAP analysis.
• Configurations and Setups for AP, GL, i-Procurement, i-Supplier, i-Expense, PO
• 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 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 Setups of the AP module - defined the AP Transaction Types, Supplier Setups, worked on Payment Manager setups, Check Printing process, etc.
• 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, AP, GL, Advance Collections, INV and PO modules

Confidential, Sunnyvale, CA

Oracle Apps 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 Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User 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, San Francisco, 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 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 to the users in GL, AR, WMS, OM, INV and Shipping Modules.

Confidential, Cleveland OH

Oracle Apps Functional resource

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 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 Applications - 11.5.9

Confidential

Oracle Apps Functional

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.
• 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