Oracle Cloud ERP Financials Functional Consultant

Oracle Functional Consultant

Nishanth M

Email: ********.****@*****.***

Phone: +1-551-***-****

https://www.linkedin.com/in/nishanth-m-539230299

PROFESSIONAL SUMMARY:

Oracle Cloud ERP Financials Functional Consultant with 7+ years of ERP transformation experience, including multiple full-cycle Oracle Cloud Financials implementations. Deep expertise in Accounts Payable (AP) and Fixed Assets (FA), Oracle Fusion configurations, workflow design, data migration, and reconciliation strategies. Proven ability to lead cross-functional teams, partner with executive stakeholders, and deliver large-scale ERP transformations including SAP and legacy ERP migrations to Oracle Cloud.

Having solid experience on End-to-End as a Functional Consultant in design, development, implementation and upgradation of Enterprise Resource Planning (ERP) systems including Oracle EBS and Fusion

Expertise in Oracle Order Management, Inventory, Purchasing, Supplier Portal, Self - Service Procurement, Sourcing, Supplier Qualification Management, Procurement contracts, Receivables, Payables and General Ledger Modules

Experience in Implementation of Procure to Pay (P2P) and Order to Cash (O2C) Business Processes.

Exposure on SCM Cloud: Order Management and Fulfillment Cloud - Pricing Strategies, GOP (Global Order Promising), Shipping

Well versed with all phases of Software Development Life Cycle (SDLC) methodology such as requirements, analysis, design, implementation and deployment

Demonstrated expertise in Waterfall and Agile Methodologies.

Adept in understanding the “AS-IS” situation as well as in documenting the “TO-BE” business process designs and use case diagrams with proven capability in producing Conceptual Design Document. and Requirements Traceability Matrix (RTM).

Ability to utilize the Oracle AIM/OUM methodologies, good understanding on Business terminology, quickly adaptable to new environments and innovative technologies.

Experienced in preparing Use Cases, diagrams (Activity, Class, Sequence), Business Requirements Document (BRD), Functional Requirement Document (FRD). Experience in conducting SWOT Analysis, Cost Benefit and ROI Analysis.

Proficient in conducting Conference Room Pilots (CRP) and User Acceptance Test (UAT) along with Business Process modelling.

Knowledge on RICEW components (Oracle Reports, Forms, Interfaces, Conversions, Extensions and Workflow).

Experience in writing MD50, BR100, CV040 and test case documents using AIM Methodology.

Closely work with the client to gather the requirements efficiently.

Well experienced in Onsite/Offshore coordination.

Hands-on experience in working with Agile-Scrum development process. Worked closely with Product Owner, Scrum master and technical team to meet the objective of the projects.

Strong knowledge GAAP principal accounting and IFRS accounting for government compliance, and revenue recognition.

Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specification for the product.

Proficiency with SQL queries to perform Data Validation and Back end testing of databases to check the integrity of data.

Worked with cross-functional teams CEMLI (Conversion, Extensions, Migration, Interfaces, and Localization)

Good knowledge on Application Security. Ability to map Business processes in EBS Application.

In-depth understanding of Oracle database structure, table dependencies, and data elements. A good working knowledge of system architecture expected.

Experience on EBS SOA web Services testing Using SOAP UI Tools.

Strong experience in preparing the cut over plan and conversion strategy during production goes live.

Develop custom queries on need basics and provide extract to Business users.

Experience in SLA management, customer communication management and Reporting

Extensively worked on TAR (SR) Creations using Oracle Metal ink and Coordinating with Oracle Duty mangers

Highly motivated self-starter with strong problem-solving and analytical skills.

Team leader with ability to coordinate with multiple clients on Business Process Enhancements.

TECHNICAL SKILLS:

ERP Applications: Oracle Applications EBS 11i, R12 (12.1.3), Oracle ERP Cloud R11, R12

Programming Languages: SQL, PL/SQL

Databases: Oracle 6i/9i/10g/11g, SQL

Modules: OM, INV,PO,AR, AP,GL Advanced Pricing, Payroll, EPM,PPM

Ticketing Software: JIRA, Track it, HP Quality Center, Remedy

Documentation: AIM Documentation (BR.100,MD50, CV40)

Tools: Excel4Apps, Data Loader, Jira,More4Apps, WebADI. SOA (Web Services), SOAP UI, REST API.

Methodologies: AIM, OUM,Agile-Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

McKesson Irving, Texas Jan 2025- Present

Oracle OM Functional Consultant

Responsibilities:

Led endtoend modernization of SOPs across Order Management, Inventory, Purchasing, AR, and Payroll, ensuring standardized, auditready processes aligned with enterprise compliance requirements. (Situation: fragmented SOPs Task: standardize controls Action: redesigned endtoend workflows Result: improved audit readiness & process consistency)

