Andrew Johnston: Professional Consulting Services

Curriculum Vitae and Customer Profiles

Since 1994 I have been working as an independent consultant, trading as Questa Computing Ltd. In addition to a number of short assignments for private clients, I have supported several major clients in a range of capacities, as described below.

Yodel Ltd. (June 2015 – February 2017)

Yodel, a UK parcel delivery company, was created out of the merger of two disparate companies, and has an IT estate characterised by significant duplication and ageing legacy technologies. The company decided to replace these with a streamlined and consolidated solution based on more modern approaches.

I was engaged to support a small existing Enterprise Architecture team by documenting and guiding the architecture of the new core system and its integration. When the original package-based approach was abandoned in favour of an internal Oracle-based development, I helped create a strong service- and event-based architecture capable of managing Yodel’s significant business volumes in real time. I documented these in a set of comprehensive reference architectures.

One particular challenge was to ensure that the solution met high business expectations in terms of performance and reliability, in a highly cost-constrained physical environment.

In addition, I designed an identity management solution for external users (using OpenLDAP), conducted an independent review of a problematic billing system, and supported the development of Yodel’s first customer mobile application.

TRW Inc / Yodel Ltd. (May 2014 – Present)

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.

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.

I also undertook (and continue involvement in) the 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.

The project has a complex technology mix included Amazon Web Services (cloud hosting), Oracle WebCenter, Microsoft stack, Linux and open source technologies.

Coleman Research Group (September 2014 – Present)

This US-based market research group uses me a part of a panel of external consultants providing market perspective to prospective investors in IT and related businesses.

National Grid Plc. (February 1997 – present)

At National Grid (NGT), I have worked in a wide-ranging role contributing to the group’s IT Strategy, technology development, merger activities, and individual system architectures. I have contributed to major business and technical change, and developing the role of IS architects throughout National Grid.

I have worked with successive IS Strategy Managers to develop the formal IT Strategy, aiming to deliver increased business value while reducing inefficiency, fragmentation and duplication. I innovated popular ways to document and communicate the strategy - the unique and acclaimed “roadmap” representation was my own invention.

As National Grid has grown by acquisition, I have been involved in various pre- and post-merger activities, including moves towards a unified IT Strategy, streamlined technical governance, and a group-wide Internet structure. NG use various system sourcing options, and I have been involved in preparing ITTs, evaluating suppliers and solutions, assisting managers new to the systems procurement process, and providing technical supervision to suppliers.

In late 2002, working with external consultants and the business, I articulated a new vision for the systems supporting NG's asset and work management. This was based around a central asset repository, with an integrated document management system, a field force solution, and a comprehensive data warehouse with Business Intelligence tools, all integrated by a shared EAI backbone.

This has now been almost fully implemented through a major programme of IS and business change, and is delivering business value. In my role as Solution Architect for the £34M programme I provided guidance and supervision to internal and external service and solution providers, maintaining a “hands on” approach. In particular I have been actively involved in the analysis, solution design and resolution of a number of integration, performance and reliability issues.

I then led the replacement of the mobile PC platforms for the various field force solutions, replacing several disparate solutions with a solution family based on a common software architecture. As part of this programme I persuaded National Grid to take an agile approach to introducing a PDA “point of work” inspection solution, which helped deliver solid business benefit much more quickly and cheaply than the normal waterfall method would have done.

Since 2007 National Grid have been engaged in a major programme of systems replacement and rationalisation, starting with their core Asset and Work Management system and now extending to almost the entire landscape. This has included refreshing the integration architecture and building comprehensive integration with a new SAP “back office”. I have worked as Lead Solution Architect and Design Authority throughout this continuing programme, and can claim to have driven design decisions which have delivered innovative value or substantially reduced costs, risks and business impact. In particular by exploiting and extending the strong integration architecture developed earlier we have now managed at least five major system replacements with almost zero impact on other systems at each stage.

Most recently my focus has been on developing a Strategy and Architecture for “Strategic Asset Management”. This programme aims to create an environment in which traditional asset data can be combined with data collected directly from assets in near real time, subject to novel analyses and presented through graphical composite applications to enable a move to condition, risk and criticality-based asset maintenance and replacement planning. As such it will form a major plank of Transmission’s strategy to meet their obligations between now and 2020. The initial stage has delivered an enabling communications and security layer, and I am now developing the data management and application architecture which will exploit this.

I have worked closely with a number of senior business managers, to develop and communicate the planned IT changes and ensure they meet the business aims. My success in defining and executing the Solution Architect role has been recognised by NG, who have made it the template for architects throughout the organisation.

In 2012 National Grid contracted with CSC to re-host the majority of their systems in new CSC data centres. I worked as the lead architect for the IBM team supporting that programme, planning and assuring the migrations from an application perspective. This required building a comprehensive understanding of around 50 complex and legacy applications to identify an appropriate migration approach, required remediation work and appropriate testing for every application. I also had to ensure that the preparations being made by IBM, CSC, networking partners and third party application vendors would provide for a “joined up” and low risk migration of each application in the IBM support portfolio.

It became apparent early on in the programme that there were few established processes and templates suitable to the National Grid situation, and I led a multi-partner exercise to progressively develop a suite of guidelines, documents and processes which could be repeatably applied by various teams to develop the required understanding for each application in turn. During the actual migrations I took an active coordinating and troubleshooting role, on several occasions identifying the source of issues and their likely resolution. 

British Energy Power and Energy Trading (February - June 2007)

