Analytics & BI
SQLPower BITableauLookerExcelKPI Reporting
Open to Data, BI & Analytics Opportunities
Swapnil
Herwadkar
Data & BI Analyst / Business Intelligence / AI-Powered Decision Systems
I build practical analytics systems that turn operational data into decisions — from SQL-backed reporting and executive dashboards to workflow automation, predictive analytics, and AI-powered decision support.
3+ yrsAnalytics & business intelligence experience
60+ hrsMonthly reporting effort saved through automation
30%Faster recurring report turnaround
25%Reduction in manual data processing effort
15%SQL query execution-time improvement
35%Workflow-efficiency improvement in reporting layers
01 / CAREER
Career Circuit
Operational analytics, enterprise reporting, business intelligence, and AI-assisted decision systems.
Oct 2024 — Oct 2025 · Data Analyst · ContractOperational Analytics, KPI Design & Reporting AutomationCommunity Dreams Foundation
- Translated homeowner intake, contractor matching, incentives, and project workflows into KPI definitions and dashboard requirements.
- Automated SQL-driven reporting and sustainability KPI workflows, reducing manual processing effort by 25%.
- Optimized MySQL reporting datasets and reusable BI logic for self-service analytics.
Nov 2022 — Jun 2023 · Data Analyst IIEnterprise BI, KPI Reporting & ETL AutomationAccenture
- Built SQL and Power BI KPI dashboards for recurring operational reporting.
- Automated ETL/reporting pipelines with scheduling, retries, alerts, and QA checks, saving 60+ hours per month.
- Standardized KPI definitions, mappings, validation rules, and reporting documentation.
Feb 2021 — Nov 2022 · Data Analyst ISQL Performance, ERP Data & Reporting ReliabilityAccenture
- Optimized high-volume SQL using indexing, partitioning, CTE refactors, and window functions, reducing execution time by 15%.
- Integrated SAP HANA/BW, ERP, and source-system data into reporting layers, improving workflow efficiency by 35%.
- Reconciled ERP, SQL, and reporting-layer data to improve accuracy and reduce discrepancies.
02 / SKILLS
Core Skills
Business-facing analytics with engineering depth for automation, validation, and scalable reporting.
Data Platforms
SnowflakeMySQLBigQueryRedshiftSAP HANASAP BW
Automation & AI
PythonPandasREST APIsNode.jsOpenAI APIETL
Business Analysis
RequirementsData ValidationRoot Cause AnalysisUATAgileJIRA
03 / PROJECTS
Featured Builds
Selected work across decision intelligence, business intelligence, operations analytics, supply chain, and predictive modeling.
Flagship · AI Decision System
SwapOpt V4 — Career Decision & Outcome Intelligence
Browser-first career intelligence system that evaluates opportunities from verified evidence, supports truthful ATS and application work under explicit user control, tracks lifecycle outcomes, and learns from personal market patterns over time.
JavaScript · Node.js · Express · OpenAI · Chrome Extension
View V4 showcase ↗AI + BI Platform
FIFA World Cup 2026 Sponsorship Analytics
End-to-end sponsorship analytics platform combining Python ETL, Snowflake, SQL, Power BI, Streamlit, and conversational AI for governed KPI reporting and decision support.
Python · Snowflake · SQL · Power BI · Streamlit · OpenAI
View repository ↗Operations Analytics
ABS Inventory Forecasting & Optimization
Time-series inventory analysis using historical sales, replenishment, and lead-time data to forecast demand and support reorder-point, safety-stock, and SKU-allocation decisions.
Python · Pandas · Statsmodels · ARIMA · SARIMA
View repository ↗Healthcare Supply Chain
ARV / HIV Treatment Distribution Analysis
Tableau-led analysis of treatment and test-kit shipments across Africa, examining delivery delays, vendor performance, shipment modes, pricing, and geographic distribution.
Tableau · Excel · XLMiner · Supply Chain Analytics
View repository ↗Predictive Analytics
Ad Click Prediction
Predictive targeting pipeline for high-probability ad-click users using feature engineering, class balancing, and gradient-boosted modeling.
Python · Scikit-learn · XGBoost · SMOTE · Pandas
View repository ↗ESG + Predictive Modeling
Fashion Sustainability Index
Analysis of fashion-industry environmental indicators with Random Forest modeling and Tableau dashboards to identify sustainability drivers and predict rating patterns.
Python · Scikit-learn · Random Forest · Tableau
View repository ↗04 / EDUCATION
Education
Business analytics training built on an engineering foundation.
Sep 2023 — Aug 2024
Master of Science in Business Analytics
University of Massachusetts Amherst
Jul 2016 — Aug 2020
Bachelor of Engineering in Electronics
Ramdeobaba College of Engineering & Management
05 / CONTACT
Let’s Build Something Useful
Open to conversations around analytics, business intelligence, data products, and AI-assisted decision systems.
Business problems → measurable analytics.
My strongest work sits where business context, reporting, data quality, automation, and decision support intersect.