MIS Executive

MIS POINTS 

Key Responsibilities

Prepare Daily, Weekly, Monthly, and Quarterly MIS reports.

Collect, verify, and consolidate data from Sales, Purchase, Warehouse, Accounts, and HR departments.

Maintain and update management dashboards with accurate business information.

Generate reports related to sales performance, inventory, collections, dispatches, procurement, and employee productivity.

Ensure data accuracy by identifying and correcting discrepancies before report submission.

Develop automated Excel reports using advanced formulas, Pivot Tables, Power Query, and Macros (where applicable).

Prepare management presentations and analytical reports for leadership review.

Analyze business trends and provide insights to improve operational efficiency.

Coordinate with department heads to obtain timely and accurate data.

Maintain confidentiality of company data and reports.

Create and maintain standard MIS formats, templates, and documentation.

Monitor KPIs and prepare variance analysis reports.

Support management with ad-hoc reports and data analysis whenever required.

Maintain proper backup and documentation of all MIS reports.

Ensure timely submission of all scheduled reports.

Continuously improve reporting processes through automation and standardization.

Required Skills

Advanced Microsoft Excel

VLOOKUP/XLOOKUP

INDEX-MATCH

Pivot Tables

Power Query

Conditional Formatting

IF, SUMIFS, COUNTIFS

Charts & Dashboards