Skip to content
View KrishnaSai315's full-sized avatar

Block or report KrishnaSai315

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
KrishnaSai315/README.md
Typing SVG

Gmail LinkedIn GitHub Memphis TN

About Me

SELECT  name, title, experience, edge
FROM    analysts
WHERE   name = 'Loknadh Kona';
Field Value
🎓 Education M.S. Data Science — University of Memphis · GPA 3.81 / 4.0
💼 Experience SQL · Python · HIPAA Certified · Analytics Projects · Real-World BI Delivery
🏢 Past Roles Junior Data Scientist @ BEPEC Solutions · Systems Engineer @ Atos
📊 Domains Financial services · Sales analytics · Supply chain & Logistics
⚡ Edge 99%+ pipeline availability · Executive-ready dashboards that drive decisions

🏆 Impact at a Glance

Metric Result How
Manual reporting effort ↓ 30% Self-service Power BI & Tableau dashboards
Downstream data errors ↓ 25% Automated SQL + Python anomaly detection
Business-review prep time ↓ 30% Excel VBA macros
Financial pipeline uptime 99%+ SLA ops at Atos Global (Franklin Templeton, Cummins)
Hidden shipment delay found 15% delay rate SQL-engineered Days-to-Ship SLA metrics

🛠️ Tech Stack

SQL & Data Engineering

SQL Server T-SQL PostgreSQL ETL Pipelines Data Warehouse

BI & Visualization

Power BI Tableau Excel & VBA DAX

Programming & Analytics

Python Pandas NumPy Scikit-Learn Git

🚀 Featured Projects

🏗️ SQL Data Warehouse & Analytics Pipeline

T-SQL · Star Schema · Medallion Architecture · SQL Server

Built a production-grade data warehouse from scratch (Bronze → Silver → Gold layers). Engineered 13 advanced analytical scripts covering customer segmentation (VIP / Regular / New), product rankings, and time-series revenue analysis (YoY & MoM) using RANK, DENSE_RANK, LAG, and window functions.

Data Warehouse Data Analytics

📦 Supply Chain & Logistics BI Dashboard

Power BI · SQL · DAX · Data Modeling

Uncovered a hidden 15% delay rate in Standard Class shipments across the Southern region using custom SQL SLA metrics. Built interactive Power BI dashboards giving logistics managers a single view to isolate bottlenecks and drive corrective action.

View Project

📊 Customer Service Performance Dashboard

Excel · Pivot Tables · Dynamic Slicers · KPI Tracking

Interactive Excel dashboard analyzing 1,000+ call records with dynamic slicers, KPI tracking for operational analytics, rep performance, and regional breakdowns — enabling fast, data-driven service decisions.

View Project

💼 Data Science Salary Dashboard

Excel · Array Formulas · FILTER Function · Map Charts

Interactive Excel dashboard exploring 2023 data science job salaries across 9 roles, 50+ countries, and 5 schedule types — built with advanced array formulas and geographic map charts for instant global insight.

View Project

🎓 Education & Certifications

Degree / Certification Institution Year
🎓 M.S. Data Science · GPA 3.81 / 4.0 University of Memphis 2024 – 2025
🎓 B.Tech. ECE Amrita Sai Institute of S&T 2017 – 2021
📜 HIPAA Certified The HIPAA Journal 2026
📜 SQL HackerRank 2026
📜 SQL for Data Science UC Davis (Coursera) 2024
📜 Excel Skills for Business: Essentials Macquarie University (Coursera) 2024

"Data is not just numbers — it's the story behind every decision."

Pinned Loading

  1. SQL-Data-Analytics SQL-Data-Analytics Public

    An End-to-End advanced SQL data analysis project Pipeline transforming warehouse raw data into strategic business assets.An End-to-End advanced SQL data analysis project Pipeline transforming wareh…

    TSQL 1

  2. SQL-DataWareHouse_Project SQL-DataWareHouse_Project Public

    Building a modern Data Warehouse with SQL Server, including ETL processes, Data modeling and Analytics.

    TSQL 1

  3. supply-chain-logistics-dashboard supply-chain-logistics-dashboard Public

    End-to-end supply chain analytics: Excel → Python → SQL Server → Power BI

    Jupyter Notebook 1

  4. Data-Science-Salary-Dashboard Data-Science-Salary-Dashboard Public

    Interactive Excel dashboard exploring 2023 data science job salaries across 9 roles, 50+ countries & 5 schedule types - built with array formulas, FILTER function & map charts.

    HTML 1

  5. customer-service-performance-dashboard customer-service-performance-dashboard Public

    Interactive Excel dashboard — 1,000 call records, dynamic slicers, KPI tracking for operational analytics, rep performance, and regional analytics

    1

  6. Data-Jobs-Market-Dashboard-PowerBI Data-Jobs-Market-Dashboard-PowerBI Public

    Power BI dashboard on 478K+ real 2024 job postings — salary benchmarks, skill demand analysis, and geospatial hiring map