SUMMARY:

• Strong Functional Experience in implementation, upgrading, customization and testing of Oracle Applications Financials R12 and 11i.
• Extensive experience in General Ledger, Account Payables, Account Receivables, PO, SLA, FA, AGIS, INV, EB - Tax, CE, iProcurement, iExpense, iSupplier.
• Experienced in Business Process flows for Procure-to-Pay (P2P), Order-to-Cash (O2C), Record-to-Report (R2R) by using AIM Methodology.
• Functional knowledge in implementation and system testing of core financial modules in R12 & 11i versions.
• Proficiency and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12 and 11i.

Financial Modules: General Ledger, Account Payables, Account Receivables, Fixed Asset, Cash Management, iExpense, SLADistribution Modules: Purchasing, Inventory, Order management, iProcurement

Tools: Toad, Dataloader, Web ADI, Microsoft office.

Methodology: AIM, OUM

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Lead Functional Consultant

Responsibilities:

• Lead Role in the project that involves gathering user requirements, planning the road map, Conducted CRP's, UAT for the implementation.
• Designed COA and Configured GL, AP, iExp, AR, SLA, AGIS for R12 Implementation.
• Implemented AGIS to create invoices in payables and receivables sub ledger from intercompany transactions.
• Implemented Multi Org - design,configuration the multi-org set up with multiple operating units.
• Implemented Accounts Receivable to process Auto Invoices from Project Billing, Receipts(Payments) in Multi-currency transactions.
• Customized SLA (Subledger Accounting) functionality in R12 to provide better matching of Liability and Expense accounting transactions on Payables invoices. For AR subledger to provide better matching of Receivables and Cash Receipt accounting.
• Implemented Electronic Payments(SEPA,DMTCHIP,AUTOFX) using EDI.
• Configured the Internal and External Banks for Fund Disbursements and Captures.
• Implemented iExpense to streamline and automated travel spend management and Established policy driven controls for expense reimbursement.

Confidential

Lead Functional Consultant

Responsibilities:

• Designed Chart of Account (COA) to provide Flexibility for Recording and Reporting Accounting Information.
• Configured Accounting Flexfield, Account Maintenance, Calendars, Currencies, Ledger and Legal Entity Setups, Data Access Sets, Document Sequences, Mass Allocations, GL Profile options and Transactions Processing.
• Configured the FSG to Create Balance Sheet and Profit Loss/Income Statements.
• Implemented iSupplier portal to View/Changes POs, Acknowledgements, Submit ASN, Create and View Invoices.
• Implemented Purchasing (PO) with 3-way match, INVENTORY, CM, Cash Management modules.
• Configured AP Financials, Payable System and Payables options, Vendors and Sites, Bank and Bank Account for Fund Disbursements.
• Implemented the Third Party Payments feature in AP.
• Created Mapping Documents for Supplier Sites, Items, OPEN PO, AP Invoices, conversions.
• Prepared Project Documentations, AS IS documents, Solution design document, BR100.
• Prepared Cutover Plan document, Monthly Closing Procedure etc.
• Used WebADI to Load Journals to the GL.

Confidential

Lead Functional Consultant

Responsibilities:

• Implemented a Highly Automated Financial processing system using Oracle EBS.
• Configured Accounting Flexfield, Account Maintenance, CVR's, Calendars, Currencies, Journal Controls, Journal Approvals, Ledger and Legal Entity Setups, Secondary Ledgers, Data Access Sets, Document Sequences, GL Profile options and Transactions Processing.
• Configured Mass Allocations, AGIS Setups in GL.
• Multi Org set-up - Responsible for implementing the multi-org set up with multiple operating and inventory orgs.
• Configured AR System options, Transaction Types, Receivable Activities, Receipt Classes, Receipt Method, Bank Accounts and Remittance process.
• Configured AP Financials, Payable System and Payables options, Vendors and Sites, Bank and Bank Account for Fund Disbursements.
• Automated the AP Payment Process by using the Electronic Fund Transfer (ACH) to reduce the load on Check Payment Process.
• Configured Approvals Management (AME) for AP Invoice Approval and Hold Notifications.
• Customized SLA (Subledger Accounting) functionality in R12 to provide Multiperiod Accounting for Deferred Expenses.
• Implemented Revenue Recognition program to generate the revenue distribution records for invoices and credit memos using Invoicing and Accounting Rules.

