SUMMARY

• More than 7 years of Professional experience as an Oracle Financial Functional Analyst with Extensive knowledge in both 11i and R12 versions & Oracle Applications.
• Professional expertise in Designing, Implementation, Customization and Testing in Oracle Financials module which include General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E Business Tax (E b - Tax), System Administration (Sys Admin).
• Expertise working on multiple projects in implementation, up-gradation and post production support projects with change management process.
• Excellent understanding of business process flow in Procure to Pay (P2P), Order to Cash (O2C), Acquire to Retire (A2R).
• Expertise in identify Gaps, prepare MD50 documentation with proposed solution and coordinate with technical team in development, test and deliver.
• Prepare Test scripts and conduct smoke tests at different intervals of project phases including issue resolution with extensive research and follow up with Oracle Technical Support on priority Service Requests.
• Involved in Data Conversions/Migration and designed function specific document of data (Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and open receipts) from Legacy System to Oracle applications.
• Interacted with Oracle support to resolve application issues, bugs and TAR/SR management.
• Experience in using Oracle’s Application Implementation Methodology (AIM): Business Functional Requirement analysis, Understanding AS-IS process, TO-BE process, Gap analysis, Solution designing and building RICE components, System configuration, Conducted CRP’s, Co-ordinate BAT, UAT and extensively worked on Preparing documentation (RD 20, BR 100, BR 150, BP 80, CV 40, BR 30, MD 50, &TE 40) and Testing.
• Excellent communication skills, leadership qualities with analytical problem solving skills and thorough knowledge on Microsoft technologies like (Office, Visio and Visual Studio).
• Able to interact effectively with other members of the Business Engineering, Quality Assurance, Users and other teams involved with the System Development Life cycle
• Knowledge of financial accounting and financial business processes, financial accounting process through financial closing, revenue and expense cash/accrual concepts, adjustments and financial statements
• Strong analytical and problem solving capabilities with effective oral and written communication skills

TECHNICAL SKILLS

Oracle Applications: E- Business Suit versions R12 & 11i. GL (SLA - Methods Builder), AP, AR, E-B Tax, CE, FA, PO, and AGIS

Knowledge on other: Module & cycles OM, PO, INV, P2P, O2C, and A2R

Operating Systems: Windows, Linux, MS Visio, PROPEL, Data loader, Bugzilla, EDM, Quality Center. &other Tools MS SharePoint, ServiceNow, ResolveIT

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Oracle Functional Analyst

Responsibilities:

• Provided support to Business Users for all the Production related issues on a daily basis by responding to critical issues and requests.
• Updated Ledger setups, Ledger Sets, Request Sets per business requirement and updated the functional documents.
• Resolved process issues, period end closing and interface issues in GL, AP, FA, PO and E-Business Tax modules.
• Tax configuration included complete set of tax rule as part of tax Regime etc.
• Prepared and did extensive testing of TE 040 test scripts.
• Support business users during Month End Close (MEC).
• Prepared Application configuration setup BR.100 and MD.50 Application Extensions Functional Design documents according to AIM.
• Tax configuration setup using the Regime to Rate flow and setup the tax rules
• Actively involved in the functional configuration of setups and implementation of financial modules throughout various phases since inception till go-live.
• Involved in troubleshooting and issue resolution with Oracle Applications financial modules.
• Conducted UAT and resolved all the issues in time before Go-Live.
• Track all issues and prioritize to follow-up with Oracle Technical Support and conduct OWC sessions for speedy resolution of issues.
• Document all proposed changes along with Functional Impact Analysis as part of the Change Management Process.
• Provided support to project manager in creating new Production Support responsibilities, daily & weekly reporting, and PCM.
• Created new Categories & added major & minor in FA.
• Tested assets by using mass addition template & running depreciations and assets retirement.

Confidential, Milpitas, CA

Oracle Business/Functional Analyst

Responsibilities:

