Skip to content
View saket08004's full-sized avatar
  • Shahjahanpur
  • 08:38 (UTC -12:00)

Block or report saket08004

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

Hi, I'm Saket Tripathi 👋

Data Analyst & Business Analyst · SQL · Python · Power BI · Excel
Turning raw data into decisions that matter.


👤 About Me

I'm a data analyst with hands-on experience building analytics systems, financial dashboards, and business intelligence solutions on datasets exceeding 1.7M+ records. My work sits at the intersection of finance, operations, and data — the kind of problems that matter at consulting and advisory firms.

  • 🔍 Focused on: Financial Analytics, GST Reconciliation, AR Ageing, Revenue & Customer Analytics
  • 🛠️ Currently deepening expertise in: Advanced DAX, Statistical Analysis, and Real-World Dataset Projects
  • 🎯 Open to: Data Analyst and Business Analyst roles at consulting and advisory firms

🛠️ Tech Stack

Data & Databases

PostgreSQL SQL

Analytics & Python

Python Pandas NumPy Matplotlib Seaborn Jupyter

Business Intelligence

Power BI Excel


📂 Featured Projects

Python · Pandas · Power BI · Financial Analytics

Automated GST reconciliation system that detects vendor filing discrepancies and quantifies ITC loss exposure. Built on simulated enterprise-scale datasets; surfaced ₹3.01M+ in potential tax credit risk across 500 invoices.


PostgreSQL · Window Functions · CTEs · Stored Procedures · Query Optimization

End-to-end SQL analytics project on 1.7M+ records covering schema design, 16 business-driven queries, stored procedures, triggers, and EXPLAIN ANALYZE-backed indexing. Answers real business questions: conversion rates, revenue trends, customer segmentation, refund patterns.


Python · Pandas · Matplotlib · Seaborn · EDA

Exploratory analysis on a 7,000+ record telecom dataset to identify churn drivers across tenure, contract type, payment method, and demographics. Delivered actionable segment-level insights for retention strategy.


Excel · Power Query · KPI Reporting · Financial Analytics

Interactive AR dashboard tracking overdue invoices, DSO, ageing buckets, and collection efficiency. Automated data refresh via Power Query; AR-to-GL reconciliation included.


📈 GitHub Activity


"Data is only as valuable as the decisions it drives."

📬 Reach me at saket08004@gmail.com

Pinned Loading

  1. gst-reconciliation-tool gst-reconciliation-tool Public

    Automated GST reconciliation · ₹3.01M tax credit risk identified · Python · Pandas · Power BI

    Python

  2. maven-fuzzy-factory-sql-analytics maven-fuzzy-factory-sql-analytics Public

    PostgreSQL analytics on 1.7M+ records · 16 business queries · Window functions · Stored procedures · Indexing

    PLpgSQL

  3. Customer_Churn_Analysis Customer_Churn_Analysis Public

    Telecom churn EDA · 7,000+ records · 26.54% churn rate identified · Python · Pandas · Seaborn

    Jupyter Notebook

  4. Accounts-Receivable-Analysis-Dashboard Accounts-Receivable-Analysis-Dashboard Public

    AR analytics dashboard · ₹2.38M outstanding tracked · DSO 242 days · AR ageing buckets · Excel · Power Query