{"id":44812,"date":"2022-07-28T14:17:23","date_gmt":"2022-07-28T12:17:23","guid":{"rendered":"https:\/\/intellias.com\/?p=44812"},"modified":"2025-01-03T14:34:34","modified_gmt":"2025-01-03T12:34:34","slug":"optimizing-telecom-back-office-systems","status":"publish","type":"post","link":"https:\/\/intellias.com\/optimizing-telecom-back-office-systems\/","title":{"rendered":"Optimizing Telecom Back-Office Systems"},"content":{"rendered":"

Business challenge<\/h2>\n

Our client, a Ukrainian telecom company that provides communication services and data transmission based on a broad range of fixed and mobile technologies, has faced the need to optimize its back-office operations. One of the company\u2019s crucial business processes is aimed at retaining existing customers and attracting new customers, and a huge part of that relies on calculating better tariffs (plans) for B2B customers.<\/p>\n

Tariff calculations were largely done manually, with salespeople and account managers having only an Excel spreadsheet for automation. Creating an offer for a customer involved multiple processes, including calculating the tariff with variations for different types of employees, importing and exporting data, building reports, and working with a sophisticated system of discounts and business terms. All this work was performed using numerous Excel formulas that only a few people could master.<\/p>\n

Apart from being a tiresome and time-consuming routine that was prone to a lot of human errors, working with an Excel document with many variables created lots of technical issues. For instance, the document could crash, making it impossible for a salesperson to perform a quick tariff recalculation based on a customer\u2019s specific requirements and a smooth live consultation.<\/p>\n

Having analyzed the client\u2019s general flow and existing problems, the Intellias team decided to use robotic process automation<\/a> (RPA) and Microsoft Power Apps to transition of back-office operations to a more powerful environment that would optimize the speed of calculations and provide sales and account managers with a better platform.<\/p>\n

\"Optimizing<\/p>\n

Solution delivered<\/h2>\n

Managing initiative details<\/h3>\n

After deciding to improve the tedious tariff calculation process for our client, the Intellias team started looking for the most efficient way to fulfill this request. One of the options was to buy a ready-made CRM and integrate it with the client\u2019s telecom back-office systems. But after thorough analysis, this approach was rejected as quite costly and hard to implement.<\/p>\n

Development, testing, and integration of any custom software solution<\/a> would also take a lot of time and finances. Knowing that our client was already using the Microsoft environment for most of its processes, we decided to expand the functionality of the existing infrastructure by creating a software bot with low-coding<\/a> and Power Apps.<\/p>\n

Aligning the automation process<\/h3>\n

Turning to Power Apps enabled us to quickly and elegantly create customizable back-office applications within the company\u2019s Active Directory. A tariff calculator became the first solution, eliminating tedious processes within the company. Being deeply integrated into the existing Microsoft infrastructure, this calculator is beneficial not only in terms of cutting costs and reducing the implementation time but also in increasing the security of internal processes, as it is available only to current employees.<\/p>\n

The newly developed tariff calculator enables full automation of most processes, such as calculating a tariff for a customer, uploading a customer\u2019s current tariff for comparison, applying various filters and discounts, and quickly creating a final invoice. This allows sellers and account managers to customize the tariff offering for any customer on the go, making a smooth presentation and giving the customer full control over the process of tariff creation.<\/p>\n

Impact and benefits<\/h3>\n

A single engineer using RPA technologies<\/a> has managed to deliver a solution that improves one of our client\u2019s most time-consuming and inconvenient processes. The tariff calculator now covers:<\/p>\n