SUMMARY

• Oracle Cloud Financials Lead Consultant with 12+ Years of experience in implementing and extending Oracle Financials Cloud R12/R13 (Fusion Financials, Fusion Procurement, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, Order Orchestration).
• Involved in implementations of Oracle Applications R12 & Cloud R12/R13.
• Strong understanding of Oracle’s Cloud Security Model as it relates to interfaces and extensions.
• Business Requirements Mapping for General Ledger, Accounts Payable modules, Accounts Receivable, SLA, FAH and Cash Management modules.
• Well Experienced in Oracle Cloud Enterprise structure design, chart of accounts design.
• Very Good Experience on Fusion Functional Setup Manager (FSM).
• Expert in integrating Oracle Cloud Services (interfaces, conversions and creating applications usingFBDI).
• Expertise in design and development of conversion programs, interfaces and Trading Community Architecture (TCA) APIs to import data from legacy systems.
• Experience in Business Intelligence reporting tool like Oracle Cloud OTBI, OBIEE, BI Publisher and Financial Reporting Center Tool (Smart View).
• Prepared Functional Documents, Project Schedules, Test Plan, Test Schedule, Test Execution.
• Prepared Test scripts for EBS Disaster Recovery Applications to reduce Execution time.
• Written and executed test scripts for Unit, Functional, Regression, Integration, End - to-End and Go-Live testing.
• Experience in Customizing Cloud Security components like Data Role, Job Role, Duty Role and Security Profiles.
• Extension knowledge and expertise of business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C) and Sub-Ledger Accounting (SLA).
• 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.
• Good exposure to AIM & OUM (Oracle Unified Methodology) Methodologies.
• Experience in using and maintaining documentation of 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 (BR100, BP 80, BR30, BR 150, MD 50, CV 40 &TE 40).

TECHNICAL SKILLS

ERP Application Tools: Oracle Forms 6i/9i/10g, Reports 6i/9i/10g, XML Publisher 5.6.2/5.6.3 , Work Flow Builder 2.6, JDeveloper10g/11g.

Database Tools: TOAD, SQL* Loader, SQL* Plus, SQL* Developer

Languages: SQL, PL/SQL, Java

Web Technologies: HTML, XML, Web Services

RDBMS: Oracle 10g/11g/12c

Operating System: Windows NT/XP/2000/98, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Cloud Financials Lead Consultant

Responsibilities:

• Requirement gathering from the business users and prepared current business baseline and business scope documents using life cycle implementation standards.
• Migrating Data using ADFDI and FBDI templates
• Designing Reporting requirements for OTBI, BI and Financial reporting Studio.
• Configured Payment Approval for Batch Processing and disabled the Single/Quick Payment by assigning the custom AP Role.
• Configured AP Invoice Approval Rule as per the business requirement.
• Created Flow for Access Process.
• Developed OTBI, FRS reports as per the Business Requirement.
• Performed Accounts payable setups that consists of Common Options for Payables and Procurement, Manage Invoice option, Manage Payable calendar, Manage Distribution set, Manage Payment options, Manage Payment Terms, Manage Invoice Tolerance, and Manage Payable Document Sequence.
• Performed Accounts Receivable setups that consists of Define Common Accounts Receivable Configuration, Manage Receivable’s Document Sequence, Manage Transaction Type, Manage Transaction Source, Manage Auto-Accounting Rules, Define Receivable Activity, Define Customer, Manage standard Memo lines.
• Performed Cash Management module setups configuration that consists of Manage Bank, Branch, and Account, Manage Reconciliation Matching Rules, Bank Statement Transaction.
• Ensure operational readiness is achieved for new capabilities and systems being enabled for internal as well as for external customers in the market.
• Analyze and define information needs and reporting/analytical requirements across the organization and translate those into functional requirements.
• Used FBDI Journal Import template for bulk upload of Oracle Receivable transaction & Receivable customers for closing balance
• Strong integration experience in multiple interfaces integrating with Oracle Cloud ERP both inbound and outbound.

Environment: Oracle Cloud ERP, BI, OTBI, BPM, FRS, SmartView, FBDI, ADFDI

Confidential, Rockledge, Florida

Senior Oracle Cloud Financials Consultant

Responsibilities:

• Configuring fusion payments - Receivables - Payments for funds Capture Activities, Setting Up Funds Capture for Receivables
• Interacted with end users and translated their requirements into documents that catered the logic for implementing user requirements.
• Worked on Functional design, business requirement and implementation of Oracle Financials Cloud.
• Created reports using Financial Reporting Studio (FRS), Smart View, and Oracle Transactional Business Intelligence (OTBI).
• Worked on Oracle Fusion Functional Setup Manager (FSM) to implement Global Financials and performed initial steps like implementation users, data roles and loading and managing the geographies, audit and scheduling.
• Prepared the configuration work books and validated the same with clients in terms of design and data of the new Fusion Cloud Application.
• Translation of Functional, Technical requirement specifications into test plans.
• Identify and tracks defects and interact with development staff to isolate and resolve, retests to confirm defects have been corrected.
• Extensively worked in developing the automated scripts for Oracle Financial Modules using QTP10/UFT11.0 and OATS.
• Developed and executed Test cases and Test Procedures for all aspects of QA including functional and compatibility testing.
• Used the Sandbox to customize the Application look and feel as per the client's requirement and Updated the Company logo as per the legal requirements.
• Developed OBI Reports/OTBI Analytics for Fusion Payables, Receivables and GL Cloud modules.
• Data Loading/Conversions/Integrations using Financial Based Data Import (FBDI) which includes the payables data, Supplier data, Customer relationships data, Order info and Order Management Data.
• Used advanced Oracle concepts to dynamically fetch the SIS outbound columns definition from configurations like custom forms and lookups.
• Strong integration experience in multiple interfaces integrating with Oracle Cloud ERP both inbound and outbound.

