Mahadav S.

Experience

1. Data Analyst Mis Analyst

   Prayas

   Jul 2020 — Present · Delhi, IN

   Advanced Excel Data Management – Maintain, clean, and organize large datasets using functions like VLOOKUP, INDEX-MATCH, and Pivot Tables for efficient data processing.• Report Automation & Dashboard Creation – Develop dynamic dashboards and automated reports using Power Query, Power Pivot, and Macros (VBA) to streamline reporting processes.• Data Validation & Accuracy – Implement data validation rules, conditional formatting, and error-checking functions to ensure accuracy and consistency in reports.• Excel-based Process Automation – Use VBA (Visual Basic for Applications) to create custom macros for automating repetitive tasks like data entry, formatting, and calculations.• Financial & Business Analysis – Perform financial modeling, trend analysis, and forecasting using What-If Analysis, Goal Seek, and Solver for data-driven decision-making.• Collaboration & Data Sharing – Manage shared workbooks, protect sensitive data with password encryption, and use Excel integration with SharePoint or Google Sheets for real-time collaboration.• Data Extraction & Processing – Extract and consolidate data from multiple Excel files and external sources using Power Query, Text-to-Columns, Flash Fill, and Import/Export features.

Education

• Uttarakhand Technical University

  Bachelor's degree, Mechanical Engineering