The agency recruits IT specialists across EMEA and Australia.

Summary

An international recruitment consultancy wanted to simplify and streamline their monthly commission calculations, and provide their consultants with far more detailed information about their work. JumpData and Techccino built for them a simple system with a web-interface to aggregate, manage and report on data from their various systems, saving senior management time and efforts.

The Issue

Our client was using a sophisticated MS Excel workbook to calculate the income generated and commission due for all their consultants. Over time, this workbook had become difficult to manage due to size and increased complexity of formulae. It also required time-consuming data entry from various system, and was used only by senior management. The client wished to have this replaced by a simpler system that could codify their custom calculations and accounting rules, was user friendly, generated automatically commission reports and automated much of the data-entry.

Our Solution

Techccino constructed a web-based user interface to allow simple data entry and non-expert management. JumpData, in partnership, cleaned and migrated all the historical data about consultants, clients and projects into a SQL database. Multiple reports could be generated by month, country, consultant and so on. Data pipe-lines were constructed which allowed automatic monthly importing of all project details from third-party software.

The Result

The new system ran in parallel with the existing MS Excel sheet for a few months before completely replacing it. It is now managed by the accounts department, freeing up senior management time to enable them to focus on other tasks. The reporting functionality provides each consultant with accurate monitoring of their projects and revenue generated for the first time. The system is continually evolving with additional functionality developed and added when required, and is now considered to be integral to the company’s business.

Dramatically Improved

“I imagine the change we have experienced as a company growing from nothing to an SME is not at all uncommon. But, as with many businesses, we made the all-too obvious mistake of sticking with systems and processes we created in the early days and knew well despite their many flaws. Investing the time, money and effort into an unknown quantity just didn’t seem worth the time we were – and always are – much too short of. The team at Tehcccino and Jump Data immediately recognised the problems and quickly designed and implemented a variety of tailored solutions that I just didn’t believe would be possible with the budget I had available. The solutions I now have to hand have dramatically improved all aspects of the data management and processing inherent in running a business, given my employees the depth and breadth of data they badly needed and, most importantly, removed me from being part of the problem!”

Managing Director