Max Chung's Projects

Community Solutions Decision Tool - Summer 2013

Community Solutions is a small consulting firm that aims to help organizations improve their delivery of program and services. They needed a custom online decision-making tool to help evaluators determine their research approach.

• Created an online questionnaire system that generates recommendations and stores past results.
• Created an admin interface to allow administrators to modify the questionnaire and question weighting.

• Application interface design, front-end and back-end development
• Performed usability tests on front-end interface
• Created test plan and test cases; performed quality assurance on the application.
• Created user documentations and user manuals.
• Configure Apache server and MySQL in the development environment

SignalChem LifeSciences Inventory System - August 2014

SignalChem is a biotech company headquartered in Richmond that manufactures enzymes, signaling proteins, and antibodies for research and drug discovery. The company currently manufactures and sells more than 750 products worldwide.

• Created an inventory management system with PHPMaker, PHP, and MySQL to streamline data entry and report generation
• Allowed manufacturing, quality assurance, and sales teams to view inventory and stock levels in real-time
• Increased data completeness and accuracy with required fields and data validation
• Increased user accountability with individual user accounts and modification change logs

• Met with stakeholders to learn about their protein manufacturing process
• Looked at existing data to identify data relationships and data types
• Designed and normalized database tables
• Collected info on which columns to display in views
• Collected info on how report values are calculated
• Created views for frequently queried data and reports
• Created web interface to view, add, and edit products
• Demo system to stakeholders and use feedback to make further modifications to forms
• Format existing spreadsheet data to fit database table format
• Imported spreadsheet data into the system and verified data accuracy

NEAT Enhancements UserScript - June 2016

BCAA has over a dozen different NEAT environments for production, learning, troubleshooting, development, user acceptance testing, and reporting. All the environments look exactly the same except for the page URL and the environment name shown in the about box. The script I created updates the site colour scheme along with the page title and favicon to reduce confusion.

• Changed the site color scheme, page title, and favicon to easily differentiate between production and different test environments
• Locked table headers to easily see which column is which when scrolling through a table
• Added row striping to easily scan across wide tables
• Added buttons on the printer add page to streamline specifying document types a user can print

Other Projects

This is a helper script to schedule emails to be sent at a specified time interval using mail and crontab. Users can specify the sender and recipient email address, email subject, attachments, and time interval.

• Script
• Documentation
• Flowchart

This is a background running script that blocks an IP address after a specified number of failed SSH login attempts using grep, awk, iptables, and crontab. Users can specify the blocking threshold and blocking duration.

• Script
• Documentation
• Flowchart

This is a Visual Basic macro to generate individual employee shift schedules from the main schedule. This allows employees to get a schedule with only their shift times.

• Employee Schedule
• Visual Basic Macro

This is a PHP script that imports 'database.csv', runs validation checks and reformats the data if needed, and outputs 'database edited.csv'

• CSV Validator and Reformatter Script
• Original CSV File
• Modified CSV File

This is a step-by-step guide on how to build my team's RCX robot that was used to complete various challenges in the First Lego League.

• Robot Building Guide