Offer Zone

$70

Hourly Consulting Rate

Contact Prakash

Prakash Sharma

Independent Consultant

Industry Experience

Accounting

Banking/Mortgage

Financial Services

Insurance

Logistics/Procurement

Pharmaceuticals

Telecommunications

+ 3 More

Location Supported

Canada

United States

Languages Supported

English

Skills

  • Functional consultant
  • Programming
  • Application development
  • Artificial Intelligence
  • Robotics
  • Machine Learning
    • +2 more

Product Specialization

  • Oracle ERP Cloud
  • Oracle E-Business Suite

About

I am passionate Oracle Functional Consultant- ERP/Cloud carrying almost decade long experience in- Consulting, Implementing and Solutioning activities of Oracle ERP(R12) on-Prem and Fusion Cloud SaaS & PaaS (R12, R13) based Projects. I am carrying Innovative, professional skills with proven ability to identify, analyze & solve problems to enhance customer satisfaction.
Experience in Oracle modules of Financials and Supply Chain Management (modules - AP, AR, CM, FA, GL, MDM, FAH, EBTax, PO, INV, OM, iProc and iSupp,). Also have decent exposure to HR modules.

Major tasks performed as a consultant for various clients are - requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, interfacing with users, identifying functional and technical gaps, estimating work, designing custom solutions, producing documentation, and production support.

Top Project Highlights

Aviva Insurance

Oracle ERP 12.1.3 Support and Cloud Implementation

Wayland Group

Oracle Cloud R13 Implementation

Marsh and Mclennan

Oracle 12.1.3 implementation and Support

Employment

Oracle Functional Consultant/Business Analyst

2019 - Present
  • Provided solution how to reconcile rejected EFT payments in Oracle Cash Management. Performed daily reconciliation between Guidewire Billing Center with Oracle General Ledger. Build the automation of reconciliation process to reconcile the various payment method transactions(EFT, Online, Credit Cards etc.) with Oracle GL, Guidewire Billing Center and Bank Details. Performed impact analysis for customer to re-class monthly journals. Resolved the issue at policy level pertaining to customer payment discrepancy. Created insurance policies in Guidewire Policy Centre & disbursed the same using Billing Centre to test ETL changes and issuing cheque payments in Oracle Payables. Created Visio diagrams and shared with senior management for proposing project estimates, sharing process flows and representing change request.

Oracle Cloud Functional Consultant

2018 - 2019
  • Configure Oracle ERP Cloud Applications modules Accounts Payable (Invoice to Pay), Accounts Receivable (Credit to Cash) and purchasing to meet client requirements and document application set-ups. Performed proof of concept in setting up offering such as purchasing, Payables, Sourcing, Procurement Contract, Supplier Portal, Self service procurement, Supplier qualification Management and Financials setups. Setup/Manage Purchasing and Receiving Business Unit. Setup of approval groups and assignment of approval groups and buyers. Configure Suppliers registration, Supplier sites, Address and site assignments. Setup Approval Assignment for Positions Implemented the position Hierarchies. Setup Document types for Purchase Orders. Setting up Payables option and financials options. Defining distribution sets, payment terms and Pay Groups. Defining Payment Formats and performing Bank Reconciliation and payment upload. Defining special calendar for recurring invoice, Withholding Tax. Setting up of Banks for Customers and Suppliers. Defining Expense report templates. Entering Standard Invoice, Debit Memo, Credit Memo, Interest Invoice, PO Default and Quick Match. Interact with the project team members responsible for developing reports, interfaces, data. Imported Inventory items, Suppliers and Customer using FBDI method.

Oracle Cloud Functional Consultant/Business Analyst

2016 - 2018
  • Develop and assist the project team in developing a clearly defined and agreed upon project functional and non-functional requirements and translate business requirements to technical specifications for development. Lead the business delivery of the Oracle Cloud implementation project by collaborating with the business stakeholders to understand their needs. Lead the activities required to ensure that business processes, business policies and guidelines and requirements are appropriately delivered. Understand differences in the functionality and the related processes between the current Oracle EBS installation and Oracle Cloud and ensure there is a plan to communicate the information to the business users. Ensure benefits are understood by all users. Provide expertise related to the design and use of reporting solutions to support core business processes. Ensure that the reports delivered are accurate and appropriate for the intended use. Perform application system analysis, prepare data/process flow diagrams and design screen / report layouts as part of the business systems solution / application design. Analyse business and user needs, gather requirements, and document those as business / functional requirements. Work with project managers and developers to define system scope and objectives based on business needs and industry standards. Devise or modify procedures to solve problems and recommend enhancements to business processes to support changing business requirements. Assist business users in developing conversion / implementation procedures and communication materials. Document problems and work to resolve them, reporting progress on problem resolution to management. Work with the QA and Support teams in the testing and implementation of developed applications/solutions.

