Accelerated Release Velocity with Mandatory Unit Testing
Release cycles were running every two months and regression issues were frequent, leaving the client without confidence in the system's stability.
Experience
Four companies over 20+ years. Each one left me with something I still use.
Senior SQL Server Database Architect, Administrator, and Lead Developer
Spearheaded all data aspects for a custom-built online scheduling solution managing 2,500+ dialysis clinics nationwide for client Fresenius Healthcare. Primary architect for feature expansion and legacy remediation.
Release cycles were running every two months and regression issues were frequent, leaving the client without confidence in the system's stability.
Core staff scheduling stored procedures were running at 1,500ms+ per call, impacting the responsiveness of the scheduling solution used across 2,500+ clinics.
Patient experience and KPI report downloads were taking approximately 10 minutes for 60MB+ datasets, blocking clinical and operations staff from timely access to the data they needed to run clinics.
Production transaction log growth was becoming unstable.
Permission management across all environments was handled manually, creating risk of configuration drift, inconsistency, and human error during deployments and environment refreshes.
The legacy "multi-config" pod/chair schema was creating data duplication and maintenance complexity that slowed development velocity and made the system harder to reason about as the clinic count grew.
Senior Software Engineer II, SQL Server Developer
FTI Consulting's e-discovery product Ringtail was a Gartner Magic Quadrant leader in legal discovery. Lead SQL developer on a web-based evidence collection and processing platform. The product was later acquired by Nuix.
The platform lacked a consistent way to track changes across client databases.
Licensing SSIS across hundreds of client servers was cost-prohibitive, but the platform needed robust ingestion pipelines to reliably process evidence data.
The Ringtail e-discovery platform required a dedicated SQL developer to own all database development and coordinate with a cross-functional SCRUM team building a web-based system for legal evidence collection and processing.
SQL Server Data Analyst, Developer, and DBA
B2B direct marketing firm running high-volume data operations for enterprise clients. Worked across the full data stack — cleansing, warehousing, ETL, reporting, and server administration — on databases up to 200GB for household-name clients. Cranberry Twp, PA.
Delivered data cleansing, warehousing, and reporting for campaigns run on behalf of Verizon, LendingTree, CheckFree, Audible, Bank One/Chase, and Sheetz — handling databases up to 200GB and processing millions of records using custom SQL scripts, SSIS Fuzzy Lookup/Grouping, and third-party matching tools.
Converted DTS packages to SSIS during the company's platform migration, while assisting the senior DBA with hardware configuration, capacity planning, and security management across 20+ servers and 50+ workstations.
Administered MicroStrategy installations, maintenance, and upgrades.
Owner & Principal Engineer
Boutique managed hosting and web services company serving small businesses since 2006. Independent SQL Server consulting, WordPress management, and content operations. Registered trademark since 2016.
Small business clients needed reliable hosting, migrations, and ongoing web support — services that larger agencies ignored or overcharged for.
Client demand for SEO, paid advertising, and social media services exceeded what 37SOLUTIONS could provide under its existing scope.
SQL developers had plenty of reference sites but almost nothing purpose-built for tSQLt unit testing and CI/CD pipeline integration.
Existing community repos for Zendesk integration with Claude AI were incomplete, leaving gaps in the tools needed for daily support ticket operations at 37SOLUTIONS.