Informe de prácticas en Colombia telecomunicaciones S.A.S E.S.P

Abstract

In the Interconnection and Roaming Financial Management area of Telefónica Movistar Colombia, the workload is high, largely due to the fact that many activities are carried out manually. In practice, this situation extends response times and generates risks in the handling of financial information. Based on this context, the professional internship focused on supporting the area in improving its processes, particularly those that were most repetitive and time-consuming. During the first weeks, the existing workflows were reviewed to identify tasks that required greater operational effort. This analysis made it possible to detect activities that could be simplified. As a result, a support tool was developed in Microsoft Excel using Power Query and initially implemented to assist daily operations. This tool enabled the integration, organization, and validation of information from multiple files, thereby facilitating the monitoring of open items and the recording of financial transactions. The results observed in this initial stage were positive. The analyzed processes showed a significant reduction in execution times, close to 80%, as well as a decreased need for constant manual validations. Although the tool still requires supervision and further adjustments, its use contributed to improving the area’s workflow and provided a clear starting point for the continued strengthening of financial processes.