Oracle Functional Consultant/Business Analyst

2009 - 2016
  • Ensure goods and services are purchased at cost, quality and delivery competitive levels as per Preferred Supplier Sourcing strategy. Produce and maintain sourcing department, expenditure, savings & KPI reports on a monthly basis. Work with Finance team and IT Technology owners to identify and initiate ways to reduce costs, improve terms, and develop better supplier relationships. Reconciliation processes, forecasting, financial planning and reporting. Setting-Up Purchasing Options and Setting Up Receiving Options. Customize PO Create Document and PO Approval Workflow, which will create PO automatically when requisition is approved and also it approves the PO automatically. Understand the factors affecting the customer’s business processes, including the sources of dissatisfaction with the business, the purchasing decision process (both formal and informal), the focus of decision-making and the political infrastructure. Set up of PO Modules so as to suit the business requirement of the company, entering of requisitions, Purchase Orders, Item defining, etc. The WokFlow automation of SASSA is developed for automation of departmental operations of the Circle Office. It simplifies and streamlines the Circle Office operations, which improve organizational efficiency, enhanced workflow process control and reporting. Personalization and Customizations of oracle forms and oracle self service page. Studying the business requirement and existing application for developing the interface between Oracle Application and existing system. Involved in defining customer bank accounts, receipt documents and receipt method and receipt sources and receivable activities. Implementation of core logic using BC(Business Component). Building an audit trail report for Supplier and Employee banking details changes. Involved in creating Customer Master and Transaction types, Sources. Involved in setting up System option, Payment Terms, Territory, Salesperson, and Collectors. Involved in Setting up Freight, Freight Carriers and other Details. Identify all defects during testing (Functional, System, Integration, Stress testing & UAT) and configure application build. Developed reports to analyze business data and achieve effective control. Drafting Documents required to be delivered (i.e.) BR - 100 Application Setup Documents MD - 50 - Functional Specification for Application Customization. MD- 70-Technical design document. MD- 120- Technical deployment document. UAT - Training Scripts TA - Training Documents. Has knowledge on Siebel Sales, Service and Marketing modules. Has worked on Siebel on Demand Integrations with Oracle ERP for the Siebel CRM to Order management. Has worked on Customer reconciliation between Siebel and Oracle ERP. Has worked on Siebel CRM analytics and used Oracle Siebel eRoadmap methodology implementation process. Support on the Oracle systems, projects in the application area and general enhancements to the applications. Budgeting and assisting users on month end process.

Oracle Apps Developer

2006 - 2009
  • Personalization and Customizations. Coding in SQL and PL/SQL. My Role also involved constant discussions with Functional Consultants and learn requirements then design and implementation. Unit Testing. Building the customer workflow. Developing Workflow for Notification. Developing a New form for Customise module. Personalization and Customizations of Oracle forms and OA pages. Build an oracle customize module name Copper Concentrated along with the customs form, reports , custom table and build a custom interface. Developed system tools and techniques that integrate various business segments streamlining enterprise wide processes maintaining data integrity and security enabling business to focus on market penetration Created SQL*Loader files for Inventory and Purchasing Modules to load data files. Also worked on Interfaces in Inventory, Purchase Modules. Exp- Uploading Bulk Items into Inventory Module, Updating bulk items. Developing Packages. Unit Testing. Develop and customize rdf reports10g, Discoverer Report, Business intelligence Report and XML Report as per client requirement. My Role also involved constant discussions with Functional Consultants and learn requirements then design and implementation.

Education

Bachelor of Engineering
2001-2005

Bachelor of Engineering - I.T. (2005) from Rajiv Gandhi Technical University, Bhopal, India

Certification

Oracle Certified Professional
2008-2010

SQL, PL/SQL, Forms

Oracle E-Business Suite R12 Supply Chain Certified Expert Consultant, Purchasing.
2011-2012

Supply Chain Certified Expert Consultant, Purchasing.

Oracle Procurement Cloud 2017 Certified Implementation Specialist
2018-2018

Oracle Procurement Cloud 2017 Certified Implementation Specialist

Oracle Payables Cloud 2017 Certified Implementation Specialist
2019-2019

Oracle Payables Cloud 2017 Certified Implementation Specialist

Ooops!

Maximum of Three products are allowed for comparision