Open to opportunities

Surbhi Yadav

@surbhiyadav

Message

Data analyst skilled in SQL, Power BI, Python, and data-driven insights.

India

Message

What I'm looking for

I seek a data-focused role where I can build dashboards, automate reporting, solve business problems with SQL/Python, and grow within a collaborative, learning-oriented team.

I am an analytical data professional with hands-on experience in SQL (MySQL, PostgreSQL), Python (Pandas, NumPy), Excel, and Power BI, focused on turning raw data into actionable business insights. I have built dashboards and automated reporting that improved visibility and informed decisions across sales, payroll, and operations.

My project work includes a Power BI retail sales dashboard visualizing $155M+ revenue and uncovering high-impact promotional strategies, Python/SQL analyses of $50M+ sales datasets, and API-driven YouTube performance analysis. I also delivered operational improvements as an intern by building payroll dashboards, standardizing task logs, and authoring SOPs that sped onboarding by 25%.

I bring a pragmatic, detail-oriented approach to data cleaning, ETL, and visualization, and I prioritize clear data storytelling to help stakeholders act. I hold a B.Tech in Computer Science and certifications including a PwC Power BI job simulation and a HackerRank SQL Gold Badge.

Experience

Work history, roles, and key accomplishments

Data & Operations Analyst Intern

RealtyEase AI

Apr 2025 - Sep 2025 (5 months)

Built payroll dashboards and standardized daily task logs for 25+ employees, improving payment visibility and reporting accuracy and speeding onboarding by 25% through 5+ SOPs. Coordinated with operations and client teams to enhance data collection and reporting processes.

Excel Google Sheets Data Cleaning SOP Development Power Query Data Collection Performance Tracking

Data Analyst (Project)

Walmart Sales Analysis

Cleaned and transformed sales data with Python and MySQL to analyze $50M+ revenue trends, identified best-selling categories and peak sales times, and supported branch- and payment-method-level decisions to improve operations.

Python Pandas NumPy MySQL Data Cleaning SQL Sales Analysis Revenue Analytics

Freelance Data Analyst

Freelance Project

Reformatted and cleaned student performance data and designed interactive dashboards in Excel/Google Sheets to enable teachers, students, and parents to track progress and identify strengths and weaknesses. Implemented slicers, conditional formatting, and charts for actionable insights.

Excel Power Query Google Sheets Data Cleaning Dashboard Design Conditional Formatting Data Visualization ETL

Data Analyst (Project)

YouTube Analysis

Retrieved and analyzed YouTube API data for 50+ videos using Python to identify top-performing content (1M+ views) and engagement patterns, delivering recommendations to optimize content strategy.

Python Pandas Data Analysis Web Scraping Data Visualization Content Analytics

Data Analyst (Project)

Retail Sales Analysis Dashboard

Designed a Power BI dashboard using MySQL and DAX to visualize $155M+ revenue and 442K+ units, analyzed promotion effectiveness achieving +110% IR% and +211.3% ISU%, and provided insights to optimize marketing and promotional strategies.

Power BI DAX MySQL Power Query Data Modeling Dashboarding

Education

Degrees, certifications, and relevant coursework

Rajiv Gandhi Proudyogiki Vishwavidyalaya

Bachelor of Technology, Computer Science

2021 - 2025

Grade: 7.89 CGPA

Bachelor of Technology in Computer Science with coursework in Databases, Python, Data Analytics, Big Data, and Data Mining & Warehousing; graduated with a CGPA of 7.89.