Edgar Iván Rodríguez Vera Email & Phone Number

As a Senior BSS and OCS Operations Engineer at Xius, I played a critical role in ensuring operational excellence by troubleshooting and resolving provisioning errors, which contributed to seamless service delivery for MVNO clients. I led the allocation of tickets and conducted operational and status meetings with clients while managing team resources to maintain compliance with SLA indicators. Additionally, I developed Shell scripts to enhance server processes, monitored SMS, data, and voice services to ensure high-quality performance, and proactively addressed any anomalies.

México

As Junior Operations Manager (BSS) at Altan Redes, I programmed and optimized Shell and SQL scripts to provide effective solutions for the team, managed messaging campaigns in the OTA application, and coordinated the resolution of tasks and technical tickets (TT). I monitored voice, SMS, and data traffic, analyzed failures in critical network elements such as HLR, GGSN, PCRF, and PGW, and implemented the national numbering plan update along with the creation of new MVNOs in the platform. Additionally, I executed, monitored, and detected failures in portability processes, collaborated with other departments to optimize customer service, and prepared performance reports for upper management while fostering staff development in a continuous learning environment.

I conducted auditing and operation of the prepaid system in a telecommunications network, involving the critical nodes that support the wireless network infrastructure in 2G, 3G, and LTE technologies. My responsibilities included fraud detection and mitigation, as well as optimizing billing and collection processes through the development of Shell scripts and advanced SQL queries (Oracle). I utilized PL/SQL for creating stored procedures, triggers, and functions that automated the auditing of nodes and data reconciliation within the mediation and billing system. I also managed connections using SSH, FTP, and SFTP protocols for the secure transmission of data between systems.

Ciudad De México, México

Operation, correction, and development of IT systems involved in the valuation of CDRs generated by the users of the telecommunications company (Movistar), as well as the development of tools that calculated the billing for MVNO traffic (virtual operators). The tools and languages used included Oracle SQL for selecting information from the lines to analyze their valuation status, Excel for generating reports on GPRS, SMS, voice, LTE, and roaming traffic, and Batch for developing automated processes and menus that allowed for the execution of various reconciliations.

Ciudad De México, México

I audited and operated provisioning systems in 2G, 3G, and 4G networks, ensuring the proper functioning of key nodes such as PCRF, HLR, HSS, and PGW within the Telcel network. My responsibilities included creating complex SQL queries for reconciling provisioning categories, utilizing advanced techniques such as joins (left, right, outer, natural), subqueries, and conditionals (case, nvl, decode). I worked with group functions (count, sum, group by, having, avg, max, min) and data type conversion functions, as well as developing stored procedures, triggers, and temporary tables. Additionally, I conducted analysis and optimization of data related to node performance, ensuring the correct provisioning and configuration of services across the network.

Área Metropolitana De Ciudad De México

I coordinated the implementation and production deployment of the Netcracker tool, overseeing the development and migration of local databases. My responsibilities included creating SQL queries for data analysis and migration, tracking work plans, and preparing weekly progress reports. I worked closely with clients in validating tests, provided training and support to users, and developed detailed technical manuals for the efficient use of the tool.