Global investment and advisory firm with more than $265 billion in Assets Under Management across 1500 portfolios including Insurance / Non-Insurance SMA’s, Hedge Funds, Mutual Funds, ETFs, and CLO’s.
The client had outgrown their previous Investment Performance and Portfolio Attribution system due to lack of features and volume of data. As a result, a business decision was made to migrate to BISAM B-One which offered additional features and increased scalability.
Grandview provided project delivery resources to configure B-One and migrate and validate historical data to verify the accuracy of key calculations.
Analyzed security master, holdings, and transactions to define business rules for transforming data extracts from the Accounting Book of Record (ABOR) to meet the specifications defined by B-One.
Designed an ETL solution to process the ABOR data which allowed the client to terminate a previously outsourced vendor solution.
Created and implemented automated system workflows for loading and validating data that reduced month-end data processing time by 84%.
Overcame system limitations by developing SQL-based return calculations and validation reports to reconcile return calculations and security master reference data.
Migrated and validated 8 years of historical security and total returns for 1000 portfolios, 100+ indices, and 30+ custom benchmarks consisting of 30,000 unique held securities and 65,000 benchmark constituents.
Grandview Analytics is a technology consulting and managed data services company serving financial institutions nationwide. We offer strategic advisory, technology implementation, systems integration, and data and analytics consulting services as well as managed data services powered by our Rivvit data management and reporting platform.
500 West Madison StreetSuite 1000Chicago, IL 60661
500 West Madison St.Suite 1000Chicago, IL 60661