{"id":1318,"date":"2024-06-06T12:14:18","date_gmt":"2024-06-06T11:14:18","guid":{"rendered":"https:\/\/www.4fx.co.uk\/portfolio\/?p=1318"},"modified":"2024-09-09T15:00:00","modified_gmt":"2024-09-09T14:00:00","slug":"case-study-timesheet-management-system","status":"publish","type":"post","link":"https:\/\/www.4fx.co.uk\/portfolio\/case-study-timesheet-management-system\/","title":{"rendered":"Case Study: Timesheet Management System"},"content":{"rendered":"

\"\"This case study provides information relating to the build of a fully integrated timesheet management system for national construction recruitment company, Constructive Resources Ltd, to streamline construction recruitment<\/strong>.<\/strong><\/p>\n

\"\"<\/p>\n

Vital statistics:<\/strong><\/h2>\n

Project: <\/strong>Timesheet Management System
\nClient: <\/strong>Constructive Resources
\nSector: <\/strong>Construction Recruitment Specialist
\nServices Delivered: <\/strong>Bespoke software design and development
\nLocation: <\/strong>Milton Keynes, UK
\nProject Date\/timescale: <\/strong>6 months<\/p>\n

In Brief…<\/strong><\/h2>\n

Specialist construction recruitment consultants, Constructive Resources, connect temporary workers with a range of roles from nationwide building and construction sector clients.<\/p>\n

Regularly recruiting over 500 temporary workers per week, its job placements range from labourers, site managers, civil engineers, heavy plant and equipment operators to 360 excavator and dump truck drivers and muck shifting crews.<\/p>\n

Manually capturing data from hundreds of timesheets each week in Excel spreadsheets and manipulating the data to create hours and billing reports was putting an administrative burden on the team and allowing manual errors to creep in.<\/p>\n

The Constructive Resources team was looking for a secure solution that would streamline the data entry process, improve accuracy and provide an audit trail for data compliance. They turned to CodeHub 200 for a bespoke software solution.<\/p>\n

Building the Foundations<\/strong><\/h3>\n

Having previously worked with 4FX, for graphic design and its new website, Constructive Resources knew the team had the necessary in-depth knowledge of building complex data systems, as well as particular recruitment sector expertise.<\/p>\n

The admin and payroll teams were already working with an off-the-shelf recruitment software package, Colleague, which records timesheets, allocates cost centres and billing amounts. However this was too in-depth with too much private data to be accessed by the whole team.<\/p>\n

They needed an interim system which provided data security and the ability for data capture, while replacing the manual entry of hundreds Excel spreadsheets. This would prevent access to personal or commercially sensitive information in the backend, while streamlining data entry and providing real time data of the status of the business.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

Delving into the Data<\/strong><\/h3>\n

4fx undertook a full workflow planning exercise of the existing process to understand the requirements for building a secure system that would log and track workers weekly timesheets and create billing files.<\/p>\n

Previously every recruitment consultant had an individual worker list in Excel, which mirrored the backend system for compliance purposes. This detailed who they were, what job they were assigned to, how they got paid and hours worked.<\/p>\n

Recruitment consultants can work with one to 30 people per day. Each individual worker\u2019s details were being cut and pasted into a new spreadsheet every time by consultants copying an Excel sheet, manually deleting rows and adding the new data, even if they were repeat workers.<\/p>\n

This information was then fed into 10 different spreadsheets to be merged by payroll into multiple new spreadsheets to create weekly invoices and HMRC information, which was very labour intensive. It also created significant opportunities for error with multiple versions of people\u2019s names, spellings or payment information.<\/p>\n

The team looked at the ways recruitment consultants used the data to add new worker details, enter client data and timesheet information such as hours worked, pay rate and payment method. It also examined repeat details, search functionality for existing data and identified validation criteria for improving data accuracy.<\/p>\n

Developing a Database<\/strong><\/h3>\n

The new system has created a large worker database where basic details can be entered or received, without access to personal information held in the backend.<\/p>\n

The new online dashboard with user friendly interface has been designed and developed using a combination of C# and AngularJS. The portal gives recruitment consultants, resourcers and administrative staff access to timesheet forms through a secure intranet browser, enabling worker data to be entered directly into a MySQL database.<\/p>\n

Each of the data fields from the Excel timesheets have been replicated on the dashboard with tolerance checking and data validation parameters added to verify data accuracy and reduce manual checking time. There is a built-in a level of validation +\/- X% of an expected value in each data field, so any irregularities are flagged up as they occur and reviewed immediately.<\/p>\n

The new system offers multi-level functionality with user ID level permissions. The team is able to assign physical timesheets from employees and sites directly though an uploader with a tick box to automatically update on the system. These were previously emailed and scanned in. Now data is only seen by users with relevant permissions, is more accurate, secure and it is easier to identify any missing timesheets.<\/p>\n

 <\/p>\n

Streamlining New Starters\"\"<\/strong><\/h3>\n
The system now enables the recruitment consultant to select information such as worker name, client and previous work history from the database, rather than re-keying all the information again, sometimes incorrectly. Keying in of data can now be done by the resourcer as well as the consultants, so more time is available to focus on sales.<\/div>\n
\n

<\/h3>\n

<\/h3>\n

Software Success<\/strong><\/h3>\n<\/div>\n
Four months in the making and with two months rigorous user testing, the CodeHub 200 team has successfully built and implemented a secure, bespoke system that consultants, administrative staff and management can use easily with minimal training. It has removed repetitive administrative tasks, reduced administration time and improved accuracy.<\/div>\n
<\/div>\n
Since the system has been implemented Constructive Resource has saved approximately:<\/strong><\/div>\n