MIS Executive – Procurement & Purchase Operations

The MIS Executive (Procurement) is responsible for managing end-to-end purchase data pipelines, maintaining real-time Purchase Indent (PI) and Purchase Order (PO) trackers, delivering executive monthly analytics, and automating reporting workflows through advanced Excel modeling.

Key Responsibilities

• Purchase Indent (PI) & PO Lifecycle Tracking:
• Log, monitor, and update all internal Purchase Indents from initiation to approval.
• Track Purchase Order generation, vendor acknowledgment, delivery schedules, and fulfillment status.
• Monitor Turnaround Time (TAT) across indent-to-PO and PO-to-delivery stages.
• Maintain open PO aging reports and proactively flag overdue orders or supply bottlenecks.
• MIS Reporting & Cost Analytics:
• Generate Daily, Weekly, and Monthly MIS reports detailing total spend, category-wise procurement, and supplier fulfillment rates.
• Prepare Monthly Purchase Price Variance (PPV) reports comparing actual buying rates against historical averages or benchmark budgets.
• Track Quantity-wise and Price-wise savings across warehouses, business units, and vendors.
• Build and maintain interactive executive dashboards covering procurement KPIs (OTIF, lead times, order fill rate).
• Data Reconciliation & Master Data Management:
• Reconcile PO details with Goods Receipt Notes (GRN) and vendor invoices to detect price, tax, or quantity variances.
• Maintain and update Item Master Data, supplier rate cards, HSN/SAC codes, and vendor ledgers.
• Coordinate with warehouse teams and accounts payable to resolve invoice holds or delivery discrepancies.
• Process Automation:
• Design automated tracker templates to streamline data entry and reduce manual reconciliation errors.
• Use automated data ingestion pipelines (Power Query) to merge multi-location purchase registers.

Technical Skills & Excel Competencies

Domain

Key Tools & Functions Required

Advanced Formulas

XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, LET, dynamic array

formulas, nested logical functions (IF/AND/OR).

Data Cleaning & Modeling

Power Query (ETL, merging multi-file databases, automated

refreshes), Data Validation rules, text-to-columns.

Visualization & Dashboards

Advanced Pivot Tables & Slicers, interactive KPI

summary cards, dynamic charts, Conditional Formatting.

Automation

Basic to intermediate VBA / Macros for recurring report

generation.

ERP / Systems Knowledge

Familiarity with SAP MM, Oracle NetSuite, Tally Prime, or

proprietary ERP procurement modules.

Qualifications & Requirements

• Education: Bachelor’s degree in Commerce, Business Administration, Supply Chain, Statistics, or related fields.
• Experience: Proven experience in an MIS or procurement data operations role handling high-volume SKUs and multi-vendor trackers.
• Analytical Ability: High attention to detail with the ability to spot anomalies in rates, tax structures, and invoice calculations.
• Communication: Clear coordination skills to align with category managers, warehouse heads, and finance teams.