• Documented the functional analysis, research findings and test results with the proposed solutions and recommendations for management approvals as well as future references
• Have followed up with the business for approval of the resolved issues
• Actively involved in troubleshooting various issues
• Accurately created test cases and conduct unit, integration and user acceptance testing
• Efficiently used Quality Center for bug reporting and defect tracking
• Scope new projects, interpret business needs, identifying business rules requirements, and test requirements.
• Worked on documenting various processes, functional requirements, setting up users for UAT, creating training materials and other management specific documentation.
• Assisted in developing BAT plans and test cases based on the business requirements.
• Created and documented process descriptions and process flows
• Creating Change Request Documents.
• Analyzing the change request and coordinating the changes required with the development team.
• Organized meeting with business users to prepare and update Business Process Requirements and System Requirements.
• Prioritized outstanding defects and system problems, ensuring that accuracy and deadlines were met.
• Organized and coordinated review sessions with various project stakeholders to resolve open issues.

Confidential, Houston, TX

Oracle Financials Functional Analyst (GL & AP)

Responsibilities:

• Prepared Impact analysis document for the upgrade of the financial modules from 11.510.2 to R12.0.6.
• Involved in preparation of future business Process document (BP 80). Prepared Application configuration setup BR.100 and MD.50 Application Extensions Functional Design documents according to AIM.
• Conducted CRP 1, CRP 2 and CRP3, and update with the requirement.
• Prepared and did extensive testing of TE 040 test scripts.
• Identified and analyzed existing business practice and prepared business requirement document and identified Gaps
• Created business specific BP 40, CV40, BR100 documents and MD 50 for RICE components
• Configured and set-up new security rules, data access sets, cross validation rules, revaluation template.
• Defined Business requirements for Oracle General Ledger, Accounts Payable
• Involved in finding efficient solutions that involved both work around and customizations to the forms and reports
• Worked together extensively with the end-users to realize and define a precise accounting flexfields structure in Oracle General Ledger
• Defined the Chart of Accounts, the accounting calendar and the currency for each legal entity
• Configured the financials and payables options
• Mapped the Future Process Requirement into Oracle AP module and identified the gaps. Analyzed the identified gaps.
• Set up employee expense templates and distribution sets.
• Defined payment terms, distribution sets, matching tolerances for purchase order matching and set up of bank details.
• Activated some descriptive flexfields to capture additional information for the client not available in standard oracle.
• Set up Suppliers and Banks for AP use.
• Defined Expense report templates in AP
• Conducted CRP and User Acceptance Test
• Conducted CRP, UAT and closed all the issues in time before Go-Live.

Confidential, Chicago, IL

Oracle Financials Functional Analyst

Responsibilities:

• Implementing Accounts Payables, Receivables and General Ledger for all business units of Confidential
• Business communications for the system updates and meeting deadlines for the implementation.
• Identifying standard functionality, and analyze gaps and complete solution for GL, AR, and AP depending on Business requirement
• Setup Banks, Bank Accounts and documents
• Setting-up of AR for invoice transactions including auto invoicing from OM and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting
• Set-up of invoices, debit and credit memos, guarantees, deposit transaction types
• Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies
• Setting up Multi-ORG and Multi Currency
• Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining FSG’s, and Open and Close Accounting Periods
• Setting up Consolidation Ledgers, AGIS for intercompany Transactions
• Setting up AP for PO matching and non-matching supplier invoices, payment profiles for check and wire, sub ledger accounting of payables transactions and transfer to GL
• Conducted CRP 1 & CRP 2, Tested RICE components
• Prepared BP 40, CV40, BR100 documents and created MD 50 for all RICE components
• Conducted UAT

Confidential, Emeryville, CA

Oracle Financials Functional Analyst

Responsibilities:

• Involved in configuration of CRP2, UAT and test instance.
• Conducted UAT and closed UAT issues on a timely basis.
• Configured new prorate conventions based on the fiscal calendars.
• Trained end users in using Web ADI tool to upload day to day adjustment journal entries.
• Prepared BP 40, CV40 documents and created MD 50 for all RICE components.
• Involved in Month-end support for close and reconciliation for AP and AR modules
• Have followed up with the business for approval of the resolved issues
• Actively involved in troubleshooting various issues
• Resolved issues that occurred in the production
• Have followed up with the business for approval of the resolved issues
• Worked with the business to develop updated business policies based on issues resolved
• Resolved all the issues which were raised in Bugzilla
• Prepared impact analysis for critical issues
• Interacted with Oracle Support to resolve critical issues through SR/TAR
• Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting

Confidential - Burnsville, MN

Oracle Financials Functional Analyst

Responsibilities:

• Interacted with the Business and analyzed existing business practice and prepared business requirement document and identified Gaps
• Created Chart of Accounts, calendar and currency according to the business requirement
• Defined Primary Ledger, secondary ledger and defined accounting setup options
• Involved in the design and setup of legal entities and the related inventory organizations using the legal entity Configurator
• Configured Payables System options, financial options and payables options
• Defined Payment Terms and Distribution Sets
• Involved in the setup of auto invoice workflow
• Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source, transaction types.
• Involved in the setup of tax configuration using the Regime to Rate flow and setup the tax rules
• Conducted CRP’s and trained end users for GL, AP and E-B Tax
• Setup Security rules, data access sets, Cross validation rules, recurring journals, revaluation template and translation
• Setup of PO matching options, invoice tolerance, term holds, expense report templates, banks, bank branches and bank accounts
• Conducted User Acceptance Test (UAT)
• Involved in Documentation of Current Business setup (BR 100, BR 30), Conversion (CV 40), Function extension design Document (MD 50), Test script (TE 40)
• Responsible for unit and integration testing
• Worked with technical team for data conversion

Confidential - North Brook, IL

Oracle Financials Functional Analyst

Responsibilities:

• Prepared Impact analysis document for the upgrade of the financial modules from 11.510.2 to R12.0.6.
• Involved in preparation of future business Process document (BP 80). Prepared Application configuration setup BR.100 and MD.50 Application Extensions Functional Design documents according to AIM.
• Responsible for preparing upgrade plan for GL, AP & FA
• 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
• Prepared impact analysis document for the upgrade of financials module4
• Responsible for setting up delta functional like MOAC, Data Access sets, Report Manager, Payment Process
• Responsible for complete functional testing and resolving issues
• Interacted with Oracle support and raised SR for critical issues
• Successfully conducted CRP 1 and CRP 2
• Conducted UAT and closed UAT issues on a timely basis

Confidential - Dayton, OH

Oracle Financials Functional Analyst

Responsibilities:

• Defined Business requirements for Oracle GL and AR, involved in identifying GAPS
• Prepared Documentation of BR 100, BR 30 and Functional Extension and design Document MD 50
• Involved in all the business meetings and communicated with the business for system updates and the meeting of implementation deadlines
• Identified RICE components according to the client needs
• Define Chart of Accounts, accounting Calendar, Currency, defined Legal entities and completed Ledger accounting options as per client requirement
• Designed and created reports for client using the FSG
• Defined setup steps of the AR module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes. Exemptions were defined, as products were not subject to tax in all states
• 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
• Defined accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, and defined aging buckets
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client’s requirement
• Defined formulas for Mass Allocation and Recurring Journals and completed setup of options required to perform Mass Allocations
• Created customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes
• Setup transaction types, invoices, guarantees, deposit, and credit memos, debit memos
• Assigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types
• Conducted CRP 1, CRP2, CRP3 and tested all the setup

Confidential, Sunnyvale, CA

Oracle Financials Functional Consultant

Responsibilities:

• Documented the functional analysis, research findings and test results with the proposed solutions and recommendations for management approvals as well as future references
• Involvement in Budgeting exercises of the company, including preparation and phasing of budget
• Developed ad-hoc journal reports using FSG as well as standard GL reports and AP reports, such as Trial Balance, Payment Register and Invoice Register
• Provided functional review & impact analysis on proposed changes with the existing functionality and prepare MD-50 for the module extensions
• Studied the current accounting structure and suggested changes to improve financial reporting and analysis
• Involved in Month-end support for close and reconciliation for AP and AR modules
• Have followed up with the business for approval of the resolved issues
• Actively involved in troubleshooting various issues
• Resolved issues that occurred in the production
• Prepared impact analysis for critical issues
• Have followed up with the business for approval of the resolved issues