Productivity Planner for iOS
Aug 2024 - Present
Under Progress
Warehouse Management Platform
• Developed a relational database management system application for warehouse inventory, utilizing Oracle for robust database management, ensuring data integrity and efficiency. Engineered using PHP and embedded into HTML.
• Designed and implemented complex SQL queries for both predefined and user-defined operations, enhancing user experience through features like aggregation, nested aggregation, projection, and division.
• Created an Entity-Relationship (ER) Diagram to visually map out the database schema, supporting a clear understanding of data relationships and facilitating database optimization and performed BCNF Decomposition on database schema to eliminate redundancy and enhance data retrieval efficiency and consistency.
• Currently enhancing the user interface to improve user experience and adding customizable search filter
Query Engine for Grades at UBC
Jan - Apr 2024
• Developed the "UBC Course Finder," a full-stack web application using Node.js for data processing and server-side logic, and HTML5, CSS, and JavaScript for the frontend. Implemented RESTful APIs to connect the frontend and backend, creating GET, PUT, POST, and DELETE endpoints for dynamic data interaction, tested using Postman.
• Implemented Test-Driven Development (TDD) from the outset, creating foundational tests to ensure basic functionality before coding began, followed by comprehensive unit and integration testing using Chai-as-promised.
• Facilitated user interaction with data through features allowing users to add, remove, and list datasets, improving the application’s usability and personalization options. Integrated advanced data visualization tools using the D3.js library, enabling users to generate dynamic bar charts and pie charts for insightful analysis of course data.
Aura
An Online Shopping App owned and operated by the MH Alshaya Group, Dubai. I worked on this eCommerce App using JavaScript and React Native alongside other plugins like Firebase and Redux.