The agency recruits IT specialists across EMEA and Australia.
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.
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.
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 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.