Job Requirement: Customer Service Specialist Planning Support (SAP & Excel Automation Specialist)
Position Summary
We are seeking a detailoriented and analytical candidate with strong expertise in
SAP and
Excel automation to support planning, scheduling, and operational efficiency. The ideal candidate will be responsible for managing material requirements, optimizing planning processes, and building automated solutions to enhance accuracy and productivity.
Key Responsibilities
- Manage daytoday planning activities, including material requirement planning (MRP), purchase requisition tracking, and order scheduling using SAP.
- Monitor stock levels, track shortages, and ensure timely availability of materials for production.
- Develop and maintain Excel-based automation tools, dashboards, and templates to streamline planning workflows.
- Apply advanced Excel functions (Power Query, Power Pivot, VBA/macros, formulas, pivot tables) to automate repetitive tasks and improve reporting accuracy.
- Extract, analyze, and validate SAP data to support decision-making and resolve discrepancies.
- Coordinate with crossfunctional teams (procurement, production, logistics, quality) to ensure seamless planning execution.
- Perform rootcause analysis for delays, variances, or supply constraints and propose corrective actions.
- Prepare periodic reportsinventory status, aging, forecast accuracy, plan adherencewith automated outputs.
- Support continuous improvement initiatives and digital transformation in planning processes.
Technical Skills
Required Skills & Qualifications
- SAP proficiency in modules such as MM, PP, APO/IBP, or relevant planning modules.
- Strong command of Excel automation, including:
- VBA/macros
- Power Query
- Power Pivot
- Advanced formulas & dynamic tables
- Dashboard creation
- Ability to extract/transform SAP datasets and integrate them with Excel tools.
- Experience with data visualization or reporting tools (Power BI is a plus).
Professional Skills
- Strong analytical and problemsolving abilities.
- Excellent attention to detail with strong numerical aptitude.
- Good communication and stakeholdermanagement skills.
- Ability to work independently and deliver under tight timelines.
- Processoriented mindset with continuous improvement focus.
Educational & Experience Requirements
- Bachelor's degree in Engineering, Supply Chain, Operations, Commerce, or related field.
- 25 years of experience in planning, supply chain, or related operational roles.
- Hands-on experience working with SAP and Excel automation in a professional environment.
5 Yrs
