Project 01 · Data Visualization
Applications Dashboard
HTML / CSS / JS
Personal
A dashboard tracking a live job search across 180+ applications. Renders status breakdowns, interview conversion rates, and sourcing comparisons visually from a structured data source.
Markdown Tracker
→
Parse & Count
→
Chart.js
→
Live Dashboard
View live ↗
HTML
CSS
JavaScript
Chart.js
Project 02 · Automation
Rate Data Pipeline Tool
Python
Corporate
At iPipeline, every time an insurance carrier sent updated rate data, someone had to manually reformat it, run tests, and produce a clean file to plug into our system. It took a while and the margin for error was real. I wrote a Python script that handled the whole thing.
Carrier Excel
→
Parse & Map
→
Test Grid
→
Audit Log
→
Engine File
The script read in the carrier's sheet, mapped their column names to our engine's format, generated a test grid to check the outputs, flagged anything outside expected ranges in an audit log, and spat out a finished engine file ready to go into the system.
# Simplified example of the core mapping logic
import pandas as pd
def process_carrier_rates(input_file):
df = pd.read_excel(input_file)
# Map carrier columns to engine format
engine_df = df.rename(columns={
'Age Band': 'age_range',
'Monthly Rate': 'rate_monthly',
'Effective Date': 'eff_date'
})
# Flag rows that fall outside expected ranges
audit_flags = engine_df[engine_df['rate_monthly'] > threshold]
return engine_df, audit_flags
I put together a presentation on it for senior leadership as part of a broader effort to get the team thinking about where automation could actually save time.
Python
pandas
openpyxl
Excel
AI-assisted development
Project 03 · AI Workflow
Content Production with AI
Workflow
Content Strategy
Most of my content work involves AI at some point now, not to write things for me but to move faster on the parts that don't need my full attention. Here's what that actually looks like in practice.
AI is good at structure. It's bad at voice. Knowing which parts to hand off is the whole skill.
-
Brief and research
I conduct research and use AI to help surface angles, fill in gaps, and get a skeleton down. Audience, platform, goal, and tone are set before anything gets written.
-
Write and edit
Writing is mine. I'll use AI for specific rewrites on a sentence level, but nothing goes anywhere without a full pass from me first.
-
Style check
AP Style pass and brand voice review. If it sounds like it came from a chatbot, it gets rewritten. The audience can tell and so can I.
-
Platform cut
The same approved content becomes a LinkedIn post, an Instagram caption, a newsletter blurb. Each one gets adjusted for how people actually read on that platform.
ChatGPT
Claude
AP Style
CMS
Notion