BEN MANGUIATData · Systems · Scrum
BEN MANGUIATSYSTEM ARCHITECT & ANALYST

Data Analytics.
Business Systems.
Agile Delivery.

I turn complex raw data and vague business requirements into organized relational systems, executive insights, and actionable delivery.

VIEW CASE STUDIESGITHUB REPOSITORIES ↗
ARCHITECTURAL SYSTEM NODE MAPX: 0.0 | Y: 0.0
SYSTEM STATE: READYCLICK NODE TO FILTER
CORE COMPETENCIES

Data, Systems & Agile Delivery

Combining technical data analytics proficiency with structured Agile Scrum leadership and relational systems architecture.

Data & Analytics

Extracting actionable insight from complex datasets

  • SQL (PostgreSQL, MySQL, Snowflake)✓
  • Python (Pandas, NumPy, SciPy)✓
  • Power BI & DAX Modeling✓
  • Tableau & Data Storytelling✓
  • ETL Pipelines & Data Cleanse✓
  • A/B Testing & Hypothesis Testing✓
  • Excel (VBA, Power Query, Pivot)✓
EXPLORE DATA & ANALYTICS →

Project Management & Scrum

Driving agile delivery and stakeholder alignment

  • Agile & Scrum Frameworks✓
  • Sprint Planning & Ceremonies✓
  • Jira & Confluence Administration✓
  • Backlog Refinement & User Stories✓
  • Stakeholder Communication✓
  • Risk & Dependency Management✓
  • Velocity & Capacity Planning✓
EXPLORE PROJECT MANAGEMENT & SCRUM →

Business & Systems Analysis

Bridging business objectives with technical solutions

  • Requirements Elicitation (BRD/FRD)✓
  • BPMN Process Modeling✓
  • Relational Database Architecture✓
  • API Specifications & Integrations✓
  • Information Systems Strategy✓
  • Cost-Benefit & Feasibility Analysis✓
EXPLORE BUSINESS & SYSTEMS ANALYSIS →
SELECTED WORK

Featured Case Studies

In-depth systems, data models, and project delivery frameworks demonstrating end-to-end analytical problem solving.

01Data & Analytics

Northstar Commerce Executive BI Dashboard & Data Pipeline

PostgreSQL Data Pipeline, Star Schema Dimensional Modeling & Power BI

Engineered an end-to-end PostgreSQL data analytics pipeline and interactive Power BI Executive Command Center to diagnose margin decay ($5.94M revenue, $2.29M profit) across 63k+ order transactions.

TECHNOLOGY STACK
PostgreSQL · SQL · Power BI · DAX · Data Modeling · Star Schema · ETL Pipelines · Data Quality Audit
VISUAL ANALYSIS PREVIEWZOOM IN
Northstar Commerce Executive BI Dashboard Overview
POWER BI EXECUTIVE COMMAND CENTER$5.94M NET REVENUE
Net Revenue$5.94M
Gross Profit Margin38.6%
Order Items Analyzed63,635
GITHUB REPOSITORY ↗
02Business & Systems

Interactive Portfolio & Analytics Platform

Modern Web Application (Next.js, TypeScript, Tailwind CSS, Recharts)

Engineered a modern, responsive web application showcase for data analytics pipelines, interactive Machine Learning scatter plots, and Agile Scrum Master project workflows.

TECHNOLOGY STACK
Next.js 16 · React 19 · TypeScript · Tailwind CSS v4 · Recharts · GitHub REST API · Glassmorphism
VISUAL ANALYSIS PREVIEWZOOM IN
NEXT.JS 16 SYSTEM ARCHITECTURE100% SSG
Next.js 16 App RouterReact 19 & Tailwind v4
PAGE LOAD SPEED
< 1.0s SSG
STATIC ROUTES
15 SSG Pages
API: GitHub REST APIINSPECT ARCHITECTURE →
Page Load Speed< 1.0s (Prerendered)
Static Routes15 SSG Pages
API IntegrationGitHub REST
GITHUB REPOSITORY ↗
03Data & Analytics

NFL Player Clustering & Fantasy Tier Analytics

K-Means Machine Learning & VOR Modeling | Python & Scikit-Learn

Unsupervised machine learning pipeline that clusters NFL players into actionable fantasy performance tiers using custom PPR+IDP scoring, Value Over Replacement (VOR), and K-Means with triple-metric validation.

