Randstad Digital

Accelerated Enterprise Reporting by 90%

Senior SQL Server Database Architect, Administrator, and Lead Developer2020

Situation

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.

What I Did

Audited the view layer and discovered that the reporting queries were performing iterative lookup table joins that effectively serialized what should have been set-based operations. Refactored the view systems to eliminate those patterns and align with proper relational execution.

Result

Reduced patient experience and KPI report download times from ~10 minutes to ~1 minute — a 90% improvement on 60MB+ datasets.

Tools & Tech

SQL ServerT-SQLSSMS