Vishal Raut

Results-driven Data Analyst and Power BI Developer with 1.5+ years of professional experience in MIS reporting, data analysis, and interactive dashboard development. Proficient in Power BI (DAX, Power Query), SQL (MySQL), Python (Pandas, NumPy, Seaborn, Matplotlib), and Advanced Excel. Proven track record of cleaning and transforming large datasets (10,000–50,000+ records) and delivering actionable business insights across pharma, supply chain, sales, healthcare, and telecom domains.

AWS Certified Cloud Practitioner. Seeking a Data Analyst or Power BI Developer role to drive data-driven decision-making.

MIS & Data Reporting Analyst at Mylan Laboratories (Viatris) (2024-07 – 2025-01)

Designed and automated weekly MIS reports for multiple operational departments using Advanced Excel. Managed, cleaned, and validated large operational datasets. Built data cleaning pipelines and delivered data-driven insights to senior management.

• Designed and automated weekly MIS reports for 5+ operational departments using Advanced Excel (Pivot Tables, Power Query), reducing manual reporting effort by ~35% and improving report turnaround time.
• Managed, cleaned, and validated large operational datasets containing 10,000+ records, maintaining 99%+ data accuracy for business-critical reporting cycles.
• Built data cleaning and transformation pipelines (deduplication, standardization, formatting) to produce analysis-ready datasets for ongoing MIS and operational reporting.
• Delivered data-driven insights on key operational KPIs to senior management, directly supporting decision-making in a regulated pharmaceutical environment.
• Collaborated with 5+ cross-functional department heads to gather reporting requirements and align dashboard outputs with business needs.

Junior Associate — Pagination & Operations at Affinity Global Advertising (2023-02 – 2024-06)

Performed structured data validation and quality checks on campaign datasets. Built and maintained Excel-based operational reports. Coordinated with internal teams to resolve data discrepancies and standardize reporting formats.

• Performed structured data validation and quality checks on campaign datasets, ensuring accuracy across multi-channel advertising operations.
• Built and maintained Excel-based operational reports used by cross-functional teams for weekly performance tracking and campaign analysis.
• Coordinated with 3+ internal teams to resolve data discrepancies and standardize reporting formats, reducing report turnaround time.
• Managed data entry workflows, ensuring consistency and completeness across structured operational databases.

B.E. in Computer Science Engineering – Savitribai Phule Pune University (SPPU) (2018 – 2022)