Scope

• Excel + Outlook Automation: Daily Report Analysis
• Excel + Word Automation: Endorsement Handling
• Windows Server Automation: Patch Management
• Windows App Automation: Configuration Checking

Client

• Government healthcare agency of extra-large scale

Objectives

• To drive successful RPA implementations within highly secured environments.
• To champion the practical adoption of the vendor's product in Hong Kong.

Roles & Responsibilities

• Team Lead, responsible for overseeing the RPA team and managing technical aspects, while assisting the Project Manager in formulating the project management plan.

Work Accomplished

• Supervised the on-premise installation of the automation suite.
• Provided concise and easily evaluable progress updates to MD.
• Prepared man-day estimates, Gantt charts, and deployment architecture.
• Delivered 2 online seminars as a keynote speaker, introducing our solutions and sharing insights on RPA opportunities with over 80 attendees.
• Collaborated closely with process owners to strengthen the use of re-engineering strategies for streamlining end-to-end business processes.
• Conducted regular code reviews and framework assessments to ensure adherence to industry best practices.
• Developed a comprehensive documentation framework from scratch and conducted the final review of the proof.
• Offered technical assistance and problem-solving insights to the team.

Achievements

• Successfully completed 6 challenging IT automation projects within 6 months, overcoming scheduling and manpower constraints.
• Completed 3 migration projects that the vendor recognized as pivotal use cases in Hong Kong.
• Played a key role in securing the company's status as the vendor's official partner in Hong Kong.

Scope

• Windows Server Automation: Configuration Checking
• Excel + Chrome Automation: Data Retrieval, Processing & Analysis

Client

• Government healthcare agency of extra-large scale

Objectives

• To explore RPA opportunities within a highly secured environment.
• To automate IT routine operations.

Roles & Responsibilities

• Analyst Developer, responsible for all technical aspects of the project, including requirements analysis, bot development, and managing change requests.

Work Accomplished

• Developed 2 bots in 2 weeks to automate 2 challenging IT back-office operations.
• Optimised business processes with fixes to long-standing issues that struggled process owners.
• Composed best-practice RPA solutions with configurable and exception-handling capabilities within a highly compressed schdule.
• Deployed and attested the platform in the client's highly secured environment.
• Presented the work to process owners with live demonstrations.

Achievements

• Received recognition from process owners for efficient prototyping.
• Contributed to securing the project contract for the company.

I was tasked with maintaining the company's ERP system, which proved challenging due to its aged framework (LAMP ES5) and absence of documentation.

I meticulously examined the entire database structure and interface code to gradually reverse-engineer the underlying business logic.

Based on my findings, I proposed revamping the system with new functions and interfaces. My seniors, including the GM and MD, were genuinely pleased with the proposal and the revitalized outcomes.

Database

• Analyse the structures, relationships and semantics across hundreds of tables
• Remove deprecated or duplicated tables from the database for traceability
• Replenish missing integrity constraints to uphold data integrity
• Enforce referential constraints to rebuild missing relationships
• Translate the database into ER Diagrams for traceability
• Switch to a more efficient database storage engine and character encoding system
• Update the choice of data type and default values to ensure consistency

User Interface

• Analyse the code structures and transaction logic across numerous PHP files
• Redesign the user interface with better browser compatibility
• Enhance search modules to provide users with a more advanced search experience
• Enable data export in spreadsheet format to support sales operations
• Replenish data validation and verification checks on data entry forms
• Improve transaction handling, cookie session management and permission checking
• Implement single sign-on with LDAP integration

The project was my first attempt at self-learning 3d modelling through tutorials, examples and experiments. It also provided me with a platform to practice typesetting and description writing. All products were published to Steam Workshop, each featuring an attractive description and gallery to boost marketing outcomes.

3D models were created using SketchUp or Blender; UV mappings were done on AutoDesk 3Ds Max or Blender; Textures were completed using Photoshop or Photopea. Each project consumed around 5 - 7 days to complete.

Publications

• 3 schools
• 4 sport grounds
• 1 fire station
• 1 library
• 2 public housing
• 1 airport atc

Achievements

• Most of my work was rated 5 stars.
• Many of my works were featured on the Most Popular Items reel.
• My works were widely subscribed to by players from Hong Kong.
• Renowned asset creators and international players commended my work.

Project Page

The final year group project was about building a voice-controlled smart instrument that is able to react accurately to a set of predefined wake words and commands.

Technology used

• Jupyter Notebook
• Tensorflow, Keras API for model building
• Librosa for audio resampling
• Python Speech Features for features extracting
• NumPy, matplotlib for Graph Plotting

We first defined a set of verbal commands and wake words to be used in the project. We made use of the Google speech recognition dataset to construct our very first audio sample library.

We then built the recognition models by applying several pre-processing and machine-learning techniques.

