Nathan Bryson

Projects

A few things I've built and shipped. Most repos include a README with data, steps to run, and visuals.

Data Pipeline Automation

End-to-end Python pipeline that extracts data from thousands of PDFs, populates Excel sheets, uploads records to a SQL Server database, and auto-generates violation notices (NOVs) ready for manager signature. The extraction phase alone has saved over 760 hours of manual labor.

Extraction

PDF parsing & data entry

Python reads and extracts structured data from thousands of PDF documents, maps fields to Excel templates, and stages records for database upload.

PythonpandasPDF ParsingExcel
Database

SQL views & reporting

Custom SQL views surface the right data for each report type. Python pulls from these views to auto-fill NOV templates, cutting 10-15 minutes per notice.

SQL ServerViewsAutomation
Impact

Results

760+ hours saved on document processing. At 500 NOVs per year, the report generator saves an additional 125 hours. Notices now only require a manager's signature.

760+ hrs saved125 hrs/yr (NOVs)

Response Time Automation

Automated intake-to-dashboard pipeline reduced response time from 4 days to under 3 hours by removing manual handoffs.

Extraction

Data ingestion

Python parses structured emails/Excel, normalizes fields, and writes a single source-of-truth table.

PythonExcelETL
BI

Power BI dashboard

KPIs for SLA, backlog, and throughput with DAX measures; auto-refresh via gateway.

Power BIDAXGateway
Impact

Results

Single-pane status visibility; bottleneck alerts; consistent audit history for handoffs.

AutomationAlerting

Wins Tracker

A React wellness app designed for people struggling with anxiety or self-doubt. Users log personal wins, revisit them on demand for a confidence boost, and access motivational quotes and crisis resources when they need them most.

App

Win logging & recall

Users add personal wins and can have past wins surfaced back to them at the press of a button, reinforcing positive self-reflection.

ReactState ManagementUI/UX
Wellness

Motivational content

Built-in motivational quotes rotate to provide encouragement alongside the user's own recorded achievements.

ReactContent Design
Safety

Crisis resources

Includes direct links and phone numbers to crisis helplines, ensuring support is always one tap away for users having a tough time.

AccessibilityMental Health

Let's work together

Have a role or collaboration in mind? I love automating tedious workflows and building clear visuals from real-world data.