With more than 6,000 financial advisors serving more than 2.5 million accounts in more than 2,500 locations throughout the United States, Canada, and overseas, the IT team for this company takes care of daily mass account transfers from incoming clients, most of whom have disparate data systems using fixed length, Excel, and SQL database formats that must be transformed into the main SQL database format. Frequently, data does not conform to existing layouts, adding to the complexity and causing delays in validating and processing. Because new clients join the company constantly, data integration is an ongoing challenge..
This company needed a robust data integration solution that could handle the complexities of validating and processing mass account transfers in a myriad of formats quickly and reliably. With new clients joining the company on a daily basis, delays in onboarding and transferring data had to be overcome.