Academic Portfolio

Featured Projects

These are some projects I completed during my time at LSU. That both expanded my skillset and furthered my knowledge of how to create different systems.

PDF Briefing Slide Healthcare Sector Cyber Risk Assessment NIST SP 800-30 Slide Preview
Click to Open Document →
Cybersecurity & IT Risk NIST SP 800-30 Assessment

Healthcare Sector Cyber Risk Assessment

Threat Vector Analysis, Historical Breach Data & Defense-in-Depth Strategy

This is a one-slider that sums up a series of projects completed for Professor Burns ISDS 4096: Cyber-risk Management Course. This comprehensive cybersecurity risk assessment analyzed threat surfaces and vulnerabilities across the medical sector under the NIST SP 800-30 framework. Evaluated historical healthcare breaches, modeled incident frequency trends, and created specific mitigations.

  • Framework: NIST SP 800-30 methodology evaluating threat likelihood and medical impact
  • Breach Investigation: Analyzed Anthem Inc. (~80M records affected), LSU Health New Orleans, and Walgreens
  • Threat Locations: Identified Network Servers, Email Spear-Phishing, and Stolen Hardware
  • Defense-in-Depth: MFA, IDS/IPS intrusion prevention, third-party vendor audits, and end-to-end data encryption
NIST SP 800-30 Cybersecurity Threat Modeling Healthcare IT / HIPAA Data Analytics Defense-in-Depth
PDF Document • 14 Pages Nordstrom Rack ER Diagram and Relational Database Schema
Click to Open Document →
Database Architecture & SQL The Big 5 • Technical Report

Nordstrom Enterprise Database & SQL Analytics

Relational ERD, Normalized 3NF Schema & 10-Query Business Intelligence Suite

This was a in-depth project completed for Professor Ahemd's ISDS 3110 Database Class. End-to-end relational database engineered for Nordstrom Rack (~300 nationwide retail locations). Co-developed with "The Big 5" team at LSU, encompassing conceptual ER modeling, 3NF schema normalization, full MySQL DDL creation scripts, and complex analytical queries.

  • Architecture: Complete ER Diagram & Relational Schema across 10 business entities
  • SQL Engineering: DDL scripts (CREATE TABLE, FK constraints), data dictionary, and seed datasets
  • Analytical Matrix: 10 SQL queries with multi-table JOINs, Subqueries, HAVING clauses, and cost audits
  • Team Project: Co-created with Kayla Goudy, Isaac Joyner, Nicholas Mwenye, and Sarah Reid
SQL / MySQL Relational Database Design ER Modeling (ERD) Normalized Schemas (3NF) Business Intelligence Query Optimization