# Shivaling Battarki — Data Analyst Portfolio > Data Analyst with 1 year of enterprise operations experience at Bharat Petroleum (BPCL), ongoing Scaler Academy DSML Fellow (joined Jan 2026), National Tableau Viz Challenge 2026 winner, and HackerRank 5-Star SQL Gold certified. Works with SQL (BigQuery, MySQL), Python (Pandas, NumPy, SciPy, Scikit-Learn), Tableau, Product Analytics, and Excel MIS automation, building toward a Data Science career focused on data-backed decisions and actions. ## Core Information - **Full Name**: Shivaling Battarki - **Location**: Hyderabad, Telangana, India - **Title**: Data Analyst / Analytics Engineer - **Email**: shivalingb09@gmail.com - **Phone**: +91 8971278063 - **Portfolio Website**: https://iamshivalingbattarki09.vercel.app/ - **GitHub**: https://github.com/Hazardous9hub - **LinkedIn**: https://www.linkedin.com/in/shivaling-93000/ - **Tableau Public**: https://public.tableau.com/app/profile/shivaling.battarki/vizzes - **HackerRank**: https://www.hackerrank.com/profile/shivalingb09 - **LeetCode**: https://leetcode.com/u/shivaling09000330/ --- ## Technical Competencies - **Database & Querying**: SQL, Google BigQuery, MySQL, MS SQL Server, Complex Joins, CTEs, Window Functions, DENSE_RANK, Relational Schema Design, Query Performance Optimization. - **Programming & Analysis**: Python, Pandas, NumPy, SciPy (Hypothesis Testing & Stats), Exploratory Data Analysis (EDA), Seaborn, Matplotlib, Central Limit Theorem (CLT), Probability Distributions. - **Business Intelligence & Dashboards**: Tableau Desktop & Public, Interactive Dashboards, Power BI, Calculated Fields, LOD Expressions, Parameter Controls, Business KPIs. - **Spreadsheets & ERP**: Advanced MS Excel, VBA & Macros, XLOOKUP, VLOOKUP, SUMIFS, Pivot Tables, SAP ECC (SD/MM modules). --- ## Professional Experience & Training ### Data Science & Machine Learning Fellow — Scaler Academy *Remote / Bengaluru, India | Jan 2026 – Present (Ongoing DSML Program)* - Completed coursework in SQL, Python (Pandas, NumPy, SciPy, Scikit-Learn preprocessing), Probability, Applied Statistics, Feature Engineering, and Data Visualization (Tableau and Excel). - Currently studying Product Analytics, with Machine Learning starting next as part of preparing for Data Science roles. - Built analytical case studies on public and corporate datasets for Target, Walmart, AeroFit, Rapido, Yulu, Netflix, and Delhivery. ### Engineering Apprentice (Analytics & Retail Operations) — Bharat Petroleum Corporation Limited (BPCL) *Kalaburagi Territory, Karnataka, India | Nov 2024 – Nov 2025* - Extracted and analyzed sales, tank-stock, and operational data across 350+ petroleum retail outlets using SAP ECC and Power BI-based reporting portals. - Analyzed 2 years of retail sales data across 50+ dealer outlets to evaluate dealer-wise bank credit eligibility under the e-DFS facility, calculating credit risk limits. - Automated daily MIS reporting pipelines in MS Excel using dynamic VBA macros, reducing compilation time from ~2 hours to under 30 minutes. - Coordinated the commissioning of 40+ new retail outlets during FY 2024–25 with cross-functional stakeholders. --- ## Featured Analytical Projects 1. **Delhivery Logistics Feature Engineering & ETA Analytics (98/100 Score)** - *Tech*: Python, Pandas, SciPy Stats, Scikit-Learn, Feature Engineering, Seaborn - Consolidated 144,867 raw checkpoint scan logs into 14,787 trips; proved OSRM underestimates transit time on 99.3% of trips (+80 min median, Wilcoxon p < 0.001) and uncovered Carting (19.3 km/h) vs FTL (29.9 km/h) fleet speed gaps. - *Repo*: https://github.com/Hazardous9hub/Delhivery-Logostics-Feature-Engineering-Analytics - *Dataset*: https://www.kaggle.com/datasets/shivaling09/delhivery-logistics-network-and-route-data 2. **Walmart Purchase Behavior & Central Limit Theorem Analysis** - *Tech*: Python, Pandas, SciPy Stats, Central Limit Theorem, Seaborn - Analyzed 550K+ retail transactions; demonstrated CLT convergence and non-overlapping 99% CI showing gender spend variance is driven by category mix. - *Repo*: https://github.com/Hazardous9hub/Walmart-Purchase-Behaviour-Business-Case-Study 3. **Target E-Commerce BigQuery Relational Analysis** - *Tech*: Google BigQuery, SQL, CTEs, Window Functions, Multi-table Joins - Analyzed 99K+ orders across 6 relational tables; identified 137% YoY revenue growth and pinpointed a 3.5x regional delivery lead-time bottleneck. - *Repo*: https://github.com/Hazardous9hub/Target-SQL-Business-Case-Study 4. **AeroFit Customer Segmentation & Profiling** - *Tech*: Python, Pandas, NumPy, Conditional Probability, Seaborn - Built demographic & behavioral profiles for 180 treadmill buyers; proved fitness level (80%+ conditional probability) is the primary predictor of premium tier adoption. 5. **Superstore Executive Sales & Profitability Dashboard** - *Tech*: Tableau Public, Parameters, LOD Expressions, Calculated Fields - Designed executive dashboard tracking $733K+ sales, discovering Central region table discounts accounted for 60%+ of operational losses. - *Live*: https://public.tableau.com/app/profile/shivaling.battarki/vizzes 6. **Rapido Ride Sharing & Churn Optimization** - *Tech*: SQL, Window Functions, Time-Series Bucketing - Analyzed driver proximity, peak-hour cancellation patterns, and surge sensitivity across 15 business problems. 7. **BPCL Retail Network Operations & Credit Tracker** - *Tech*: MS Excel, VBA / Macros, SAP ECC, XLOOKUP, SUMIFS - Automated daily sales reconciliation across 350+ pumps and calculated credit risk limits for 50+ retail dealers. --- ## Education & Certifications - **B.E. in Mechanical Engineering**: Brindavan College of Engineering, VTU Belagavi (CGPA: 8.67 / 10.0, Distinction, 2018–2022) - **HackerRank SQL Gold (5-Star)**: Verified database mastery (Feb 2026) - **Deloitte Australia Data Analytics Simulation**: Forage Certified (Aug 2026) - **SQL Skill Mastery**: Scaler & InterviewBit (Aug 2026)