SUMMARY

• Over 11 years of experiencein Oracle E - business Suite Application as a Functional Consultant.
• Working with Confidential . in Rockville, MD as Oracle Functional Lead
• Worked with Confidential, MIas Lead Consultant for Oracle financials
• Worked with Confidential as a Functional Lead on Oracle O2C and P2P
• Worked with Confidential as an Oracle Financial Functional Lead
• Worked with Confidential as an oracle on-site functional lead
• Worked with Paradigm Geophysical as an Oracle financial functional Lead consultant
• Worked with Capgemini Consulting as senior Oracle Financial Consultant
• Worked in Cambridge, India,as a Track Lead, for Oracle Financial Modules
• Extensive Oracle Financials experience in design, development and Implementations, roll-outs, system upgrades, integrations, process re-engineering, requirements gathering, fit and gap analysis, system setups, interfaces, extensions, training & support
• Successfully implemented seven (7) complete (end-to-end) life cycle projects in Oracle Financials& SCM - GL, AR, AP, CM, FA, PO, OM, INV, AGIS,ipayments, isupplier andTrade Management (AR Deductions)
• As an Oracle Apps Implementation specialistexcellent experience with Sub-Ledger Accounting(SLA), E-business Tax, MOAC, AGIS, Payments and TCA
• Excellent support experience on period closing process and trouble shooting for AP,AR, Inventory and Purchasing (Sub-ledger reconciliations with GL)
• Subject Matter Expert in processes like Procure-to-Pay, Order-to-Cash, General Ledger and Fixed Assets
• Worked on Upgrade Projects from 11.5.8 to 11.5.10.2 and 11.5.10 to 12.1.3.
• Worked and contributed in Data conversion, data Interfaces, reporting requirements
• Prepared implementation Documents by using Oracle AIM methodology (RD20, BP80, BR100, MD50 and TE40), good understanding in various Oracle related products like SQL, PL/SQL, Reports Builder, forms Builder, XML Reports, Discoverer and various Oracle tools.
• Expertise in Oracle E-Business suite, Oracle Technologies PL/SQL, SQL*Loader, TOAD, SQL Plus.
• Functional noledge and implementation experience in industries like Telecom, Finance, Manufacturing and Distribution industries.

TECHNICAL SKILLS

• Oracle E-Business Suite 11i& R12:Accounts Payable (AP)
• Accounts Receivable (AR)
• General Ledger (GL)
• Cash Management(CM)
• Fixed Assets (FA)
• Advanced Collections
• Trade Management
• Inventory (INV)
• Purchasing (PO)
• Order Management (OM)
• Sub-ledger Accounting
• E-Business Tax
• Multi Org access control
• TCA

PROJECT EXPERIENCE

Confidential, MD

Cost Management, AP and FA

Responsibilities:

• Gather and review business requirements to implement International Financial Reporting Standards (IFRS).
• Analyze, design and setup the Oracle EBS system as per IFRS reporting requirements.
• Prepare documents like user requirement speciation (URS), Functional Requirement Specification (FRS), System setup and Installation Plan (SSIP) documents.
• Implemented Sub-ledger level Secondary Ledgers for IFRS reporting purposes under existing USGAAP Primary Ledgers
• Configure E-Business system to enable Periodic Weighted Average Costing (PWAC) to value inventory with Periodic Average Cost of the Items
• Work with Development team to customize the E-business suite to meeting reporting requirements of IFRS.
• Develop and execute quality assurance test plans for unit, system and regression testing.
• Conduct User Training sessions.

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, MI

FA and HRMS

Responsibilities:

• Worked on application enhancements to implement better business process
• Prepare Functional Design documents for enhancements
• Building a process for reconciliation strategy between systems (Oracle apps and legacy systems)
• Responsible to resolve production issues around oracle Financials modules (GL, AP and FA)
• Working on Report requirement analysis and testing of reports

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, IL

Cost Management and E-BTax

Responsibilities:

