Systems Integration and AutomationStonehage Fleming

Altitude assisted with internal projects to automate and integrate data from numerous external data feeds into their internal reconciliation system, AutoRek, so that the data could be reconciled with their client administration system, 4Series. This included bank and securities statement details and daily foreign exchange rate & securities pricing feeds.

Altitude also helped with the setup and support data feeds and data manipulation scripts in AutoRek.

Altitude developed a system using Microsoft System Centre Orchestrator (SCORCH) to automate the retrieval of source data from different sources - such as downloadable CSV files from SFTP servers, extracting attachments from emails and pulling files from the local network.

  • Technologies
  • SCORCH
  • MS Excel
  • AutoRek
  • SQL Server
  • Opalis Integration Server
  • Microsoft System Orchestrator