Senior Planner (US MNC/ Excel proficiency)

Jda Wms

Negeri Sembilan

On-site

MYR 89,000 - 134,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

JDA WMS Pte Ltd is seeking a Senior Planner to own the Master Production Schedule (MPS) and raw material planning, ensuring customer orders ship on time. The role balances forecasts, demand and plant capacity, and provides Purchasing with timely material plans.

Strong Excel, Power Query, and macro skills are essential to automate planning reports. You will work cross-functionally with Sales, Production, Warehouse and Logistics to resolve capacity issues and improve KPIs such as on-time delivery

Qualifications

  • Requires a diploma or bachelor’s degree in a related field (Supply Chain/Logistics/Business).
  • Proficient in MS Excel (advanced functions, Power Query, macros) and MS Office.
  • Experience with ERP planning modules such as JDE and demand planning processes.

Responsibilities

  • Prepare and maintain the Master Production Schedule (MPS) aligned to forecasts and capacity.
  • Ensure MPS meets delivery dates and adjust to changes in demand/capacity.
  • Analyze raw material requirements and provide timely material plans to Purchasing.
  • Run planning in ERP systems (e.g., JDE) maintaining lead times, lot sizes, safety stock.
  • Build Excel-based planning tools to automate data pulls, reports and dashboards.
  • Track inventory, shortages, and apply FIFO/JIT/lean to keep stock lean.
  • Collaborate with Sales, Purchasing, Production, Warehouse and Logistics to resolve issues.
  • Report planning KPIs such as on-time delivery and inventory turns.
  • Mentor junior planners and continuously improve planning processes.

Skills

Demand planning
MPS planning
Mentoring junior planners
Lean & JIT principles

Education

Bachelor's or Diploma in Supply Chain / related field

Tools

Excel (advanced functions, Power Query, macros)
ERP planning modules (JDE)
MS Office

Job description

We are hiring a Senior Planner to own the Master Production Schedule (MPS) and raw material planning, so that customer orders ship on time. You will balance forecasts, customer demand and plant capacity, and give Purchasing timely material plans. Strong Excel skills are central to this role, including advanced functions, Power Query and macros, to automate planning reports and analysis.

Key responsibilities

  • Prepare and maintain the Master Production Schedule (MPS) in line with sales forecasts, customer demand and available capacity.
  • Ensure the MPS meets customer requirements and delivery dates, and adjust it when demand or capacity changes.
  • Review and analyze raw material requirements against forecasts and actual orders, and give Purchasing timely material plans.
  • Run planning in the ERP system (such as JDE), keeping planning data such as lead times, lot sizes and safety stock accurate.
  • Build and maintain Excel planning tools, using advanced functions, Power Query and macros to automate data pulls, reports and dashboards.
  • Track inventory levels, shortages and excess stock, and apply FIFO, JIT and lean principles to keep stock lean.
  • Work with Sales, Purchasing, Production, Warehouse and Logistics to resolve supply and capacity issues.
  • Report on planning KPIs such as on-time delivery, schedule adherence and inventory turns.
  • Mentor junior planners and improve planning processes.

Requirements

  • Diploma or bachelor's degree in Supply Chain Management, Logistics, Economics, Business Administration or a related field.
  • Proficient in MS Excel, including advanced functions, Power Query and macros.
  • Proficient in MS Office and the planning modules of ERP systems such as JDE.
  • Familiar with process, product and demand planning.
  • Familiar with FIFO, JIT and lean manufacturing principles.
  • Experience preparing and maintaining a Master Production Schedule that meets customer requirements and delivery dates.
  • Experience analyzing raw material requirements from forecasts and actual orders, and providing timely material plans to Purchasing.

JDA WMS Pte Ltd | EA Personnel: Pham Thi Tuyet Mai

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Planner: Master Production Scheduling & Excel
Senior Planner: Master Production Scheduling & Excel

Jda Wms • Negeri Sembilan

On-site
MYR 89,000 - 134,000
Production Planner / Senior Planner (EMS / Multiple Headcount)
Production Planner / Senior Planner (EMS / Multiple Headcount)

AGENSI PEKERJAAN TRUST RECRUIT SDN. BHD. • Penang

On-site
MYR 60,000 - 120,000
Planner (Global MNC)
Planner (Global MNC)

AGENSI PEKERJAAN TRUST RECRUIT SDN. BHD. • Bayan Lepas

On-site
MYR 60,000 - 90,000
6757 - Planner
6757 - Planner

Agensi Pekerjaan Minde Group Sdn Bhd • Penang

On-site
MYR 50,000 - 73,000
Planner
Planner

ASMPT MALAYSIA SDN. BHD. • Pasir Gudang

On-site
MYR 72,000 - 98,000
6592 - Supply chain officer - Planner
6592 - Supply chain officer - Planner

Agensi Pekerjaan Minde Group Sdn Bhd • Penang

On-site
MYR 60,000 - 90,000
Planner
Planner

NationGate Solution (M) Sdn. Bhd. • Seberang Perai

On-site
MYR 60,000 - 90,000
Annual Bonus & Salary Increment
Employee Share Grant (LTIP)
Medical & Accident Insurance Coverage
+4
Planning Manager
Planning Manager

PerkinElmer Manufacturing Sdn. Bhd. • Gelang Patah

On-site
MYR 120,000 - 180,000
6721 - Material Planner
6721 - Material Planner

Agensi Pekerjaan Minde Group Sdn Bhd • Penang

On-site
MYR 56,000 - 78,000
Planner
Planner

Microchip Operations (Malaysia) Sdn. Bhd • Bayan Lepas

On-site
MYR 60,000 - 90,000