Dheeraj Vempaty - Senior Data Engineer

About Me

I’m a data-driven problem solver who thrives on transforming complex business challenges into scalable, efficient, and insightful data solutions. With over a decade of hands-on experience, I’ve architected end-to-end pipelines, developed LLM-powered BI tools, and championed real-time analytics platforms at enterprise scale. I bring both technical depth and a passion for enabling strategic decisions through reliable and innovative data platforms.

Technical Skills & Tools

Cloud: GCP (BigQuery, Looker, DataProc)

ETL: Informatica, SQL, Python, Dell Boomi

BI Tools: Looker, Tableau, SAC

Languages: SQL, Python, Shell

Versioning: GitHub, Autosys, Airflow

Certifications: GCP Data Engineer, Architect

Professional Summary

Senior Data Engineer with 12+ years of experience delivering enterprise-scale data solutions across Finance, HR, and Compliance domains. Specialized in scalable pipelines, GCP platforms, and BI automation using Looker & Tableau. Delivered $20M+ cost savings, pioneered LLM-based analytics tools, and enabled data-driven decisions globally.

Professional Experience

PayPal Inc. – Chennai
Senior Data Engineer | Jan 2020 – Present

Market Insights Tool: Self-service Looker dashboards for global financial analytics (~80TB daily refresh).
LLM-Powered Finance Assistant: Internal AI bot using OpenAI models, integrated with Looker Extensions, saved 3+ hours/analyst/week.
Learning DataMart: Unified L&D analytics via Airflow and vendor APIs (Udemy, LinkedIn, O'Reilly).
Real Estate DataMart: Enabled hybrid workspace planning, saving ~$20M in vendor costs.
People DataWarehouse: Central source for HR metrics, enhanced hybrid classification and analytics.
Tax DataMart: Migrated 15TB+ legacy data to GCP, automated 1099K, CP2100 processing across platforms.

Cognizant | The Hartford Financial Services
Data Engineer | Nov 2013 – Jan 2020

Developed full-stack enterprise DWH from ingestion to reporting layers with Oracle/MySQL.
Designed dimensional models (SCD Type 1/2, fact tables, star schemas).
Created chatbots for insurance workflows using Azure bots.
Built Tableau dashboards and optimized batch pipelines (Autosys, Informatica).
Improved job SLAs with error recovery, reusable data frameworks, and runtime tuning.

Education

Sathyabama University, Chennai: B.E in Electronics & Instrumentation (75%)
Sri Vivekananda Jr College, Vijayawada: Intermediate (87%)
City Central High School, Kodad: SSC (90%)