Skip to content
View Hazardous9hub's full-sized avatar
πŸ“ˆ
Learning and Upskilling
πŸ“ˆ
Learning and Upskilling

Block or report Hazardous9hub

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.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. 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
Hazardous9hub/README.md
Header Banner Typing SVG



Portfolio Resume LinkedIn Tableau HackerRank LeetCode Email



β›½ Enterprise Operations
350+ Retail Outlets
Monitored daily sales & stock at BPCL
πŸ” Cloud Relational SQL
99K+ Orders Analyzed
Target BigQuery multi-table case study
πŸ† Database Competency
5-Star Gold Badge
HackerRank verified SQL ranking
πŸŽ“ Academic Merit
8.67 CGPA
B.E. Mechanical Engineering (VTU)

πŸ‘¨β€πŸ’» About Me & My Journey

I am a Data Analyst with a degree in Mechanical Engineering (8.67 CGPA) and a year of on-ground enterprise operations experience at Bharat Petroleum Corporation Limited (BPCL).

  • βš™οΈ From Physical Systems to Data: My engineering background trained me to think in numbers, constraints, and root causes. At BPCL, I saw how physical operations rely on day-to-day data accuracy: monitoring fuel throughput, underground tank inventories, and dealer credit risk across 350+ retail stations.
  • πŸ› οΈ Practical Process Automation: Working with SAP ECC, Advanced Excel, and VBA, I rebuilt manual daily reporting routines, cutting MIS compilation time from 2 hours down to around 30 minutes (~75% reduction) and evaluated bank credit eligibility under the e-DFS facility for 50+ retail dealers.
  • πŸ“ˆ Rigorous Upskilling with Scaler DSML: I committed to deep analytical training through Scaler Academy's Data Science & Machine Learning program, mastering SQL (BigQuery, MySQL), Python (Pandas, NumPy, Scipy, Seaborn, Matplotlib, Sci-Kit Learn), Applied Probability, Hypothesis Testing, and Tableau Public. Learning Product analytics (RCA, RFM customer segmentation,Guess Estimates)
  • 🎯 Current Focus: Open to full-time Data Analyst / Business Analyst roles where I can combine operational intuition with clean SQL queries, statistical rigor, and executive dashboards.

πŸ› οΈ Technical Arsenal

Languages & Querying Python SQL BigQuery MySQL VBA
Analytics & Statistics Pandas NumPy SciPy scikit-learn Probability Hypothesis Testing
BI & Data Visualization Tableau Power BI Excel Seaborn
Enterprise & Workflow SAP ECC Git Jupyter Colab

πŸ“‚ Detailed Project Breakdown & Artifacts

🚚 Delhivery: Logistics Feature Engineering & ETA Optimization β€” Python SciPy scikit-learn
  • 🎯 Business Problem & Scale: Rebuilt 14,787 end-to-end trips from 144,867 raw checkpoint scans to test the predictive accuracy of Delhivery's Open Source Routing Machine (OSRM).
  • πŸ’‘ Quantified Outcome: Actual trips ran 194.6 minutes longer than OSRM predictions on average (median 80 min, $p < 0.001$), proving that OSRM underestimates real transit by failing to account for highway congestion and checkpoint handling.
  • πŸ”— Direct Artifacts: πŸ”— GitHub Repository β€’ πŸ““ Jupyter Notebook β€’ πŸ“Š Case Study Report (PDF) β€’ πŸ—‚οΈ Kaggle Dataset
πŸ›’ Target E-Commerce: BigQuery Logistics Disparity & Revenue Scaling β€” Google BigQuery SQL CTEs Window Functions
  • 🎯 Business Problem & Scale: Evaluated delivery lead-times across Brazilian states, transit bottlenecks, and customer repeat behavior across 99,441 orders in 6 relational BigQuery tables.
  • πŸ’‘ Quantified Outcome: Identified a 3.5x regional delivery delay (29.3 days in Roraima vs. 8.3 days in SΓ£o Paulo), while Jan–Aug revenue grew +137% YoY. Recommended localized regional fulfillment hubs in the Northern zone.
  • πŸ”— Direct Artifacts: πŸ”— GitHub Repository β€’ πŸ“„ Master SQL Queries (.sql) β€’ πŸ“Š Case Study Report (PDF)
πŸ›οΈ Walmart: Consumer Purchase Behavior & Central Limit Theorem β€” Python CLT Sampling Distributions
  • 🎯 Business Problem & Scale: Tested demographic spending assumptions across 550,000+ Black Friday transactions to guide seasonal inventory allocation and promotional budgets.
  • πŸ’‘ Quantified Outcome: Men spend +$702.96 (+8.05%) more per transaction with zero CI overlap at 99% confidence, while marital status showed no spending difference ($4.74 variance, completely overlapping CIs).
  • πŸ”— Direct Artifacts: πŸ”— GitHub Repository β€’ πŸ““ Jupyter Notebook β€’ πŸ“Š Case Study Report (PDF) β€’ πŸ“± LinkedIn Slides
