Nageswara S

Junior Telecom Officer (Telecom -IT)

Technoloy • Período integral

Aug 2008 - Present • 17 yrs 9 mos

Hi, I’m Nagesh – a Telecom & IT professional with over 15+ years of experience, specializing in large-scale data processing, Oracle SQL, PL/SQL, and telecom billing systems. My core expertise lies in working with Telecom Billing systems (MIU – CDR Message Investigation Unit, Rating of CDRs), where I handle high-volume Call Detail Records (CDRs) involving deep data analysis, validation, and real-time processing using complex SQL queries and PL/SQL logic. What makes my profile unique is the rare combination of strong telecom domain knowledge (CDR rating, plan validation, billing workflows) along with hands-on expertise in Oracle SQL, PL/SQL, Linux, and scripting. This allows me to solve real-world problems that require both domain understanding and deep technical skills. In my experience, I have worked extensively on real-time rating of lakhs of CDRs using optimized SQL queries and PL/SQL procedures in production environments. I have handled and analyzed large database tables with crores of records, including challenging scenarios where tables had no indexes, and I optimized SQL queries accordingly for performance and accuracy. I have strong experience in writing, debugging, and tuning complex SQL queries and PL/SQL code for data validation, reconciliation, and error correction in telecom billing systems. I have also worked on postpaid plan configuration and validation, where SQL-driven data checks and complex scripts are used to ensure correct tariff implementation. My role also involved guiding and troubleshooting CDR rating issues using SQL-based analysis, identifying discrepancies in billing data, and resolving them through precise query-level investigation. I regularly use Linux commands and shell scripting along with SQL queries for log analysis, data extraction, and automation of repetitive tasks. I focus on providing practical, reliable, and efficient solutions for database-related problems, telecom data analysis, and query optimization.