Mayank Nagpal

MIS Executive | Data Analytics

New Delhi, India 1+ yrs exp 84 · Excellent

About

MIS Executive with 2 years of experience in MIS reporting, ERP data management, dashboard automation, and customer data handling across manufacturing and trading operations. Skilled in MS Excel (Pivot Tables, VLOOKUP, INDEX-MATCH, SUMIF, Power Query), Power BI dashboard design, and SQL and Python (Pandas, NumPy) for data cleaning and analysis. PG Diploma in Data Analytics with hands-on project experience in statistical analysis and predictive modeling. Consistently delivers accurate, on-time reporting that supports management decision-making; seeking a data analytics role with greater ownership of end-to-end reporting and insight generation.

Skills & Expertise (31)

Power BI Intermediate

7.5/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Dashboard Automation Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Python Intermediate

6.0/10

Years Exp

Statistical Analysis Intermediate

6.0/10

Years Exp

ERP Systems Cross-functional coordination Attention to Detail Time management Process Improvement stakeholder communication PowerPoint Excel Word MS Office Suite Data Reconciliation Data Validation Index-match MIS reports NumPy Pandas KPI Tracking Pivot Tables Report Automation VLOOKUP Power Query SUMIF If

Work Experience

MIS Executive

SSRPM Pvt. Ltd.

Nov 2025 - Present

Process end-to-end bond documentation for 100+ transactions monthly, maintaining 100% accuracy against company compliance standards. Maintain and update customer data records daily for 500+ active accounts, ensuring data accuracy, confidentiality, and audit-readiness. Prepare and deliver daily, weekly, and monthly MIS reports to management, improving visibility into operational performance and turnaround times. Conduct regular reconciliation of customer records against source systems, identifying and resolving discrepancies before they impact reporting. Coordinate with cross-functional teams to resolve data mismatches, reducing report correction cycles and improving data reliability.

Marketing Intern

MBA Hub

Present - Present

Documented and explained financial products and services to clients; maintained accounting and distribution records.

Data Executive

Panex Overseas

Feb 2024 - Jan 2025

Maintained and updated large-scale ERP datasets (2,000+ records) to ensure accuracy for downstream reporting and analysis. Built and automated MIS reports in Excel using Pivot Tables, VLOOKUP, IF, and SUMIF, cutting manual reporting time by an estimated 30%. Extracted and consolidated data from ERP systems to support 10+ recurring internal reports for management review. Ran systematic data quality checks to catch inconsistencies prior to report distribution, improving first-pass report accuracy. Cleaned and standardized raw datasets in Excel and Power Query for weekly and monthly reporting cycles. Partnered with multiple departments to keep data update schedules on track, supporting on-time monthly close. Maintained structured documentation of data processes while safeguarding sensitive and confidential information.