SUMMARY:

• 20 years of work experience, which includes over 12 years of hands - on experience in Oracle Applications.
• Extensive work experience in various Implementation and support projects in Oracle ERP application with good coverage in R12.
• Has rich experience of more than seven years in Finance domain having worked in various capacities and handled different roles.
• Well proficient in various modules of Financials and has worked in General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Credit Management, Advance Collections, Cash Management and also Oracle Purchasing.
• Certified in Oracle Workflow, Internal Controls Manager, Contracts management and Depot Repair.
• Proficient in Business Analysis and has undertaken scoping studies in the past for ERP Implementations.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Financial Functional Lead Consultant

Responsibilities:

• Solution design for AP, AR, Credit Management, Advance Collections, FA and Cash Management
• Configure setups for Fixed Assets AR, Credit Management, Advance Collections, AP and CM.
• Designed business process for matching options and configured the AP system to meet the requirement. Configured setups for multi-currency invoices, Payment formats like Check, Wire and EFT payments. Defined withholding tax, Employee expense template in AP. Process has been designed for purchase returns in Oracle payables system. Configured the setup for Batch invoices and Batch payments.
• Define Auto Lock Box, Automatic receipts and Auto Invoicing for AR and Customer setups
• Configured Sub-ledger accounting to meet the requirement.
• Worked on the end to end implementation of Credit & Collections Management module - maintaining customer data, defining credit analysis, credit management system options, customer credit classifications, defining hierarchical relationships, populate summary tables, periodic review cycles, assign credit usage rules, credit management workflows, defining scoring models, assigning credit analysts, defining automation rules, etc.
• Worked on Advance Collections - by setting up the Collection Engine, Collection Rules, Collectors and Dunning Plans.
• Worked on Advance Collections - defined the work queue nodes, setting up preconfigured elements, setup multi-level strategies, collector work queue nodes, setup metrics, etc.
• Cash Management System have been configured and tested to meet the auto reconciliation of bank statement with payments, receipts and Journal entries.
• Documented the requirements and provided as Is and To Be process, GAP, BR - 100 and Functional specks for reports and conversions.
• CRP1 proposed in January

Environment: R12 ERP Applications, Oracle Database 11g/10g databases, Main Frame

Confidential, New York

Oracle Financial Functional Lead Consultant

Responsibilities:

• Worked on the setups of GL, AP, AR, SLA, Channel Revenue Management, Advance Collections, AR Deductions Management, Credit Management, Payment Manager, Credit & Collection Management, E-Business Tax, i-Expense modules.
• Worked on setups of for the Auto Lock Box process for Bank of America and Wells Fargo bank
• Worked on the Credit Card integration with Oracle Payment Manager using the Verisign Credit Card Gateway.
• Worked on the Channel Revenue Management - worked on the supplier ship and debit, channel rebate and point of sale, price protection process, AR Deductions Settlement, etc.
• Worked on Advance Collections Implementation - defining scoring engine, strategies, dunning plans, collector work queue nodes, metrics, profile options, etc.
• Worked on the configuration of the TCA - defining parties, accounts, account sites, contacts, contact points, party relationships, account relationships, etc.
• Worked on the Credit and Collection Management module - credit and collection date patters, setup activity codes, delinquency policies, delinquency statements, credit insurance policies, credit and collection managers, assigning credit and collection information to customers, setting up workflow messages for credit and collections.
• Worked on the ACH process in Oracle AP - setup with Bank of America and Royal Bank of Canada.
• Worked on the Payment Manager integration with a credit card gateway for credit card authorization and settlement.
• Worked on the setups of the Auto Invoice in Oracle AR
• Worked o the setups of the Auto Lock Box in Oracle AR for Bank of America and Bank of Canada
• Worked on the configurations of the Revenue Recognition process in AR module
• Worked on the setups of the Auto Accounting process in Oracle AR module
• Worked on the definition of the System Options in Oracle AR
• Worked on the setups of the Transaction Types in Oracle AR
• 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.
• Implementation of Revenue Recognition process in Oracle AR module
• Worked on the Configuration on the Primary Ledger and Secondary Ledgers in GL
• Worked on the setups of the Ledger Sets and Data Access sets in Oracle GL
• Worked on Revaluation and Translation process in Oracle GL
• Worked on the Consolidation process in Oracle GL module
• Worked on the design of the chart of accounts in GL module
• Worked on the setups of the consolidation process in GL
• Worked on the setups of Data Access Sets and Ledger Sets in GL
• Worked on configuration of the Journal Sources in GL
• Worked on the Auto Invoice process for Invoicing in the AR Module.
• Worked on the ACH Process in AP module
• Worked on the configuration on the Payment manager in AP
• Worked on the AR/AP netting process in AP
• Worked on the bank setups in Oracle Cash management for AP
• Tax configuration included complete set of tax rule as part of tax Regime etc.

Environment: AR, AP, GL, Payment Manager, AGIS, Credit and Collection Manager, Cash Management modules.

