Data Services

Moving data from one system to another. Merging data onto a new platform. Initializing and maintaining cost basis. Setting up Private Equity accounts and transactions. Any time data needs to be analyzed, sliced, diced, merged, posted, and reconciled, that’s when CSSI’s Data Services department comes to the rescue. CSSI Data Services is dedicated to making the “big jobs” manageable for your firm.

Here are some recent projects we’ve completed:

Mergers/Acquisitions

In a recent acquisition, a firm needed to bring over 4 years of transaction history from Tamarac to APX for 2000 accounts. CSSI Data Services Department

  • Pulled transactions, prices, and performance from Tamarac
  • 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

Historical transaction data entry

When Firm A acquired Firm B in 2015, they elected at the time to forego historical transaction conversion. Three years later, the need for historical transactions rose to the surface. CSSI converted and posted 12 years of transactions, securities, prices, and tax lots for 7000 accounts using bulk files from the custodian.

Private equity transaction conversion and data entry

CSSI created private equity transactions from a bulk delivery of excel files, reconciling to client statements

Cost Basis initialization and maintenance

Using data files from the custodian’s website, CSSI initialized tax lots as of 12/31/17, and re-posted transactions from 1/1/18 to present to match custodian gain/loss. CSSI developed a process to maintain cost basis on a go forward basis.

Restructure asset classes, sectors, or other security classifications

A firm recently decided to change their sector reporting to standard GICS classifications. CSSI worked with the firm to map securities appropriately, as well and analyze and restructure historical performance.

 

Interested in hearing more?

Contact our sales team at or to learn more about how CSSI’s Data Services team can help your firm.