Constructed and analyzed an 3D academic co-authoring and citation network from Scopus bibliographic database.-- Implemented a Java data crawler using Scopus public API. Millions of nodes are stored in an optimized MySQL database.-- Discovered and filtered problematic data caused by inconsistent server response and changing data index on the server.

Delivered a product library application to keep track of sample product flow and accelerate internal product samples management.-- Modeled the application using 3-tier architecture with load balancer that ensures smooth access for all employees.-- Built a multi-level secure authentication mechanism to prevent unauthorized connections.-- Implemented Restful APIs using Java Servlets that allows both web and mobile client using the application, and one level of cache for most searched result, reducing query time by 80% for the most cases.-- Designed and created the web interface of the application with jQuery and Bootstrap.

Launched a visualized billing module for Yonyou NC cloud ERP system.-- Created a Java framework that uses metadata to automatically generate proper billing page to conform clients’ demands.

Boosted the efficiency and security of staff operations and online student-faculty interactions.-- Developed an academic resource system in .NET with back-end management portal for instructors, integrated it with Blackboard to show dynamic contents based on students’ profile using created Restful API. Received 10K+ quires in weeks.-- Digitized student contract signing procedure by implementing a web application using .NET MVC Framework.

Worked full-stack across a National Grid project, required quickly picking up new techniques and different environments.-- Optimized back-end database query, increased query performance for multi-node powerline by 50%.-- Redesigned and implemented a data export module that utilizes user-provided templates.-- Provided various test cases and performed unit testing with JUnit.