Partnered with Finance, HR, Supply Chain, and Internal Audit teams to document ASIS / TOBE processes, identify control gaps, and embed compliance checkpoints directly into Oracle Cloud and EBS configurations.

Authored and maintained BRDs, Functional Design (MD50), and configuration documents to support SOP governance, change traceability, and regulatory audits.

Configured and standardized Oracle modules (OM, INV, PO, Advanced Pricing, AR, Payroll) to align system behavior with approved SOPs, reducing manual workarounds and operational risk.

Designed compliant Payroll SOPs covering endtoend payroll lifecycle, including payroll definitions, elements, fast formulas, balance definitions, costing, approvals, and statutory validations. (Situation: inconsistent payroll processing Action: reengineered payroll workflows Result: improved compliance & reduced reconciliation issues)

Executed Payroll costing integration with GL, ensuring accurate financial postings, traceable audit trails, and seamless reconciliation between Payroll, HR, and Finance systems.

Supported critical payroll processing cycles (prepayroll validation, costing, reconciliation, and approvals), resolving discrepancies while maintaining strict compliance with statutory and internal controls.

Modernized reporting SOPs by defining functional specifications for Payroll, Costing, and Activity Reports, partnering with technical teams to deliver reliable audit and management reporting.

Streamlined OrdertoCash SOPs by configuring OM profiles, transaction types, pricing rules, freight and special charges, holds, approvals, shipping, and document sequencing, ensuring revenue recognition and operational compliance.

Standardized Inventory SOPs, including item creation, item templates, category assignments, interorg transfers, and IR/ISO processes to improve traceability, data integrity, and control enforcement.

Enhanced ProcuretoPay controls through purchasing setups, shopping category creation, smart forms, and payroll element eligibility rules, aligning procurement execution with corporate policies.

Led UAT and compliance validation cycles, creating detailed test scenarios and scripts mapped directly to SOP requirements, ensuring business signoff and audit confidence.

Troubleshot and resolved highpriority production issues across Payroll, OM, INV, and PO, replicating issues in lower environments and validating fixes prior to production deployment to protect business continuity.

Engaged Oracle Support via Service Requests (SRs) to resolve payroll calculation defects and functional bugs while preserving compliance SLAs and documentation standards.

Coordinated closely with offshore (APAC) and onshore teams, delivering SOP walkthroughs, payroll flow demonstrations, P2P and O2C knowledge transfers to ensure consistent global execution.

Collaborated with DBAs on patching, data migration, cloning, and cutover activities, ensuring SOP adherence during environment changes and production golive events.

Resolved critical complianceimpacting issues related to Payroll reconciliation, costing transfers, and Shipping Execution during highvolume sales order processing, preventing financial misstatements.

Bank United Miami Lakes, Florida April 2022 – July 2023

Oracle Functional Consultant

Responsibilities:

Identify the functional specifications, prepared the documentation setups and maintain Functional Design Document

Worked on Enterprise Structures, Business Units, Payables and Procurement, Reference objects

Configured Applications Security, Job roles, Duty roles, and Privileges, Approval Management Procurement

Worked on the setups and configurations of Supplier Portal, Purchasing, Self-Service Procurement,Sourcing, Supplier Qualification Management and Procurement Contracts

Configured on the Purchasing setups - defining Purchasing document configuration such as line types, document styles, change order templates, value sets and descriptive flex fields

Worked on defining Receiving Parameters - Receipts, RMA (Return Material Authorization)

Worked on the Supplier setups - Numbering, Supplier Type Lookup, Supplier Products and Services Category hierarchy

Worked on defining Payment terms, UOM, Carriers, and Hazard Clauses

Worked on the setups of Financial Orchestration Flow - Currency Conversion, Self-billed invoice, Return to supplier

Worked on the Self-Service Procurement setups - defining the profile options, content maps, Catalog Categories, Catalog types

Worked on the Catalog Categories - local catalog, Punchout catalog, Informational catalog.

Worked on the creating public shopping lists, information template, Smart Forms.

Worked on the setups Sourcing - Negotiation Templates, Negotiation Styles, Cost Factors, Attribute Lists, Line Attributes.

Configured Two-Stage RFQ using Negotiation Styles

Worked on the setups of Supplier Qualification Management - Qualification Models, Qualification Areas.

Created questions for Supplier Qualification

Billing is basically about making sure customers are charged the right amount, at the right time, for what they actually used or purchased.

A good billing process avoids confusion—clear invoices help customers understand what they’re paying for without back-and-forth questions.

Accuracy is key. Even small billing errors can cause delays in payments or damage trust with customers.

Billing also connects closely with finance teams, since it directly impacts revenue, reporting, and reconciliations.

When billing runs smoothly, it speeds up collections and keeps both the business and customers happy

Worked on the Procurement Contract Setups - Clauses, Variables, Numbering Schemes, Deliverables.

Configured OTBI (Oracle Transactional Business Intelligence) Reports for Procurement.

