SUMMARY:

• Overall 8 years of experience as a Techno Functional Analyst in Oracle Financial Modules (GL, AP, AR, i - Expense, SLA, Lease and Finance Management (OLFM), E-Business Tax, Fixed Assets, Cash Management)
• Extensive experience with Oracle e-Business suite rollouts, implementations and upgrades in version Release 12.x and 11i
• Performed Requirement gathering and Designed and Implemented solution. Also did testing and Performed Maintenance.
• Experience with Order to Cash and Procure to Pay business flows.
• Prepared Business Requirements Definition (RD) and Module Design (MD) documents required under the AIM methodology.
• Developed test cases, test plans, and testing processes. Conducted core team and end user .
• Experience with R12 Implementation
• Payments Module
• Lease and Finance Management (OLFM)
• Sub ledger Accounting
• E-Tax Engine
• Financials Consolidation Hub
• Extensive experience with FSG reports and Discoverer reporting.
• Extensive experience with Revenue Recognition, Auto Accounting, GL Transfer process, Order to Cash and Procure to Pay.
• Conducted several UAT and CRPs in Oracle Applications.
• Good working knowledge and interpretation of financial statements such as retained earnings and balance sheet statements. Also have a good understanding of general accounting principles “GAAP”.
• Configured and implemented applications as per the client’s request and the business requirements.
• Sound knowledge of technical architecture, tables, and interrelationship among tables
• Led the technical team for Interfaces and Conversions.
• Worked in Multi-Org, Multi-currency environment.
• Interacted with Oracle Support to resolve application issues.
• Developed business process flows, identified risk points and suggested risk mitigating control measures.
• Accomplished in working with Organizational user to understand their needs and requirements prior to developing application systems.
• Experience in handling production support activities and interacting with users of different nationalities.

SKILL:

Operating System: Windows 95/98/NT/2000, DOS, UNIX, Solaris

RDBMS & GUI: Oracle 7.x/8/8i

Oracle Tools: SQL*Plus 8.0, TOAD 9.5, SQL Loader, Data Loader, Application Desktop Integrator

ERP: Oracle Application 11.5.9 and 11.5.10.

Functional Modules: GL, AP, AR, FA, Lease and Finance Management (OLFM), CM, and i-Expenses

Technical Modules: Flex fields, AOL, System Administration

Methodology: Oracle AIM 3.0

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

Oracle Finance Techno Functional Consultant

Responsibilities:

• Preparing business requirement documents for three different projects with the business rules associated to integrate the new company acquired by Fox into the original system and the new Oracle - SAP setup.
• Preparing business test scripts with the business rules associated with it to test the data after integration and related development for all the four projects and signing it off for the Oracle Team
• Performed all the setups for GL, AP, AR, i-Expense, Lease and Finance Management (OLFM), SLA, E-Business Tax, Fixed Assets, Cash Management modules.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on a deferred revenue customization using the Revenue Recognition process in AR.
• Setup Event Based revenue recognition and rule-based Revenue recognition in Oracle AR
• Worked on replacing a customization for deferred COGS with Standard functionality in Release 12.
• Worked on the setups of Oracle Lease and Finance Management (OLFM) - configured the Lease Contract Authoring, Lease Booking and Lease Funding, Rebook, Transfer and Assumption, Renewal of Lease, Release of Lease, Upgrade of Lease in Oracle OLFM
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Confidential & Royal Bank of Canada.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Facilitated and followed the IT PMO process thoroughly.
• Flow Testing for Finance Modules (GL, AP, AR, Lease and Finance Management (OLFM), i-Expense, SLA, E-Business Tax, Fixed Assets, Cash Management) to make sure flow is working without any issues.
• Conducting Pre-Project Review & Post Project Review.
• QA Lead for Oracle ERP for a project, which needed TIBCO and SAP integration and coordination.
• Managed the complete testing activities SIT, UAT and Oracle QA.
• Obtained and signed off documents and tests from Oracle ERP side.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: GL, AP, AR, i-Expense, SLA, Lease and Finance Management (OLFM), E-Business Tax, Fixed Assets, Cash Management modules

Confidential, SFO, CA

Oracle Financials Techno Functional Consultant

