Skip to content
View Koyyalanaveen's full-sized avatar

Highlights

  • Pro

Block or report Koyyalanaveen

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
Koyyalanaveen/README.md

Hi, I'm Naveen Koyyala 👋

Data Analyst | SQL · Python · Power BI · Excel · BI Reporting

B.Tech ECE Graduate from Hyderabad, India. I build end-to-end analytics projects covering data cleaning, SQL analysis, KPI dashboarding, and business intelligence reporting. My focus is on converting raw data into clear, actionable business insights.

🛠️ Skills

Data & Programming

Python Pandas NumPy SQL MySQL

Business Intelligence & Visualization

Power BI DAX Power Query Tableau Advanced Excel Excel VBA

Tools & Platforms

Streamlit Jupyter GitHub VS Code

📊 Featured Projects

Project Summary Tools
E-Commerce Sales & Support Analytics End-to-end analytics project covering sales, delivery, returns, and support tickets with AI-style ticket auto-tagging. Python, SQL, Power BI, Pandas
AI Data Cleaning & Quality Audit Assistant Streamlit web app for CSV data profiling, quality scoring, business rule validation, and cleaned file export. Python, Streamlit, Pandas
Procurement & Supplier Performance Dashboard Analyzed 777 purchase orders across 5 suppliers to track OTD, defect rates, and a $4M savings opportunity. SQL, Excel, Power Query, Power BI
Mutual Fund Analytics Dashboard Analyzed 20 mutual funds across Equity, Debt, and Hybrid categories using NAV, CAGR, Sharpe Ratio, Alpha, and Beta. Excel, Power Query, Power BI, DAX
Portfolio Optimization & Risk Analysis Risk-return analysis using Monte Carlo simulation and Excel Solver to support asset allocation decisions. Python, Pandas, NumPy, Excel, Power BI
AI-Based Smart Traffic Monitoring & Challan System B.Tech major project for traffic violation detection using computer vision and OCR-based number plate recognition. IEEE paper submitted. Python, YOLOv8, OpenCV, Flask, MySQL

💼 What I Bring to the Table

  • Clean, validate, and transform raw datasets for business reporting
  • Write SQL queries for data extraction, aggregation, and analysis
  • Build interactive Power BI dashboards with DAX measures and Power Query ETL
  • Build financial models and KPI trackers in Advanced Excel
  • Create KPI reports, MIS summaries, and business insight decks
  • Build lightweight data tools and audit apps using Streamlit

📜 Certifications

  • SQL Intermediate — HackerRank
  • Excel Basics for Data Analysis — IBM / Coursera
  • Data Visualization & Dashboards with Excel and Cognos — IBM / Coursera
  • Power BI Workshop — OfficeMaster
  • Python Essentials 1 & 2 — Cisco / OpenEDG (May 2026)

🚀 Currently Exploring

  • Python Data Visualization — Matplotlib and Seaborn (actively practicing)
  • Excel VBA & Reporting Automation (currently learning)

📬 Contact

Open to entry-level opportunities in Data Analytics, BI Reporting, MIS Reporting, SQL Analysis, Python Analytics, and Business Analyst roles. Immediate joiner.

Pinned Loading

  1. ecommerce-sales-support-analytics ecommerce-sales-support-analytics Public

    End-to-end e-commerce analytics project using Python, SQL, Power BI, and AI-style support ticket tagging.

    Jupyter Notebook

  2. AI-Data-Cleaning-Quality-Audit-Assistant AI-Data-Cleaning-Quality-Audit-Assistant Public

    Streamlit app for CSV data profiling, quality checks, cleaning recommendations, and audit report generation.

    Python

  3. Procurement-Analytics-Dashboard Procurement-Analytics-Dashboard Public

    Procurement analytics dashboard for supplier performance, defect tracking, cost savings, and KPI reporting.

  4. Mutual-fund-analytics-dashboard Mutual-fund-analytics-dashboard Public

    Mutual fund analytics dashboard tracking NAV, CAGR, Sharpe Ratio, Alpha, Beta, and fund performance.

  5. portfolio-optimization-tool portfolio-optimization-tool Public

    Portfolio optimization project using Excel Solver, Monte Carlo simulation, SQL, and Power BI for risk-return analysis.

  6. AI-Traffic-Monitoring-Automatic-Challan-System AI-Traffic-Monitoring-Automatic-Challan-System Public

    Academic computer vision project using Python, YOLOv8, OpenCV, OCR, Flask, and MySQL for traffic violation detection and challan record management.