Key Responsibilities
MIS & Management Reporting
Prepare daily, weekly, monthly and quarterly MIS reports.
Develop operational, sales, financial, HR and
performance reports.
Consolidate data from Sales, Marketing and other departments.
Prepare dashboards, KPI reports and variance analysis.
Ensure accurate and timely reporting.
Data Management & Analysis
Collect, consolidate, validate and reconcile data
from multiple sources.
Identify data discrepancies and coordinate corrections.
Analyse data to identify trends, gaps and business insights.
Maintain structured databases and reporting templates.
Ensure data accuracy, integrity and confidentiality.
Excel & Dashboard Management
Create advanced Excel reports using Pivot
Tables/Charts, XLOOKUP/VLOOKUP, INDEX-MATCH,
SUMIFS/COUNTIFS and IF/IFS.
Develop charts, dashboards, conditional formatting
and data validation.
Use
Power Query for data extraction and consolidation.
Develop automated reporting templates to reduce
manual effort.
Knowledge of Power BI is an advantage.




KPI & Performance Tracking
Maintain KPI and target trackers.
Prepare Actual vs. Target, MoM and YoY analysis.
Identify performance gaps and highlight key deviations.
Provide data-backed insights for corrective action.
Process Improvement & Automation
Identify manual/repetitive reporting tasks for automation.
Standardize reporting formats and improve reporting processes.
Reduce turnaround time and reporting errors.
Maintain reporting documentation and version control.
Coordination & Stakeholder Management
Coordinate with Sales, Operations, Finance, HR and
Business Development teams.
Follow up for pending or incorrect data.
Understand business requirements and create
meaningful reports.
Handle ad-hoc reporting and management requirements.

Requirements
Required Skills
Advanced MS Excel – Mandatory. Solid knowledge of
Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH,
SUMIFS/COUNTIFS, IF/IF

📌 Mis Executive Noida
🏢 WebBee esolutions
📍 Noida