William McVicar
available · internships, grad roles, contract work
Computer science student building end‑to‑end systems.
Relational database design and SQL, data pipelines and visualisation, and the hardened Linux servers they run on. Currently running two live sites on a self-managed server while finishing a BSc in Computer Science, with a minor in Data Analytics, at the University of Waikato.
Selected work
5 projects-
matthewjeromson.com
PHP · Apache · Oracle Cloud VPS · Cloudflare · Let's Encrypt · Cron · Composer · GitHub Actions
Publication and profile site for an academic. Built, deployed and maintained solo. Diagnosed a silent data-pipeline failure and re-architected scraping onto a scheduled VPS cron job, then provisioned and hardened the Ubuntu server it runs on.
-
willmcvicar.com
HTML · CSS · JavaScript · PHP · Composer · Apache · Cloudflare · Let's Encrypt · GitHub Actions
Second production site on the same hardened VPS via Apache virtual hosts, with its own TLS certificate, isolated logging and deploy pipeline. The PHP contact form validates server-side, filters spam with a honeypot and rate limiting, and delivers over authenticated SMTP with SPF/DKIM. Security headers are set at the web-server layer.
you are here -
Strength Training Planner
React Native · Expo · TypeScript · SQLite · Drizzle · Jest · GitHub Actions
Free, offline-first iOS and Android app for following structured lifting programs: loads calculated from a training max, PR detection and end-of-cycle reviews, with no accounts, backend or tracking. Built spec-first, with requirement IDs traced from the specification through tests to commits and CI that must pass.
-
Inventory Tracking
FastAPI · PostgreSQL
Stock management system for a client: a FastAPI service over a PostgreSQL database.
-
Coaching Platform
React · Node.js · TypeScript · relational design
Full-stack platform built in an agile team for an external client, as part of the COMPX374 industry project.
Degree
bsc · computer science, data analytics minor · completing 20262026 year three · in progress
-
compx301Design and Analysis of Algorithms
Complexity, P/NP/NP-hard; implemented simulated annealing and LZ78 compression.
completed -
compx316Network Security
Configured live networks and practised attack and defence in FRR routing.
completed -
compx323Advanced Database Concepts
Relational design, joins, filtering and aggregation in SQL on MySQL.
completed -
compx361Logic and Computation
State automata and Turing computability.
enrolled -
compx374Software Engineering Industry Project
Team delivery of a software product for an external client: the coaching platform above.
enrolled
2025 year two · 6 papers
-
compx201Data Structures and Algorithms
Implemented core data structures to compare use cases and complexity trade-offs.
-
compx202Mobile Computing and Software Architecture
Built an Android app end to end as a group in Android Studio, with Maps API integration.
-
compx225Introduction to Databases and Web Development
Relational database principles and web development fundamentals.
-
compx234Systems and Networks
Networking principles through a Java implementation of client-server interaction.
-
compx235Cybersecurity Engineering
Security architecture in practice: SSH, firewalls, attack and defence techniques.
-
compx310Machine Learning
Data modelling and training processes, implemented in Python with NumPy and pandas.
2024 year one · 7 papers
-
busan205Data Analytics with Business Applications
Data analysis applied to business decisions.
-
compx101Introduction to Programming
Foundational paper.
-
compx102Object-Oriented Programming
Foundational paper.
-
csmax175Introduction to Cyber Security
Foundational paper.
-
csmax270Cultural Perspectives for Computing and Mathematical Sciences
Kaupapa Māori perspectives and their place in software design and data sovereignty.
-
datax201Practical Data Science
Practical data analysis in R and RStudio.
-
datax221Statistical Data Analysis
Modelled and analysed complex datasets in R and reported the conclusions.
Open to internships, grad roles and contract work.
Based in Hamilton, Aotearoa New Zealand. Happy to talk about backend systems, databases, infrastructure or a project you're planning.
Alongside study: five years in healthcare administration, keeping patient records accurate and confidential and working with clinical staff under pressure.