SUMMARY

• Over 7+ years of experience in ERP Oracle Application E - Business suite on 11i and R12 implementation, Support and upgrade projects on Oracle Applications.
• Worked extensively as Oracle Apps Functional Consultant in modules like Oracle General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CE), Order Management (OM), Advanced Pricing, Purchase Orders (PO) and Inventory (INV).
• Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P).
• Experience in Implementation of Procure to Pay(P2P) and Order to Cash(O2C) Process, training users on ORACLE Applications from 11i to R12 version.
• Expertise in the Application Implementation Methodology(AIM),FunctionalDesignDocumentation, Configuration of Applications, Testing, End-User Training.
• Experience with end-to-end complete ERP implementation and support. Very strong Business/Functional knowledge, experience. Multiple full life cycle implementations of Oracle Applications.
• Expertise in Requirements Gathering, GAP Analysis, Business Process Re-Engineering, Functional Design, Modeling Business Structures, Configuration, Testing, User Training, User Manual and Production Support.
• Implementation experience in General Ledger, Purchasing, Accounts Payables, Account Receivables, E-Business Tax, Multi-Org, Multiple Reporting Currencies, Sub Ledger Accounting, Order Management, Inventory, Web ADI
• Experience in building Forms, generating Reports and registering them as concurrent programs in Oracle applications using AOL (Application Object Library).
• Participated in multiple Oracle apps 11i implementations in multiorg/multicurrency scenarios, Order management and worked as areas involving Pricing, Purchasing, and Inventory.
• Expertise in interacting with customers at multiple levels in a variety of industries & business segments.
• Structural and methodical in approaching a problem resolution.
• Strong analytical and communication skills.

TECHNICAL SKILLS

ERP Skills: Financials (GL, AP, AR, FA, CM, PO), SLA, iExpenses, OM, INV, Advanced Pricing

ERP Methodology: AIM

Oracle Applications: Versions R12 (12.1.3/12.1.1/12.0.6/12.0.4 ) / Versions 11i (11.5.10/11.5.9/11.5.8 ).

Databases: Oracle RDBMS (Oracle 10g/9i/8i/8/7).

Utility tools: SQL Developer, OBIEE

Programming Languages: SQL, PL/SQL.

Hardware/OS: Linux, Sun Solaris 5.5, Windows.

Project Management Tools: Microsoft Projects, MS Office & Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Functional Consultant

Responsibilities:

• Assisted customers to provide production support for the e-Business Suite Application to end users which includes providing Functional Support for the issues encountered by users.
• Logged Service Requests with Oracle as needed to resolve user issues and tested the solutions as provided by Oracle.
• Pre upgrade testing and Post upgrade production live support.
• Worked on the application setups in Oracle E-Business Suite for Entities like US / Canada being migrated from Legacy system to Oracle.
• Installed and implemented the OATS in-order to automate the Load Test - different Modules.
• Developed the Open Scripts for the financial modules like Accounts Payables, General Ledger and Payments using OATS.
• Debugged/supported the users while having issues in developing the Open Scripts.
• Performed the testing for the new application setups using OATS (Oracle Application Testing Suite).
• Assisted with the CRP testing and trained the new users.
• Defined Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in AccountsPayables.
• Configured the setups for prepayment to employees and defined employee expense report.
• Helped the technical team in the supplier conversion, Open Accounts Payable invoices and paymentsconversion.
• Designed and Developed the Payment Process Templates for the Garnishments,Flexible Spending accounts, Intercompany and Convention.Also, Defined the Payment Process Profiles like Check, Electronic, EFT and Wire based upon the requirement.
• Worked closely with DBA in applying the Data fix Patching and involved in regression testing related to the Payables and Payments.
• Implemented the new R12 MOAC feature to the different Operating Units.
• Configured the Automatic Debit Memo Creation in AP when a Return to Supplier is performed in Purchasing and worked on issues related to it with the users.
• Worked on the setups related to Cash Management like Bank Setups, Transactions Codes and Bank Statements.
• Designed and setup automatic process to import the Bank Statements through Interface and Auto reconciled the Transactions.
• Manually Reconciled the Unreconciled transactions during the Auto Reconcile process.
• Performed the Accounts Payables and Bank Statements reconciliation.

Environment: Oracle Applications R 12.1.3, PO, AP, FA, AR, GL, i-Store, iExpenses, OM andLinux x86-64.

Confidential, Hightstown, NJ

Oracle Financial GL Lead

Responsibilities:

• Gathered Business Requirements from the Business for Atlas Physical Separation Project where Confidential Financial (MHF) obtains a new physical instance where as The Confidential Education (MHE) retains the existing physical instance.
• Initiated in identifying the Issues and Risks involved in the Atlas Physical Separation Project and provided the Action plans to meet the critical milestones ahead.
• Integrated with the Design and Architecture of separated BST applications that are currently shared.
• Involved with study of existing system, preparing the Functional design (MD50) to extract data from legacy system into Oracle Applications open interface tables.
• Involved in enhancing functionality and testing iniProcurement. Good knowledge in Workflow for Requisition Approvals.
• Involved in the Project Planning and Kick-Off Meeting Sessions for SIT,UAT, MOCKs and Go-Live.
• Performed unit testing and help the user with the testing, Identifies and fix the bugs before the Go-Live.
• Performed the E Business Tax (EBTax) setups which includeSALES and USE Tax: Tax Statuses, Tax Rates, Tax Determining Factor Sets, Tax Condition sets and Tax Rules per STATE, COUNTY and CITY as per the business needs.
• Designedthe chart of account and multi-org structure.
• Configuredchart of accounts, accounting calendar, Ledger, Ledger Sets and Data Access set.
• Defined the currency conversion rate types ( Corporate Daily, Monthly, Average rates) and run Historical rates process while opening balances.
• Configuredconsolidation definition.
• Designed and configured FSG reports based on requirements.
• Modified the Cross-validation rules as per the Business Requirements for both MHF and MHE.
• Involved in Huge COA Maitainence related tasks. End-dating the old MHE Ledgers, Organizations and Chart of Account Values in the MHF and vice versa.
• Executed Trial Balance Snap shot for both MHF and MHE for Reconciliation of GL Balances.
• Disabled MHE code combinations in MHF Instance and vice-versa. Worked on the Translation Engine- Mappings from Lawson - Oracle and Oracle to Lawson.
• Developed the Functional Desgins (MD50’s) for COA Extract to feed the Legacy sytems for MHF.
• Removed/ Disabled MHE specific customizations and Interfaces in MHF Instance and vice-versa.
• Developed a Custom API with the help of Oracle to Load the Cross-Validation Rules in high-volume.
• Defined the Global to Local Chart of Account Mappings for specific countries.
• Setup of Journal Reversal Criteria, Journal Authorization Limits and Journal approval flow for Manual Journal Entities.
• Worked on the Security rules to rescrict MHF User access to MHE data to inquiry only in MHF Instance and vice-versa.
• Updated the EIM table to distinguish between MHF and MHE files. Created separate GL Maestro Book Close calendars for MHE & MHF. Run the Journal Security ON/OFF Prgm for both the MHF and MHE.
• Reviewed WEBADI Kick-outs and resolved the issues along with maintenance if needed.
• Provided documentation for the Month end, Yearend closing process for the financial Modules to facilitate proper and timely closing of the accounting period.
• Developed Ad-Hoc views on GL Balances, Unit Code Hierarchy, Code Combinations, Monthly YTD amounts by month etc.,
• Implemented Accounts Payable module. Setup payables options, financial options, Payment System, payment process profiles, Payment process templates, Bank accounts,Tolerance limits.
• Defined the tax codes for withholding taxes and set up the invoice approval workflow in Accounts Payables (AP).
• Designed and setup inbound process to import invoices and from external sources.
• Designed and setup outbound process to send the paymnet information to Bank and thirdparty systems.
• Designed AP payment files for SEPA payment and HSBC payments in XML format.
• Designed AP Invoice interface and Payment files for Deutsche bank bottom line checks, ACH and wire payments.
• Defined Sub ledger accounting rules (Account derivation rule) for custom journal line type AP accrual, AP liability account (Automatic offset at account level), Item expense account, Tax and withholding tax account etc.
• Developed new reports and customized seeded reports as per the client requirements like Printed Purchase Order Report,Invoice on Hold Report and Supplier Payment History Report.

