Skip to main content
Experience Projects Contact
Available for hire

Hi, I'm David R

Software Developer building full-stack applications, data pipelines, and RAG-powered AI that ships with confidence

Get in touch LinkedIn

Results

$80K+
Annual Cost Savings
Desktop Billing Application
75%
Process Acceleration
Billing Workflow Automated
40%
Productivity Increase
Manual Data Entry Eliminated
5 Hour
Runtime Reduction
Nightly Batch Query Optimized

Featured Work

World Baseball Classic Data Platform
+ RAG AI Assistant

Full-stack baseball analytics platform with a Python ELT pipeline, dbt SQL transformations, Dagster orchestration, pgvector RAG with local embeddings and Groq LLM, SvelteKit frontend deployed on AWS EC2 and Vercel

Source Launch
Ingestion
Python ELT pipeline polling MLB Stats API on a schedule, loading raw JSON into PostgreSQL with no transformation at ingestion
Database
PostgreSQL via Supabase — three-schema architecture: raw (JSONB), analytics (dbt-transformed), vectors (pgvector embeddings)
Transforms
dbt SQL-based transformations — 12+ models across 3 standard layers (staging / intermediate / mart), 50+ automated data tests, full visual lineage
Orchestration
Dagster software-defined assets — each dbt model surfaces as an individual asset with first-class lineage
RAG Pipeline
Local SentenceTransformer embeddings (all-MiniLM-L6-v2, 384 dims), pgvector HNSW index for retrieval, Groq llama-3.3-70b-versatile for streaming generation
Frontend
SvelteKit full-stack with TypeScript, SSR, Tailwind CSS — deployed to Vercel with zero configuration
CI/CD
GitHub Actions runs dbt tests on every push; deploy workflow auto-deploys pipeline to EC2 via SSH on merge to main
Status: Live in production

Full-Stack Notes Application

Full-stack Next.js 16 App Router application with Google and GitHub OAuth, per-user private notes, serverless API routes, MongoDB Atlas, and automated CI/CD on AWS Amplify

Source Launch
Frontend
Next.js 16 App Router with React and TypeScript, server-side rendered via Server Components
Backend
Serverless API routes built into Next.js (/api/notes) with full CRUD operations
Database
MongoDB Atlas with Mongoose ODM, schema validation, and automatic backups
DevOps
GitHub Actions CI pipeline runs full Playwright E2E suite on every push against a production build; AWS Amplify auto-deploys on push to main
Status: Live in production

Experience

$80K+
Annual Cost Savings

Built a C# desktop billing application that automated insurance claim processing end-to-end, delivering $80K in annual savings and 75% faster workflows.

C# .NET T-SQL SQL Server
80%
Fewer Claim Rejections

Engineered automated validation logic into the claim submission workflow, reducing insurance rejection rates by 80% through real-time rule enforcement at the application layer.

C# .NET T-SQL SQL Server
~95%
Reduction in Failed Syncs

Implemented exponential backoff and structured audit logging across all API calls in a bidirectional CRM sync, cutting sync failures by 95%.

Python REST APIs Webhooks
43,000+
Records Migrated

Delivered a CRM integration migrating 43,000+ realtor records and enabling the client's first automated outreach campaigns, delivered ahead of schedule.

Python REST APIs Webhooks
8 min → 45 sec
Query Execution Time

Partitioned a 200M-row billing history table by year, cutting report query time from 8 minutes to 45 seconds with zero application layer changes.

T-SQL SQL Server
7 hrs → 2 hrs
Nightly Batch Processing

Replaced a slow UNPIVOT operation with CROSS APPLY and introduced indexed views to pre-compute high-cost joins, cutting overnight runtime by 70%.

T-SQL SQL Server
40%
Productivity Increase

Eliminated 15 hours of manual data entry per employee per week by replacing a legacy DOS terminal workflow with a Python ETL pipeline.

Python T-SQL SQL Server
90%+
Data Integrity Error Reduction

Applied defense-in-depth validation with Python schema checks at the application layer and SQL Server constraints at the database layer against external hospital data sources.

Python T-SQL SQL Server

Technical Skills

Languages

TypeScript Python T-SQL C# (.NET) JavaScript

Frontend

React Next.js SvelteKit TypeScript JavaScript Tailwind CSS

Backend

Node.js Next.js API Routes Express.js Python C# (.NET) REST APIs

Database

SQL Server PostgreSQL MongoDB Atlas Supabase pgvector MySQL

Testing

Playwright Jest React Testing Library E2E Testing Unit Testing

Cloud & DevOps

AWS EC2 Vercel Docker GitHub Actions CI/CD Git Linux

Data & AI

RAG Pipelines pgvector HNSW dbt Dagster Vector Search

Security

OAuth/JWT Rate Limiting Input Validation CORS SQL Injection Prevention

Let's Build Something Together

Have a project in mind? Let's talk.

hi@davidr.io LinkedIn