Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings
@DeveshShukla23
DeveshShukla23
Follow

Devesh Shukla DeveshShukla23

Aspiring Data Analyst | Data Scientist | Power BI & Excel Certified | Python, SQL, Machine Learning & Generative AI | Transforming data into actionable insight

Block or report DeveshShukla23

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please donโ€™t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
DeveshShukla23 /README.md

๐Ÿง  Who Am I?

devesh = {
 "name" : "Devesh Shukla",
 "based_in" : "Jhansi, Uttar Pradesh ๐Ÿ‡ฎ๐Ÿ‡ณ",
 "education" : "BA History & Sociology โ€” BU (2019)",
 "experience" : "Data Analyst Intern @ Access Million โœ…",
 "duration" : "6 Months | Aug 2025 โ€“ Feb 2026",
 "certs" : "14 Certifications in DS, Analytics & AI ๐Ÿ†",
 "roles" : ["Data Analyst", "Data Scientist", "AI/GenAI Developer"],
 "tools" : {
 "languages" : ["Python", "SQL", "R"],
 "bi" : ["Power BI", "Tableau", "Excel"],
 "ml" : ["Scikit-learn", "TensorFlow", "LSTM"],
 "ai" : ["LLaMA 3.3 70B", "Groq API", "Streamlit"],
 "databases" : ["MySQL", "MySQL Workbench"]
 },
 "capstone" : "CHANAKYA โ€” 12-Layer AI Commerce Platform ๐Ÿ›๏ธ",
 "latest" : "TRACE โ€” AI Root Cause Analyzer ๐Ÿ”",
 "philosophy" : "Data is not numbers. It is the story of your business.",
 "status" : "๐ŸŸข Actively seeking opportunities"
}


๐Ÿ’ผ Work Experience

๐Ÿข Data Analyst Intern โ€” Access Million

Premium Marketing Services | Pune, India ๐Ÿ“… Aug 2025 โ€“ Feb 2026 | โฑ๏ธ 6 Months | ๐Ÿฌ Marketing Department

  • ๐Ÿ“Š Analyzed marketing data to drive business decision-making
  • ๐Ÿ“ˆ Built data visualizations and reports for the marketing team
  • ๐Ÿ” Applied end-to-end analytics in a real professional environment
  • ๐Ÿ’ก Delivered actionable insights to support campaign strategies

๐Ÿš€ Featured Projects

๐Ÿ›๏ธ CHANAKYA โ€” AI Commerce Intelligence

Python โ€ข MySQL โ€ข Power BI โ€ข ML โ€ข Deep Learning โ€ข Agentic AI

My flagship capstone โ€” a 12-layer end-to-end Data Science platform built on 100% original Indian e-commerce data.

What's inside:

  • ๐Ÿ—„๏ธ MySQL Star Schema โ€” 14,829 records
  • ๐Ÿ“Š EDA + RFM โ€” 9 customer segments
  • ๐Ÿšจ Anomaly Detection โ€” 34 frauds caught
  • ๐Ÿค– ML + LSTM + Churn Prediction
  • ๐Ÿ“Š Power BI Dark Dashboard โ€” DAX
  • โšก ARTHA Agentic AI โ€” LLaMA 3.3 70B

Python MySQL Power BI TensorFlow Groq Streamlit

๐Ÿš€ Live App | ๐Ÿ“‚ GitHub

๐Ÿ” TRACE โ€” AI Root Cause Analyzer

Trend Recognition and Automated Cause Explanation Python โ€ข Streamlit โ€ข Groq LLaMA 3.3 70B โ€ข Scikit-learn โ€ข Plotly

Upload any business CSV or Excel file โ€” TRACE automatically detects anomalies, traces root causes via correlation analysis, and generates plain English diagnostic reports. Any domain. Under 2 minutes.

