Data Engineering

Projects focused on data engineering and Data Analysis showcasing my analytical and technical abilities.

Project 1 : Exploratory Data Analysis (EDA) of COVID-19 (2020-2021)

In this project, I conducted an in-depth Exploratory Data Analysis (EDA) of COVID-19 data for the years 2020 and 2021. Utilizing SQL and SQL Server Management Studio (SSMS), I extracted, transformed, and analyzed large datasets to uncover key insights and trends related to the pandemic. The analysis focused on various metrics such as infection rates, death percentage, percentage of new deaths compared to new cases, highest death count by country, total people vaccinated by continent and vaccination progress across different regions.
For data visualization, I employed tools to create comprehensive and interactive dashboards that effectively communicated the findings. These visualizations helped in identifying patterns and correlations, providing valuable insights for decision-makers and stakeholders.
This project not only enhanced my technical skills but also deepened my understanding of data-driven decision-making in public health.

Skills: SQL · SQL Server Management Studio · Data Visualization · Data Analysis · Microsoft Power BI

Project 1 : Intelligent Level Crossing Safety System

Project Overview
Designed and implemented an automated detection and management system for level crossings, prioritizing the safety of vehicles, pedestrians, and trains. This innovative system integrates multiple sensors, signaling devices, and alert mechanisms to prevent incidents and ensure seamless traffic flow.
Key Features
Multi-sensor detection system for accurate tracking of approaching vehicles, pedestrians, and trains
Advanced signaling and alert mechanisms for timely warnings and notifications
Automated incident prevention system to minimize risks and ensure public safety
Technical Skills
Hardware Design: VHDL programming for FPGA development
Hardware Installation: Successful deployment of system components
Digital Logic: Utilized Field-Programmable Gate Arrays (FPGA) for efficient system operation
Impact
Enhanced public safety through automated incident prevention
Improved traffic flow and reduced congestion
Demonstrated expertise in designing and implementing complex safety systemsProject Overview Designed and implemented an automated detection and management system for level crossings, prioritizing the safety of vehicles, pedestrians, and trains. This innovative system integrates multiple sensors, signaling devices, and alert mechanisms to prevent incidents and ensure seamless traffic flow. Key Features Multi-sensor detection system for accurate tracking of approaching vehicles, pedestrians, and trains Advanced signaling and alert mechanisms for timely warnings and notifications Automated incident prevention system to minimize risks and ensure public safety Technical Skills Hardware Design: VHDL programming for FPGA development Hardware Installation: Successful deployment of system components Digital Logic: Utilized Field-Programmable Gate Arrays (FPGA) for efficient system operation Impact Enhanced public safety through automated incident prevention Improved traffic flow and reduced congestion Demonstrated expertise in designing and implementing complex safety systems
Skills: VHDL · Hardware Installation · Field-Programmable Gate Arrays (FPGA)

Project Overview
Designed and developed a comprehensive bus booking system using Java, enabling seamless travel experiences for users. This system allows users to efficiently book bus travels, streamlining the ticketing process and enhancing customer satisfaction.
Key Features
User-friendly interface for easy booking and management
Real-time bus schedule and availability updates
Technical Skills: Programming language: Java. IDE: NetBeans
Database management: SQL. MYSQL
Achievements
Successfully implemented a scalable and efficient booking system
Improved user experience through intuitive interface design