Confidential, Boca Raton, FL

Oracle Financial Functional Consultant

Responsibilities:

• Providing Post-production support on all financials and module extensions based on the requirements. Also coordinating with Users during month end process in order to make the month end process smooth.
• Provide Year End support to Super Users
• Prepare documents for module and functional extensions of proposed changes as per the business requirements.
• Conducted numerous business meetings for all new proposed enhancements and prepare MD50 for complete functional design.
• Provide impact analysis on all proposed changes and process through change management process.
• Work on production issues resolution and follow up with Oracle SRs.

Environment: Oracle R11, ERP Applications, Oracle Database 11g/10g databases

Confidential, Irving, TX

Oracle Financial Functional Consultant

Responsibilities:

• Involved in support of Oracle Financials R12 and 11i with NCH an US based company
• Involved in multistage level of support for GL, AP, AR, Fixed Asset modules of Oracle This includes solving the tickets Responsible for all support related activities in resolving issues
• Troubleshoot problem areas in Business cycles especially Procure to Pay cycles as they get reported through tickets
• Coordination with other team members to get timely resolution of tickets raised in other modules
• Drawing Functional specification and design upgrade for functional process enhancement
• UAT testing for the above through test scripts based on Change requests
• Liaison with Oracle on SR related issues and getting tickets to closure
• Capturing key Metrics data for Quality and reporting to Top management on periodic basis.

Environment: Oracle R11, R12 ERP Application (e-Business suite), Oracle Database 11g/10g/9i databases

Confidential

Team Lead

Responsibilities:

• Involved in up gradation Implementation of Oracle Financials R12 with Almac an UK based Pharma company
• Liasoning with technical team for brief customization of P2P and O2S cycles as per Almac’s requirements
• Offshore Function team lead for conversions of current process to Be Process
• Responsible for onsite coordination in resolving issues
• Finalization of BR50 Documentation
• Carry out design and solution enhancement by capturing additional business needs/special business requirements

Environment: Environment: Oracle 11g (11.1.0.7), Oracle 10g RAC (10.2.0.5 & 10.2.0.4), Oracle ERP Applications 11.5.10 and R12.

Confidential, CA

Consultant

Responsibilities:

• Designed Key Accounting Flex field structure for Ledger with Multi Org and Multi Currency setup. Defined system controls, intercompany accounts, summary accounts, account aliases, journal sources, and journal categories. Defined various currencies for multi currency operations and currency translation, conversion, revaluation were done to meet the requirement. Cross validationrules have been setup for various GL codes.
• Defined Access sets to enter transactions across the operating units.
• Configure setups for Consolidation, Multi reporting currency.
• Designed business process for matching options and configured the AP system to meet the requirement. Configured setups for multi currency invoices, Payment formats like Check, Wire and EFT payments. Defined withholding tax, Employee expense template in AP. Process has been designed for purchase returns in Oracle payables system. Configured the setup for Batch invoices and Batch payments.
• Define Auto Lock Box, Automatic receipts and Auto Invoicing for AR and Customer setups
• Configured Sub-ledger accounting and Tax setups to meet the requirement.
• Cash Management System have been configured and tested to meet the auto reconciliation of bank statement with payments, receipts and Journal entries.
• Documented the requirements and provided As Is and To Be process, GAP, BR - 100 and Functional specks for reports and conversions.
• CRP was done and provided tests scripts for GL, AP and AR modules for UAT

Environment: R12 ERP Applications, Oracle Database 11g/10g databasesClient: Emirates Airlines, Dubai

Confidential

Oracle Financial Business Analyst

Responsibilities:

• Implementation of Oracle Financials for JAT Airways Belgrade Serbia.
• System study, Study of current process and GAP Analysis.
• Business restructuring of client’s key process to suit ERP requirements
• Finalization for implementation of Airline Chart of Accounts to suit compliance with IAS(International Accounting Standards)
• Visioning with core project members and end users to facilitate smooth progress of project.
• Co-ordinate with other project units for Implementation of RAPID (a Customized Airline based Accounts Receivables)
• Complete Implementation of Accounts payables in alignment with P2P cycle
• Complete Implementation of AR module .Also involved in providing functional inputs interfacing AR module with RAPID

Environment: Oracle 9i, 10g Database Server, Oracle ERP Applications 11.5.10.2

Confidential

Team Lead

Responsibilities:

