SUMMARY

• Over 8 years of Industry experience, which includes over 7 years of experience as an Oracle Financial Functional Consultant (11i and R12) with multiple industries.
• Good experience in Designing, Implementing, and Testing of Oracle E - Business Suite - Financial modules which includes General Ledger (GL) including AGIS (Advanced Global Intercompany System), COA Maintenance, Accounts Payable (AP), Accounts Receivables (AR), Fixed Assets (FA), Cash Management (CE), iExpenses, iProcurement, and System Administrator (Sys Admin).
• Extensive knowledge in Implementation, Up-gradation and Support projects of Oracle Financial Modules (GL, AP, AR, Assets, and CE) and understanding their interaction in the overall accounting structure of an organization.
• Oracle R12 experience in GL, AP, AR, CE and Assets modules with MOAC (Multi-Org Access Control), MRC (Multi Reporting Currency) including SLA (Sub-Ledger Accounting).
• Prepared business process, business requirements and configuration documents, which includes BR30, MD50, BR100, RD50, BP30, BP40, BR20, BP80, CV40, BR150, and TE40.
• Experience in analyzing the Business Process flow and providing Gap and Fit analysis.
• Worked with all levels of business managers and users during different phases of the project life cycle with requirements to development, configuration, validation, go-live, production support and end user training.
• Complete understanding of business process flow in Procure to Pay (P2P), Order to Cash (O2C), and Acquire to Retire (A2R) cycles.
• Functional knowledge of Oracle reporting tools - FSG’s (Financial Statement Generator) and WebADI.
• Experience in Data Conversion from legacy system to Oracle 11i/R12.
• Co-ordinated with Oracle Support to resolve application issues, bugs and TAR/SR management.
• Created user manuals and provided training to a large group of business users, conducted several CRP’s (Conference Room Piloting) and UAT’s (User Acceptance Test).
• Always exceeded expectations of project work and contributed significantly in teamwork. Have worked across many domains and industry verticals and capable of handling multiple responsibilities without compromising on the quality.
• Excellent communication skills, ability to perform individually, good interpersonal relations and self-motivated.
• Worked in a multicultural and multi-ethnic environment with coordination across different time zones including On-Site/Offshore model.

TECHNICAL SKILLS

Application Versions: Oracle E-Business Suite Versions R12 and 11i (11.5.9, 11.5.10, 11.5.10.2, R12.0.1, R12.0.3, R12.0.6, R12.1.1 R12.1.3)

Experience on Modules and Key Cycles: GL, AP, AR, CE, Assets, AGIS, P2P, O2C, R2R, and A2R

Operating Systems & Database: Windows, Linux, Macintosh, UPK (User Productivity Kit), Proficient in Microsoft Office Suite, Oracle 11/10g

Other Tools: Data Loader, ADI, WebADI, OBIEE, Bugzilla, SQL Loader, XML Publisher, Discoverer and TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle Financials Functional Analyst

Responsibilities:

• Preparing functional documents according to the requirement gathering, update the existing RD20 and BP80 documents according to AIM implementation methodology.
• Preparing Visio Process diagrams for As Is/To Be scenarios for GL.
• Conducted regular meetings with business for Requirements gathering and training
• Configuration of CRP1 and UAT instances for GL and AP modules, and support the Business Users
• Update COA Maintenance To Be Flow, Set up of Recurring Journals, Mass Allocation, GL Alias, and Journal Approval Business Process
• Compared the BR100 with CRP/UAT instance, and suggested the recommended changes
• Design and Configure Financial Statements Using FSG
• Defined GL Responsibility, Value Sets, Defined Key Flexfield Segments in CRP Instance.
• Defined Period Types, Accounting Calendar, Currencies, and Setup Ledgers on CRP Instance
• Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, and Establishment Setups, MOAC security
• Train business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers
• Developing GL, AP, AR and CE Training Guides using UPK
• Set up AP bank accounts, bank documents, bank codes and expense report templates
• Set up Financial options & Payable options in AP, defined payment terms and invoice approval hierarchy.
• Enabled Assets Key, Category and Location Key Flexfield
• Defined the prorate calendars, depreciation rate and calendars, fiscal calendars and book controls
• Assisting configuration of CRP and other test instances and Coordinating with the users for the User Acceptance Testing (UAT)

Confidential, San Jose, CA

Oracle Financials 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.
• Created and defined custom FSG reports as per the client’s requirement.
• Support business users during Month End Close (MEC).
• 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.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
• 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.
• Created roll-up groups, summary accounts and suspense accounts for automatic balancing journal entries from particular sources and categories.
• Implemented AGIS among all the Entities.
• Helped users during the month-end process (MEC) with GL (Including AGIS), AP, and AR modules. Assisted on the discrepancies between Primary and IFRS Ledgers during month end.
• Worked with thebusinessto recommend appropriate training, communication and scheduling as systems are deployed.

Confidential

Oracle Financials Functional Analyst

Responsibilities:

