SUMMARY

• A dedicated IT professional with over15+ yearsof extensive experience asOracle Application Functional Consultantin implementation, upgrade and customization ofOracle e - Business Suite Applications(R12, 11i).
• Involved in ERP Implementations, upgrades and support mainly inGeneral Ledger, Human Resource Management System (HRMS) Procure to Pay (P2P), Order to cash (O2C), Account Payables, Account Receivables, Fixed Assets, Cash Management, Purchasing (PO), Inventory (INV), Oracle Payments, Advanced Collections and Order Management (OM) and Advanced supply Chain Management (ASCP)modules.
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications.
• Defined payment terms, setup paymentprocess profiles and also configured thepaymentmanager.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Two full lifecycle Implementations R12 with GL, AP, AR, FA, CE, iProcurement, iReceivables, iExpenses, E-business tax and Sub ledger Accounting(SLA) .
• Designed process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
• Functional proficient inRICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Strong Knowledge of Application Implementation Methodology (AIM) and software Development Life Cycle (SDLC).
• Fair Knowledge in customizing existingOAFScreens, forms and reports as per business needs using OAF Substitutions.
• Dexterous in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g andXML Publisher(BI Publisher).
• Well versed with client server environment and tools likeSQL Plus, PL/SQL, SQL Loader, Toad, Oracle Forms, Oracle Reports, and Workflow.
• Expertise in requirement analysis, support, development, testing, documentation and design reviews
• Experience incustomizing oracle workflowssuch as the PO approval process, Order/Line Flow to send user notifications based on the business requirement.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support.

TECHNICAL SKILLS:

ERP: Oracle EBS R12, Oracle EBS 11i

SLA, E: Business Tax, Alerts and Report Manage

Operating Systems: Windows 7, Vista, XP, Linux

Office Applications: MS Outlook, Visio, MS Office, MS Project

Database Tools: TOAD, SQL Loader, Data Loader

Languages: SQL, PL/SQL, C, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Oracle Financials Functional Lead

Responsibilities:

• Identify process flow for GL/FA/AP and AR modules to introduce accounting activities to AR and FA
• Prepare chart of accounts structure to meet the Arbonne requirements. Business Process (BP080) Identified and configured as per Client’s Requirements to future segments in COA.
• Implement a Highly Automated Financial processing system using Oracle EBS.
• Worked on Payment Pipeline Process in Oracle Payments module which includes Inbound/Outbound Interfaces along with the custom Forms and XML reports to handle the paymentinformation.
• Worked on Check printing for payments to be made to suppliers, as per the Operating unit specifications.
• Responsible for setting up Check, Wire, ACH paymentsin Oracle Payments.
• Create PL/SQL stored procedures, functions and packages for moving the data from staging area to data-mart.
• Work with Oracle Receivable and Advanced Collections to integrate various modules.
• Perform AR and collection duties on a daily basis using Oracle
• Design and developed custom workflow Item types to send notifications from Concurrent Programs/PL-SQL procedures.
• Provided diagnostics utilizing SQL and PLSQL and drafted reports upon analysis completion
• Configure 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.
• Define Ledgers, Legal entities, Operating units and Inventory Organizations for Poland Operating Unit to identify project funding source category.
• Funds Disbursement through Decentralized Processing solution and Centralized Processing solution.
• Credit card Payment processing for both funds disbursement and Funds Capture Process.
• Define Corporate Books for managing assets. Defined asset cost, asset clearing, depreciation expense, accumulated depreciation, CIP cost, CIP Clearing, Depreciation Adjustment as Fixed assets accounting. Per client’s requirements.
• Define Straight Line Method (STL) asset depreciation and identified the use of the current Descriptive Flexfields in Purchasing into AP
• Create test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components. Prepared test scripts/smoke testing prior to user testing and Configuration of CRP and UAT instances.
• Document all the BR100 for all my setups for AP/GL/FA and AP modules.
• Develop test plan and testing scenarios for financials modules. Design Multi-Organization Structure including legal entities, operating units, primary and secondary ledgers. Conduct CRP and UAT sessions, preparation of test scripts.
• Use of AIM methodology for process various finance templates.

Confidential, Kansas City MO

Oracle Financials Functional Lead

Responsibilities:

• Conducted business requirement analysis and compared clients’ requirements with the available Oracle functions available with the module (Oracle AP, AR, FA, GL, OM, AC and PO).
• Documented requirement analysis and worked with programmers on technical details.
• Mapped and gapped requirements and specifications; and advised on customization.
• Involved in performance tuning of SQL queries
• Setup Oracle Paymentsfor Check, ACH, and OracleReceivables Pre-PaymentMethods.
• Created customer profile classes, attached paymentterms, collectors, matching receipts, statement cycle to profile classes
• Designed and Developed necessary feeder system i.e. staging tables, validation routines using SQL* Loader, SQL and PL/SQL procedures
• Prepared Chart of Accounts and Set of Books for Single and Multi-organization structures.
• Prepared set-up document and carried out set-ups. Prepared module conversion design specification.
• Prepared module test scripts and participated in CRP testing. Assisted with transfer, conversion and customization of legacy data to Oracle Database.
• Responsible for integrating client services with Oracle Payments for funds capture process
• Supported Production migration. Carried out integration and performance testing.
• Assisted with the transfer of Fixed Asset data from different legacy systems into Oracle. Prepared and run test scripts for Fixed Asset module and the integrated systems.
• Worked with DBA's and technical groups to apply patches and help to resolve technical issues with
• Prepared FA documentation and trained Fixed Asset managers and heavy users.
• Held meetings to reconcile Oracle FA balances with different legacy systems.

Confidential - Frisco, TX

Oracle Functional Consultant.

Responsibilities:

• Primary implementation responsibility for General Ledger and Advanced Global Intercompany System.
• Responsible for design, requirements gathering, gap definition and mapping, and proposing best practice solutions.
• Involved with extensive configuration of oracle paymentssub module
• Lead efforts and created deliverables related to data conversion, interfaces, extensions, system configuration and testing. Included designing interfaces to custom applications and creating a variety of custom reports.
• Complex configuration including sixty ledgers in fifteen countries, Included primary, secondary, and reporting currency ledgers.
• Technologies: Oracle Release 12 applications including General Ledger and Advanced Global Intercompany System.
• DevelopedFSG Reports in GLlike (Income statement, Dept. Expenses, Inter Company Summary).
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Cash Management and Fixed Assets.

Confidential, Austin, TX

Oracle Financials Functional Lead Consultant

Responsibilities:

• Requirements gathering, GAP analysis, configuration, testing and support of AR, GL/AP/FA/ to accommodate Global transactions in a heavily customized system.
• Lead the System Test integration for AR, GL/AP/FA/CE on Corporate Oracle Financials system.
• Designing the future process (BP080) for AP/AR/FA/GL, Payments CE, ICM and E-Business TAX
• Wrote Definition and derivation rules to re-class Journal Entries into GL using r12 SLA
• Setup profile option and Concurrent Programs for Latin America (Brazil and Argentina)
• Developed Test Cases, Conducted Unit Test, Systems Test, Integration Test and UAT and developed all Test scripts for all financial modules (FA, GL, AP, AR and Cash Management.
• Developed procedures material for and tested the MD 050 Customizations.
• Defined Auto Reversal and Auto Post Program of the journals except before conversion.
• Setup and documented the BR100 for Sub-Ledger Accounting Process SLA for FA and AP and BR110 for System Administration
• Defined users, roles, responsibilities, request groups, profile options, Security rules and Menus.
• Used Mass Allocation formula to create Journals that allocate revenues and expenses across a group of cost centers, departments and divisions and process of Intercompany transactions.
• Designed MD050 for GL Account Analysis for Foreign Currency detail report, MD050 for GL Control Accounts and MD050 for AP Exchange Rate based on Invoice Date modifying the standard functionality where the exchange rate is based on system date.
• Involved in global Integration Testing of the application, resolving issues and working with technical developers, DBAs, and Oracle Support to resolve these issues coming from the testing.
• Compile a check list for Segregation of duties Control Process modifications, control considerations and control recommendations GL/AP/ AR and Cash Management.

Confidential

Oracle Financials Functional Lead

Responsibilities:

• Responsibilities included developing and managing project plans, define project scope, captured in the Services Statement of Work, working closely with the customer to identify specific customer requirements for R12 GL/AP/AR/PO/Payments and CE implementation.
• Created the Responsibilities for all the ledgers and attached the Responsibilities to the Ledger.
• Filled in Data Group details and assigned the Data Access set to responsibilities.
• Defined users, roles, responsibilities, request groups, profile options, Security rules and Menus.
• Setup Workshops for Chart of Accounts, interviewed end-users directly.
• Payment processing for both funds disbursement and funds capture setup.
• Created a bank account, Bank Branch and bank accounts, Receipt class and Receipt Methods.
• Setup format programs for Banks, Receivable activities, Instruction and occurrence codes.
• Worked with the JPMorgan Chase bank on the process of Receipt Remittance process for inbound and outbound remittance batch.
• Assigned a data Access Set for each GL Responsibility.
• Defined the Accounting Calendar, period types, Parent Accounts and entered values.
• Created the Accounting set up in the accounting setup manager and created Legal entity and the Accounting Setup Structure.
• Set up customers, Transaction Types. Sources, Payment Terms In AR.
• Defined a Primary Ledger and completed Ledger option and reporting currencies.
• Completed the Secondary Ledger definition and primary to Secondary Ledger Mapping.
• Created and Assigned Operating Unit to Primary Ledger.
• Configured the inbound and outbound Remittance Process Batch.
• Defined cross-validation rules and security rule elements.
• Define Banks, bank Accounts, Bank Branches and Banks transmissions detail.
• Defined Receivable Activities, occurrence codes and instruction codes.
• Setup Automatic Journal Reversal, Automatic journal post and Suspense Accounts.
• Defined Currencies and Rate types. Verified functional currencies and enable other currencies.
• Defined Suppliers, invoice, Tax Codes, Tax names and groups.

Confidential

Oracle ERP Functional Lead Consultant

Responsibilities:

• Gathered the requirements for GL/AR/AP/CM/FA, advanced collection and Oracle Internet Expense.
• Defined Customers in AR, Setup Taxes by county and province.
• Defined Suppliers and AP invoice Profile options.
• Documented AS IS processes and future Process Flows for AP/Internet Expense, GL/AR/ CE.
• Setup Schedules and Credit Card Usage policies for enforcement, audit and Reporting functionality for Policy violations.
• Set-up Expense Types. Workflow process and Setup Audit and List Automation in IExpense.
• Managing Receipt Notifications and holds on expense report.
• Set-up Policy compliance and Violation Types for Internet expenses.
• Created Policy, Rate Schedules and setup Expense Allocations in Internet Expenses.
• Define Receipt Batch sources and created Transaction batch source in AR.
• Defined Tax Codes, Tax names and groups in AP.
• Setup Credit Card Expense mapping and Data file download.
• Setup Supplier sites, Matching Tolerances and Distribution Sets in AP.
• Setup Bank Accounts and Payment Terms in AP. Setup Expense Report Template in IExpense.
• Document all the Setups in BR 100 Template for GL/AR/AP/CE/FA and Internet expense.
• Set up the application in both Test and in production instance for AR/AP/FA/GL/CM.
• Executed the Test Scripts for GL/AP/AR/CM and FA and Internet Expenses.
• Conducted and documented current and future Business Processes for GL/AP/AR/FA/CM.
• Documented and distributed Weekly and Monthly status reports.
• Developed Navigation Document and basic transactional guidelines for End-users.

Confidential, San Antonio, TX

Oracle Financials Functional Lead

Responsibilities:

• A leading manufacturer of quality Jamaican goods. Lasco Group of Companies form of business is Manufacturing, Distribution, Money Transfer and Foreign Exchange. A Multi Org, Multi-currency, Two sets of Books Implementation on E-Business 11.5.10
• Held COA workshops, gathered the data for Chart Design. Designed the COA and mapped Old COA to the New COA. Combined COA of six companies to a consolidated COA.
• Set up GL Sets of Books for Jamaica and Barbados in Dev, Test and Production Environment. Defined the Accounting Key Flexfield.
• Created the Macros to load the COA to the system using Data Loader and loaded the COA to GL.
• Defined Row set, Column Sets Using FSG.
• Defined the Set of Books, Currency and the Transaction Calendar in GL.
• Defined the Recurring journals, Journal sources and Journal Categories GL
• Defined Budgets and Budget organizations.
• Setup matching tolerance and distribution sets AP.
• Define Banks, bank Accounts, Banks transmissions details and Payment Terms.
• Opened AP accounting period and Defined Withholding tax s and exceptions.
• Defined the format for the invoice Aging Report AP.
• Define tax codes and withholding tax groups for use automatic withholding tax AP.
• Defined US 1099 income tax regions AP and AP invoice Profile Option.
• Define customers Define Receipt Batch source and created the transaction batch source
• Defined AR system Options, Setup Tax names, Groups and Expense Reports templates.

Confidential, Trumbull CT

Implementation and Post Production Support

Responsibilities:

• Provided a high level review of the documentation drafted by prior consulting company for AR/GL/AP and System administration.
• This review focused on validating the chosen approaches, discussing possible alternatives and provided an overall reasonableness check on the usage of the AR module.
• Created test plans, performed system testing, and worked with end users on all facets of the customer record for AR.
• Production Support of Oracle AR/GL/AP.
• Collection, analysis and consolidation of users reporting requirements.
• Helping Finance users with Month End Process for AR/GL/AP and solving day-to-day problems.
• Development of reports using FSG.