Environment: Oracle Applications R 12.0.6, PO, AP, FA, AR, GL, iExpenses and Oracle11g, AOL & Sys Admin.

Confidential, Tampa, FL

Oracle Financial Business Analyst

Responsibilities:

• Responsible for Implementing Purchasing and Oracle General Ledger. Also provided production support for Payables and Purchasing.
• Interacted with client to gather the requirements and estimate the time lines.
• Provided production support in Procure to Pay modules (P2P) and facilitated to complete critical business process like Month end closing processetc.
• Implemented Procure to pay cycle: created the employees, setting up of buyer and creation of requisitions, RFQ,quotations, and PO (purchase order).
• Customized the PO Requisition Approval workflow to add custom approvers, additional validation, derivation and verification depending upon the business needs.
• Worked on setups in Purchasing in assigning approval assignments,approval groups, and approval hierarchy.
• Created organizations, inventory items, catalog RFQ, got approval from supplier in procure to pay cycle and customized the Purchase requisition and auto creation of a standard purchase order based on a quote and generated receipt.
• Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report.
• Provided online user training, created user manuals and best practice proposals for purchasing modules.
• Defined the Key Flex fields, Descriptive Flex fields, system security mapping, and currency conversion typeand loaded the daily rates.
• Enabled Multi-Org Access Control (MOAC) to process data and transactions more efficiently across NA/LATAM/EMEA operating units.
• Setup of Daily Transaction calendar, financial calendar and Pre-paid Calendar and attached them to the Ledger.
• Setup ofchart of accounts, accounting calendar, Ledger, Ledger Sets, Data Access set.
• Configured Security Rules, Cross-Validation Rules, Roll up Rules, consolidation definition.
• Design and configure FSG reports based on requirements.
• Using Captivate Tool prepared the User manuals and Training documents for Yearend/ Month end closing in Oracle General Ledger.
• Setup Refund process in Receivables to convert the credit memos in to AP invoice.
• Configured SLA to address special accounting requirements.
• Defined and configured Locations, Unit of Measure, Document types, System profiles, Item category, Flex-field.
• Set upAuto Invoice flow from Third party system to AR module to import invoices and on account credits.
• Involved in Set up of auto Bank Reconciliation process via CE (Cash Management) module, which provides for Automatic Generation of Reconciliation Accounting Entries, Automatic Recording of bank initiated activities, Automatic Reversal of rejected receipts, and the ability to clear payments and receipts before Reconciliation.
• Prepare test script for and train the end users with the new process.

Environment: Oracle Applications R12, PO, SLA, AR, AP, CM, SQL, PL/SQL, Discoverer, Oracle10g, Toad.

Confidential, Hoboken, NJ

Oracle P2P Functional Consultant

Responsibilities:

• Worked as interface between business groups, responsible for conducting negotiations on requirements, highlight the features of application and brought out the solutions and alternatives for existing business process.
• Identified the structure of Flex-fields, defined value sets and values for several descriptive flex fields in GL, AP and AR module.
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
• Created and maintained User Menu objects and created responsibilities assigned to users and set profile option.
• Implemented the setups for Payment types, Distribution Sets, Tolerances, Approval Limits, and Transaction Types, Item and supplier setups.
• Worked on payables open interface to import invoices and involved in Purchase Order matching. Validated the data and populated the Payablesinterfacetable through a Concurrent program.
• Implemented Employee-Supervisor Hierarchy for Invoice approvals in AP (AME).
• Reconciled the Trail Balance report in AP with GL and run the Payment reports to identify the in process/unaccounted transactions in AP as a part of AP PeriodClose process.
• Created training documents for standard invoice, payment invoice, recurring invoices, holds, credit memos, debit memos, and expense reports in AP.
• AR Setups are such as Transaction Types (Invoice Types), Auto Accounting Setups, and Configured Invoice Types with Order types, AR Batch sources, remit to addresses, Receipt Classes and Payment Methods.
• Worked on Auto invoice Import setup by defining transaction type, payment term, batch source, grouping rule, line order rule, and transaction flex-field.
• Categorized AR customers to identify Domestic and Internal customers and involved in creating Order Work Flow for order is booked before being invoiced or approval before being shipped.
• Created training documents for creating receipts by defining bank, receipt class, receipt source, and Auto cash rule set. Created Automatic receipt using lockbox.
• Created legal entities, Set of Books and defined the accounting setups in GL.
• Setup of accounting setups like accounting calendar, chart of accounts, primary currency.
• Created FSG reports using row set, column set, content set, and row order.
• Defined the value sets, uploaded the values into value sets using .CSV file.
• Developed the test scripts and scenarios for Inbound, Outbound processing in GL.
• Loaded balanced WEDADI journals and created End-user training document on WEDADI.
• Created training documents for creating all types of Journals like standard, statistical, suspense, batch journals, recurring journals, adjustment journals, reverse journals and encumbrances.
• Used ADI (Application Desktop integrator) with Excel for quickly creating and running financial reports.

Environment: Oracle Applications 11.5.10, GL, AP, AR, PO, Discoverer, Oracle9i, AOL & Sys Admin.

Confidential, Lake Forest, CA

Oracle Financial Functional Consultant

Responsibilities:

• Worked as a Functional Consultant in AR and AP modules implementation and testing.
• Identified Gaps between the Client’s Business process and Oracle financial application.
• Prepared future business process flows (BP080).
• Documented procure to pay process flow for the client and worked on the related interfaces.
• Created functional design specification documents (MD050) and worked with technical team to ensure that the technical development was done as per the specification.
• Involved in complex custom development scenarios like fund balance check before making payment, Policy & Claims Search Forms, automatic bank statement upload from FTP location, automatic EFT file upload etc.
• Worked on setups included Defined Invoice attributes- Payment Terms and Distribution Set,
• Special Calendar for Recurring Invoice, Payable Quick Codes, Entering Supplier and Site Information, Payment Attributes- Payment Formats, Bank Account, Payable Documents, Tax Code, Rates, Groups and Withholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
• Prepared test script to train the end users with the new process.
• Worked on period opening and closing process in AR and AP modules.

Environment: Oracle Applications 11i, AP, AR, SQL, PL/SQL, Discoverer, Oracle10g, Toad, UNIX.

Confidential

Oracle Functional Consultant

Responsibilities:

• Gathered and analysed the Confidential expense reports business process and reporting needs.
• Able to discuss the requirements with business users, turned the requirements into recommendations or alternatives, and then able to implement internet expenses.
• Prepared Set of operations and procedure manuals to assists management in operating more efficiently and effectively.
• Setup and configured the Oracle Internet Expenses in multi-org environment. Setup the expense report template, AMEX Credit Card Program. Defined the Policy Schedules, expense fields, audit rules.
• Worked with Development team and AMEX to feed the master data (AMEX Card data) and transaction data daily into Oracle Internet Expenses.
• Provided custom workflow solution for CTC related expense reports in Oracle Internet Expenses.

Environment: Oracle Application 11.5.10, Sun Solaris, Oracle 9i, Oracle Internet Expenses (OIE).