Pratik Lakhpatwala

About Pratik Lakhpatwala

With 16+ years of experience in database and data warehousing across diverse platforms, I’m a results-driven professional passionate about delivering customer-focused solutions. As a Senior Engineer and EDW Architect at Comcast, I specialize in data architecture, performance tuning, and business solution development.I’ve led numerous successful projects involving data and platform migrations, EDW implementations, and advanced analytics. My hands-on expertise spans technologies like Teradata, Snowflake, BigQuery, Vertica, and Oracle. Certified in Snowflake, Vertica, Teradata, and Oracle, I’m committed to continuous learning and delivering innovative, high-impact solutions.

Experience

1. Sr Engineer Edw Architect

   Comcast

   Jul 2023 — Present · West Chester, PA, US

   Led the maintenance and management of Comcast’s largest Enterprise Data Warehouse (EDW) system, overseeing both onsite and offshore database management teams.• Conducted weekly check-in meetings with business stakeholders to design and implement business models within the EDW environment.• Performed in-depth troubleshooting of ETL processes, resolving data quality and performance issues efficiently.• Analyzed existing data infrastructure, identified gaps, and developed integration strategies to align current systems with future-state architecture.• Designed and supported EDW initiatives, including metadata modeling and architecture for various Extract, Transform, Load (ETL) processes.• Collaborated with project managers to define project scope, develop statements of work, create project plans, and conduct risk assessments.• Served as a Teradata Subject Matter Expert (SME), delivering internal training sessions to upskill teams and promote best practices.• Conducted proof-of-concept (POC) evaluations on various data warehousing platforms to assess capabilities and recommend optimal solutions.

Education

• Boston University Metropolitan College

  Master's degree, Applied Business Analytics

  2019

• SIES College of Commerce and Economics

  Bachelor’s Degree, Information Technology

  2009

• Shah & Anchor Kutchhi Polytechnic

  Diploma in IT, Information Technology

  2007

Skills

• Extract, Transform, Load (Etl)
• Aix
• Data Warehousing
• Databases
• Teradata
• Oracle Rac
• Rman
• Oracle 9i
• Query Tuning
• Informatica
• Unix Shell Scripting
• Ibm Db2
• Toad
• Pl/Sql
• Data Guard
• Sql Tuning
• Data Integration
• Datastage
• Windows
• Db2
• Oracle
• Requirements Analysis
• Operating Systems
• Database Design
• Performance Tuning
• Database Layer
• Sql
• Linux
• Shell Scripting
• Sap Businessobjects
• Erwin
• Unix
• Data Modeling
• Oracle Applications
• Oracle Database
• Solaris
• Database Administration
• Data Migration
• Etl
• Business Objects