tonysmiththathousingitguy @HousingITguy

Some thoughts on IT and UK SocialHousing from a unique perspective of over 27+ years working with over 140 RSL's, Councils and social landlord groups in the UK, Ireland & Australia. (c) No reproduction without prior/express permission Available for independent housing RSL implementation, procurement of HMS, Repairs, CRM, EDM, DLO, Financial, Scheduling systems, critical friend etc. In Scotland I work with the folks at Arneil Johnston Check us out on Soundcloud /housingitguy

Sunday, 18 October 2020

International Dateline

If you do the Twitter thing, follow me at @HousingITguy
or LinkedIn here https://uk.linkedin.com/in/tonysmiththathousingitguy

This week I was working with a social housing landlord client at the tail end of a procurement, where we are down to a couple of possible suppliers and software products.

One of the most important parts of a procurement that I find is generally glossed over, is the reference site follow-up. That probably warrants a whole future blog of its own to be honest, as it can be so crucial in flagging up future issues that may need mitigating in your project delivery.

No doubt about it, who suppliers chose for your procurement says much about how their user base feels and functions in relationships with them. Large suppliers with only the same couple of reference sites definitely should flag up questions, as should why much nearer apparent sites have not been put forward.

In this case, both options had plenty of sites to choose from and spookily the product was sold in many countries and regions around the world. Now I have sat through demos where many familiar suppliers have put that initial slide up to say they have 20,000 people working for them and they have sites all over the place. The claim was generally true, but the reality sometimes is that out of that number, it might just be two men, a lady and a dog, based in some outpost like Cumbernauld employed by them, who actually will be your go-to support.

They might be a very good three person team, but might not be adequate to support a product, over sold to dozens of unwary punters. Inevitably they would be a bottleneck to getting anything done or anything done or fixed quickly. Much like a single point of failure inside a housing organisation, management need to recognise and mitigate it quickly for everyone’s benefit.

These two references were really positive, although one of the people I am working with on the project mentioned something that really surprised them and it made one really stand out for him. The reference site had mentioned that on a number of occasions that help desk tickets had been picked up and resolved for them well out of normal hours, even though contracted support was a working 09:00-17:00. We are all used to logging help desk calls via self-service these days and probably phoning in those emergency (everything down) P1 calls.

The difference was with one supplier, was that a single worldwide helpdesk was being utilised for the product. When the Europe team clocked off, the US team in CA kicked in, Australia next, then the India team. You get the picture. Clearly too, a worldwide helpdesk meant a massive knowledge base supported the help desk staff, it wasn’t just in one persons head. Even though that sort of service wasn’t contracted, it was often delivered.

With a some of our ‘usual suspects’ suppliers now being amalgamated into bigger groups and claiming to have customers across three or more continents using the same products we use here in UK & Ireland, how many will have the ambition to evolve to be more joined up? Is that something your organisation could benefit from, rather than your helpdesk calls often falling out of your contract SLA’s?

Do have it in your mind when that slide of reassurance comes up at the start of your demo, to ask, “Where is your helpdesk located for this solution being offered and are you open enough to share your unvarnished current SLA stats for it”?

Catch the blog monthly archive at
https://soundcloud.com/housingitguy/

_/_/_/_/_/_/_/_/

I would be pleased to connect with you on LinkedIn - http://uk.linkedin.com/in/tonysmiththathousingitguy Message me with any issues or queries, you would like to be explored in this blog. We generally receive a couple of suggestions each month.

Ladytron – International Dateline.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009

Access a quick list of our Social Housing ICT blog posts here

Could we help you or your organisation? Our contact details are here , get in touch we will be pleased to chat about your problems and help with your organisation issues.