Confidential

Lead Functional Consultant

Responsibilities:

• Prepared Project Documentation, Requirement Document, Future Requirement Document, Solution Design Document, Test Scripts, Setup Documents and Training documents.
• Customized Standard Purchase Orders to communicate Report (Print) the purchase details to the suppliers.
• Configured AP Financials, Payable System and Payables options, Vendors and Sites.
• Configured Bank, Branch, Account, Payment Processing Profile (PPP) Setup for Funds Disbursements and Capture.
• Automated the AP Payment Process by using the Electronic Fund Transfer (ACH) to reduce the load on Check Payment Process.
• Customized SLA (Subledger Accounting) functionality in R12 to provide better matching of Liability and Expense accounting transactions on Payables invoices.
• Implemented the accounting rules using SLA functionality is modified for Accum Depreciation, Revaluations transactions in FA using standard SLA configuration and setups.
• Configured AR System options, Transaction Types, Receivable Activities, Receipt Classes, Receipt Method, Bank Accounts and Remittance process.
• Configured AP/AR Netting automatically compares Payables to Receivables and created the appropriate transaction in each system to net supplier invoices and customer invoices.

Confidential

Lead Functional Consultant

Responsibilities:

• Coordinated and led the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules in R12 environment.
• Designed rollup groups, Security rules, Data Access Set, Intercompany accounts, summary accounts, account aliases. Defined currency translation.
• Implemented AR Invoices and Credit Memos are interfaced from iHub to EBS.
• Customer Information are interfaced to EBS.
• Implemented Lockbox to apply Receipts to AR Invoices.
• Implemented Revenue Recognition program to generate the revenue distribution records for invoices and credit memos using Invoicing and Accounting Rules.
• Configured AP Financials, Payable System and Payables options, Vendors and Sites.
• Lead Role in the Internet Expense (iExpense) project that involves gathering user requirements, planning the road map for the implementation
• Performed detailed setups in Internet Expense involving defining templates, policies, rules based on business requirements
• Implemented the credit card functionality into Internet Expense with Confidential .
• Customized Account Generator Oracle Workflow process using Workflow Builder for Project Accounting to default the line level expense account from the project
• Created MD50 using AIM Methodology for conversion of employee type supplier in Payables for iExpense.
• Implemented Project Costing and Accounting: actuals (expenditures) are incurred for a project. Type of expenditure: Pre-approved expenditure and expenditures from Oracle Payables.
• Customized Subledger Accounting (SLA) ADR, JLD, Application Accounting Definitions for Accounts Receivables.
• Monitored UAT Process and solved Functional issues related to AP, AR, GL and iExpense.
• Worked with Oracle Support to fix various issues while implementing AP, AR, Internet Expense

Confidential

Functional Consultant

Responsibilities:

• Implemented Procure-to-Pay process for the integration of newly acquired wireline business units into their existing R12 environment.
• Involved in Config Document (BR100), Functional Design (MD50) and TE040 documents.
• Configured iProcurement web based module that allows users to create requisitions from shopping lists and receiving items.
• Configured Payable option, Bank, Branch, Account, Payment Processing Profile (PPP) Setup and Payment Process Request (PPR) for Check and EFT payments.
• Worked on Approval workflow process to Requisitions and PO
• Requisition creation program called from Order Orchestrator.
• Customized API which imports the requisitions from Legacy into Oracle Purchasing.
• Monitored UAT Process and solved Functional issues.
• Identified client GAPs in solution design. Based on this we suggested for customizations.
• Preparation of Project Documentation, Requirement Document, Future Requirement Document, Solution Design Document, Test Scripts, Setup Documents and Training documents.
• Implemented Internal Sales Order for MRP.
• Configuration of Sales Order Booking, Releasing, Ship Confirmation, Order Information portal, AutoInvoice Process, Receipt Reconciliation.
• Implemented accurate financial records of assets for financial and income tax reporting in FA.
• Using Dataloader Tool to setup Data in various Instances.

