Yogita Gupta
Data Analyst
Narayangarh,HR
Work Preference
Education
Bachelor in Computer Application - Data Science
Maharishi Markandeshwar (Demeed To Be University)
Mullana 09.2022 - 03.2026
Timeline
Bachelor in Computer Application - Data Science
Maharishi Markandeshwar (Demeed To Be University)
09.2022 - 03.2026
Overview
3
3
years of post-secondary education
Skills
- Data Analysis & manipulation: Python (Pandas, NumPy), SQL (Joins, CTEs, Window Functions), Advanced Excel (Power Query, Pivot Tables)
- Data Visualization: Power BI (DAX, Power BI Service, Interactive Dashboards)
- Statistical Analysis: Descriptive Statistics, Data Distribution
- Database Management: Relational Databases (MySQL), Data Cleaning & ETL
- Soft Skills: Data Storytelling, Analytical Thinking, Problem-Solving, Stakeholder Communication, Time Management
Summary
Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations.
Languages
English
Upper intermediate (B2)
Hindi
Advanced (C1)
Certification
Python Internship Training - Solitaire Infosys Pvt.Ltd - 6weeks
Projects
Food Delivery Data Analysis & Performance Optimization
- Analyzed 5K+ delivery records using SQL (multi-table joins, CTEs, window functions) to evaluate delivery performance, customer behavior, and revenue trends
- Identified key patterns such as peak ordering hours (8 PM–12 AM) and analyzed late delivery percentages across cities
- Developed an interactive Power BI dashboard with KPIs, delivery performance metrics, and customer insights for data-driven decision-making
- Generated actionable insights, including impact of delivery distance on delays, correlation between faster delivery and higher ratings, and identification of high-value customers contributing majority of revenue
E-Commerce Sales Analysis Dashboard
- Cleaned and transformed 1,000+ rows of raw sales data using Excel and Power Query to ensure data accuracy and consistency
- Developed an interactive Power BI dashboard with KPIs, slicers, and dynamic visualizations for real-time business insights
- Analyzed customer behavior, revenue trends, and product performance to support data-driven decision-making
- Utilized DAX measures (MTD, YTD, Same Period Last Year) to perform advanced time-based analysis
- Identified top-selling categories and profit trends, improving visibility into business performance and strategic planning
- Analyzed retail sales data to identify sales patterns by day, hour, and month, uncovering peak periods and seasonal trends
- Evaluated store location performance and average order value to understand customer spending behavior and optimize pricing strategies
- Identified best-selling products by quantity and revenue, supporting inventory planning and product optimization
- Generated actionable insights to improve staffing efficiency, inventory management, and overall sales performance
Big Data-Driven Customer & Revenue Intelligence System
- Designed and executed an end-to-end Sales Data Analysis project using Python (Pandas, NumPy) and Power BI, converting raw data into actionable business insights
- Performed data cleaning, EDA, and feature engineering (profit margin, time-based metrics) to uncover key trends in customer behavior and revenue
- Developed an interactive Power BI dashboard with dynamic KPIs and visualizations to support strategic decision-making
- Identified high-value customer segments driving ~80% of revenue and delivered insights to optimize sales performance and customer targeting