Job Responsibilities:

• Responsible for the planning, execution and follow-up of all Replenishment stock orders & direct shipment Applied orders to Egypt.
• Responsible for co-ordination of delivery from Origin to Egypt Port - Customs clearance & delivery to warehouse in Egypt.
• Responsible for the management & execution and all customer orders (split by salesperson to each Supply chain coordinator).

-Planning

• Working with Sales planning on monthly Forecast Process, to produce Ukeharai demand plan for DAME to use to secure supply for DAEG
• Mange RDD of replenishment order in SAP in line with Ukeharai each month to ensure matching with forecast DAME will submit to factory (after DAEG establish own import license à will place PO in SAP directly under 5970 plants in replacement of CRM quotes under plant 5950)
• Monthly reporting on inventory & purchases for DAEG management
• Support to DAME during budget cycles on volumes and inventory levels

-Replenishment Inventory orders in SAP (DAME & DAEG)

• Convert Replenishment Quotes from CRM to SAP under DAME 5950 plant
• Issue SAP Pro-forma invoice to import company to enable Issuance of pricing offer
• Generate DAEG inbound PO in SAP and send final PO to import company
• Save import company PO in SAP against HQ Sales order
• Mange RDD of replenishment order in SAP in line with Ukeharai each month to ensure matching with forecast DAME will submit to factory
• Create delivery of replenishment orders in line with Ukeharai & arrange delivery co-ordination with factory, Inspection agents and DAME monthly nominated Freight forwarder.
• Issue invoice after collection & Co-ordinate with factory to issue EUR1
• Co-ordinate with Freight forwarder to issue draft BL and confirm documents.
• Co-ordinate with DAME for legalization of invoices, creation of COO and submission of all docs to GIZA bank
• This will be completely revised after DAEG establish own import license

-Customs Clearance

• Work with nominated customs broker to ensure smooth clearance of all shipments arriving in Egypt to avoid detention, demurrage or port storage costs.
• Become a specialist on customs related topics for AC in Egypt & support SBU on best way to import products to ensure compliance at all times.
• Regularly prepare /maintain reports on HS codes & customs requirements in Egypt to be shared with Management.

-Warehouse inbound

• Generate & distribute inbound to DAEG warehouse in SAP against correct PO, ensuring correct estimated delivery date is maintained & updated as ETA changes
• Ensure inbound numbers are generated for each container (inbound cannot be created for all containers)
• Co-ordinate with the warehouse to ensure they are aware of inbounds, and unloading is correctly planned.
• Approve / validate any overtime requests from the warehouse related to inbound shipments
• Monitor and report Monthly KPI for inbound shipments

-Reporting

• Co-ordinate with Daily update of central tracker on open order / in-transit orders to ensure full visibility
• Managing Supply/Purchase/Inventory reports towards DAEG management & DAME HQ
• Monitoring and reporting stock levels to sales and logistics to ensure availability is known by all key departments.
• Establish SLA/ KPIs with Customs Broker / inbound transport company to monitor and manage performance, report on a monthly basis as part of Supply chain / logistics KPI reporting
• Monitor and report on warehouse inbound performance in line with agreed SLA

-Inventory control & Stock count

• Daily follow up of Stock comparison list (SCL) in SAP, fixing any issues with warehouse with the support of DAME
• Validate the monthly stock count completed and submitted by warehouse, any discrepancies investigated, and stock corrections requested to DAME if required.
• Responsible for coordinating & preparing the yearly wall to wall stock count with warehouse & external auditors.
• Closely follow-up stock in 009 / 003 and maintain reports monthly on all stock in these locations.
• Manage repair and scrap of damaged warehouse units, coordinating parts procurement for repairs with SPP team in DAME and repairs with DAEG service team.

-Direct Deliveries

• Convert direct orders from CRM to SAP under DAME 5970 plant.
• Co-ordinate with DAME to arrange PO submission to factory
• Mange RDD of order in SAP with correct ETA
• Co-ordinate with DAME team to arrange delivery with factory.
• Co-ordinate with factory to issue EUR1
• Co-ordinate with Freight forwarder to issue draft BL and confirm documents.
• Co-ordinate with DAME for legalization of invoices, creation of COO and submission of all docs to GIZA bank
• Generate & distribute inbound in SAP and issue the final invoice to the customer in line with incoterms.

-Spares:

• Support Spare parts team with order creation, distribution & customer collection
• Role to be discussed internally with SP team to understand break up between Supply chain and SP team

-Monthly invoices

• Review and approve invoices importer and customs broker within three working days of submission.
• Submit to finance for payment and provide any supporting information as required
• Monthly cross-check with the finance team and vendor to ensure all invoices are accounted for in the correct month.

Job Requirements

Experience & Knowledge:

• Minimum 5 to 7 years of experience in Supply Planning
• Multinational company experience
• HVAC industry is an advantage
• Logistics & Planning knowledge
• SAP experience is an advantage (or other ERP system)

Education:

• Bachelor's degree graduate
• Certificate in logistics and supply is an advantage

Skills:

• Good Knowledge of Excel
• Excellent written and spoken English
• Strong communication and coordination skills

Personality Attributes:

• Analytical skills
• Quick Learner
• Attention to details
• Can handle deadline and pressure (Sense of urgency)
• Organized