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

Software Engineering

A collection of Software engineering projects I created, demonstrating my skills in software engineering and design.

Project 2 : Bus Booking system

Mobile Apps

Showcasing innovative mobile applications developed during my studies.

CanaPrep : Canadian citizenship exam prep app

Project Overview

Led and executed the full product lifecycle for CanaPrep, a Minimum Viable Product (MVP) mobile application designed to simplify and prepare candidates for the Canadian Citizenship exam. This system digitizes study materials, manages preparation progress, and streamlines the path to citizenship, demonstrating end-to-end proficiency from idea conceptualization to Google Play Store launch.

  • Key Features

    Cross-Platform UI/UX: Architected a highly performant, responsive user interface (UI) for both iOS and Android, facilitating engaging study and tracking experiences.

    Dynamic Checklist Interaction: Implemented front-end logic for dynamic interaction with personalized study and application checklists.

    Scalable RESTful API: Developed a secure back-end API to handle user authentication, serve study content, and manage real-time progress data.

    Secure Data Management: Designed and optimized a database to ensure reliable storage and fast retrieval of user profiles and application progress.

  • Technical Skills

    Mobile Development: Flutter

    Back-End Development: PHP (RESTful API), Python (Data Engineering/Scripting)

    Database Management: MySQL

    Product Management: Full Product Lifecycle, QA Testing, Continuous Deployment

    Deployment: Google Play Store Release

  • Achievements

    End-to-End Product Delivery: Successfully owned and delivered a commercial-grade software product from conceptualization (zero) to market release (MVP).

    Full-Stack Mastery: Demonstrated complete proficiency across the entire tech stack (Front-End, Back-End, Database, Deployment).

    Enhanced User Preparation: Created an intuitive tool that simplifies a complex compliance/study process, driving user engagement and exam readiness.

    Deployment Expertise: Managed and executed the continuous deployment pipeline and successful publication to the Google Play Store.