LW
Hello, I’m

Lionel Wang

I build the systems companies run on — end to end, in production

0+ Years Experience
0 REST Endpoints
0K Lines of Code
0 Certifications

I am an IT systems and infrastructure engineer in Greater Vancouver. I started in 2022 as a system administrator at a furniture manufacturer. Since 2025 I have been the sole engineer of the ERP and automation platform two furniture manufacturers operate on daily — 274 tables across four databases. I own the schema, the backend, the front end and the deploys.

My work is data modelling, idempotent integrations, and access control enforced at one choke point. I build in Node, Express and MySQL, ship every screen in English and Chinese, and apply language models where the job used to be re-typing. I am open to platform, integration and internal tooling roles where one engineer owns the system.

What I Do

AI & Machine Learning

Function calling over live data, hybrid retrieval, IMAP commands, phishing detection.

System Administration

Windows/Linux servers, AWS, Google Workspace, network and endpoint hardening.

Full-Stack Development

Internal platforms and operator tooling on Node.js, Express and MySQL.

Cybersecurity

Security audits, penetration testing, DNS filtering, vulnerability scanning.

ERP & Automation

ERP and warehouse systems, accounting sync, EDI over SOAP, scheduled reporting.

Tech Stack

Node.js Express Python MySQL OpenAI GPT AWS Docker JavaScript HTML5 / CSS3 Bootstrap Puppeteer Flask REST APIs EDI Embeddings Linux Git Wireshark Node.js Express Python MySQL OpenAI GPT AWS Docker JavaScript HTML5 / CSS3 Bootstrap Puppeteer Flask REST APIs EDI Embeddings Linux Git Wireshark

Currently Learning

Kubernetes
RAG Pipelines & LangChain
Azure Cloud (AZ-900)
Terraform & IaC

Projects

Try It

Three runnable panels — an assistant sandbox, a recorded search rebuild, a caption planner.
AmaxBot · interactive

How it picks a tool, calls it and answers

Each run shows the routing decision, the tool call with its real argument shape, and the rows returned.

This is a sandbox. It runs in your browser on static sample data — fictional customers, no network calls, no database. The real assistant sits behind a login and reads live company data.

amaxbot — sandbox session sample data

Nothing has run yet

Pick a question above, or type your own below. Start here:

Free text is keyword-matched to the nearest of the eight sample questions, and the panel says so plainly when it cannot find one.

Case Studies

Four builds, each written as problem, mechanism, result.

AmaxBot — a GPT assistant that inherits the ERP’s permission model

AI / Node
Problem

Where is this order, is it in stock, what does this account owe — every answer sat behind SQL across four databases and 274 tables. Staff asked IT; IT answered hours later with a screenshot.

Built

Two surfaces over one accuracy layer: a chat UI exposing 55 function-calling tools, and an IMAP service answering 27 @amaxbot_* commands from a shared mailbox, each in English and Chinese.

Result

Staff query the ERP themselves, by chat or plain email. The tool catalog is filtered by role before the model sees it, so a non-admin request cannot contain a write tool; out-of-scope rows never reach the model.

The integration layer — EDI in, accounting out

SOAP / Accounting
Problem

Purchase orders arrived from trading partners over EDI, then the same orders and supplier bills were re-keyed by hand into two accounting companies. Nobody caught a transposed figure until month-end close.

Built

Inbound, a SOAP client against an EDI provider: pull partner purchase orders, return acknowledgment, ship notice and invoice. Outbound, an accounting hub of 6 connectors and 42 APIs posting sales documents and supplier bills on a daily schedule.

Result

Partner orders reach the ERP and both accounting companies without re-keying. Every push is idempotent, keyed on the document number, so a resend cannot double-post; a rejected batch is un-flagged and retried.

Knowledge-base search — rebuilt as hybrid retrieval

Embeddings / RRF
Problem

The knowledge base ran on one MariaDB FULLTEXT match — literal words only. Chinese failed outright: no CJK tokenizer, so a whole question arrives as one unmatchable token, and the Chinese columns sat outside the index.

Built

A retrieval layer embedding 26 articles as 110 chunks, fused with the existing FULLTEXT query by reciprocal-rank fusion. No vector database: 0.64 MB of Float32 blobs, cosine-scored as a dot product in Node.

Result

Five of eight staff questions returned rows before, one of them the wrong article; all eight now return the correct article, including three Chinese questions that returned nothing. It ships behind a flag and falls back to the old query.

Social Video Maker — script to vertical video

FFmpeg / TTS
Problem

Marketing needed a steady stream of Mandarin short-form video with no per-video budget and no editor in the loop: a publishable 1080×1920 file produced from pasted script text in a single pass.

Built

A standalone Node app: TTS narration, Ken Burns b-roll, a talking-head overlay driven by per-100 ms amplitude samples, burned-in captions, FFmpeg assembly, and progress streamed live to the browser. Every service in the chain is free.

Result

The free speech endpoint returns zero bytes for SSML breaks, so pacing is spliced silence and each caption boundary snaps to the nearest measured pause. Publish-ready in one pass, covered by a 130-case unit suite.

