SUMMARY

• Over 6 years of extensive experience as Oracle Financials Functional Consultant in full life cycle implementation of Oracle 11i/R12 applications, business process analysis, evaluation and integration of internal systems, postproduction support and training to the users.
• Performing functional work within the Financial, Manufacturing, and Self - Service modules of Oracle Applications (Oracle Financials/Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP).
• End to End Implementation of Release 12 Financials including General Ledger (GL), Receivables (AR), Payables (AP), Purchase Order (PO),iProcurement and Cash Management (CE), Fixed Assets, iExpense, iProcurement.
• 2 full life cycle implementation of Oracle 11i Financials including General Ledger, Accounts Receivable, Accounts Payable including hands on Configuration of these applications.
• Good Command over Procure to pay (P2P) and Order to Cash (O2C) lifecycle.
• Experience in supporting/upgrading the Oracle E-Business Suite, Release 11i for General Ledger, Accounts Receivable, Accounts Payable, and Purchase Order.
• Providing application requirements gathering, designing, development, functional documentation, and debugging.
• Performing business process mapping, Gap analysis and user training.
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through period closing; revenue and Expense cash/accrual concepts; adjustments and financial statements.
• Knowledge on Sub ledger Accounting (SLA), for managing accounting across Sub ledger transactions to generate accounting entries.
• Special expertise in integration of self-service or Internet extensions(Internet Expenses and iProcurement) and the impact that changes in one area have on the rest of the system
• Extensive knowledge in using Oracle AIM of project implementation methodologies.

TECHNICAL SKILLS

Oracle Modules: Oracle Application Release 11i, 12 (R12) (GL, AP, FA, CM, PO, AR).

Language: C,SQL, PL/SQL

Front End Tools: Discoverer

Relational Database: Oracle 8i/9/10/11g, My SQL,SQL server

Operating System: Unix/Windows

Other Tools: Toad, SQL Loader

PROFESSIONAL EXPERIENCE

Confidential, Ramsey, New Jersey

Oracle EBS Financials - Functional Consultant

Responsibilities:

• Responsible for End-to-end Oracle Applications (GL, AP, AR, PO) implementation project from assessment to production support as a Functional Analyst.
• Particular interest in this project was the consolidation of monthly results for different companies in organization
• Performed functional analysis which implemented gathering user requirements account receivables system. Implementation included defining the System and Profile Options, define receivables lookups, define payment terms, defining transaction types and sources, define receipt classes and payment methods, and define Customer.
• Defined intercompany accounts and done setup for global consolidation.
• Configuration of Approvals Management Engine (AME) for standard Invoice Approval Workflow.
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Creating cross validation and security rules.
• Used Data Loader scripts to load data into Supplier Tolerance, Bill to Location and FOB.
• Presentation of Financial Consolidation system to the Management.
• Coordinate the rest of team members in identify and test interfaces between AP, PO iExpenses.
• Developed and successfully implemented reengineering plan for the tax department that split the compliance function from the consulting process. Initiated a specialized tax scheduling system to effectively monitor compliance and research projects.
• Strong hands on Functional experience in Procurement transformation to iProcurement.
• Involved in Month-end support for close and reconciliation for AP and AR modules.
• Implemented a custom solution for retirement and reinstatement of assets based on the Install Base transactions like demo-to-sale, rental-to-sale and sale-return transactions.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period. Setup Auto Accounting to recognize revenue based on Sales Order line.
• Gather Business Requirement (BR030), write Setup Docs (BR100), write functional (MD050) and provide recommendations for user Challenges, and implement process and system modifications. Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using AIM guidelines.
• Provided functional review & impact analysis on proposed changes with the existing functionality and prepare MD-50 for the module extensions.

Confidential, Boca Raton, Florida

Oracle Financials Functional Consultant/Business Analyst

Responsibilities:

• Responsible for the requirement gathering of deployment activity and data cleansing requirement gathering as a Functional Analyst for the modules AP, GL, FA, iExpense.
• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s related to the split scenario and post production data cleansing.
• Gathered business requirements and successfully implemented the AP Check Printing Outsourcing to Bank of America to change the existing payment business process.
• Successfully Re-engineered the AMEX Credit Card Interface and P-Card Interfaces with I-expense and Accounts Payable.
• Worked extensively with data loader Classic and pro for enabling and disabling GL code combinations, and inactivating the credit card holders in Iexpense.
• Identified category, location, Asset key FF for FA module.
• Setting up Payment Terms, Transaction Types & Sources, Standard Memo Lines, Accounting & Invoicing Rules.
• Successfully Implemented phantom pay process during the EBS Split to accommodate the resolution of duplication of invoices respectively in the both the companies which got split.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Customized the ADI template to be Compatible with new Environment to upload Journal Entries.
• Implemented parent child roll Confidential and updated Mass Allocation Setups.
• Assistedbusiness team to Zero out the balance sheet and P&L accountsfor new company.
• Reviewing Assets and assisted Business team reallocated, retired, move to one company or another.
• Worked on gathering the data cleansing requirements post production for Projects, AP, GL, and FA on granular level.
• Considered each element with regards to legal, DOD and competitive requirements and additionally reviewed the company’s record retention requirements and made recommendations for data clean-up.
• Assisted in Cleansing customers, projects, project expenditures and project budgets one from the other company after the legal day1 of both the companies.
• Worked closely with business in Identifying all the data elements across the financial modules that needs clean up(Either masking, Purging or Deletion)
• Worked closely with the development team in analyzing and adjusting the RICE objects based on the Company Split Scenario.
• Major interest in this project is the company split, provided functional review & impact analysis on proposed changes with the existing functionality and prepared MD-50 for the proposed modifications related to this company split scenario.

