Summary
Overview
Work History
Education
Skills
Certification
Languages
Projects
Additional Information
Timeline
BusinessAnalyst
PraveenKumar S

PraveenKumar S

Data Engineer
Poonamallee,Chennai/Tamilnadu

Summary

Experienced Data Engineer with 1.5 years of expertise in Azure ADF, Azure Synapse, SSIS, and Data Flow on Azure cloud platforms. Proficient in designing and implementing scalable data pipelines, ETL workflows, and data integration solutions. Adept at transforming raw data into actionable insights to drive business strategy and enhance decision-making. Certified in SnowPro, Databricks, and Generative AI fundamentals, with a strong track record in collaborating with cross-functional teams to resolve complex data engineering challenges.

Overview

2
2
year of professional experience
3
3

Certifications

Work History

Data Engineer

Avasoft
01.2023 - Current
  • Developed and managed ETL processes using SSIS, SQL, Python, and Azure Data Factory, handling an average of 100,000 records per day.

    Designed and implemented scalable data pipelines and ETL workflows on Azure platforms, resulting in 20% increase in data processing efficiency.

    Monitored and optimized data warehouse functionality and performance, reducing query execution time by 30%.

    Supported large-scale data integration programs, coordinating substantial datasets across multiple sources, resulting in 25% reduction in data processing time.

    Presented data insights using data visualization techniques to drive business change, leading to 15% increase in revenue.

    Automated data collection processes to maintain accuracy and consistency, saving approximately 10 hours of manual work per week.

    Enhanced analytics to support strategic planning and decision-making, resulting in 20% improvement in forecasting accuracy.

    Developed and deployed data models, improving existing models for effective solutions, resulting in 15% increase in data accuracy.

    Collaborated with cross-functional teams to identify and address business requirements, resulting in 10% increase in project completion rate.

    Troubleshot and resolved complex data engineering challenges, resulting in 50% reduction in system downtime.

Education

Bachelor of Engineering in Computer Science -

S.A. Engineering College
Chennai, Tamil Nadu
01.2023

12th Grade in Computer Science -

Velammal Matric Higher Secondary School
Chennai, Tamil Nadu
01.2019

10th Grade in General Studies -

Saraswathi Vidhyalaya Matric and Higher Secondary School
Chennai, Tamil Nadu
01.2017

Skills

  • Data Warehousing: SQL Server, Azure Synapse Analytics, Google BigQuery
  • Programming Languages: Python (2x, 3x), Apache Spark (PySpark, Spark SQL)
  • Databases: MS SQL Server (On-Prem & Cloud), PostgreSQL, Oracle
  • ETL Development Tools: SSIS, Azure Data Factory (ADF), Azure Data Pipeline, Data Flow, Notebooks
  • Cloud Technologies: Microsoft Azure, Google Cloud Platform (GCP)
  • DevOps: Azure DevOps
  • Project Management: JIRA, MPP
  • Data Visualization: Power BI
  • Data Modeling
  • Data Pipeline Design

Certification

  • SnowPro Core Certification
  • Databricks Certified Data Engineer Associate
  • Academy Accreditation - Generative AI Fundamentals

Languages

Tamil
Bilingual or Proficient (C2)
English
Advanced (C1)

Projects

ETL Engineer for Law Firm (TX, US)  
Technologies: SSIS, SQL Server, Azure Synapse


  • Designed and implemented an Azurebased cloud data platform for data engineering and transformation.
  • Created data models based on medallion architecture, organizing data in an Azure Data Lake.
  • Developed full load and incremental pipelines for data synchronization.
  • Implemented data quality frameworks to ensure accuracy and consistency.
  • Utilized Azure DevOps for CICD processes and project tracking with MPP.
  • Extracted, transformed, and loaded data from multiple sources, ensuring seamless integration into the data warehouse.


ETL Engineer for Marketing Client  
Technologies: GCP (BigQuery, Dataproc, Cloud Storage), PySpark, Spark SQL


  • Migrated data from legacy architecture to Google Cloud.
  • Cleaned and standardized data using PySpark notebooks.
  • Formed customer segments based on business data points.
  • Delivered data to Salesforce for targeted marketing campaigns.
  • Managed project using Jira and DevOps operations with GitHub.
  • Developed data pipelines to curate and integrate marketing data into BigQuery.

Additional Information

The information provided in this resume is accurate to the best of my knowledge. Any misrepresentation or omission of facts may result in disqualification from consideration for employment. I authorize the verification of any and all information listed herein.


Timeline

Data Engineer

Avasoft
01.2023 - Current

Bachelor of Engineering in Computer Science -

S.A. Engineering College

12th Grade in Computer Science -

Velammal Matric Higher Secondary School

10th Grade in General Studies -

Saraswathi Vidhyalaya Matric and Higher Secondary School

Similar Profiles

CREATE PROFILE
PraveenKumar SData Engineer