Ryan Thomas

Data & Analytics Engineer

What I've Built at Work

Enterprise Reporting

Built self-service Power BI semantic models and migrated a legacy BI platform enterprise-wide.

  • Power BI
  • Tableau
  • dbt
  • SQL Server
  • Python
  • AWS

MCP Development

Built MCP servers connecting LLMs to live analytics tooling and enterprise data.

  • TypeScript
  • MCP
  • Cloudflare

AI Infrastructure

Built enterprise AI workflows on AWS and integrated Vertesia for content management.

  • AWS
  • Lambda
  • Glue
  • S3
  • CloudWatch
  • Terraform
  • Vertesia

Data Engineering

Builds and maintains ETL/ELT pipelines and a central dbt data model spanning enterprise systems.

  • SQL Server

Data Governance

Established dbt testing, a central data glossary, and governance standards across internal teams.

  • dbt
  • Confluence
  • Git

Web Applications

Built internal apps for AI tooling and enterprise resources.

  • Flask
  • React
  • HTML
  • CSS

API & Application Integrations

Configured enterprise integrations connecting accounting systems, grant management, and cloud infrastructure.

  • CostPoint
  • EGMS
  • SQL Server
  • AWS

Graph Databases & AI

Modeled ontologies and knowledge taxonomies for AI-native applications.

  • Ontologies
  • Taxonomies
  • GCP

Projects

Stock Portfolio Risk (stock-portfolio-risk)

Analyzes any stock portfolio for real risk concentration, diversification, and correlation between positions.

  • React
  • TypeScript
  • FastAPI
  • Python
  • DuckDB
  • dbt
  • Docker
  • Cloud Run
  • GitHub Actions

OntoloTeacher (ontologenius)

An AI study tool that maps a topic's prerequisites and quizzes you until you've mastered each concept.

  • TypeScript
  • Next.js
  • Claude API
  • Graph DB
  • SQLite

Personal Data Lake (personal-data-lake)

A personal data warehouse and knowledge graph on Google Cloud, built and deployed entirely from code.

  • Terraform
  • BigQuery
  • Cloud Run
  • Knowledge Graph
  • GitHub Actions

Pantry MCP (pantry-mcp)

Connects an AI assistant to a recipe and pantry database to suggest meals from what you already have.

  • Python
  • SQLite
  • Claude API
  • GitHub Actions