Confidential, Boston, Massachusetts

Oracle Functional Consultant

Responsibilities:

• Responsible for End-to-end Oracle Applications (GL, AP, AR, PO, iProcurement) implementation project from assessment to production support as a Functional Analyst.
• Strong hands on Functional experience in Procurement transformation to iProcurement.
• The Cash management implementation covered the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.
• Designed conversion strategy for conversion of Fixed Assets from legacy system into Oracle Assets, carried out conversion, verified the asset balances, maintained the books for a number of periods and transitioned the books to the users for maintenance.
• Implemented a custom solution for retirement and reinstatement of assets based on the Install Base transactions like demo-to-sale, rental-to-sale and sale-return transactions.
• Performed functional analysis which implemented gathering user requirements account receivables system. Implementation included defining the System and Profile Options, define receivables lookups, define payment terms, defining transaction types and sources, define receipt classes and payment methods, and define Customer.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period. Setup Auto Accounting to recognize revenue based on Sales Order line.
• Particular interest in this project was the consolidation of monthly results for different companies in organization
• Presentation of Financial Consolidation system to the Management.
• Provided functional review & impact analysis on proposed changes with the existing functionality and prepare MD-50 for the module extensions.
• Coordinate the rest of team members in identify and test interfaces between AP, PO iExpenses and FA modules.
• Developed and successfully implemented reengineering plan for the tax department that split the compliance function from the consulting process. Initiated a specialized tax scheduling system to effectively monitor compliance and research projects.
• Created scenarios and prototypes in iProcurement to evaluate the advantages of iProcurement Implementation.

Confidential, Schaumburg, Chicago

Oracle EBS Functional Consultant

Responsibilities:

• Responsible for End-to-end implementation of R12 GL, AP, AR, PO, iProcurement and payment from assessment to production as a Financial Functional Consultant.
• Provide functional expertise to developers during the technical design and construction phases of the project.
• Implementation, business process design and improvement, and integration with 3rd party applications to import customer data.
• Assisted business analysts and end users in implementing the test plans and execute UAT in Test instance
• Perform the related setup tasks in the applications that work together with Internet Expenses to create an integrated environment for expenses reporting.
• Coordinate the rest of team members in identify and test interfaces between AP, PO AR modules.
• Documented AS is process, Target process design, requirements documentation, configuration (BR100) document, user training procedures and month end processing for all the implementation that I handled.
• Financial reporting - 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 reports, etc.
• Performed analysis and preliminary design for future iProcurement implementation.
• Documented current state, designed future state to automate treasury functions including cash position, daily investing, cash forecasting, cash general ledger entries and debt facility accruals. Configured the Cash management module for GL Accounts Mapping, setting up transaction codes, BAI2 file upload, Customization of out file as per Bank of America requirements, automatic transmission and import of bank files.
• Configured banks, bank accounts and documents for different needs like AP processing.
• Carried out vendor conversion due to merger of group companies, converted requisition data and open purchase orders between the two operating units.
• Designed process flows for each functional area during the implementation of R12Carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.

Confidential, Lake Forest, CA

Oracle Financial Functional Consultant

Responsibilities:

• Worked as member of GE Support Team for modules GL, AP, AR and CM
• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Receivable, and Accounts Payable including setups stated below.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Supervised the period close and quarter close processes by ensuring that all financial transactions have been accounted for accurately and on a timely basis in Oracle GL.
• Provided support during the system test, Product Integration Testing and UAT.
• Supported the implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on the changing requirements.
• Created an interface to load Prime Vendors as Customers, match Vendor Invoices to Credit Memos from Accounts Payable, AP, to Accounts Receivable, AR, to reduce vendor payments in AP and generate Customer Invoices to vendors in AR to interface with Get Paid.
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies, Set of Books, Assigning Set of Books to a Responsibility, Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.
• Set-up Oracle Receivables and Oracle Payables including System Options.
• Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources, Bank Information, Receivables Quick Codes, Auto Invoice Grouping Rules and Transaction Types.
• Setups included Defined Invoice attributes- Payment Terms, Approve, Hold & Release and Distribution Set, Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes, Entering Supplier and Site Information, Payment Attributes- Payment Formats, Bank Account, Payable Documents, Tax Code, Rates, Groups and Withholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.

Confidential, Atlanta, GA

Oracle Functional 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.

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.