Shruti Shekhar

Data Analyst

Patna, Bihar 0+ yrs exp 81 · Excellent

About

Data Analyst with 8+ months of internship experience across 2 organizations, delivering end-to-end Business Intelligence solutions across logistics, retail, real estate, and sports domains. Proficient in Python, SQL, Power BI, Advanced Excel and Streamlit — with hands-on experience in ETL pipelines, data modelling, multi-level EDA, and stakeholder reporting through interactive dashboards that surface actionable business insights.

Skills & Expertise (30)

Microsoft Office Suite Intermediate

7.0/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

ETL Pipelines Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Matplotlib Intermediate

6.0/10

Years Exp

Python Intermediate

6.0/10

Years Exp

Seaborn Intermediate

6.0/10

Years Exp

scikit-learn Intermediate

6.0/10

Years Exp

Descriptive stats Intermediate

6.0/10

Years Exp

Univariate Analysis Intermediate

6.0/10

Years Exp

Bivariate Analysis Intermediate

6.0/10

Years Exp

Multivariate Analysis Intermediate

6.0/10

Years Exp

Hypothesis Testing Intermediate

6.0/10

Years Exp

Variance Analysis Intermediate

6.0/10

Years Exp

Data Modelling Intermediate

6.0/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

Conditional Formatting Intermediate

6.0/10

Years Exp

VLOOKUP Intermediate

6.0/10

Years Exp

Pivot Tables Intermediate

6.0/10

Years Exp

Power Query Intermediate

6.0/10

Years Exp

Streamlit Intermediate

6.0/10

Years Exp

M Query Intermediate

6.0/10

Years Exp

Aggregations Intermediate

6.0/10

Years Exp

Window Functions Intermediate

6.0/10

Years Exp

CTEs Intermediate

6.0/10

Years Exp

Subqueries Intermediate

6.0/10

Years Exp

Joins Intermediate

6.0/10

Years Exp

Work Experience

Data Analyst Intern

Labmentix

Mar 2026 - Sep 2026

Executed end-to-end ETL pipelines across logistics, sports, retail, and real estate domains — handling data extraction, cleaning, transformation, and dashboard delivery for each project independently. Built interactive Business Intelligence dashboards in Power BI and Streamlit tracking domain-specific KPIs including revenue trends, shipment performance, property pricing, and player statistics — enabling stakeholder reporting without manual data handling. Applied univariate, bivariate, and multivariate analysis techniques across real-world datasets to surface operational patterns, cost drivers, and business anomalies documented in structured stakeholder reports.

Data Analyst Intern

Mentorness

May 2024 - Jun 2024

Cleaned and transformed 2 large public datasets — COVID-19 case records and NREGA government scheme data — using advanced SQL including CTEs and window functions. Built Power BI dashboards analyzing pandemic spread trends and government scheme reach across states, producing KPI reports presented in final project reviews.