Prince Chhabra
Data Engineering
Delhi
Summary
As a seasoned senior data engineer with extensive experience in cloud environments such as Azure and AWS, I have a proven track record of designing, implementing, and optimizing data pipelines to extract, transform, and load large volumes of data. My expertise includes working with cutting-edge technologies such as Snowflake and Redshift, as well as programming languages like Python and SQL. I am proficient in building scalable and efficient data solutions using tools such as FastAPI, Terraform, Redis, Kafka, and Airflow. With a strong background in database management and visualization tools like SSMS and Power BI, I excel in translating complex business requirements into actionable insights, driving data-driven decision-making and delivering tangible business value.
Overview
7
7
years of professional experience
6
6
years of post-secondary education
8
8
Certifications
Work History
Senior Data Engineer, AI Product Development
Yum! Brands Inc.
08.2023 - Current
- Led the design and implementation of a parallel architecture system for efficient processing of data ingestion requests in a distributed environment and Integrated Elasticsearch for data ingestion, enabling seamless storage and retrieval of processed data for further analysis.
- Developed a scalable infrastructure using Kafka, Redis, and Terraform to handle concurrent requests and dynamically provision resources.
- Designed and implemented the API endpoints using FastAPI for receiving model definition requests, integrating with Kafka for asynchronous processing.
- Developed the backend logic for managing request statuses using Redis, enabling real-time monitoring and tracking of request progress.
- Implemented Terraform scripts to provision and manage independent worker machines on cloud infrastructure, ensuring scalability and fault tolerance.
- Successfully reduced request processing time by 50% by parallelizing workflow execution and optimizing resource allocation. Scaled the system to handle a 3x increase in request volume without degradation in performance, resulting in improved system reliability and user satisfaction.
- Led a data analytics project aimed at optimizing Pizza Hut Canada's menu by analyzing sales, revenue, and quantity data. Utilized Python for data preprocessing, Excel for in-depth analysis, and Power BI for visualization..
- Collaborated closely with stakeholders from marketing, operations, and finance departments to gather requirements and validate recommendations.
- Optimized menu offerings based on customer preferences, leading to a 20% reduction in menu complexity and improved customer satisfaction.
- Managed and created Azure Data Factory (ADF) pipelines to orchestrate data movement and transformation tasks between various data sources and destinations.
- Designed and implemented SQL database tables, views, and stored procedures based on the data modeling schema to support data analysis and reporting requirements.
- Developed interactive dashboards and reports in Power BI to visualize and communicate key insights derived from the data.
- Extracted, transformed, and loaded advertising data from Google Analytics, Facebook Graph API, BigQuery, and Google Ads using Python scripting and data manipulation libraries.
- Designed and implemented data storage architecture using Elasticsearch, ensuring efficient ingestion and retrieval of advertising data for analysis and optimization.
- Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
- Mentored junior team members in best practices for software development, code optimization, and troubleshooting techniques.
Senior Data Engineer
Kinesso(IPG MEDIABRANDS)
01.2022 - 07.2023
- Collaborated on development of ETL (Extract, Transform, Load) pipelines using using a variety of tools including Python,Amazon Redshift, Amazon S3, Snowflake, Postgre SQL
- Developed Views and Tables for Dashboards on both Redshift and Snowflake Datawarehouse using Postgre SQL and ANSI Standard SQL respectively, acting as a base for end user reporting.
- Designed and implemented effective data warehouse solutions and models for complex analysis needs.
- Maintaining data integrity and verifying pipeline stability to ensure timely completion and data availability in data warehouse for reporting, for over six fortune 500 clients, using SQL Server Management Studio.
- Conversion of altreyx flows to Snowflake Tables and Views.
- Migration of Data from Redshift to Snowflake Database to follow a standardized and homogenized solution, adopted company-wide
- Automated the QA process using python to ensure data integrity and reduced data discrepancy by a margin of 50% for around 6 clients(most of them fortune 500 clients)
- Developed complex client dashboard and reporting tools to monitor and track key performance indicators.
- Provided technical support for troubleshooting analytics and reporting issues.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Collaborated with stakeholders to identify business needs and data sources.
- Awarded twice with Data Champion of the Quarter.
Data Science Intern
ILFS Technologies
07.2017 - 08.2017
- Worked on data mining project namely text mining of legal data.
Successfully designed relation analyzer modules using Natural language processing. - Designed personal information extraction modules using data science libraries like pandas and numpy helping in data
extraction and data segregation. - Increasing efficiency and accuracy by enormous margin for large data set of 5000 files.
Education
B.Tech - Computer Science And Engineering
Maharaja Surajmal Institute Of Technology
New Delhi 08.2014 - 07.2018
Class 12 - Science
Salwan Public School
New Delhi 04.2013 - 05.2014
Class 10 -
Salwan Public School
New Delhi 04.2011 - 05.2012
Skills
Postgre SQL
Advanced SQL(Window function and portioning)
Python
Snowflake
Redshift
Amazon Web Services S3
Microsoft SQL Server Management Studio
Warehousing expertise
Power BI
Data analysis
Pandas and Numpy
Web Scraping
Data Engineering
ETL/ELT
Tableau
Apache Kafka
Redis
Terraform
Docker
Airflow
Power Query
Azure Data Factory (ADF)
Azure SQL Database
Azure Portal
Elasticsearch
BigQuery
Kibana
Git
Certification
•Data Analysis with Pandas and Python – Udemy
Timeline
Senior Data Engineer, AI Product Development
Yum! Brands Inc.
08.2023 - Current
Senior Data Engineer
Kinesso(IPG MEDIABRANDS)
01.2022 - 07.2023
Data Science Intern
ILFS Technologies
07.2017 - 08.2017
B.Tech - Computer Science And Engineering
Maharaja Surajmal Institute Of Technology
08.2014 - 07.2018
Class 12 - Science
Salwan Public School
04.2013 - 05.2014
Class 10 -
Salwan Public School
04.2011 - 05.2012
Similar Profiles
DEVANAND JEGARAJDEVANAND JEGARAJ
Sr. Manager, Site Reliability Engineering at Yum! Brands Inc.Sr. Manager, Site Reliability Engineering at Yum! Brands Inc.
Zavien HuddlestonZavien Huddleston
Tacobell at Yum! Brands Inc.Tacobell at Yum! Brands Inc.
Dillon MerrittDillon Merritt
Food Service Worker at Yum! Brands Inc.Food Service Worker at Yum! Brands Inc.
Tyson MeadTyson Mead
Delivery Logistics at Yum! Brands Inc.Delivery Logistics at Yum! Brands Inc.
Abhishek MishraAbhishek Mishra
Sr. Engineer (Electronics component Sourcing Import & Domestic) at Halonix Technologies Pvt Ltd.Sr. Engineer (Electronics component Sourcing Import & Domestic) at Halonix Technologies Pvt Ltd.