Download PDF

Scott Matthews

Senior Business Intelligence Analyst · Automation Architect · Connecticut, USA

Summary

Senior BI Analyst and full-stack automation builder with 8+ years turning manual processes into verified production systems across financial, medical, and manufacturing operations. Only embedded builder on an executive AI-acceleration program — 20+ production repositories shipped in one year via AI-agent-orchestrated development, $4M/month in third-party billing brought under full-population review (up from a <1% sample), and chartered projects delivered on or ahead of schedule, including one signed off by the executive sponsor 16 days ahead of target.

Technical Skills

BI & VisualizationPower BI, Tableau, SAS
Automation & AIUiPath, Google Apps Script, AI-agent orchestration (Claude), VBA
LanguagesPython, TypeScript, JavaScript, SQL
Web & DataNext.js, React, Node.js, PostgreSQL, Docker, Git/CI
PlatformsGoogle Workspace, Microsoft 365, QMS Systems
DomainsFINTECH, Medical Devices, Manufacturing, Compliance

Experience

Senior Business Intelligence Analyst

2025 - Present · 1 yr 7 mo
WEX Inc.Efficiency & Automation Team
  • Delivered two chartered projects solo as the only embedded builder on an executive AI-acceleration program — comparable projects were staffed with two-person builder pairs — shipping 20+ production repositories (2,000+ source files, 300+ automated test files) in one year via AI-agent-orchestrated development
  • Built an independent Python pipeline for full-population review of ~$4M/month in third-party billing — previously a <1% manual audit sample — catching confirmed errors, including a 65x invoice-quantity error, that the sponsor said they never would have found otherwise
  • Automated a four-source aging-report consolidation with a Python engine chartered to cut effort from 6 to 2.5 hrs/mo; delivered 16 days early, UAT-validated on 16 months of production data
  • Engineered a config-driven premium-reconciliation engine designed for a 60-client rollout, reproducing 10 self-bill and funding tabs of an analyst's production workbook under an automated grader
  • Designed UiPath bot suite covering 17 returned-payment scenarios, processing 300+ accounts daily with measured handling time cut from minutes to under 20 seconds, validated error-free at launch
  • Built full-stack platforms (Next.js, TypeScript, PostgreSQL, Docker) consolidating operator tools, plus a KPI monorepo whose simulations reproduce a 1,356-row historical month to the penny
  • Matched ~99,000 fleet-card transaction rows to mobile-fueling sites for a customer pilot using batch geocoding and real driving distances — median 0.3 mi to the nearest site, 78% within one mile — grounding the pilot's site-density recommendations
  • Built enterprise monitoring dashboard tracking SAS report infrastructure that surfaced critical gaps to VP of Technology, triggering company-wide monitoring system integration

Project Coordinator

2022 - Feb 2025 · 3 yr 1 mo
RWS Life SciencesGlobal Language-Services Provider
  • Developed automation script adopted into company-wide QA system, increasing processing speed by 1000% and eliminating manual entry errors across 100% of workflow
  • Built reporting automation for $2.5M/year medical client, consolidating hundreds of data points into executive presentations and cutting senior management prep from 2–10 hours to under 30 minutes monthly
  • Transformed 28-step manual file creation process into single-click macro with zero error rate, saving 30–50 hours monthly across project teams

QA Analyst

2021 - 2022 · 1 yr
KweryFreelance
  • Executed test cases for 6 applications (3 mobile, 2 web, 1 PWA) with zero critical production bugs across releases
  • Managed release schedules and conducted user research that directly informed UX decisions

Project Coordinator

2018 - 2021 · 3 yr
MedtronicMedical-Device Manufacturing
  • Administered change management in QMS for 33% of plant SOPs across Polymer Development Manufacturing
  • Overhauled compliance reporting system, earning Director recognition and saving 2,000+ hours annually
  • Supported 7 major regulatory audits (MDSAP, FDA, OSHA) with zero findings via rigorous version control

Creative & Product Development

2022 - Present · Ongoing
IndependentPersonal Projects
  • Wrote Eclipseborn: Sun and Moon — a 125,000+ word original epic-fantasy novel
  • Produced a self-narrated audiobook of the saga
  • Built Eldoria and Realm Runners — self-contained browser games
  • Shipped a games portal and a pickleball league app as an installable PWA
  • Designed a unified design system shared across the apps

Selected work

  • Returned Payment Automation SuiteUiPath bot that processes returned payment accounts by navigating an internal credit-servicing application, updating settings across multiple screens based on a scenario matrix, writing calculated comments, and logging all changes.
  • Billing KPI ProcessorBrowser-based automation that transforms general-ledger exports into a formatted KPI Excel workbook with preserved formulas, integrated validation, and real-time processing logs.
  • Tax Reports DashboardDashboard built to capture knowledge about undocumented SAS reports, with PowerShell monitoring for real-time job tracking. Identified a monitoring gap and delivered improved report ownership and enterprise-wide oversight.
  • QA Automation SuiteVBA automation that produces monthly QA reports for a major client by processing hundreds of source files with complex transformations. Rolling 3-month, 6-month, and yearly aggregations.
  • Lunar Vaults Radio — six always-on stations self-hosted on a NAS: Icecast, Liquidsoap, and a Python interactive layer.