Data Analyst · BI Engineer · Analytics Specialist

Shadrack
Boateng Addo

I turn complex data into clear decisions. Dashboards, pipelines, and sites that help teams move faster.

View work Download resume

Based in Richmond, BC · Open to opportunities

Field notes

About

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.

Less manual reporting after automating 8+ workflows

Faster queries across SQL Server, PostgreSQL, Redshift

Transactions processed annually via Python and T-SQL

Teams supported with live executive KPI dashboards

Live sample · drag the range

Analyst hours saved per week

18.4 hrs / week

Scrub the slider under the chart to inspect a week. Built with the same Plotly stack I use in demos.

How I work

How I turn a messy ask into a dashboard stakeholders actually use — scope first, model the grain, then ship a view with one job.

Clarify the decision

Translate the ask into one measurable outcome and the few KPIs that move it.

Model the grain

Lock facts, dimensions, and freshness rules before writing transforms.

Transform with tests

dbt/SQL models with schema tests so dashboards inherit trustworthy tables.

Ship the view

One dashboard, one decision job — then measure whether reporting load actually dropped.

models/marts/fct_tickets.sql dbt · incremental

-- 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_daily

Websites I've built

Live sites in production. Each one solves a specific job — from immigration math to editorial storytelling to public-service search.

canadacitizenshipcountdown.com

Live

Design + Build · 2026

Canada Citizenship Countdown

A countdown app that calculates when you become eligible for Canadian citizenship using official IRCC rules. It tracks days as a temporary resident, days as a permanent resident, and time spent outside Canada across the rolling 5 year window. Also available as an iOS app on the App Store.

Next.js TypeScript IRCC rules engine iOS

Visit site iOS app

wcestudio.com

Live

Design + Build · 2025

WCE Studio

Portfolio and consulting site for Whitney Chinonye Ernest — African data artist and creative documentation consultant. Editorial layout that showcases work and services without card clutter.

Next.js HTML/CSS JavaScript Responsive

Visit site

ghana-hospitals-finder.onrender.com

Live

Design + Build · 2024

NkwaSafe

An emergency first aid guide and hospital finder for Ghana. Walks users through what to do in a medical emergency, then helps them locate nearby facilities filtered by services and specialization.

Python Flask JavaScript APIs

Visit site Code

Education

University of Victoria

Bachelor of Computer Science, Minor in Economics

Expected November 2026 · Victoria, BC

Database Systems
Software Engineering
Statistical Analysis
Data Mining and Machine Learning

Experience

2023-25

Data Analyst and BI Developer

Karrio (Startup)

July 2023 to December 2025 · Remote

Automated reporting pipelines, optimized SQL workloads, and shipped executive dashboards for Finance and Operations.

Selected impact

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 Journey

Toolkit

Python T-SQL PostgreSQL Redshift Tableau Power BI SSRS ETL

2022-23

Data Analyst Intern

Boat Star Foods

September 2022 to April 2023 · Remote

Supply chain and inventory dashboards plus forecasting models for live KPI visibility.

Selected impact

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.

Toolkit

Tableau Power BI T-SQL Python R

Shadrack
Boateng Addo