• Prepared Functional Design Document by studying existing business process
• Prepared BR100s (Application Configuration documents)
• Conducted meetings and interacted with business managers to gather requirements and understand the business process
• Configured a Ledger, Legal Entity, Operating Unit and virtual Inventory Orgs for Ireland Location
• Worked on defining& trouble shooting Pricing Formulas and Price Lists in Advanced Pricing for Customer Price list and Intercompany Price List
• Configured OM, AR, AP, GL, PO and Inventory applications
• Tested O2C and P2P cycles including GL as part of Development Unit Testing
• Co-ordinate with testing team to prepare test cases & support UAT issues
• Worked on defining Shipping networks and Intercompany relation ships
• Conduct daily meetings with offshore to get the status and report to business owners
• Working on Post production support

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, Plymouth, MI

AP

Responsibilities:

• Prepared As-is document by studying current system (JBA) and prepared a mapping document for gap analysis
• Worked on complete design of O2C and P2P including inbound and outbound interfaces with legacy systems like (AS400, EDI etc..)
• Conducted CRPs and interacted with business managers to gather requirements and understand the business process in the company around the modules
• Prepared the documents like RD20s (Requirement Gathering), Business Process flows (BP), BR100s (Application Configuration), MD50s (Functional Design), and Test Scripts)
• Configured Ledgers, Legal Entities, Operating units and Sub Ledger accounting options(SLA) by using accounting setup Manager
• Configured OM, AR, AP, GL and cash management applications
• Worked on designing and testing of on Sales Order interface, shipping interface from (Avatar) system to Order Entry
• Worked on Interface design with AS400 and Oracle Receivables and Inventory for AR invoices shipping transactions
• Worked on isupplier portal to configure ASBN system for Import procurement (overseas purchases)
• Designed Chart of Accounts as per reporting requirements of the company in Income statements, Balance Sheets, and Budget reports etc.
• Prepared Data mapping sheets for Supplier, Customer, AP invoices, AR Invoices, Open Orders, Employee and GL Balances Conversions
• Designed various reports in Accounts receivables for Sales Commission, Gross Margin, Royalty Calculation, Custom Customer statements, OE Sales Planning Report, reports for tracking the Material in in-transit (Import system) etc.
• Designed and test an interface between legacy system to AR for AR invoice interface (Sales from Future3 System)
• Designed an extension on Auto Accounting to derive the Revenue Accounting values by sale type
• Worked on Trade Managementfor AR Deductions
• Implemented Advanced Collections module to track the payment history and customers call history
• Worked on setup Auto Lock, Application Rule set, Auto Cash Rules and Matching rules and in support of trouble shoot of loading Lock data from Bank file
• Setup Cash Management application for Automatic Bank reconciliations and Bank transfers (Internal Bank transfer transactions)
• Worked on Month end closing processes for reconciliation of sub-ledgers (AP, AR, PO and Inventory) with GL and sales and shipping transaction with AS400

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, Houston, TX

Senior Oracle Financial Functional lead

Responsibilities:

• Worked on post upgrade application support and process enhancements
• Worked on analyzing, setup and testing of Sub-ledger Accounting for OPM Financials
• Conduct meetings to interact with business managers to gather requirements and understand the business process in the company and proposed solutions
• Conduct UATs for custom process & Reports developed
• Worked on PO account generation customization and testing dat is moved from 11i to R12
• Worked on setup new balancing segment, Inventory organization to separate business by product
• Worked on Web ADI templates to reconfigure as per the new balancing segment setup
• Interact with offshore team to get updates on a daily basis

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, Houston, TX

Senior Oracle Financial Functional lead

Responsibilities:

