Summary
Overview
Work History
Education
Skills
Certification
Internships
Certifications
Timeline
Generic

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, USA
01.2024

Master of Science, (M.S.) - Industrial & Systems, Data Science

University at Buffalo (SUNY)
New York, USA
02.2019

Bachelor of Science, (B.S.) - Mechanical Engineering, Data Analytics

Gujarat Technological University
Vadodara, India
05.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
Shrikant Pachpande