Kumar Udeshya

About Me

Results-Driven
Data Storyteller

End-to-End Projects

100K+

Records Analysed

Tools Mastered

Certifications

🔍

              Deep SQL Expertise
              Complex joins, CTEs, window functions & query optimisation
            

🏗️

              Project Ownership
              Independently scoped, executed & documented all analytics projects
            

💡

              Business Thinking
              Translates findings into loyalty strategy, staff optimisation & inventory management
            

I'm a results-oriented Data Analyst currently pursuing my BCA at Magadh University, with strong hands-on experience in SQL analytics, Python automation, and business intelligence dashboarding.

I specialise in deriving actionable business insights from complex datasets across customer behaviour, operations, and delivery performance domains. Every project I take on is independently scoped, executed, and documented — end-to-end.

Currently based in Patna, Bihar, and actively seeking an entry-level Data Analyst or Junior Analyst role where I can contribute analytical depth in a professional environment. I continuously upskill through certifications from Deloitte, IBM, HackerRank, and GUVI.

✉ Email Me LinkedIn →

Technical Arsenal

Skills & Tools

A curated stack built through real project work — not just tutorials.

🐍

Programming

Python Pandas NumPy Scikit-learn Matplotlib Seaborn

🗄️

Databases & SQL

SQL MySQL PostgreSQL Window Functions CTEs Subqueries Query Optimisation

📊

Visualisation & BI

Power BI Tableau DAX Excel Pivot Tables Power Query

🔬

Analytics Methods

EDA Statistical Analysis A/B Testing Hypothesis Testing Time-Series Analysis Data Wrangling

TOOL PROFICIENCY

SQL90%

Python (Pandas/NumPy)82%

Power BI78%

Tableau72%

Excel / Power Query80%

Statistical Analysis70%

KEY STRENGTHS

🧠 Analytical Depth

Converts raw datasets into strategic decisions, not just charts

⚡ Self-Starter

Independently scoped and delivered all projects with zero hand-holding

📚 Continuous Learner

Certifications from Deloitte, IBM, HackerRank & GUVI underline commitment to growth

Portfolio

Featured Projects

End-to-end analytics solutions independently built from raw data to boardroom-ready insights.

Project / 01

Zomato Sales & Operations Analytics

End-to-End SQL Analytics

A comprehensive operational analytics project on a simulated Zomato-scale dataset — joining 5+ datasets to surface revenue patterns, customer segments, and delivery KPIs.

Identified top-10 restaurants driving ~60% of total platform revenue

Segmented customers into high-value, loyal & at-risk cohorts — loyal customers showed 35%+ higher AOV

Time-series analysis on 100,000+ orders pinpointed peak demand (7–10 PM) for staffing optimisation

Built a delivery partner KPI ranking model for a performance-based incentive framework

SQL CTEs Window Functions Multi-Table Joins Time-Series MySQL

Project / 02

Library Management System Analytics

SQL Analytics Project

Analytical deep-dive into 10,000+ library checkout records to uncover borrowing patterns, inventory anomalies, and operational inefficiencies.

Identified top-3 authors & categories responsible for 45%+ of total checkouts

Detected same-day multi-checkout anomalies as high-demand procurement signals

Storage location analysis flagged high-risk zones — recommended RFID/barcode for a projected 30% reduction in inventory loss

Peak checkout time analysis used to optimise staff scheduling & reduce wait times

SQL Anomaly Detection Inventory Analysis PostgreSQL Time-Series

Project / 03

Customer Behaviour Analysis Dashboard

Power BI Dashboard

An interactive Power BI dashboard analysing purchasing trends, customer demographics, and revenue insights across 5,000+ customers with ₹994K+ in total revenue tracked.

Dynamic filters for gender, category, subscription status & discounts

KPIs for revenue by category, payment method, season, location & age distribution

Applied Power Query, DAX & data modelling for cleaning, transformation & advanced calculations

Power BI DAX Power Query Data Modelling KPI Design

Project / 04

Swiggy Sales Analytics Dashboard

Excel Dashboard

An interactive Excel dashboard analysing Swiggy sales performance, customer ordering trends, food category insights, and regional sales distribution across multiple states with ₹53M+ total sales tracked.

Built dynamic slicers for month, category, and restaurant-level filtering

Designed KPI cards for Total Sales, Average Rating, Orders, Rating Count, and Average Order Value

Created trend analysis visuals for monthly, daily, and weekly sales along with state-wise and city-wise performance insights

Used Pivot Tables, Power Query, charts, conditional formatting, and advanced Excel formulas for data cleaning and dashboard automation

MS Excel Pivot Tables Power Query Data Visualization Dashboard Design KPI Reporting

View All Projects on GitHub →

Track Record

Training & Simulations

Industry-recognised programmes that mirror professional data analytics workflows.

Forage · Deloitte Australia

Data Analytics Job Simulation

Deloitte Australia — Virtual Experience Programme

Completed a simulated engagement mirroring Deloitte's actual data analyst workflow
Worked on forensic data analysis, business problem framing, and visual storytelling with real-world datasets
Practised data cleaning, analysis, and presenting insights in a professional consulting context

IBM Developer Skills Network

Data Analytics Mentorship Program

IBM — Structured Learning Pathway

Completed IBM's structured analytics mentorship covering data analysis fundamentals and tools
Gained exposure to data pipeline thinking, statistical concepts, and real-world business application
Reinforced Python and SQL skills through IBM's guided project-based learning

HackerRank · GUVI

SQL Certification & Python Mentorship

HackerRank + GUVI — Technical Certifications

Earned HackerRank SQL Certification — validated through multi-difficulty query challenges
Completed GUVI's Python Mentorship Programme, deepening Pandas and NumPy proficiency
Applied learned concepts directly in Zomato and Library analytics projects

Background

Education & Certifications

Bachelor of Computer Applications (BCA)

Magadh University, Bodh Gaya, Bihar

July 2023 — May 2026

Relevant coursework: Database Management Systems, Statistics, Data Structures, Programming with Python.

Built end-to-end data analytics projects independently during coursework — demonstrating self-driven learning beyond the standard curriculum.

Certifications & Training

🏢

Data Analytics Job Simulation

Deloitte Australia · Forage

💼

Data Analytics Mentorship Program

IBM Developer Skills Network

✅

SQL Certification

HackerRank

🐍

Python Mentorship Program