Data Analyst - MIS Reporting & Power BI

MOHIT TANEJA

Jaipur, Rajasthan +91-882******* ***************@*****.*** LinkedIn: mohit-taneja-64ab571bb

PROFESSIONAL SUMMARY

Data Analyst with 3+ years of experience in MIS reporting, data analysis, dashboard development, and business intelligence. Skilled in SQL, Power BI, Advanced Excel, Google Sheets, and data visualization. Experienced in transforming large datasets into actionable insights, automating reporting processes, improving data quality, and supporting data-driven decision-making.

CORE SKILLS

SQL, Power BI, Advanced Excel, Google Sheets, Data Analysis, Data Cleaning, Dashboard Development, Data Visualization, KPI Reporting, Power Query, Data Validation, ETL Concepts, Excel Automation, Google Apps Script, Business Intelligence, Reporting Automation, Stakeholder Management

PROFESSIONAL EXPERIENCE

MIS Assistant Allen Digital (ALLEN Online), Jaipur Jun 2025 – Present

Manage end-to-end MIS reporting and data management for academic and operational teams.

Develop Power BI dashboards to monitor KPIs, enrollment trends, and operational performance.

Automate recurring reports using Excel and Google Sheets, improving reporting efficiency.

Ensure data accuracy, consistency, and validation across daily, weekly, and monthly reports.

Collaborate with stakeholders to gather reporting requirements and deliver actionable insights.

MIS Analyst Aakash Educational Services Pvt. Ltd., Jaipur Jul 2024 – Jun 2025

Created interactive Power BI and Excel dashboards for senior management reporting.

Automated MIS reporting processes, reducing report turnaround time by approximately 20%.

Analyzed large datasets to identify trends and support strategic business decisions.

Maintained high standards of data accuracy, completeness, and reporting consistency.

MIS Executive ICICI Prudential Life Insurance, Jaipur Sep 2023 – Jun 2024

Prepared daily, weekly, and monthly performance reports using Excel and SQL.

Built KPI dashboards for business and sales performance monitoring.

Utilized advanced Excel functions, Pivot Tables, and automation techniques for data processing.

Improved reporting workflows through standardized templates and process optimization.

PROJECTS

Automated Dashboard System – Reduced manual reporting effort by 50% through automated Excel dashboards.

SQL Data Cleansing Project – Cleaned and transformed large datasets using joins, CTEs, views, and aggregations.

Google Sheets Automation – Automated data synchronization and reporting workflows using Apps Script.

EDUCATION

MBA (Analytics with Data Science) – Manipal University Jaipur 2024 – 2026

Bachelor of Commerce – University of Rajasthan 2021 – 2023

CERTIFICATIONS

Certified Data Analyst – Grras Solutions

Advanced Excel, SQL, Power BI, Python (Pandas, NumPy), Data Visualization

LANGUAGES

Hindi (Native), English (Intermediate)

Contact this candidate