Skip to content
View heysubu's full-sized avatar
🙃
🙃

Block or report heysubu

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

Typing SVG


LinkedIn  GitHub  Profile Views



🧠   The Person Behind the Spreadsheets

Admin & MIS Executive turning chaotic, manual spreadsheets into clean automated systems. I've spent 5+ years at the intersection of data, process, and people — where nothing slips through the cracks.

    🎓  Pursuing MBA in Business Analysis



💼   What I Do Best

📊 MIS & Reporting

▸ Delivered weekly & monthly MIS to C-suite across 15–19 group companies
▸ Cut report generation time by 85% using Excel automation
▸ Built automated dashboards eliminating 100% manual data entry
▸ Managed full PO lifecycle for 50+ vendors with zero errors
Excel Automation

▸ Designed Macros for end-to-end workflow automation
▸ Built Power Query pipelines to clean & transform raw data instantly
▸ Dynamic dashboards with Pivot Tables, INDEX-MATCH & Conditional Formatting
▸ Reduced audit preparation time by 40% via automated compliance tracking
📈 Business Intelligence

▸ Power BI dashboards with DAX for real-time KPI tracking
▸ Built inventory systems for EV dealerships (Ather Energy)
▸ Sales tracking tools that helped teams hit targets 3 months running
▸ Delivered analytical reports enabling faster management decisions
🤝 Process & Operations

▸ Managed billing for 100+ vehicles (₹40L+/month) with zero errors
▸ Improved RTO registration process, cutting time by 20%
▸ Maintained 95% on-time delivery across logistics & B2B coordination
▸ Saved ₹8+ lakhs annually through documented process improvements


🛠️   My Toolkit

— Data & Reporting —

Excel  Macro  Power Query  Power BI  DAX  Google Sheets

— AI Tools —

ChatGPT  Claude  Julius AI  Power BI Copilot

— How I Work —

Process Improvement  ·  Stakeholder Communication  ·  Cross-functional Collaboration  ·  Project Coordination



📈   GitHub Stats

 



Activity Graph


Contribution Snake


📂   Projects

Real-world Excel automation & business solutions — built from actual problems, not tutorials.


Browse All Projects →



💬   Let's Build Something That Actually Works


if ( yourProcess === "manual" )             automate_it();
if ( yourData   === "scattered" )           consolidate_it();
if ( yourReports === "taking_forever" )     fix_it_with_subham();

Connect on LinkedIn  



Popular repositories Loading

  1. personal-finance-tracker personal-finance-tracker Public

    Comprehensive Excel-based personal finance management system with automated expense tracking, budget analysis, and wealth visualization

    2

  2. vehicle-customer-tracker vehicle-customer-tracker Public

    Excel-based customer tracking system for vehicle sales with accessories and charger allocation

    1

  3. monthly-accessories-sales-tracker monthly-accessories-sales-tracker Public

    Automated sales performance tracker with incentive calculation for automotive accessory sales

    1

  4. ather-stock-allocation-report ather-stock-allocation-report Public

    Comprehensive inventory management system for electric vehicle dealerships tracking stock allocation, aging, damage, and charger compatibility

    1

  5. purchase-requisition-form-system purchase-requisition-form-system Public

    Automated Excel-based purchase requisition management system with duplicate detection, multi-company support, and instant form generation

    1

  6. electricity-dg-billing-support-system electricity-dg-billing-support-system Public

    Automated Excel-based electricity and diesel generator billing system for commercial buildings with daily consumption tracking and multi-office support

    1