Sales Planning Coordinator ( From FMCG Industry ) - Porur

Execute flawless day-to-day order processing and sales reporting to keep our supply chain

moving and our leadership fully informed. You will own the routinebut business- critical—tasks that ensure every customer order is entered correctly, dispatched on time, and reflected in accurate, deadline-ready reports. Your discipline with ERP workflows, advanced Excel/Pivot skills, and basic Python automation will free the Sales Planning Manager to focus on strategic analysis while keeping growth engine running smoothly.

Responsibilities

Order Processing (SCM)

• Enter customer orders in ERP/OMS within 1 hour of receipt, validating pricing, SKU codes, and stock levels.
• Coordinate with Warehouse & Logistics teams to secure daily pick-lists and ensure OTIF (On- Time-In-Full) dispatch.
• Escalate stock-out risks immediately and log corrective actions.

Sales Data Maintenance

• Cleanse and reconcile data to eliminate duplicates, mismatches, and missing values.
• Maintain master data tables (SKUs, outlets, price lists) with strict version control.
• Update daily sell-in / sell-out feeds from distributors, key accounts, and e-commerce portals.

Reporting & Deadlines

• Produce daily flash, weekly trend, and month-end sales reports in Excel/Power Pivot with zero formula errors.
• Meet all reporting cut-offs agreed with the Sales Planning.

Distribution Record-Keeping

• Keep outlet & distributor master files up-to-date (new openings, closures, territory changes).
• Track numeric & weighted distribution metrics for quick reference by the field team.

Process Compliance & Improvement

• Follow standard operating procedures (SOPs) for order entry, data validation, and report circulation.
• Document any deviations and propose small-scale process tweaks that raise accuracy or speed.

Success Metrics (KPIs)

• Order Entry:100 % of orders entered within 1 hour
• OTIF Dispatch Data Accuracy: 99 %
• Report On-Time Delivery: 100 % vs. calendar
• Reporting Error Rate: 0.5 % per month
• Master Data Update Cycle: 100 % daily/weekly refresh completion

Key Skills & Competencies:

• Education: Bachelor’s degree in business, Supply Chain, Commerce, or related field.
• Experience: 2–4 years in order management, sales operations, or SCM support—preferably in
• FMCG or food.
• Technical:
• Advanced Excel (Advanced formulas, PivotTables, basic VBA/macros).
• Power Query/Power Pivot; familiarity with ERP/WMS.
• Intro-level Python (pandas) for simple automation a plus.
• Behavioral: Highly organized, deadline-driven, and fanatical about data accuracy; thrives on
• routine excellence.
• Communication: Clear written & verbal English; able to flag issues promptly and concisely.
• Excellent time-management, multitasking, and follow-through.
• High attention to detail and a proactive, service-oriented mindset.

Contact Person

Sofiya Sayyed

SG OASIS

Interested candidates can share their resumes on sofiyaoasis@gmail.com