Monitoreo y análisis de KPI Post-Fusión para sitios integrados y uso compartido del espectro

Abstract

This undergraduate thesis, titled “Monitoring and Analysis of Post-Merger KPI for Integrated Sites and Spectrum Sharing in 4G and 5G Networks”, was carried out during the professional internship at Huawei Technologies Co., Ltd., within the Radio Network Optimization (RNO) group of the Radio Frequency (RF) department. The project aimed to evaluate the behavior of Key Performance Indicators (KPI) during the network and spectrum integration process between Tigo and Telefónica, implemented under MORAN and MOCN sharing schemes. Data were collected and processed from MAE and OSS/BSS platforms, organized in PostgreSQL databases, and analyzed through automated HTML reports using Jinja2 and interactive dashboards developed in Dash. Statistical analyses were performed on indicators such as SgNB Addition Success Rate, Service Call Drop Rate, User Throughput, PRB Utilization, CQI, and MCS to detect performance variations before and after the integration. The results showed temporary degradations after the merger, which were corrected through network parameter optimization and configuration adjustments, leading to throughput recovery, lower drop rates, and overall network stabilization. This work highlights the importance of KPI-based post-merger monitoring and automated analysis as essential tools for quality management, technical decision-making, and spectral efficiency improvement in modern 4G and 5G mobile networks.