Andrew (Drew) Brown

Andrew’s flagship solo project and the strongest expression of his engineering style: local-first, reliability-focused, architecturally deliberate, and built for daily real use rather than demo value.

• Architected a layered system across Core, Services, Database, and UI with an explicit composition root for lifecycle management.
• Designed an intent-driven command bus where frontend intents route to backend handlers and emit events back over WebSockets.
• Built crash-resilient AudioSpool real-time WAV streaming that survives process interruption.
• Implemented five refinement levels using Qwen3 4B, 8B, and 14B with safety invariants and token-budgeting.
• Used SQLite WAL mode, FTS5, and 10+ forward-only migrations for durable local persistence.
• Delivered cross-platform support for Linux, macOS, and Windows, plus installers, analytics, tags, export, bulk actions, auto-refine, and auto-title.
• Maintains a 23-chapter dev diary, “Speaking into Existence,” chronicling architecture, rewrites, migration choices, AI pairing, and lessons learned.

• Designed a 30+ table normalized relational schema for a single-guild Discord bot.
• Modeled events with a lean parent table and type-specific child tables for messages, voice sessions, and role changes.
• Designed a rule engine with named rules, event scoping, parameterized predicates, multiple outcome types, cooldowns, and deduplication.
• Included seasonal competitive periods, dual-currency gamification, full Discord entity modeling, migration tracking, expression-based uniqueness, and partial indexes.
• Kept all important data queryable in SQL rather than hidden inside JSON columns.

• Built the first REST interface for Spark entities in a student-led microblogging platform.
• Works inside an architecture that anticipates REST, gRPC, AMQP, JDBC, and R2DBC based service integration.
• Uses a question-and-answer design methodology: define what the system must answer, then let that drive storage and organization.
• Current trajectory includes authorization, richer entities, basic UI, infrastructure as code, and cloud deployment.

• Maintains a 6-VLAN segmented homelab with dedicated management, services, lab, internal, clients, and IoT networks.
• Runs two-server infrastructure: Ryzen 7 5800X with 64 GB RAM and Intel NUC with 32 GB RAM.
• Hosts Plex, Minecraft via AMP, Pi-hole, Unbound, UniFi, Graylog, Uptime Kuma, MinIO, Immich, Arr stack through Gluetun, apt-cacher-ng, and a honeypot lab.
• Maintains resettable vulnerable VMs and containers for cybersecurity club exercises with retained Graylog data across weekly resets.

• Built a personal portfolio and blog from scratch with GitHub Pages deployment via Actions.
• Created an interactive presentation viewer with keyboard navigation and fullscreen support.
• Built an NCL report viewer, GitHub contribution heatmap, animated starfield, and Medium cross-post integration.
• Designed the site’s visual identity directly with strong opinions on motion, presentation, and non-generic interface feel.

• TCOP Pages: reconstructed and refactored Franklin University Technology Community of Practice web pages.
• Introduction to Artificial Intelligence: produced a five-episode YouTube series covering AI fundamentals and architecture.
• RimWorld AI Storytelling Mod: C# concept integrating procedural AI-generated narrative recaps into gameplay.
• EMT Conduit Cable Management System: 3D-printed physical product prototype for cleaner post-drywall cable runs.
• BookBot: completed Boot.dev project work in Python.
• Custom Water-Cooled PC Build: built and daily-drives a custom-loop RTX 3090 Debian workstation.

Maintained electronic security infrastructure across Huntington Bank branch locations through a contractor responsible for branch security systems.

• Performed upgrades, preventative maintenance, and troubleshooting across networked security systems.
• Worked with bank-grade DMP panels, IP cameras, NVR/VMS systems, vault systems, and related operational infrastructure.
• Reduced repeat failure modes through structured restoration workflows and systems-level diagnostics.

• Installed and serviced networked electronic security systems.
• Completed 30+ DMP burglary system takeovers and CCTV deployments.
• Used DMP Remote Link, Wireshark, and Wisenet Device Manager for integration troubleshooting.
• Produced technical guides and supported training for 12+ technicians.

• Planned and executed network installations and rehabilitations for SMBs supporting 50+ end users.
• Deployed and configured 50+ Ubiquiti and MikroTik devices across routing, switching, and wireless.
• Managed a deployment delivered two weeks early and improved client network performance by roughly 30%.
• Planned and deployed scalable point-to-point radio internet supporting approximately 74 households.

• Monitored and triaged network performance issues using PRTG and Grafana.
• Coordinated escalation and restoration during high-alert periods.
• Resolved 100+ PagerDuty equipment alerts and produced remediation-ready site reports.

• Installed and maintained residential wireless internet systems.
• Performed on-site diagnostics for connectivity and performance issues.

• The Original Mattress Factory, Sales Associate: built spreadsheet automation linking Google Forms, Microsoft Access reports, and graphical presentation outputs for annual business reporting.
• Barton Mines Corp, Entry Level Operator: managed shipping and receiving, forklift operation, material staging, and logistics under COVID-era operational pressure.
• Under Armour, Sales Associate: supported retail floor operations through Black Friday conditions.
• The Sagamore Resort, Room Service: trained new hires, coordinated VIP deliveries, and worked under intense timing pressure.
• The Adirondack Experience, Cafe Assistant: first long-term professional role; developed foundational customer service, teamwork, and execution discipline.

• Designs and delivers programming workshops centered on problem solving, systems thinking, and collaborative development.
• Has helped overhaul student club direction and make architectural decisions for shared club infrastructure, including Synapse.
• Has delivered approximately 36 workshops and presentations across Programming SIG and Cybersecurity SIG combined.

• Designs and delivers defensive-security presentations and supports hands-on learning initiatives.
• Architected a student lab environment with honeypot VMs, VLAN isolation, WireGuard access, and retained Graylog logging.

• Publishes technical reflections on systems design, local-first tooling, and applied AI.
• All 7 published Medium articles are cross-posted to the site blog.
• Maintains a 23-chapter “Speaking into Existence” dev diary; 2 chapters are currently published and the full set is ready for revision and release.

• Fall 2025: Team Leader, 20th out of 4,674 teams; Individual rank 121st.
• Spring 2025: Team Leader, 71st nationally; Individual rank 238th.
• Documented contributions across OSINT, cryptography, password cracking, log analysis, network traffic, forensics, scanning, web application work, and reverse engineering.
• Used tools including exiftool, CyberChef, hashcat, John the Ripper, Wireshark, tshark, Burp Suite, sqlmap, Gobuster, Scapy, binwalk, Volatility, Ghidra, ldapsearch, and snmpwalk.
• Translated competition work into student-facing methodology, writeups, tooling, and a full NCL prep briefing for the following season.

Current enrollment includes MIS 310 — Information Systems Architecture & Technology. Relevant completed coursework covers programming fundamentals, databases, cloud architecture, web development, discrete math, and information security.