What's inside:

  • ๐Ÿ”ฌ 9 Anomaly Detection Methods โ€” Z-Score, IQR, Isolation Forest, Level Shift & more
  • ๐Ÿ”— Correlation Engine โ€” Lag detection, Pareto ranking, contribution %
  • ๐Ÿค– LLaMA 3.3 70B โ€” AI-narrated root cause reports via Groq API
  • ๐Ÿ“Š Plotly Dark Dashboard โ€” KPI cards, heatmap, anomaly timeline
  • ๐Ÿท๏ธ Confidence Tags โ€” [ VERIFIED ] [ CONFIRMED ] [ PROBABLE ]
  • ๐ŸŒ Domain Agnostic โ€” Sales, HR, Finance, Logistics, Operations

Skills: Python Streamlit Pandas NumPy SciPy Scikit-learn Plotly Groq API LLaMA 3.3 70B RapidFuzz Statistical Analysis NLP Anomaly Detection Correlation Analysis

๐Ÿš€ Live App | ๐Ÿ“‚ GitHub

๐Ÿš— BMW Global Sales Intelligence

Excel โ€ข MySQL โ€ข Python โ€ข Power BI โ€ข K-Means โ€ข Forecasting

4 tools. 4 phases. 785ใƒ‰ใƒซ.58M revenue story โ€” zero shortcuts.

Most analysts get clean data. I started with 4,569 rows of corrupted BMW records.

The pipeline:

  • ๐Ÿ“‹ Excel โ€” 29-column audit, 800+ bad records flagged
  • ๐Ÿ—„๏ธ MySQL โ€” 8 business queries, CTEs + Window Functions
  • ๐Ÿ Python โ€” 13 M5 Black visuals, K-Means (K=4), 193ใƒ‰ใƒซ.5M forecast
  • ๐Ÿ“Š Power BI โ€” 4-page BMW M5 Black dashboard, 13 DAX measures

Python MySQL Power BI DAX Scikit-learn Plotly Excel

๐Ÿ“‚ GitHub

๐Ÿค– KAUTILYA โ€” Agentic AI Data Analyst

Python โ€ข Groq LLaMA3 โ€ข Agentic AI โ€ข Voice Enabled

AI agent that autonomously analyzes any CSV/Excel dataset โ€” in Hindi & English.

Highlights:

  • ๐Ÿง  Groq LLaMA3 โ€” Transformer Agentic AI
  • ๐ŸŽค Voice Input & Output โ€” Hindi & English
  • ๐Ÿ“Š Auto Visualizations โ€” 4 chart types
  • ๐Ÿ’ก Autonomous business insights

Python Groq Streamlit SpeechRecognition gTTS

๐Ÿš€ Live App | ๐Ÿ“‚ GitHub

๐Ÿ• NLP Sentiment Analysis โ€” Food Delivery

Python โ€ข NLP โ€ข Machine Learning โ€ข Deep Learning

1,459 real reviews from Zomato, Swiggy & Blinkit โ€” 7 models tested.

Highlights:

  • ๐Ÿค– 5 ML + 2 Deep Learning models
  • ๐Ÿ† Random Forest โ€” 91.10% Accuracy
  • ๐ŸŒ Live Streamlit App deployed
  • ๐Ÿ’ก Actionable business insights

Python NLTK TensorFlow Streamlit VADER

๐Ÿš€ Live App | ๐Ÿ“‚ GitHub

๐Ÿ” BCG X โ€” PowerCo Churn Prediction

Python โ€ข Scikit-Learn โ€ข Random Forest โ€ข Forage

Real-world BCG X simulation โ€” challenged the price sensitivity hypothesis with ML.

Highlights:

  • ๐Ÿ‘ฅ 14,606 customers | 9.7% churn rate
  • ๐Ÿค– Random Forest โ€” ROC-AUC: 0.71
  • ๐Ÿ’ก Proved price โ‰  primary churn driver
  • โœ… Certificate โ€” BCG X x Forage

Python Pandas Scikit-Learn Matplotlib Seaborn

๐Ÿ“‚ GitHub

๐Ÿ“Š Quantium Data Analytics Simulation

Python โ€ข SciPy โ€ข Pandas โ€ข Forage

Real retail analytics โ€” 245K+ transactions, uplift testing.