Organized CRP (Conference Room Pilot) during the internal testing phase of the project to identify bugs and glitches.

Work with Oracle Support on Service Requests

PepsiCo New Bern, NC SEP 2019 – March 2022

Oracle Functional Consultant

Responsibilities:

Well aware debugging issues and possess knowledge on important base tables and their contents in P2P and O2C cycles.

Worked on the trading partner setup for the suppliers (xml gateway).

Involved in issues related to OSN for PO and Invoices.

Supporting business users by resolving production issues.

Handled enhancement requests for the existing components.

Worked on performance tuning by modifying queries of the reports and procedures.

Involved in Customer conversions to import customers using Interface tables.

Worked on Auto Invoice Interface to import transactions in AR.

Simplifies the revenue aspects of revenue and increases performance.

Extensively worked on Inbound and Outbound Interfaces from Oracle to various systems.

Activation of various flex fields in the forms to gather the additional information

Developed PL/SQL procedures, functions, packages to validate the data and insert the data into Oracle Standard interface tables.

Used the System Administrator responsibility to define users and assign responsibilities and set Profile options

Involved in the Data Conversion from 11i to R12.1.3 Oracle System for AR Invoices(Auto Invoice), AP Invoice, AP Suppliers, AR Receipts, AP Banks and Open Purchase Orders

Defined Organization Structure, Users and Responsibilities, Security Profiles and Flex Fields.

Tuned SQL queries & Views using Explain Plan, SQL trace

Used data migration tools to migrate Concurrent Programs, Data Definitions, xml templates, request groups, value sets from Development instance to Various Instances.

Worked on SRs with Oracle Support for the handling of bugs in oracle functionality.

Supporting business users resolving production issues.

Involved in the post support activities in Oracle.

Knowledge Transfer to Key Users / Process Owners and End users, User Acceptance, Production Go-Live

Amazon, Bangaluru,India Aug 2018 – Aug 2019

Oracle Technical Business Analyst

Responsibilities:

Worked on Order Import interface, to load all the legacy orders in booked status into Oracle.

Worked extensively on Auto Lock Box to bring data from external sources into Receivables AR base tables.

Customized the Credit Analysis Report, Trucking Manifest and Pick Slip reports in Order Management OM.

Developed Conversion program to import Vendor/Supplier Information into Purchasing PO by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor Information Base tables.

Created Custom responsibilities in GL, AR, OM, and INV and moved all orders booked and status not closed to the new responsibilities for further process.

The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.

Adding and Capitalizing a CIP asset in Fixed Assets FA module.

Designed, developed and loaded data using FA MASS ADDITIONS Interface from Legacy systems.

Worked on the development of Interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM, BOM & SHIPPING.

Responsible for solution design for development of reports across various modules using XML/BI Publisher and Discoverer. Customized the Master/Detail budget report in GL and the Discounts Available

Krio Info Solutions Hyderabad, India May 2017 – July 2018

Oracle Business Analyst

Responsibilities:

Involved in the design, development and documentation of business processes.

Interaction with Team and Management to assure smooth project run.

Interacting with Client on all Implementation Phases.

Conducted End User & Key User Training.

Involved in Requirements Gathering for Oracle Application Implementation.

Mapped the Requirement to Oracle Applications.

Used Application Implementation Methodology (AIM).

Setup the Test, Development and Production Instances.

Involved in UAT and sign-off.

Involved in Setup Document Preparation.

Defining UOM types, Dual unit of measures and their conversions.

Inventory types, ABC rank, Grades, Lot statuses etc. required for creation of Items.

Defining Resources, Activities and Operations for Routing creation.

Creating Inventory and Shop calendar and Defining Shop Day for plant Operations.

Creating Step Dependencies for critical Operations in Routings

Performed detailed Analysis on Client Support Issues in Bug Tracker.

Provided solutions for the Support issues raised by client.

Performing Period End Activities for Client applications every month.

Preparing Technical Specification for technical programs/ reports development.

Evosys – Internship, Hyderabad, Telangana Jan 2016 – Apr 2017

Oracle digital assistant consultant

Responsibilities:

•Support configuration of Oracle Fusion or EBS modules like Inventory, Procurement, Order Management, and Manufacturing under guidance

•Help with data preparation, validation, and migration activities for items, suppliers, and transactions.

•Participate in CRP, SIT, and UAT cycles; prepare functional documentation such as test cases and reports

•Work on analyzing and resolving minor functional issues or defects reported during testing or post-go live.

•Observe and document business processes like Procure-to-Pay (P2P) and Order-to-Cash (O2C) for learning and improvement

•Help in preparing training materials and conducting user training sessions

•Support creation of custom reports and dashboards for operational insights.

•Assist in monitoring and troubleshooting integrations between Oracle modules and external systems.

EDUCATION:

Master’s in information Technology and Management 2025

Bachelor’s in electronic and communication Engineering 2017

Contact this candidate