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.

See more examples of my work