Constructed a browser-based data management system to enable user to search, upload, delete and edit.
◦ Designed and implemented the UML and Java class of the relational model and database schema to ensure clear
dependency in tables from MySQL, efficient usage of fields, and reduced querying time in the backend.
◦ Participated in cleaning data, deploying database Aliyun to avoid potential data loss, defining ETL workflows with
external data source for business analysis and insights.
◦ Built the Data Access Layer(DAO) for all the classes using JDBC, view components of the application using JSP,
and server using Apache Tomcat, in order to achieve the core features of the application such as login,
registration, data CUDR operations, and advanced search function.