Data Analyst · BI Engineer · Analytics Specialist
Data Analyst with 3+ years turning complex data into clear business decisions.
I've shipped analytics pipelines processing 1M+ transactions annually, built executive dashboards in Tableau, Power BI, and SSRS, and cut manual reporting overhead by 65% through automation. Deep SQL expertise with a track record of improving query performance and data quality. I also ship web work like the WCE Studio site when a product needs a considered front end.
Live sample · drag the range
Scrub the slider under the chart to inspect a week. Built with the same Plotly stack I use in demos.
How I turn a messy ask into a dashboard stakeholders actually use — scope first, model the grain, then ship a view with one job.
Translate the ask into one measurable outcome and the few KPIs that move it.
Lock facts, dimensions, and freshness rules before writing transforms.
dbt/SQL models with schema tests so dashboards inherit trustworthy tables.
One dashboard, one decision job — then measure whether reporting load actually dropped.
-- Grain: one row per ticket per day
with ticket_daily as (
select
date_trunc('day', created_at) as day,
channel,
count(*) as tickets,
avg(resolution_hours) as avg_resolve_hrs
from {{ ref('stg_tickets') }}
where created_at >= dateadd(day, -90, current_date)
group by 1, 2
)
select * from ticket_dailyOutcome first. Expand a row for problem → query → dashboard frame → impact.
Live dashboards on wildlife–aircraft collisions, NYC street trees, and media ratings — published for anyone to explore.
Expected November 2026 · Victoria, BC
Automated reporting pipelines, optimized SQL workloads, and shipped executive dashboards for Finance and Operations.
Reduced manual reporting effort by 65% by redesigning 8+ workflows into automated pipelines, saving 20+ analyst-hours per month. Improved query performance by 42% across SQL Server, PostgreSQL, and Redshift through indexing and query restructuring. Built Tableau, Power BI, and SSRS dashboards delivering executive KPI views for 4+ teams. Engineered Python and T-SQL pipelines processing 1M+ transactions per year.
Read My Developer JourneySupply chain and inventory dashboards plus forecasting models for live KPI visibility.
Designed Tableau and Power BI dashboards for supply chain and inventory, giving 3 teams live KPI visibility. Wrote T-SQL queries and R/Python forecasting models that surfaced overstocking patterns for stakeholders.