SUMMARY

• Over 8+ years of experience as an Oracle EBS functional consultant/analyst with expertise in design, implementation, customization, and upgrade of Oracle application modules GL,AP, AR, FA, CE, SLA, OM, and PO.
• Excellent writing skills in authoring Business Requirements Document (BRD), Functional Requirement Design (FRD), Use Case Specifications, Systems Requirements Specification (SRS), Data Dictionary, and Workflows.
• Involved in full life cycle implementation of Oracle EBS Release12 such as GL, AP, AR, and CE.
• Excellent R12 Oracle EBS Financial Functional knowledge with Sub - Ledger Accounting, E-Business Suite (EB) Tax, Multi Org Access Control, and Trading Community Architecture (TCA).
• Good working knowledge in Technical Documentation with AIM Methodologies (BRD, BR-100, MD 30, MD 50, MD 70, BR30, TE40).
• Experience in system analyst skills, 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, Business Users, Testing, and Documentation.
• Strong functional skills in Order 2 Cash (O2C) and Procure 2 pay (P2P) process cycles.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets, and Flex fields in Oracle Applications (EBS).
• Good understanding of Data Conversion and Data Migration process including vast expertise in Global implementations and working with large group of business users and Onsite & Offshore model projects
• Experienced in developing and implementing test strategy for functional testing environments (Unit, Integration & UAT) includes providing functional impact analysis as part of Change Management Process
• Conduct Oracle Web Conference (OWC) with Oracle Technical Support for all high prioritized and time sensitive issues.
• Experience in working implementation and upgrade projects in R12 and 11i application.
• Strong in Oracle EBS with business planning, requirements, design & configuration, module setup, test script generation, and user .
• Fully involved in testing both the P2P (Procure to Pay) and O2C (Order to Cash) businessFlow process.
• Experience in developing AP Expense Report interface to load the invoices from multiple sources like Legal Invoices, Quarterly Payroll, OfficeMax, Charitable Contributions, Travel EFT etc., into Accounts Payable in a periodic basis.
• Based on SOX analysis, build the responsibility(s), menu(s), function(s) and form(s) according to the business requirements.
• Created custom solutions for accounting and business processes to address gaps & issues.
• Provided s 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.
• Worked with SQL, PL/SQL, and TOAD for data conversion and query generation.
• Proven ability to quickly learn and apply new technologies with strong financial background.
• 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).
• Expert in System Administration in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities

TECHNICAL SKILLS

Applications: Oracle E-Business suite R12/R11, GL, AR, AP, FA, CE, SLA, INV,OM, iProcurement, iExpense, iSupplier, PO, User Management (UMX),Workflow admin and System admin

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

Application Tools: Oracle Reports and 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.

Other Tools: MS-Office, Quality Center

Technological Environments: Microsoft Windows, Linux, and UNIX

Scripting Language: Unix Shell scripts

PROFESSIONAL EXPERIENCE

Confidential, IL

Oracle EBS Functional Analyst

Responsibilities:

• Functional analyst for Oracle EBS Implementation, Enhancement and Support (12.1.3)
• Analyze, design, and configure the Oracle applications and modules including GL, AP, AR, CE, PO, iExpense, and iProcurement modules
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes.
• Fully Involved in Conversions of old legacy system data in Oracle (Open Purchase Orders, Requisition’s, Receipts etc.)
• 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 (EBS) can leverage their existing processes.
• Conduct CRP, SIT and UAT sessions with key stake holders to test all the Finance Modules .
• Enhance the Search functionality under iProcurement responsibility with different roles to search the Invoice, purchase Order and Requisitions.
• 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.
• Assisted in GL setup by defining Chart of Account, Flexfield Qualifiers, Segment Security rule, Independent - Depend Rule and None value sets.
• Participated in (SDLC) full software development and life cycle testing and Quality analysis of the applications.
• Defined Calendar, Currencies and used them for creating Ledger.
• Mapping the Client requirements with Oracle standard functionality, finding the gaps and delivering the solutions in terms of Customizations, workarounds, reengineering and form personalization.
• Experience in requirement analysis, GAP analysis, Design the ‘to be’ process, Process mapping, Data Conversion Management, Testing (unit/integration/system).
• Preparing TE040 Documents, which can helpful to test the application functions.
• Done the Configuration forGL, AP, AR,andCash Managementmodules as per the client prerequisites.
• Defined mass allocation, recurring journals, cross validation rules, security rules, calendar, key flex fields, and descriptive flex fields in GL.
• Configured mandatory setups in Payables like Suppliers, supplier’s banks and its bank accounts to run payments.
• Set up AP bank accounts, bank documents, bank codes and expense report templates.
• Define Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields.
• Defined AR Setups like Transaction Types and sources, System Options, Receipt Classes and sources etc.
• Defined Expense report setups to prepare expense reports on travelling or other business expenses.
• Experienced in creation of Purchase orders, suppliers, AP invoices, payments, accounting of Oracle financial applications.
• Designed and developed Auto-Lockbox to load receipts and invoices into AR.
• Involved in customer conversion from legacy system into Oracle Accounts Receivable by using Customer Interface.
• Performed System Administration tasks in Oracle Financial Application by defining Responsibilities, Users, and Menus, Concurrent programs, Request sets and Request Groups.
• Prepared Business Requirements and setup document (BR 110) based on the business users.
• Developed Consolidated FSGs with two companies, eliminations and consolidated totals.
• Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center (ALM) to perform User Acceptance Testing (UAT).
• Conducting CRP, UAT and User for Implementation.

