GERTRUDE

1. FROM DATA TO BENEFITS GERTRUDE A new way to comfortably and accurately monitor, optimize and allocate your telecom costs

2. Who is Toni Lazazzera - Tmanco – GERTRUDE ? • Toni Lazazzera (see www.linkedin.com for full curiculum) • HES electronic engineer, postgraduate in IT & Telecom (EduSwiss) • 1988-1999: 11 years at LOGITECH. Last 6 years as telecom manager (Europe then Global) • 1999-2002: 4 years at INS as telecom consultant for large customers (see www.ins-group.ch) • Feb.2003: founded own company Tmanco • Tmanco – Telecom Management Competence (see www.tmanco.com) • Expertise in all areas of Telecom management • Special focus on cost management, contract negotiations and process optimization • Core value: independence from any service provider or product manufacturer • GERTRUDE (see also www.tmanco.com > GERTRUDE) • A new type of tools called TTCM (Total Telecom Cost Management) • See also http://www.aberdeen.com (search for “TTCM”) • Gestion Environnement Réseau Télécom: Resources, Utilisation, Dépenses, Evolution(Management of Telecom Network Environment - Resources - Usage - Spending – Evolution) • Born in 1997 and continuously improved • 1997: initial version, developed for own needs as telecom manager, as part of a diploma-work • 1999-2002: improvements and usage for large administrations • Since 2002: packaged and positioned by Tmanco as a solution for telecom cost management • Modules for various providers / services (fix telephony, mobile, leased lines, etc.) • Family of modules expanded according to market trend and demands G-R-O-W-S A structured approach from Reality to Goal GERTRUDE - Solving your telecom-costs management challenge

3. Other’s goal: manage spending to reduce costs GOAL What we want, where we want to be: benefits GERTRUDE - Solving your telecom-costs management challenge

4. Your goal: optimize costs, automate cost allocation, ...? • Ensuring proper management of the telecom budget, means: • Pay only what we ordered • Check invoices against orders, check discounts/conditions against contracts • Order only what we use, and use only what we need • Cost-awareness and self judgment, delegate cost-supervision • Choose the most adequate technologies, services, providers • Proper mix of cost, quality, reliability, flexibility • Ensuring proper cost allocation, means: • Accounting through internal systems (eg: SAP) to the business-units, efficient and accurate process • What are your goals ? What are your priorities ? GOAL What we want, where we want to be: benefits GERTRUDE - Solving your telecom-costs management challenge

5. Other’s reality: new tool/philosophy to manage Telecom costs REALITY What we have, where we are: difficulties GERTRUDE - Solving your telecom-costs management challenge

6. Your reality: high number of invoices, loosing visibility, ...? • What is your reality ? What are your challenges or difficulties ? REALITY What we have, where we are: difficulties GERTRUDE - Solving your telecom-costs management challenge

7. The GERTRUDE approach to addressing this challenge • Use the data available from providers • Electronic bill details, real costs charged • Advantages compared to conventional “Call accounting” systems • Doesn’t require hardware to collect CDR generated by the PBXs • Doesn’t require to maintain rate-tables (time-consuming, inaccurracies). • Includes all phone lines & extensions, in all locations, even if not going through a PBX. • Includes all phones: conventional, VoIP, mobiles. • Structure the data available from the client • Inventory of legitimate invoices, phone-lines, mobiles, leased-lines and other objects appearing on the provider’s invoices • Combine both provider’s and client’s data • Cross-link, structure the data, prepare for flexibility • Exploit OLAP functionalities to explore that data • OLAP = Online Analytical Processing (technology used by Business Intelligence tools such as Business Objects, Cognos, SAS, etc.) • Drill-down, slice, dice, dynamic, interactive, intuitive, fast • Enables discovery of often overlooked information, easy setup of custom reports OPTIONS How we can move from Reality to Goal GERTRUDE - Solving your telecom-costs management challenge

8. GERTRUDE turns your data into information • More than just a tool: a process and activities assisted by a tool ! • The tool automates the integration of provider’s and client’s data,and enables extensive reporting • Preparing good data & interpreting reports are essential to getting quality and valuable information. • This is why Tmanco recommends to take GERTRUDE as a service and not just acquire it as a tool. OPTIONS How we can move from Reality to Goal GERTRUDE - Solving your telecom-costs management challenge

9. GERTRUDE turns your data into information • More than a tool: a set of tools to manage the various activities • Maintain inventories of invoices,phone-lines,leased-lines,mobiles, etc. • Simple and decentralized lists (Excel files, decentralized, maintained by different people) • Structured, user-friendly and common philosophy to allow automatic re-usability • Encompass your various providers & services • A module for each provider/service, all with common approach and structure • Flexibility to add or adapt to your changing environment (new provider, different data) • Including original tools to prepare and follow-up your budget or projects • Helps reduce the administrative overhead and increased accuracy of common tasks OPTIONS How we can move from Reality to Goal GERTRUDE - Solving your telecom-costs management challenge

