Key Responsibilities

1. Master Task List Management

- Maintain a live Master Task Tracker (Excel/Google Sheets) handling 25–40 active tasks across 3–5 managers simultaneously.
- Log every new task assigned via calls, WhatsApp, or emails within 30 minutes with a clear Owner, Target Date, Status, and Next Follow-up Date.
- Submit a Daily Task Plan by 10:30 AM and a complete Evening MIS Report by 7:00 PM without fail.
- Never mark a task as "Closed" without attaching concrete proof of completion (email, document, photo, Tally entry, or LR copy).

2. Daily Follow-Up & Escalation

- Maintain a daily Follow-up Register and complete all scheduled follow-up calls/messages before 1:00 PM.
- Coordinate across Sales, Purchase, Production/Filling, QC/QA, Dispatch, Accounts, vendors, and transporters to track pending approvals, order-to-dispatch steps, and material deliveries.
- Push back politely but firmly on vague answers ("dekhte hain", "kal ho jayega") to secure specific date and time commitments, confirming every commitment in writing on WhatsApp/Email immediately.
- Apply a strict 3-step escalation ladder for missed commitments, presenting facts, ageing data, and dispatch/customer impact to senior management.

3. Data Analysis & MIS Reporting

- Track task ageing (0–2 days, 3–5 days, 5 days) and analyse Turnaround Time (TAT) compliance across departments.
- Identify recurring bottlenecks, repeat delays, and root causes,



presenting a 1-page Weekly Follow-up & Productivity Summary.
- Pull basic reference data from Tally Prime (outstanding, sales register, stock) to support follow-ups.

Requireents (Must-Haves)

- Experience: 3 to 6 years in Operations Coordination, Follow-up, MIS Reporting, Executive Assistance (EA to Manager/Director), or Sales/Dispatch Coordination (Manufacturing, Lubricants, Chemicals, Auto Parts, or FMCG preferred).
- Education: Graduate in any stream (B.Com / BBA / B.Sc). MBA in Operations/General is an advantage.
- Advanced Excel Skills: Hands-on proficiency in SUMIF, COUNTIF, VLOOKUP/XLOOKUP, Pivot Tables, Filters, and Conditional Formatting.
- Communication: Solid verbal and written command over English and Hindi (Punjabi is a plus) for drafting crisp emails, WhatsApp updates, and making firm follow-up calls.
- Software Exposure: Basic working knowledge of Tally Prime, Google Sheets, and AI drafting tools (ChatGPT/Gemini) is highly desirable.
- Mandatory Overtime Willingness: Must be willing to put in 30–50 hours of planned overtime per month (paid extra on a pro-rata basis) to close daily goals and urgent follow-ups. Candidates unwilling to commit to overtime will not be shortlisted.

Pay: ₹20,000.00 - ₹50,000.00 per month

Application Question(s)

- what is your current salary

Location:
- Patiala, Punjab 147001 (Preferred)

Work Location: In person

📌 Co-ordinator (Patiala)
🏢 Shield Lubricants u0026 Specialities
📍 Patiala