Designed and implemented a relational database for an airline booking system using Microsoft Access and SQL Server, including an ER diagram with 15+ entities, normalized tables (up to 3NF), and enforced referential integrity with primary and foreign keys.
Developed complex SQL queries and reports to analyze flight schedules, passenger bookings, and revenue data, utilizing JOINs, subqueries, GROUP BY, HAVING, and aggregate functions for insights into seat availability, peak travel times, and customer preferences.
Wrote SQL scripts to create, populate, and manage the database, ensuring data consistency and integrity through constraints, triggers, and stored procedures to automate booking confirmations, cancellations, and fare calculations.
BUSI 2402 Business Applications Development (Academic Project)
Built a Python-based inventory and order management system for small businesses.
Implemented searching and used built in sorting algorithms to optimize order lookup and processing time.
Integrated SQLite for database management, enabling efficient order tracking.
Timeline
Sales Representative
Neo Financial
09.2023 - 12.2023
Appeals Officer
Canada Revenue Agency
05.2023 - 08.2023
Property Administrator
Upper Hunt Club Centre Inc.
05.2022 - 04.2024
Finance Assistant
Sultan Supermarket
06.2019 - 04.2023
Bachelor of Commerce - Management of Information Systems