Available for freelance & consulting

Senior Data Engineer & Analyst

I design pipelines, analytics systems, and dashboards that give supply chain teams the clarity to move faster. 7+ years across retail, pharma, and CPG.

Zion National Park
Zion, Utah
Ahmad Anis
Alaska
Alaska
Snowflake Power BI Python Azure Synapse SQL dbt MicroStrategy Supply Chain Analytics ETL Pipelines Medallion Architecture Anthropic API Neural Networks Snowflake Power BI Python Azure Synapse SQL dbt MicroStrategy Supply Chain Analytics ETL Pipelines Medallion Architecture Anthropic API Neural Networks
7+
Years experience
100M+
Records daily
20+
National parks
3.9
Graduate GPA
Capabilities

Built on a strong technical foundation

🗄️
Data Engineering
SnowflakeAzure SynapseETL/ELT dbtApache AirflowAWS Glue Medallion ArchitectureAzure Data Factory
📊
Business Intelligence
Power BIMicroStrategy TableauDAXLooker
🐍
Programming
PythonSQL (Advanced) PySparkPandasSQLAlchemy
☁️
Cloud & Infrastructure
AzureAWS CI/CDGit/GitHub
🔗
Supply Chain
SAP ERPS&OP Demand ForecastingKPI Development
🤖
AI / ML
NLPNeural Networks Anthropic APILLM Integration
Work

Things I've built and shipped

🌊
Data Engineering · Supply Chain
Ocean Inbound E2E Workflow Pipeline

Architected a production Snowflake SQL pipeline tracking ocean freight purchase orders from origin port through container loading, transit, customs clearance, and warehouse receipt. Multi-tier matching logic — exact PO, quantity-tolerance, FIFO, and unmatched flagging — across 100M+ daily records. Full medallion architecture from raw ingest to analytics-grade output.

PythonSQLSnowflake Azure SynapseMedallion Architecture
Bath & Body Works · Internal Pipeline
📧
Automation · Python
Stakeholder Email Automation

Python pipeline pulling live Snowflake data via ODBC, calculating weekly Delivery Agent projections, formatting Excel output, and sending templated emails to distribution lists — cutting a multi-hour manual process to minutes.

PythonSnowflake ODBCopenpyxlPandas
Bath & Body Works · Internal Tool
📦
Dashboard · Analytics
DC Work-in-Process Tracker

Real-time distribution center WIP dashboard consolidating carton tracking from 6 source systems into a unified Snowflake schema. Power BI gives planners live carton visibility from shipping through store delivery.

Power BISnowflakeDAXSQL
Bath & Body Works · Internal Dashboard
Side Projects

Built on my own time

🎙️
Voice Agent for Laundry Business

End-to-end voice AI agent handling customer calls — order intake, pricing inquiries, pickup scheduling. Fully autonomous, no human in the loop.

PythonVoice APILLM
🤖
LinkedIn AI Posting Agent

Automated content pipeline using Selenium and the Anthropic Claude API to draft, schedule, and publish thought leadership posts to LinkedIn.

PythonSeleniumClaude API
🔍
SQL Peer Review Tool

React + Claude API tool for automated SQL code review with context-aware feedback on patterns, anti-patterns, and optimization. Adopted by the BBW BI team.

ReactClaude APIJavaScript
Open Source

Tools I trust and use

great-expectations / great_expectations
Data validation and profiling — essential for pipeline data quality in Snowflake/ETL environments.
Python⭐ 10k+
🔧
dbt-labs / dbt-core
SQL-first transformation framework for modular, tested, documented Snowflake data models.
Python⭐ 10k+
🌬️
apache / airflow
Workflow orchestration for scheduling and monitoring end-to-end ETL pipelines and Snowflake jobs.
Python⭐ 38k+
sfu-db / connector-x
Fastest Python library for loading data from Snowflake and SQL databases into DataFrames.
Rust/Python⭐ 1.8k+
📈
mwaskom / seaborn
Statistical visualization for exploratory supply chain data analysis and KPI distribution plots.
Python⭐ 12k+
🗃️
simonw / sqlite-utils
CLI + Python library for rapid prototyping of data transformations before pushing pipelines to Snowflake.
Python⭐ 1.6k+
Career

Where I've done the work

2022 — Present
Bath & Body Works
Columbus, OH
Senior Data Analyst & Engineer · Supply Chain Planning & Analytics BI
  • Architected 6+ Power BI dashboards delivering real-time supply chain KPI visibility to 15+ cross-functional stakeholders, replacing 3 static weekly reports
  • Engineered E2E_KPI_TARGETED_OUTCOMES in Snowflake; resolved 4 critical fiscal calendar and fan-out bugs that had skewed metrics by 40%
  • Built ocean inbound pipeline processing 100M+ daily records with multi-tier PO-matching logic and medallion architecture
  • Automated PowerPoint logistics deck generation — from 10 hours to under 20 minutes per week via PptxGenJS
  • Developed React + Claude API SQL peer review tool adopted by the full BI team, reducing query error rates by ~70%
2019 — 2022
GlaxoSmithKline
Cleveland, OH
Supply Chain Planning Manager
  • Built statistical demand forecasting models reducing forecast error by 40% across 100k pharmaceutical SKUs
  • Automated inventory reporting with Python, eliminating 20 hours/week of manual data preparation
  • Designed relational SQL data models for pharmaceutical KPI tracking with SCD logic
  • Identified and led implementation of 70% lead time reduction opportunity via gap analysis
Life outside the terminal

I explore places,
not just datasets

When I'm not building pipelines, I'm planning the next National Park adventure with the two loves of my life. From the red canyon walls of Zion to glacier boats in Alaska to autumn in the White Mountains — the world is the other dataset I'm always analysing. Tennis on every continent is the long game.

20+
National Parks visited
Zion National Park
Zion · Utah
Alaska
Kenai Fjords · Alaska
White Mountains
White Mountains · NH
Ahmad and family
Ahmad's cat
White Mountains
About me

Not just a
data engineer

I'm Ahmad — a data engineer and analyst based in Columbus, OH. I build pipelines that turn messy supply chain data into something useful, and dashboards that make executives rethink what visibility actually looks like.

Outside of work, I'm an adventurer at heart. My wife and our cat are the two loves of my life — they've joined me across roughly 20 National Parks and counting. I'm also pursuing an M.S. in Artificial Intelligence because apparently I enjoy learning things the hard way.

Big board game fan. Exotic car enthusiast. Playing tennis on every continent is the long-term goal.

🐱White cat co-pilot on road trips
🎾Tennis on every continent
🏎️Exotic car enthusiast
🎲Board game collector
📚MSAI in progress
🌍Columbus, OH via Karachi 🇵🇰
Education

Always learning

🤖
M.S. Artificial Intelligence
In Progress · NLP, Neural Networks
Current
🎓
M.S. Information Systems
Cleveland State University · GPA 3.9
2023
⚙️
B.E. Industrial Engineering
NED University · Karachi, Pakistan
2017
Certifications
🏅 Microsoft Power BI PL-300
❄️ Snowflake SnowPro Core
📊 Google Data Analytics
🗄️ Advanced SQL for Data Engineers
🏗️ dbt Fundamentals
☁️ AWS Cloud Practitioner
🔷 Azure DP-900
Get in touch

Let's build
something together

Open to freelance projects in Power BI, Snowflake pipelines, supply chain analytics consulting, and AI-powered data tooling. Based in Columbus, OH — available remotely.