Prime Capital AG
Frankfurt, London, Luxembourg
Industry

Financial Services: Fund of Hedge Funds, Asset Management

Timeframe 01/2007 – ongoing
Project Fund of Hedge Funds – Data Warehouse, Positions and Reporting

Planning, development, rollout and management of a "Fund of Hedge Fund" data warehouse for consolidation and utilization of hedge fund master and market data.

The platform was further enhanced to a Portfolio Management and Reporting System.
(Transactions and positions, portfolio book keeping, P&L, reporting services and analysis)

Details:

  • Hedge Fund/FoHF master and market data
  • Indexes and benchmarks
  • Consolidated Hedge Fund/FoHF data layer
  • FoHF portfolio module – master data, positions, P&L
  • FoHF portfolio – series transactions
  • FoHF portfolio – investments, liquidity, fees, expenses, …
  • Reporting and analysis module –
    positions, performance, allocation, attribution, exposures/risk key data, …
  • Reporting services interface
  • Reporting web services
  • Import/Export web services
  • Maintenance web services
  • SharePoint document interface
Functions and Project Activities
  • IT Project Management
  • System design
  • Database design, design of software components and processes
  • Development of web applications
  • Development of database back ends
  • Development of web services
  • System- and integration tests, rollout
  • Service and management of the platform
  • Further development of the platform
Hardware
  • HP Blade Server Cluster
  • Dell PowerEdge Server
Operation systems
  • Windows Server
  • Red Hat Linux
  • CentOS
Databases,
Doc.management
  • Oracle 10g/11g/12c
  • SQL Server
  • SQL Server Reporting Services
  • SharePoint
Software Platform
  • .NET
Programming Languages
  • C#
  • ASP.NET
  • PL/SQL
  • C
  • Java
  • LINQ
Dev. Tools
  • Visual Studio .NET
  • ODP.NET/ODAC
  • SQL Developer, TOAD
  • Report Builder
  • GIT
  • SoapUI
Interfaces
  • Web Services (SOAP)
  • Import-/Export-Interfaces
  • WCF Data Services