Highlights:

  • ๐Ÿ›๏ธ 245K+ transactions | 71K customers | 1ใƒ‰ใƒซ.8M revenue
  • ๐Ÿ“Š Customer segmentation & uplift testing
  • ๐Ÿ”ฌ Pearson Correlation for control store matching
  • โœ… Certificate โ€” Quantium x Forage

Python Pandas SciPy Matplotlib Seaborn

๐Ÿ“‚ GitHub

๐Ÿ“ฆ Blinkit Sales Dashboard

Power BI โ€ข DAX โ€ข Business Intelligence

1ใƒ‰ใƒซ.2M+ in sales across 10 outlets โ€” interactive Power BI dashboard.

Highlights:

  • ๐Ÿ“Š KPIs โ€” Sales, Avg Sales, Items & Ratings
  • ๐Ÿ—บ๏ธ Sales by Outlet Location (Tier 1/2/3)
  • ๐Ÿ“ˆ Trend analysis 2012โ€“2022
  • ๐Ÿ”„ Interactive slicers & DAX measures

Power BI DAX Data Visualization Business Intelligence

๐Ÿ“‚ GitHub

๐Ÿ’ฐ Dynamic Pricing Model

Python โ€ข Machine Learning โ€ข Predictive Analytics

3 ML models compared on a self-created synthetic pricing dataset.

Highlights:

  • ๐Ÿค– Linear Regression, Decision Tree, Random Forest
  • ๐Ÿ† Random Forest โ€” R2: 0.97
  • ๐Ÿ“‰ Residual & error analysis
  • ๐Ÿ“Š Feature importance breakdown

Python Scikit-Learn Matplotlib Pandas

๐Ÿ“‚ GitHub

๐Ÿ›’ E-Commerce SQL Analysis

MySQL โ€ข Data Analysis โ€ข Business Queries

Full e-commerce database built from scratch โ€” 7 real-world business queries solved.

Highlights:

  • ๐Ÿ—„๏ธ Designed full schema from scratch
  • โ“ 7 business queries answered
  • ๐Ÿ“‹ JOINs | CTEs | Window Functions | CASE WHEN

MySQL MySQL Workbench SQL Data Analysis

๐Ÿ“‚ GitHub

๐Ÿฅ MedSathi โ€” AI Health Assistant

Python โ€ข Google Gemma 3 โ€ข Streamlit โ€ข Google AI Studio

Built for the Gemma Impact Hackathon 2025 โ€” an AI health companion for 700M+ rural Indians who lack access to doctors.

What's inside:

  • ๐Ÿค– Google Gemma 3 (gemma-3-4b-it) โ€” Core AI engine
  • ๐ŸŒ Bilingual โ€” Hindi & English support
  • ๐Ÿšจ Emergency Detection โ€” Auto-alerts with 108/104 helplines
  • ๐Ÿ’Š 6 Quick Symptom Buttons โ€” Accessible for elders
  • ๐ŸŽจ Dark medical green theme โ€” Streamlit Cloud deployed

Python Google Gemma 3 Google AI Studio Streamlit CSS

๐Ÿš€ Live App | ๐Ÿ“‚ GitHub

๐Ÿ”œ More Coming Soon...

Always building. Always learning.

Currently working on:

  • ๐Ÿง  ANTARVANI โ€” AI Emotional Support App
  • ๐Ÿ“Š HR Analytics Dashboard (Power BI)
  • ๐ŸŒ ATLAS โ€” Conflict-Driven Commodity Dashboard

โญ Watch this space!


๐Ÿ“Š GitHub Stats

๐Ÿ† Certifications

