MIS Executive

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