Andrew Johnston: Professional Consulting Services

Case Study - TRW Inc / ID-Workshop Ltd. (May 2014 – Present)


Development of a web portal for the automotive aftermarket

Key Outcomes

Delivering a complex system ready for commercial exploitation

Key Challenges

Complex technologies and supplier structure, split between UK and Germany

Key Technologies

Amazon Web Services, Oracle WebCenter, Microsoft stack, Linux and open source technologies


TRW was seeking to establish an innovative web-based capability for the automotive aftermarket, fully integrating cloud-based vehicle diagnostics, technical workshop data, a knowledge base and distributor parts catalogues.

A small team of consultants was engaged at a point where the project was under imminent risk of closure, having spent a large investment with relatively little result. We first assessed that the project was worth saving, and were then challenged to do so.

A crude Proof of Concept had been developed without any effective unifying architectural viewpoint, and fell well short of commercial expectations in terms of usability, performance, reliability and scalability. As Programme Architect I worked with developers in London and Berlin to progressively develop unifying architectural principles, covering aspects such as performance, scalability, usability and reliability, and then to progressively apply these to an initial proof of concept to a point where we had confidence of its ability to perform as a commercial product. Alongside this I provided input to colleagues performing similar reworking of the programme’s commercial, management and procedural structures.

With the main development secured I undertook the prototype development of the system’s knowledge base. This can synthesise information from a number of external sources to guide mechanics from a diagnostic trouble code through to a parts recommendation which can then become a query in the distributor’s parts catalogue.

Following the ZF acquisition of TRW, ID Workshop was spun off as an independent entity. I continue to advise the directors on the technical evolution of the core system, while providing ongoing development of the knowledge base, which is evolving to incorporate significant expert system and machine learning capabilities.


Peer Assessment

Please take a look at some of the nice things colleagues said at the end of project wrap-up.

© Questa Computing Ltd. 2014
Page last updated 10 March, 2017 11:30

Questa Computing Ltd. is registered in England and Wales number:2889117.
Registered office: Ember House, 35-37 Creek Road, East Molesey, KT8 9BE UK
For credits, copyright details and cookie policy, see here.

Search my Sites:

Share this page:

Share |


Favourite/Major Articles
All Articles by Category
All Articles by Title
Review Index

Site Map:

Welcome / Home Page
Contact Me
Search the Site
Thoughts on the World
Consultancy Services
An introduction
Key Skills
Career Summary
Case Studies
IT Knowledge/Education
Customer Profiles
Training Courses
Previous Experience
Download Full CV
National Grid Group Plc
British Energy Power and Energy Trading
Legal Marketing Services Ltd.
Marks and Spencer Plc
Faith Footwear Ltd.
Barclays Sales Financing Ltd.
Oracle Corporation UK Ltd.
Livingston Rental Group Ltd.
National Power Plc.
Agile Development
Coding Projects & Thoughts
General Thoughts
Products and Projects
Reviews: Books, Music & Films
Website Announcements
Full Index
Publications and Papers
A Hacker's Guide to Project Management
Conference Papers
Agile Architecture
Practical Enterprise Integration
Modelling an Enterprise Data Architecture
Strategies for Flexibility
Getting Sizing Right
Muzzling the Alligators
Evolution of a Test Method
Photography Articles & Discussion
Photo Gallery
Projects and Products
RelQuest - Reliability Modelling Tool
ConQuest - Container Yard Management System
Full Index
Biography and Personal Endeavour
Construction & Civil Engineering
Human-Computer Interaction
Mathematics & Statistics
Military & 20th Century History
Modelling & Analysis
Photography & Photographers
Physics & Cosmology
Project & People Management
Psychology & Human Behaviour
Science, General

Contact Me

Email me

Feeds and Tweets

Follow me on Twitter


Thoughts on the World
(main feed)

Feedburner XML
RSS Version XML (direct)

How many subscribers?

Other Feeds

Professional Blog
Photo Blog
Photo Album
Review Pages

About my feeds

Google Blog Search

References to
References to

Sister Sites: