SUMMARY

• Over 8 years of experience as an Oracle applications (E - Business Suite) consultant with expertise in design, Implementation, customization and up gradation of Oracle modules AP, AR, GL, FA, INV, PO, OM, SLA.
• Excellent writing skills in authoring Business Requirements Document (BRD), Functional Requirement Design (FRD), Use Case Specifications, Systems Requirements Specification (SRS), Data Dictionary, Workflows.
• Good working knowledge in Technical Documentation with AIM Methodologies. (BRD, BR-100, MD 50, MD 70, BR30, CV040, TE40)
• Experienced in Functional Requirement analysis, Gap Analysis, Production Support, Training Business Users, Testing, and Documentation
• Strong functional in Procure to pay process and Order to Cash in flow Oracle finance.
• Experience in working implementation and upgrade projects in R12and 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 am very efficient in handling cross location teams to deliver results.
• Worked with SQL, PL SQL and TOAD for data conversion and query generation.
• Excellent understanding of Software Development Life Cycle (SDLC
• 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, SLA, OM

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

Application Tools: Oracle Reports 10g/6i, Forms, XML publisher

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

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

PROFESSIONAL EXPERIENCE

Confidential, Valhalla, NY

Oracle Financials Functional Consultant

Environment: Oracle Applications R12.1.3, AP, AR, GL, FA, PO, iExp, INV.

Responsibilities:

• Responsible for identifying key capabilities and business process. Provided analysis, design, installation, and rollout of Oracle R12.1.3 General Ledger, Accounts Payable, and Receivable, Purchasing, iExpense module and Project Accounting.
• Created MD50 and designed test scripts of all sub-process identified in assessment phase.
• Responsible for production support which involves modification, enhancement and support of all standard and custom financial applications.
• Support the business user at the time of closing process at month end and quarter end period.
• Designed, documented Billing to GL Inbound Interface and validated the data before creating the journal entries.
• Involved in Auto Invoice Interface to bring Legacy Invoices into Oracle Financials AR.
• Worked on Fixed Assets module on Mass Additions.
• Responsible for providing adequate support for any issues involving reconciliation of financial data between B2C and Oracle.
• Customized reports and forms in AR and APmodules according to the requirements.
• Preparing Invoices and recording transactions, maintain payment records responsible for compiling amounts own in AR module.
• Solution design for Interface of Oracle MSCA labels to tag Inventory
• MD050 for Oracle MSCA & Purchasing components
• Assisted accounting supervisor on all accounts payable and receivable logs.
• Developed custom reports in Discoverer used both Internet and desktop versions.
• Involved in Periodical Reconciliation Process - FA to GL, FA to AP and FA to Projects.
• Analyzed user requirements, designed and implemented End User Layer (EUL) with packages, business views to meet client special needs by utilizing Discoverer Administration Edition, PL/SQL.
• Created reports using XML/BI Publisher and Reports 10g.The modules involved were Sourcing, iSupplier, Purchasing (PO).
• Designed interfaces and responsible for data conversion programs for applications.
• Involved in FA module while defining General Ledger Accounts/Books, Asset cost and Asset Clearing.
• Reviewed the regression test results and updated the flow of business processes in all modules.
• Conducted workshop with business team as a part of explaining the flexibility of oracle functionality and how it meets the business requirements.
• Conducted workshop to explain end to end process to Business Analyst and super user groups.

Confidential, Miami, FL

Oracle Financials Functional Consultant

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

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, 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 flex field 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 flex-fields, 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

Confidential, Milwaukee, WI

Oracle Financials Functional Consultant

Environment: Oracle Apps 12.1.1, AR, AP, GL, PO, Oracle 10g, SQL, PLSQL, Forms 10g, Reports 10g, XML/BI Publisher, UNIX, SQL Loader, Toad.

Responsibilities:

• Involved in requirements review, requirements mapping and gap analysis, functional documents review and confirmation, Test scripts preparation and system testing in Source To Settle (P2P) Purchase implementation.
• Implemented requisition (PR) approval process using AME rules based on Dollar amount and purchase categories.
• The process has defined and implemented Contingent Worker requisition process in P2P.
• The Purchase Order approval process has been restricted to two levels.
• Provided test scripts for various functional scenarios in end to end system testing, purchase requisition approval rules and functional extensions.
• Purchase Requisition and PO data conversation strategy has been defined for data conversions.
• Stores are configured for catalog items in iProcurement to meet the business needs in P2P process.
• Provided process to upload Supplier catalog items into iProcurement.
• Implemented Punch-out process in iProcurement.
• The process has been designed to include project for technology items purchase exceeds $5000 cost threshold.
• Conducted workshops to gather requirements for new modules to be implemented in release 12.
• In Account Receivables (AR) Designed control files for importing customer Data from Legacy systems.
• Loaded Legacy Journals data intoGL INTERFACE table and Integrated in Oracle Applications.
• Identified the structure of Flex fields, defined Value sets and values for each segment of flex fields of GL and AR.
• For new reports, registered concurrent programs Executables and concurrent programs in Oracle Applications using AOL.
• For concurrent programs defined the parameters and attached it to the Respective value set.
• Involved in setting up user security, creating new responsibilities, value sets, setting up custom menus, responsibilities and defining concurrent programs and request set.
• Imported journals into GL from legacy system using GL import interface Program
• Customized reports like Customer Detail/ summary and Aging Bucket reports to suit the client requirements.
• Registration of Concurrent programs, Creation of Value sets, placing the Reports and Interfaces in the AOL directory of the server.
• Created MD50s for various custom interfaces, reports, and extensions, and reviewed those with client/business users and technical resources.
• Providing production support for all the applications, and working on enhancements/SCRs for improved functionality and performance of the deployed system.
• Involved in developing Functional and technical design documents using Oracle AIMS Standards.

Confidential, Oakland, CA

Oracle Applications Functional Consultant

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

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 Administration.
• Registered Concurrent programs and custom applications using System Administration.
• 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.

Confidential, Upper Saddle River, NJ.

Oracle Apps functional Consultant

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

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 flex field structures, segments and value sets according to user requirements in GL.
• Setup CV rules / Flex field Security rules for the new accounting flex field.
• Prepared Migration technical documents for Data Conversions and Interfaces.
• Developed control files & PL/SQL procedures to migrate the customer data into ARCustomer 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
• Developed a Customized XML publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the inventory module.
• Involved in production support, problem resolutions and bug fixing. Actively involved in raising issues and coordinating between the Management & Users.

Confidential, Sunnyvale, CA

Oracle Applications Functional

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

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.

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.

Confidential 

Oracle Functional Support Consultant

Environment: Functional Support (11.5.10) AR, AP, GL, PO, OM.

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.