SUMMARY

• I am certified Senior Oracle Financial Functional Consultant with over 10+ years of comprehensive experience and also having "Oracle R11 Cloud Financial Functional" experience in Oracle EBS different areas of End - To-End Implementation, Enhancements, CR’s and Upgrades, System Configurations/Setups, Production Support of Oracle Application modules like Oracle General Ledger, Oracle Payables, Oracle Receivable, Advanced Collections, Credit Management, Cash Management, Fixed Assets, EB Tax, SLA, Purchasing, Inventory, P2P and O2C.
• Strong familiarity with AIM methodology and Oracle Unified Method (OUM) in Oracle EBS creating BRD, RD-20, BR-100, MD-50, MD-70, BP-80, MOM throughout multiple Projects.
• Requirement gathering from the business and prepared current business base line and scope documents using life cycle implementation standards with Oracle AIM Method and Oracle Unified Method (OUM)
• Detail understanding of business and documentation ‘as-Is’ and ‘To-Be’ Organization structure and process.
• Done Oracle EBS 11i & R12 implementation, roll outs, enhancement, upgrade projects, Go-Live and Production support and
• Worked as testing lead and tested End-to-End functional and technical business process for projects.
• 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.
• Involved in Revenue Recognition setups and process.
• 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 in EBS.
• Experience in reviewing Test Procedures, Test Cases and maintaining Test Scripts, analyzing bugs, interacting with team members in fixing errors.
• Thorough testing of user issues in Test/UAT/Dev instance before moving it to production
• Maintained CRP1 and CRP2 processes.
• 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 and 12.1.3

Oracle EBS Financial Modules: General Ledger, Accounts Payables, Account Receivables, Advanced Collections, Credit Management, Cash Management, Fixed Assets, E-Business Tax, Procure-To-Pay (P2P), Order-To-Cash (O2C), iExpenses, Oracle Purchasing, Oracle Inventory, Order Management, Human Resource (Core HR), SLA

Oracle EBS Other Modules: System Administration, Application Object Library (AOL), Oracle Diagnostics, User Management, Legal Entity Manager, Approval Management Engine, ADI.

Oracle 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.

Oracle EBS Certifications: R12 Oracle General Ledger & Accounts Payables.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Financial Functional Lead

Environment: Oracle 12.1.3 - General Ledger, Payables, Receivables, Fixed Assets, P2P, Order Management, 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, Overland Park, KS

Associate Financial Functional Lead

Environment: Oracle 12.1.2 - General Ledger, Payables, Receivables, Advanced Collections, Fixed Assets, P2P, 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
• 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.
• 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

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, Advanced Collections 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.
• 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.

Confidential

Finance Functional Consultant

Environment: Oracle 11.5.9 - General Ledger, Payables, Receivables

Responsibilities:

• Provide regular status updates and monitoring progress on issues as per client requirements.
• Providing daily and monthly remedy reports and chart reports to the business.
• Providing daily and monthly SLA reports Service Level Agreement
• Conducted business process review and gap analysis to determine business requirements.
• Involved setting ups Expense Report Templates and creating expense reports.
• User problem resolution on a timely basis without interrupting regular transactions.
• Assisting the users and end-users in overcome the trouble shoots.