“Y&L analysts were brought in to eliminate data integration failures. An in-depth analysis of system logs was conducted, the server and network infrastructure was reviewed and validated, the integration process and code was reviewed, and data tables were analyzed for improvement. ”

“The team incorporated various changes including table indexing and partitioning (which provided the most improvement) and queries were re-written to optimize load performance. Additionally, several automatic and dynamic maintenance plans were implemented.”

Tools Used: SQL Server, SQL Server Integration Services, Proprietary front-ends (.Net)