TCM is an integrated infrastructure and service provider and one of the largest privately owned IT companies in South Africa. TCM has over 600 staff, offices in all major cities, plus numerous satellite branches. In order to maintain its impeccable service record and increase customer satisfaction, TCM used Visual LANSA and RAMP to modernize and progressively redevelop its homegrown system for sales and services, to extend the systemโs functionality and to deliver it inside an integrated visual framework that also includes System21 ERP and a document management solution.
Wayne Impey, Chief Financial Officer of TCM, said โUsing RAMP and Visual LANSA we have taken our legacy systems and left them running while we have systematically upgraded them and replaced components as required. We have been able to follow a pragmatic low risk approach through a phased implementation. The improved efficiency of the modernized solution has contributed to allowing us to double in size while only having to increase our administrative support staff by 20 percent.โ
We have been able to follow a pragmatic low risk approach through a phased implementation.
TCM is headquartered in Johannesburg and has branches across South Africa to provide nationwide 24ร7 on-site and remote support to its customers. The company was founded in 1987 and has grown exponentially since. TCM has strong formal relationships with IBM, HP, Dell, Microsoft, CISCO, SUN, LANSA and many other software and hardware vendors.
Systems development mirrored the expansion of the company, initially with a small IT team using traditional IBM AS/400 development methodologies based on RPG. As there were no suitable packages available for the services area, TCM developed its own. The services system has grown with the company over 15 years and evolved to include sales, stock and warranties. The homegrown systems were supplemented with a standard implementation of System21, for which the source code was not available.
The business eventually outgrew this structure. Although most of the required functionality was covered, the system also showed a number of structural shortcomings, especially in the sales and stock modules. Moreover, the system still had its original 5250 character-based user interface that required users to navigate through many screens to process a single transaction.
TCM was considering a systems replacement. Any new solution had to be representative of โBest Business Practiceโ and as a first choice packaged solutions were examined for best fit. As TCM already had System21 Financials in place, the first thought was to implement the System21 Sales and Stock modules and integrate the homegrown system with these modules. However, that plan turned out to be problematic and was eventually dropped. The search for solutions from other vendors didnโt result in any suitable outcome either.
Gavin Mills, IS Manager at TCM, explains, โWe found that the commercially available solutions were not only very expensive, but also needed a great deal of customization.โ
In addition to the IT effort and costs of replacing the existing IT systems, TCM found the associated risk to the business disproportionately large. โMigrating to another system would have created a lot of disruption to our daily activities and would have involved a significant amount of training. We looked at various products. We considered the risks and the costs and we came to the conclusion that these ERP vendors were not going to offer anything fundamentally different to what we already hadโ, says Impey.
However, TCM did need to modernize its existing systems, not just by improving the look-and-feel, but also by reworking some of the structural shortcomings and adding new functionality. In searching for a product that could do all this, TCM chose RAMP from LANSA. โTo us it was a better option to take the virtue of what we had and improve on it. LANSA allowed us to capitalize on the lessons learned and work done over the years, but without having to take the legacy code forward. RAMP also provided us with the opportunity to improve on the systemโs shortcomings and add new functionalityโ, continued Impey.
To us it was a better option to take the virtue of what we had and improve on it.
TCMโs first modernization project phase involved setting up the RAMP Framework for easy navigation. This was followed by the snapping in of the refaced System21, with several improvements in functionality and presentation. For example, TCM added the option of viewing transactions in System21 by โdeal referenceโ, which was implemented by adding an extra table. These improvements were possible even though TCM didnโt have the source code.
The second project phase involved improving on the sales, stock and warranty modules, plus integration with MicroFile, a document management system.
Several structural improvements were made in this phase, such as tracking a piece of equipment by its serial number. Previously this required the user having to find their way through a number of menus and programs. Now a single screen is opened and the relevant tabs can be viewed to track down any particular piece of equipment, investigate warranty issues, find out the invoice number, check for replacement stock, and so on.
Another example is Built Units, a process that involves assembling a unique machine from a set of parts. Previously this required a user to manually go through a number of screens for each part, by first selecting the part for the custom machine and transferring it from the warehouse to the workshop and then booking the partโs transfer in System21.
Mills explains, โIt is not uncommon for a machine to be built from over 100 parts. Sometimes it took hours to process a single Built Unit, now it takes only minutes. The user can now select the parts with the point-and-click of a mouse, allowing for a far more rapid selection than what was previously possible. Next, behind the scenes, a RAMP program populates the screens that are needed to pull the parts from the warehouse and run the transactions through System21. The user seemingly takes a few simple steps, but the system generates many different transactions in the background. Especially for System21, which can be demanding in the inventory transactions area, we havenโt changed any functions. We just changed the way the user sees them.โ
TCMโs sales stock of computers, printers and other peripherals can reach substantial levels and proper management can save a lot of money. According to Mills, stock holdings have come down significantly because of the improved functionality in the sales and inventory systems. Better management of the warranty plans and flow of spares has also made a major logistical difference.
The third project phase, which only recently started, is concerned with improving the services system. It includes Helpdesk, Contract and Service Level Agreement management features, enabling advanced customer service management. This phase involves real-time data-integration between the LANSA-based services application on the IBM i and PDAs carried by TCMโs field engineers. TCM is excited about this project and believes that it will create a real competitive advantage.
The user seemingly takes a few simple steps, but the system generates many different transactions in the background.
โWe have simplified complex business processes while maintaining the integrity of the underlying applications and business controls,โ Mills summarizes as one of the key benefits of the system overhaul. โThis simplification was achieved by using LANSA to consolidate multiple screens across various homegrown and packaged systems, dramatically reducing the input of data and the number of screens to navigate.โ
โThe new system contributes to improved agility and a better response to customer needs and market forces,โ according to Impey. โIt has helped us to reduce the business cycle time, as measured from the initiation of a transaction to the collection of cash.โ
โThe improved efficiency has contributed to allowing us to double in size while only having to increase our administrative support staff by 20 percent,โ explains Impey, citing as specific areas of improvement: a productive user interface to the customer call logging systems, easy allocation of costs to customer business units and improved access to performance reports.
Document handling time has been significantly reduced for both TCM and its customers, as electronic documents are automatically created, archived and distributed on production and can be retrieved when required, all through the LANSA Framework. Clear evidence of the improved document handling facility is the fact that the traditional piles of manila folders have disappeared from the usersโ desks.
โManagement has been provided with faster access to information to support decision-making, while at an operational level teams are provided with easy access to live information, enabling them to take timely corrective actions when needed,โ says Impey.
โThe modernized system allows us to draw on best business practice, past experience and lessons learned, by combining a mix of software packages and homegrown applications, all presented as one consistent and seamless view to the user through the LANSA Frameworkโ
The improved efficiency of the modernized solution has contributed to allowing us to double in size while only having to increase our administrative support staff by 20 percent.
Mills regards the number of additional user requests as a good measurement of the projectโs success. โThe original project brief was quite clear and short, but now that the users know whatโs possible, they keep on asking for more and getting it,โ he said. Next on the agenda is providing a dashboard view over the services and sales data. Going forward Mills sees LANSA having a key role in integrating internal IBM i and Windows applications, as well as integrating with external business partners.
The modernization projects, including setting up the RAMP Framework, the Visual LANSA extensions, the integration with the document management system and the engineersโ PDAs, were carried out by two developers from TCMโs own IT team, one with traditional LANSA skills and one with RPG skills, both new to visual development.
โLANSA is productive in development, but more importantly we have found that our LANSA developed applications also require a dramatically reduced level of maintenance,โ concludes Mills.
Chantal Applewhite, Managing Director at TCM Software & Services, reflects on the fact that TCM, as a long time LANSA partner, has advised several of its customers to adopt LANSA, โWe believe in the products we sell. Our project provides a great example for our customers of how you can modernize and extend legacy applications using your own small IT team and with minimum risk to the business.โ
โBy putting the existing functionality in the Visual LANSA Framework, modernizing it and adding new applications, we have provided a solid foundation for further enhancing the IT systems that support our business. Our users have responded very positively and the overall customer experience has been enhanced.โ
Our project demonstrates how you can modernize and extend legacy applications using your own small IT team.