SUMMARY

• Over 8 years of Functional & Business experience in Oracle ERP in a variety of large Projects with Full Life Cycle Implementations, Upgradation and Post Production Support of Oracle Applications.
• Strong Oracle Applications Functional experience in multiple implementations, Upgradation and Post Production Support of Financials Modules in both R12&11i versions of Oracle E - Business Suite.
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials including General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax),Purchasing (PO) and Sys Admin.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
• Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R).
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, and GL Balances.
• Experience in maintaining documentation and using the Application Implementations Methodology (AIM),which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BP 80,RD20,BR30,BR 100, BR 150, MD 50, CV 40 &TE 40)
• Create SR’s with Oracle Technical Support, coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Conducted CRP’s and provided wide range of functional training to multiple business user groups and coordinated UAT sessions.
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.

TECHNICAL SKILLS

Oracle ERP: Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, iExpense, Sys Admin, SLA, P2P, O2C and A2R.

Other Tools: Web ADI, ADI, Toad, Data Loader, Hyperion, Discoverer, Hyperion, OBIE, SQL*Loader, SQL*Plus and MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Seneca Falls, NY

Oracle Financial Functional Analyst

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document (BRDs) for the financial modules from CRP0 thru CRP1.
• Conducted CRP0, CRP1, SIT, and UAT sessions for the financial Modules namely GL, FA, PA, AP, CM and Purchasing.
• Mapped the future state process requirements
• Setup the AP Module for different Operating Units
• Defined Expense report templates in AP.
• Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source&types
• Defined System Options, Accounting Option, Lookups, Payment and Billing term templates.
• Worked with the business users and technical team to enable data conversion from legacy systems to Oracle in CRP1, SIT and Simulation phases.
• Performedand documented systems analysis, validation testing, and development of training documentation (UPK), training of internal staff of enhanced business system functionality.
• Created test documents, performed unit, End to End and User Acceptance Tests for AP, FA, GL, PA and PO.
• Defined Rules and Responsibilities per Confidential super users’ guideline.
• Involved in post-production troubleshooting, bug fixes, raising SRs and working with DI and Oracle Support for escalating issues and finding resolutions.

Confidential, Bethpage, NY

Oracle Financial Functional Analyst

Responsibilities:

• Identified Business Requirements & detailed Solution Design for GL, AP and AR Modules.
• Supported Post-Upgradation from 11i to R12 phase for Oracle Financials Modules.
• Resolved issues raised by users and reviewed major setups in the financial Modules.
• Involved in post-production troubleshooting exercises, bug fixes, raising SRs and working with Oracle Support for escalating issues and finding resolutions.
• Resolved the issues related to payment processing, payment authorization, and suppliers.
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Configured the Refund process in AR and the Automation of invoices in AP.
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report
• Setup PO module and matching options with AP invoices.
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register.
• Ran diagnostic scripts using toad and then gave input to technical team.
• Worked with Oracle Technical Support to resolve the critical issues through SR.
• Configured and implemented the Global Consolidation System (GCS) for the Company.

Confidential, Chicago, IL

Oracle Financial Functional Analyst

Responsibilities:

• Identified Business Requirements & detailed Solution Design for GL, AP and Purchasing Modules.
• Involved in workshop sessions with GL, AP Finance users in detailing out business requirements & map business design with Oracle GL & AP configuration (12.1.3).
• Identify & Document Gap Business Requirements for Oracle GL, Purchasing& Oracle Payables Apps.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data.
• Designed & Developed Oracle iProc and Purchasing Inbound & Outbound Integration with Lawson Legacy Systems.
• Involved in Configuration of Oracle I-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items.
• Defined the employee and buyer.
• Integrated PO and AP modules for Invoice and PO matching.
• Created Purchase order (Blanket, Standard) and Requisition.
• Matched the AP Invoices (3-way) to the purchase Order in PO modules.
• Developed Functional design documents to support to-be business processes.
• Create & updating BR100 / setup documents for GL, AP, PO & iProc.
• 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.
• Involved in design and configuration of chart of accounts, calendar and currency.
• Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing.
• Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
• Developed new FSG reports and customized various standard FSG reports.
• Interacted and worked with the development team to solve the problems faced in the test scenario run.
• Prepared Integration & Customization Unit Test Plans & supported Business / Functional users in testing Integration with Oracle GL, Purchasing & Oracle Payables Applications.
• Conduct CRP’s and work on open items to accomplish within the timelines.
• Create and update test plans and test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Coordinated with Oracle support for high priority open issues for its speedy resolution.

