Broker/dealer Mizuho Securities USA (MSUSA), has implemented Xenomorph’s TimeScape data and analytics management system to replace its existing market and reference data platform. The firm selected TimeScape for its ability to provide greater data model flexibility, data cost savings, and faster processing times.
“Xenomorph’s TimeScape positions us to not only manage the complexities of today’s data and analytics environment, but also ensures our platform is built to handle the challenges of tomorrow,” said Sandy Kapoor, CTO, Mizuho Securities USA.
Tailored to MSUSA’s specific needs, the TimeScape data model will acquire, standardize and deploy market and reference data for the required asset classes, including: equity, fixed income, indices, mortgage, CDS and ETFs. The system will import and manage data sources from Bloomberg, IDC Financial Insights, S&P, NASDAQ OMX, DTCC and Markit.
The TimeScape Security Master imports and stores data from each vendor using SQL Server Integration Packages (SSIS). Deploying this solution enables simple identification of the data stored in TimeScape against the actual data in the raw files supplied by the vendors. Based on MSUSA’s daily holdings, an ETL (SSIS) process was then implemented to standardize historical, holdings-based copy of all relevant reference data and prices across multiple stage databases, including links for easy comparison and tracing. The data can then be deployed to any downstream system using an ETL process, the TimeScape Web Service, or any TimeScape APIs including Excel, C/C++, VBA, and C#.
“Xenomorph was selected to seamlessly replace MSUSA’s legacy system with TimeScape to provide a flexible and robust Security Master with integration with SSIS to reduce processing time of vendor raw files, and to cut data management costs,” said Naj Alavi, Managing Director, Xenomorph. “TimeScape provides MSUSA with enhanced control of its data on a centralized platform and the means to easily visualize and extract business-critical data and also a platform that will accommodate changes with ease.”