Sales Planning Executive

*** Sales Forecast:
- Baseline forecasting:
+ Typically cleanse historical data
+ Analyze historical sale trend & provide useful reference to cross-functional teams
+ Prepare statistical forecast; consolidate salesmen forecast
+ Monitor forecast tool & reconcile significant variances and refine the model for better result
- Collaborative forecasting:
+ Hold first-level discussion with sales & PM on the salesmen forecast/ statistical baseline forecast/ historical sale trend to understand the nature and drivers that impact forecast e.g. seasonal demand, promotion, product launches, price change, phase-out/ super session, marketing activities etc.; reconcile variance and generate collaborative demand forecast
+ Maintain second-level review with the functional management: DP/ SC/ Sale/Fin to get alignment of collaborative forecast prior to approval by BOM
- Follow up status of project order/ sale pipeline/ sale performance to ensure forecast number are chanllenged and in-line with business plan
- Handle/ report approval sale forecast to stakeholder or related person for next action
- Keep tracking forecast processing over time
- Identify potential demand/ supply failure & pro-actively work with cross-function teams to mitigate associated risks; keep following resolution plan
- Measure & analyze forecast performance across different metrics; Communicate with cross-function for resolution or improvement plan

*** Sales Order Management:
- Periodic review and cleanse sale order data in SAP
- Follow up with SC/ CS/ SA to get update the status of sale order & ensure goods timely being fulfilled/ released & sold out
- Generate PR to Purchasing Team (K & L items; potential project order)

*** Others:
- Cooperation with cross-function to: run SOI/ E&O clearance & promotion sale; optimize number of SKUs; provide proposal in develop stock strategy (e.g MTO/ MTS, buffer stock qty, etc.)
- Monitor ad-hoc order that lead high expense & report
- Periodic KPI review to prepare individual development plans

- Bachelor Degree, major in business administration
- 1+ year experience in Sales Planning/ Cost Analysis
- Advanced Excel data manipulation and analysis skills 
- Ability to communicate clearly and effectively at all levels 
- Ability to work under pressure and to prioritize workload to meet deadlines