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, agile 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.

📌 MIS Executive – Procurement & Purchase Operations (Hyderabad)
🏢 VR Elite
📍 Hyderabad