Summary
Overview
Work History
Education
Skills
Websites
Workshops
Projects
Open to Relocation:
Certification
Timeline
Generic

PRABHAV VAISHNAV

Noida

Summary

  • Dedicated and results-driven Jr. Big Data Engineer Trainee with 1 year of hands-on experience in SQL, Python, Azure (ADF, Databricks, ADLS Gen2), PySpark, and Power BI.
  • Skilled in designing, implementing, and optimizing ETL pipelines, data integration workflows, and API-based data migration processes.
  • Proficient in building interactive Power BI dashboards to deliver actionable business insights.
  • Strong foundation in data warehousing, cloud computing, and big data technologies, with a passion for solving complex data challenges.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Jr. Associate Bigdata | Data Analyst

Celebal Technologies pvtltd
Noida
02.2023 - 01.2024
  • Developed and maintained data pipelines for ingestion, transformation, validation, and storage of diverse data formats, while ensuring compliance with data governance standards.
  • Executed ETL operations using Apache Spark to cleanse and integrate data into a centralized repository.
  • Created dynamic Power BI dashboards and automated reports with Python to facilitate data-driven decisions.
  • Analyzed over 1,000 data points through SQL to identify trends, boosting customer retention by 15%.

Software Analyst Intern

Biztime IT Solutions
Remote
05.2020 - 07.2020
  • Developed and managed comprehensive project plans, providing regular status updates for timely delivery.
  • Collected user data from online platforms, maintaining secure and organized user database.
  • Analyzed user income data to offer customized loan facilities, enhancing user financial support.
  • Implemented cost-effective network infrastructure to ensure internet connectivity in underserved rural areas.

Education

Master of Computer Applications -

Lovely Professional University
Phagwara, Punjab
07-2023

Bachelor of Computer Applications -

UPES
Dehradun, Uttarakhand
06-2020

Senior Secondary -

KVITBP Gauchar
Chamoli, Uttarakhand
06-2017

Skills

  • Advanced SQL
  • Python programming
  • Java programming
  • Software Engineering
  • Microsoft Azure Service
  • Azure Data Factory and Databricks
  • Power BI and Excel
  • ETL processes
  • Apache Airflow
  • Big Data workload
  • Hadoop, Spark, and PySpark
  • Database management systems
  • Data warehousing and modeling
  • Data governance practices
  • Data quality assurance
  • Data analytics techniques
  • REST API integration
  • CI/CD
  • JSON and XML handling
  • Linux command line interface
  • Communication skills
  • Customer support
  • Problem-solving abilities
  • Analytical thinking

Workshops

  • Participated in the Microsoft Azure Data Fundamentals Bootcamp in 2023
  • Attended the 'Big Data Analytics using PySpark' webinar, hosted by Databricks
  • Completed the Celebal in-house workshop on ADF pipeline optimization

Projects

Project 1: Scalable Data Migration Utility

Project description:

  • Built a scalable data migration utility for automated S3 to ADLS Gen2 transfers using ADF, Databricks (PySpark), and SQL, boosting efficiency by 30%
  • Designed and optimized ETL pipelines with advanced SQL queries for data validation, transformation, and incremental loads over 100 GB+ datasets
  • Migrated over 400 DB objects (tables, views, procedures), with DDL compatibility, integrated REST APIs, and applied performance tuning techniques
  • Delivered real-time insights via Power BI, enforced data governance, and implemented automated alerting and monitoring of ETL workflows

Project 2: Sales Performance Dashboard in Power BI

Project description

  • Increased sales forecasting accuracy by 20%
  • Developed an interactive dashboard to track sales KPIs and trends
  • Integrated data from SQL Server, Azure Data Lake, and Excel using Power Query
  • Designed visual reports with slicers, drill-throughs, and DAX queries
  • Reduced manual reporting by 60%, enabling real-time decision-making
  • Increased sales forecasting accuracy by 202,

Open to Relocation:

  • Hyderabad, Bangalore, or anywhere in India.
  • Comfortable with shifts: 2 PM – 11 PM | 11 AM – 8 PM

Certification

  • Certified by Databricks Lakehouse Fundamental
  • Microsoft Azure Data Fundamentals Certified (DP-900)
  • Microsoft Azure Fundamentals Certified (AZ-900)
  • Completion Certificate Course of 300 hours on Responsive Web Design by freeCodeCamp, July 2022
  • Google IT Automation with Python – Coursera
  • Completion Certificate from Personal Software Training

Timeline

Jr. Associate Bigdata | Data Analyst

Celebal Technologies pvtltd
02.2023 - 01.2024

Software Analyst Intern

Biztime IT Solutions
05.2020 - 07.2020

Master of Computer Applications -

Lovely Professional University

Bachelor of Computer Applications -

UPES

Senior Secondary -

KVITBP Gauchar

Similar Profiles

CREATE PROFILE
PRABHAV VAISHNAV