SUPPLY PLANNER

Supply Planning

• Conduct forecasting based on historical consumption trends and upcoming production/project plans.
• Coordinate with Production/Operations to align inventory planning with upcoming schedules or seasonal demand.
• Calculate and maintain safety stock levels for critical items to prevent stockouts.
• Conduct lead time analysis with suppliers/purchasing and adjust reorder points accordingly.

Supplier & Purchasing Coordination

• Coordinate with Purchasing on supplier performance issues affecting delivery timelines (late deliveries, partial shipments).
• Support vendor evaluation by providing consumption and demand data for negotiations or contract renewals.
• Assist in identifying alternate sources/substitute items for critical or long-lead-time materials.

Cost & Process Improvement

• Identify cost-saving opportunities through inventory optimization (reducing excess stock, minimizing emergency purchases and obsolete inventory).
• Recommend process improvements to reduce manual Transactions creation and improve planning accuracy.
• Support annual/periodic physical inventory counts and reconcile discrepancies with system records.

Compliance & Documentation

• Ensure all PRs and master data changes comply with internal procurement policies and approval workflows.
• Maintain SOPs (Standard Operating Procedures) for inventory planning and PR processes, updating as procedures change.
• Support internal/external audits by providing inventory records, justifications, and documentation as requested.

KPI & Performance Tracking

• Track and report key planning KPIs (e.g., stockout rate, inventory turnover, forecast accuracy, PR-to-PO cycle time).
• Provide root-cause analysis for recurring stockouts or excess inventory situations.

Cross-Functional & System Support

• Act as the key user/point of contact for inventory planning modules in Oracle supporting system upgrades or testing.
• Train or guide end users on raising correct PR requests and understanding Min/Max logic.
• Support new item setup and classification when new products/materials are introduced.

Inventory Analysis & Reporting

·         Review Min/Max levels for fast moving inventory items monthly, based on actual consumption, and adjust as needed.

·         Perform ABCD analysis/classification monthly and update management, requesting action to clear slow-moving stock — particularly end-user consumption plans for "D Class" items.

·         Review the Turnover and Days-in-Stock report (based on on-hand quantity and monthly consumption) and report findings to Supply Chain Management for reference and action as needed.

·         Prepare periodical reports on non-moving or obsolete inventory, including an action plan for clearance.

Inventory Control

• Raise daily PRs for inventory items to maintain stock levels.
• Email Purchasing to arrange delivery for pending PRs/POs, avoiding emergency situations.
• Review Min/Max levels for Packing, Chemical, and Production Consumables to prevent shortages, and create PRs based on Min/Max and on-hand quantity.
• Correct master data (description, Min/Max, price) using supporting documentation such as quotations.
• Monitor item master records to prevent duplication and ensure data consistency in the Inventory Management module.

Monthly Activities

• Process stationery PRs per user requirements.
• Process refreshment PRs per management request.
• Process Dubal Billets nomination PRs per purchasing requirements.

Desired Candidate Profile

• Minimum of 5 Years in Inventory/ Supply Planner role
• Advanced Microsoft Excel
• PowerBI