As part of a job I helped design, debug and complete this realtor website under this live domain: landedpropertysingapore.com (may have been changed). Jpb scope indluced UI/UX changes, debug link attachments, chatbot, etc.

As part of the ByteHackz 2023 X OCBC Hackathon, me and my team built a prototype to make online banking services with functions to increase accessibility for people with physical disabilities. I took on various roles including product management, frontend coding, and debugging within the Scrum framework. Working alongside a diverse and talented team, we faced stimulating challenges that pushed us to innovate and collaborate effectively. It was incredibly rewarding to see our ideas materialize through coding and innovation.

For my part, I completed package 2 which entailed these features: Basic Features: 1. Upon receiving a parcel, the station manager will search for the parcel delivery record based on the “Parcel ID” and assign it to a delivery man. The system should update the delivery status of the parcel to “delivery to destination in progress”. (See "Parcel" Table for details.). A record associated to the “Parcel ID” should be inserted in the “DeliveryHistory” table, with the description: e.g., “Received parcel by StationMgrSG on 29 Mar 2023 4:00pm.” (Note: StationMgrSG is the Login ID of the station manager.) 2. The delivery man can view a list of parcel delivery records assigned to him, with the status of “delivery to destination in progress”. After completing the tasks assigned, the delivery man will update the delivery status as follows: • For local delivery, update the status to “delivery completed” once the delivery is successful. A record associated to the “Parcel ID” will be inserted in the “DeliveryHistory” table with the description: e.g., “Parcel delivered successfully by abc1 on 30 Mar 2023 10:00am.” (Note: abc1 is the Login ID of the delivery man.) • For overseas delivery, update the status to “delivery to airport in progress” after delivered to airport. A record associated to the “Parcel ID” will be inserted in the “DeliveryHistory” table, with a description: e.g., “Parcel delivered to airport by abc1 on 30 Mar 2023 1:00pm.” (Note: abc1 is the Login ID of the delivery man.) Advanced Features: 3. When the station manager assigns a parcel to a delivery man, the system should validate that the delivery man can only be assigned with a maximum of 5 parcels with status of “delivery to destination in progress”. 4. For each unsuccessful delivery, e.g., parcel receiver is not found, wrong address, parcel damaged, etc., the delivery man will update the delivery status to “delivery failed” and create a "Delivery Failure Report" in the system explaining the situation. (See "DeliveryFailure" Table for details.) System to ensure that only parcel delivery records with the status of “delivery failed” are allowed to create “Delivery Failure Report”.

Made Dashboards using Power BI.

Using survey data that has been collated on International Air Passenger Survey Data.xlsx, I created suitable Interactive PivotTable reports that help answer queries.

Used Microsoft Excel functions and features in an integrative approach

I used Jupyter Notebook to design and implement a dashboard and/or interactive visualisations that allowing us to explore a given dataset.

Using Jupyter Notebook, we analyzed two datasets to understand the data and prepare the data for the machine learning modelling

As part of the Design Principle Module, I redesigned the Uber App Icon

Created a website with my partner incorporating database servers surrounding a healthy online business.

I learnt to the basics of HTML. Starting with HTML semantics and elements such as , , , , , , . I also learnt styling in HTML making use of CSS to change the colour, size and position of elements in the website. Following that we were taught the use of ID and Class attributes which is an amazing tool allowing us to target individuals or groups to alter their style. We were then taught to create forms using , and tags. The media query was also taught to modify the CSS to suit mobile viewing. Positioning and Z-Index were also taught to position the elements and control the depth. Lastly, flexboxes were taught allowing out items sizes to change according to the container.

Created a website for my ID Asgn 1 surrounding a technology company.