SOFTWARE TOOLS, TAILOR MADE TO FIT YOUR TELECOM NEEDS
At Tmanco, we combine the skills of a Telecom Engineer with a Database programmer, both in the same brain. This is a key advantage when needing to develop software that is intended to manipulate telecom data, extract meaningful information or interface with other systems. Hereafter are some examples of what we have done.
Large organizations have plenty of situations where data needs to be Extracted / Transformed / Loaded. So it can simplify activities, avoid errors, interface systems, and so on. We have the capability to understand your telecom situation and build the software solution for it.
When founding Tmanco in 2003, we developed an TEM (Telecom Expense Management) application called GERTRUDE, designed to process carrier files, manage telecom inventory, perform analysis, produce reporting, facilitate cost-allocation, and much more.
For that, we created our ETL (Extract – Transform – Load) framework based on MySQL server and able to automate the process end-to-end, from acquiring the carrier-files to loading data into SAP (or other applications).
We then leveraged the GERTRUDE framework to design a billing solution for a large city in Switzerland, acting as a regional provider for TV + Telephony + Mobile services.
That solution is working since 2006 for the monthly invoicing of over 10’000 customers, tightly integrated with the SAP application handling the global invoicing.
We later developed a new framework named GLET (Gertrude applet) with the objective to run on a customer machine (limited privileges) and process data locally (confidentiality).
One applet we developped is an anonymizer for “Swisscom Invoice Reporting raw data” files (billitem.zip, itemized.zip). It takes the original files and replaces all sensible data with fake values (phone-numbers, name, email, cost-center, …). We provide that tool to customers who want us to estimate their potential savings without exposing sensible information.
This framework is a foundation to rapidly develop other kind of tools for various jobs or situations.
Sometimes you have a bunch of data and you know there is information in there which could help you for a given project / problem / RFP/ etc.
We use our tools, expertise, and sometimes develop custom software to address such situations. Hereafter are few examples of what we have done:
- Analyse several GBytes of Cisco Call-Manager logs to understand how calls were being routed and what caused many calls to be delayed or abandoned.
- A customer with 70 locations had to move from a “PBX infrastructure” to a “VOIP network”. To dimension the trunks between each location it was important to know how much traffic was flowing in/out and to which other locations. We processed several months of billing files and were able to provide helpful information such as Erlangs, simultaneous calls, etc.
- In the context of an RFP for a mobile contract, we processed several months of billing files to build a traffic table with destinations/volumes. We then integrated the tariffs provided by each candidate to simulate the real cost based on the real traffic pattern. This way we could negotiate where it matters: on destinations with high traffic where a small discount can have a large impact.
The variety of mobile offers makes it difficult to compare and choose the ideal subscription/options for each user … unless we can automate that !
To address this challenge, we developed a tool called TSPENDO (based on the framework GLET) to exploit all the details available in the billing files, run simulations and deliver a well-formatted report with precise recommendations for cost-optimisation.
Thanks to TSPENDO, we were able to achieve impressive savings in various cost-optimization projects (see CASALE Success Story).
Excel is one of our favorite tools. Since over 25 years we use it in numerous contexts and developed an expertise which we are now sharing through a service called XHELP – Excel coaching for busy people.
You would be surprised to see what you have under the hood, and how that can simplify your tasks or processes, no matter the area: Telecom, Project mgt, IT, Accounting, Sales, Logistic, Admin, …
SOME OF OUR CUSTOMERS
RELATED POSTS
How CASALE reduced its mobile costs by 70%
If you use Swisscom NATEL go, a new package "Voice Travel" enables you to reduce the cost of calls abroad. We propose a free pre-analysis to quantify how much you can save using Voice Travel and all the available options. You could be surprised to learn that your mobile invoice can be reduced by 20% or more.
Success story: CASALE Mobile costs optimization & governance
CASALE massively reduces its mobile costs with the advice & tools from TMANCO ABOUT CASALE - Founded in 1921 with HQ in Lugano, CASALE is an engineering company, global provider of integrated solutions for the production of fertilizers and chemicals. HIGH MOBILE COSTS [...]
Swisscom NATEL go – New package “Voice Travel”
If you use Swisscom NATEL go, a new package "Voice Travel" enables you to reduce the cost of calls abroad. We propose a free pre-analysis to quantify how much you can save using Voice Travel and all the available options. You could be surprised to learn that your mobile invoice can be reduced by 20% or more.
Swisscom NATEL go – New conditions – More optimization
Take advantage of the new NatelGo conditions to optimize your costs On July 1st 2021, Swisscom updated the conditions for NATEL go subscriptions In case you missed it, here are some interesting changes you can leverage to optimize your costs or services