Service

Data Services

Expert data management and integration solutions for your business. Seamlessly transfer data between systems, merge platforms, and transform complex data challenges into manageable solutions.

Data Services Overview

Expert data transformation and management solutions

CSSI Data Services specializes in system migrations, data merging, cost basis management, and private equity transaction setup. We analyze, transform, merge, and reconcile complex data, making challenging data projects manageable for your firm.

Recent Project Highlights

Acquisition Data Migration

Migrated 4 years of transaction history from Tamarac to APX for 2000 accounts, including:

Transaction and performance data extraction
Securities analysis and setup
Historical transaction posting
Account reconciliation
Price history and performance conversion
Demographic data migration

Historical Transaction Restoration

Three years after an acquisition, we restored 12 years of historical transactions, securities, prices, and tax lots for 7000 accounts using custodian bulk files.

Private Equity Data Integration

Created and reconciled private equity transactions from excel files, ensuring accurate alignment with client statements.

Cost Basis Management

Initialized tax lots using custodian data, reposted transactions to match custodian gain/loss, and developed ongoing cost basis maintenance procedures.

Classifications Restructuring

Helped a firm transition to standard GICS sector classifications by mapping securities appropriately and restructuring historical performance data.

Data Conversions and System Merges

Expert data migration services for investment management firms

CSSI over the last 15 years has done a number of system merges into Axys/APX and other systems. With the acceleration of acquisitions in the market place CSSI has completed a number of large and small conversions in a matter of weeks on small ones and in a few months on larger ones. CSSI has also completed a number of move to other systems from Axys/APX. When thinking about your system merge or data conversion there are a number of tasks and analysis that needs to be completed. CSSI can project manage, perform the project, or assist your firm.

Here are some sample tasks that typically happen in a system merge or data conversion:

Pulled transactions, prices, and performance from Tamarac and other systems
Analyzed securities between the two systems
Assisted in setting up new securities in APX
Set up initial positions
Posted historical transactions to present
Reconciled accounts to match current data
Converted and posted daily prices
Converted performance since inception
Pulled demographic information and custom data

Direct Feeds

Timely and accurate data for your portfolio management system

CSSI Solutions knows that a portfolio management system without timely data is not very useful. Over the years, we have established our own direct feeds and worked with partners to assist in data aggregation.

Our Direct Feed Solutions

Trevport Utility

CSSI's Trevport utility can be used with any datafeed that the customer has access to for prices, positions, transactions, and more. It is CSSI's swiss army knife data utility.

Morningstar ByAllAccounts (BAA)

BAA has thousands of direct and indirect feeds that can be used in your portfolio management system and continues to grow the list regularly.

WealthTechs (WT)

WT has done an excellent job of pulling together a large number of custodian relationships which cover a large portion of the custodial universe. WealthTechs also provides flexible custom development in a timely manner.

ByAllAccounts

Comprehensive BackOffice Services with ByAllAccounts integration

CSSI's ByAllAccounts (BAA) BackOffice Services offers a one-stop source for reconciliation outsourcing and data needs. This offering can apply to a portion or to all of your accounts.

CSSI BAA BackOffice Service Includes:

•Cash and position daily reconciliation
•Monthly/quarterly performance update
•Corporate actions: process splits, symbol changes, name changes & reorgs
•Daily price and index updates from customers pricing sources
•Basic security setup: type, cusip, symbol

Through CSSI's relationship with BAA, the customer won't need to pay the annual Custodial Integrator fee. The customer will pay for all BAA data feeds and for reconciliation services only on the accounts that are active.