SUMMARY:

• I am certified Senior Oracle Financial Functional Consultant with over 10+ years of comprehensive experience in Oracle EBS different areas of End - To-End Confidential, Enhancements, CR’s and Upgrades, System Configurations/Setups, Production Support of Oracle Application modules like Oracle General Ledger, Oracle Payables, Oracle Receivable, Fixed Assets, Cash Management, Project Accounting, iExpense, EB Tax, Sub-Ledger Accounting (SLA), Purchasing, Inventory, Order Management, P2P, O2C and Q2C
• Strong familiarity with AIM methodology and Oracle Unified Method (OUM) in Oracle EBS creating BRD, RD-020, BR-100, MD-050, MD-070, BP-080, TE040, MOM throughout multiple Projects.
• Requirement gathering from the business and prepared current business base line and scope documents.
• Preparation of RD020 document (As-Is process document) and get sign-off from client. Preparing BP080 Document (Mapping of As-Is process to To-Be Process) and get sign-off from client.
• Done Oracle EBS 11i & R12 Confidential, roll outs, enhancement, upgrade projects, Go-Live and Production support.
• Worked as testing lead and tested End-to-End functional and technical business process.
• Exposure to all phases of Confidential which include design and configuration of Multi-org structure & Global Chart of Accounts, Business Process Analysis, User Requirement Study.
• Configured Primary Ledger, Secondary Ledger, Business Group, Operating Units, Legal Entities, Inventory Org and Sub-Inventory Org in application as per MOAC ( Multi-Org) in Oracle EBS.
• Good knowledge of Release 12 concepts covering Accounting Setup Manager, Sub-ledger - Accounting, Multi-org Access control, e-Business Tax and Payment Setup Administrator.
• Business Process Mapping, Fit/gap Analysis, Production Transition and End User Training.
• Have knowledge on Quote to Cash.
• Experience in creation of executable, concurrent programs, parameters and value set in Oracle application using AOL.
• Done mapping between legacy system and Oracle Staging tables using Open Interfaces/API’s
• Used Oracle standard Open Interface tables for data Migration/Conversion for modules General Ledger, Payables, Fixed Assets.
• Involved in data migration and conversion and prepared templates for financial modules.
• Good understanding of RICE and CEMLI process in Oracle EBS.
• Experience in working roll out and upgrade projects in Oracle 11i to Oracle 12.1.3, 12.2.4 in EBS.
• Written test cases, test scripts and test scenarios to do test by respective module super users.
• Thorough testing of user issues in Test/UAT/Dev instance before moving it to production
• Conduct Conference room pilot testing (CRP1 & CRP2), unit testing, and integration testing.
• Ability to write beginner to intermediate level SQL queries using by TOAD tool.
• Coordinated and managed the deliverables from both On-shore and Off-shore teams.
• Highly motivated and self-driven for timely target achievement.
• Multi-task oriented with strong work ethics and ability to work effectively in a team or individually.

TECHNICAL SKILLS:

Oracle EBS Environment: 11i & R12 - 11.5.9, 11.5.10.2, 12.0.4, 12.1.2, 12.1.3 and 12.2.4 Oracle EBS Financial Modules Oracle EBS SCM Modules

Quote to Cash (Q2C): General Ledger, Accounts Payables, Account Receivables, Cash Management, Fixed Assets, Sub-Ledger Accounting (SLA), E-Business Tax, Project Accounting, Procure-To-Pay (P2P), Order-To-Cash (O2C), iExpense, Purchasing, Inventory, Order Management, Human Resource (Core HR), SLA

Have knowledge on Quote to Cash

Oracle EBS Other Modules: System Administration, Application Object Library (AOL), Oracle Diagnostics, User Management, Legal Entity Manager, Tax Manager, Approval Management Engine (AME)ADIOracle EBS Cloud Financial Modules: R11 - General Ledger, Payables, Receivables, Fixed Assets, Cash Management, P2P, IDM, HCM, BPM and APM.

