Jamey McElveen

• Architected offline-first sync layer using Dotmim Sync — field laptops operate independently and reconcile with central hub on reconnect. Zero data loss, no paper fallback required.
• Implemented Double Metaphone phonetic patient search via PostgreSQL fuzzystrmatch — solving name romanization inconsistency across multilingual mission contexts.
• Unified spiritual and medical outcome tracking in a single data model (spiritual=heard|hope|none) — treating the whole person as the patient.
• Enforced CI parity via single gate running ESLint, Vitest, React Testing Library, and production Next.js build locally and in GitHub Actions.

• Architected high-concurrency public APIs in .NET Core on Kubernetes (EKS) with elastic scale to absorb Giving Tuesday traffic spikes — zero downtime during peak donation surges.
• Designed anti-fraud heuristics to detect and shut down credit-card validation attacks (carding), protecting platform integrity and donor funds.
• Engineered idempotent ETL pipelines for PostgreSQL to Snowflake migrations; pipelines restart mid-stream without duplicating financial records.
• Leveraged Snowflake Time Travel for financial audit trails and year-over-year trend reporting without loading production transactional DB.
• Created, maintained, and documented Angular components using Storybook across the full frontend component library.
• Applied FinTech-grade security including immutable audit trails, TLS 1.2+ enforcement, and least-privilege access across all data surfaces.

• Migrated entire development organization from file-share-based storage to Git and GitHub — cleaning 100,000+ commits with BFG Repo-Cleaner, reducing repo size by 80%.
• Implemented CI pipelines for HIPAA-compliant clinical systems, replacing manual deployments with automated, auditable release processes.
• Mentored developers and interns on Git workflows, branching strategy, and pull request culture.
• Introduced ELK stack with Golden Record PHI scrubbing service — replacing real names and SSNs with synthetic identities in non-production environments. Zero BAA exposure risk.
• Enforced TLS 1.2+ across all WCF and REST endpoints.
• Managed data integration bridges between .NET applications and Oracle Cloud / Epic EMR platforms serving thousands of clinical staff.

* Except May 2005 – May 2006 (see Lyle's Data Systems)

• Strategic architectural lead for flagship SaaS suite serving 50,000+ organizations worldwide; directed distributed R&D team of 20+ engineers.
• Scrum Master for Realm for several years; served as Product Owner during management chapter — ran backlog grooming, story points, standups.
• Pioneered Model-Driven Development (MDD) for large-scale C# codebases.
• Used actor pattern for async debit card hardware feedback coordination in payment processing flows.
• Departed following strategic leadership transition that altered the organization's technical vision and direction.

• Architected multi-tenancy using RLS and SQL Resource Governor to prevent Noisy Neighbor degradation across 50,000+ tenants.
• Built shard-aware routing layer enabling live zero-downtime tenant migration when organizations exceeded resource thresholds.

• Designed N-tier C# / WCF / SOAP architecture with custom WS-Security header processing in the WCF message pipeline.
• Eliminated high-concurrency booking conflicts using RowVersion optimistic locking; reduced scheduling query overhead 70% via covering index eliminating a bookmark lookup.

• Modeled non-linear Student-Guardian-Representative hierarchies using M:N relational tables with bitmask permission flags.
• Architecture maps directly to SC DSS / CAPSS child placement and voucher eligibility workflows — transferable to behavioral health or child-services SaaS domains.

• Managed three developers delivering Java / Struts MVC government services platforms to municipal clients across the Southeast.
• Architected multi-jurisdiction online property tax payment system enabling citizens and banks to pay home, vehicle, and boat taxes online.
• Designed and built @ Your Request — citizen issue-reporting platform with photo uploads and real-time progress tracking.
• Performed GIS / ESRI geospatial data conversion migrating legacy systems into MS SQL Server.