10. GERTRUDE aims to satisfy various types of customers • For the IT/Telecom manager • Know the costs, how they are distributed among services, the trend • Identify areas for optimization • Help prepare and control budgets • For the Telecom engineer/technician • Help for dimensioning, identify anomalies • Motivation/justification for upgrades, networking, cancellations • For the finance controller or accounting • Verification of invoices, check if legitimate, errors • Finance analytics, cost per dept, business unit, location, etc. • Automate internal cost allocation, reduce processing cost and improve reliability • For the department managers, or the managers of the cost centers • Receive detailed report on cost being allocated (eg: cost per mobile, per month). • Enables people to play an active role in cost-controlling and reduction OPTIONS How we can move from Reality to Goal GERTRUDE - Solving your telecom-costs management challenge

11. Next steps with Tmanco and GERTRUDE • Initial spot-analysis and analysis-report • Tmanco uses its expertise and GERTRUDE to perform an in-depthanalysis of one or more services of your choice (fix telephony, mobile, both, etc.). • You receive a report presenting key findings and recommendations for potential cost-optimizations, anomalies or other improvements. • This analysis, based on a sample set of months, brings you an enormous level of insight into your spending, with minimum budget and resources. The report brings you immediate benefits with straight and pragmatic recommendations. It helps you make informed decisions and gives you more power for negotiations with providers. • Further analysis and custom environment • After the spot-analysis, you also have a better understanding of what you can get from Tmanco+GERTRUDE and what type of service is best for your organization. • Repeat the analysis at regular intervals and/or with other services (eg: mobile) • Adopt the GERTRUDE approach to transform your internal processes for the management of your telecom costs, from inventories-management, invoice verification, cost-allocation, cost-optimization. Tmanco can help you define, implement and run such an environment, including the processes, tools, training and coaching. WORK-PLAN Proposed options and next steps GERTRUDE - Solving your telecom-costs management challenge

12. What the analysis-report will tell you • How much can we trust the data and therefore the resulting reports ? • What is included or missing on the electronic bill ? (invoices, lines,...) • Does the electronic version match the paper version ? Are the reports plausible ? • What is included or missing in the client’s data ? • What is the big picture ? • Where is the money going ? Cost, minutes, calls, lines, etc. per category ? • What is the trend ? Can we observe a correlation with known events ? • View specific information or in specific ways relevant to the client’s context. • Where could I reduce the costs and how much ? • Zoom into high cost positions or categories, keeping the client’s context in mind. • Review areas which usually present high cost with good optimization probability (e.g.: fix-to-mobile, high fix costs for line-rental, traffic to own destinations, etc.). • Evaluate potential savings. Recommendations for action plan. • Are there any anomalies – Technical or Financial ? • Look for common anomalies such as: very long calls (24h), calls to premium nb. or other blocked nb., high nb. of calls, lines apparently not used, possible abuse,etc. • Check invoiced costs, applied tariffs, discounts. WORK-PLAN Proposed options and next steps GERTRUDE - Solving your telecom-costs management challenge

13. Client’s data: list of extensions Links the extension to Organization, Department, Service, etc. Other lists include invoices, phone-lines, locations, ... Output:Provider’s data (cost)combined with client’s data GERTRUDE Sample report WORK-PLAN Proposed options and next steps GERTRUDE - Solving your telecom-costs management challenge

14. Sample output (Fix telephony) • Costs per various levels of detail • Per invoice, per phone-line, per site, per category (eg: fix-to-mobile),per extension, etc. • Validation of legitimate objects (invoices, phone-lines) • Indicates invoices or phone-lines appearing on the invoice but not present in client’s data or outside the validity period defined by the client (eg: line has been cancelled but still billed) • Cost per phone-extension • Net cost per extension, per cost-center • All extensions, even those with “hidden number”, for all extensions even if no PABX or SOHO • For each extension: longest call, most expensive, nb. minutes, nb. calls • OnNet Traffic • Indicates cost and traffic between client’s locations as well as to the group of client’s mobile phones • Support for decisions such as networking, VoIP, CMN, GSM Gateways. • Extract a list of calls • Date, time, calling extension, called number, duration, cost, etc. WORK-PLAN Proposed options and next steps GERTRUDE - Solving your telecom-costs management challenge

15. Questions, feedback and next project checkpoint • Questions • Need further information ? Details ? Demo ? • Feedback • Was this presentation helpful to you ? • Do you feel the team Tmanco+GERTRUDE can help you “Solve your telecom-cost management challenges” ? • Do you feel a “Spot-analysis + exec. summary” can have an acceptable ROI ? • Next steps • What would be your preferred way to move forward with Tmanco+GERTRUDE ? • Do you feel ready to move forward ? Now ? Later ? When ? • Next checkpoint • Date, objective, participants, action-items STEERING How will we ensure we stay on-track GERTRUDE - Solving your telecom-costs management challenge

16. S W O R G Thanks for your attention This presentation can be viewed and downloaded from www.tmanco.com > GERTRUDE GERTRUDE - Solving your telecom-costs management challenge