stewart wilson

Designed and shipped Python services orchestrating AI agents for insurance intake, wiring LLM APIs and tool-calling to Django endpoints so agents read and update policy data through guarded, auditable calls. Led full-stack delivery of a Django/React policy-servicing application, owning PostgreSQL schema, migrations, and query tuning to maintain steady response times as datasets grew. Built a RAG pipeline over internal underwriting guidelines and records using PostgreSQL vector storage and embedding search to provide grounded citations and reduce manual document lookups. Containerized services with Docker and deployed on Kubernetes in AWS, standardizing health checks, resource limits, and rollout strategies. Automated releases with CI/CD pipelines (unit, integration, contract tests) and added structured logging, tracing, and alerting. Evaluated AI outputs against curated test sets and improved prompts, validation, and fallback behavior before releases, while mentoring engineers and par

Extended a Django case-management platform for justice agencies by adding REST endpoints for case intake, document handling, and status tracking consumed by a React interface. Shipped React screens for case search and disposition tracking, replacing server-rendered paging workflows. Modeled case and party relationships in PostgreSQL, authored migrations, and built composite indexes to keep reporting queries responsive as case data accumulated. Standardized the application stack on Docker and aligned CI/CD so builds, migrations, and tests behaved consistently locally and on shared test servers. Expanded test automation with Pytest, growing regression coverage for case submissions and notification flows to more than 100 repeatable tests, collaborating with court clerks and product owners to clarify requirements and document resulting data rules.

Engineered Python services on Django for policy and billing workflows, exposing REST APIs to internal claims tools and partner brokers for submitting and retrieving policy information. Authored normalized PostgreSQL schemas for policy, premium, and payment records across four business lines, writing migrations to keep month-end reporting consistent. Implemented batch jobs and ETL routines moving premium and claims data between policy administration systems and an enterprise data warehouse on an overnight schedule. Wrote automated unit and integration tests for billing calculations and protected rating and proration logic previously verified manually. Streamlined builds and deployments with Jenkins and CI/CD scripts, replacing manual file copy steps and reducing time from merged change to tested build. Overhauled JavaScript reporting screens and continued enhancements in React from 2016 onward to support underwriting filters and export options.