Yash Rane

Data Science postgraduate with strong expertise in SQL, Power BI, Advanced Excel, and AWS, and a solid foundation in data modeling and analytics. Experienced in building interactive dashboards, automating reports, and transforming raw data into actionable business insights. Proficient in data validation, ETL processes, KPI tracking, and performance optimization.

Hands-on experience as a Data Analyst Intern and MIS Executive, supporting cross-functional teams with accurate and timely reporting. Detail-oriented problem solver with strong analytical, visualization, and communication skills focused on driving data-driven decision-making.

Mis Executive - Avant Garde Industries Pvt ltd

(2026-02)

• Prepared daily, weekly, and monthly MIS reports by collecting and validating data from multiple departments.
• Created automated dashboards using Excel (Pivot Tables, XLOOKUP, SUMIFS) to track KPIs and performance metrics.
• Analyzed sales, operational, and financial data to identify trends and provide actionable insights.
• Maintained and updated company databases ensuring data accuracy, confidentiality, and audit readiness.
• Coordinated with cross-functional teams to ensure timely reporting and support management decision-making.

Data Analyst Intern - Pune Knowledge Cluster

(2023-06 - 2023-08)

• Developed interactive dashboards to visualize and interpret complex datasets, delivering business-relevant reporting outcomes.
• Automated data merging processes by developing specialized code to combine data with corresponding image names, enhancing efficiency and accuracy.
• Supported data quality checks and ensured seamless integration of datasets for reliable analysis.

Masters - Data Science - SYMBIOSIS SKILLS & PROFESSIONAL UNIVERSITY (2024-09)

Bachelors of Science - Information Technology - UNIVERSITY OF MUMBAI (2022-06)