Michael Phelan

I’m a Senior Data Analyst with 10+ years of experience turning messy operational and product data into trusted SQL analysis, dashboards, and reusable datasets. I’m known for translating ambiguous stakeholder questions into clear metrics, validation logic, and reporting that improves decision-making.

At Capital One, I built BigQuery SQL models and analytical datasets for finance and operations teams, reducing ad hoc request turnaround from days to hours across 20+ recurring metrics. I designed dbt transformations with documented grain, tests, and lineage for claims-like and billing-style source tables, strengthening trust in downstream reporting used by 5 stakeholder groups.

I also create governed PowerBI dashboards with drill-through views and row-level filtering, giving leaders self-service performance visibility across 3 business functions. By writing complex SQL with CTEs, window functions, and reconciliation checks, I cut manual QA cycles by 40% and ensured reports stay accurate through monitored freshness and schema drift in Fivetran-fed pipelines.

Previously, I led end-to-end SQL and dashboard delivery for product, operations, and client-facing teams at SoftWriters, building dbt-style dimensional models and automating recurring analysis with Python scripts and stored logic. My background includes Software Engineer roles where I built Tableau dashboards, wrote validation scripts, maintained SQL Server reporting tables, and tuned jobs in PostgreSQL and SQL Server—habits that still guide my focus on data quality, clear documentation, and reliable metric definitions.