SUMMARY

• Over 8 years of experience as an Oracle financial functional consultant with expertise in design, Implementation, customization and up gradation of Oracle application modules AP, AR, GL, FA, CE, PO, and SLA.
• Excellent writing skills in authoring Business Requirements Document (BRD), Functional Requirement Design (FRD), Use Case Specifications, Systems Requirements Specification (SRS), Data Dictionary, and Workflows.
• Good working knowledge in Technical Documentation with AIM Methodologies. (BRD, BR - 100, MD 50, MD 70, BR30, TE40).
• Experience in, GAP Analysis, Test Plan Preparation, Unit Testing, Functional Architecture, System Integration testing, Business Requirements gathering, UAT, SDLC processes using AIM Methodology.
• Experienced in Functional Requirement analysis, Production Support, Training Business Users, Testing, and Documentation.
• Strong functional in, Order 2 Cash, and Procure 2 pay process in flow Oracle finance.
• Experience in working implementation and upgrade projects in R12 and 11i application.
• Strong in Oracle Apps with business planning, requirements, design & configuration, module setup, test script generation, and user training.
• Created custom solutions for accounting and business processes to address gaps & issues.
• Worked extensively on onsite, offshore model and very efficient in handling cross-location teams to deliver results.
• Provided trainings to users as how to setup organizations, master items, costing, requisitions, requisition approval, purchase order creation and approval flows, receiving the inventory, matching them to invoice, making payments to suppliers.
• Configured payment administrator setups to create payment formats, profile and payment documents to use them while matching invoices and then use the payment manager to schedule the pay runs.
• Worked with SQL, PL/SQL, and TOAD for data conversion and query generation.
• Experience in reviewing Test Procedures, defining Test Cases, reviewing and maintaining Test Scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).

TECHNICAL SKILLS

Applications: Oracle E-Business suite R12/R11, GL, AR, AP, FA, CM, PO, and SLA

Databases and Tools: Oracle 11g/10g/9i/8i, TOAD, SQL*PLUS, SQL*Loader

Application Tools: Oracle Reports and Forms, XML publisher, OAF

Languages: SQL, PL/SQL, JAVA, C, C#

Technology Competencies: System Administrator, Oracle Workflow, Alerts, Developer/2000,Designer2000, Database Triggers, PL/SQL, HP Quality Center.

Office Applications: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Project, and Microsoft Visio.

Technological Environments: Microsoft Windows, Linux, and UNIX

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh, PA

Functional Financial Consultant

Responsibilities:

• Functional Consultant for Oracle Apps Implementation, Enhancement and Support (12.1.3)
• Conducted workshops to gather the requirements and understand how the existing system is working.
• Assisted Functional lead by configuring the vision instance for CRP1 for conducting workshops to gather further requirements by explaining them how Oracle E Business suite can leverage their existing processes.
• Once the requirements are clear, prepared the BR 100 document for GL, and got the sign off.
• Similarly conducted workshops to gather requirements for other financial modules (AR, AP, CE, and FA).
• Then documented those using BR 100 templates. Once all the documents were signed-off, CRP2 instance was configured with the setup configurations from BR 100.
• Conducted workshops for gathering extension requirements that were found out during prior workshops and prepared the MD 050 documents
• Defined Security rules in GL so that some of the segments of COA were not available for certain users and set up cross validation rules for validating the accounts being generated dynamically.
• Created Ledgers, Legal Entities and operating units using Accounting Setup manager.
• Used data loader extensively to perform data entry tasks to load value sets for COA segments, load responsibilities, and update profile options for all the responsibilities created.
• Trained users on how to use WEB ADI integrator (Journal Wizard). Shown them how to modify the templates with in using desktop integrator responsibility.
• Trained users on functionality and processes for reconciling, revaluating the foreign currency balances, translating them into USD and consolidating them to consolidated ledger.
• Hands on experience on generating FSG’s
• Conducted rigorous Unit and integration testing on CRP3 instance, which had the customizations extensions installed with the seeded functionality configured as per signed off documentation.
• Based on the BR 100 setup document for Payables, configured the Payables setup options (Financial, payables system and payables options).
• Logged in as sysadmin and configured the cash management for the user to create banks, branches, and bank accounts.
• Trained users as how to create suppliers and supplier sites and configure suppliers for using them to create payment invoices.
• Configured the price lists, modifiers for items in Order management while configuring the Order to Cash business process.
• Provided demo to users as how to configure advance pricing for items using Oracle Advance Pricing module. Creating Qualifiers and associating them to the Modifiers.
• Went through the complete flow of booking order, pick listing & confirming the shipping and running the background workflow process to transfer the entries to AR interface tables.
• Then through Cost Manager responsibility ran the three COGS reorganization programs.
• Then went through the AR to show how automatic invoices were created through auto invoicing.
• Used the payment administrator web form to configure payment profile and add the payment document to payment profile.
• Provided a demo to the users as how to use payment administrator and payment manager to schedule payments.
• Configured the Purchasing setup for purchasing options and financial options. The Financial options are shared between payables and purchasing.
• Configured the receiving options for two inventory organizations and gave a demo to users as how set those options.
• Good understanding on 2 way, 3 way and 4 way matching, receipt routing .
• Creating approval groups, assigning them to proper job, adding buyers for creating purchase orders.
• Creating PO standard purchase orders, blanket purchase releases.
• Configured the Inventory Organizations, created items, assigned them to different organizations. Created the item costs in the organizations.
• Configured the Procure to pay process to send purchase orders to suppliers, receive the material, match the PO in Payables, and using payment manager, pay the invoices to suppliers.
• Reconciled and verified if Data correctly got updated during post implementation.
• Month end process - Create Accounting entries, print month end reports, Transfer accounting to General Ledger.
• Resolved Post implementation issues and issues raised during testing either by analysis and provided steps to correct them if they are user errors, otherwise created service request ticket if it was an issue with seeded functionality.
• Actively worked with Oracle Support for resolving bugs and issues.

Environment: Oracle Applications R12.1.3, AP, AR, GL, PO, CE, FA, and SLA.

Confidential - Houston, TX

Functional Consultant

Responsibilities:

• Prepared Business Requirement and setup document (BR 100) based on the workshops conducted with business users.
• Gathered business requirements and configured the modules based on the defined future business process.
• Assisted in GL setup by defining Chart of Account, Flexfield Qualifiers, Segment Security rule, Independent - Depend Rule and None value sets.
• Defined Security and Cross-Validation rules to restrict access and prevent invalid account codes combinations.
• Defined Calendar, Currencies and used them for creating Ledger.
• Defined mass allocation, recurring journals, cross validation rules, security rules, calendar, key flexfields, and descriptive flexfields in GL
• Designed and developed specific FSG reports Based on Client requirement.
• Performed System Administration tasks in Oracle Financial Application by defining Responsibilities, Users, and Menus, Concurrent programs, Request sets and Request Groups.
• Involved in Purchasing and Cash Management setups.
• Thorough understanding of Multi organization access control allowing the users to submit requests, enter, view and access data of different operating units without having to switch between responsibilities.
• Experienced in Business Process Re-Engineering study for GL, AP and AR.
• Defined AP important setups like Financial Options and Payable options to carry out all types of Invoices which are relating to payments.
• Defined the Payables and Financials Options.
• Setting up PO matching option, invoice tolerances, distribution options, terms, holds etc. Setting up Payment methods, Banks, payment format etc.
• Configured mandatory setups in Payables like Suppliers, supplier’s banks and its bank accounts to run payments.
• Defined Expense report setups to prepare expense reports on travelling or other business expenses.
• Defined AR Setups like Transaction Types and sources, System Options, Receipt Classes and sources etc.
• Defining Lock Boxes and Transmission formats.
• Good working knowledge and hands on experience on all the aspects AR.
• Defining all 3 flexfields in Assets.

Environment: Oracle Applications R12.0.4, AP, AR, PO, GL, CE, and FA.

Confidential - Miami, FL

Oracle Financials Functional Consultant

Responsibilities:

• Responsible for requirements study, interaction with business users, preparing design documents, coordinating with development team at offshore for Implementation project for new organization in Multi org environment.
• Involved in implementation of Oracle Financial Applications R12 GL, AP, PO, and AR modules.
• Setup and documentation for General Ledger, and Accounts Payable Profile options, mapping,
• Interacted extensively with the end-users to realize and define a precise accounting flexfields structure in Oracle General Ledger.
• Defined the Chart of Accounts, Legal Entities, the accounting calendar, and the currency for each legal entity and maintenance of Chart of Accounts.
• Created users, custom menu and responsibility, key and descriptive flexfields, request groups and request sets through System Administrator responsibility.
• Configured Security Rules as per Customer specifications &setup for Cross-Validation Rules to restrict invalid GL code combinations
• Created Gapless Document Sequencing, defined Revaluation rules, translation rules, and consolidation sets setup of Ledgers.
• Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Worked on AIM Methodology to build design documents MD050, BR100 for system configuration change to Oracle Applications.
• Conduct CRP to provide a demo as well as train the Business users in their respective areas.
• Defined Payment Terms, Payment set ups, and distribution sets.
• Configured Payables System Options, and financial options.
• Set up Suppliers, Supplier sites, Bank Accounts and process documents.
• Implementation of standard Procure to Pay (P2P) functionality.
• Set up purchasing standard functionalities such as converting purchase requisitions into standard purchase orders and blanket releases.
• Involved in documentation of Future Business (BP-80), present business requirements (RD20), and function extensions (MD-50), Test Scripts (TE-40), System setup Document (BR-100) as per AIM Methodology.
• Identified process and reporting gaps and recommended solutions.
• Developed functional specifications for invoice matching solution.
• Configured Multi Organization setups for various operating units located in different legal entities.
• Configured the setups for prepayment to employees and defined employee expense report.
• Created custom responsibilities-attached specific menus, forms and reports for restricted user access

Environment: Oracle Applications R12.1.2, AP, AR, GL, PO, and SLA

Confidential - Oakland, CA

Oracle Applications Functional Consultant

Responsibilities:

• Responsible for gathering Business Requirements, creation of functional Design Documents (MD.50), Unit Test Cases, Defect logs and user Documentation using AIM methodology.
• Working on understanding and gathering of functional designs for customizations/extensions/inbound-outbound interfaces and preparing Functional Design Documents (MD50).
• Assessed the current use of Oracle applications and the mapping of new features and functionality of 11.5.10 to the functionality required in the present company environment.
• Created users and responsibilities using System Administrator.
• Registered Concurrent programs and custom applications using System Administrator.
• Setup a new set of books with a calendar assignment and test the consequences of calendar changes and FSG Reports in Adjustment Periods.
• Created multiple responsibilities, developed security rules, and customized menu to restrict user access to GL functionality as per client’s requirement.
• Worked in the Procure to pay cycle and Setup auto accounting, payment methods and transaction types for invoices.
• Setup recurring invoices, prepayment invoices.
• Created template for employee expense invoices and reports
• Conducted numerous meetings with SME team on business over view of the client and identify the external systems involved in the business functionality.
• Worked on Revenue recognition transactions, involved in invoicing rules.
• Customized various reports in AR related to aging, invoice printing and customer balances.
• Good functional understanding of RFQ and Quotation.
• Used AIM methodology documentation by studying functional design document (MD50) and created technical design document (MD 070).
• Developed various custom reports and customized standard Oracle reports like Account Status Report, Bank Account Listing, and Employee Listing Reports as per the business requirements.
• Development of Customized Reports.
• Involved extensively in Performance Tuning.
• Setup Project Templates, Expenditure Categories, System Implementation Options, and Auto accounting for the Projects Module.
• Worked on Loading bank statements, reconciling bank statements and posting to General Ledger in Cash management module
• Customized PO Account Generator Workflow and Requisition Account Generator Workflow for Generating Project Charge Account.

Environment: Oracle Applications 11.5.10, AP, AR, GL, FA, PO, CE, INV, Oracle 10g, TOAD, PL/SQL

Confidential - Upper Saddle River, NJ

Oracle Apps functional Consultant

Responsibilities:

• Studied the Organizational setup, Business Process Flow of the Organization and identifying the required set ups to map it into Oracle Applications.
• Involved in Planning and designing of accounting flexfield structures, segments, and value sets according to user requirements in GL.
• Setup CV rules / Flexfield Security rules for the new accounting flexfield.
• Prepared Migration technical documents for Data Conversions and Interfaces.
• Developed control files & PL/SQL procedures to migrate the customer data into AR Customer interface tables.
• Provided various validations such as purging previous data, checking for duplicate files, validating input data, updating invalid data, formatting input data and transferring data from custom staging table(s) to interface table(s) such as GL INTERFACE.
• Experience in importing PO Headers, PO Lines from legacy system to Oracle Purchasing through Purchase Order Open Interface (PO).
• Worked on AOL to register new reports, forms, functions, and created validation sets, request sets and concurrent programs.
• Experience in customization of XML Publisher reports for Oracle Purchasing.
• Developed two main reports in Oracle Purchasing i.e., Purchase Order report and Requisition Report
• Involved in production support, problem resolutions, and bug fixing. Actively involved in raising issues and coordinating between the Management & Users.

