HIRING – MIS EXECUTIVEProcurement & Purchase Operations

Department: Supply Chain / Procurement
Location: Hyderabad – On-site
Experience: 2–5 Years
Industry Preference: Food & Beverage Industry
Salary: As per industry standards
Joining: Immediate Joiner / Candidates with short notice period preferred

ROLE OVERVIEW

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

1. 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.

2. 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 such as OTIF, lead times, and order fill rate.

3. 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.

4. Process Automation

- Design automated tracker templates to streamline data entry and reduce manual reconciliation errors.
- Use automated data ingestion pipelines through Power Query to merge multi-location purchase registers.

TECHNICAL SKILLS & EXCEL COMPETENCIES

Advanced Excel 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
- 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.

Industry:
Candidates with experience in the Food & Beverage industry are preferred.

Analytical Ability:
High attention to detail with the ability to spot anomalies in rates, tax structures, and invoice calculations.

Communication:
Explicit coordination skills to align with category managers, warehouse heads, and finance teams.

HOW TO APPLY

Interested candidates can share their updated resume at [email protected]

Pay: ₹25,000.00 - ₹30,000.00 per month

Work Location: In person

📌 MIS Executive Procurement & Purchase Operations (Telangana)
🏢 Vibrant Recruitment Consultancy Services
📍 Telangana