Confidential, Atlanta, GA

Oracle Financial Functional Analyst

Responsibilities:

• Interacted with business and analyzed existing business practices, Prepared and maintained business requirement gathering documents BR 100, BR 30, functional extension and design document MD 50 and identified GAPS.
• Carried out operational analysis (AS-IS),solution design (TO-BE), Building Stage along with configuration of Oracle Financials GL(General Ledger) and AP (Accounts Payable)
• Coordinated CRP’s and was involved in Test Scripts preparation (TE 40), for GL & AP.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Training Super users & power users before start of CRP2.
• Involved in Period Closing & Reconciliation with GL
• Setting up Global consolidation & multi reporting currency & developed FSG Reports for customized Financial Statements.
• Created users and granted responsibilities to the defined users.
• Setting up legal entity, business group and operation unit.
• Setup AP payable system options, financial options, payable options, suppliers and operating units.
• Defined Invoice attributes, payment attributes - Approve, hold and release, special calendar, payment formats, pay group, payable document.
• Worked in Payment process profiles, defined banks, bank accounts &documents.
• Supported month end closing for AP with iPayments.
• Setup CE and created CE Responsibilities
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.

Confidential, Palo Alto,CA

Oracle Functional Consultant

Responsibilities:

• Supported Post-Implementation phase for Oracle Financials Modules.
• Resolved issues raised in Bugzilla.
• Involved in post-production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions
• Involved in Month end support for the period close for AP, AR & reconciliation through CE.
• Resolved the issues related to payment processing, payment authorization, suppliers.
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Resolved the issues related to credit card refund, return, bills only, freight charge return, credit card authorization, consolidated invoicing and receivables
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report
• Worked on development of new FSG reports and customized various standard FSG reports.
• Setup PO module and matching options with AP invoices.
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Setup the iExpense Module for different Operating Units.
• Set up the approval hierarchy for the expense reports and created signing limits for iExpense users in Payables.
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register.
• Configured auto Bank Reconciliation process via CE (Cash Management) module & Automatic Reversal of rejected receipts, and the ability to clear payments and receipts before Reconciliation with the bank.
• Extensively used Toad and SQL Developer to view the tables to troubleshoot production issues.
• Coordinated with the offshore technical team when needed.
• Ran diagnostic scripts using toad and then gave input to technical team.
• Worked with Oracle Technical Support to resolve the critical issues through SR/TAR.
• Run Diagnostic scripts and coordinated with oracle tech support through OWC session.

Confidential, Houston, TX

Oracle Financials Functional Analyst

Responsibilities:

• My responsibilities include requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
• Designed Key Accounting Flex field structure (COA) for Ledger and configured with Multi Org and Multi Reporting Currency setup. Defined system controls, intercompany accounts, summary accounts, journal sources, and journal categories.
• Defined various currencies for multi-currency operations and currency translation, conversion, revaluation for consolidation purpose.
• Made sure Cross validationrules have been setup for various GL codes. Configured Sub-ledger accounting process to GL. Defined Security rules at segment level.
• Configured and Ensured that Payables process had been designed and system had been configured and setup for(Financial option, Payable system option & Payable option) to meet the requirements such as batch invoices, batch payments, employee expense report process, withholding tax, 1099 reporting, cross currency invoices and payments.
• Set up Fixed Assets including defining category, location, and asset key flex fields.
• Defined the prorate convention; prorate calendar, depreciation rate and calendar, fiscal calendar, book controls and system controls.
• Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
• Defined Asset TAX Book Performed Quick Additions, CIP Additions, Mass Additions and Capitalized CIP Assets.
• Performed Asset Transfer, Mass retirement, Reinstate the retirement and Mass Changes in Assets.
• Worked on Construction in Process (CIP) assets, adjustments, and classification of assets.
• Grouped assets associated with a specific project, department, and location to track CIP assets in the organization.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
• Created/Maintained Business process Documents BP80,RD-20,BR-30,BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.