File Under: #HomesForBritain,#HousingDAY,#InternetOfTenants,#Shout,#UKHousing, 07854655009, 1st Touch,1stTouch,360,365Agile,3squared,4Js, ACL,ALMO,AMS,AX,Aareon,Abritas,Academy,Accuserv,Accuserve,Active Housing,ActiveH,ActiveHousing,Acutence,Advanced,Agile,Agile365,AirWatch,Alfresco,Alignment,Allpay,Amazon Web Services,Anite,Apex,App,ArchHouse,Archouse,Asprey e-state pro,Asset Management,Associates,Aurora,Average IT Costs,AWI SX Integration Toolkit,AWS, BI,BO,BPR,BancTec,BigChange,Blockwise,BluTek,Bluebox,Blueprint,Browser Applications,Business Objects,Business Planning,Business Process Review,Business social networking, CACI,Capita One Housing,CBL,CCS IT Keystone CCSIT,CEDRM,CHICS,CHR,CIH,CMS,COA,CORE,CPL,CRM,CRM2013,CRS,CTI,CTX,Cadcorp,Capita,CapitaOne,Capita One,Capital Management,Cashflow,Castle,Castleton,Castleton Technology,Cedar Open Accounts,Cerrus,Change,Charges,Chartered Institute Of Housing,Cheaper Housing IT,Chics, Citrix,Civica,Civica CTX,Civica Cx,Civica Genero,Civica Saffron,Clearview,Clik,Cloud Dialogs,CloudDialogs,Coactiva,Codeman,Comino,Commontime,Community Reward Services,Company,Competitive Dialogue process,Component Accounting,Consilium,Consolidation, Consultancy,Consultant,Consultants,Contact Manager,Context,Contractor Systems,CorVu,Cost Reductions,Covalent,Crystal Reports,Customer Relationship Management,Cx, DRS,Deeplake,Designer Software,Development Systems,Director,Document,Documotive,Docuware,Dynamic AI,DynamicAI,Dynamics 365,D365,Dynamics365, ECMK,EDM,EDRMS,ERP,ESRI,Elmhurst,Enghouse Interactive,England,English,EnterpriseBI,Estatecraft,Etive,Exhibition,Exponential-e, Facebook,Factorwise,Field Service management,Finance,Financial Systems,Financials,Footprint,Forms,Freezes,Fusion, Gas Tag,G-Cloud,GCloud,GDPR,GGP,GIS,GasTag,Genero,GeoSolveIT,Getting best from,GoTonySmith,Grasp,Grip,Group Apex, HFI (Housing Financials interface),HG,HRA,Hardware,Hitachi Systems,Hitex,HomeMaster,Hometeam,HouSys,House,Housemark,Housemark survey,Housing,Housing Contact,Housing Group,Housing Insight,Housing Management,Housing Management Consultant,Housing Partners,Housing Portfolio Management System,Hub Asset Management,Homeswapper,Housing jigsaw, Housing Support Pro,HousingIT,HousingSupportPro,HyperOptic, IMS,IT,IT Budget,IT Training,ITIL,Impact Response,In,In4,In4Systems Promaster,InfoBoss,InHouse,InMotion,InMotion2015,InMotion2016,InfoBoss,Infoflow,Information,Information Technology,Information@Work components,Informix,Innovation, Informetis,Inphase,Inside Housing,Insight,Internet Portal,Internetalia,Invu,Ireland,Irish,itLab, Keyfax,Keylogic,Keypera,Keystone,Kirona,Kypera, Landlord,Ledgers,Linkedin,Liquid,Locality,Localz, M3,MAVIS,MD,MDM,MI,MIS,MIS-AMS,MISCS,MRI,MS Dynamics,MRI,MS Dynamics CRM2011,Microsoft365,microsoft 365,MWL,Management,Management Server,Manifest,Measuring,Mebus,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid, NDL,NINTEX,NINTEX workflow,NPS,NPS ASSIST,NPS Housing,NPS Job Manager Mobile,NROSH,Natural,Neighbourhoods and Communities,Nintexworkflow,Northgate,Northgate Codeman,Northgate Public Services,Notice, OA,OGC Buying Solutions,OJEU Limits,ORS,Ohms,OmFax,Omniledger,One,OneAdvanced,OneServe,Open source,OpenContractor,OpenHousing,Opti-time,Options,Optitime,Oracle,Orchard,Outsource and outsourcing,OutSystems, PIMMS,PIMSS Data,PM,PRINCE2,Paloma,Pamwin,PanConnect,People Value,Peoplevalue,PfH,Pick,PlanForm,Planned maintenance,Plenfific,Plus,Portfolio Management System,PowerObjects,Pro,Pro-Points,Prodo,Progress,Promaster,Propoints,Proval,Providers,Pyramid, QL,QuantSpark,Qube,QLX,Qlikview,QueryView,Queryview reporting,Quiss, RM865,ROCC,RPs,RSL,Rave,ReAct,Reality,RedkiteCRM,Red Olive,Registered,Registered Social,Rent Increase,RentSense,RentSenseLite,Repairfinder,Reporting,Reports,RobotAutomation,Rocket, Salesforce,Salesforce.Org,SAP,SASSHA,SDM,SHBVN,SM,SOTI,SP,SQL,SQL Open Housing,SQL Reporting,SQL Server,Saffron,Safron,Saturn,Scenario,Scotland,Scots,Scottish,Scout,Sequoa,Serengeti,Serros,Server,Service,Services,Servitor,Sharepoint,Sim,SimPro, Simdel,Simdell,Slash and Burn,Social Housing ICT,Social Housing Software Applications,Social Media,Software,Software solutions,Spotlight Service,Spotlightservice,Star rating,Stores and Stock,Strategic,SunAccounts,Sunguard,Surveys,Streetwise, Swordfish,Sx3,Symatrix Human,System alignment,Systems,Systemwise, T-Files,TEAMS,TED,TFiles,TP Tracker,TSG,Tagish Casework,Tagra,Task,TAIM,Technologies (India) PVT Limited,Telecetera,Template,Terminal Services,That,Three Star,Today,Tony Smith,Tony Smith That Housing IT Guy,TonySmith that housing IT,TonySmithHou,TonySmithHousing, ,TonySmithHousingITguy,Total,Total Mobile,Totalmobile,Trace,Tribal,Twitter, U2,UC,UK,UK Housing,Ukhousing,UniClass Enterprise,Unidata,United Kingdom,Universal,Universalcredit,Universe,Unrest, Valueworks,Van Stock,Vantage,Vantage Sentinel,Version,Virtualisation,Visualmetrics,Voice,Voice and data,Voluntas, Wales,Welsh,Wheatley,Windows Server,Workflow and,Work Hub,Works Connect, XML,Xen App,XenApp,Xmbrace, ...
. . . . . . . . . . . .

