David Cao

IT professional with coding and cloud expertise

About

I'm an IT professional who manages enterprise platforms and builds the tools that keep them running. My work spans Go development, PowerShell automation, and cloud infrastructure — mostly pipelines, integrations, and anything that replaces a manual process. I'm most at home at the intersection of IT and development, where a bit of code solves a real operational problem.

Skills

Programming & Scripting

Go (Golang) Python Bash Angular YAML/JSON Parsing SQL C++ REST API PowerShell Selenium

MDM & Endpoint Management

Microsoft Intune Mosyle NinjaOne Sophos WorkSpace One ScreenConnect Apple Remote Desktop Google Admin Console

Virtualization & Cloud

GCP AWS Azure Oracle VM VirtualBox Hyper-V VMWare ESXI ProxMox

Operating Systems

Windows macOS Linux ChromeOS

Projects

⚡

ETL Data Flow Automation

Built ETL pipelines to automate data extraction, transformation, and loading across district systems — syncing user records, device inventory, and operational data between platforms to eliminate manual entry and ensure consistency organization-wide.

SQL Go PowerShell REST API

🔗

Identity & Directory Consolidation

Unified Google Workspace, Microsoft Entra ID, and Active Directory into one system — cross-platform password sync, automated license assignment, and full account management from onboarding through offboarding.

Entra ID Active Directory Google Workspace IAM

☁️

Cloud Platform Management

Manage infrastructure across GCP, AWS, and Azure — GCP is the main platform. Migrated key workloads to Cloud Run for containerized services, Cloud Functions for event-driven automation, and Compute Engine for persistent VMs. The result was better uptime, lower costs, and less operational overhead.

GCP Cloud Run Cloud Functions Compute Engine AWS Azure

🖥️

Enterprise Machine Deployment

Managed district-wide machine deployment across Windows, macOS, and mobile platforms using Intune, Workspace ONE, Mosyle, and Apple School Manager. Set up Sophos for endpoint protection, Proofpoint for email security, and ScreenConnect alongside Apple Remote Desktop for remote access. Automated configuration, policy enforcement, and provisioning through Ansible.

Intune Workspace ONE Mosyle Apple School Manager Sophos Proofpoint Ansible

🌐

Internal Web Application

Custom web apps built to fill gaps in district SIS and LMS platforms, serving 20,000+ users.

Grade Center — teacher analytics and custom reporting not available natively in SIS/LMS
Student ID App — PWA with custom badge generation and event management
Parent Portal — families track student progress and complete critical school-year processes, backed by SQL with automated data pipelines

Go Angular SQL PWA REST API

🏠

Personal Projects & Homelab

A collection of self-hosted infrastructure and automation projects running 24/7.

Proxmox Lab — LXC containers running Home Assistant, AdGuard Home, Jellyfin media server, and SMB file shares across the local network
Reservation Bots — scripts that monitor and notify for Global Entry appointment slots, Kirby Café bookings, and campsite availability
WireGuard VPN — self-hosted tunnel for secure remote access to the homelab from anywhere in the world
Finance Dashboard — personal spending tracker that aggregates transactions and visualizes trends with custom category breakdowns

Proxmox Go Python Home Assistant WireGuard LXC

Achievements

🏆

Employee of the Year

Congratulations to our 2024 HBUHSD District Office Classified Employee of the Year, David Cao!🤩 David is our Systems Analyst in the tech department. He is always available to help with any technical issues, big or small, with a smile on his face and is one of the most kind, genuine, and hard-working individuals. We're so grateful for everything you do and can't think of a better person who is more deserving of this recognition!💙🧡