Environment: Oracle EBS R12.1.3, AP, AR, GL, PO, CE, SLA, FA, EB-Tax, TCA, OM, PO, iProcurement, and INV.

Confidential - CO

Oracle EBS Financial Business Analyst

Responsibilities:

• As a business analyst, implemented the following modules: AR, AP, GL, FA, e-Business Tax, iExpense, PO, OM, iProcurement
• Worked on the Functional mapping of data Conversions & Enhancements AR, AP, GL, FA, OM, & PO modules
• Preparing BR100, MD050, TE40, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle AR, AP, GL, FA, e-Business Tax, iExpense, PO, OM, iProcurement modules from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Payment Process Profiles (PPP) and Payment Process Requests in the Payment Manager in AP Module.
• Worked on the payment transaction file to be transmitted to the bank using the EDI 820 Payment file
• 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 (CVR) for validating the accounts being generated dynamically.
• Setup the Internal banks for Oracle AP in the Cash Management module.
• Involved in understanding the existing business process & conducted meetings on client business overview
• Build the business requirements as per the business standards and SOX compliances.
• Implemented iProcurement as per new solution design including punchouts and configured AME for requisition approvals.
• 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).
• Good working knowledge on setting up journal line type, new accounting definition rules, and account derivation rules in SLA.
• Configure and implement the TCA model to define customer’s information such as customer name, locations, sites, and contacts.
• Developed PL/SQL Procedures for Customer interface using Trading Community Architecture (TCA) in Accounts Receivables according to Client Requirements
• Involved in Month/Year end Process for AP, AR, FA and GL modules.
• Worked on Revenue recognition transactions, involved in invoicing rules.
• Helping technical team develop a customized Revenue Recognition program in AR.
• Actively worked with Oracle Support for resolving bugs and issues.

Environment: Oracle EBS R12.1.3, AP, AR, GL, PO, CE, SLA, FA, EBS Tax, iSupplier, TCA, OM, and INV.

Confidential - Miami, FL

Oracle EBS 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 (CVR) 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 EBS 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 (MOAC), allowing the users to submit requests, enter, view and access data of different operating units without having to switch between responsibilities.
• Developed SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• 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.
• Develop and Define customer type such as organization or person, locations, and sites in TCA model.
• Defined AR Setups like Transaction Types and sources, System Options, Receipt Classes and sources etc.
• Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.
• Defining additional options in AR invoices such as Consolidated Billing to view the invoice number on the relevant windows and reports.
• Developed an Interface Program to import customers, locations, customer’s sites and customer contacts by using the TCA APIs.
• Defining auto Lockboxes and Transmission formats.
• Good working knowledge and hands on experience on all the aspects AR.
• Defining all 3 flexfields in Assets
• Customized Reports like the Order Summary Report, Pick Slip Report and Packing Slip Report in Order Management using XML/BI publisher.
• Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables Interface tables.
• Prepared test scripts for different scenarios to perform preliminary R12 System testing and supporting CRP (Conference Room Pilot), UAT and production cut-over.
• Prepared User Requirements document (URD) for Data Migration from legacy to Oracle Apps.
• Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Worked on journal import interface program to import journal data from legacy system into GL Base tables.
• Customized revenue Recognition rules by using API’s in Project Accounting.
• 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.
• Have in-depth knowledge in User Management and system admin actives
• Actively worked with Oracle Support for resolving bugs and issues.

Environment: Oracle EBS R12.0.4, AP, AR, PO, GL, CE, INV, TCA, OM, EBS Tax, Project Costing & Billing, and FA.

Confidential - Upper Saddle River, NJ

Oracle EBS 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 EBS Financial Applications R12 GL, AP, PO, and AR modules.
• Setup and documentation for General Ledger, and Accounts Payable Profile options, and 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, accounting calendar, and the currency for each legal entity and maintenance of Chart of Accounts (COA).
• 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, Standard Journals & Mass Allocation Journals.
• Worked on AIM Methodology to build design documents MD050, BR100 for system configuration change to Oracle EBS 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.
• Develop and Define customer type such as organization or person, locations, and sites in TCA model.
• 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 EBS R12.1.2, AP, AR, GL, PO, INV, TCA, EBS Tax, and SLA

Confidential

Oracle Apps Techno-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 EBS 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 procure to pay (P2P) 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 overview 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.
• Configure to define customer details such as name, site, address, in TCA model.
• Mapping and executing all necessary tasks to take existing (in Oracle) AR Model Customer base and convert them to TCA Model Customers.
• 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.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Customized standard AP Invoice Aging to run the report based on ‘as of date’
• Developed an Interface Program to import Supplier Invoices from legacy system into Oracle AP.
• Developed an Interface Program to import customers, locations, customer’s sites and customer contacts by using the TCA APIs
• Setup Project Templates, Expenditure Categories, System Implementation Options, and Auto accounting for the Projects Module
• Develop and Extracts in GL and AR modules and the extracted files are sent via FTP to other systems using the UNIX Shell Script
• Worked on Loading bank statements, reconciling bank statements and posting to General Ledger in Cash management module
• Involved in Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables
• Customized PO Account Generator Workflow and Requisition Account Generator Workflow for Generating Project Charge Account.
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.

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

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 EBS functionalities with user interaction
• Trained users and Created test scripts for new functionalities
• Provided User on one to one basis and also in group mode
• Updated Value sets’ values for COA
• Defined cross validation rules (CVR) & security rules in GL
• 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, Standard 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.