Back to Developers
Yash Solanki

Yash Solanki

Data Analyst Intern

Mumbai, India $30/hr Remote Full-time 0+ yrs exp 91 · Outstanding

About

Performance-driven IT Graduate and Data Analyst Intern combining a strong academic foundation (8.92 CGPA) in Machine Learning and Statistics with hands-on experience delivering enterprise-level business intelligence. Expert in Python, SQL, and advanced BI tools, with a proven track record of engineering real-time data pipelines, automating reporting workflows, and deploying production-ready Streamlit, Looker Studio, and Tableau applications. Demonstrated success translating massive datasets into actionable strategic growth, highlighted by building a fleet-monitoring dashboard and analyzing over 1.85B+ in executive sales revenue. Adept at leveraging predictive modeling, K-Means clustering, and EDA to optimize customer lifetime value, uncover high-growth market segments, and accelerate data-driven executive decision-making.

Skills & Expertise (25)

Gujarati Expert
9.0/10
5
Years Exp
Hindi Expert
9.0/10
5
Years Exp
English Expert
9.0/10
5
Years Exp
Python Advanced
8.2/10
1
Years Exp
Pandas Advanced
8.0/10
1
Years Exp
Google Sheets Advanced
8.0/10
1
Years Exp
Pivot Tables Advanced
8.0/10
1
Years Exp
Microsoft Excel Advanced
8.0/10
1
Years Exp
Descriptive Statistics Advanced
8.0/10
1
Years Exp
EDA Advanced
8.0/10
1
Years Exp
Streamlit Advanced
8.0/10
1
Years Exp
SQL Advanced
8.0/10
1
Years Exp
NumPy Advanced
7.8/10
1
Years Exp
Power BI Intermediate
7.5/10
1
Years Exp
Plotly Intermediate
7.5/10
1
Years Exp
Looker Studio Intermediate
7.5/10
1
Years Exp
Feature Engineering Intermediate
7.5/10
1
Years Exp
K-Means Clustering Intermediate
7.5/10
1
Years Exp
Predictive Modeling Intermediate
7.5/10
1
Years Exp
Looker Intermediate
7.5/10
1
Years Exp
Tableau Intermediate
7.5/10
1
Years Exp
Modeling Intermediate
7.5/10
1
Years Exp
scikit-learn Intermediate
7.5/10
1
Years Exp
Seaborn Intermediate
7.5/10
1
Years Exp
Matplotlib Intermediate
7.5/10
1
Years Exp

Work Experience

Data Analyst Intern

Markss Infotech Pvt. Ltd.

Mar 2026 - Present

Engineered and deployed the Visibility IQ Dashboard, a real-time Streamlit application integrated with SQL Server, to monitor battery health, device performance, battery swaps, and operational disruptions across an executive fleet, enhancing operational visibility and enabling proactive maintenance through data-driven insights. Designed and implemented an executive-level Looker Studio dashboard analyzing ₹1.85B+ in sales revenue across multiple product categories, delivering interactive KPI tracking and performance insights that enabled leadership to make faster, data-driven strategic decisions. Optimized complex SQL queries and automated end-to-end reporting pipelines, reducing dashboard refresh time, improving data availability, and accelerating cross-functional reporting and stakeholder decision-making.

Education

B.Tech (Information Technology) - G H Patel College of Engineering & Technology

2022 - 2026 · India

High School - Shri J. P. Thakkar High School

2020 - 2022 · India

Certifications

Data Analytics Essentials

Cisco Networking Academy · 2025

Data Analytics Job Simulation

Deloitte Australia via Forage · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 6/15
💰 Rate 5/5
🏆 Certs 5/5
Verified 5/5
Total Score 91/100

Profile Overview

Member sinceJul 2026
Work ModeRemote
AvailabilityFull-time

Availability Details

Visa Status

Need Sponsorship

Relocation

Depends on Offer