Trystan Woods
Senior Analytics Engineer – Microsoft Fabric, Power BI & AI
- San Antonio, TX
- offices@trystanwoods.com
Executive Summary
Senior Analytics Engineer who delivers Microsoft Fabric and Power BI implementations using AI tooling and agentic workflows, for clients in finance, healthcare, and manufacturing. Built an agentic plugin that turns client documents into delivery-ready semantic models and reports in half the usual build time, and is a top contributor to Fresche’s wider Claude Code toolkit. Builds Fabric platforms from greenfield through migration: semantic models, medallion lakehouses, Direct Lake, and deployment pipelines. A background in accounting and finance operations keeps the models tied to how the business actually reports.
Core Capabilities
- Agentic AI Workflows
- AI-Assisted Development
- AI Governance & Guardrails
- Microsoft Fabric & Power BI
- Semantic Modeling
- Medallion Architecture
- SSRS-to-Power BI Migration
- Deployment Pipelines & DevOps
- SQL
- Python/PySpark
- Stakeholder Leadership
Experience
Fresche Solutions | Senior Analytics Engineer – Microsoft Fabric, Power BI & AI
Jan 2023–Present
- Lead Fabric and Power BI engagements for multiple clients, using AI tooling throughout delivery
- Top contributor to Fresche’s AI delivery toolkit of Claude Code plugins used by the consulting team: ~40% of all commits (twice the next contributor) and author of several of its plugins
- Built an end-to-end agentic flow that converts raw client inputs (SOWs, transcripts, legacy SSRS and Excel reports) into delivery-ready semantic models and Power BI reports, cutting build time from 40 hours to 20 with almost no hand edits
- Automated migration of legacy SSRS libraries to Fabric paginated reports: AI converts each report, render-tests it, and delivers the whole library as a single reviewable pull request
- Built AI skills that compare semantic models and reports across environments, generate wiki documentation for them, and hand work off cleanly between sessions and colleagues
- Built AI work-item triage across Azure DevOps boards: agents investigate against live data and draft fix PRs, with read-only defaults, human approval, and PII screening
- Design Fabric platforms that bring Salesforce, Dynamics 365, healthcare, and operational data into shared semantic models
- Designed semantic models shared across departments, so each KPI is defined once
- Implemented Direct Lake and medallion (bronze/silver/gold) architectures on OneLake
- Set the semantic modeling and governance standards used across 10+ client deployments
- Built Dev/Test/Prod deployment pipelines with controlled promotion
- Built Python and PySpark data pipelines in Fabric notebooks
- Traced data issues end to end with AI assistance, from source systems through to the report
- Trained analysts and developers on Fabric, Power BI, and AI-assisted development practices
Weir | Manager of Support Services
Jan 2020–Jan 2023
- Ran reporting and analytics for a global shared services organization.
- Moved Excel-based reporting into Power BI
- Cut report preparation time by building standard reporting models
- Agreed one set of reporting definitions across departments
Weir/ESCO | Process Improvement Manager
Apr 2019–Jan 2020
- Led automation and process work across finance operations.
- Freed two FTEs for redeployment by automating manual finance workflows
- Digitized the cash applications process and standardized how it ran
UPS | Accountant
Jun 2018–Mar 2019
- Owned lease accounting reporting.
- Moved lease reporting from Excel into CoStar lease management software, replacing manual spreadsheets with system reports
Certifications
Skills & abilities
AI & Automation
- Claude Code
- Agentic Workflows & Subagents
- MCP
- Prompt & Skill Engineering
Microsoft Fabric & Power BI
- Microsoft Fabric
- Direct Lake
- Semantic Models
- Deployment Pipelines
- PBIP
- Power BI
- DAX
- Tabular Editor
- Report Builder
Data & Analytics
- SQL Server
- T-SQL
- Python
- PySpark
- Data Modeling
- Medallion Architecture
Tools & DevOps
- Azure DevOps
- Git
- VS Code
Education
- MBA | The University of Texas at Arlington 2020
- BBA Accounting | University of Iowa - Henry B. Tippie College of Business 2011