top of page
Swapnil Herwadkar
Results-driven Business Analyst with 3+ years of experience in process optimization, stakeholder management, and data driven decision-making. Led workflow automation and KPI strategies, achieving $10M+ in savings while improving efficiency and scalability. Proficient in SQL, Power BI, and dashboard development to drive transparency and decision-making. Recognized for timely milestone delivery, ensuring planning and quality execution.
RESUME
WORK EXPERIENCE
Business Analyst (Process Optimization)
Community Dreams Foundation
Sebring, Florida, USA
Developed a SQL framework to enhance mentor matching, increasing engagement by 30%. Designed AI-driven process optimizations to automate reporting workflows, integrate real-time sustainability KPIs, and improve KPI-based decision-making by 25%. Optimized SQL queries using indexing and partitioning while enhancing Tableau dashboards with dynamic filtering, reducing load times and improving real-time data insights. Built SQL-based ETL pipelines to eliminate data inconsistencies, ensuring 100% reporting accuracy and enabling reliable, data-driven decision-making.
2024 - Now
Business Analyst II (Business Intelligence)
Accenture
Pune, India
Designed and deployed KPI-driven dashboards in SQL and Power BI for Weekly Status Reports (WSR), enhancing executive transparency and accelerating decision-making by 20%. Redesigned business workflows by integrating automated validation rules and scheduled reporting, reducing manual dependencies by 60% and enabling faster, data-driven decisions for key stakeholders. Led requirement elicitation workshops to resolve reporting challenges, translating stakeholder needs into structured requirements and leveraging Causal Analysis and Resolution (CAR) to improve reporting accuracy by 40%. Additionally, developed Functional Requirement Documents (FRD) and Business Requirement Documents (BRD) to bridge stakeholder expectations with technical implementation, minimizing misalignment issues and ensuring smoother project execution.
Business Analyst I (Data Analytics)
Accenture
Pune, India
Optimized SQL query performance by implementing indexing and query tuning, reducing data discrepancies by 20% in high-volume datasets. Integrated five data sources from SAP-based systems, including Global Trade System (GTS) and Business Warehouse, streamlining data transformation and improving workflow efficiency by 35% for more accurate analytics. Led cross-functional teams in User Acceptance Testing (UAT) and product roadmap development, minimizing post-launch issues in HyperCare by 25% and accelerating decision-making efficiency by 30%. Additionally, mapped existing workflows to identify bottlenecks in reporting and approval processes, implementing optimizations that cut turnaround times by 20% and strengthened cross-functional. collaboration.
2022 - 2023
2021 - 2022
EDUCATION
Master of Science in Business Analytics
University of Massachusetts Amherst
Amherst, MA
GPA - 3.95
2023 - 2024
Bachelor of Engineering in Electronics
RCOEM, RTM Nagpur University
Nagpur, Maharashtra, India.
GPA - 3.34
2016 - 2020
SKILLS & EXPERTISE
Data Analysis & Visualization
Tableau
Power BI
Microsoft Excel (Pivot Tables, VBA)
SQL
MySQL
Python (Pandas, Scikit, NumPy) for Data Cleaning & Automation
Data Modeling
Data Warehousing
SAP HANA
​
Project Management & Methodologies
Agile (Scrum, Kanban)
Lean
Process Improvement
UAT (User Acceptance Testing)
Business Process Automation
Traceability Matrices
Causal Analysis & Reporting (CAR)
Business Analysis & Strategy
Stakeholder Management
Requirements Gathering
Functional & Requirements (FRD, BRD)
Business Process Reengineering
Business Process Modeling (BPMN, Visio)
Use Case Development
KPI Definition
Gap Analysis
Root Cause Analysis
Change Management
​
Tools & Technologies
SAP ERP
JIRA
Confluence
Microsoft Visio
Data Pipelines
Data Mapping
​
CONTACT
CONTACT
Phone
413-479-9181
Hi, I am Swapnil,
I am an aspiring Data and Business Analyst with a Master’s in Business Analytics from UMass Amherst. I specialize in optimizing business processes and delivering actionable insights that drive efficiency and growth. Outside of work, I enjoy photography, cooking, graphic designing, and listening to music, thus adding creativity in my life.
bottom of page