• Designed and developed a data pipeline for track popularity data, increased the data timeliness 30%, reduced manual work needed;

• Performed data migration between on-premises environments and AWS S3 using Lambda, SQS, and used that data extracted from S3 to create asynchronous cache refresh;

• Developed code for obtaining bean references in Spring framework using Dependency Injection;

• Created 30+ unit and integration tests using Junit test and Mockito.

• Developed a household register management system for the local government of Kunming City;

• Built backend server with Spring Boot using Spring Security and JWT authentication. and implementing over 30 interfaces.

• Reorganized 3 million+ data into relational data structure, connecting them by Hibernate;

• Integrated the Baidu Map APIs into the system, implementing the locating and routing functions.

• Constructed and maintained the database system and analyzed datasets;

• Analyzed client requirements, conducted use cases and designed over 50 test cases for development, delivering status reports for both technical and non-technical team members;

• Improved the maintenance of the database with Shell scripts and SQL, and sped up the data access by indexing;

• Used SVM models to classify dataset and extracted patterns via domain-specic language (DSL) with Scala.