Skip to content
View raugan's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report raugan

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

Hey, I'm Anurag 👋

PGDM student · Data Science · Bangalore

Commerce grad now deep into data science — learning by building. I work mostly with Excel, SQL, and Python, and I'm interested in how data can make financial decision-making clearer and faster. Currently in my first year of PGDM at IIBS Bangalore.


🛠 Tech stack

Languages Python SQL VBA

Data & analytics Excel Power Query Power BI Pandas NumPy

Databases MS Access MySQL

Finance & accounting Financial Modelling KPI Tracking Tally Prime Bloomberg

Tools & AI Git GitHub ChatGPT Claude


🚀 Projects

Things I've built while learning — nothing fancy, just solving real problems.

Aurelius Strategic Holdings - Financial Command Centre

Advanced Excel dashboard automating quarterly financial analysis with 54+ calculations, dynamic KPI engine, and board-ready PDF exports using VBA macros.


LUMINA: Personal Capital Intelligence & MIS Engine Hybrid dual-tier system combining MS Access relational database with Excel-based analytics engine featuring 10+ advanced formulas, 8 interactive charts, and AI-augmented insights.


VANGUARD: Retail Intelligence & Revenue Attribution Engine

End-to-end analytics system with Power Query ETL pipelines (99.9% data integrity), advanced SQL queries with CTEs and window functions, RFM segmentation, and AI-assisted strategic analysis identifying $770K+ in optimisation opportunities.

Movie Box Office Predictor

End-to-end ML pipeline predicting movie box office success using pre-release attributes with XGBoost, achieving 93.7% ROC-AUC. Leverages SHAP for interpretability, revealing director reputation as the leading success factor. Live Streamlit deployment for real-time predictions.


🎓 Certifications

Certification Issuer Date
Python for Data Science NPTEL · IIT Madras Jan–Feb 2026
Junior Cybersecurity Analyst Career Path Cisco Feb 2026
Bloomberg Finance Fundamentals Bloomberg Nov 2025
Generative AI Mastermind Outskill Nov 2025
Power BI Certification Course CSC Academy & IIBS 2025
Advanced Excel Certification Course CSC Academy & IIBS 2025
O Level in Computer Applications NIELIT Jan 2025

📫 Connect

LinkedIn Email

Pinned Loading

  1. movie-box-office-predictor movie-box-office-predictor Public

    I built an end-to-end ML pipeline that predicts movie box office success using only pre-release data, achieving 93.7% AUC with XGBoost. The key finding: a director's track record is more predictive…

    Python

  2. pizza-runner-sql-case-study pizza-runner-sql-case-study Public

    SQL case study on data cleaning, runner logistics, and pizza order analytics using MySQL

  3. dannys-diner-sql-case-study dannys-diner-sql-case-study Public

    SQL case study analyzing customer spending, loyalty membership behavior, and purchasing patterns using MySQL.

  4. Executive-Financial-Dashboard Executive-Financial-Dashboard Public

    Executive financial dashboard transforming quarterly statements into board-ready insights. 8 automated KPIs (liquidity, profitability, solvency, growth), 4 dynamic charts, quarter selector, and aut…

    VBA

  5. Lumina-MIS-Dashboard Lumina-MIS-Dashboard Public

    Hybrid financial intelligence system: MS Access backend (normalized schema, complex SQL) + Excel frontend (dynamic formulas, executive dashboards). Tracks income/expenses with AI-powered narrative …

  6. VANGUARD-Retail-Intelligence-Revenue-Attribution-Engine VANGUARD-Retail-Intelligence-Revenue-Attribution-Engine Public

    Advanced retail analytics engine transforming transaction data into strategic insights. Built with Excel (10 custom KPIs), SQL (14 complex queries), VBA automation, and AI-powered analysis. Identif…

    VBA