Summary
Overview
Work History
Education
Skills
Timeline
Cashier

KETAN SHAH

Summary

Results-driven Data Scientist with expertise in analytics automation, data engineering, and AI-driven solutions to enhance decision-making and operational efficiency. 10 years of proven track record of building scalable dashboards, optimizing data pipelines, and deploying AI-powered tools that have saved millions in costs, improved product reliability, and accelerated business insights.

Overview

10
10
years of professional experience

Work History

Senior Data Scientist

Block
07.2023 - Current
  • Workflow Automation: Developed a Python-based ETL pipeline to automate data ingestion from 100+ vendor spreadsheets, eliminating 10+ manual hours/week of data processing.
  • Data Warehousing: Designed a data transformation process to normalize supplier pricing, quantity, and factory location across millions of rows in Snowflake, enabling faster querying and trend analysis.
  • Machine Learning: Built a Looker dashboard providing predictive forecasts and insights into supplier pricing trends, cost fluctuations, and negotiation leverage points, reducing time-to-analysis from 4 hours to under 5 minutes.
  • Efficiency: Implemented an event-driven automation mechanism that optimized Snowflake compute usage, reducing costs by $14K/month while improving infrastructure efficiency.
  • Optimization: Enabled faster, data-driven negotiations for the GSM team, improving supplier cost efficiency and increasing profit margins across 100+ suppliers.

Senior Product Analyst

Block
06.2022 - 06.2023
  • Dashboarding: Developed a Network Health Dashboard to monitor connectivity performance (RSSI, speed, WiFi disconnects, uptime) across sellers and identified 8K+ sellers with below-average network performance.
  • Problem Solving: Provided data insights to account managers, leading to the discovery that 60% of affected sellers were using low-quality local network setups causing system failures.
  • Teamwork: Implemented a scalable solution for improving reliability by partnering with Square’s business team to introduce a premium UniFi network kit to enhance seller connectivity.
  • Optimization: Launched a 50-seller pilot program, reducing seller-reported network complaints from 23% to 4% by optimizing network reliability enhancing seller experience and reducing churn.
  • Scalability: Scaled the network kit program company-wide, benefiting 15K+ sellers and strengthening Square’s infrastructure and POS system reliability.

Lead Data Analyst

Comcast
09.2017 - 06.2022
  • Automation: Built an automated data pipeline to integrate Flex order and activation data from multiple sources to provide a single source of truth for adoption tracking.
  • Collaboration: Partnered with the Orders team to analyze Flex sales, activation trends, and retention patterns and identified key adoption drivers and customer behavior insights.
  • Storytelling: Created real-time monitoring metrics to track device adoption and customer retention and provided executives with actionable insights for strategic decisions.
  • Strategy: Enabled quick turnaround on analytics and reporting for leadership which informed Comcast’s decision to eliminate the $5 Flex fee, reducing churn by 8% and increasing market share.

Education

Master of Science - Information Management

Syracuse University
Syracuse, NY
05.2015

Bachelor of Technology - Electronics Engineering

University of Pune
Pune, India
05.2013

Skills

  • Programming: Python (Pandas, NumPy, Scikit-learn, Matplotlib, Seaborn), ML Modeling, Automation, SQL, Databricks, Snowflake, Jupyter Notebook, A/B Testing, Airflow, Github
  • Analytics: Looker, Tableau, Power BI, IBM Cognos Report Studio, IBM Watson Analytics, Amplitude, Fivetran, Excel, Adobe Analytics

Timeline

Senior Data Scientist

Block
07.2023 - Current

Senior Product Analyst

Block
06.2022 - 06.2023

Lead Data Analyst

Comcast
09.2017 - 06.2022

Master of Science - Information Management

Syracuse University

Bachelor of Technology - Electronics Engineering

University of Pune
KETAN SHAH