🚲 Yulu Micro-Mobility: Statistical Hypothesis Testing (ANOVA & Chi-Square) β€” Python Pingouin Two-Way ANOVA
  • 🎯 Business Problem & Scale: Diagnosed electric cycle revenue slumps and evaluated environmental and temporal drivers across 10,886 hourly rental records using a 6-step hypothesis testing framework.
  • πŸ’‘ Quantified Outcome: Revealed a +136% weekend surge in casual riders against commuter-dominated weekdays, a 50% spring demand collapse ($p < 10^{-100}$), and a 42% rental drop during adverse weather.
  • πŸ”— Direct Artifacts: πŸ”— GitHub Repository β€’ πŸ““ Jupyter Notebook β€’ πŸ“Š Case Study Report (PDF)
πŸƒ AeroFit: Treadmill Customer Segmentation & Conditional Probability β€” Python EDA Contingency Tables
  • 🎯 Business Problem & Scale: Evaluated customer demographic profiles across entry-level (KP281), mid-tier (KP481), and commercial (KP781) treadmills to build targeted sales recommendations.
  • πŸ’‘ Quantified Outcome: Self-rated fitness was the single strongest indicator: 93.5% of customers rating fitness 5 bought the premium KP781 model, proving fitness habit outweighs income or age alone.
  • πŸ”— Direct Artifacts: πŸ”— GitHub Repository β€’ πŸ““ Jupyter Notebook β€’ πŸ“Š Case Study Report (PDF)
πŸ“Š Superstore: Executive Sales & Profitability Dashboard β€” Tableau Public LOD Expressions Parameters
  • 🎯 Business Problem & Scale: Provided executive visibility into loss-making product categories, regional discount sensitivity, and customer margins across $733K+ in total sales.
  • πŸ’‘ Quantified Outcome: Discovered that aggressive discounting on Tables in the Central region accounted for over 60% of total regional operating losses, providing quantitative justification for discount caps.
  • πŸ”— Direct Artifacts: 🌐 Live Interactive Dashboard (Tableau Public) β€’ πŸ‘€ Tableau Public Profile
πŸ“‚ View More Specialized Projects & Operational Analyses (BPCL, Rapido, HR, IoT, Netflix)

πŸ“œ Verified Certifications & Credentials

  • πŸ† HackerRank SQL - 5-Star Gold Badge (View Verified Profile)
  • πŸ‡¦πŸ‡Ί Data Analytics Job Simulation β€” Deloitte Australia (via Forage) (Certificate)
  • πŸŽ“ SQL Skill Mastery Certification β€” Scaler Academy & InterviewBit
  • πŸ“Š Data Analytics & Visualisation: Probability & Statistics β€” Scaler DSML
  • 🐍 Data Analytics & Visualisation: Python Libraries (Pandas, NumPy, Seaborn) β€” Scaler DSML
  • πŸ“ˆ Tableau & Excel Specialization β€” Scaler DSML
  • πŸŽ“ Bachelor of Engineering (B.E.) in Mechanical Engineering β€” VTU Belagavi (CGPA: 8.67)

🐍 GitHub Contribution Snake

GitHub Contribution Snake

πŸ’¬ Analytical Mindset

"Numbers have an important story to tell. They rely on you to give them a clear and convincing voice."
β€” Stephen Few

Whether it's auditing daily sales across 350 petroleum stations, diagnosing regional logistics delays in BigQuery, or finding purchase drivers with conditional probability, I enjoy the craft of making data clean, clear, and actionable.

Designed & Maintained with curiosity by Shivaling Battarki β€’ Open for Data & Business Analyst Roles

Pinned Loading

  1. Indian-Automotive-Specification-Intelligence-Portal Indian-Automotive-Specification-Intelligence-Portal Public

    Interactive Indian Automotive Specification & Performance Intelligence Portal with dual-mode Showroom Mosaic, Radar benchmarking, and Tableau integration.

    HTML 1

  2. Delhivery-Logostics-Feature-Engineering-Analytics Delhivery-Logostics-Feature-Engineering-Analytics Public

    Delhivery's Logistics Network & Route Data Analytics implementing Data Cleaning, Hypothesis Tests & Feature Engineering

    Jupyter Notebook 1

  3. Target-SQL-Business-Case-Study Target-SQL-Business-Case-Study Public

    Target Brazil E-Commerce SQL Business Case Study analyzing 99K+ orders across 27 states using Google BigQuery (CTEs, Window Functions, Logistics & Revenue Analysis).

    1

  4. Walmart-Purchase-Behaviour-Business-Case-Study Walmart-Purchase-Behaviour-Business-Case-Study Public

    Analyzing 550K+ Walmart retail transactions using Python, Central Limit Theorem (CLT), and Confidence Intervals (90%, 95%, 99%) to debunk demographic spending myths and optimize retail merchandising.

    Jupyter Notebook 1

  5. Yulu-Hypothesis-Testing-Business-Case-Study Yulu-Hypothesis-Testing-Business-Case-Study Public

    Jupyter Notebook

  6. EDA-Data-Profile-Tool EDA-Data-Profile-Tool Public

    A python script for exploring basic features of Data

    Python