• Involved in preparing the impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.1.3.
• Prepared future business process documents BP80, application configuration setup document BR100 and application extensions functional design documents MD50.
• Identified business needs, gaps and requirement analysis.
• Defined value sets, key flexfield segments and roll-up groups with security and cross-validation rules.
• Used web ADI to integrate the GL module to the Excel spreadsheet.
• Created the general accounting functionality by setting up Chart of Accounts, Currency and Fiscal Calendars.
• Defined the Ledger, Ledger Sets, Accounting Periods, Automatic Posting and Journal Sources.
• Data migration from Oracle 11i into Oracle R12 using Export, Import and SQL*Loader.
• Setup and defined Financials and Payables options.
• Defined Suppliers and Bank for Accounts Payable.
• Created and defined custom FSG reports as per the client’s requirement.
• Involved in troubleshooting and issue resolution with Oracle applications financial modules.
• Created training material and conducted user training for GL and AP module.
• Conducted CRP 1, CRP 2 and updates conferring to the business requirements.
• Conducted UAT and resolved all the issues in time before Go-Live.
• Configured DEV instance, CRP 1 & 2 instances 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.

Confidential, Novata, CA

Oracle Financials Functional Consultant

Responsibilities:

• Understanding Business requirements and preparing BR100 document.
• Actively participated in collecting current business process documents.
• Preparing BP40, CV40 documents and MD50 for RICE components.
• Involved in setting up the configuration for CRP 2, Test Instance and UAT.
• Trained end users to get familiar with the Wed ADI tool to upload day-to-day adjusting journal entries.
• Prepared Test Scripts for Development Instance (TE20) and Integration Testing (TE50).
• Writing validations before importing the data into tables and then running the interface programs.
• Setting up consolidation ledgers and AGIS for intercompany transactions.
• Setting up Multi-org (MOAC) and Multiple Reporting Currencies.
• Involved in the development and customization of reports as per business requirements.
• Define payment terms and recurring invoice templates. Set up employee expenses template.
• Created some descriptive flexfields to capture additional information for the client not available in standard Oracle forms.
• Prepare impact analysis of critical issues and resolved all the issues raised in Bugzilla.
• Interact with the Oracle Support to resolve critical issues through SR/TAR.
• Provide support to users during go-live by way of problem solving and instructions.
• Provide Post Production Support with follow up on open issues from Go-Live phase and prioritize based on business need for speedy resolution.

Confidential, Simsbury, CA

Oracle Financial Functional Analyst

Responsibilities:

• Worked with the client team in understanding the Business Process to prepare the Business requirement definition document.
• Mapped the future process requirement into Oracle Payables module and identified the gaps. Analyzed the identified gaps and updated BR100 and MD50.
• Defined payment terms, recurring invoice templates, employee expense templates and distribution sets.
• Supported for the implementation of Procure to Pay (P2P) cycle.
• Coordinate on PO for all AP dependency areas including taking lead on few areas in PO.
• Activated selected descriptive flexfields to capture additional information for the client not available in standard Oracle forms.
• Performed the unit and integration tests.Prepared Test Scripts and participated in the Conference Room Pilot (CRP) test for all the modules implemented by the client.Worked with the client team to carry out Accounts Payable period end closing.
• Involved in preparing documents for the Accounts Payable Module, including business requirement mapping document, security profile document, conversion strategy, and setup document.
• Conduct user trainings for AP and created training material for the same.
• Configured CRP 2, CRP 3 and UAT instances and updated test scripts, scenarios and BR100.
• Conducted CRP 2 and CRP 3 before Go Live.

Confidential, Warrenville, IL

Oracle Financials Functional Analyst

Responsibilities:

• Involved in month-end support for close and reconciliation for AP and AR modules.
• Prepared impact analysis of critical post-production issues.
• Resolved issues that occurred in the production phase.
• 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.
• Actively involved in troubleshooting various issues.
• Updated documentation for the proposed custom process issue resolutions.
• Provided functional analysis comparison between oracle prototype functionality and existing custom processes.
• Resolved all the issues which were raised in Bugzilla.
• 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 the status meeting.

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Set up the set of books as proposed after defining the Calendar, the Functional Currency and the segments for Chart of Accounts.
• Designed and set up the accounting structure for GL/AP modules and defined system and financial options.
• Worked with the client team in understanding the business process to prepare the business requirement definition document RD20.
• Designed high level To-Be process flow along with effort estimates and a project plan for Global implementation including Ireland and Belgium.
• Mapped the future process requirement into Oracle AP module, identified the gaps and analyzed the identified gaps.
• Carried out the setup of the accounts Payable module, which involves setting-up payment terms, recurring invoice templates, employee expense templates and distribution sets.
• Worked with the technical team for the migration of the legacy data like suppliers and open invoices into an Oracle AP module for production.
• Performed the unit and integration tests, prepared TE40 and TE50 from integration test output.
• Participated in the Conference Room Pilot (CRP) test for all the modules implemented by the client. Guided the client team to carry out Accounts Payable period end closing.
• Defined numerous signing limits for different managers of various cost centers in AP.
• Provided basic training for the key users of the client, developed test scripts, and created user manuals.
• Set up the approval hierarchy of the expense reports.