Skip to content
View Saksham3124's full-sized avatar
1 follower · 5 following

Highlights

  • Pro

Block or report Saksham3124

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

Kumar Saksham

Turning complex data into practical business solutions.

What I Build

I enjoy designing end-to-end analytical solutions that transform raw data into meaningful insights.

My projects combine SQL, Python, PostgreSQL, Tableau, Power BI, and AWS to automate workflows, analyze large datasets, and support data-driven decision-making across domains such as finance, taxation, and transportation.

I'm currently exploring cloud analytics, data engineering concepts, and scalable data pipelines while continuously improving my problem-solving skills.

Selected Projects

Credit Risk Analytics & Decision Support

An end-to-end analytics solution built on 307K+ loan applications to identify default risk patterns and support credit decision-making.

Key Highlights

  • Python-based preprocessing and feature engineering
  • PostgreSQL database design
  • Advanced SQL analytics
  • Customer segmentation and KPI reporting
  • Statistical risk analysis
  • Interactive Tableau dashboards

Tech Stack

Python SQL PostgreSQL Tableau

Repository

➡️ https://github.com/Saksham3124/credit-risk-analytics

GST Invoice Anomaly Detection & Vendor Risk Scoring System

A business intelligence solution that detects anomalous invoices and evaluates vendor risk across 50K+ GST records.

Key Highlights

  • SQL Window Functions
  • Z-Score & IQR anomaly detection
  • Vendor risk scoring framework
  • Audit-focused analytics
  • Interactive Tableau dashboards

Tech Stack

Python SQL PostgreSQL Tableau

Repository

➡️ https://github.com/Saksham3124/gst-invoice-anomaly-detection

Railway Delay Analytics & Monitoring System

An automated analytics system that collects railway delay data, performs SQL-based analysis, and visualizes operational trends.

Key Highlights

  • Automated data collection with APScheduler
  • PostgreSQL storage
  • SQL analytics
  • Power BI dashboards
  • Delay trend monitoring
  • Operational reporting

Tech Stack

Python SQL PostgreSQL Power BI

Repository

➡️ https://github.com/Saksham3124/Rail-Delay-Tracker

Tech Stack

Category Technologies
Programming Python, SQL
Database PostgreSQL
Data Analytics Pandas, NumPy, Matplotlib
Business Intelligence Tableau, Power BI, Excel
Cloud AWS (S3, Athena, RDS)
Tools Git, Jupyter

Currently Exploring

  • Advanced SQL & Query Optimization
  • Cloud Analytics on AWS
  • Data Engineering Fundamentals
  • Scalable ETL Pipelines
  • Business Intelligence
  • System Design Fundamentals

Connect

Pinned Loading

  1. gst-invoice-anomaly-detection gst-invoice-anomaly-detection Public

    3-layer GST invoice anomaly detection system using Python, PostgreSQL, and SQL window functions — with vendor risk scoring and Tableau dashboard

    Python 1

  2. credit-risk-analytics credit-risk-analytics Public

    End-to-end credit risk analysis on 307K loan applicants using SQL, Python & Tableau — identifying default patterns across demographics, age groups, and bureau activity

    Jupyter Notebook

  3. Rail-Delay-Tracker Rail-Delay-Tracker Public

    Real-time railway delay simulation pipeline with automated scheduling, risk classification, CSV + PostgreSQL dual storage, and a Power BI dashboard for trend monitoring and analysis.

    Python 1

  4. Spending-Analytics-Forecasting Spending-Analytics-Forecasting Public

    ML-powered spending analytics system with category prediction, budget monitoring and forecasting

    Python 1

  5. olist-ecommerce-delivery-analysis olist-ecommerce-delivery-analysis Public

    End-to-end SQL analysis of 100K+ Olist orders identifying delivery failures, geographic risk patterns, and seller accountability gaps — visualized in Tableau.

    1

  6. Superstore-KPI-Dashboard Superstore-KPI-Dashboard Public

    Business KPI dashboard analyzing $2.3M Superstore sales using Python, SQL, and Power BI

    Python 1