Other Projects

An envelope with a phishing hook through it

Email Phishing Detection

A Google Apps Script on a timed trigger submits links and attachment hashes to a reputation service, then a language model reads the body for pretext.

Apps Script ML ChatGPT API VirusTotal
A microphone beside a speech waveform

Voice Assistant

A Python desktop tool that transcribes speech in real time with Vosk running on-device, then answers questions against the running transcript.

Vosk ChatGPT API Python GUI Automation
Two systems exchanging documents in both directions

EDI & API Integration

Order and stock feeds between the ERP, marketplace back ends and warehouse systems, normalized to one order shape, upserts keyed on the partner’s document number.

EDI REST API Automation
An uptime chart with one incident marked

Network Monitoring

Scheduled probes collect link, latency and service-availability metrics into a time series, rendered as Grafana dashboards a non-engineer can read at a glance.

Networking Grafana Python
A stack of documents reconciled into one spreadsheet

Python Automation

Walks a folder of supplier PDFs and spreadsheets, extracts the tables, reconciles them against the ERP and writes an Excel exception workbook.

Python PDF Excel Automation
Two chat bubbles, the reply marked as drafted

Desktop Chat Assistant

A Python desktop app that watches an instant-messaging window, reads the thread with a vision model and holds each drafted reply for human approval.

Python Claude API Vision Automation
A wall-mounted camera filing footage to cloud storage

CCTV Archiver

Pulls recordings off a Hikvision NVR on a schedule and uploads them to S3 through presigned PUT URLs, so the device holds no AWS credentials.

Python AWS Automation
An article rendered in two languages

Bilingual News Digest

A Node service on a timezone-pinned cron that gathers industry news, summarizes each story in English and Chinese, and mails a rendered HTML digest.

Node.js Cron ChatGPT API i18n
A browser window filling in a form on its own

Browser Automation

Playwright scripts that drive a saved browser session to reach partner portals and upload the inventory feed, formerly posted by hand, roughly 177 rows a run.

Playwright Automation REST API

Web Design & Development

Aurora Furniture

Aurora Furniture home page
HTML5 CSS3 Responsive UI/UX

Amax Leather

Amax Leather storefront
HTML5 CSS3 E-commerce UI/UX

Standard Install

Standard Install home page
UI/UX Responsive SEO

Resume

Education

Jan 2024 – Dec 2024

Master of Science in Cybersecurity

New York Institute of Technology

GPA 3.74 — network security, cryptography, penetration testing, forensics.

Network Security Cryptography Pen Testing
Sep 2017 – Dec 2022

Bachelor of Technology in Information Technology

Kwantlen Polytechnic University

Major GPA 3.8 — web development, IoT, cloud security. CO-OP completed.

Web Dev IoT Cloud Security

Work Experience

Current
May 2025 – Present

IT Systems & Infrastructure Specialist

Amax Leather Canada Ltd & Aurora Furniture MFG

Sole engineer of the ERP and automation platform both companies run on: 1,048 REST endpoints, 274 MySQL tables, 150 pages, ~230,000 lines in production — plus the in-house GPT assistant, EDI and accounting integrations, and the dealer portal.

77 route files, 24 services, 726 scripts
AmaxBot: 55 function-calling tools + 27 email commands
Partner EDI over SOAP + a 42-API accounting hub
Node.js OpenAI MySQL SOAP / EDI AWS Playwright
Aug 2022 – Apr 2025

System Administrator

Amax Leather Canada Ltd

AWS infrastructure, automation tooling, GPT integrations, and security hardening.

EC2, S3 and IAM administration
OpenAI-integrated internal tools
Cybersecurity hardening & audits
AWS Python Linux Security
May 2022 – Mar 2023

Website Developer

Perfect Decor

Client websites and web apps: responsive layouts, SEO, and page-speed work.

HTML/CSS JavaScript UI/UX SEO

Skills

Languages

English

Fluent

Mandarin Chinese

Native

Certificates

NYIT New York Institute of Technology

Master of Science in Cybersecurity

Issued Dec 2024

Credential ID: 2VU9-7XT8-WEGQ

NYIT Certificate
KPU Logo Kwantlen Polytechnic University

Bachelor of Technology in Information Technology

Issued Jan 2023

KPU Degree
AWS Amazon Web Services

AWS Cloud Foundations

Issued Apr 2024

AWS Certificate
Fortinet Fortinet

Google Cloud Security 7.6 Administrator

Issued Feb 2025

Skills: Google Cloud Platform, Cloud Security

Fortinet Google Cloud Security Certificate
Fortinet Fortinet

Cybersecurity 1.0

Issued Jan 2025

Skills: Awareness, Risk Assessment

Fortinet Cybersecurity 1.0 Certificate
Fortinet Fortinet

Cybersecurity 2.0

Issued Dec 2024

Skills: Network Security, Threat Analysis

Fortinet Cybersecurity 2.0 Certificate
Fortinet Fortinet

FortiGate 7.6 Administrator

Issued Feb 2025

Skills: Firewall Administration

FortiGate Administrator Certificate