Optimización de procesos de cobro en gestión de cartera para el área de Roaming e Interconexión Internacional

Abstract

Problem: The billing and collection management of open positions in Telefónica Movistar Colombia's Roaming and International Interconnection area presents process stages with room for improvement in portfolio recovery, with potential positive impact on segment liquidity and profitability. Objective: To design and implement optimization strategies for the collection processes within this area, aimed at reducing recovery times and lowering the overdue portfolio index. Method: A diagnostic assessment of current collection processes was conducted by a documentary review of existing procedures. Based on these findings, a data-processing bot (Bot_Append.py) was developed in Python to automate the reading, PLMN/partner filtering, and consolidation of OS Report and Open Positions files, generating an Excel output with four worksheets: OS Report, PA, Valores, and APPEND. Results: The bot implementation enabled automatic detection of pending netting positions, reduced report preparation time, and standardized the interoperator reconciliation process. Discussion: Findings highlight the needto integrate automation tools with proactive portfolio management, aligned with current billing and collection practices in Telefónica Movistar Colombia's Roaming and InternationalInterconnection area.