TECHNICAL PROJECTS


Swift Route: Logistics Management System (Solving VRP Using Google OR-Tools)

Laravel, HTML, CSS, JavaScript, Bootstrap, Python, MySQL, Google Maps API

The final-year project is a web application designed for logistics companies and teams to manage logistics orders, vehicles, and routes efficiently. It also offers comprehensive analytics to support better decision-making. The system utilizes the routing solver from Google OR-Tools, an optimization algorithm developed by Google AI, to optimize delivery routes and minimize travel distances and time.

System demo »

Exploring Disney Movie Portfolio

Python

Conducted exploratory data analysis on the dataset to view trends and insights related to Disney movies from 1937 to 2016.

Read documentation »

Exploring Malaysia Annual Live Births by State Sex Ethnicity

Python

Conducted exploratory data analysis on the dataset to view insights on Malaysia's annual birth rate from 2000 to 2022.

Read documentation »

Maven Roasters Sales Data Analysis

Tableau

Analyzed transaction records in 2023 for Maven Roasters, a fictitious coffee shop operating out of three NYC locations. Designed a sales and product dashboard and provided recommendations and insights from the business moving forward based on the analysis.

View dashboard »

DFA Place Name Finder

Python

An implementation of a Deterministic Finite Automata (DFA) to recognise various place names in a text, which includes regions, subregions, seas, countries, and states.

FlixPrime: Online Movie Ticket Booking App

Java, XML, Firebase, Android Studio

Developed an Android application for cinema-goers that will generate a digital ticket that users can display on their application upon arrival at the cinema, eliminating the need to wait in line to purchase or print a physical ticket.

View prototype »

Predict The State Of Fetus In Patients

Python

Created two supervised machine learning models, decision tree and k-Nearest Neighbors algorithms that could predict the state of fetus in patients based on a cardiotocogram dataset. The decision tree model managed to predict with 97% accuracy and was chosen as the best model.

Read documentation »

Discovering Most Common Long Covid Symptoms Told In Social Media using N-grams and Concordances

Python, AntConc

Conducted exploratory data analysis on Long Covid related posts on Reddit that reveal the experiences and symptoms that people with a history of Covid-19 experience. Text analysis methods are used to discover the most common Long Covid symptoms that people say they experience.

Read documentation »

AirAsiana Airline Ticket Reservation Database System

SQL, Oracle Database 11g Express Edition, Oracle APEX

Designed the entity relationship model, wrote SQL query to generate a cross-module report, implemented and integrated the system on Oracle APEX.

System demo »

Netflix Content Rating Data Analysis

Power BI

Analyzed Netflix’s content in conjunction with IMDb scores from 2021-2023 to identify high-rated content characteristics.

View dashboard »

Bike Sales Data Analysis

Power BI

Analyzed sales data from 2011-2016 for a Bike Sales Company in Europe. Designed a sales dashboard and provided recommendations and insights from the business moving forward based on the analysis.

View dashboard »

Maven Toys Expansion Plan

Power BI

Analyzed sales and inventory data for a fictitious chain of toy stores in Mexico. Designed a dashboard that outlines a potential expansion plan and contains the supporting data from the analysis.

View dashboard »

Quick Sort Algorithm

Python

Implemented the quick sort algorithm in Python to sort the strings in a file lexicographically.

Daily Cafe Sales Calculator

C++

Applied object-oriented programming to create a program that displays the analysis report of cafe sales.

Implementing Common Graph Functions To A Directed Weighted Graph

C++

Applied object-oriented programming to create a program that applies various graph functions to a directed weighted graph.

© 2024 by Hana Shah