PROFESSIONAL SUMMARY:

• Around 8 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 within teh Financial, Manufacturing, and Self - Service modules of Oracle Applications (Oracle Financials/Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP).
• 1 Full Life Cycle Implementation of Release 12 Financials including General Ledger (GL), Receivables (AR), Payables (AP), Purchase Order (PO) and Cash Management (CE).
• 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) 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.
• 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

Documentation tools: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Oracle Financials Functional Consultant/Business Analyst

Environment: Business Analyst (R11.5.10.2) ADT SECURITY SERVICES, INC was split into two separate companies ADT LLC and Tyco IS. Teh EBS Suite was cloned to create two separate environments. Major Emphasis in this project is based on this Clone of EBS application for two different Companies

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.
• Major interest in this project is teh company split, provided functional review & impact analysis on proposed changes with teh existing functionality and prepared MD-50 for teh proposed modifications related to this company split scenario.
• 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.
• Particular interest in this project is on MARK VIEW, an imaging tool which has been tightly integrated with Accounts Payable which makes teh invoice entry process more automated.
• Extensively worked on teh Upgrade from Mark view5.0 to Mark view 7.0
• Gatheird business requirements and successfully implemented teh AP Check Printing Outsourcing to Bank of America to change teh existing payment business process.
• Extensively worked with ACOM Check printing Process.
• Coordinated with teh third party to identify teh impacts of split and test interfaces between AP,iExpenses and third party programs
• Successfully Re-engineered teh AMEX Credit Card Interface and P-Card Interfaces with me-expense and Accounts Payable.
• Successfully handled all teh in-flight transactions when we split into two companies.
• 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.
• Coordinated with legacy system to test different interfaces and data flow related to projects and customers.
• 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 with new Environment to upload Journal Entries.
• Implemented parent child roll ups and updated Mass Allocation Setups.
• Extensively with data loader Classic and pro for enabling and disabling GL code combinations, and inactivating teh credit card holders in Iexpense.
• 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 with 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 with business in Identifying all teh data elements across teh financial modules that needs clean up(Either masking, Purging or Deletion)
• Worked closely with teh development team in analyzing and adjusting teh RICE objects based on teh Company Split Scenario.

Confidential, West Harvard, CT

Oracle Functional Consultant

Environment: Upgrade of R11.5.10.2 to R12

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
• Presentation of Financial Consolidation system to teh Management.
• 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 with 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 TEMPeffectively monitor compliance and research projects.
• 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.
• 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.
• Creating New Customers, Locations, Party Sites, Account Sites and Contacts using API’s. Invoice report customizations include printing for different Transaction Types. Print Statement Format customizations. Aging Reports, Billing and Receipts History .Report Customization. Program to switch credit limit to zero, if customer has any outstanding invoices.

Confidential, Des Moines, Iowa

Oracle Financials Analyst

Environment: Fresh implementation of R12

Responsibilities:

• Responsible for End-to-end implementation of R12 GL, AP, AR,PO and payment from assessment to production as a Financial Functional Consultant.
• 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.
• Gather Business Requirement (BR030), write Setup Docs (BR100), write functional (MD050) specifications, provide recommendations for user challenges, and implement process and system modifications.
• Provide functional expertise to developers during teh technical design and construction phases of teh 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 teh test plans and execute UAT in Test instance
• Perform teh related setup tasks in teh applications that work together with 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.
• Work with using ADI, Discoverer, and Data Load.
• Prepared and Executed Test Scripts for teh functionality of teh whole system.
• Documented AS is process, Target process design, requirements documentation, configuration (BR100) document, user training procedures and month end processing for all teh implementation that me 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.
• 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.
• Gatheird business requirements and translated teh business processes into application setups like setting up various vendors, vendor sites, payment terms, payment banks, payment programs and payment formats, payment batches.
• Carried out vendor conversion due to merger of group companies, converted requisition data and open purchase orders between teh two operating units.

Confidential, Baltimore, MD

Oracle Financial Functional Consultant

Environment: Implementation of 11.5.9

Responsibilities:

• 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 have 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 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.

Oracle Functional Support Consultant

Confidential

Environment: Functional Support (11.5.10)

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 teh 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 teh problem and physical inventory was not updating teh quantity in teh right cost group. Supporting users after going live on all financial modules.

Confidential

Oracle Consultant

Environment: Post-Production Support, Module Extensions & Month-end Process of 11.5.8

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 reports, etc.
• Setting Accounting flex fields, Defining Journal Sources, Journal categories, Document Sequences and their assignment, Chart of Accounts maintenance.
• Month end and Year end reconciliations for closure of subsidiary modules - AR and AP.