Long Long

● Designed ER-Model schema of relational database; created tables and stored data in PostgreSQL
● Build a website for users to view, add, update, and delete data in database, and wrote SQL queries to retrieve data
● Developed web app backend in Flask and utilized sqlalchemy to connect to PostgreSQL database hosted on Google Cloud
Created frontend web pages with Jinja2 templating; added search ability that takes user search keyword to construct queries

▪ Implemented list of data management functions including fetching, searching, cleaning, and reorganizing data from NBA.com
▪ Analyzed data using statistic knowledge and python libraries such as Pandas, and matplotlib
▪ Self-learned D3, designed series of interactive data visualization, and presented findings with webpage story

● Focused on development of server side RESTful APIs using NodeJS with Express, and worked in agile environment
● Implemented user authentication features with local and social network strategies using PassportJS and MongoDB
● Developed functions to search nearby service postings based on address, geo coordinates, or map areas from user input
● Created suite of unit tests with Mocha framework, and integrated git repository with Travis CI for continuous integration

● Implemented in-kernel key-value store with kernel-level locking and wait queues, and system calls to give access to user space programs
● Implemented and embedded a scheduler that can schedule tasks in round-robin fashion in higher priority than programs with normal policy
● Developed a simple custom filesystem from scratch that supports write, read, create and delete files and directories

● Developed NodeJS web app for users to stream tweets and visualize “mood map” on webpage, and deployed app on AWS EC2
● Employed Twitter APIs to fetch streaming tweets, used Kafka as processing queue, and perform sentiment analysis using IBM Natural Language Understanding with pool of background workers in Python, and sent analysis result via AWS SNS notification
● Stored and queried analysis results in Elasticsearch, and drew Heatmap on client side using Socket.io and GoogleMaps APIs

● Developed web application using Django and python for user to view, add, and edit player and game statistics.
● Designed backend system architecture and configured relational database in SQLite .
● Created visualization tools using JavaScript on frontend for users to analyze data more intuitively.

● Designed complier for eGrapher, a programming language that can draw basic shapes with c syntax and python feature.
● Built compiler frontend including parser, lexical analysis, syntax tree generation, and static semantic analysis.
● Implemented backend, focused on translation of abstract syntax tree into LLVM intermediate representation code.