Oracle EBS Methodologies: AIM &OUM.

Oracle Data Base: Oracle PL/SQL 9I/10G/11G.

Oracle EBS Tools: Data Loader, TOAD, ADI, OBIEE, Discoverer Plus, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Longview, TX

Financial Functional Lead

Environment: Oracle 12.2.4 - General Ledger, Payables, Receivables, Fixed Assets, P2P, O2C, EB-Tax, SLA, ADI, Sys Admin

Responsibilities:

• Requirement gathering from the business users and prepared current business base line documents.
• Mapping the requirements to Application process for respective modules.
• Preparing BP080 Document (Mapping of As-Is process to To-Be Process) and get sign-off from client
• Prepared GAP Analysis, Business Requirement Documents (BRD’s) and Functional Spec Documents (FSD) like MD050, BR100 etc.
• Written test cases and scenarios to do testing as per business requirements.
• Handling tickets and application support to the end-users. When an issue is received, it needs to be analyzed and resolved.
• Coordination with client managers/Key users and other teams for issue resolutions and getting sign-off for release to be moved to production.
• There will also be interaction with other modules consultants/Technical Consultants/DBAs/Developers. run diagnostics requests, SQL’s or any other required to identify or resolve the issue, then run those required (data fix SQL’s when Required) and update SR’s and co-ordinate with oracle support team till closure
• Training the end users and preparing end user training material.
• Production support after go-live & assisting the users in overcome the trouble shoots on daily.
• Supported for period end closing process.

Confidential, San Jose, CA

Financial Functional Lead

Environment: Oracle 12.1.3 - General Ledger, Payables, Receivables, Fixed Assets, P2P, O2C, EB-Tax, SLA,ADI, Sys Admin, Discoverer Plus.

Responsibilities:

• Gathered and Prepared Business Requirement Documents (BRD) for Journal Approvals in EBS.
• Defined required setups and done testing as per standard application for new functionalities in test instance.
• Prepared MD050 Functional Solution Design (FSD) document and BR100 for new functionalities and enhancements in EBS environment.
• Maintained Change Advisory Board (CAB) process for Oracle Data Fix, Patches and Bugs.
• Defined new ADI templates to upload journals in to General Ledger interface tables.
• Maintained Oracle SR’s for Data Fix, Bugs and Patches to resolve issues on high priority.
• Supported for Oracle E-Business Tax.
• On-call production support for day-to-day troubleshoot issues and provided solutions.

Confidential

Associate Financial Functional Lead

Environment: Oracle 12.1.2 - General Ledger, Payables, Receivables, Fixed Assets, iExpense, P2P, Project Accounting, Order Management, O2C,EB-Tax, ADI, Sys Admin, OBIEE

Responsibilities:

• Perform a functional evaluation of your current application environment and analyze existing gaps across your Oracle EBS suite of applications.
• Perform a practice upgrade of a clone instance of your production instance to gain experience with your unique upgrade and environments.
• Performed CEMLI’s evaluation in EBS.
• Prepared planning scope include the upgrade objectives, new features and functionality to be implemented, potential changes, the impact of the upgrade on customizations or interfaces in current environment.
• Maintained Revenue Recognition process and Reports
• Provided Global Finance support for the modules GL, AP, AR, Collections, FA, CE, PO
• Prepared GAP Analysis, Business Requirement Documents (BRD’s) and Functional Spec Documents (FSD) like MD050, BR100 etc.
• Performed complete End-To-End financials modules testing in new version environment.
• Assisting to the Technical team to write code for custom reports as per business requirements.
• Provided functional off-shore support to the users and end-users.

Confidential

Finance Functional Module Lead

Environment: Oracle 12.0.4 - General Ledger, SLA, Payables, Receivables, Fixed Assets, Cash Management, P2P, O2C, ADI, Sys Admin, Data Loader

Responsibilities:

