Actuarial pricing platform migration
A twenty-year-old, undocumented workers compensation actuarial pricing system running against a legacy mainframe warehouse that was being retired. Pricing outcomes had to stay defensible to auditors throughout.
I reverse-engineered two decades of undocumented SAS to establish the system's actual behaviour, mapped legacy variables to their replacements on the new platform in SQL Server, built the end-to-end ETL, and designed and ran the parallel-run cycles — verified by internal analysts, actuaries and executives, and by external audit. Mid-project I architected a workaround enabling remote SQL submission to bypass a SAS configuration limit that threatened delivery.
Old-versus-new outcomes came in within tolerance. The program was signed off. The code ran clean in production through every monthly cycle after project close.
This was a multi-year, multi-million-dollar transformation program on which several external provider arrangements across audit and technology consulting were restructured and stood down during delivery. I was retained to completion, and my final deliverable was presented to senior management and led to sign-off.