Meera Solanke

Data Analyst

LinkedIn | GitHub | Email | Phone

[email protected]

+918237326737

Sambhajinagar, IN

About

Certified Data Analyst with hands-on expertise in SQL, Python, Power BI, and Excel, adept at transforming complex data into actionable business insights. Proven ability to optimize database performance by 25% and automate reporting processes, reducing manual effort by 50%. Passionate about developing interactive dashboards and comprehensive reports to drive strategic decision-making and enhance operational efficiency.

Work Experience

Data Analytics Intern

Trainity

May 2023 - Aug 2023

Remote, Maharashtra, IN

Led data analysis initiatives, developing databases, automating reports, and creating dashboards to enhance data-driven decision-making and operational efficiency.

  • Developed and optimized MySQL databases, improving query performance by 25% to enhance data retrieval and processing efficiency.
  • Automated critical reporting processes using Python, reducing manual effort by 50% and ensuring timely delivery of insights.
  • Built interactive Power BI dashboards to visualize complex trends, enabling stakeholders to make data-driven decisions.
  • Cleaned and validated large-scale datasets using pandas and SQL, ensuring data integrity and reliability for analysis.

Education

Computer Science

MGM University

8.0+

Jan 2022 - Jan 2025

Sambhajinagar, Maharashtra, IN

Science

State Board, India

77%

Jan 2020 - Jan 2022

Maharashtra, Maharashtra, IN

General Studies

State Board, India

96.4%

Jan 2019 - Jan 2020

Maharashtra, Maharashtra, IN

Certificates

Data Analytics Internship

Coursera

Jan 2024

Python for Data Science

Coursera

Dec 2023

SQL for Data Analysis

Coursera

Nov 2023

Projects

HR Analytics Dashboard

Oct 2023 - Dec 2023

Developed a comprehensive HR analytics dashboard using Power BI to analyze employee data, attrition rates, and average tenure for strategic HR insights.

Vrinda Store Sales Analysis

Aug 2023 - Oct 2023

Performed extensive data cleaning, transformation, and trend analysis on retail sales data using Excel, culminating in dashboards for revenue growth and inventory insights.

Student Result Analysis

Jun 2023 - Aug 2023

Processed and analyzed student academic performance data using Python, generating visualizations and automated summaries to support educational decision-making.

Operation Analytics

Mar 2023 - May 2023

Conducted operational metric analysis using SQL to identify and investigate anomalies, specifically focusing on job failure rates and response times.

Instagram User Analytics

Jan 2023 - Mar 2023

Developed a robust MySQL database and performed in-depth SQL analysis to understand user engagement and post popularity trends for an Instagram-like application.

Awards

Silver Medal, Gold Medal - IMO, IEO, NSO

IMO, IEO, NSO (International Olympiads)

Jan 2020

Recognized for outstanding performance in national and international academic Olympiads in Mathematics, English, and Science.

Merit Holder - Homi Bhabha Young Scientist Exam

Homi Bhabha Young Scientist Exam

Jan 2020

Achieved merit status in the prestigious Homi Bhabha Young Scientist Examination, demonstrating strong scientific aptitude.

Skills

Programming & Data Analysis

  • Python
  • SQL
  • Pandas
  • NumPy

Data Visualization

  • Power BI
  • Excel Dashboards
  • Pivot Tables
  • DAX
  • Slicers
  • Measures
  • Calculations
  • Charts

Tools

  • MS Excel
  • PowerPoint
  • Google Sheets
  • Zoom
  • Microsoft Teams

Soft Skills

  • Written Communication
  • Verbal Communication
  • Problem-solving
  • Team Collaboration