Confidential

Functional Consultant

Responsibilities:

• Involved in gathering business requirements for Procure-to-Pay.
• Designed Future requirement in GL, SLA, AP,AR, Projects Modules
• Involved in Config Document (BR100), Functional Design(MD50), Technical Design(MD70) and TE040 documents.
• Involved in Setting up of Test instance for CRP1
• Implemented and tested Oracle Applications, Financial R12 General Ledger, Accounts Payables AR and iExpense modules.
• Monitored UAT Process and solved Functional issues in GL, AP, AR, iExpense.
• Identified client GAPs in solution design. Based on this we suggested for customizations.
• Implemented AGIS to create invoices in payables and receivables sub ledger from intercompany transactions.
• Preparation of Project Documentation, Requirement Document, Future Requirement Document, Solution Design Document, Test Scripts, Setup Documents and Training documents.
• Designed Key Accounting Flex field structure, Chart of Accounts with Multi Org. Defined rollup groups, security rules, Intercompany accounts, summary accounts, account aliases, encumbrance types. Defined currency translation.
• Designed Receivable Activities, Distribution sets, Receipt Classes & Receipt sources.
• Configured Bank, Branch, Account and Payment Processing profile Setup for Check and EFT payments.. iExpense setup, Audit information, workflow process and Configured User Interface.

Confidential

Functional Consultant

Responsibilities:

• Provided Procure to Pay process analysis for the integration of newly acquired business units into their existing 11i environment.
• Implemented procurement contracts with suppliers with terms and pricing.
• Designed Future requirement for Confidential in OM, AR, GL,AP,PO Modules
• Configuration of Sales Order Booking, Releasing, Ship Confirmation, Order Information portal.
• Involved in Solution Design using Future requirement document.
• Involved in Setting up of Test instance for CRP1and CRP 2
• Assisted Multi org set-up - Responsible for implementing the multi-org set up with multiple operating and inventory orgs.
• Setting up Banks and Defining Bank Account (Internal), Setting up Payment Terms, Distribution Sets.
• Involved in defining Recurring and Mass Allocation journals.
• Identifying Customization and get Clients Concurrence on Scope.
• Discussing Gaps and Work Around to be Stage with Client and obtain Concurrence.
• Worked on the Journal needs Workflow Approval process.
• Involved in monthly, quarterly and in monthly year-end closings of the books.
• Developed Alerts in OM: Unsettled Orders More Than 3 Days from Entered Date Alert OM: Custom Current Month Sales.

Confidential

Functional Consultant

Responsibilities:

• Preparation of Project Documentation, AS IS documents Future requirement document, Solution design document, BR 100 and CV 40.
• Implemented the rules both suppliers and employees will follow to create and track RFQ's and to create a PO's.
• Involved in preparation PO’s Like Standard, Planned, Contract & Blanket.
• Prepared Training Manuals for UAT
• Involved in Setting up of test instance in GL AP AR.
• Involved in Setting up Mass Allocation, Consolidation and FSG Reports.
• Tested Consolidations and Mass allocations in General Ledger.
• Tested standard reports in Oracle Financials.
• Tested Invoice approvals in payables.
• Defined financial options, payable options, and setups for recurring journals, interest invoice, and automatic withholding tax invoices.
• Defined Receivable Activities, Distribution sets, Receipt Classes & Receipt sources in Receivables
• Tested the integration of business system flow between Payables, Receivables and General Ledger.
• Worked closely with the Oracle technical team to provide timely solutions