- 🏢 Business & Data Analyst @ Monster Energy (Feb 2022 – Present)
- 📊 7+ years transforming data into executive-level decisions
- 🎓 MBA + MS in IT — California Baptist University, Riverside CA
- ⚡ Automated 30% off our reporting cycle with Power Query & VBA
- 🌍 Cross-continental experience across USA 🇺🇸 · India 🇮🇳
- 🤝 Expert at cross-functional collaboration: finance, ops, merchandising
- 🎮 Just shipped: Monster × Call of Duty Barcode Generator
- 💬 Ask me about Power BI · SQL · Python · SAP · Agile · Excel Automation
📊 BI & Visualization
💻 Languages & Databases
🏗️ Platforms & Tools
🔧 Excel Expertise
|
Barcode Generator
Product SKU & barcode system for a Monster Energy × COD limited-edition collab. Supports UPC-A, EAN-13, CODE128 & CODE39 with PNG download.
|
Multi-Location KPI Tracker In Progress Dynamic Power BI + SQL dashboard for 50+ retail locations. Variance analysis, inventory alerts, and promotional ROI tracking — drove 15% sales uplift.
|
|
Mars Inc. — 20+ Distribution Centers In Progress Unified SAP/ERP reporting dashboards for multi-DC operations. Automated milestone tracking & inventory risk flags — boosted accuracy 25%.
|
Automated Variance & Planning In Progress Python + Excel Power Query forecasting system. Eliminated manual reporting cycles — 30% time reduction, adopted by finance & ops teams.
|
┌─────────────────────────────────────────────────────────────────────────────┐
│ GURDEEP SINGH — CAREER JOURNEY │
├──────────┬──────────────────────────────────────────────────────────────────┤
│ 2018–19 │ 📦 Junior Data Analyst · Domino's · Punjab, India │
│ │ 50+ location performance dashboards · Excel automation │
├──────────┼──────────────────────────────────────────────────────────────────┤
│ Jun–Sep │ 📡 Data Analyst · Airtel · Delhi, India │
│ 2019 │ Budget forecasting · SQL reporting · KPI dashboards │
├──────────┼──────────────────────────────────────────────────────────────────┤
│ 2019–21 │ 🌍 Data Analyst – Supply Chain · Mars Incorporated · India │
│ │ 20+ DCs · SAP/ERP · Milestone tracking · Risk flags │
├──────────┼──────────────────────────────────────────────────────────────────┤
│ 2022–Now │ 🟢 Business & Data Analyst · Monster Energy · Riverside, CA │
│ │ Power BI · Excel VBA · Agile · Cross-functional analytics │
├──────────┼──────────────────────────────────────────────────────────────────┤
│ 2023 │ 🎓 MBA – California Baptist University, Riverside CA │
├──────────┼──────────────────────────────────────────────────────────────────┤
│ 2024 │ 🎓 MS Information Technology – California Baptist University │
└──────────┴──────────────────────────────────────────────────────────────────┘
gurdeep = {
"role" : "Business & Data Analyst @ Monster Energy 🟢",
"building" : ["Supply Chain Dashboard", "Forecasting Engine", "Portfolio Site"],
"learning" : ["dbt Core", "Databricks", "ML for Time-Series Forecasting"],
"open_to" : "Senior Analyst · BI Manager · Data Lead roles 🚀",
"fun_fact" : "I built a Monster × Call of Duty barcode scanner for fun ⚡🎮"
}| Badge | Certification | Issuer | Year |
|---|---|---|---|
| 📊 | Advanced Excel for Data Analysis | Microsoft | 2023 |
| 📈 | Power BI Dashboard Development | Microsoft | 2023 |
| 🗄️ | SQL for Business Analytics | Coursera | 2022 |
| 🔄 | Agile Project Management | Scrum Alliance | 2022 |
| 🏭 | Supply Chain Analytics | APICS / Coursera | 2021 |
