MIS EXECUTIVE – JOB DESCRIPTIONCompany: VST INFRA & PROFILES PVT. LTD.

Position: MIS Executive

Department: MIS / Operations / Accounts Support

Location: Pune, Maharashtra

Employment Type: Full-Time

Job SummaryWe are looking for a detail-oriented and responsible MIS Executive to manage daily business data, prepare MIS reports, maintain Excel records, and provide accurate information to management for decision-making.

The candidate will work closely with the Sales, Purchase, Accounts, Dispatch, and Godown teams.

- Key Responsibilities1. Daily MIS & ReportingPrepare and maintain Daily MIS Reports.
- Prepare daily/weekly/monthly reports for management.
- Maintain sales, purchase, stock, dispatch, and outstanding data.
- Track daily business transactions and ensure timely data entry.
- Identify data discrepancies and report them to the concerned department.
- 2. Sales MISMaintain customer-wise and salesperson-wise sales reports.
- Prepare daily sales booking and dispatch reports.
- Track pending orders and deliveries.
- Prepare product-wise and customer-wise sales analysis.
- Monitor sales targets and achievements.
- 3. Stock & Godown MISMaintain daily stock reports for steel products.
- Track opening stock, purchases, sales, dispatches and closing stock.
- Reconcile physical stock with system/Excel records.
- Monitor product-wise stock such as TMT, GP Pipe, CRC Pipe, Sheet, Coil, Structure, HR, etc.
- Coordinate with the godown team regarding stock discrepancies.
- 4. Purchase & Dispatch ReportsMaintain purchase records and supplier-wise data.
- Prepare purchase and inward material reports.
- Maintain vehicle/loading/dispatch records.
- Track pending dispatches and deliveries.
- Coordinate with the dispatch and logistics teams for accurate reporting.
- 5. Accounts Support MISMaintain customer outstanding reports.




- Prepare customer-wise receivable/payable statements.
- Follow up internally for pending billing and payment information.
- Coordinate with the Accounts Department for data reconciliation.
- 6. Excel & Data ManagementMaintain organized Excel databases.
- Use VLOOKUP/XLOOKUP, Pivot Tables, SUMIF/SUMIFS, IF, COUNTIF/COUNTIFS, Filters, Sorting and basic Excel formulas.
- Prepare qualified dashboards and management reports.
- Maintain proper backup and filing of daily reports.
- Ensure data accuracy and confidentiality.
- Required SkillsStrong knowledge of MS Excel is mandatory.
- Good analytical and numerical skills.
- Good typing and data-entry skills.
- Attention to detail.
- Ability to identify mistakes in data.
- Good communication and coordination skills.
- Ability to work under deadlines.
- Knowledge of Tally/ERP/software will be an advantage.
- Experience in steel, construction, trading, manufacturing or logistics industry will be preferred.
- QualificationGraduate in B.Com / BBA / BCA / Any Graduate.
- Minimum 1–3 years of experience in MIS/Data Management preferred.
- Freshers with excellent Excel knowledge may also be considered.
- Key Performance Indicators (KPI)Accuracy of daily MIS reports.
- Timely submission of reports.
- Accuracy of stock and dispatch data.
- Proper maintenance of customer/supplier records.
- Reduction of data-entry and reporting errors.
- Timely identification of discrepancies.

Working CoordinationThe MIS Executive will coordinate with:

Sales Team → Purchase Team → Accounts Team → Godown Team → Dispatch/Transport Team → Management

Preferred CandidateWe are looking for someone who is:

Accurate | Responsible | Good with Excel | Analytical | Organized | Proactive

Salary: As per experience and skill level.

Immediate Joiners will be preferred.

📌 MIS Executive (Pimpri-Chinchwad)
🏢 VST Infra & Profiles Private
📍 Pimpri-Chinchwad