• Feature Extraction: Mel-Frequency Cepstrumc (MFCC)
• Model building: Convolutional Neural Network (CNN) - Speaker independent
• Model building: Gaussian Mixture Models (GMM) - Speaker dependent

After generating the models, we developed several python algorithms that compare the trained models with processed inputs for results prediction.

Raspberry Pi was used as an edge device for housing the entire python-driven recognition system (listener, predictor, feature extractor, resampler, and trained models). The device interfaced with an instrument to offer voice-controlled smart capabilities.

Since the edge device come without a display, we developed an Android mobile app using MIT App Inventor to provide users with a simple graphical interface to interact with the system.

When a user speaks, the speaker on Raspberry Pi or mobile app captures the audio signals. The system then processes the data by performing MFCC feature extraction. Once the feature is extracted, it is compared with the pre-trained models. The results will then be displayed on the mobile app (communication via SSH), and will be used to signal the interfaced instrument (e.g., turning lights on).

Throughout the project, we achieved goals, composed reports, and learned techniques together as a team.

Project Page

First released in 2013 and last updated in 2014, Admin360 was originally an abandoned Minecraft Java plugin developed by vidhu1911.

The plugin introduces a helpdesk system to Minecraft that poses a stronger focus on real-time interactions rather than contactless "ticket" processing. Maybe the original author isn't aware of how useful the idea is, but the concept was pretty well needed for small servers at the time (including my server).

At the time when I wanted to make use of the plugin, it was already 2 years since the author's inactivity. Very unfortunately, during that period of time, Minecraft went through several big updates that broke some of the legacy codes in the plugin. Due to my strong interest in the project, I decided to fork it, fix the defective parts and share it with others. That's how the reloaded version came into place in 2016.

The new version continued Admin360's philosophy with extensive enhancement in code, performance, customizability, and functions. The improvements were mostly done based on the established framework.

To be in line with modern Minecraft and Java standards, the legacy code base has been drastically revitalised throughout the years. About twice to thrice the number of new features was added to the system as an answer to the growing needs. At the time of 2021, the original framework only accounted for up to 30% of the newly maintained code.

Through this project, I practised extended development based on existing products. This kind of "build upon somebody's work" creation is far more effective than building the entire framework from scratch.

Project Page

In this project, I explored functionalist concepts by analysing several architectural examples from Hong Kong. Dioramas and summaries were published to PlanetMinecraft (PMC), the largest Minecraft creative fansite and community.

Activities

• Studied flat sales brochures, floor plans and elevation plans
• Analysed functionalist design philosophies and their evolutions in history
• Created 3D models in Minecraft to practice the use of space, proportions and forms
• Explored the development of public housing and school standards in Hong Kong
• Composed articles and diagrams to present my findings and thoughts
• Researched Le Corbusier's theories and building controls with real-life examples
• Experimented with different content delivery and product presentation approaches

Publications

• 8 Public Housing Buildings (6 HOS, 2 PRH)
• 2 Standard School Premises
• 1 Public Library Building

Areas of Interest

• Modular flat design
• Site-specific design approach
• Non-standard domestic blocks
• Building controls, Planning standards
• Flexi-school and Interlocking school standards
• Home Ownership Scheme, Public Rental Housing

Achievements

• Ranked 8th among 110 entries and 48 finalists in 2018 PMC Skyscraper Solo Contest
• Received "neat+" commendations from the contest judges in terms of content delivery
• Featured on PMC's Twitter, Minecraft: China Edition official blog, and various Chinese Minecraft forums
• Commended by renowned PMC members and site admins
• Referred to by the Owners and architecture students
• Among the most popular Hong Kong and educational maps on PMC

Project Page

In the project, I created a well-structured MySQL / MS Access relational database (populated with sample data), a functional VB.NET windows application that interfaces with the database, and a detailed report with attractive typesetting. The 200-page report describes the entire development process as follows:

Project Management

• Man-day Estimation
• Gantt Chart

Design & Implementation

• Requirements Analysis
• DBMS Selection
• UML Diagram
• Use Case Diagram
• Sequence Diagram
• Network Diagram
• Hardware Spec
• Data Modelling
• ER Diagram
• Cardinality Constraint
• Participation Constraint
• Integrity Constraint (Entity, Referential, Domain)
• ER to Relational Mapping
• Database Schema
• Normalisation
• Order of Creation and Data Loading
• SQL DDL and DML
• Sample Data Loading
• User Interface
• Report Layout

Testing & Evaluation

• Unit Test
• Full Procedure Test
• Special Case Test
• Scenario Test

Conclusion & Discussion

• Limitation
• Strength
• Improvement
• Self Reflection

This SBA project was highly commended by my school instructor and received a grade of 99 out of 100 from the HKEAA.

2017 marked the final session for project-based SBA. After that, projects were replaced with in-class guided tasks. I'm really thankful I had the opportunity to practice the entire development lifecycle in high school, turning theories into action.

Project Page