Summary
Overview
Work History
Education
Skills
Certification
PROJECTS
Timeline
Generic

Bhavik Patel

Houston,TX

Summary

Aspiring Data Engineer with hands-on experience in data modeling, ETL development, and database management through professional roles and academic projects. Proficient in Python and SQL with a strong foundation in data analytics. Seeking an entry-level Data Engineer position to apply and grow technical skills in optimizing data infrastructure and building efficient data pipelines.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Data Engineer

HCL Technology
01.2022 - 09.2023
  • Designed, built, and maintained ETL pipelines: Successfully implemented ETL data pipelines to efficiently extract, transform, and load data from various sources into data warehouses and lakes, resulting in a 30% reduction in data processing time.
  • Data cleansing and transformation: Conducted thorough data cleansing and transformation, including normalization, aggregation, and enrichment, ensuring high-quality data for analysis and reporting.
  • CI/CD pipeline development: Developed and optimized CI/CD pipelines to automate testing and deployment across multiple environments, reducing deployment time by 40%.
  • Azure services integration: Managed data ingestion to Azure Data Lake, Azure Storage, and Azure SQL, and processed data using Azure Databricks, enhancing data accessibility and processing efficiency.
  • ETL:Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Process improvement initiatives: Led several process improvement initiatives, identifying areas for enhancement and implementing solutions that increased operational efficiency by 20%.
  • Data warehousing solution: Engineered a robust data warehousing solution using Spark, enabling the processing and analysis of multi-terabyte datasets and improving data-driven decision-making efficiency by 25%.

Data Engineer Intern

HCL Technology
09.2021 - 12.2021
  • ETL development with Synapse: Performed ETL processes using Synapse Pipeline and Synapse Notebook, streamlining data integration and processing workflows.
  • Databricks dashboard creation: Created comprehensive Databricks dashboards utilizing Python and SQL to provide data visualization and insights for data providers, enhancing data-driven decision-making.
  • Azure Data Factory pipelines: Developed and managed data pipelines using Azure Data Factory, successfully integrating and processing data from multiple sources to ensure seamless data flow.
  • Data analysis with KQL and SQL: Conducted data analysis using Kusto Query Language and SQL, providing actionable insights for business decisions.
  • Pipeline implementation: Implemented efficient data pipelines in Azure Data Factory, facilitating data extraction, transformation, and loading from various sources, improving data accuracy and availability.

Education

Bachelor of Science - Computer Engineering

University of Houston Clear-Lake
Clear-Lake, TX
12.2021

Skills

Languages: Kusto Query Language, SQL, DAX, Python, PySpark

Developer Tools: Microsoft Azure, Databricks, Synapse, Data Factory, Azure DevOps, Fabric, Power BI

Technical: Data Analytics, ETL, Data Warehousing, Data Pipelines, Dashboard Development

Certification

  • Microsoft Certified: Azure Fundamentals by Microsoft
  • Traditional Data Architectures: Data Warehousing and ETL Systems by Skillsoft
  • Data Engineering on Microsoft Azure: Databricks by Skillsoft
  • Data Engineering on Microsoft Azure: Data Factory by Skillsoft

PROJECTS

Customer Churn Prediction
HCL Technology, September 2021 - December 2021

  • Developed a customer churn model in Azure ML using data from Azure Data Factory pipelines.
  • Analyzed and synthesized large datasets using Python and SQL.
  • Created a predictive model that identified at-risk customers with 85% accuracy, resulting in a 15% decrease in customer churn within the first quarter of deployment.


University Capstone Project: Data Warehousing Solution
University of Houston Clear-Lake, January 2021 - May 2021

  • Designed and implemented a data warehouse using SQL and Azure services.
  • Developed ETL processes to load and transform data from multiple sources into the data warehouse.
  • Created interactive dashboards using Power BI to visualize key insights and trends from the data.

Timeline

Data Engineer

HCL Technology
01.2022 - 09.2023

Data Engineer Intern

HCL Technology
09.2021 - 12.2021

Bachelor of Science - Computer Engineering

University of Houston Clear-Lake

Similar Profiles

CREATE PROFILE
Bhavik Patel