SUMMARY:

• Highly experienced in the financials domain with more than 11years as an Oracle Private and Public Sector Financials Functional consultant with extensive experience in all financial modules in Oracle E - business suite
• Expertise in Oracle Applications Functional experience in multiple implementations, Upgrade and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Extensive work experience and 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), Advanced Collections, I-Receivables, I-Payments, iExpense, Fixed Assets (FA), Cash Management (CE), Treasury (XTR), 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), Budget to Report (B2R), Record to Report (R2R) etc.
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle.
• Involved in Assessment of business requirements, Auto Invoices, Customer TCA Management, Pre-payments, Collections, Advanced Collections, Tax Integration for AP and AR.
• 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 Co-ordinateUAT 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 items.

Oracle ERP: Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, iExpense, Sys Admin, SLA, P2P, O2C and A2R, R2R, B2B, B2C Customer Care, OM, Oracle Payments, Advanced Collections, Billing, Collections, i-Receivables, SCM/MM/INV/ENGINEERING.

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

PROFESSIONAL EXPERIENCE:

Confidential, Knoxville, TN

Oracle ERPFunctional Lead Consultant

Responsibilities:

• lved critical issues on FSGs, multi-org setup, SLA accounting and GL closing during the upgrade
• Implemented GST changes in multiple Operating Units
• Prepared setup documents and setup all existing applications GL, AP, AR and Taxes
• Setup of Desktop ADI and test the creation of Journals along with Web ADI
• Setup new Orgs, Operating Unit (New OU for Australia), banks, bank addresses, accounts, suppliers, accounting rules, security rules etc. and data migrations.
• Configured many rollup groups to reflect in reporting for financials.
• Enabled the GL workflows and approval limits
• Testing the entire process of payables transfer to GL.
• Resolved Conversion and Translation issues and prepare conversion user guide.
• Defined Customers, customer profile classes, payment terms and distribution sets, and Auto Cash Rule sets.
• Defined Invoicing information including Payment terms, invoicing and accounting rules, Territories and Invoice Sources.
• Setup the rounding rules in AP to support accounting.
• Document fit/gap analysis and get approval from management
• Participated in finalizing R12 impact on Global Processes, educate/train users on the major R12 Changes
• Resolved application issues related R12 upgrade, configure and document BR100 and procedural changes
• Prepared test scenarios and guide the users and resolve issues during different phases of testing
• Participate in the project status meetings and various stages of project planning, issue status, go-live planning and detailed go-live technical/functional tasks
• Re-defined all the Auto Invoice import request sets in R12.2 for more than 5 Operating Units based on the Currency.
• Dealt with Finance team to drive the proper setups for Intercompany accounting.
• Implemented new Auto Accounting rules for Receivables to drive correct accounting.
• Implemented Dunning Letters in Receivables for customers to send on a monthly basis based on aging of the Invoices. Worked on TCA for customer master project which involved lot of data cleanup.
• Setup SLA for Receivables for third party merge activities.
• Implemented Payments (iPayments in 11i) Funds capture process in R12.2.4 and implemented SFTP configuration with Chase Paymentech. Defined Routing Rules based on the transaction type and currency.
• Implemented custom check printing, funds disbursement and defined EFT/Wire payments in R12.2.4
• Re-configured All the taxes in EB-Tax (Location base/Sales Tax, GST, HST,CT, VAT etc.)
• Created Regimes, taxes, tax codes and tax rates. Trained users to update the Tax rates based on the requirement for that Tax code. Documented all the updates and changes for future use.
• Defined setups for Oracle AR like Auto Cash Rule Set, Grouping Rules, transaction sources, Transaction types, payment methods, payment terms, Sales tax flex fields Structure, System Options, collections, receipt class, receipt sources.  Defined Centralized Tax Setups in E-Business Tax module.
• Configured Trade Management to handle disputes and advanced collections.
• Configured Advanced Collections to streamline collections process.
• Designed and setup scoring engines for Receivables, Advanced Collections.
• Resolved many accounting issues in AP and GL and Recon related issues
• Tested many patched for R12.2 version and documented issues and resolution
• Supported Interfaces with SOA in 11i PRD and R12 development for upgrade.
• Documented all the changes in R12 and knowledge transfer to business users and Superusers.
• Conducted CRP1, CRP1, SIT & UAT sessions and made sure to get the users hands on with the R12 functionality
• Work with Oracle support through service requests on any critical issues/data fixes etc.
• User training on Cash Management module on clearing checks and Bank setups and Accounts Maintenance
• Designed new Intercompany transaction model in AR and Improved Collection process for Intercompany transactions using new features of Advanced Collections in R12. Designed a new model for commercial Collections transaction.
• Designed, configured all Payments in New R12.2.4 version to meet business requirement. Custom Checks print testing and co-ordination with bank on checks approval process.
• Worked on many objects testing and co-ordination with offshore team on development work
• Configured Auto Invoice Import program and completed Order to Cash cycle

