Software Development Case Studies

Here are three examples of Software Applications:

Year End HR Reporting: Allied Distillers

JEMCO was approached in 200X by Allied distillers staff in Glasgow.

They had a brief to analyse the years HR data on hours worked sickhours and so on.

The deadline for the delivery of the reports was in two days time and they did not know how to proceed in compiling and analysing the data.

A workshop was set up for analysing the data with Excel.

The data, unseen before the workshop was studied and final reports created using advanced level Pivot Tables after some cleaning up of the data.

The entire exercise took 3 hours from first sight of the data to final report production.

The time saved was 6 man days work per annum.

The client was delighted with the outcome.

Perhaps we could do the same for your organisation

back to top

Training and Certification Records database; Diageo

In 2005 JEMCO was requested to create an HR Training records log for staff at Diageo.

The database had to be produced within two weeks to be included within the current financial years budgets.

The brief was to produce an easy to use single user database allowing rapid data entry for the tracking of courses attended and certificates gained with analytical reports pre configured.

The clients IT department would not support MS Access therefore MS Excel had to be utilised.

The end product was delivered within 10 days utilising an MS Excel workbook with custom picklists and macros.

The client was supplied with a fully fledged application allowing rapid data entry with minimal training requirements due to the easy navigation and help information included on the sheets.

The client was delighted with the final application and the speed of response of our service.

The time saved by the utility was estimated at some 24 man days per year.
Perhaps we could do the same for your organisation.

back to top

Custom MS Project Timesheet Extraction Routine: Royal Bank of Scotland

At the time of the request JEMCO were providing MS Project training for the Business Integration Department of the Royal Bank of Scotland, Edinburgh Head Office.

The department wanted to use MS Project as a timesheet datacapture method for all staff for payment of wages.

JEMCO created a custom view in MS Project allowing users to enter time against project and non-project work in a robust error-free manner.

The data was then extracted to Excel utilising a custom built extraction utilitywhich exported the data directly to Excel in a pre-determined layout for capture by the RBoS accounting system.

The utility allowed the user to choose the project file and date range of the data required for extraction giving a seamless exportation of the data from any view in the package. Error checking for the correct number of hours in the working week was included in the routine.

The Extraction utility was delivered tested and fully functioning within 20 days from the awarding of the contract and was used by some 300+ staff members.

The time saved by the utility was estimated at some 300 man days per year.

Perhaps we could do the same for your organisation.

back to top

Contact John Cowie on 0791 787 4739 to discuss your requirements, or use our enquiry form.