• Gathered and Prepared Business Requirement Documents (BRD) for all finance modules General Ledger, Payables, Receivables, Fixed Assets, Cash Management, Purchasing, Inventory, Human Resource (Core HR)
• Prepared current business base line document RD020 and provided validations.
• Involved in system analysis and GAP analysis in existing business process.
• Defined new Ledgers (Primary & Secondary), Legal Entities, Operating Units, Inventory Organizations and Sub-Inventories.
• Written test cases, test scripts and test scenarios to do test by respective module super users.
• Defined required setups and done testing as per standard application functionality for respective modules (GL, AP, AR, CE, FA, PO, INV etc.)
• Defined MOAC setups and assigned Set of Books, Operating Units and Legal Entities to profile Options.
• Prepared all custom components and migrated in to the respective new Operating Unit.
• Loading Budgets Journals and Balance Sheet Trial Balance through ADI.
• Prepared data migration/conversion templates for all Open Transactions like AP Invoices & Payments, AR Invoices & Receipts for new Operating Unit.
• Provided On-Call production support for Period, Quarter end period close process.

Confidential

Finance Functional Lead

Environment: Oracle 12.0.4 - General Ledger, Receivables, Cash Management

Responsibilities:

• Requirement gathering from the business users and prepared current business base line documents RD020 and business scope documents.
• Involved in system analysis and GAP analysis between Oracle Application and third party legacy system in existing business process.
• Prepared MD050 functional solution design (FSD) document as per existed business solution.
• Prepared Business Requirement Documents (BRD) and Functional Spec Documents (FSD’s)
• Written test cases and scenarios to do testing as per business requirements.
• Extracted AR open Invoices and Receipts from legacy system and populated them into AR Interface tables through SQL Loader.
• AR & AP module integrated with TABS legacy system for reconciliation/auto-reconciliation in Cash Management.
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client requirement.
• Production support after go-live.

Confidential

Financial Functional Consultant

Environment: Oracle 12.1.2 - GL, AP, AR, Project Accounting, Sys Admin, LE Manager, MOAC and OBIEE

Responsibilities:

• Defined required setups and done testing as per standard application functionality.
• Prepared functional solution design document as per existed business solution.
• Provided assistance to the business users when required.
• Provided support for Project Accounting.
• Involved with OBIEE development team for reports development.
• Preparation of test cases and test scenarios against CR’s.
• Assisting the users and end-users in overcome the trouble shoots on daily basis.

Confidential

Finance Functional Module Lead

Environment: Oracle 11.5.10.2 - General Ledger, Payables, Receivables, Fixed Assets, P2P, O2C

Responsibilities:

• Prepared Business Requirement Documents (BRD) and Functional Spec Documents (FSD’s)
• Working on understanding and gathering of Functional Spec designs for Customizations, Personalization’s and inbound-outbound interfaces and preparing Functional Design Documents (MD50)
• Provided and conducted UAT instance for users/end users testing and also to get approval to migrate the same in to Production.
• Handled Roll-out projects for different Legal Entities.
• Production support after go-live & assisting the users and end-users in overcome the trouble shoots on daily basis and on-call support.
• Created SR’s and maintained Sev.1 issues 24/7 support for period end closing process.

Confidential

Finance Functional Consultant

Environment: Oracle 11.5.9 - General Ledger, Payables, Receivables,iExpense,P2P, O2C, TOAD, Data Loader, Discoverer.

Responsibilities:

• Analysis status of the project, clarify any queries regarding the functionality etc.
• Gathering information about existing patch set level in Oracle finance and then working with Oracle to get latest patch available.
• Performed AP and PO functional setups such as Banks, Bank Accounts, Supplier, Supplier Sites, Payment Terms, Financial & Payables Options, Profile Options, signing limits, approval groups, and approval assignments.
• Provided General Finance and Global Finance Production support.
• Define expense report options, templates and assign signing limits.
• Supported code changes/modifications as users requested for custom reports/personalization.
• Preparing Test Cases and Test Scripts against CR’s.
• Assisting the users and end-users in overcome the trouble shoots.