SLFHA - now AmicusHorizon Ltd (April 2008 – September 2010)

Data Consultant/ Project Manager

On leaving SLFHA a year earlier, I suggested they build upon their policy work by evidencing their inspections and performance, remarking that; 'if the Audit Commission cant see it, then you didn't do it!'.

 

I received an unexpected request from Kevin Day, Neighbourhood Services Director that I construct a range of inspection auditing tools.  Over the following year my company, IC Consulting Ltd had worked or tutored in every department with the housing services.

My work has all but ceased at AmicusHorizon as it is now known. The databases require little or no maintenance and the organisation has followed a policy of post merger austerity, compounded by government funding cuts. I do however remain in contact with many of my friends and have a personal interest in their success and that of the organisation.

 

Customer Services - Dynamic Absence Monitor, Agency Worker Database, Web Interface Portal

Neighbourhood Housing Services - Neighbourhood Inspection Database,  Cleaning and Gardening Monitors, Web Interface Portal

Maintenance Call Centre - Call Centre Monitor

Homes for Older Persons Service (HOPS) - Tuition – Basic Computing for Older Residents, Tuition – Intermediate Computing for Staff

 

Customer Services

Dynamic Absence Monitor

  • Produced a spreadsheet based monitor to record and calculate sickness frequencies, patterns and trends by employee, department, front line deployment and reason via a single input.

  • Automatic output to reports and KPI’s

  • Monitors Monday/Friday start days, periods and incidents of sickness over rolling 12 months. Also measures return to work interview performance

Agency Worker Database

  • Records and reports agency worker name, agency, work dates and rate

Web Interface Portal

  • Office based web structure in SLFHA Customer Services house style, users access relevant resources via linked menu

  • Enables management to control access and organise office resources simply and efficiently

Neighbourhood Housing Services (NHS)

 

Neighbourhood Inspection Database

  • Produced a comprehensive inspection recording tool, consistent with the Housing Quality Network (HQN) methodologies and scoring regime

  • Unique as it additionally measure data from block inspections

  • Housing Officers now enter inspection data directly, transferred from paper forms in matching dataset format

  • Monitors Housing Officer and estate performance over a range of government directed indicators

Cleaning and Gardening Monitors

  • Two distinct databases to monitor contract performance

  • Monitors the inspectors performance for consistency and inspection quota progress

  • Produces comprehensive reports as graphical, email or scorecard for KPI use

  • Automatically outputs to word, PDF and spreadsheet format

Web Interface Portal

  • Office based web structure in SLFHA NHS house style (similar to the Customer Services version above)

Maintenance Call Centre

 

Call Centre Monitor

  • Produced a database to capture telephone call duration, by date, reason and call operative

  • Outputs to management reports for KPI purposes

Homes for Older Persons Service (HOPS)

 

Tuition – Basic Computing for Older Residents

  • Produced and delivered all teaching materials

  • Held classes at various venues to suit the customer

  • Received consistently positive feedback

Tuition – Intermediate Computing for Staff

  • Provided ‘in house’ tuition and material for staff wishing to improve file and data management

Tuition – Intermediate Computing for Staff

  • Department now works with improved data co-ordination

  • Eliminated instances of accidental loss or duplication of data

Return to Welcome Page