Membership Database & Engagement Platform
Comprehensive membership platform: registration, profiles, households, volunteer hours, events, payments, admin tools, and email list sync.
React/TSSupabase (RLS)APIsTailwind
Public Sector Product & Data Leader
I lead cross‑functional teams to plan, deliver, and scale mission‑aligned products and data programs—turning policy goals into transparent systems, actionable insights, and measurable outcomes.
About
I’m Troy Shimkus, a team‑first leader focused on Public Sector Data Programs—aligning stakeholders, shaping roadmaps, and coaching teams to deliver useful, human‑centered solutions.
Recent work: leading services delivery at PowerSchool (dashboards for 150+ districts), building a membership platform for a civic organization, and serving as City Commissioner to advance transparency and trust.
Resume Highlights
Leadership & Product Delivery
- Align stakeholders, shape roadmaps, coach cross‑functional teams
- Plan → execute → scale with standard delivery and clear outcomes
- Bridge technical/non‑technical to ship the right thing
AI Practices & Automation
- LLM‑assisted workflow: design, prompting, codegen, evaluation
- Model use: Whisper, YOLOv8; data prep/labeling for ETL
- Guardrails/privacy mindset; pragmatic, outcome‑driven adoption
Data Programs & Systems
- Dashboards and secure data flows; integrations (APIs, ETL)
- Cloud practices: observability, CI/CD, reliability
- K‑12 and civic data experience; stakeholder‑ready reporting
Voter (Spring Boot)
Online voting system with multiple methods, anonymous voting, real-time results, and Bootstrap UI.
JavaSpring BootMySQL
District Analytics Dashboards
Custom dashboards for 150+ K‑12 districts to improve insight and renewals; standardized delivery accelerated onboarding.
SaaSSQLETLAWS
VideoTranscribe
Automated video/audio transcription and summarization using Whisper; batching, timestamp handling, and PDF/JSON output.
PythonWhisperFFmpeg
Crowd Counter
Computer vision tool using YOLOv8 to estimate crowd sizes from photos/videos; annotated outputs and CSV reports.
PythonYOLOv8OpenCV
Voter Mapping Utility
Radius-based voter lookup and mapping; Leaflet.js UI with MySQL spatial indexing.
PHPMySQL SpatialLeaflet
Embroidery Design Tools
Python utilities for PES/DST embroidery patterns, patch borders, and geometric designs.
PythonPES/DST
Concierge Site
Directus-based headless CMS deployed with Docker for service-oriented content management.
DirectusDockerCMS
Email Management
Automation and list management; campaign tooling and ESP integrations.
AutomationESPData
Contact
Send a note and I’ll get back soon.