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 teh users.
• Performing functional work wifin teh 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 teh 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 teh impact that changes in one area has on teh rest of teh 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 teh consolidation of monthly results for different companies in organization
• Performed functional analysis which implemented gathering user requirements account receivables system. Implementation included defining teh 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 teh Management.
• Coordinate teh rest of team members in identify and test interfaces between AP, PO iExpenses.
• Developed and successfully implemented reengineering plan for teh tax department that split teh compliance function from teh 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 teh 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 teh process using AIM guidelines.
• Provided functional review & impact analysis on proposed changes wif teh existing functionality and prepare MD-50 for teh module extensions.

Confidential, Boca Raton, Florida

Oracle Financials Functional Consultant/Business Analyst

Responsibilities:

• Responsible for teh requirement gathering of deployment activity and data cleansing requirement gathering as a Functional Analyst for teh 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 teh split scenario and post production data cleansing.
• Gatheird business requirements and successfully implemented teh AP Check Printing Outsourcing to Bank of America to change teh existing payment business process.
• Successfully Re-engineered teh AMEX Credit Card Interface and P-Card Interfaces wif I-expense and Accounts Payable.
• Worked extensively wif data loader Classic and pro for enabling and disabling GL code combinations, and inactivating teh 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 teh EBS Split to accommodate teh resolution of duplication of invoices respectively in teh both teh companies which got split.
• Configured Security and Cross validation rules to restrict teh usage of departments and companies belonging to one Company by teh other in sub ledger transactions.
• Customized teh ADI template to be Compatible wif new Environment to upload Journal Entries.
• Implemented parent child roll Confidential and updated Mass Allocation Setups.
• Assistedbusiness team to Zero out teh 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 teh data cleansing requirements post production for Projects, AP, GL, and FA on granular level.
• Considered each element wif regards to legal, DOD and competitive requirements and additionally reviewed teh company’s record retention requirements and made recommendations for data clean-up.
• Assisted in Cleansing customers, projects, project expenditures and project budgets one from teh other company after teh legal day1 of both teh companies.
• Worked closely wif business in Identifying all teh data elements across teh financial modules that needs clean up(Either masking, Purging or Deletion)
• Worked closely wif teh development team in analyzing and adjusting teh RICE objects based on teh Company Split Scenario.
• Major interest in this project is teh company split, provided functional review & impact analysis on proposed changes wif teh existing functionality and prepared MD-50 for teh 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.
• Teh Cash management implementation covered teh Bank setups, teh 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 teh asset balances, maintained teh books for a number of periods and transitioned teh books to teh users for maintenance.
• Implemented a custom solution for retirement and reinstatement of assets based on teh 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 teh 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 teh consolidation of monthly results for different companies in organization
• Presentation of Financial Consolidation system to teh Management.
• Provided functional review & impact analysis on proposed changes wif teh existing functionality and prepare MD-50 for teh module extensions.
• Coordinate teh rest of team members in identify and test interfaces between AP, PO iExpenses and FA modules.
• Developed and successfully implemented reengineering plan for teh tax department that split teh compliance function from teh consulting process. Initiated a specialized tax scheduling system to effectively monitor compliance and research projects.
• Created scenarios and prototypes in iProcurement to evaluate teh 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 teh technical design and construction phases of teh project.
• Implementation, business process design and improvement, and integration wif 3rd party applications to import customer data.
• Assisted business analysts and end users in implementing teh test plans and execute UAT in Test instance
• Perform teh related setup tasks in teh applications that work together wif Internet Expenses to create an integrated environment for expenses reporting.
• Coordinate teh 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 teh 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 teh 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 teh two operating units.
• Designed process flows for each functional area during teh 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 teh system updates and meeting teh deadlines for teh implementation.
• Supervised teh period close and quarter close processes by ensuring that all financial transactions has been accounted for accurately and on a timely basis in Oracle GL.
• Provided support during teh system test, Product Integration Testing and UAT.
• Supported teh implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on teh 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 wif 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 Wifholding 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 wif users and resolved issues
• Identified SR’s as GAP’s that needed customization and reviewed wif management wif GAP analysis document
• Developed functional documents for technical customizations
• Implemented new Oracle functionalities wif 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 teh 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 teh development work done.
• Provided support all through teh SIT (System Integration Testing).
• Written Unit Test Cases, Unit Test Outputs, implementing, support, enhancement and bug fixing.