Tejaskumar Patel

Senior Data Engineer @ adMarketplace

About

As a Senior Lead Data Engineer, I leverage my 13+ years of IT experience to design, develop, and optimize data solutions for various domains, such as finance, banking, retail, energy, and health care. I have a strong background in BI platforms, database development, data modeling, and data warehousing, as well as proficiency in C#, VB.net, Python and Google Cloud(GCP). I have successfully implemented ELT using Airflow/Cloud Composer, data streaming using Pub/Sub, DataFlow, and BigQuery, and data warehouse design and development using BigQuery in GCP. I have also worked with complex nested and repeated data structures, SQL performance tuning, backup and recovery processes, and dimensional modeling. I enjoy working with a team of passionate and innovative data professionals, and I am always eager to learn new skills and technologies.

Country

United States

City

New York City Metropolitan Area

Industry

Marketing & Advertising

Skill

Jenkins, Bitbucket, Apache Kafka, Aws Databricks, Argoworkflow, Amazon Simple Notification Service (SNS), Amazon Athena, AWS Lambda, Amazon Relational Database Service (RDS), Amazon Web Services (AWS), VB.net, SSRS, Google Cloud Dataflow, Cloud Function, Microsoft SQL Server, SSIS, Sqoop, Ozzie, Airflow/Cloud Composer GCP, Transact-SQL (T-SQL)

Experience

Senior Data Engineer

adMarketplace

2024-11 - Present · 1 yr 11 mos

New York, New York, United States

Senior Lead Data Engineer

Publishers Clearing House

2015-2 - 2024-11 · 9 yrs 10 mos

Jericho, New York, United States

Architecting scalable data solutions, providing technical leadership to a team of engineers, ensuring data quality and governance, collaborating closely with stakeholders to deliver insights, and driving continuous improvement in data engineering processes and tools. Oversaw Implementation of GCP data-lake.

SQL Server Database Developer

Enterprise Products

2014-7 - 2015-2 · 8 mos

Houston, Texas, United States

Designed and implemented Accounting/invoice/logistic database solutions for ERP system for Oil industry. Automated and replaced 100’s of Excel based processes using SSIS and created various SSRS reports for business. This project save over 100M $

SQL Server Database Developer

United Airlines

2012-3 - 2014-6 · 2 yrs 4 mos

Houston, Texas, United States

Designed and implemented and supported databases for various applications like maintenance, booking and fleet Management. Oversaw the Data Migration and merge of different applications. Migrated DTS Packages to SSIS with tuning. Tuned SQL Queries, SSIS Packages and SSRS Reports. Managed database maintenance and permissions for various users. This Integrations helped the United Airline and Continental airline to manage the business without affecting any Operations.

SQL Server Database Developer

Charles Schwab

2011-9 - 2012-2 · 6 mos

Chicago, Illinois, United States

Integrated Stock history data from vendor. Created ETL to process GBs of Stock data daily. Analyzed and Processed data Required for Analytics and provided different matrix/stats. Created Dashboard reports for Executives.

SQL Database Developer

Cardinal Health

2011-3 - 2011-9 · 7 mos

Houston, Texas, United States

Designed and created SSIS ETL processes data from various sources (FTP, MYSQL, SQL server) to pull the drug And patient information. Created Complex stored procedures, views and functions. This helped to manage patient requirements on time by hospitals.

SQL Database Developer

SQL DATA SOLUTIONS, INC.

2011-1 - 2011-3 · 3 mos

New Hyde Park, New York, United States

Designed logical/physical models in Erwin Tool. Created complex queries, stored procedures, views, triggers, CTE and UDF. Created SSIS packages to pull the data from MYSQL to SQL server. Tuned the SQL queries run by analytics team.