Meera Solanke

Meera Solanke

Data Analyst
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

Trainity
|

Data Analytics Intern

Remote, Maharashtra, India

Summary

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

Highlights

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.

Projects

HR Analytics Dashboard

Summary

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

Summary

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

Summary

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

Operation Analytics

Summary

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

Instagram User Analytics

Summary

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

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.

Education

MGM University
Sambhajinagar, Maharashtra, India

B.Sc.

Computer Science

Grade: 8.0+

State Board, India
Maharashtra, Maharashtra, India

HSC

Science

Grade: 77%

State Board, India
Maharashtra, Maharashtra, India

SSC

General Studies

Grade: 96.4%

Certificates

Data Analytics Internship

Issued By

Coursera

Python for Data Science

Issued By

Coursera

SQL for Data Analysis

Issued By

Coursera

Awards

Silver Medal, Gold Medal - IMO, IEO, NSO

Awarded By

IMO, IEO, NSO (International Olympiads)

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

Merit Holder - Homi Bhabha Young Scientist Exam

Awarded By

Homi Bhabha Young Scientist Exam

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