• Write SQL scripts to autoload files into the database and extract critical information by merging tables every week.

• Scheduled python script which can detect abnormalities in the database and send an alert every morning with crontab.

• Built a data analysis website using Flask, where the front end can update value dynamically by utilizing Jinja and JQuery.

• Tested the system stress with Locust, and checked calculated value on each web page with python.

Built the Front End using Vue for the project which builds a platform for Food Quality Certification applies.

Analyzed 16 application forms, divided each form into separate parts, designed 10 webpages to fill forms, implement autocomplete to reduce the repeat input.

Accomplished data update automation using lifecycle hooks in Vue. In the instance lifecycle, the webpage will send requests to API through Ajax and gain the most recent data.

Programed the task board and warning message to display application status, use histogram and pie chart to show the related statistic.

• Performed data visualization on cloudberry, tableau, and Nanocube for over 1 million records.

• Evaluated data visualization performance of cloudberry, tableau, and Nanocube based on 14 million twitter data.

• Authored report on evaluation and comparison on different aspect of cloudberry, tableau, and Nanocube, including performance, space usage, and implementation methods for each function.