Oracle Fusion SCM Senior Consultant
Dr.Abdulaziz Al Ajaji Dental Group sister concern of Dr.Sulaiman Al Habib Medical Group
Total years of experience :19 years, 5 Months
Working on the setups of Requisitioning Business Function, Procurement Business Function, Common Options for Payables and Procurement, and configuration of procurement agents.
Working on Requisition Approvals, Purchasing Document Approvals, and Supplier Approvals.
Working on the setups of Fusion self-service procurement, configuring Punch Outs, Catalogs, Categories, Content Zones and Approval process.
Managing Mapping set for Cost management for PR creation and PO creation.
Executing the setups of the Fusion supplier portal- defining the supplier registration process, Supplier creation, Supplier responsibilities and approval process.
Working on Fusion Enterprise Structure, Fusion Procurement, Self-service Procurement, Sourcing, PO Contract, Supplier Qualification, Supplier Portal, Fusion Inventory, Fusion Receipt Accounting and Costing.
Setup of Inventory, Purchasing and Order Management as per the client requirement and suggested business process changes. Support to INV, PO and OM activities.
Conducted and coordinate CRPs, UAT.
Interacted with users, fixed the bugs, developed test plans and provides daily production support.
Conduct systems tests to ensure that solutions delivered meet business requirements as defined and specified.
Collecting user requirements and business needs.
Functional support for the preparation of different Customized Reports as required by clients.
Coordinating with the Technical team in developing and modifying new and existing reports respectively.
Trained End-user to work on Oracle Supply Chain Management.
Interacted with users, fixed the bugs, developed test plans and provides daily production support.
Support to INV, PO and OM activities.
Support to the users on day-to-day functional issues of Oracle for Inventory/ Purchase Order/ Order Management.
Implementing internal requisition and internal sales order as a solution for intercompany transactions.
Development and customization of reports based on Customer requirements.
Form Personalization and Forms Customization.
Involved in development of reports based on business requirements and registered them in oracle applications.
Defined value sets, concurrent programs, profile option, request sets, registering reports and PL/SQL Procedures, and Packages.
Data Uploading through Interface Tables and APIs and Data Loader.
Interacted with users, fixed the bugs, developed test plans and provides daily production support.
Developed Purchasing, inventory and order management Report using BI Publisher.
Designing and reviewing the technical documents.
Creating of value sets various modules of the application.
Interacted with users, fixed the bugs, developed test plans and provides daily production support.
Trained End-user to work on Oracle Supply Chain Management.
Ensure SD tickets and resolved functional and Technical issues.
Key member in Development of various in- house software’s using Oracle 9i/ developer 6i.
Trained End-user to work on in-house development software’s.
Customized many Forms and Reports according to the business requirements.
Creating custom database objects like Tables, Views, Synonyms, Sequence.
Backend programming using oracle 9i/10g/11g, screen designing using forms 6i/10g and developing reports using reports 6i/10g.
Developed PL/SQL, packages and procedures for the backend processing of the proposed database design.
Created tables, synonyms, sequences, views, PL/SQL stored procedure and triggers.
Enforced database integrity using primary keys and foreign keys.
Developed master-detail forms for master tables and transaction tables.
Dynamic LOV, programmatically Record group handling.
Installation, support and customization to existing software R4 (Dental software), Sidexis (Dental X-Ray), Focus (Accounting, purchase, inventory and HR).
•Developing forms and Reports using Oracle developer 2000.
•Created tables, constraints, synonyms, sequences, views, PL/SQL triggers.
•Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
•Enforced database integrity using primary key and foreign key.
•Developed data entry screens and generate code.
•Developed master-detail forms for master tables and transaction tables.
•Developed server side PL/SQL (stored procedure, function & packages) for implementing complex business logic.
•Full life cycle development which includes feasibility, requirement definition, estimation, design, coding, testing, implementation and client training.
•Responsible for taking backup.
•Designing, analysis and development