arrow line bg

our work


Software Case Study

Archer Capital Management is a hedge fund focusing on the middle market.

The Problem

Archer collects data from its clearinghouses and stores the data in a local database which was maintained onsite. This database would then be used to populate Excel files which ran complex macros and calculations. The process took over 4 hours and consistently crashed and kept staff in the office well past 9:00 pm.

The Goals


Reduce the runtime by 2 hours


Increase reliability


Use a more secure method of backup and maintenance for their onsite server


Increase the functionality of the reports


Maintain the connection between the Excel files and the database

cone bg white cylinder bg gold rod bg ball 1 bg ball 2 bg gold prism bg

The Solution

We moved the database server into our data centers where our staff could maintain it and back it up properly, increasing Archer’s compliance and governance.

We automated the process and reduced the run time from 4 hours to under 5 minutes. We also added functionality to:

  1. Keep a complete history of all data (better compliance and reporting)
  2. Audit connections and changes to the database (better governance)
  3. Create a web portal where they could log in to monitor the processes and turn on or off access to the data and define the level of access (better governance)

We updated the Excel files so they could pull data directly from the database, which allowed staff to work from home instead of the office. Our system averaged about one issue per year versus once per week with the original system. Lastly, we made the reporting updates that could not be performed by Excel and then allowed the data to be exported into Excel for use.