Confidential, Windsor Mill, NY

Sr. Oracle Federal ERP Lead

Responsibilities:

• Analyze the business requirements and functional specifications for creating Requirements Traceability Matrix (RTM) and testing of the major modules like Account payables, Account Receivables, General ledger, Purchasing and Federal Admin modules that are being implemented in HIGLAS.
• Involved in making the detailed Oracle Financials Test Plan regarding the scope and focus of the testing.
• Testing the production fixes of Setups, Data fixes, Month End Data fixes, Code Changes, Patch testing (Oracle, Autosys, WebSphere)
• Round trip testing/Autosys/WCC for the following inbound interfaces 271, 274, 811R, 811S, 837, 810 and outbound interfaces of 835 and 811V as part of the daily work basis
• Performing regression Test suit (Automation), Round trip validation with Treasury for NTDO related changes, Performance Engineering reviews and approvals
• Developed test scripts, process flows and strategies for testing all processes
• Testing the database using SQL queries
• Involved in the functional testing using Mercury Quality Center
• Supported more than 70 contractors and conducted UAT sessions for each quarterly releases, as well as production support.
• Involved with all phases and stages of software life cycle including end-to-end system testing and business requirements analysis
• Worked on document repository tools like e-Room, Web Center, Clear Quest, Clear Case.
• Proactively involved in identifying and troubleshooting the data /code related issues. Coordinated the Development team and conducted and participated in status meetings
• Updates to the Financial Reconciliation FSD documents to reflect the R12 Changes

Confidential, Albany, NY

Sr. Oracle Public Sector E-Business Suite Functional Lead

Responsibilities:

• Supervising the process and functional design activities
• Identified functional requirements as an input to application design
• User Support Analysis: Research solutions to problems, answer client questions and provide consulting and training as required. Track software and documentation issues.
• Identify, diagnose and document system issues.
• Assess how well a product adheres to its design.
• Prepared Impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.1.3
• 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, PO depending on Business requirement.
• Defined payment terms, Accounting Rules, Accounting Periods, Invoice Sources.
• Resolved many accounting related Recon issues which are included like encumbrance accounting and accrual accounting.
• Defined Bank information, receivables quick code, auto invoice grouping rules, transaction types.
• Setup AP payable system option, financial options, and payable options.
• Conducted several user-training sessions on the system upgrade tasks- Trained in Sub Ledger Accounting, Budgets, Encumbrances and terminology changes from 11i to R12.
• Responsible for preparing upgrade plan for GL, AP, PO, AR, and I-Expenses with all customizations and form personalization.
• Raised SR for several issues and resolved them.
• Prepared impact analysis document for the upgrade of financial module.
• Supported more than 7 years of data migrations into Oracle from Legacy.
• Investigated the current system (11i) and provided the better solutions as per the business requirements.
• Supported Confidential integration with SFS/CAS PeopleSoft financial system.
• Assisted users with training sessions and documentation
• Facilitating end-user training and developing the various users training manuals and conducted the UAT sessions.

Confidential, Long Island, NY

