Troy Shimkus

Projects

I lead cross‑functional teams through planning, alignment, and delivery — focusing on clarity, useful outcomes, and sustainable practices. Below are representative initiatives; I’m happy to dive deeper on any of them.

AI In The Work

Pragmatic use of AI to accelerate outcomes while maintaining quality and privacy.

Membership Database & Engagement Platform

Comprehensive membership platform: registration, profiles, households, volunteer hours, events, payments, admin tools, and email list sync.

React/TSSupabase (RLS)APIsTailwind
Details

Application Overview

Comprehensive membership platform for a local political organization with member‑facing and administrative capabilities.

Core Functions & Capabilities

  • Member registration and management; duplicate detection and household grouping
  • Event integration via Mobilize.us; event display and sign‑up sync
  • Volunteer hour tracking and contribution history
  • Payment processing for dues and donations; status tracking
  • Email list synchronization with Constant Contact
  • Administrative dashboard with metrics, bulk ops, and reporting

Technology Stack

  • React 18 + TypeScript, Tailwind
  • Supabase (PostgreSQL) with Row‑Level Security and Supabase Auth
  • Integrations: Constant Contact API, Mobilize.us API, ActBlue
  • Dockerized dev, cloud deploy, end‑to‑end tests with Playwright

Voter (Spring Boot)

Online voting system with multiple methods, anonymous voting, real-time results, and Bootstrap UI.

JavaSpring BootMySQL
Details

Application Overview

Online voting system with anonymous ballots, multiple vote types, and a clean Bootstrap interface.

Core Functions & Capabilities

  • Anonymous voting without user identification
  • Multiple vote types and configurable vote limits
  • Manage voting sessions; live results/tally views
  • Compact string‑based vote storage schema

Technology Stack

  • Java, Spring Boot, Maven
  • MySQL schema for votes and sessions
  • Bootstrap UI; standard Spring Boot deployment

District Analytics Dashboards

Custom dashboards for 150+ K‑12 districts to improve insight and renewals; standardized delivery accelerated onboarding.

SaaSSQLETLAWS
Details

Application Overview

Custom analytics dashboards for 150+ K‑12 districts with standardized delivery that accelerates onboarding and renewals.

Core Functions & Capabilities

  • Standard templates and playbooks that reduce time‑to‑value
  • Secure data extracts and ETL into dashboard models
  • KPI‑aligned visualizations for leadership, operations, and schools
  • Training, rollout, and adoption support across stakeholders

Technology Stack

  • SQL and data modeling; ETL (Alteryx/Knime/Talend)
  • Cloud storage/compute (AWS)
  • Dashboard platforms and CI/CD for content updates

VideoTranscribe

Automated video/audio transcription and summarization using Whisper; batching, timestamp handling, and PDF/JSON output.

PythonWhisperFFmpeg
Details

Application Overview

Automated video/audio transcription and optional summarization for meetings and interviews using Whisper.

Core Functions & Capabilities

  • Processes MP4/MOV videos and WAV/MP3 audio
  • Merges multiple audio files based on timestamps
  • Whisper speech‑to‑text with configurable model sizes
  • Optional summaries (local markdown or GPT‑assisted)
  • Extracts timestamps (e.g., DJI filenames) for context
  • Batch processing in Docker containers

Technology Stack

  • Python 3.10, Whisper, FFmpeg
  • Transformers/Torch for model runtime
  • Outputs PDF transcripts and JSON metadata
  • Dockerized with env‑based configuration

Crowd Counter

Computer vision tool using YOLOv8 to estimate crowd sizes from photos/videos; annotated outputs and CSV reports.

PythonYOLOv8OpenCV
Details

Application Overview

Computer vision tool for estimating crowd sizes in photos/videos using YOLOv8 object detection.

Core Functions & Capabilities

  • Frame‑by‑frame video analysis with configurable intervals
  • Batch photo processing (JPG/PNG) with auto‑rotation
  • Person detection and counting; threshold tuning
  • Annotated visual outputs (bounding boxes) for transparency/QA
  • Reports: HTML summaries and CSV data exports

Technology Stack

  • Python 3.10, YOLOv8 (Ultralytics)
  • OpenCV/PIL for image processing
  • FFmpeg integration for video I/O

Voter Mapping Utility

Radius-based voter lookup and mapping; Leaflet.js UI with MySQL spatial indexing.

PHPMySQL SpatialLeaflet
Details

Application Overview

Radius‑based voter lookup and mapping with integrated voter registration and geocoded address data.

Core Functions & Capabilities

  • Find voters within configurable distances of target locations
  • Leaflet.js map UI with filtering and selection export
  • Multi‑database joins across geocode and voter tables
  • Spatial indexing and distance calculations (MySQL)

Technology Stack

  • PHP backend with Composer
  • MySQL 8 with spatial functions (ST_Distance_Sphere)
  • Leaflet.js front‑end; responsive layout
  • Environment‑based configuration

Embroidery Design Tools

Python utilities for PES/DST embroidery patterns, patch borders, and geometric designs.

PythonPES/DST
Details

Application Overview

Utilities for generating/modifying embroidery machine files, focused on patches, borders, and geometric designs.

Core Functions & Capabilities

  • Generate rectangles and borders; add/remove patch borders
  • Create custom camp patches and geometric motifs

Technology Stack

  • Python scripts
  • PES (Brother) and DST (Tajima) formats

Concierge Site

Directus-based headless CMS deployed with Docker for service-oriented content management.

DirectusDockerCMS
Details

Application Overview

Directus‑based headless CMS deployed with Docker for service‑oriented content management.

Core Functions & Capabilities

  • Role‑based content management with Directus
  • Static content delivery optimizations
  • Webhooks/integrations for external services

Technology Stack

  • Directus CMS
  • Docker/docker‑compose orchestration
  • JSON‑based initialization and config

Email Management

Automation and list management; campaign tooling and ESP integrations.

AutomationESPData
Details

Application Overview

Automation and tools for managing campaigns and transactional email.

Core Functions & Capabilities

  • ESP integrations for campaigns and transactional flows
  • List hygiene, segmentation, and automated journeys
  • Data sync/import and enrichment
  • Tracking and reporting to guide optimizations

Technology Stack

  • Python/PHP scripts
  • Email service provider APIs
  • Backing datastore for contacts/metrics