SK

Chapter 0 · Opening

Shubham
Keshri

Data Analyst & AI Developer

Turning raw, messy data into decisions. Scroll to fly through the story: where I started, what I build now, and where I’m headed.

↓ Scroll to begin

Chapter 1 · The past · 2023

It began with a question

I joined Amity University, Delhi for a Bachelor of Computer Application and chose Data Analysis as my specialization. I wanted to know how a pile of numbers becomes a clear answer.

Chapter 2 · Learning the tools · 2024

Then the tools

SQL first: T-SQL, CTEs, window functions. Then Python and Pandas, Excel and Power BI. Self-driven projects followed, and each one taught me something the classroom did not.

  • SQL
  • Python
  • Power BI
  • Excel

Chapter 3 · The present · now

What I build today

Pipelines, dashboards and AI apps. Keep scrolling and the work flies past, one project at a time.

Project 01 / 06

    Open repository ↗
    1. AI Resume Ranker AI-powered candidate screening that ranks resumes against a job description using NLP and semantic vector similarity.
    2. Customer Shopping Behavior Analysis Retail customer analysis with multi-tier segmentation and Power BI executive dashboards.
    3. Dirty Cafe Data Cleaning Automated pipeline that turns messy cafe sales logs into structured analytics tables.
    4. Maven Fuzzy Factory Analysis Website traffic, channel conversion funnels and revenue optimisation for an online store.
    5. SSMS SQL Employee Database Advanced T-SQL: ranking functions, CTEs and salary analytics on an enterprise schema.
    6. Productivity Dashboard in Excel Interactive task dashboard with conditional formatting and tracking.

    Chapter 3 · The toolbox

    What’s in the bag

    Programming
    Python · JavaScript · HTML5 · CSS3
    SQL
    MSSQL · T-SQL · MySQL
    Analytics & BI
    Power BI · Excel · Pandas · NumPy
    AI
    Machine learning · NLP · Streamlit · LangChain

    BCA, Amity University · CGPA 7.35 · Class of 2026

    Chapter 4 · The future · next

    Where I’m headed

    Data Analyst, BI and AI Developer roles, and internships. I want to build the systems that let a team ask a question and trust the answer: cleaner pipelines, sharper dashboards, and AI agents that do real work.

    “Without data, you’re just another person with an opinion.”

    Final chapter · Your turn

    Let’s build something useful

    Open to full-time roles and internships. Delhi, India · remote or hybrid.

    Email me GitHub LinkedIn

    © 2026 Shubham Keshri · Privacy policy