Time Critical Solutions (TCS) Ltd, formerly ETL Motion Ltd, continues to maintain a strong relationship with many corporate and SME clientele who have trusted us to deliver their solutions and appllications to the highest industry standards and most stringent commercial timetables. In fact, Time Critical Solutions (TCS) Ltd, also known as "TeCS", is a preferred technology solutions provider to many organizations throughout the UK, wider Europe, and beyond. In particular, TeCS has now establish a base in Cyprus, a full member of the European union and a trading gateway between three major continents being Europe, the Middle-East, and North Africa enabling us to serve these regions, and Cypriot companies more effectively.

Our longest-standing client relationships have been our corporate clients because of the continuous stream of projects that they often have scheduled, however, we maintain close contact with all of our clients in order to anticipate their requirements and give them a competitive technological edge over their competition. A few examples of the work we have done for major clients is briefly discussed below:

Works Undertaken

ETL and Data Warehousing Consultancy:-

TeCS Technology Consulting supplied expert ETL and data warehousing consultancy to project teams throughout the 100 strong IT Services team at London Underground IM consultancy, enabling TFL to deliver an array of major MIS and operational projects over a four year period.

Applications Development:-

TeCS Applications/Web Development delivered many major data and front-end components of the following multi-million GBP projects that have made a real difference to the quality of service London Underground has been able to provide customers, including:

Projects Overview(s)

SSTA (Single Source of Truth, Assets):

�4.5m intranet based centralised asset management system, able to track the location, projected depreciation and team allocation of every one of the tens of millions of physical assets owned by the London Underground rail network infrastructure – from every piece of track, to every train carriage to every track signal, etc. This was a major undertaking and drew heavily on the experience and expertise of the TeCS architectural, design and development team. (Technologies employed: Hummingbird ETL, SQL Server 2005, DTS, and c#.NET 3)

KPI (PRT):

�2.5m intranet based inter-departmental key-performance indicator measurement and comparison system that has enabled all departments with London Underground to measure their progress against the criteria that is relevant to them. This system also contributes directly to personnel reviews and appraisals all the way to director level. (Technologies employed: Hummingbird ETL, SQL Server 2005 and c#.NET 3)

Trackernet:

Underground GIS system, able to show operational staff precisely where any one of the 700 trains that run simultaneously within the underground rail network are at any one time. The system provides play-back, rewind and record systems enabling operation staff to review any train incidents (such as derailments, or signal violations) from an auditing and safety management perspective. (Technologies employed by the team included: Microsoft Silverlight on c#.net 3 and SQL Server 2005, and related tools)

---

TeCS Technology Consulting established a long working relationship with GE Health Care Plc, one of the very few authorised nuclear medical-research sites in the UK, based in Amersham, and part of perhaps the world’s largest conglomerate, General Electric.

Works / Project Overview

TeCS Technology Consulting provided database process optimisation and processing support services to the global revenue reporting system of the organization. The systems was developed to take regular data feeds from sales divisions from more than 100 countries world-wide at any one time, these subsequently being validated, matched, and loaded into an corporate-wide online sales reporting repository/data warehouse for real-time management information – and subsequent deliver into GE Healthcare’s SAP systems.

---

Powergen (under it's new parent company, E.ON) is one of Europe's largest energy generators and retailers supplying millions of customers throughout the UK and Europe. TeCS had the honour of providing industry specific bespoke systems to Powergen on the basis of TeCS's substantial experience of developing MIS systems within this vertical market - specifically based on its long-term working relationship nPower, formerly Yorkshire Electricity.

Works / Project Overview

TeCS Web/Applications Development tendered and won the contract to deliver a national, high-volume data warehouse that would give real time management information to the distributed, nationwide management team at all levels within the organization. The project involved taking literally hundreds of disparate data feeds from many operational systems throughout the organization, and centralising the data into a coherent, consistent and validated data warehouse to be used for management reporting nationwide.

---

Like Powergen, nPower (formerly Yorkshire Electricity) is one of Europe's largest energy suppliers, supplying millions of customers throughout the UK and Europe. Our relationship with Yorkshire Electricity has continued over a period of two and a half years, during which time we took responsibility for developing a number of management information systems and CRM systems. We were amongst their preferred supplier of corporate wide expert systems, integrating this data from many of their operational systems, and centralising it in structured data marts and data warehouses to facilitate real-time reporting at both an executive and managerial level.

Works / Project Overview

The team at TeCS was responsible for developing much of the CUADP national customer-understanding MIS system used throughout the nPower retail energy operation, as well as being closely involved with a number of other internal MI reporting systems, deployed on Windows and the nPower intranet. Our team worked on-site with nPower MI across 3 sites, including the company HQ at Scarcroft, Leeds within the UK.

---

SEMA Plc is a listed, international software development company in its own right, so we were flattered when they outsourced an important part of their contract to deliver a nationwide transaction auditing system to us on behalf of their client Post Office Counters Ltd, a national UK postal institution.

Works / Project Overview

TeCS Web / Application Development took responsibility for the development of complex modules for a high volume Transaction Information Project (TIP) serving the whole of the Post Office branch network throughout the United Kingdom. The project was based on Oracle 8i in a UNIX environment. The system relied heavily on effective PL/SQL development due to the high transaction processing involved. Pro C, Business Objects, Constellation Hub, and UNIX shell scripts were developed to allow for overnight scheduling of overnight batch processing of much of the operational data required by post offices throughout the entire country.