A passionate and detail-oriented Data Analyst with a strong foundation in AI & ML, specializing in transforming complex data into actionable business insights. My expertise lies in the end-to-end data lifecycle: from ETL, data modeling, and advanced SQL querying to building interactive dashboards and deploying full-stack data applications. I am driven by a passion for solving real-world problems and telling compelling stories with data.
Here are my flagship projects that demonstrate my skills and passion for data analytics and AI.
An intelligent, RAG-based AI chatbot built with Streamlit and GPT-4o to act as my interactive portfolio and answer questions about my professional profile.
- Architecture: Implemented a Retrieval-Augmented Generation (RAG) pipeline with a hybrid search strategy (semantic + lexical) for accurate responses.
- Features: Includes intelligent NLP guardrails (using spaCy) and a real-time analytics pipeline that logs all user interactions to Google Sheets.
- Impact: A unique and engaging way to present my skills and projects to recruiters.
A full-stack data application with a Streamlit frontend and a FastAPI/MySQL backend, demonstrating the ability to build a complete solution from database to dashboard.
- Architecture: Built with a decoupled frontend and backend, showcasing an understanding of modern application design.
- Analytics: The app provides personalized, session-based analytics, including category-wise contribution and month-over-month trend analysis.
- Features: Includes a "Demo Mode" with a preloaded dataset and a smart fallback to ensure a seamless user experience.
An enterprise-grade BI dashboard for a hardware company, providing a 360-degree view of the business across Finance, Sales, Marketing, and Supply Chain.
- Architecture: Developed a robust Galaxy Schema data model to handle complex relationships between multiple fact and dimension tables.
- Analytics: Wrote over 30 advanced DAX measures to perform dynamic P&L analysis, switchable benchmark comparisons (YoY vs. Target), and actionable risk classification (e.g., "Excess Inventory" vs. "Out of Stock").
- Impact: Created a single source of truth that empowers business leaders to make strategic, data-driven decisions.
A SQL-based case study solving 10 real-world business problems for a consumer goods company, demonstrating strong problem-solving and analytical query skills.
- Advanced SQL: Solved complex business problems using Window Functions (`RANK()`, `DENSE_RANK()`), CTEs, and conditional aggregation.
- Analysis: Performed a wide range of analyses, including Top-N per category, YoY growth calculations, and contribution analysis.
- Showcase: The repository is structured as a professional case study, with each query and its corresponding result clearly documented.
| Area | Core Tools | Key Proficiencies & Techniques |
|---|---|---|
| Business Intelligence & Visualization | Power BI Streamlit Excel |
|
| Database & Querying | SQL (MySQL) |
|
| Data Processing & Analysis | Python |
|
| AI & NLP | RAG Architecture Key Libraries |
|
| Backend & Developer Tools | FastAPI Platforms & Tools |
|