Skip to content
View Nayan-Reddy's full-sized avatar

Block or report Nayan-Reddy

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 supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Nayan-Reddy/README.md
Nayan Reddy Soma - Data Analyst Banner

Hi there, I'm Nayan Reddy 👋

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.

Email    Resume    Portfolio LinkedIn

colorful line break

🚀 My Core Competencies

📊 Data Visualization & Business Intelligence

Creating interactive and insightful dashboards that empower business leaders to make data-driven decisions. My focus is on clarity, user experience, and actionable KPIs.

Power BI GIF Tableau logo Streamlit

⚙️ Data Analysis, ETL & SQL

Extracting, transforming, and analyzing data to answer complex business questions. I have a deep understanding of database querying, performance optimization, and data modeling.

SQL Pandas Python GIF

💡 AI & Full-Stack Data Applications

Building and deploying end-to-end data products, from the backend API and database to the user-facing frontend. I enjoy creating unique, data-powered experiences.

NLP FastAPI RAG

colorful line break

📂 Portfolio Showcase

Here are my flagship projects that demonstrate my skills and passion for data analytics and AI.

1. AI Portfolio Chatbot

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.

Python GIF NLP OpenAI Streamlit

  • 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.

Live Demo GitHub Repo

colorful line break

2. Expense Tracker Analytics App

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.

Python GIF FastAPI MySQL Pandas

  • 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.

Live Demo GitHub Repo

colorful line break

3. Business Insights 360 (Power BI)

An enterprise-grade BI dashboard for a hardware company, providing a 360-degree view of the business across Finance, Sales, Marketing, and Supply Chain.

Power BI GIF DAX SQL

  • 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.

Live Demo GitHub Repo

colorful line break

4. Ad-Hoc SQL Analysis for Consumer Goods

A SQL-based case study solving 10 real-world business problems for a consumer goods company, demonstrating strong problem-solving and analytical query skills.

SQL MySQL

  • 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.

GitHub Repo

colorful line break

🛠️ My Technical Skill Set

Area Core Tools Key Proficiencies & Techniques
Business Intelligence & Visualization Power BI

Streamlit

Excel
  • Architecting end-to-end BI solutions
  • Advanced DAX for dynamic measures & time intelligence
  • Complex Data Modeling (Galaxy Schema) & ETL with Power Query
  • Building & deploying interactive data applications
  • Implementing session management for personalized UIs
  • Advanced formulas, Pivot Tables, and automation
Database & Querying SQL (MySQL)
  • Writing advanced analytical queries (Window Functions, CTEs)
  • Performing conditional aggregation for comparative analysis
  • Designing and executing complex JOINs and subqueries
Data Processing & Analysis Python
  • Pandas & NumPy: High-performance data manipulation, cleaning, and aggregation
  • Scikit-learn: Applying core machine learning concepts like cosine_similarity
AI & NLP RAG Architecture

Key Libraries
  • Implementing Retrieval-Augmented Generation (RAG) pipelines
  • Building semantic search with Vector Embeddings
  • Creating NLP guardrails with Named Entity Recognition (NER)
  • OpenAI, spaCy, Sentence-Transformers
Backend & Developer Tools FastAPI

Platforms & Tools
  • Developing robust, production-ready REST APIs
  • Using Pydantic for API data validation
  • Git, GitHub, VS Code, Power BI Service, DAX Studio

Pinned Loading

  1. Business-Insights Business-Insights Public

    An end-to-end business intelligence solution for a global hardware company, built with Power BI. Features a complex Galaxy Schema data model, advanced DAX for multi-faceted analysis, and a five-pag…

  2. Consumer-Goods Consumer-Goods Public

    A SQL-based case study solving 10 real-world ad-hoc business requests for a consumer goods company, demonstrating proficiency in advanced SQL techniques like Window Functions and CTEs.

  3. expense-tracker-frontend expense-tracker-frontend Public

    The interactive Streamlit frontend for a full-stack expense analytics platform. This application features session-based personalization and dynamic dashboards that consume data from a FastAPI backend.

    Python

  4. Nayan-chatbot Nayan-chatbot Public

    An intelligent, RAG-based AI chatbot built with Streamlit and GPT-4o to act as an interactive portfolio, featuring a real-time analytics dashboard.

    Python