Responsibilities:

• System Administration: Define Users, Responsibilities, System Profile Values, Administer Folders, Assigning Responsibilities to Users
• Tested the Revenue Recognition Process, Auto Accounting, Lease and Finance Management (OLFM), Auto Lock Box, GL Transfer, Order to Cash Process and the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Preparing business requirement documents with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for GL, AP, Lease and Finance Management (OLFM), AR, i-Expense, SLA, E-Business Tax, Fixed Assets, Cash Management modules.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1
• Pricing Business Requirement Study and designed / documented Functional Specification. (AIM Methodology Adoption)
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Flow Testing for Finance Modules (GL, AP, Lease and Finance Management (OLFM), AR, i-Expense, SLA, E-Business Tax, Fixed Assets, Cash Management) to make sure flow is working without any issues.
• Conducting Pre-Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: GL, AP, AR, Lease and Finance Management (OLFM), i-Expense, SLA, E-Business Tax, Fixed Assets, Cash Management

Confidential, San Jose, CA

Oracle Financials Techno Functional Consultant

Responsibilities-

• Gathered requirements from Business User Leads
• Defined key flex fields for all Modules, Defining Locations, Legal Entity, Operating Units, Organizations and complete setup of Multi-Org.
• Worked on the customizations, in Processes, Programs, and Reports.
• Configured AR module according to the business requirement.
• Defined setups: GL, AP, AR, Lease and Finance Management (OLFM), i-Expense, Cash Management
• Provided necessary to User Leads and Users on Enhancements.
• Performed system administration work (Depending on responsibilities enable and disable different forms and menus for Security). Defined different Organizations and Responsibilities. Setup all relevant profile options.
• Worked on testing of the 11.5.10 instance from end to end including enhancements and extensions.

Environment: Oracle 8i, SQL, Oracle Financial Applications 11i(11.5.10.1), PO, OM, INV, Shipping, Advance Pricing (Functional & Technical - AOL, Sys admin), SQL Net, Oracle Discoverer, TOAD, SQL Loader, Unix.

Confidential, Kansas City, MO

Oracle Financials Techno Functional Consultant

Responsibilities-

• Was involved in the design and development of new enhancements:
• Provided Information to User leads about new enhancements / features
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the customizations, in Processes, Programs, and Reports.
• Performed all the setups and configurations for GL, AP, AR, i-Expense, Cash Management Modules.
• Worked on customizing as well as developing new Workflow processes.
• Providing necessary to User Leads and Users on Enhancements
• Worked on testing of the 11.5.10 instance from end to end including enhancements and extensions.
• Worked on Setting up Auto Lock Box in AR.
• Worked on rectifying error transactions in Auto Lock Box Interface Table.
• Designed the Chart of Accounts in GL and Accounting Flex Field.
• Developed test scripts for testing the order to cash process and also the AR to GL flow.
• Tested several patches that were applied to the 11.5.10 instance for functionality as well as performance.
• Worked on setting up multiple reporting currencies (MRC) in the 11.5.10 instance.

Environment: SQL, Oracle Financial Applications 11i (11.5.10) with Multi-Org, AP, AR, PO, OE, FA, INV (Functional & Technical - AOL, Sys admin), SQL Net, Oracle Workflow, Oracle Discoverer, TOAD, SQL Loader, Unix.

Confidential

Oracle Financials Techno Functional Consultant

Responsibilities -

• Did Multi-Org Setups in Accounts Payable and Accounts Receivable.
• Did Multi-Org Setups in HR module as a result of the new Parts Operating Unit that is being introduced as part of the upgrade to 11.5.10.
• Worked on the Procure to pay business flows.
• Written MD 50 for AP Payment programs and AR Dealer Statements.
• Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10).
• Written standard test scripts for Subaru Oracle Financials and Manufacturing Modules.
• Written TE 020 Unit Test Scripts for Payment Methods in AP and interface with Parts Operating Unit.
• Written TE 040 System Test Scripts for GL, AP, AR, i-Expense, Cash Management Modules.
• Performed Standard Functionality testing in GL, PO, AP, AR and OM.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Worked closely with Developers team for different issues

Environment: Oracle Applications 11.5.9 (AR, AP, and GL)