๐Ÿฅ‡ Certification Institution Year
๐Ÿ… Data Science Job Simulation BCG X x Forage Mar 2026
๐Ÿ… Data Analytics Job Simulation Quantium x Forage Mar 2026
๐Ÿ… Masters in Data Analytics TopMentor Feb 2026
๐Ÿ… Masters in Data Science TopMentor Feb 2026
๐Ÿ… Masters in Business Analytics TopMentor Feb 2026
๐Ÿ“‹ View All 14 Certifications
# ๐Ÿ† Certification ๐Ÿซ Institution ๐Ÿ“… Year ๐Ÿท๏ธ Category
1 Data Science Job Simulation BCG X x Forage Mar 2026 ๐Ÿ”ฌ Data Science
2 Data Analytics Job Simulation Quantium x Forage Mar 2026 ๐Ÿ“Š Analytics
3 Masters in Data Analytics TopMentor Feb 2026 ๐Ÿ“Š Analytics
4 Masters in Data Science TopMentor Feb 2026 ๐Ÿ”ฌ Data Science
5 Masters in Business Analytics TopMentor Feb 2026 ๐Ÿ’ผ Business
6 Machine Learning Specialist TopMentor Feb 2026 ๐Ÿค– ML / AI
7 Generative AI โ€” Prompt Engineer TopMentor Feb 2026 ๐Ÿง  Gen AI
8 Generative AI โ€” ChatGPT Specialist TopMentor Feb 2026 ๐Ÿง  Gen AI
9 Power BI Specialist TopMentor Feb 2026 ๐Ÿ“ˆ Visualization
10 Tableau Specialist TopMentor Feb 2026 ๐Ÿ“ˆ Visualization
11 Python Specialist TopMentor Feb 2026 ๐Ÿ Programming
12 SQL Specialist TopMentor Feb 2026 ๐Ÿ—„๏ธ Database
13 R Programming Specialist TopMentor Feb 2026 ๐Ÿ“‰ Programming
14 Advanced Excel Specialist TopMentor Feb 2026 ๐Ÿ“‹ Analytics

๐Ÿค Let's Connect!

๐ŸŸข Open to Data Analyst | Data Scientist | AI/GenAI Developer Opportunities!

6 months internship โ€ข 14 certifications โ€ข 10 projects โ€ข 5 live apps

"Most people analyse clean data. I started with the mess โ€” because that's what real analyst jobs look like."


LinkedIn GitHub Email CHANAKYA TRACE Portfolio


โญ If my work adds value โ€” drop a star on my repos! โญ

Footer

Pinned Loading

  1. CHANAKYA CHANAKYA Public

    CHANAKYA - AI Commerce Intelligence Platform | End-to-End Data Science Capstone Project | 12 Layers | ETL | SQL | EDA | ML | Deep Learning | Power BI | Agentic AI | Streamlit

    Jupyter Notebook

  2. BMW_Global_Sales_Analysis BMW_Global_Sales_Analysis Public

    ๐Ÿš— End-to-End BMW Global Sales Analysis | Excel โ†’ SQL โ†’ Python โ†’ Power BI | 4,569 Records | 785ใƒ‰ใƒซ.58M Revenue | EDA, K-Means Clustering, Forecasting & Interactive Dashboard

    Jupyter Notebook

  3. KAUTILYA-AI-Data-Analysis-Agent KAUTILYA-AI-Data-Analysis-Agent Public

    ๐Ÿค– Agentic AI Data Analysis Agent | Groq LLaMA3 70B | Voice Enabled Hindi & English | Auto Visualizations | Live Streamlit App

    Python

  4. MedSathi MedSathi Public

    AI Health Assistant for Rural India powered by Gemma 3 | Built for Gemma Impact Hackathon 2025

    Python

  5. BCG-Data-Science-Job-Simulation BCG-Data-Science-Job-Simulation Public

    ๐Ÿ“Š 14,606 customers | 9.7% churn | One hypothesis to test | Built end-to-end ML pipeline to uncover real churn drivers for PowerCo | BCG X Data Science Job Simulation on Forage

    Jupyter Notebook

  6. Ecommerce-SQL-Analysis Ecommerce-SQL-Analysis Public

    ๐Ÿ›’ End-to-end MySQL project | 7 Business Queries | JOINs โ€ข CTEs โ€ข Window Functions โ€ข CASE WHEN | 3ใƒ‰ใƒซ.2M+ Revenue Analysis | Star Schema Design

AltStyle ใซใ‚ˆใฃใฆๅค‰ๆ›ใ•ใ‚ŒใŸใƒšใƒผใ‚ธ (->ใ‚ชใƒชใ‚ธใƒŠใƒซ) /