SUPPLY PLANNER

GULF EXTRUSIONS LLC; Dubai; On-site; AED 180,000 - 260,000; Full time

Job summary

GULF EXTRUSIONS LLC in Dubai seeks a Supply Planning specialist to forecast demand from historical trends and upcoming production plans, and to align inventory with schedules.

You will maintain safety stock levels, conduct lead time analysis with suppliers, and adjust reorder points to prevent stockouts.

Proficiency in Advanced Excel and PowerBI is required to analyze data, track KPIs, and support continuous improvement across procurement and inventory control.

Qualifications

• Minimum of 5 years in Inventory/Supply Planner roles.
• Advanced Microsoft Excel skills required.
• Proficiency in PowerBI for data analysis.

Responsibilities

• Forecast demand based on historical trends and upcoming production plans.
• Coordinate with Production/Operations to align inventory with schedules.
• Maintain safety stock levels to prevent stockouts.
• Lead time analysis with suppliers and adjust reorder points.
• Coordinate with Purchasing on supplier performance and deliveries.
• Identify cost-saving opportunities through inventory optimization.
• Prepare periodic inventory/turnover and accuracy reports.
• Maintain SOPs for inventory planning and PR processes.
• Act as key user for Oracle inventory planning modules and train end users.
• Review Min/Max levels and perform ABCD analysis monthly.

Skills

Advanced Microsoft Excel

PowerBI

Job description

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