Piyush Mamodia

Data Analyst / MIS Executive

Delhi, India 1+ yrs exp 82 · Excellent

About

Data Analyst / MIS Executive with 1 year of experience in insurance operations, working daily with Excel-based reporting, data cleaning, validation and KPI tracking. Advanced Excel user (PivotTables, XLOOKUP, SUMIFS) with skills in SQL and Power BI. Strong at turning raw operational data into accurate reports, trends and actionable insights, and at communicating findings clearly to business and operations teams. Open to remote roles.

Skills & Expertise (39)

Conditional Formatting Advanced

6.5/10

Years Exp

Filtering Advanced

6.5/10

Years Exp

PivotTables Advanced

6.5/10

Years Exp

XLOOKUP Advanced

6.5/10

Years Exp

VLOOKUP Advanced

6.5/10

Years Exp

If Advanced

6.5/10

Years Exp

SUMIF Advanced

6.5/10

Years Exp

SUMIFS Advanced

6.5/10

Years Exp

COUNTIF Advanced

6.5/10

Years Exp

Countifs Advanced

6.5/10

Years Exp

Sorting Advanced

6.5/10

Years Exp

Data Cleaning Intermediate

5.3/10

Years Exp

Charts Intermediate

5.3/10

Years Exp

Data Visualization Intermediate

5.3/10

Years Exp

Report Building Intermediate

5.3/10

Years Exp

Slicers Intermediate

5.3/10

Years Exp

Filters Intermediate

5.3/10

Years Exp

WHERE Intermediate

5.3/10

Years Exp

validation Intermediate

5.3/10

Years Exp

Transformation Intermediate

5.3/10

Years Exp

Anomaly checks Intermediate

5.3/10

Years Exp

stakeholder communication Intermediate

5.3/10

Years Exp

Documentation Intermediate

5.3/10

Years Exp

Attention to Detail Intermediate

5.3/10

Years Exp

Meeting Deadlines Intermediate

5.3/10

Years Exp

Dashboards Intermediate

5.3/10

Years Exp

Power BI Intermediate

5.3/10

Years Exp

Joins Intermediate

5.3/10

Years Exp

Aggregate Functions Intermediate

5.3/10

Years Exp

GROUP BY Intermediate

5.3/10

Years Exp

ORDER BY Intermediate

5.3/10

Years Exp

Exploratory data analysis Intermediate

5.3/10

Years Exp

Select Intermediate

5.3/10

Years Exp

SQL Intermediate

5.3/10

Years Exp

Data Reconciliation Intermediate

5.3/10

Years Exp

performance reporting Intermediate

5.3/10

Years Exp

MIS reports Intermediate

5.3/10

Years Exp

KPI Tracking Intermediate

5.3/10

Years Exp

Trend Analysis Intermediate

5.3/10

Years Exp

Work Experience

MIS Executive (MIS & Operations)

5 Elements Insurance Brokers Pvt. Ltd.

Aug 2025 - Present

Prepare and maintain daily and weekly Excel reports on policy-related activity, and track business KPIs to support timely decision-making. Analyze structured datasets using PivotTables, charts and formulas (XLOOKUP, SUMIFS, COUNTIFS) to compare categories, identify trends and highlight patterns. Collect, clean and validate data from multiple records; identify incomplete entries, duplicates and inconsistent formats before data goes into reports. Cross-check and reconcile records to ensure data accuracy and investigate inconsistencies. Create charts and dashboard-style summaries that present findings in a clear, structured format for stakeholders. Maintain policy and employee records and document reporting processes so information stays organized and accessible for daily operations. Coordinate with operations teams to deliver accurate reports within deadlines.