This repository holds the source for my portfolio site and gives a shorter map of the work spread across my GitHub.
My background is in HR data analytics and automation. I am also finishing a master's degree in cybersecurity, so my public projects now cover secure software, application security, Hack The Box, threat modeling, Python automation, SQL, VBA, and Android development.
| Area | Repository | What is there |
|---|---|---|
| Security Engineering | Security Engineering Projects | Secure software, threat modeling, architecture review, Python, VBA, Android, database work, and engineering research tooling |
| Application Security | Application Security Labs | WebGoat, Juice Shop, SQL injection, CSRF, static analysis, TypeScript remediation, and retesting |
| Offensive Security | Offensive Security Labs | Hack The Box writeups, enumeration, exploitation, troubleshooting, and privilege escalation |
| GitHub Profile | andyspyro | The quickest view of my current work and proof links |
A full stack Node.js and Express application with SQLite, Socket.IO, authentication, RBAC, CSRF protection, rate limiting, moderated music controls, and audit logging.
My most complete Hack The Box writeup. I have retained evidence for the full path from source review and command injection to a service account, user access, and root.
Static analysis with Semgrep and SonarQube Cloud, local SQL injection testing, TypeScript source review, query remediation with bound values, rebuilding, and retesting.
Used REA, PowerShell, Chrome DevTools Protocol, and Codex for browser-based JavaScript reverse engineering. Examined a practice app and Wikipedia, then investigated YouTube's player controls and mid-roll advertising implementation. The YouTube source investigation reported 34 checked anchors for cue timing, possible ad prefetch, ad layouts, and conditional content restoration; server-side selection and live end-to-end mid-roll execution remain unverified.
Reverse engineering project · YouTube mid-roll investigation
A hands-on forensic examination of a derivative JPEG using ExifTool, ImageMagick, OpenCV, Pillow, binwalk, jpeginfo, ICC/EXIF analysis, JPEG compression analysis, ELA, noise residuals, PRNU fundamentals, hashing, and evidence-based attribution. The case study documents both technical findings and the limits of identifying an original camera after metadata stripping and recompression.
Sanitized professional work covering hiring and vacancy reporting, data quality, cross system reconciliation, workflow tracking, Power BI, Excel automation, and recurring audit logic.
A multi version Python automation project with local model integration, system diagnostics, Windows automation, voice features, research workflows, local memory experiments, and visual tooling.
Kotlin and Jetpack Compose work. The Reply Time Tracker has retained source. I also tested an HR workflow prototype, but I do not have the original source for that second app anymore.
| Area | Tools and technologies |
|---|---|
| Security | Nmap, Burp Suite, Hack The Box, WebGoat, Juice Shop, Semgrep, SonarQube Cloud, Flawfinder, ExifTool, ImageMagick, OpenCV, binwalk, jpeginfo |
| Development | Python, JavaScript, Node.js, TypeScript, SQL, Kotlin, HTML, CSS, EJS |
| Systems | Windows, Linux, WSL, PowerShell, Bash, SSH, TCP/IP, DNS, DHCP |
| Data | Power BI, Excel, VBA, Smartsheet, reconciliation, workflow tracking, reporting automation |
| Security Design | STRIDE, data flow diagrams, trust boundaries, IriusRisk, RBAC, session security, audit design |
| Mobile | Android Studio, Kotlin, Jetpack Compose, Material 3 |
I keep real employee and applicant data, private credentials, HTB flags, private keys, internal system identifiers, and local configuration out of the public repositories.
When I no longer have original source, I say so instead of rebuilding it and presenting it as the original project.