Faster mortgage data processing
First American Default Technologies · Financial services
A mortgage servicing platform faced a serious data-processing bottleneck. Overnight data loading took approximately 11 hours, while mainframe-to-SQL Server updates at a major client were finishing on time only 10% of the time.
I was initially brought in as a contractor for database tuning. Following the success of that work, I joined the organization and continued overseeing database upgrades, migration, process improvements and rollout planning.
The challenge
An 11-hour overnight data-loading process created a narrow operating window, while critical data updates were meeting their deadline only 10% of the time.
What I did
I performed database tuning, oversaw a database upgrade and migration to new hardware and managed changes to the data-loading process. I coordinated requirements, testing and sign-off while also planning implementation across additional clients.
The result
11 hours to 2 hours
Overnight data loading dropped from 11 hours to approximately two.
10% to 95%
On-time data updates increased from just 10% to 95%.
The project dramatically improved the speed and reliability of a critical data-processing workflow, giving the organization substantially more dependable overnight processing.
Technology and skills
Mainframe data • SQL Server • SSIS • Database tuning • Hardware migration • Data processing
Related services
Learn more about data consulting and legacy software modernization.
Facing a similar problem?
Start with a free 30-minute conversation to discuss the problem and see whether I’m a good fit.
Detailed assessments and project planning are available through paid discovery.