Jian Shi

Designed and queried a spatial database regarding the African national park using Oracle Express 11g.
Installed and created Oracle Spatial Database, used JDBC as the interface to access the database.
Created an application with a GUI in Java, which allows users to interact with the spatial data above.

Designed and programmed to locate and assail counterparts.
Programmed the interface module between SCM and engine.
Programmed to serve the deferring tactics to target on specific counterparts.
Designed the remote module, programmed to instruct autonomous robots.
Programmed the feedback process of LED monitoring all modules.

Implemented the login screen, applied server-side language PHP to access MySQL user tables.
Implemented custom search functions to enable users to shortlist for house locations.
Designed a sidebar which contained shortcuts such as favourite list and direction for visiting.
Enhanced display functions which eased viewing of house photos. Users could swipe back and forth to view photos effortlessly.

Implemented the boids behaviours of protoss such as following, flocking and avoiding obstacles.
Designed efficient offensive algorithms and implemented the micro attacking strategy.
Integrated machine learning into our macromagement to enforce AI bots to take corresponding countermeasures to deal with variant enemies.

Implemented the control system, including joystick controllers, accelerometer controls and touch control.
Built the inventory system for players to collect equipments and choose what to equip with to gain power.
Implemented the artificial intelligence algorithm for enemies, such as pathfinding and releasing skills.
Designed and implemented the graphical user interface in the game such as the homepage and the settings page.

Developed an e-commerce website with the features such as login, shopping cart and checkout.
Built an employee side website to manage products and collect information from customer purchases.
Ensured website safety and prevented it from Cross-Site Scripting and SQL injection using CodeIgniter.
Used Responsive Web Design to make user interface fit for different sizes of screens.

Developed advanced calculator using MCV mechanism that can draw curve by current variable value.
Developed breakout mobile game using core motion, accelerometer and animations.
Implemented Twitter smashtag searching application that can search by users and tags, and parse url within application.

Created a SAT solver, which converts the propositional logic sentence into its equivalent CNF sentence.
Implemented the DPLL algorithm to build a boolean satisfiability solver that can determine whether the given CNF can be converted into a satisfying assignment or not.
Implemented the Bayesian Networks for Disease Diagnosis, patients can check whether they have certain diseases based on a list of symptoms.

Implemented processes and thread schedule, including process creation, termination and context switch.
Developed virtual file system layer using ramfs, including system calls and pathname conversion.
Wrote virtual memory system, including loading kernel into memory, mmap, page switch and pagefault handler.

Simulated a traffic shaper who transmits packets controlled by a token bucket filter depicted below using multi-threading within a single process.
Handled shared-data between 5 threads to realize the whole process from packet arrival through token consumption to packet service and departure.
Applied thread cancellation mechanism to handle the Unix signal properly and clearly.

Set up and simulated the model of CERNET2 by OPNET, and optimised the performance of the transmission efficiency using dijkstra algorithm.
Set up the model of wireless local area network, including antenna model, node and process model.
Explored the relationship between bit error rate and the type of antenna in WLAN simulation by experiment, and weakened this effect by creating the directional antenna.

Applied XAML Layout and Control Widgets to implement the user interface and the user interaction logic.
Designed algorithms to integrate Chinese Lunar Calendar and festivals into the Gregorian Calendar.
Implemented the function of searches and cross references on different months and years.