• Team Lead fore Sourcing project for GE ENERGY in O2S (Order to Settlement and SSP5 both are Customized versions of Oracle Purchasing and Financial Modules.
• The main activities include Coordination to execute day-to-day activities, providing weekly status reports and making sure that SLA’s and other metrics of the project are met with
• Preparation of Project plans using dPMM models and Six sigma methodologies
• Function reviews of Test cases & Design plans
• Crisis Management by providing Root Cause analysis & managing change requests
• Providing support for proposal initiatives based on response to RFPs
• Time sheet management and controlling activities for team members
• Business and Process analysis for incorporating Functional enhancements for future Releases of the product
• Coordinate with key stake holders at onsite for future Business enhancements

Environment: Oracle 9i, 10g Database Server, Oracle ERP Applications 11.5.10.2

Confidential

Functional Consultant

Responsibilities:

• Involved in post implementation functionality enhancement s in Oracle Application 11i GL, AP, PO and FAmodules.
• Conducted study on current business processes, analyzed future state requirement and mapped them to Oracle functionality.
• Studied current system and replaced current process in Oracle Purchasing and Account Payables and Receivables
• Functional process designed for invoice matching solution, requisition and Purchase order approval process.
• Performed setups to meet the requirements in AP, GL, PO, FA and AR modules for functionality enhancement.
• Configured the setup for raising Batch invoices, Batch payments, multi currency invoice, cross currency payments and auto withholding tax on supplier invoice. New expense reports were defined.
• Setup of Transaction Sources, Types, Receipts and Auto Invoicing in AR.
• New Business process has been designed and configured setups for prepayments and adjustment to payment to suppliers and employees.
• Developed test plans and scripts and conducted testing for quality assurance.
• Prepared and provided the functional specks like MD - 50, MD - 70 and TE - 40.
• Identified process and reporting gaps and recommended solutions. Involved in Development and customization in coordination with Technical Team of several reports as per client specifications.

Environment: Oracle 9i, 10g Database Server, Oracle ERP Applications 11.5.10.2

Confidential

Oracle Apps 11i Financial Consultant

Responsibilities:

• Involved in Functional analysis of existing systems and databases and GAP analysis for implementation of 11i. Discussions with the client/users regarding the user’s requirement, limitations of existing database and proposed solution.
• Configured GL Key Accounting Flex field structure, Chart of Accounts, calendar, currencies. Defined cross validation rules, security rules, budgets. Defined intercompany accounts, account aliases. Defined currency translation, conversion, revaluation and Set the system profile options.
• Configure setups for Consolidation, Multi reporting currency and FSG reports.
• Designed organization structure consisting territory & location flex field structure. Defined transaction structure of transaction sources, quick codes, transaction types, receivable activities and classes, customers, customer profiles, Banks, lock box etc for AR.
• Define the system parameters such as banks, cash clearing, bank charges, and bank errors in AP.
• Defined system parameters, such as remittance and cash accounts for each bank and miscellaneous transactions in AR for Cash management.

Confidential

Oracle Financials 11i, Windows NT - Functional Consultant

Responsibilities:

• Evaluated the organizational structure and business needs for the chart of accounts through regular interaction with the client. This project involved setting up of Oracle GL, AP and AR
• Defined a set of books, built the chart of accounts, set up cross-validation rules, establish summary accounts and parent/child relationships, set up cross-validation rules and flex field security rules, set up the accounting calendar and maintain accounting periods
• Modified existing reports to in corporate changes and developed new FSG’s as per business requirement
• Prepared GL documentation using AIM’s document (BR100)
• Facilitate the technical team by providing functional information during data conversion from legacy system
• Worked with AP team for setting up payment terms, supplier/supplier sites, invoice tolerances, and lookups
• Assisted the AR team in customers, defined adjustment limits, transaction rules, sources and types, set up receipt classes, receipt sources, defined payment methods, and set up collection information and collectors

Environment: Oracle 9i, 10g Database Server, Oracle ERP Applications 11.5.10.2

Confidential

Consultant

Responsibilities:

• Part of Project group offering Domain related solutions to Project Matrix Units in Lotus Notes and also developed solution for intranet community
• Developed E share Trading & Brokering Activities packages in Lotus Notes Environment for group Investment companies.
• Advanced Methodologies for leading Corporates in Lotus Notes & Commerce.

Confidential

Manager - Finance

Responsibilities:

• Assist group managing directors to discharge his duties for the business affairs of the group:
• To oversee/supervise the accounting aspects of manufacturing activities of the group
• To handle the accounts of the trading divisions.
• To prepare timely accounting reports for the management.
• To get accounts of the group audited.

Confidential

Manager

Responsibilities:

• MIS Reporting for operational units, their costs analysis and implementation of costs control measures for efficient performance.
• Analysis of financial data, preparation of budgetary reports and wide range of management information.
• Co-ordination with various units’ Auditors in capacity of Internal Auditor to ensure compliance of Audit procedures and set standards including monitoring custodial records.
• Monitoring of finalization of accounts and preparation of balance sheet in co-ordination with Auditors.

Confidential

Finance Executive

Responsibilities:

• Prepare and maintain project cash flow forecasts and development of expense budget.
• Periodic generation of MIS as supportive inputs for top level decision making.
• Co-coordinating role in management of public issue in consultation with the company’s lead managers and co-managers.
• Involved in merchant banking and allied activities thereof for public issue management.
• Liaison with Banks and financial institutions for term loan syndications and working capital requirements.