Material And Production Planning Analyst

Ajmal Perfumes; Dubai; On-site; AED 120,000 - 240,000; Full time

Job summary

Ajmal Perfumes is seeking a skilled Material & Production Planner to manage demand planning, SAP maintenance, and data analysis. You will support 13 months of production planning, ensure material availability, and drive process improvements through data-driven insights.

The role requires strong Excel skills, SAP planning proficiency, and experience in manufacturing planning, with emphasis on inventory management and reporting to stakeholders.

Qualifications

• Advanced MS Excel with complex formulas, PivotTables and data modeling.
• Hands-on SAP planning experience focusing on MD04, COOISPI and related functions.
• Strong understanding of MRP, demand planning, production planning and inventory management.
• Experience with data visualization using dashboards and PowerPoint/Power BI.

Responsibilities

• Gather forecasts and convert to demand plans using statistical tools.
• Ensure RM/PM are available to support 13 months of planning via MRP.
• Update PIR, reservations, planned orders, and validate production orders.
• Communicate reports and analyses to stakeholders to optimize operations.
• Perform root cause analysis for forecast, production, or supply discrepancies.
• Assist with other tasks as assigned by supervisor.

Skills

Advanced MS Excel

SAP planning

MRP knowledge

Data visualization

Analytical skills

Communication skills

Manufacturing experience

Tools

MD04

COOISPI

Power BI

Excel

Job description

Role & responsibilities

1. Material & Production Planning.

2. Inventory Planning

3. Data Analysis and continuous process improvement.

4. SAP maintenance and data monitoring

5. Team management

FUNCTIONAL AREA

Material & Production Planning

• Gather the forecast/sales plan from all the customers and do the statistical analysis and convert into a demand plan by using all statistical and mathematical tools
• Systematically gather the forecast/sales plans from all customers, then perform thorough statistical analysis on this data using appropriate statistical and mathematical tools in order to convert in to robust demand plan.
• Ensure that all required RM/PM is ordered and available to support the next 13 months of the plan for filling and packing by timely and accurate run of MRP.
• Update PIR, order reservation, creation of planned orders and validate process orders according to the production requirements.
• Communicate with stakeholders sharing reports, updates and analysis to aid decision and optimize operational efficiency.
• Conduct root cause analysis for any discrepancies in forecasts/production/supply and actual sales
• Any other task/duties assigned by reporting supervisor/LOT.

SAP Planning Data Maintenance

• Ensure that all the LSF, planned independent requirements, dependent requirements, planned orders, process orders, order confirmation, and reservations are validated on a regular interval and accurate in the system.
• Ensure that material master data at plant levels is correct and updated.
• Ensure that BOM Bill of Materials) and production versions are created with accurate parameters.

Data Exploration and Analysis

• Use statistical tools and techniques to explore and analyse data, identify patterns, relationships, and trends which can influence policy and decision-making processes for the planning team as well as for reports for management.
• Ability to undertake complex analysis to create information and to interpret data and trends
• Numerate with statistical studies and a full understanding of how failure impacts the production, manufacture and customer order fulfilment

Preferred candidate profile

MANDATORY SKILLS & EXPERTISE IN

• Advanced MS Excel skills are mandatory, including IF, AND, OR, SUMIF, SUMIFS, Pivot Tables, and advanced mathematical and statistical functions.
• Strong hands-on experience in SAP, particularly planning-related T-codes, MD04, and COOISPI.
• Good understanding of Material Requirements Planning (MRP), demand planning, production planning, and inventory management.
• Experience in data visualization using charts, dashboards, PowerPoint, and Power BI.
• Strong analytical, numerical, problem-solving, and root cause analysis skills.
• Good written and verbal communication skills.
• Prior experience in a manufacturing environment, preferably in supply chain or planning operations
• Competency Weightage: 30% Planning operations, 50% Data Analytical and 20% Planning.