TECHNOLOGY STACK
Python · Scikit-Learn · K-Means · Pandas · Value Over Replacement (VOR) · Matplotlib · Seaborn · CLI Pipeline
VISUAL ANALYSIS PREVIEWZOOM IN
NFL Player Fantasy Tiers K-Means Clustering
K-MEANS VOR TIERS (k=4)SCIKIT-LEARN PIPELINE
Validation MethodsElbow, Silhouette, Gap
Clustering ModelK-Means (k=4)
Core MetricVOR (Value Over Replacement)
GITHUB REPOSITORY ↗
04Data & Analytics

TFT Analytics & Snowflake Data Warehouse

SQL Dimensional Data Modeling & Snowflake Cloud Warehousing

Engineered a Snowflake cloud data warehouse and analytical SQL pipeline analyzing Teamfight Tactics (TFT) player performance, team composition synergies, and win-rate trends.

TECHNOLOGY STACK
Snowflake · SQL · Python · Data Warehousing · Dimensional Modeling · ETL Pipelines
VISUAL ANALYSIS PREVIEWZOOM IN
TFT Analytics Power BI Dashboard
TFT POWER BI DASHBOARDSNOWFLAKE DATA PIPELINE
Data WarehouseSnowflake Cloud
Schema ModelStar Schema (Fact/Dim)
Query OptimizationCustom CTEs
GITHUB REPOSITORY ↗
05Project Management & Scrum

Woodland Manor Agile Web Redesign & Systems Overhaul

Scrum Master & Business Analyst Project Management Delivery

Led a cross-functional Scrum team (DevHawks) through 4 2-week Sprints to redesign Woodland Country Manor’s digital presence, streamlining stakeholder reviews and boosting user engagement by 45%.

TECHNOLOGY STACK
Agile / Scrum · Jira / Confluence · Backlog Grooming · Stakeholder Management · User Stories · Process Mapping
VISUAL ANALYSIS PREVIEWZOOM IN
AGILE SCRUM SPRINT DELIVERY4 SPRINTS · 8 WEEKS
AVG VELOCITY
42 Pts
ON-TIME
96%
FEEDBACK
-40%
ARTIFACTS: Backlog · Burndown · DoDLIVE WEBSITE →
TEAM: DevHawks (6 Members)EXPLORE FRAMEWORK →
Sprint Velocity Increase+35%
On-Time Story Completion96%
Stakeholder Feedback Loop-40%
LIVE WEBSITE ↗
METHODOLOGY & WORKFLOW

How I Approach & Solve Problems

Whether engineering an analytical data pipeline or leading an Agile Scrum sprint, I follow a disciplined methodology to ensure predictable, measurable results.

STAGE 01 OF 05Identify Key Questions & KPIs

Business Problem Definition

Collaborate with business stakeholders to convert vague business challenges into measurable analytical questions, target KPIs, and actionable success metrics.

TOOLS & METHODOLOGIES:
Stakeholder InterviewsKPI FramingRequirements Matrix
KEY DELIVERABLE
Analytical Problem Charter

Guarantees alignment between technical execution and business value at this stage.

INTERACTIVE EXECUTIVE DATA SANDBOX

Revenue & Churn Intelligence Engine

Test custom filters to view dynamic metrics visualization and auto-generated SQL analytics queries.

METRIC: revenueSEGMENT: All
DYNAMIC SQL QUERY
PostgreSQL
SELECT 
  DATE_TRUNC('month', order_date) AS month,
  SUM(sales_amount) AS total_revenue
FROM fact_sales f
JOIN dim_customer c ON f.customer_id = c.customer_id
WHERE c.customer_segment = 'All'
  AND f.order_date >= '2026-01-01'
GROUP BY 1
ORDER BY 1 ASC;
Query Latency: 14ms250k Fact Records
INTERACTIVE AGILE SCRUM SIMULATOR

Sprint 4 Kanban Board & Backlog

Click any story card to inspect Acceptance Criteria or move stories across Sprint stages.

VELOCITY42 Points
SPRINTDay 7 of 10
Product Backlog1
US-1058 pts

Inventory Stockout Predictive Alert Widget

Analytics
Sprint To Do1
US-1042 pts

Sprint 5 Backlog Grooming & Story Poker

Scrum
In Progress1
US-1033 pts

Automated Daily SQL ETL Pipeline Alerting

Data Eng
Done (DoD Met)2
US-1015 pts

Executive Sales Dashboard Filter Controls

Analytics
US-1028 pts

Woodland Manor Online Booking API Integration

Full-Stack
US-101Executive Sales Dashboard Filter Controlsdone

Acceptance Criteria: Filters must support multi-select regional breakdown with < 200ms query latency.

Ben M. (BA/Dev)
OPEN SOURCE CODE REPOSITORIES

Live GitHub Synchronization

Every project comes with full source code transparency. Inspect SQL scripts, Python notebooks, and Next.js applications directly on GitHub.