Back to Developers
Shruti Gupta

Shruti Gupta

Data Analyst

Nagpur, India 1+ yrs exp 89 · Excellent

About

Detail-oriented Data Analyst with 1+ year of experience collecting, cleaning, and analyzing large datasets to deliver actionable business insights. Proficient in SQL, Advanced Excel (Pivot Tables, Power Query, VLOOKUP), Power BI, and Tableau for building automated dashboards and performance reports. Skilled in identifying trends, patterns, and business opportunities through statistical analysis and data modeling. Experienced in cross-functional stakeholder collaboration, translating business requirements into data-driven recommendations that improve decision-making efficiency by up to 30%.

Skills & Expertise (34)

Advanced SQL Intermediate
7.4/10
1
Years Exp
Power BI Intermediate
7.4/10
1
Years Exp
Data Cleaning Intermediate
7.0/10
1
Years Exp
Data Visualization Intermediate
7.0/10
1
Years Exp
MySql Intermediate
6.4/10
1
Years Exp
Python Intermediate
6.4/10
1
Years Exp
Statistical Analysis Intermediate
6.4/10
1
Years Exp
Tableau Intermediate
6.4/10
1
Years Exp
DAX Intermediate
6.4/10
1
Years Exp
SQL Server Intermediate
6.4/10
1
Years Exp
Postgresql Intermediate
6.4/10
1
Years Exp
Excel VBA Intermediate
6.0/10
1
Years Exp
Data Mining Intermediate
6.0/10
1
Years Exp
Business Analytics Intermediate
6.0/10
1
Years Exp
Azure NumPy Pandas Git Automated Reporting Data Integrity Data Quality Data Validation Agile Data Warehousing ETL Processes Ad Hoc Analysis A/B testing EDA KPI Reporting Dashboard Development Data Modeling VLOOKUP Power Query Pivot Tables

Work Experience

Data Analyst

SheWork

Feb 2025 - Present

Collected, cleaned, and analyzed CRM datasets of 500+ records using advanced SQL and Power Query; ensured data quality, integrity, and consistency across reporting systems, reducing data errors by 25%. Developed and maintained automated Power BI dashboards and performance reports tracking hiring KPIs — improving data visibility by 30% and eliminating manual reporting effort by 25%. Wrote complex SQL queries (JOINs, subqueries, aggregations) to extract, manipulate, and validate structured data; performed statistical analysis to identify trends, patterns, and business opportunities in hiring data. Collaborated with cross-functional stakeholders to understand business requirements, performed ad hoc analysis, and presented data-driven recommendations to both technical and non-technical audiences.

Data Analyst Intern

Bartr Catalyst Group

Jan 2025 - Jun 2025

Collected and analyzed operational datasets using SQL and Python (Pandas); performed EDA and statistical analysis to identify trends and patterns, delivering actionable insights that supported strategic decision-making. Designed and maintained 5+ interactive Tableau and Power BI dashboards for KPI performance monitoring; documented analytical processes and methodologies, improving reporting efficiency by 30%. Ensured data quality and consistency across reporting systems through data profiling and validation; translated business requirements into data-driven solutions for leadership and cross-functional teams.

Education

B.Tech – Industrial Internet of Things - Yeshwantrao Chavan College of Engineering

2021 - 2025 · Afghanistan

Certifications

Data Analytics Job Simulation

Deloitte Australia · 2025

Adobe India Hackathon

· 2025

CodingNinjas

· 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 9/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 89/100

Profile Overview

Member sinceJul 2026

Availability Details

Relocation

Open to Relocation