• Prepared As-is document by studying current system (11.5.10) and prepared a mapping document for gap analysis
• Involved in Pre-upgrade and post upgrade system assessment
• Worked on Pre-upgrade and post upgrade functional tasks like running sub-ledger accounting report, Sanity check of the system after upgrade etc..
• Worked on Post upgrade system setups like completing ledger setups, Assign legal entities and Balancing segment values to Ledgers, re-defining custom AP invoice foldersetc..
• Conducted CRPs and interacted with business managers to gather requirements and understand the business process in the company around the modules
• Worked on E-btax setups after upgrade process including Latin American Localizations
• Worked on custom SLA for depreciation account derivation in fixed assets
• Analyzed various application issues found during post upgrade testing process and applied patches
• Worked on AGIS requirements gathering, configurations and testing
• Configured payment templates in R12 for custom payment formats
• Involved testing of O2C end to end flow including revenue recognition
• Configured Account Receivables to integrate with service contracts and worked on Bill Presentment Architecture(BPA) and Balance Forward billing configuration
• Worked on Web ADI templates to reconfigure as per the R12 requirement
• Worked on Report manager to configure report templates
• Involved in post upgrade system testing including custom interfaces with Pivotal and Bizdoc.
• Worked on Argentina Localization to setup Withholding tax calculation and VAT calculations
• Interacted with offshore team to get updates on a daily basis

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, Stratford, ON

Senior Oracle Financial Functional lead

Responsibilities:

• Conducted CRPs and interacted with business managers to gather requirements and understand the business process in the company around the modules
• Prepared As-is document by studying current system (JBA) and prepared a mapping document for gap analysis
• Configured the Ledgers, legal entities, Operating units and Sub Ledger accounting options(SLA) by using accounting setup Manager
• Worked on an interface design for Future3 and Oracle Inventory and AR for Sales and Shipping transactions
• Prepared the documents BusinessProcess flows, BR100s (Application Configuration), MD50s (Functional Design), and Test Scripts)
• Designed Chart of Accounts and report for Income statements, Balance Sheets, and Budget reports etc.
• Prepared Data mapping sheets for Supplier, Customer, AP invoices, AR Invoices, Employee and GL Balances Conversions
• Implemented Canadian Sales Tax (HST) for Payables and receivables
• Configured Account Payables (AP) to support multiple currency transactions and designed various report to calculate the un-realized gain/loss report
• Setup the Cash Management application for Automatic Bank reconciliations and Bank transfers (Internal Bank transfer transactions)
• Worked on Month end closing processes for reconciliation of sub-ledgers (AP, AR, PO and Inventory) with GL and sales and shipping transaction with AS400

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, Marion, IL

Senior Oracle Financial Functional lead

Responsibilities:

• As-is system studyand documentation for mapping and gap analysis
• Gathered client requirements by interacting with business managersand understanding the processes involved in the company around the modules
• Prepared the documents like RD20s (Requirement Gathering), Business Process flows, BR100s (Application Configuration), MD50s (Functional Design), TE40s (Application Test Scripts)
• Designed Chart of Accounts, Summary Accounts, FSG Templates for various reports (Income statements, Balance Sheets and Budget reports)
• Configured Ledgers,, legal entities, Operating units and Inventory Orgs
• Prepared Data mapping sheets for Supplier Conversion, Customer Conversion, Employee Conversion, GL Balances Conversion
• Worked on Intercompany Accounting
• Worked on Inventory month end closing process (trouble shoot pending Material transactions, Inventory adjustments etc..)
• Worked with Business Managers & System Admin team to prepare & configure list of user groups & responsibilities (Security Setup)
• Prepared test scenarios for SIT and UAT for all financial modules.
• Designed few report like Budget Detailed report, Use Tax Report, Sales Report etc…
• Defined Bank Mapping codes to load BAI2 bank statements by using Bank statement loader program
• Worked on Month end closing processes for reconciliation of sub-ledgers (AP, AR, PO and Inventory) with GL and sales and shipping transaction with AS400

Environnent: Oracle Apps. R 12.1.3 on Linux and Oracle 11.2.0.3.0

Confidential, San Diego, CA

Senior Oracle Financial Functional Consultant

Responsibilities:

• As-is system study and documentation for mapping and gap analysis
• Gathered client requirements by interacting with process champions and understanding the processes involved in the company around the modules
• Worked on multiple extensions to fill the gaps (an Extension on Auto Invoice, COGS and Revenue Recognition etc.)
• Prepared the documents like MD50s (Functional Design), BR100s (Application Configuration), and Application Test Scripts
• WorkedSales Order Interface and tested from POS (Point of sale) to Oracle TIBCO as a middle ware
• As a Senior Oracle Functional consultant, I am involved in configuring the Oracle Payables, Receivables, Order Management, as per business requirements and supporting issues of iPayment.Supporting issues regarding Credit Card payment processing
• Worked on a Form to define Instant Rebate and Credit Note Agreements starting from design, testing and implementation
• Involved in SIT and UAT to test the application end to end, including interfaces and extensions.

Environnent: Oracle Apps 11.5.10 on Linux, TIBCO, Oracle 10g

Confidential, Atlanta, GA

Oracle Financial Functional Consultant

Responsibilities:

• Prepared the documents like Business Process Flows, BR100s (Application Configuration), TE40s (Application Test Scripts)
• Existing system study and documentation for mapping and gap analysis
• Designed an Interface between External Asset tracking System (COEP) and Fixed Assets
• Involved in designing the interface between external Purchasing system (CCP) with Oracle Purchasing and Projects.
• Configured AP, FA modules as per the interface requirement.
• Imparted training to end users and prepared training manuals for all processes around the modules
• Interacted with business users and process managers for Requirement Gathering
• Coordinated with technical team on customizing reports and forms

Environnent: Oracle Apps 11.5.10 on Linux, Oracle 10g

Confidential, UK

Oracle Financial Implementation specialist

Responsibilities:

Responsibilities:

• Prepared the documents like RD20s (Requirement Gathering), BP80s (Future Business Process), BR100s (Application Configuration), TE40s (Application Test Scripts)
• Configured the complete O2C (Order to Cash) and P2P(Procure to Pay) Cycles of the application
• Designed Chart of accounts and configured the set of book and Organization for Confidential
• Defined Financial Statement Generator(FSG) - templates for Income statements and Balance Sheet
• Defined Invoice attributes like Payment Terms, Distribution sets, Expense Report Templates and Invoice tolerances
• Defined payment attributes like Payment Formats, Banks and Bank Accounts and Interest Rates
• Tested the application Integration across the modules

Environnent: 11.5.10 on Linux, BPEL, Oracle 10g / 9i

Confidential

Oracle Financial Consultant

Responsibilities:

• Provided post implementation support and Configured the application for new organization established in UCAL for the modules GL, AP, AR and CE
• Prepared the BR100 - Module configuration documents and TE40s, Application Test scripts
• Imparted training to end users and prepared training manuals for all processes around the modules
• Business requirements gathering by meetings with business and process owners to understand the processes involved in the company around the modules
• As-is system study and documentation for mapping and gap analysis
• Designed and configured Multi Organization structure (New operating Unit definition)
• Coordinated with technical team on customizing reports and forms

Environnent: Oracle Apps 11.5.8 /11.5.10 on Linux,Oracle 10g / 9i

Confidential

Implementation of Oracle

Responsibilities:

• Prepared various documents like MD.050, RD20s (Requirement Gathering), BP80s (Future Business Process), BR100s (Application Configuration), TE40s (Application Test Scripts)
• Configured the complete O2C (Order to Cash) and P2P(Procure to Pay) Cycles of the application
• Designed Chart of accounts and configured the set of book and Organization for Confidential
• Defined Financial Statement Generator(FSG) - templates for Income statements and Balance Sheet
• Defined Invoice attributes like Payment Terms, Distribution sets, Expense Report Templates and Invoice tolerances
• Defined payment attributes like Payment Formats, Banks and Bank Accounts and Interest Rates
• Custom solutions were designed using Oracle forms, Reports and PL/SQL public APIs.
• Tested the application Integration across the modules

Environment: Oracle Applications 11.5.10 on Linux, Oracle 10g, Developer 2000, PL/SQL