Oracle R12 Functional Resume
Charlotte, NC
SUMMARY
Over 8 years of experience in Oracle Financials withroll out, up gradation, Onsite, Offshore Support projects. Hands on end-to-end full cycle implementation experienceand support of GL, AP, AR, PO, OM, E-Business Tax and FA using Oracle Application Implementation Methodology (AIM). Experience of System Configuration, Requirements Gathering, design, documentation and Testing.
SKILLS
- Strong in Oracle R12 Financials implementation in the areas of GL, AP, AR, PO, OM, and FA with Full Life Cycle implementationexperience.
- Experience with Oracle AIM/SDLC methodology, business process and Fit Gap Analysis. Document and analyze "as is" and "to be" process flows covering all the functionality to satisfy business need and requirements.
- Proficient with Order to Cash (O2C)and Procure to Pay (P2P) cycles, covering modules Inventory Order Management (OM), Payables (AP), Purchasing (PO), Receivables (AR) Cash Mgt. and GL.
- Analysis, design, and rollout of Oracle GL, AP, PO, AR and FA for offshore and onsite projects and CRP-I, CRP-II Solution Piloting. Good experience in FSG’s and Web ADI and standard reports.
- Experience in global treasury functions including banks, Cash Management, Risk Management and Investment Management.
- Familiar with business planning, requirement gathering, design, setup & configuration, testing, test script generation, documentation and user training.
- Proven expertise in implementing and roll out of GL, AP, AR, PO and HFMalong with concepts of Flex fields, Chart of Accounts (COA), FSG, Multiple Reporting Currencies (MRC), Global Consolidation System (GCS), Global Intercompany system (GIS), Revaluation and Translation.
- Ability to lead and facilitate cross-functional teams to deliver complex projects in 11i & R12.
- Developed test scenarios and perform functional testing and document test results.
EDUCATION
M.B.A. - Finance
Master of Commerce - Accounting
Diploma in Computer Science
TECHNICAL SKILLS
Oracle Application - E-Business Suite R12 and 11i
Oracle Application Modules - Oracle General Ledger (GL), Accounts Payables (AP), Account Receivables
(AR), Fixed Assets (FA), Cash Management (CM), Order Management (OM)
Purchasing (PO) and Reporting – FSG, Web ADI.
SQL, PL/SQL, forms, reports, Discoverer, XML Publisher
PROFESSIONAL EXPERIENCE
Confidential
Charlotte, NC
Oracle R12 Functional Consultant Jul’10 – Present
Responsibilities:
- Participated in making recommendations for GL, AP, AR, CM, and FA.
- Defined setups and configured AP, AR, FA and GL modules with R12 new features.
- Participated in Requirement gathering, design, documentation, setup and configuration.
- Defined GL setups, Chart of Account (COA), Calendars and periods for Assets and projects.
- Involved in Payment functions including Oracle Receivables, Payables, Cash, Bank operations.
- Defining Accounting Flex fields for GL and Tax requirements for AR and AP modules.
- Involved in configuration for Account Receivables, Payables, Banks and Cash Management.
- Created authorization limits in AP and ARthat sends notifications to the concerned people.
- Defined setups for Oracle AR like Auto Cash Rule Set, Grouping Rules, transaction sources, Transaction types, payment methods, payment terms, Sales tax flex fields Structure, System Options, collections, receipt class, receipt sources. Defined Centralized Tax Setups in E-Business Tax module.
- Defined Customer profile classes, bank accounts, payment terms, distribution sets and Credit.
- Prepared RD20 Requirement document, MD50 and BR 100 Functional setup document.
Environment: Oracle Applications R12 (GL, AP, AR, CE, FA and Oracle Reports - FSG and ADI)
Confidential
Washington, DC
Oracle Financials Consultant Jan’10-June’10
Responsibilities:
- Prepared R12 Functionality document for GL, AP, PO, Federal Finance and AR modules.
- Defined GL, AP, PO and AR setups and configured with Projects.
- Setting up System Profiles, Application Security (user, menus and responsibilities) Flexfields, Value sets, Ledgers, COA, Calendar and Currency.
- Participated in making recommendations for implementation and to support users on resolving issues
- Defined Invoicing information including Payment Terms, Invoicing and accounting rules, territories, Invoice Sources and Interfaces.
- Defined Tax features such as Codes, Rates, Exceptions and Exemptions. Customize FSG’s (Financial Statement Generator), Web ADI reporting.
- Prepared RD20, BR100, TE40, and MD50 documents.
- Defining accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set and auto invoice tuning.
- Defined AP and AR transactions for misc. receipts, finance charges, bank charges, iPyaments, iExpenseand defined distribution sets.
- Defining receipt class, specifying creation method, Payment method, clearing method, collectors, revenue recognition and aging buckets.
- Set up transaction types, invoices, guarantees, deposit, credit memos and debit memos.
- Assigning receivable account, revenue account, unbilled account, fright account, clearing account and unearned account to transaction types.
Confidential
New York, NY
Oracle Functional Consultant Mar’09 to Jan’10
Responsibilities:
- Implemented and supported for R12 GL, PO, AP, AR, CM and FA.
- Analyzed As-Is and To-Be process, involved in Solution Design, CRP-I, CRP-II, Solution Piloting.
- Designed steps for implementation and prepared the business documentation for implementation and supporting of R12 using the SDLC/AIM Methodology and Advanced Global Intercompany System.
- Setup GL, AP, AR, FA, and Cash Management, EB TAX, System Profiles and Application Security.
- Setup and configured business applications to support business requirements.
- Experience in defining Calendar (Transaction Calendar), Currency and Chart of Accounts (COA)
- Involved in setups including Oracle Receivables and Payables Reporting, Cash, Banks, treasury operations, EB TAX, invoice mapping and implementing strategies.
- Involved in Business Requirements, As-Is and To-Be Processes, Fit/Gap Analysis.
- Defined setups for GL included Budgeting, Multi Reporting Currency, FSG and Multi Org.
- Developed reports in Financial Statement Generator (FSG) and ADI
- Configured and did complete end-to-end testing ofOrder to Cash and Procure to Pay Processes.
- Defined setups for Oracle AR, AP like Auto Cash RuleSet,GroupingRules, transaction sources,Transaction types, payment methods, payment terms, EB-Tax, Canadian Tax, PST, QST, GST, HST, tax flex fields Structure, System Options, collections, receipt class, receipt sources.
- Setting up Approval hierarchies for the applications ofAR, CM, AP, and defined EB Tax such as Codes, Rates, Exceptions and Exemptions.
- Involved in finding solutions both work around and customizations to iPayments and iExpense.
- Involved in the entire project, which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
- Defined Customer profile classes, bank accounts, payment terms, distribution sets and Credit Management policies.
Environment: Oracle Applications R12, R11i (GL, AR, AP, FA, INV, PO, OM, CE) HRMS, Oracle Reports.
Confidential
New York, NY
Oracle Financials Analyst Mar’08 to Feb’09
Responsibilities:
- Requirement gathering for GL, AP, AR, Cash Management and FA.
- Involved in Business Requirement Documentation(RD20Questionnaires), Process Mapping (RD20Process Definition), BR 100 Setup Document, Future Business Requirements (BP-80) & Requirement Mapping document (BR 30) as per AIM Methodology.
- Setup and configured business applications to support business requirements.
- Implemented GL, AR, CM and AP according to the user requirements for the client.
- Involved in the implementation of Cash Management, Accounts Payable and Treasury management...
- Performed process analysis, solution design, build, test, delivery, and postproduction support for enterprise-wide GL, AP, AR, Fixed Assetsand related documentation/deliverables.
- Worked with cross-functional groups (Procure to Pay cycle) for cross functional issues related to real time and Non-real time reporting requirements
- Gathered user specifications and system requirements for development process.
- Setting up the Oracle Payables, EB-Tax, Cash Management and Bank Reconciliation.
- Created parent-child relationships for segment values, Rollup Groups and Summary Accounts.
- Defined formulas for Mass Allocation and Recurring Journals in GL.
- CRP Testing, Documentation and User Training for new modules
- Involved in the setup of the GL, AP, AR, Cash Management and defined EB Tax setups.
- Defined Legal Entity, Primary Ledger (COA, Calendar, and Currency) Assign Ledger to Legal entity.
- Defined AR System Options, Customer Profiles, Transaction Types, Payment Terms, Tax Rules, Auto Accounting Rules, Transaction Batch Sources, Distribution Sets, Transaction Activities, Auto Cash Rule Sets, Receipt Sources, Profile Classes, and Lockboxes.
- Involved in the setup of Financial Options and Payables Options, Distribution Sets, Suppliers and Banks.
- Environment: Oracle APPS 11i (AP, AR, GL and FA), Windows NT, Oracle 8i, Reports, MS Word and Visio.
Confidential
Pittsburgh, PA
Oracle Financials Consultant Jan’07 to Feb’08
Responsibilities:
- Gone through all stages of implementation like As-Is, To-Be, Solution Design, CRP-I, CRP-II, Solution Piloting and UAT.
- Responsible for Implementation and roll out of GL, AP, Cash Management and iExpense.
- Develop functional designs in support of global 11i implementation using SDLC/AIM methodology
- Defining and structuring of chart of accounts (COA) by mapping with the old account codes.
- Experience in defining Calendar (Transaction Calendar), Currency as per client requirements
- Defining unique document sequencing for each journal categories.
- Using Journal Approval limits so that journal goes for an approval if it exceed some thresholds.
- Used absolute budget for the capital expenditure items and advisory for the rest.
- Defined Tax setups for Use Tax, Sales Tax and VAT and exposure with Vertex
- Define item master inventory and major and minor items using ADI.
- Defining major and minor categories in fixed assets.
- Loading of Trial Balance and matching with the old balances.
- Defining system options in Receivables, Payables and Cash Management.
- Defining payable and financial options, System options and profile options.
- Defined COA mapping, G/L balances conversion, Vendor and Customer conversion, AP and AR setup
- Period closing process in liaison with HRMS and Procurement.
- Developed functional designs in support of global 11i implementation using SDLC/AIM methodology.
- Environment: Oracle APPS 11i (AP, AR, GL and FA), Windows NT, Oracle 8i, Reports 6i, Forms 6i.
Confidential
Nashville, TN
Oracle Financials Consultant Jan’05 to Dec’06
Responsibilities:
- Upgrade of Oracle GL, AP, AR, OM, and Reconciliation of custom objects.
- Involved in migration of modules by following upgrading “Categories”
- Identify the Upgrade errors as a part of Iterations and resolving the issues sitting with the technical team.
- Involved in defining custom descriptive flex fields and Tax requirements.
- Worked as a conversion specialist and in customization of oracle Apps. Converted data from legacy system to Oracle Applications. The conversion includes Customer information and Receipt information in AR through Auto lock box, Customer interface.
- Involved in implementation of GL, Account Receivables, Payables and Cash Management modules.
- Performed Setup steps for Oracle Receivables like Auto Cash Rule Set, Tax Rules, transaction sources, Transaction types, payment methods, payment terms, Sales tax flex fields Structure, System Options, receipt class, receipt sources.
- Also created Workflow in AR, CM & Inv.that sends notifications to the concerned people about Orders.
- Defined AR Dunning letters to customers about outstanding due and Reconciliation.
- Customized ‘Check Printing’ Program in AP to avoid printing a ‘Blank’ before Bank account number.
Environment: Oracle Applications 11i (INV, AP, AR, CE, OM, GL, FA, Workflow Builder 2.6, Oracle Reports.
Confidential
Marietta, GA
Oracle Financials Analyst Jul’03 to Dec’04
Responsibilities:
- Implemented Oracle Financials 11i modules GL, AR, OM and AP for a large distribution network.
- Setting up the EB Tax and Sales Tax and credit management application workflow and process activities
- Defined the Line Ordering and Grouping Rules to be used with the Auto Cash Rule Sets in order to maintain the desired sequence for transactions to appear in an invoice.
- Completed the setup of the receipts workbench that included receivable activities, receipt classes, payment methods, receipt sources and distribution sets.
- Worked in the Revenue Cycle with Multi-Currency and Bank Reconciliation
- Set up Banks account, transaction types, invoices, guarantees, deposit, and credit, debit memos.
- Assigning receivable account, revenue account, unbilled account, fright account, clearing account, and unearned account to transaction types.
- Defined Split payment terms for invoice installments that have different due dates and assigned multiple discounts to each payment line and Cash forecasting
- Defined customer and setting up credit management and Tax rules
Environment: Oracle Applications (AP, AR, CE, OM, GL, FA) and Oracle Reports.
Confidential
New York, NY
Oracle Financials Analyst Jul’02 to Jun’03
Responsibilities:
- Participated in the configuration and implementation of GL, AP, AR and Cash Management.
- Defined Profile Options to specify certain implementation parameters, and Processing System Options.
- Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources and payment methods.
- Defined Tax setups such as Tax Codes, Rates, Exceptions and Exemptions.
- Defining System Item Flex Field and Organization.
- Defining accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set and auto invoice tuning.
- Defining Receivable activities for receipts, finance charges, bank charges and defining distribution sets.
- Defining receipt class, specifying creation method, Payment method, clearing method, collectors and aging buckets.
- Set up transaction types, invoices, guarantees, deposit, credit memos and debit memos.
- Assigning receivable account, revenue account, unbilled account, fright account, clearing account and unearned account to transaction types.
Environment: Oracle Applications 11i (AP, AR, CE, GL, FA), Visio, and Oracle Reports.