BEPET were in the process of refreshing many of their trading systems. In this short engagement I helped define the requirements, future architecture and project direction for the Retail Spine, which handles the commercial processes for around 10% of Britain’s electricity, supplied to some of its largest corporate consumers.

Legal Marketing Systems Ltd. (January-July 2004)

LMS proposed a major innovation in their core business process, remortgage conveyancing. I assessed whether their existing systems could support the revised process and what changes would be required. I then provided consultancy as this moved into the implementation phase.

Addison Wesley (January 2003 – present)

I regularly review book proposals and manuscripts for this major technical publisher.

Marks and Spencer Plc (May 1999 - June 2002)

Marks and Spencer had an urgent business requirement for a new back office system, for which several previous projects had failed. It was subject to a number of severe and conflicting constraints limiting timescales, the delivery of new software, and available WAN bandwidth. I designed a solution which met the very tight deadlines, used roughly 1% of the previous communications bandwidth, and exploited the existing Microsoft Office/Exchange infrastructure to deliver substantial functionality without any new components at the desktop. The solution reduced a key business process necessary to get and keep goods on sale from over 14 days to a few hours.

I provided technical leadership for two years, as the design was substantially extended in scope, including multi-country and multilingual support. Complex business and formatting rules were moved from the code to a rule database, substantially reducing the source code, and the system migrated to a very flexible component-based architecture.

Marks and Spencer cited me as co-inventor (with the key business manager) in a patent application covering several important concepts from this system. After the main project I continued to provide occasional consultancy for its development, including a working thin-client prototype of the system, using Microsoft .NET technology, developed in just ten days.

Faith Footwear Ltd. (May - November 2001) 

In Summer 2000 I undertook a short fixed-price study to assess Faith's existing IT provision, and possible ways in which it might evolve to support new business models such as collaborative working with suppliers using eCommerce technology.

This led in 2001 to my involvement in a project to establish a Management Information database, and support for new business models. I developed a proprietary transport-independent EAI messaging system running between the stores and their head office supporting data warehousing, software distribution, application integration and distributed near-real-time processing.

Barclays Sales Financing Ltd. (January - June1999)

During this short assignment, I provided support for both the development of the system architecture and supporting standards, and also for the development of an intranet-based toolset for document distribution and control within the development team.

Oracle UK (June 1998 – March 1999)

Oracle’s Interactive Services Project was developing the platform for British Interactive Broadcasting’s interactive digital television service. I undertook a review of the design to assess its likely reliability, which included the development of a novel Fault Tree Analysis technique for such systems. In addition, I supported the development of system test plans and technical strategies for aspects such as error handling.

Livingston Rental (as an Associate of Sema Group) (March 1995 – January 1997)

This project centred around porting the Livingston Group's rental systems from a legacy Data General architecture to a more flexible Unix/Oracle base.

I defined the overall architecture for the new system. Performance benchmarking and prototyping exercises saved the client several hundred thousand pounds by allowing the use of lower-specification hardware . The performance prediction work led to a paper for the EUROStar '96 testing conference.

A leading role in commissioning the new infrastructure included setting up the Sun servers, defining a disaster recover plan and operational procedures, sorting out LAN communications and establishing new configuration control tools. I also set up a Wide Area Network between several European sites, using ISDN and the Suns as WAN routers.

Thereafter I specified, designed and implemented the following:

    • A system to replicate stock information between the British, French and German sites, using Oracle database services, and Visual Basic for the client-server front-end.
    • A scheme for remotely monitoring numerous aspects of system performance on the various Unix and NT servers and Oracle databases, relaying potential alerts back to a single point for system administrator attention via a graphical front-end.
    • A tool to automate translation so that English, French and German versions of the Rental system (written in a Unix-based legacy 4GL) could use common source code.

National Power (July 1994 - March 1995)

I supported the introduction of Windows-based code control and automated test tools, and helped define repeatable system testing for the project. To control delivery of complex software infrastructure components, I specified, designed and built a unique PC-based configuration tool using PVCS and a component database. I also led a project to update, index and promote the development method and standards, to encourage developers to adopt and follow them.

© Questa Computing Ltd. 1999
Page last updated 10 March, 2017 11:45

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 |

Indexes

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
Customers
National Grid Group Plc
British Energy Power and Energy Trading
Legal Marketing Services Ltd.
Addison-Wesley
Marks and Spencer Plc
Faith Footwear Ltd.
Barclays Sales Financing Ltd.
Oracle Corporation UK Ltd.
Livingston Rental Group Ltd.
National Power Plc.
Blog
Agile Development
Coding Projects & Thoughts
General Thoughts
Humour
Personal
Photography
Products and Projects
Publications
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
Photography Articles & Discussion
Photo Gallery
Projects and Products
RelQuest - Reliability Modelling Tool
ConQuest - Container Yard Management System
Reviews
Full Index
Architecture
Biography and Personal Endeavour
Construction & Civil Engineering
Cryptography
Fiction
Human-Computer Interaction
Mathematics & Statistics
Military & 20th Century History
Modelling & Analysis
Photography & Photographers
Physics & Cosmology
Project & People Management
Psychology & Human Behaviour
Science, General
Links

Contact Me

Email me
@TweetAndrewJ
Others

Feeds and Tweets

Follow me on Twitter

@TweetAndrewJ

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 www.andrewj.com
References to www.agilearchitect.org

Sister Sites:

www.agilearchitect.org