Dipak Naik

MIS Executive with 4+ years of hands-on experience preparing daily, weekly, and monthly MIS reports, maintaining accurate business data, and building dashboards using Advanced MS Excel (VLOOKUP, HLOOKUP, Pivot Tables, Charts, IF Functions). Strong track record of data collection, validation, and reporting accuracy – reduced report preparation time by 35% and managed 15,000+ records with zero-error reconciliation at Reliance Industries Limited. Skilled in coordinating with cross-functional teams to resolve data discrepancies and ensure timely, accurate reporting.

Comfortable with Google Sheets, MS Word, and PowerPoint for day-to-day reporting and documentation. Additionally experienced in SQL Server and Power BI for advanced dashboard development – an added strength beyond core MIS reporting requirements.

MIS Executive - Reliance Industries Limited - Ahmednagar, India

(2022-01 - 2025-08)

• Prepared and maintained daily, weekly, and monthly MIS Reports, Operational Reports, and Management Reports using Advanced Excel to support business operations and management review.
• Collected, verified, and maintained 15,000+ records of accurate business/inventory data, performing Data Validation, Data Integrity checks, Data Reconciliation, and duplicate identification.
• Created reports, charts, and performance summaries using Pivot Tables, VLOOKUP, and Power Query to analyze data and generate meaningful insights for management.
• Identified discrepancies in operational data and resolved them promptly by coordinating with cross-functional teams, ensuring timely and accurate MIS reporting.
• Ensured timely submission of daily/weekly/monthly reports and documentation, maintaining 35% faster report turnaround.
• Performed data cleaning and validation to maintain consistency and accuracy across all operational reporting.

MIS Executive - Pratap Technocrats Pvt. Ltd. - Pune, India

(2026-01 - 2026-04)

• Prepared and maintained daily, weekly, and monthly MIS Reports, Operational Reports, and Management Reports using Advanced Excel and ERP data for Preventive Maintenance and Service Operations.
• Maintained and updated operational master data for preventive maintenance, service activities, technicians, customers, and parts consumption to ensure accurate MIS Reporting.
• Performed Data Validation, Data Cleansing, Data Reconciliation, and Data Quality checks to ensure accurate, consistent, and error-free operational reports.
• Managed customer and vendor complaint tracking and follow-up using CRM portal, ensuring timely resolution and accurate status reporting.
• Prepared KPI Reports and Management Reports to track service activities, pending work, technician performance, and operational trends.
• Analyzed operational data using Advanced Excel, Pivot Tables, VLOOKUP/HLOOKUP, and reporting automation techniques to support management decision-making.

Bachelor of Science - B.Sc. - Dr. Babasaheb Ambedkar Marathwada University (2021-06 - 2024-07)

MIS Analytics (Modular) - ICA Edu Skills (NSDC Partner) (2024-11 - 2025-05)