Tuesday, 6 October 2020

Serco Don’t Lose That Number!

If you do the Twitter thing, follow me at @HousingITguy
or LinkedIn here https://uk.linkedin.com/in/tonysmiththathousingitguy

Earlier this week, a few thousand people and probably a dozen at least of my contacts, probably grinned with a knowing smile.

Of course I am writing about the UK’s national Serco Test and Trace spaff-up, relying on Excel spreadsheets, to collate and process Covid-19 tests.

If I had £500 for every time I had told people off for calling 'info in spreadsheets', a database, I could have retired by now.

The situation could be laughable, if it were not so important and crucial.

Now, if anyone wants to spread blame around, I would personally start with Microsoft. Why So, you might ask🤔

The original Lotus 1-2-3, as anyone who broke their teeth on it during the 1980’s may remember, only had a maximum of 8,192 rows (and 256 columns). Now if it had stayed at that size, a very limited number of fools would have tried to store lots of data in it and sensibly selected a proper database to do the job. But no. As Reeve’s and Mortimer might have said, “They couldn’t let it lie” - .

Microsoft’s Excel gave us 65,536 rows, immediately giving the illusion of it being a ‘database’, not a useful summary manipulation and presentation tool, which is what a spreadsheet does best. I have been involved in so many projects where users, managers and directors in some cases, have been firmly wedded to spreadsheets, needing to migrate to proper solutions, with protection, data control and robust audit. I have often proposed amnesty, after replacement system go-live, where spreadsheets can be dropped.

My proposal is that if the fearsome and opposing communities in Northern Ireland, could put their weapons beyond use, we should have a spreadsheet version of the Good Friday Agreement, where users do the same and promise never to return to them again. For some its starting to catch on thankfully.

For sure, Excel can be a good place to start for an initial prototype, but no one should continue to try to run a whole enterprise on it. Serco are not alone. Eight years ago or so, I worked with a big organisation, dealing with £8m of monthly transactions on Excel with its one million row and memory limit creaking & ready to break. Fifteen years earlier, with a turnover a 50th of that, spreadsheets just kind of worked. For that organisation it took about 4 months to procure and 12 to implement, a proper finance, feeder and self-service solution and they never looked back.

Serco however have apparently been paid £12b of taxpayers dosh and should have been able to build their own database quite quickly with 20 or so of the right ICT staff, none of which would have probably stuck with Excel, if there was any capability of a millions of test a day Moonshot a-coming.

