{ AK }
Contact

Data analyst portfolio / Gen AI workflows

Anirudh Mukund Kumar

Aspiring data analyst building around SQL, Python, Excel, Tableau, and Gen AI-assisted workflows — with projects that focus on customer behavior, dashboards, web apps, and AI product thinking.

0 public projects across analytics, dashboards, web development, and generative AI
0 transactions analyzed in the RFM customer segmentation project
0 dashboard revenue metric highlighted in the Excel sales and delivery project
0 goal: internship-ready work that shows analysis, execution, and communication

Proof / fast links

The essentials, grouped for a quick first look.

Resume, code, professional profile, and certificates are separated from the projects so a recruiter can verify the basics quickly.

A computer engineering student building the bridge between analytics work and AI leverage.

I focus on the practical side of data work: cleaning messy data, finding patterns, building dashboards, and using Gen AI where it actually saves time. I want the final output to be understandable to a recruiter, a manager, or a teammate at a glance.

The idea is simple: use tools like Python, SQL, Excel, Tableau, and AI to move faster through repetitive steps, then spend more time on judgment, interpretation, and communication.

The best portfolio is not the one with the most projects. It is the one that makes your thinking easy to see.

Projects that show analysis, product thinking, and hands-on engineering range.

Dashboard preview Featured · dashboard screenshot
Excel Dashboard Sales analytics Delivery metrics

E-Commerce Sales & Delivery Intelligence Dashboard

Interactive Excel dashboard for analyzing e-commerce sales performance, delivery metrics, and regional revenue trends.

Why it matters: it shows how a dashboard can turn sales, delivery, and payment data into a single view for faster business decisions.

View GitHub
Problem

Track revenue, delivery status, and regional performance in one place instead of reviewing separate reports.

Tools

Microsoft Excel, pivot tables, charts, slicers, KPI cards, and data cleaning.

Process

Prepared the data, built interactive filters, and organized the dashboard around fast scanning and comparison.

Outcome

Created a dashboard with revenue, delivery, and product insights, including KPI cards for $35,258 revenue, 76% fast deliveries, and top product tracking.

  • Impact Built interactive slicers for region, delivery status, and payment method.
  • Practiced executive-style reporting with clean, readable KPI design.
RFM Analysis Dashboard Customer segmentation · analysis preview
Python RFM Pandas Customer analytics

Customer RFM Analysis

Customer segmentation project using Recency, Frequency, and Monetary analysis to identify customer groups and marketing opportunities.

Why it matters: it shows how transaction data can be turned into a customer targeting framework instead of a flat spreadsheet.

View GitHub
Problem

Identify high-value, loyal, at-risk, and inactive customers using buying behavior instead of treating everyone the same.

Tools

Python, Pandas, NumPy, Matplotlib, Seaborn, Excel, and quantile-based scoring.

Process

Worked with 23,000+ transactions from 1,000 customers, calculated RFM scores, and grouped customers into business-ready segments.

Outcome

Built a repeatable segmentation workflow with groups such as Champions, Loyal Customers, Potential Loyalists, Big Spenders, At Risk, and Lost.

  • Impact Used Pareto analysis to show how a small group of customers drives disproportionate revenue.
  • Created a marketing-friendly way to think about retention and reactivation.
Java Web Dev Code Interface Learning path · Java / JSP / JDBC
Java JDBC Servlets JSP

Full-Stack Java Web Dev Journey

A structured collection of Java web development exercises and projects, ranging from Core Java to Jakarta EE and full web applications.

Why it matters: it shows backend understanding, documentation habits, and steady progress across the web stack.

View GitHub
Problem

Build a stronger foundation in server-side development and how data moves through web applications.

Tools

Core Java, JDBC, databases, Servlets, JSP, frontend basics, and capstone web application work.

Process

Kept the work organized into course sections: Core Java, JDBC/Databases, Servlets/JSP, capstone apps, and frontend development.

Outcome

Built a public learning trail that shows consistency, backend awareness, and web app fundamentals.

  • Impact Helps connect analytics work with how real web systems store and serve data.
  • Shows that you can learn in a structured way, not only finish one-off tutorials.
Shopsphere E-Commerce UI E-commerce UI · product flow preview
Java JSP Servlets MySQL

Shopsphere E-Commerce Project

A full-stack Java e-commerce web application featuring user authentication, product catalogs, shopping carts, and order management.

Why it matters: it connects frontend pages with the backend systems that create real business data.

View GitHub
Problem

Create an e-commerce flow that feels complete: login, browse products, add to cart, and manage orders.

Tools

JSP, Servlets, MySQL, Java backend logic, and full-stack e-commerce structure.

Process

Built the project around product catalog flow, user authentication, cart behavior, and order handling.

Outcome

Produced a working e-commerce application that demonstrates both backend and frontend implementation skills.

  • Impact Useful as a portfolio piece because it shows how data-rich web apps are structured.
  • Strong evidence of applying Java beyond coursework into a complete application flow.
Txt2Img AI Image Generator UI Gen AI app · prompt workflow preview
Python HTML/CSS/JS Gen AI Puter.js

AI Image Generator

A browser-based AI image generator with prompt enhancement, local history saving, multiple model options, and export features.

Why it matters: it shows you can build a useful Gen AI experience, not just call a model.

Problem

Give users an easy way to generate images from prompts while keeping the workflow fast and simple.

Tools

Vanilla HTML, CSS, JavaScript, Puter.js, and model selection logic.

Process

Built the prompt input flow, enhancement feature, local history, responsive interface, and dark/light mode support.

Outcome

Created a free, browser-based image generator with no API keys, plus export and clipboard features.

  • Impact Shows product thinking around AI usability and prompt refinement.
  • Good proof of frontend + AI workflow integration.

A stack tuned for analytics, automation, and the web systems around data products.

Analytics & AI

  • Python
  • SQL
  • Excel
  • Tableau
  • Generative AI

Engineering

  • Java
  • HTML5
  • CSS3
  • JavaScript
  • MySQL

Recent certifications that support the analytics and Gen AI direction.

Available for data analyst internship & job conversations.