A clearer picture.
A better way
forward.

I’m Jonathan. I work through messy data, complicated processes, and practical problems to help people make better decisions.

Explore my work View resume

SQL · Python · R · Tableau · ExcelAnalysis with an operational perspective

01 / Work in practice

Complex problems.
Useful solutions.

Work from Viasat and Amazon, covering reporting, process improvement, and tools built around real operational needs.

View all projects

Complete Spotfire live dashboard with station distribution, open WiFi deferrals, station visits and expanded routing; logpage IDs and maintenance comments blurred. — Preview · Live maintenance dashboard · logpage IDs and comments blurred

ViasatOperations

Aircraft maintenance reporting that helps people act

Working reporting workflow

Joining supported aircraft, open deferrals, and flight schedules to identify maintenance opportunities.

SQLSpotfireExcel

Read case study

Inventory stock dashboard with location filters, counts across eight equipment categories, and minimum and maximum stock indicators. — Preview · Stock overview · location filters and minimum/maximum indicators

ViasatOperations

Six station inventories, one usable process

Built application and reporting workflow

Standardized records, matched updates by serial number, and built an interface for intake, installation, and inventory review.

ExcelSharePointPower Automate

Read case study

OvertimeRequester request review and editing side by side: week and shift filters, approval actions, request statuses, and editable date, hours, and notes; personal names blurred. — Preview · Request review and editing · names blurred

OvertimeRequesterOperations

Overtime requests, without the back-and-forth

Deployed application

A Slack workflow for requests, approvals, shift availability, and a recorded decision history.

PythonSlackAWS Lambda

Read case study

First-year scenario chart separating replacement avoidance and management capacity in gross benefit totals of $183,320 and $288,320, with $87,360 in base wages shown separately. — Preview · First-year model · wage and benefit comparison

Retention and cost analysisAnalysis

Putting a cost around a workforce bottleneck

Proposal and financial model

A scenario model comparing wage investment, avoided replacements, and management capacity.

PythonpandasExcel

Read case study

A practical approach

The analysis matters.
What happens next matters too.

My background is in environments where a missing part, an unclear process, or an overlooked pattern has real consequences. That experience shapes how I approach data: understand the situation, check the assumptions, and make the result useful to the people doing the work.

More about my approach

02 / Analytical foundations