Project Archive

High-impact analytics programs, end-to-end.

Each initiative below combines product framing, data modeling, and technical execution. The chart reflects directional performance signals from repeated delivery patterns.

Click any project to read the full case study

Impact Map

GenAI Analytics Agent

Shifted recurring analytics questions from analyst queue to stakeholder self-serve flow.

Days → Minutes

Insight turnaround

Recurring pharmacy ops questions resolved in-session.

NL → SQL

Interface delivered

Natural-language prompts converted into query-ready analysis.

Self-Serve

Decision velocity

Stakeholders run deep dives without waiting for analyst bandwidth.

How It Shipped

1

Documented schemas, join keys, and metric semantics.

2

Created reusable query patterns for operational questions.

3

Connected outputs to dashboard workflows for fast action.

PythonAWSNLPSQLAnalytics UX
01

Personal Project · 2025

GenAI Analytics Agent

LLM-powered query assistant that translates natural language into SQL — built to explore how analytics teams can reduce stakeholder dependency on manual reporting.

Prototyped against a pharmacy operations schema; demonstrated days-to-minutes insight turnaround for recurring business questions.

PythonAWSNLPAnalytics UX
Try it
02

Clarke Power · 2020

Digital Inspection App

Replaced paper-based vehicle inspection workflows with a mobile-first product used by field technicians.

Improved technician completion velocity by 60% while creating high-quality maintenance telemetry.

ProductOperationsMobileData Capture
03

Clarke Power · 2019

Customer Stratification Model

Built a segmentation model connecting customer patterns to revenue potential and service risk.

Refocused commercial motion on the highest-value customer cohort and simplified account prioritization.

SQLModelingGo-to-MarketDecision Science
Try it
04

Amazon Pharmacy · 2024

Snowflake to Redshift Migration

Led an end-to-end migration of storage, ETL orchestration, and reporting dependencies for analytics workloads.

Reduced annual infrastructure spend by $1.4M while improving operational reliability and ownership.

RedshiftETLCost EngineeringPlatform

Next

Want to see how these programs map to role progression?