Project

Created a SQL database with a PHP webpage used for such as reset, insert, update, group by, and division

Designed a web page with a user-friendly UI,  basic security practices, and error handling

Used SQL Plus to make a database with 8 relations, 10 entities, and 26 attributes and normalized by BCNF 

Wrote R in Jupyter Notebook to load the dataset and do preprocessing

Used t-test and bootstrapping to test hypothesis with visualization

Completed a full-stack web development project in TypeScript and Node by IntelliJ IDEA

Designed a web page for UBC grade history and UBC building distance and connected it to the server by JSON

Collaborated with a partner by using different branches and peer reviewing before merging in GitHub

Wrote R in Jupyter Notebook to build a model for heart disease prediction in a group of four people

Split data and used 10-fold cross-validation to find the best neighbour number for classification

Trained the model by weighted k-nearest neighbour classification and assessed the accuracy of the model

Designed a calculation on Android to display real-time results as users type the equation

Used Rhino engine for equations’ evaluation to improve computational efficiency and save development time

Connected a router to UBC Wi-Fi by Raspberry Pi to make smart home appliances on the same LAN

Added temperature-controlled function for Raspberry Pi fan by Python to reduce fan’s noise

Set up auto reboot after power failures to ensure appliances continue to run by Linux command prompt

Designed a console-based user interaction for the to-do list and transformed it into GUI using JAVA Swing

Implemented a mechanism for to-do list data that saves/loads data to/from the file system

Used JUnit to test to-do list application with exceptions

Added notification sound for add and delete buttons