SUMMARY

• Oracle Finance Functional consultant with over 9 years of focused expertise in Financials modules of Oracle Applications.
• Strong experience as a Functional/Business Analyst in implementation and Production support of Oracle ERP financial suite including Oracle General Ledger, Payables, Receivables, Assets, Purchasing, Cash Management, iExpenses, EB Tax and SLA.
• Worked on Release 11i, Release 12.0.6, 12.1.3 & Release 12.2.4.
• Experience in implementation, customization and testing of Oracle Applications for Financials 11i/R12 modules.
• Extensive experience working in Finance Modules (AP, FA, GL, IEXP, PA, AR, OTL, OPM and iProcurement).
• Worked in 4 full life cycle implementation and 1 Post Go - live enhancement project in Order to Cash (O2C) and Procure to Pay (P2P) Modules.
• Competent in understanding the functionality of the Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Worked on life cycle implementation & experience in Oracle Financials Modules: GL, AP, FA, CM, iExpense, EB Tax, Sys Admin (11i / R12).
• Expertise in Implementation of Oracle General Ledger, Accounts Payable, Accounts Receivables, Fixed assets, Cash Management, E-Business Tax, Sub ledger Accounting, Oracle Loans, and Financial Accounting Hub.
• Implementation experience in Multinational, Multi-currency, Multi-Org for Financials in Manufacturing, Banking, Finance and Service Sectors.
• Experience in setting FSG, Multi Organization structure, Multiple Reporting Currencies, Key and Descriptive flex fields and System Administrator functionalities.
• Good working knowledge and interpretation of financial statements such as retained earnings and balance sheet statements.
• Assisted client with the formation of a business case to migrate from legacy system to Oracle 11i & R12 systems.
• Created mapping for interfaces to existing systems and also data migration and conversion of legacy data into Oracle.
• AIM Methodology was referred for designing standard documents (MD-50, BR-100).
• Conducted and evaluated Business Process review, Map and Gap analysis to resolve business requirements not addressed by the applications.
• Designed and developed test scripts (TE-40s).
• Created training materials and also conducted several UATs and CRPs in Oracle ERP.
• Conducted end user training through instructor led sessions and virtual classes
• Strong analytical, diagnostic and troubleshooting skills with the ability to work in a fast-paced and team oriented environment.

TECHNICAL SKILLS

Tools: Data Loader, TOAD, SQL Developer, SQL Plus, MS Word/Excel/Visio/Project

ERP: Oracle 11i and R12

ERP Modules: GL, AGIS, AP, Oracle Payment, AR, CM, FA, PO, OM, EB Tax, ADI, Web ADI, INV, Costing, System Administration, Oracle iExpense, Oracle iProcurement, Workflow Administrator, Oracle Approvals Management (AME) and Application Developer

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

Oracle EBS Functional Lead

Responsibilities:

• Provided solutions for fresh implementation of Fixed Assets (FA) and E-Business Tax (EB Tax) Modules.
• Provided Solutions for open Issues on Accounts Payable (AP) and Purchasing Modules.
• Understood the existing business process for Fixed Assets and EB Tax which were maintained outside the Oracle EBS and are interfaced with Oracle GL to provide the month end information. Prepared BP 40 deliverable for the current Business Process as per AIM Methodology and presented the deliverable for signoff.
• Presented requirement questionnaire and gathered business requirements. Prepared RD 50 for requirement analysis as per AIM methodology and presented the deliverable for signoff.
• Gathered requirements for new enhancements in Payables like extension of AP Hold notification timeout, Supplier Cash Discounts, AP/AR Netting for some suppliers, setting up the supplier based tolerance limits to reduce the invoice hold counts and Invoice Approvals under AME.
• Upon the requirement deliverable signoff, prepared the Solution Design by mapping the requirement with Oracle standard functionality. Identified any gaps and delivered solutions in terms of Customizations, workarounds and any form personalization, wherever applicable
• Worked on end to end testing for P2P & O2C Processes for 12.1.3 upgrade (from 12.2.2) and resolved few upgrade issues.
• Performed the flow of iExpense Transaction to AP to Projects and capitalized those transactions to Fixed Assets.
• Prepared functional design document MD50 and closely coordinated with the technical team
• Constantly kept Project Management and Business stakeholders up to date with the status of the development activities
• Created a new Bank and Bank Accounts with all setups related to Payment Process Profile and template creation for the newly added Balancing Segment
• Conducted and configured modules for CRP1, CRP2 and UAT in different instances
• Conducted Super User Training to train and understand all the Super Users on the newly implemented modules and enhancements
• Created a detailed training manual for all configurations and customizations made on AP, EB Tax and FA modules
• Setup 2 new Corporate Books and 4 Tax Books associated to each of the Corporate Book
• Successfully completed setups in FA on Fiscal Calendars, Asset Books, Categories, and Depreciation Methods and worked on Mass Additions.
• For Corporate Books used WEB ADI to migrate complete legacy Assets data to Oracle and updated Tax Book data through FA TAX INTERFACE tables
• Taken care of O2C test scenarios and test cases review and providing sign off and co-ordinate with QACC.
• Documented the setup instructions and also prepared User Acceptance Test cases
• Utilized Data Loader to setup Calendars, Categories and other configurations for FA
• Solved issues related to tax books for different depreciation methods and prorate conventions in FA
• Implemented EB Tax for US - Regime to Rate flow with Rules and Exceptions, Self-assessment Taxes and Non-Recoverable taxes
• Worked on Rolling out the P2P Sub-Ledgers process to newly created Operating Units including Setting up iProcurement and Catalog Punch out process.
• Developed issue trackers to manage day to day transactions and document any issues
• Prepared Test Scripts TE40s intended for unit testing in FA (for Mass Additions, Mass Reclassification, Mass Transfer, Retirements and Reinstatements) and AP (for Tax calculation)
• Set up SLA for Fixed Assets with required customizations
• Involved in the month end closing process, generating reports and reconciliation after running the month end process.

Environment: Oracle Application R12, SCM (AP, AR, GL, PO, INV, OM, iExpense, iProcurement), OPM, SQL, PL/SQL, TOAD, EIS Reporting, P2P, O2C.

Confidential, Atlanta, GA

Oracle Functional Lead Consutlant

Responsibilities:

• Documented the Current Business Process detailing the ‘AS IS’ process in their legacy system (Solomon), future business process ‘TO BE’ and performed GAP analysis
• Interacted with the client team to understand the existing business practices and assisted in the preparation of business requirement definition document BR 30
• Created MD 50 for AP Check Printing & Remittance Advice
• Defined different expense templates for different business requirements
• Configured Accounts Payable for matching and non matching POs
• Configured Invoice Approval using AME for Invoices that are not matched to Purchase Orders
• Defined different payment process profiles for Check & Wire payments
• Prepare User Transaction Manual and Setup Manual documents of Oracle General Ledger and Oracle Financial Accounting Hub (FAH)
• Worked on Testing Business specific customizations for all modules of EBS and Discoverer reports
• Provided Production Support to resolve issues for P2P & O2C modules.
• Configured Approvals & Approval hierarchy in Purchasing for Requisition & Purchase Order Approval
• Defined payment terms, distribution sets, matching tolerances for purchase order matching
• Defined both single currency and multi-currency bank accounts
• Configured for integration of American Express Corporate Credit Card with i-Expenses & Accounts Payable
• Strong Understanding of the Business processes, Procure to Pay (P2P) and Order to Cash (O2C)
• Developed financial reports using FSG
• Worked on Enhancements covering P2P and O2C modules.
• Setup print statements customer report to be sent directly to email and Fax using bursting technology
• Created responsibilities with appropriate menu for users to restrict their access to application
• Provided Training to users, and Created User Manuals for PO, AP & IExpense modules
• Provided Post-production support in the Procure to Pay (P2P) Cycle

Environment: Oracle Apps 12.2.4 Modules: GL, AP, FA, EB Tax, PO.

Confidential, Bedford, MA

Functional Lead

Responsibilities:

• Configured a cloud model implementation on Release12.2.4.
• Involved in configuring P2P cycle using the requisitions from ISupplier portal which is on premise and imported to payables using the interface.
• Documented the Current Business Process detailing the ‘AS IS’ process in their legacy system (Cost point), future business processes ‘TO BE’ and performed GAP analysis.
• Interacted with the client team to understand the existing business practices and assisted in the preparation of business requirement definition document BR 30.
• Created MD 50 for supplier import, Invoice Interface API using flat files and GL code combinations.
• Working on Daily Production Issues across Finance Modules (AP, FA, GL, IEXP, PA, AR, OTL, OPM and iProcurement)
• Configured Approvals & Approval hierarchy in Payables for invoice approval based on the client requirement.

Environment: Oracle Apps 12.1.3 Modules: GL, AP, AR, PO, iExpenses.

Confidential

Upgrade to R12 for finance & distribution

Responsibilities:

• Interacted with client to gather the requirements to design and estimate the Application
• Provided post production support for financial and supply chain modules (Release 12) (AP, AR, GL, OM & PO, EB Tax, iExpenses, iProcurement)
• Analyzed existing business process to identify opportunities for enhanced functionality of Oracle
• Streamlined process for inter-company shipments and invoicing
• Provided support for month end closing, quarter end closing and reconciliation of Subledger with Oracle General Ledger
• Prepared detailed functional specifications for new/modified extensions, interfaces, reports and conversions.
• Worked on Testing Business specific customizations for all modules of EBS
• Analyzed data errors by executing SQL queries using TOAD
• Implemented US Sales Tax using the Regime to Rate Tax Flow in E-Business Tax
• Used form personalization to customize forms including form validations, defaulting values, providing user messages etc.,
• Worked with Oracle Support to resolve inconsistencies in Accounts Payable Trial Balance & Purchasing Accrual Reconciliation Report

Environment: Oracle Applications R12, AP, AR, GL, OM & PO, EB Tax, iExpenses, iProcurement, Oracle Process Manufacturing (OPM).

Confidential

Functional consultant

Responsibilities:

• Analyze existing business systems for the Order to Cash (O2C) cycle and document ‘AS-IS’ Business processes
• Identify gaps that cannot be accommodated using standard Oracle and suggest alternatives or workarounds
• Document high-level & detailed specifications for the customizations identified
• Present CRP sessions to the client for user sign off
• Provide training to the core team users
• Model the customer structure/hierarchy using Trading Community Architecture.
• Oracle ERP Cloud experience in General Ledger, Accounts Payable, Accounts Receivable, Asset Management and Cash Management.
• Integration of shipping with custom mobile applications built for hand-held devices.
• Develop specifications for complex pricing formulas to be used in Pricing modifiers & Price Lists
• Coordinate with the technical team for conversion of customers, customer item master cross reference, Open Orders in OM & Open Invoices in AR.
• Set up and configure Order Management, Shipping & Accounts Receivable modules.
• Worked closely with technical team to resolve issues.
• Configured for event-based revenue management.
• Provided Post Production support.

Environment: Oracle Applications 11.5.10.2, GL, AR, FA and CM, Sys Admin.

Confidential

Oracle Business Analyst

Responsibilities:

• Done the Flow testing for GL and AR, Designing Chart of Accounts Structure, Defining Accounting.
• Calendar, Functional Currency, Ledger, and Rollup Groups Summary Templates.
• Defining Collector, Aging Buckets, Auto Cash Rule Sets and Assign to Customer Profile Classes, Defining Statement Cycles, Dunning Letters and Dunning Letters sets
• Set up the customers and customer profile classes, Setting up Transaction types, Sources, Receipt classes and receipt sources, Setting up receivables activities, statement cycles and dunning letters.
• Involved in the Design and configuring the auto accounting on basis of transaction types, assisted in setting up Invoicing rules, accounting rules, remittance banks, distribution sets, Set up system options and profile options.
• Involved in Configuring and Setting up Auto invoicing (Grouping Rules, Line Ordering Rules), Setting up Consolidates sales invoice based on client requirement.

Environment: Oracle Applications 11.5.9, GL, AR, and CM.