Environment: Oracle Apps R12, AR, PO, AOL, GL, AP, XML Publisher, Windows XP.

Confidential - Sunnyvale, CA

Oracle Applications Functional

Responsibilities:

• Analyzing the business needs for GIS, GCS and setting them up accordingly
• Eliminated duplicate customer problem using merging functionality
• Providing solution for Revenue Recognition for different types of Blue coat orders in AR
• Helping technical team develop a customized Revenue Recognition program in AR
• Creating punch out catalogues and configuration of iProcurement
• Extracting data from PO and uploading for online purchase
• Creating catalogs and adding to BC defined stores.
• Creating the Blanket PO as per the existing US PO and copying all items from US to Swiss org along with costs
• Followed SOX rules in designing the responsibilities and restricting access accordingly to various functions as per the business requirement
• Creating new accounts for intercompany transactions, Bank set ups etc
• Evaluating the Reports and testing them for the desired outputs after development as per the Business requirements
• Setup MRC for GL as well as Sub ledgers to maintain foreign currency transactions
• Defining system parameters for Cash management with the default set of books and other information
• Uploading data into the forms in oracle using data loader scripts
• Running various customized reports to evaluate any changes from the existing set up
• Testing of P2P process end to end while providing support to users for the same
• Testing of Hyperion flow to GL process for Swiss roll out
• Analyzing the business needs and setting up new corp book and categories for Swiss org Assets
• Test the Reconciliation process in Cash management by entering manual bank statements
• Testing the entire process of Payables transfer to GL, AP Assets creation and mass additions create through Payables
• Setting up Customer Room Pilot (CRP) instance and providing support for UAT
• Set up of Desktop ADI and test the creation of Journals along with WEB ADI
• Evaluating and adding account combinations so Account Generator runs smoothly for Depreciation run.
• Developed Consolidated FSGs with two companies, eliminations and consolidated totals.

Environment: Oracle Applications 11.5.10(GL, AP, AR, FA, PO), Oracle10g/9i, Windows XP, SQL, PLSQL, SQL Navigator, TOAD 8.0.

Confidential

Oracle Consultant

Responsibilities:

• Financial reporting - Oracle Standard reports (GL) developed using Financial Statement Generator (FSG), Account Analysis reports development, Trial balance reports development. Generation and analysis of Consolidation reports like Consolidation Exception reports, Journals report, Consolidation rules report, Summary Trial balance
• Month end and Year end reconciliations for closure of subsidiary modules - AR and AP.
• Prepared MD50 Functional Design documents for all the development work done.
• Provided support all through the SIT (System Integration Testing).
• Written Unit Test Cases, Unit Test Outputs, implementing, support, enhancement, and bug fixing.

Environment: Oracle Applications (11.5.10), AP, AR, GL, and CE.

Confidential

Oracle Functional Support Consultant

Responsibilities:

• Worked as member of GE Support Team for modules GL, AP, AR and CM
• Reviewed daily support SR’s, co-coordinated with users and resolved issues
• Identified SR’s as GAP’s that needed customization and reviewed with management with GAP analysis document
• Developed functional documents for technical customizations
• Implemented new Oracle functionalities with user interaction
• Trained users and Created test scripts for new functionalities
• Provided User training on one to one basis and also in group mode
• Updated Value sets’ values for COA
• Defined cross validation rules & security rules
• Designed Financial Reports using Financial Statement Generator (FSG) tool
• Set up of Parent &Child relations, Rollup Groups and summary templates
• Set up of System Options and Financials Options.
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Helped in Inventory management module for costing problem. Inventory valuation report was not tying with General Ledger Inventory account. Cost group was the problem and physical inventory was not updating the quantity in the right cost group. Supporting users after going live on all financial modules.

Environment: Functional Support (11.5.10) AR, AP, GL, FA, and CE.