Eliminated hundreds of legacy stored procedures in Amex's collections data pipeline.
As Amex was going through an enterprise datawarehouse migration, the legacy stored procedures that fetched data into the Collections platform were old and outdated and we needed to rearchitect
Reverse-engineered business logic, partnered with QA and Data Engineering, and replaced over 60% of procedures with reusable views and parameterized queries.
Data refactoring is not glamorous — but it unlocks speed, safety, and sanity
Cut nightly processing time by 40%. Reduced maintenance time by ~8 hours/month for data team.