Shantanu Pingale

Experience

• 

  Pimlico Cafe

  Jan 2020 - Dec 2021

  Business Intelligence Analyst

  • Boosted monthly revenue by $10,000 by leveraging SQL, AWS (Lambda, S3, Athena, Glue), and Power BI to develop performance reports and identify critical KPIs, ensuring real-time sales insights.• Achieved 25% cost optimization by integrating Python-based EDA (Matplotlib) and Alteryx workflows, uncovering unsold items in the supply chain and minimizing inventory waste.• Reduced customer wait times by 30% during peak hours through a Python SARIMA predictive analytics model, enabling data-driven staffing decisions and elevating overall customer satisfaction.• Increased marketing campaign ROI by 18% by crafting SQL-driven BI dashboards to assess the effectiveness of special offers, translating data insights into actionable strategies for leadership. Show less

• 

  Seagate Technology

  Jan 2022 - Jul 2022

  Data Quality Analyst

  • Increased overall data accuracy by 25% by implementing rigorous data analysis, quality checks, and data cleaning (SQL, Excel, Python), ensuring consistent and reliable storage product information.• Reduced response times by 20% and enhanced data process flow efficiency by 30% through root cause analysis of storage data requests and automation of data validation pipelines using Python (NumPy, Pandas).• Elevated data governance standards by partnering with business units, firmware teams, and SI teams to define and enforce policies, safeguarding data security, integrity, and quality across all organizational systems. Show less

• 

  Northeastern University

  May 2023 - now

  • Decreased query execution time by 90% (from 1 minute to 2 seconds) by implementing advanced Snowflake modeling, including recursive CTEs and optimized data models.• Applied SARIMA models in Python on Snowflake to improve monthly budget forecasts by 40%, ensuring more precise resource allocation.• Deployed 30+ interactive Tableau dashboards to oversee $1.13B in capital projects, enabling real-time cost vs. budgets vs. actuals tracking for enhanced Financial Planning & Analysis (FP&A)• Established quality checks and anomaly detection to enhance data reliability by 40%, significantly increasing confidence in operational metrics. Show less • Architected ETL pipelines in Alteryx to unify over 1M work requests from 275 buildings, boosting end-to-end data quality and reliability.• Leveraged predictive analytics and regression models to identify anomalies across multiple regional sites, reducing operating costs by 15%.• Streamlined facility management insights by cutting manual reporting time 30% and expediting data-driven decision-making for building and maintenance teams.• Migrated over 1 million rows from MS SQL Server to Snowflake via Python-based pipelines, enabling near real-time analytics and minimizing data latency.• Led monthly strategy sessions with stakeholders to integrate project data, ensuring unified reporting across 18 diverse campus sites.• Analyzed Excel-based energy metrics to uncover consumption trends, guiding policies that lowered overall building energy usage. Show less

  • Data Analytics Engineer

    Sept 2024 - now

  • Data Analyst

    May 2023 - Aug 2024