In my time manipulating data, I have witnessed many things Excel does trying to be clever, without telling you. Truncating to 65,536 is common where old solutions can only use XLS format to export. No doubt you might have experienced that too. The type and length of unique ID’s seen in the SocialHousing sector, is ripe for Excel to helpfully swap then to scientific notation. How we laughed at that one, several weeks down the line.

So, beware the spreadsheet, its not a database. Don’t do a Serco Track & Trace, learn from their mistakes.

Who in YOUR organisation needs to take that advice to heart?

Catch the blog monthly archive at
https://soundcloud.com/housingitguy/

_/_/_/_/_/_/_/_/

Steely Dan – Rikki Don’t Lose That Number.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009

Access a quick list of our Social Housing ICT blog posts here

Thursday, 1 October 2020

Rescue Me

If you do the Twitter thing, follow me at @HousingITguy
or LinkedIn here https://uk.linkedin.com/in/tonysmiththathousingitguy

Perhaps no one (except for maybe Albert Camus, seventy three years ago), could have confidently predicted COVID-19’s impact on the Social Housing sector in 2020 – particularly its repairs function.

Last week’s news of more lockdown-focused tightening prolongs existing challenges even further.

Most of the organisations I work with, especially where internal direct labour is involved (the trusty DLO or Building Services Team), have stripped back their repairs function. It’s just Emergency and Voids works now.

For the latter, a couple of my clients have focussed on preparing temporary accommodation for homelessness provision or early prisoner releases. Many DLO staff, including one on my street, oddly enough, have been furloughed.

More than one current client of mine has highlighted that tenants are ‘cottoning on’ to the new normal and logging minor issues as far larger ones, to squeeze repairs into the Emergency priority zone.

The dilemma for all appears to be a building backlog of ordinary, urgent, routine repairs (and some Right-To-Repair priorities in Scotland). Regulators seem to have dragged their feet in offering direction. However all those logged issues will have to be chewed through and everyone expects their current workforce to struggle when work orders can finally be scheduled.

Back in January, I blogged about Plentific, which could be described quite rightly as the socially-minded ‘Uber of Repairs’. The company and the concept is interesting to me as it has gained exceptional traction with providers such as Notting Hill Genesis, Peabody and uses a unique platform attractive to the sector. It also features a mature marketplace to match skilled staff, rated on each job, to sector demand. Verification of staff certifications and capabilities are coupled with a fast-paying financial platform, a key benefit for the framework of contractors.

The Plentific Platform

I was interested in how Plentific is expanding across the wider UK and more so, how COVID-19 may have impacted its business model. What’s the best rating achievable for works undertaken in this new normal?

Like others, Plentific initially saw a drive to more Emergency priority work, including the new innovation of COVID-19 deep cleans, particularly in London, where the Coronavirus spike hit first. With a number of trade staff within social housing clients self-isolating or furloughed, Plentific throughput was similar to the same quarter 2019.

From recent webinars and my own contacts in the sector, I know that Plentific is rapidly expanding into major conurbations across the UK. I understand that expansion of the platform’s ecosystem has led to more partner contractors under their wing already in the West Midlands, Birmingham, Manchester, Leeds and Liverpool.

This important development I believe unlocks a potential new resource in the main urban areas, becoming available to be used as a ‘pressure release valve’, for the social housing COVID-19 backlog.

More importantly, if as the scientists seem to be suggesting, a second peak arrives, Plentific might well be the backup for a DLO or your key partnering contractor.

Plentific Battling the backlog discussion

Availability of solutions, as we all know, is one thing. Passing muster with procurement in order to exploit a new digital-world contractor, such as Plentific, can be something else. Framework-only is quite common these days, particularly in local authorities and fortunately a framework does exist.

Personally, I am liking the ‘Uber of Repairs’ concept, particularly as it's cost effective for landlords and potentially can drive up resident satisfaction. Contractors seem to like Plentific too, as it’s a personal and on-going relationship (way beyond the taxi Uber). Go check out more at https://www.plentific.com/

Catch the blog monthly archive at
https://soundcloud.com/housingitguy/

_/_/_/_/_/_/_/_/

Cabaret Voltaire - Rescue Me.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009

Access a quick list of our Social Housing ICT blog posts here