Confidential, Westlake, OH

Oracle Financial Analyst

Responsibilities:

• Prepared Impact analysis document for the upgrade of the financial modules from 11.510.2 to R12.0.6
• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Identified standard system functionality, analyzed GAP document and designed solutions for GL & AP depending on Business requirement.
• Created process documents BR100,MD50, TE40, CV40 for requirement gathering, process design, system configurations, conversions (RICE) and test scripts in AIM methodology as part of project upgradation task.
• Coordinated with project Manager, Business team for deadlines for the implementation.
• Setup Chart of Accounts structure, Currencies, Calendar, Sub ledger accounting method (SLA).
• Defined value Sets, Flex fields and Segment Qualifiers, cross validation rules, security rules.
• Involved in the design and setup of legal entities and the related inventory organizations using the legal entity Configuration
• Functional design and Building Custom BAI2 Lockbox file from (Credit Multiple Message Line) CREMUL file as part of Automated Bank Reconciliation through CE module for AR transactions.
• Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources.
• Defined Bank information, receivables quick code, auto invoice grouping rules, transaction types.
• Setup AP payable system option, financial options, and payable options.
• Involved in the setup of auto invoice workflow. Setting up of banks, bank branches and bank accounts
• Defining accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set, auto invoice tuning.
• Setting up of PO matching options, invoice tolerance, term holds, and expense report templates.
• Involved in end user training and user acceptance testing (UAT), preparation on test scripts (TE 040) and integration testing.

Confidential, Chicago, IL

Oracle Financials Functional Analyst

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document
• Mapped the future state process requirements in AP and iExpense
• Setup the iExpense Module for different Operating Units
• Set up the approval hierarchy for expense reports and created signing limits for iExpense users in Payables
• Involved in the project scoping of the iExpense implementation
• Setup of Policy schedules such as Accommodations, Airfare, Car Rental, and Mileage
• Worked closely with the users to define Daily limits, roles, and locations in Expense reports
• Defined Expense report templates in AP.
• Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source&types
• Define system options, Accounting Option, Lookups, Payment and Billing term templates
• Worked with the business users, technical team to enable conversion of the lease from legacy system
• Performed developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Created test documents, performed unit, End to End and User Acceptance Tests for AP

Confidential, Cupertino, CA

Oracle Functional Consultant

Responsibilities:

• Prepared Impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.0.4
• Involved in preparation of future business Process document (BP80). Prepared Application configuration setup BR100 and MD50 Application Extensions Functional Design documents according to AIM.
• Successfully conducted CRP 1 and CRP 2
• Prepared and did extensive testing of TE 040 test scripts.
• Responsible for preparing upgrade plan for GL, AP & FA.
• Prepared impact analysis document for the upgrade of financials module.
• Prepared the setup documents and configured system according to business requirements.
• Responsible for setting up delta functional like MOAC, Data Access sets, Report Manager, Payment Process.
• Designed Financial Reports using Financial Statement Generator (FSG) tool.
• Month end support in financial modules GL, AP and FA

Confidential- Dayton, OH

Oracle Financial Functional Analyst

Responsibilities:

• Responsible for the documentation (BR.100 -Application Setup and TE.040 -System Test Script) and setups of the General Ledger and Account Payables Modules
• Created BR100 documentation for GL and AP
• Interacted with the client team to understand the existing business practices and prepared the business requirement definition document
• Participated in designing the chart of accounts to meet the client’s business requirements
• Created Customized responsibilities, customized menus, customized request groups
• Defined value sets, key flex field segments and roll-up groups with security and cross validation rules, used ADI (Application Desktop Integrator) to integrate the GL module to the Excel spreadsheet.
• Defined Mass Allocation Formula, journals and budgets (standard and formula)
• Developed reports and various data items using Oracle Financial Analyzer and Discoverer
• Used Accounting Setup Manager for Inter-company Transactions.
• Configured Payable Setup Options.
• Worked with Technical team regarding conversion of data
• Provided various custom solutions for client’s specific needs
• Conducted CRP 2, Created user-manuals and provide training end users
• Created Test Scripts (TE-40’s) for UAT sessions

Confidential, Duluth, GA

Oracle Functional Consultant

Responsibilities:

• Involved in Month-end support for close and reconciliation for GL, AP, and AR modules.
• Resolved issues that occurred during production and provide Month end support to all financial modules.
• Interacted with the end users and demonstrated the functionality in details.
• Involved in unit testing and integration testing on various modules.
• Prepared and did extensive testing of TE 040 test scripts.
• Used TOAD, to open multiple instances and query tables using SQL, to figure out issues.
• Assisted in user acceptance testing and CRP’s (Conference Room Pilot).
• Prepared training materials with screen shots, exercises and presentations for critical end users.
• Assisted the technical teams on the customization and extension issues of RICE objects.
• Actively involved in the post production support and troubleshooting on various issues.
• Used Accounting Rules to determine the number of periods and percentage of total revenue to be recognized (Revenue Recognition) in each accounting period.
• Supported the implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on the changing requirements.
• Matched Vendor Invoices to Credit Memos from AP to AR to reduce vendor payments in AP and generated customer Invoices to vendors in AR to interface with get paid.
• Assisted client with iExpense Policy schedules on the basis of location or designation.

Confidential, Collierville, TN

Oracle Financials Consultant

Responsibilities:

• Defined Profile Options to specify certain implementation parameters, Processing Options and System Options.
• Defined Invoicing information including Payment Terms, Invoicing & accounting rules and Invoice Sources.
• Defining System Item Flex Field, Defining Organization.
• Defining receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets.
• Defining receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets.
• Creating customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.
• Set up transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Assigning receivable account, revenue account, unbilled account, fright account, clearing account, and unearned account to transaction types.
• 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
• Fixed Assets, FA Set Up, Books ( Corporate & Tax), Category, Location & Descriptive Flexi filed definitions, Set Up for Fixed Assets Categories, Transactions of Mass Additions, Mass Deletions & Mass Transfers, Fixed Assets Inventory Interface using ADI Tools, and Tax Books Interface using SQL Loader.
• FA Reconciliation Process Set Up, FA with GL & FA with AP, Depreciation Calculations & Period Close.

Confidential, Davidson, NC

Oracle Financial Consultant

Responsibilities:

• Worked with the client team in understanding the Business Process to prepare the Business Requirement definition documents RD20, RD10, and MD50& BR100 (AIM).
• Designed and set up the Set of Books after defining the Calendar, the functional currency and the Chat of Accounts Structure.
• Designed and configured Set of books, Cash management, Accounts receivable, Accounts payables.
• Mapped the Future Process Requirement into Oracle AP module and identify and analyze gaps.
• Carried out the setup of the Accounts Payable module. Defined payment terms and recurring invoice templates.
• Set up Suppliers and Banks for AP use. Set up employee expense templates and distribution sets.
• Defined PO matching tolerances, and invoice approval codes.
• Defined distribution sets, expense reports templates, Locations.
• Set up the format for expense distribution detail report and Aging report, special calendars for key indicators and recurring invoices, and profile options forms.
• Worked with the technical team for the migration of the legacy data like suppliers and open invoices into oracle AP module for production.
• Performed the unit and integration tests. Prepared TE.040 and TE.050.
• Participated in the Conference Room Pilot Test for all the modules implemented by the client. Guided the client Team to carry out Accounts Payable period end closing.
• Did some basic training for the key users of the client.