Environment: Oracle Fusion Cloud (Fusion Financials, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, Accounts Receivables, Accounts Payables, Procurement), BI Publisher, FRS, SmartView, OTBI,, FBDI and ADF DI

Confidential, Buffalo Grove, IL

Oracle Cloud Financials Consultant

Responsibilities:

• Configuring Fusion Payables - Supplier Model, Create Payment Term, manage invoice options and payment options
• Configuring fusion payments - payables - Payments Activities, Payment System, Payments and submitting a payment process request.
• Configuring Fusion Receivables - Receivable Activities, Receivables System Options, Receipts, Customer and Profile Class.
• Configured Work structures, Payroll Costing, Payroll components like elements, balances, etc.
• Configured Benefits such as Life Events, Eligibility Profiles, Programs, Plan Types, Options, Plans, Rates, Elements, Extracts, etc. for multiple vendors.
• Worked on Oracle Fusion Cloud Financials, Fusion Procurement, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, General Ledger, Accounts Receivables, Accounts Payables.
• Interacted with end users and translated their requirements into documents that catered the logic for implementing user requirements.
• Created outlines, calculation scripts, member formula and business rules, Data forms, reporting with Smart View.
• Worked on Setup for integration between PBCS (EPM) and Fusion Financials clouds services using Data management in PBCS (EPM).
• Created reports using Financial Reporting Studio (FRS), Smart View, and Oracle Transactional Business Intelligence (OTBI).
• Worked on Oracle Fusion Functional Setup Manager (FSM) to implement Global Financials and performed initial steps like implementation users, data roles and loading and managing the geographies, audit and scheduling.
• Worked on Order to Cash Cycle and Cloud Enterprise Structure.
• Conduct Conference Room Pilot (CRP), SIT and UAT s, and end user s.
• Built Custom Security to Fusion Modules which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles using APM, OIM and Security console.
• Supported technically as well as functionally during two successful GO Live for same client.
• Developed new BI reports to extract the absence details and related other reports.
• Developed and configured new roles (Job, Duty and Data roles) using the Fusion Security model.
• Defined Test cases and validated on various Custom solutions.
• Tracking Issues logged by user and provided solutions.
• Involved in Functional, SIT, Regression, Performance and UAT Testing.
• Involved in Test Plan, Schedule, Estimation and Test execution/defects management metrics.
• Prepare and review test scripts based on the business requirements.

Environment: Oracle Fusion Cloud R13, (Fusion Financials, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, Accounts Receivables, Accounts Payables, Purchasing, Oracle PBCS and EPBCS), BI Publisher, SQL*Loader, Toad, HCM Extract, FRS, SmartView, OTBI, FBDI, HDL.

Confidential

Oracle EBS Financials Consultant

Responsibilities:

• Involved in testing for Payables, General Ledger, Assets based on deep understanding of the functional processes.
• End to End Configuration testing of GL Setups of Legal Entity, Primary Ledger, Secondary Ledger, Operating Unit and Reporting Currency
• Extensively involved in systems testing of production fixes related to Setups, Data fixes, Month End Data fixes, Code Changes, Patch application, and supported business during regression and UAT phases.
• Responsible for reconciliation of month-end/Quarter end reports.
• Assisted the UAT user in execution of test scripts and test the UAT Instance for UAT Signoff.
• Creating Test plan, Test Scenarios and Test cases based on Business and Functional requirements.
• Post production support, Performance tuning and Query optimization for Reports and Interfaces using Explain plan
• Create and setup customers and its profile class.
• 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.
• Provided production support on GL, AP, AR, FA, PO, and modules and resolved period end closing and interface issues in production. Trained user on process design and enhancements.
• Translating the functional requirements to the technical team for developing various reports and financial statement.
• Managing Finance track Month End Closing.
• As per Oracle AIM methodology review the existing business processes and map them with Oracle standard functionality.
• Performed complete setup for GL, AP and AR as per business requirement
• 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.
• Identifying standard functionality, analyze gaps document and design solution for GL & AR depending on Business requirement.

Environment: Oracle E-Business Suite R12(12.1.1) AP, AR, FA, CM, GL, Inv, OM, PO, BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, Workflow, SQL * Loader, UNIX

Confidential, Wilmington, MA

Oracle EBS Financials Consultant

Responsibilities:

• Created and checked the order submission process from different customers for different items and groups.
• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents.
• Developed Credit Packing Slip Details Report and Open Item Details Report using XML/BI Publisher.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Organizing walkthrough session for review and sign off on Test plan, Test scenarios and Test cases.
• Involved in performing Functional, Regression, Integration, End to End and User Acceptance Testing.
• Studied, understood the Planning operations and solution in Value chain planning a very unique design, model that is very different from standard flow.
• Documented the new business processes, also provided with materials, Test Scripts to the business users.
• Conducting testing events like CRP1, CRP2 and UAT.
• Involved with migration of historical data for Account Payables.
• Created newer FSG reports depending on the business requirements.
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components.
• Provided period end closing process for Payables and General Ledger. Resolved period end closing issues.
• Prepared Functional Specification for customization to achieve the business requirement
• Designed functional solution, to keep various factors in mind like, performance improvement, easy maintenance and less defect opportunity after regular patching cycle.

Environment: Oracle EBS R12 (General Ledger GL, Account Payables AP, Account Receivables AR, TCA, Inventory INV, Order Management OM), Oracle 10g, TOAD, PL/SQL, Forms 10g Reports 10g, XML/BI publisher 5.6.3, SQL*Loader, Shell Scripts.