Shrikant Pachpande
Alpharetta,GA
Summary
7+ years of experience in Business Intelligence, Data Management & Analytics, developing dashboards in Power BI & Tableau. Expert in SQL & DAX queries. Leveraged Business Intelligence (BI) tools to enhance operational efficiency and productivity, yielding exemplary outcomes.
Visa Sponsorship Not Required
Overview
10
10
years of professional experience
1
1
Certification
Work History
Sr. Business Intelligence Analyst
Tosca Global
05.2024 - Current
- Optimized KPI reporting by converting PBIX native queries into Snowflake views, significantly improving datasetrefresh speed and cost savings for Tosca IT.
- Developed a predictive forecasting data model to improve inbound product planning, identify supply-chain inconsistencies, and increase customer experience (Walmart, Kroger) scores by 15%.
- Streamlined data pipelines into Snowflake/Redshift using Hevo and Fivetran, delivering faster access to trusted data for business-critical dashboards, enabling centralized, governed analytics across multiple business systems.
- Delivered scalable, SQL-driven reporting that transformed raw data into trusted insights for leadership, while simplifying data models and centralizing certified data sources for Power BI.
- Converted 50+ manual reports to Power BI reports, improving business efficiency by 20% in 2 year by collaborating with Business Analysts from various Departments.
- Migrated production data using 3PL API to SSMS/Snowflake and then created reporting for Operations, increasing the productivity (OEE) by 25%
Sr. Business Intelligence Engineer
Tegra LLC Client: - Nike, Inc
07.2019 - 05.2024
- Addressed time-sensitive business inquiries by performing ad hoc analyses, delivering timely insights to enhance decision-making, and increasing revenue by $250,000 per year.
- Achieved full automation by utilizing Power Apps and Power automate, resulting in enhanced customer service experience and estimated savings of $300,000 per year.
- Worked cross-functionally with HR, IT, QA, Finance, Supply Chain, identifying variations and anomalies in datasets, utilizing Power BI/Tableau, increasing revenue by $1.1M.
- Accomplished Row-level security restricting access to sensitive data, reducing breach risk, bolstering overall data confidentiality.
Business Intelligence Engineer
Serta Simmons
03.2019 - 05.2024
- Designed and developed visualizations, dashboards in Tableau, improving operational efficiency by 35%
- Identifying trends, anomalies, and patterns in large datasets from ERP for scheduling, saving over $500K per year
- Utilized SQL, Power BI, and Python for statistical analysis, predictive modeling, and data visualization.
- Collaborated with all levels of organization to identify KPI and develop dashboards for accurate decision-making.
Data Visualization and Analysis Intern
Zimmer Biomet Health
08.2018 - 12.2018
- Used SAP maintaining data and used a maintenance module to analyze data pertinent to equipment life cycle.
- Examined historical data of 20 years on medical device failure claims using SQL, delivering detailed finding.
Quality Data Analyst Intern
Wells Concrete
05.2018 - 08.2018
- Developed reports and dashboards using R, Power BI, SQL, and Excel, providing insights to the team on KPI.
- Performed labor cost analysis and reduced labor overtime by 80%, resulting in cost reduction of $50,000 per month.
- Work in cross-functional teams to determine monthly goals and develop a dashboard for tracking daily progress.
Data Analyst
L&T Corporation
05.2016 - 08.2017
- Designed and developed interactive dashboards and reports using SQL and Excel to present insights and KPI.
- Resolved 100 = Excel technical issues, enhancing user proficiency by conducting 30 training sessions for end-users.
- Analyzed data for vendors’ supply spare parts using Excel pivot table and power pivot to create visuals and user stories.
Education
Master's in Business Administration (MBA) - Business Intelligence, Data Analytics
University of the Cumberland's
Kentucky, USA01.2024
Master of Science, (M.S.) - Industrial & Systems, Data Science
University at Buffalo (SUNY)
New York, USA02.2019
Bachelor of Science, (B.S.) - Mechanical Engineering, Data Analytics
Gujarat Technological University
Vadodara, India05.2017
Skills
- Strategic opportunity mindset
- Complex problem solving
- Cross-functional collaboration
- Clear professional communication
- Technology market expertise
- Mentoring and team building
- Strong time management
- Independent and team contributor
- Multitasking under deadlines
- Continuous improvement mindset
- Confidential data integrity
Certification
- SQL (Snowflake SQL)
- Snowflake
- ETL Development
- Data Engineering
- Power BI
- DAX
- FiveTran Pipelines
- Hevo Data
- ERP Data Integration
- Amazon Redshift
- Tableau
- SSRS
- SSIS
- Python
- Microsoft Azure
- Metaplane
- Visual Studio
- SAP
- SSMS
- MySQL
- DBeaver
- Advanced Excel
- Pivot Tables
- Microsoft Office
- VBA
- Power Automate
- Power Apps
Internships
Data Visualization & Analysis Intern - Zimmer Biomet Health
08/2018 – 12/2018 | Parsippany, NJ
- Analyzed equipment lifecycle data using SAP maintenance modules and SQL to assess reliability trends.
- Evaluated 20 years of medical device failure claims, delivering actionable insights to engineering and quality teams.
Business Intelligence Intern -Wells Concrete
05/2018 – 08/2018 | Wells, MN
- Built Power BI dashboards and SQL reports to track business KPIs.
- Performed cost analysis that reduced operators overtime by 80%.
Certifications
1. Power BI: Integrating AI and Machine Learning LinkedIn
2. Machine Learning with Python: Foundations LinkedIn
3. Six Sigma Green Belt SSGI
4. Project Management University of California, Irvine
5. Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics LinkedIn
6. MS Excel VBA Programming Udemy
7. SQL Tips and Trick's for Data Science LinkedIn
Timeline
Sr. Business Intelligence Analyst
Tosca Global
05.2024 - Current
Sr. Business Intelligence Engineer
Tegra LLC Client: - Nike, Inc
07.2019 - 05.2024
Business Intelligence Engineer
Serta Simmons
03.2019 - 05.2024
Data Visualization and Analysis Intern
Zimmer Biomet Health
08.2018 - 12.2018
Quality Data Analyst Intern
Wells Concrete
05.2018 - 08.2018
Data Analyst
L&T Corporation
05.2016 - 08.2017
Master of Science, (M.S.) - Industrial & Systems, Data Science
University at Buffalo (SUNY)
Bachelor of Science, (B.S.) - Mechanical Engineering, Data Analytics
Gujarat Technological University
Master's in Business Administration (MBA) - Business Intelligence, Data Analytics
University of the Cumberland's