Open to opportunities

abhay pandey

@abhaypandey1

Message

Data Engineer and BI specialist building scalable pipelines and analytics platforms.

India

Message

What I'm looking for

I’m looking for data engineering roles where I can own end-to-end pipelines, optimize ETL/ELT, and build production-grade warehousing and transformation layers. I want to bring analytics insight to create reliable, self-service data products.

I’m a Data Engineer and BI Developer with 6+ years of experience building end-to-end data pipelines, warehousing solutions, and analytics platforms across logistics, fintech, and media. I’m hands-on with SQL, Python, BigQuery, Snowflake, AWS Glue, Azure Data Factory, and dbt, and I enjoy architecting data infrastructure from scratch.

In my recent roles, I’ve focused on production-grade ETL and trusted reporting. At DTDC Express, I designed enterprise Tableau dashboards with SQL, consolidated data from 10+ operational systems into a centralized reporting layer, and reduced leadership dashboard data latency by 40%—while automating recurring reports to eliminate 15+ hours/week of manual effort.

I’m also experienced in data transformation and analytics enablement for real stakeholders. From building churn and cohort analytics pipelines in BigQuery for Spartan Poker to delivering loan default risk analysis systems that improved underwriting accuracy, I consistently translate business needs into scalable data models, single-source-of-truth metrics, and self-service analytics that non-technical teams can use.

Experience

Work history, roles, and key accomplishments

Current

Business Intelligence Developer

Current

DTDC Express Pvt. Ltd.

Oct 2025 - Present (7 months)

Designed and developed enterprise Tableau and SQL dashboards for logistics operations, including shipment tracking and network performance monitoring. Built and optimized pipelines consolidating data from 10+ operational systems, reducing leadership dashboard data latency by 40%, and automated recurring reports to eliminate 15+ hours/week of manual work.

Tableau SQL DBT Google BigQuery AWS Glue ETL Data Modeling KPI Design

Tableau Developer / Data Engineer

Yesvini Technology

Dec 2024 - May 2025 (5 months)

Built end-to-end data pipelines (MySQL, SQL Server, BigQuery) to power near-real-time Tableau dashboards for ERP modules including inventory, billing, and CRM. Optimized SQL and extraction processes to reduce refresh times by 35% and increased adoption by 50% using Tableau parameters, calculated fields, and row-level security.

Tableau SQL Optimization MySQL SQL Server Google BigQuery Data Pipelines Tableau Security (RLS)Data Modeling Dashboarding

Senior Data Analyst

Quadrific Media Pvt. Ltd.

Feb 2023 - Oct 2024 (1 year 8 months)

Built the data and reporting infrastructure from scratch, establishing BigQuery ETL pipelines and end-to-end Tableau dashboards, reducing reporting time by 40%. Developed cohort and churn models in Python/SQL, contributing to a 20% increase in MAU and improving repeat transactions by 18% through targeted retention funnels.

BigQuery Tableau Python (Pandas)SQL Cohort Analysis Churn Modeling Retention Analytics Funnel Analysis Data Modeling

Senior Associate – Reporting & Data

Assimilate Solution Pvt. Ltd.

Jun 2020 - Aug 2022 (2 years 2 months)

Automated reporting pipelines using SQL and Excel macros for a large US mortgage portfolio, reducing manual reporting effort by 60% and eliminating data processing errors. Built a loan default risk analysis model with Python and SQL, reducing prediction errors by 25% and saving an estimated $200K in bad debt while generating monthly vendor performance and risk reports across $50M+ transactions.

SQL Excel Macros Tableau Matplotlib Python SQL Server Risk Modeling

Customer Success Engineer

Jindal Intellicom Pvt. Ltd.

Jun 2018 - Feb 2020 (1 year 8 months)

Managed data for Zomato’s global chat support process and produced weekly/monthly incident reports across India and MEA, resolving 95% of support tickets within SLA. Created operational decks and MIS reports for a team of 25 to track KPIs and support performance trends.

KPI Tracking Incident Reports Customer Support Operations Data Management

MIS Executive

St. Xavier's High School

Dec 2015 - Feb 2018 (2 years 2 months)

Built and maintained a student and faculty database of 1,200+ records and generated automated attendance, performance, and admissions reports for school leadership. Ensured consistent reporting outputs to support ongoing academic operations.

Attendance Reporting performance reporting Admissions Reporting Operational MIS