Andrew Bilyeu

Cyber Governance, Risk, and Compliance Intern

Lockheed Martin | Summer 2025

• Spearheaded a database migration used in automated email communication, reducing runtime by 45% (45 min/run down to 20 min/run).
• Prepared for the ITGC Audit by remediating compliance issues across hardware/software, boosting compliance rates by ~30% over a domain of ~20,000 employees.
• Created an automated vulnerability notification system, cutting processing time by 58% (4 hrs → 2.5 hrs).
• Built an automated IT Systems Inventory classifier, improving efficiency by 20% by cutting the amount of checks needed to integrate sources into a database by 1 per data source.

Lifeguard

City of Aurora | June 2022 – Present

Front Range Recreation | June 2023 – Present

• Ensured patron safety and successfully performed three rescues.
• Maintained vigilance and emergency response readiness in high-pressure environments.

Volunteer

Shalom Park | 2013 – Present

• Supported elder residents through community activities, boosting morale and engagement.
• Collaborated with coordinators to facilitate recreational programs.

CSV Inventory Automation Suite

Built Python tools to automate asset management and compliance workflows.

• compare_inventory.py – Automated reconciliation between database and new inventory files, matching by IP/hostname and producing clean matched/unmatched reports. - Used at Lockheed Martin
• split_csv.py – Implemented rules-based categorization system that classified assets into categories with wildcard and conditional logic, generating categorized CSV outputs. - Used at Lockheed Martin

Canvas File Scraper

Automated tool to download and organize Canvas course files. Built with Python and Canvas API to improve workflow efficiency.

Advent of Code Challenges

Solved algorithmic programming challenges in Python, focusing on parsing efficiency, modular design, and problem-solving under time constraints.

Portfolio Website

Personal site built with HTML/CSS to showcase projects, technical skills, and achievements in a responsive, recruiter-friendly layout.