SUMMARY

• Over 11.5 years of industry experience
• Successfully implemented seven (7) complete (end - to-end) life cycle projects in Oracle Financials & SCM - GL, AR, AP, CM, FA, PO, OM, INV, AGIS, isupplier and Trade Management (AR Deductions)
• As an Oracle Apps Implementation specialist excellent experience with Sub-Ledger Accounting(SLA), E-business Tax, MOAC, AGIS, Payments, iPayments, Credit Card processing 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 knowledge 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

Management/Leadership Skills: Project Lead & Finance & SCM Functional Lead

PROFESSIONAL EXPERIENCE

Confidential, MI

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

Responsibilities:

• Working on application enhancements like implement Automation of Payments to dealers (EFT or ACH), Journal approval with custom hierarchy, Sending Remittance Advises to Dealers interface between oracle and Easy links etc…
• Worked on deferent enhancements testing
• Worked on fixing application upgrade issues
• Prepare Functional Design documents (MD050) for enhancements
• Worked on configuration changes and application testing as part of business process improvement
• 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

Confidential, Libertyville, IL

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

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
• Worked on Post production support

Confidential, Plymouth, MI

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

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 Management for 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

Confidential, TX

Senior Oracle Financial Functional lead

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

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 that 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

Confidential .Houston, TX

Senior Oracle Financial Functional lead - R12 Upgrade & Production support

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

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

Confidential Stratford, ON

Senior Oracle Financial Functional lead

Environnent: Oracle Apps. R 11.5.10.2 on Linux and Oracle 10g

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 Business Process 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

Confidential, Marion, IL

Senior Oracle Financial Functional lead - Implementation

Environnent: Oracle Apps. 11.5.10.2 on Linux and Oracle 11.1.0.7.0

Responsibilities:

• As-is system study and documentation for mapping and gap analysis
• Gathered client requirements by interacting with business managers and 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 Set of books,, 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

Confidential, San Diego, CA

Senior Oracle Financial Functional Consultant

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

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

Confidential, Atlanta, G

Oracle Financial Functional Consultant - Application Implementation

Environnent: Oracle Apps 11.5.10 on Linux, Oracle 10g

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

Confidential

Oracle Financial Implementation specialist

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

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 DHL D2P
• 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

Confidential

Oracle Financial Consultant

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

Responsibilities:

• Provided post implementation support and Configured the application for new organization established in Confidential 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

Confidential

Implementation of Oracle 11i & Post Implementation support

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

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 DHL D2P
• 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
• Business study, Gap analysis, Mapping.
• Prepared 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), P2P(Procure to Pay) Cycles, Oracle Projects and Fixed Assets of the application
• Understanding of client requirements, Interacted with process champions to understand the processes involved in the company around the modules
• Designed Chart Of Accounts, Set Of Books and Organizations for NACHo
• Defined FSG Templates for Income Statements and Balance Sheet
• Tested the application Integration across the modules