Rahul Chavan
👋 Open to new opportunities

Hi, I'm Rahul Chavan

|

Senior BI & Data Engineer with 8+ years across Amazon, Avnet & Cepheid — delivering scalable data pipelines, ML-powered analytics, and automation tools that generated $850M+ in documented business value.

View My Work Get In Touch
Scroll
// about me

Who I Am

I'm a Senior BI & Data Engineer with 8+ years of experience across Amazon, Avnet, and Cepheid — delivering scalable data pipelines, ML-powered analytics, and automation tools that have generated over $850M+ in documented business value.

I specialize in AWS (Redshift, S3, QuickSight, Bedrock), Python, SQL, Tableau, Power BI, and RPA (UI-Path). I thrive at the intersection of engineering and business strategy — building enterprise-grade reporting infrastructure that translates complex datasets into decisions that move the needle.

Currently based in the United States, open to senior data engineering, BI, and analytics leadership roles.

Download Resume →
8+ Years Experience
$850M+ Business Value
35 FTE Saved via Automation
4 Companies

Languages

PythonSQLVBA MacrosJavaBash

Cloud & Platforms

AWS RedshiftS3LambdaGlueBedrockAzureDatabricksSnowflake

ML & Analytics

Machine LearningXGBoostARIMAStatistical ModelingFeature Engineering

Visualization & BI

TableauPower BIQuickSightMatplotlibSeaborn

Data Engineering

ETL/ELT PipelinesSSISData WarehousingData ModelingREST API

Automation & RPA

UI-PathSAP GUI ScriptingPython AutomationCI/CD
// experience

Where I've Worked

Senior Business Intelligence Engineer

Amazon · Phoenix, AZ
Apr 2022 — Ongoing
  • Applied AI-powered analytics and ML models to detect counterfeit activity, identify brand abuse patterns, and quantify Amazon's value to brands across worldwide marketplaces.
  • Leveraged AWS tools (Redshift, S3, Amazon-Q, QuickSight, Bedrock) for data warehousing and large-scale dataset processing through Andes (Amazon Data Lake).
  • Built SQL-based back-end databases and company-wide reporting dashboards in QuickSight that directly influenced leadership decisions.
  • Designed database architecture, performed data mining, statistical modeling, and ETL automation to process multi-terabyte datasets.
  • Built profitability analysis framework for the Transparency program — collaborating with Finance, Operations, and Sales to measure FC Cost, Promotions, Revenue, and write-offs.
AWS RedshiftQuickSightBedrockPythonSQLETLML

Senior Automation Developer

Avnet · Phoenix, AZ
Mar 2020 — Apr 2022
  • Built RPA robots using UI-Path to automate Supply Chain processes — saving 35 FTE and generating $100M/year in cost savings.
  • Created and maintained company-wide SQL Server database with stored procedures, SSIS jobs, and SAP database integration via daily automated merge scripts.
  • Developed Power BI reports to track NMI, Logistics, Finance, Inventory, and Safety Stock KPIs across the enterprise.
  • Built interactive front-end web applications using HTML, CSS, PHP, and Python-Django for real-time order tracking.
UI-PathPower BISQL ServerSSISPythonDjango

Supply Chain Big Data Analyst

Cepheid · San Jose, CA
May 2019 — Feb 2020
  • Developed end-to-end ML forecasting pipeline (Python, SQL, XGBoost, ARIMA) reducing SAP MRP inventory inaccuracy by 25%.
  • Built dashboards in Tableau, Power BI, and Klipfolio to track Supply Chain KPIs and give leadership real-time procurement visibility.
  • Automated BI reporting via SAP GUI scripting using VBA macros, eliminating ~2 FTE in manual reporting overhead.
  • Led company-wide President's Kaizen initiative using DMAIC and data-driven Lean methodology.
PythonXGBoostARIMATableauPower BISAP

Data Engineer

GEP Worldwide · India
Sep 2016 — Aug 2017
  • Developed VBA macros to automate reporting and data analysis, saving approximately 800 hours/month in manual effort.
  • Performed procurement data analysis to identify supplier performance, pricing, payment terms, and spend; developed KPIs to track supplier performance and OTD.
VBASQLData AnalysisKPI Development
// projects

Things I've Built

Featured
🛡

Profitability Analysis — Amazon Counterfeit Program

Collaborated with Finance, Operations, and Sales to build KPIs measuring brand profitability across FC Cost, Promotions, Revenue, and write-offs. Directly influenced brand onboarding and offboarding decisions at scale.

Jan 2025 — Mar 2025
AWS RedshiftQuickSightPythonSQLETL
Featured
📈

Time Series Forecasting Tool — Python & ML

Built end-to-end ML forecasting pipeline using NumPy, Scikit-learn, XGBoost, and ARIMA to predict demand, Safety Stock, MOQ, and DU for high-demand materials. Designed companion dashboards in Python, SQL, Power BI, and Tableau.

Mar 2019 — Apr 2019
PythonXGBoostARIMAScikit-learnTableauPower BI
🤖

RPA Supply Chain Automation

Built UI-Path RPA robots to fully automate Avnet's Supply Chain business processes — delivering 35 FTE in savings and $100M/year in documented cost reductions. Backed by SQL Server and SSIS pipelines with daily automated SAP sync.

UI-PathSQL ServerSSISSAPPython
📊

Enterprise BI Reporting Suite

Designed and deployed company-wide reporting dashboards tracking NMI, Logistics, Finance, Inventory, and Safety Stock KPIs. Built on Power BI, QuickSight, and Tableau — providing real-time visibility to executive leadership.

Power BIQuickSightTableauSQLKlipfolio
// writing

From the Blog

Data Engineering Coming Soon

Building Multi-Terabyte ETL Pipelines on AWS Redshift

Lessons learned architecting ETL pipelines that process multi-terabyte datasets daily — the patterns, pitfalls, and performance wins from production at Amazon.

Notify me →
ML & Forecasting Coming Soon

ARIMA vs XGBoost for Supply Chain Demand Forecasting

A practical comparison of time series methods after deploying both in production. When classical statistics beats ML, and when it doesn't.

Notify me →
Automation Coming Soon

How We Saved 35 FTE with UI-Path RPA at Avnet

The full story of designing, building, and deploying an enterprise RPA program — from business case to $100M/year in savings.

Notify me →
Get Notified When I Post →
// documents

Download My Documents

📄

Resume

Senior BI & Data Engineer — 8+ years of experience across Amazon, Avnet, Cepheid, and GEP Worldwide. Skills in AWS, Python, SQL, ML, Tableau, and RPA.

PDF · Updated June 2026
Download Resume
✉

Cover Letter

A tailored cover letter highlighting my expertise in data engineering, BI development, and delivering measurable business impact at enterprise scale.

PDF · Available on request
Request Cover Letter
// contact

Let's Work Together

Whether you have a data engineering role, an analytics challenge, or just want to talk shop about ML and BI — my inbox is always open.

✉
📞
Phone
585-503-1996
💼
📍
Location
United States · Open to Remote & Hybrid