Prateek Kulshreshtha
Louisville,KY
Summary
Lead Data Engineering professional with 14+ years of experience designing, building, and scaling modern data platforms across Healthcare, FinTech, Consumer Products, and AdTech domains. Proven expertise in architecting cloud-native data solutions, implementing robust orchestration frameworks, and enabling analytics at scale using technologies such as Databricks, Snowflake, Airflow, DBT, and AWS.
Known for leading end-to-end data initiatives—from data modeling and warehouse design to automation, CI/CD, and production support—while driving measurable business outcomes including improved SLAs, reduced operational costs, and accelerated analytics delivery. Strong background in Business Intelligence, analytical problem-solving, and translating complex business requirements into reliable, high-performance data solutions.
A collaborative technical leader with experience managing distributed, hybrid teams across geographies, mentoring engineers, and establishing engineering standards and best practices. Adept at partnering with stakeholders to bridge business needs with technical execution, delivering scalable, maintainable, and high-impact data engineering solutions.
Overview
14
14
years of professional experience
6
6
Certifications
Work History
Senior Technical Lead - Data Engineering
Publicis Sapient
02.2022 - Current
- Led the design and delivery of scalable, cloud-native data platforms integrating multi-channel media, marketing, and fintech data to enable trusted, executive-level analytics and reporting.
- Architected and implemented robust ETL and data transformation pipelines using Databricks (Medallion architecture), Python, and SQL, ensuring analytics-ready, consistent, and high-quality datasets.
- Designed and automated end-to-end orchestration frameworks using Airflow, significantly reducing manual intervention and improving pipeline reliability and operational efficiency.
- Spearheaded the redesign of centralized DBT deployment frameworks on Snowflake, resolving long-standing deployment inconsistencies and reducing IT support overhead.
- Introduced improved DBT model design standards, error logging, and version upgrade processes, strengthening governance, observability, and release stability across the data platform.
- Led adoption and integration of Starburst and Trino within the DBT ecosystem, and delivered proof-of-concept initiatives including centralized Hive Metastore and Iceberg support exploration to influence platform roadmap decisions.
- Drove strong data quality, validation, and monitoring practices, ensuring accurate KPI definitions and trusted datasets for downstream analytics and business stakeholders.
- Partnered closely with fintech clients’ centralized analytics teams to standardize KPI definitions and semantic models using AtScale and Alation, enabling scalable self-service analytics and consistent executive dashboards in Tableau.
- Acted as the primary technical liaison between business stakeholders, analytics teams, and engineering teams—translating complex business requirements into reliable, high-performance data solutions.
- Led and mentored distributed teams across the US and India, coordinating delivery, conducting design and code reviews, grooming new engineers, and delivering cost-effective initiatives that reduced operational expenses and improved SLA performance.
Senior Development Lead (Assistant Consultant)
Tata Consultancy Services (Client : HUMANA INC.)
01.2018 - 02.2022
- Partnered with internal stakeholders and external vendors to design and deliver ETL solutions, leading the migration from legacy processes to cloud-based ETL using SnapLogic, accelerating project delivery timelines by ~40%.
- Conceptualized and implemented an automated test data refresh framework, eliminating manual processes and generating $1M+ in direct cost savings for the organization.
- Led the delivery of multiple end-to-end data initiatives with complex business requirements, including Power BI dashboards, ensuring accurate reporting and strong alignment with stakeholder expectations.
- Applied advanced T-SQL and PL/SQL expertise to analyze large, heterogeneous datasets, enabling data-driven decision-making and uncovering actionable business insights.
- Managed and mentored a cross-functional delivery team of 7 full-time engineers and 2 contractors, overseeing planning, execution, quality reviews, and timely delivery across parallel workstreams.
Senior Application Developer (I.T Analyst)
Tata Consultancy Services (Client : HUMANA INC.)
05.2015 - 12.2017
- Delivered complex, business-critical requirements with a strong focus on troubleshooting, system stability, and end-to-end ownership of data deliverables.
- Designed and implemented a comprehensive data solution for Humana’s Finance team, leveraging .NET, SQL Server, SSIS, and SSRS to support financial reporting and operational analytics.
- Collaborated closely with project managers and cross-functional teams to define database development scope, align on timelines, and ensure predictable, on-time delivery.
- Developed complex SQL queries and data extracts to provide on-demand insights and ad-hoc analysis for business users and leadership teams.
- Built and maintained .NET (C#) web services to expose data securely to multiple downstream applications, enabling system integration and reuse of core data assets.
Application Developer (Systems Engineer)
Tata Consultancy Services (Client : HUMANA INC.)
01.2012 - 05.2015
- Collaborated with software development and QA teams to design and deliver scalable, high-performance solutions aligned with client functional and non-functional requirements.
- Developed web-based business applications using .NET, HTML, CSS, and AJAX, supporting core business workflows and data-driven functionality.
- Designed and implemented SSIS-based batch processing pipelines to integrate data across backend systems, improving data availability and consistency.
- Built SSRS reports based on detailed business requirements, enabling standardized operational and management reporting.
Education
Post Graduate Program (PGP) - Artificial Intelligence And Deep Learning
University of Texas At Austin
Austin, TX11.2022
Post Graduate Program (PGP) - Data Science And Business Analytics
University of Texas At Austin
Austin, TX01.2022
Bachelor of Technology - Computer Engineering
Rajasthan Technical University
Kota, India07.2011
Skills
- Data Analytics
- Python
- DBT
- SQL/Oracle
- Snowflake
- Airflow
- Advanced SQL Query Optimization
- AWS/GCP/Azure
- Docker
- Data Architecture and Governance
- ETL Technologies (Snaplogic, SSIS)
- Power BI, Tableau, Machine Learning
- GitHub Actions
- SparkSQL (PySpark)
- Data Pipeline Management (Airflow)
- Application Development and Automation
Certification
- SnowPro Advanced: Data Engineer Certification - 2025
- SnowPro Core Certification - 2022
- Databricks Certified Associate Developer for Apache Spark 3.0 - 2021
- Snaplogic Certified Enterprise Automation Professional - 2021
- Certified Azure Data Engineer (DP-200 & DP-201), Microsoft - 2021
- Azure Fundamentals, Microsoft - 2020
- Lean Six Sigma – Green Belt Training - 2013
Recognitions
Star of the Month - Humana (Pharmacy) , March 2021
PS Core Value Awards 2023 Winner - Learning Mindset
Timeline
Senior Technical Lead - Data Engineering
Publicis Sapient
02.2022 - Current
Senior Development Lead (Assistant Consultant)
Tata Consultancy Services (Client : HUMANA INC.)
01.2018 - 02.2022
Senior Application Developer (I.T Analyst)
Tata Consultancy Services (Client : HUMANA INC.)
05.2015 - 12.2017
Application Developer (Systems Engineer)
Tata Consultancy Services (Client : HUMANA INC.)
01.2012 - 05.2015
Post Graduate Program (PGP) - Artificial Intelligence And Deep Learning
University of Texas At Austin
Post Graduate Program (PGP) - Data Science And Business Analytics
University of Texas At Austin
Bachelor of Technology - Computer Engineering
Rajasthan Technical University