Sr. Oracle ERP LeadConsultant

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).
• Provided Functional assistance in the implementation of I-Receivables and other Internet modules.
• Identify & Document Gap Business Requirements for Oracle GL, Purchasing & Oracle Payables Applications.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Involved in Tax setups in EB-TAX for AP and AR.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data.
• Involved in Configuration of Oracle I-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items.
• Analyzed client customizations on Progress Billing & Revenue Recognition processes to propose new solution strategy regarding local market RST (Regulatory, Statutory and Taxation) requirements.
• Developed Functional design documents to support to-be business processes.
• Implemented Lockboxes in AR with Chase Bank to reduce huge manual effort in applying cash in Accounts Receivables.
• Create & updating BR100 / setup documents for AR, 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.
• Created few Regimes and loaded the tax rates and trained users on how to update the rates manually.
• 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.

Confidential, Seattle, WA

Sr. Oracle FinancialsSubject Matter Expert

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.
• Involved in all EB TAX setups for INPUT and OUTPUT taxes for Payables and Receivables Modules.
• 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.
• Implemented location based tax for AP and AR through EB-TAX.
• Defined Tax features such as Codes, Rates, Exceptions and Exemptions
• Implementation of country localizations like currency, COA, Calendar, taxation and formats.
• 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.
• Integrating iPayments, iCollections, iExpenses and iReceivables along with Advanced collections and Accounts Receivables.
• 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, Salt Lake City, UT

Oracle Functional Lead

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, and 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
• Defined and maintained setups for Oracle AR, AP like Auto Cash RuleSet,GroupingRules, transaction sources,Transaction types, payment methods, payment terms,  EB-Tax, Canadian Tax, PST, QST, GST, HST, tax flex fields Structure, System Options, collections, receipt class, receipt sources.
• 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.
• Resolved many withholding tax issues in Payables and supported Auditors.
• 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, Los Angeles, CA

Sr. Oracle Financial Functional Analys

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, Rochester, NY

Sr. 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, Rochester, NY

Oracle Financial Analyst

Responsibilities:

• Involved in the Functional Setup of GL, AP, AR, and PO
• Identified gaps between system processes and Business processes and documented using Gap Analysis Document. Also analyzed and indicated proposed workarounds and resolutions
• Business process study and creating business process maps using Visio for Oracle E-Business Suite GL, AP and AR modules.
• Gathered, analyzed and wrote detailed business requirements, user profile, created workflow processes documents and charts.
• Customized the Invoice Aging and Customer Balance Report in AR.
• Knowledge of Performance tuning of various queries and stored procedure
• Developed several BR 100s of GL & AP to fulfill the business need.
• Worked with business users to define their business requirements in preparation for developing program solutions and translated the requirements into 11i Processes
• Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template. Tested features Translation, Reevaluations, and consolidation.
• Prepared end user training material with specific business cases and conducted end-user training.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities.
• Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader.

Confidential

Oracle Financials Analyst/Advisor

Responsibilities:

• Complete Assessment of Solectron Business Process. To understand existing COA structures.
• Upgrade from 10.7 Character Based Applications to Oracle11i using OracleEasiPath Migration Method(EMM).
• Setup and tested ACH/Wire transfer.
• Gap Analysis between existing Application and Customization, using Oracle EMM Methodology
• Training User on New Rel.11i Application Functionality, GL, AP and Purchasing
• Identify the patches that need to be applied to prepare the Release 11i environment for implementing Oracle Internet Procurement.
• Complete Setup that must be completed before setting up Internet Procurement.
• Steps needed to setup catalogs Workflows and custom packages used by Internet Procurement Setup required for shopping at external sites.
• Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines.
• PO matching options, invoice tolerances, distribution options, terms, holds, etc.
• PO setup and matching options with invoices.
• Designed and configured setups in Inventory, Purchasing and AP modules to meet the Purchase Requisition.
• Setup the workflow for creating purchasing documents automatically to PO Create Documents.
• Setup CRP-II and training, expand core Team knowledge of Oracle11i.