Sonal Undekar

Sonal Undekar

Data Analyst
India
Kannada, Hindi, English

About Me

Data Analyst with 3.8+ years of experience in telecom billing, usage, and operational data analysis at Netcracker.

Experience

QA Analyst / Data Analyst

Netcracker Technology – Telecom Billing Platform
Aug 2022 - Present · 3 years 11 months

Analyzed telecom billing, usage, and rating data using SQL and Excel to identify revenue leakage, incorrect charges, and data mismatches across millions of CDRs.
Designed SQL queries to validate invoice calculations, discounts, taxes, and roaming charges, reducing billing defects by ~30% before production release.
Built Excel-based dashboards (Pivot Tables, formulas, conditional logic) to track defect trends, customer-impacting issues, and release quality KPIs.
Performed data reconciliation between source systems and billing outputs, ensuring 99%+ data accuracy for critical financial reports.
Worked closely with product owners, developers, and business analysts to convert business rules into testable data logic and validation queries.
Used Jira to manage defects and analyze root-cause patterns, helping teams prioritize high-impact fixes.

QA Analyst / Data Analyst

Netcracker Technology · Bangalore, India
Jul 2022 - Present · 3 years 11 months

Analyzed telecom billing, usage, and rating data using SQL and Excel., Designed SQL queries to validate invoice calculations and reduce billing defects., Built Excel-based dashboards to track defect trends and release quality KPIs., Performed data reconciliation between source systems and billing outputs., Worked with product owners, developers, and business analysts to convert business rules into testable logic., Used Jira to manage defects and prioritize fixes.

Intern

Netcracker Technology
Mar 2022 - Jul 2022 · 4 months

Supported senior analysts in validating billing and usage datasets using SQL and Excel.
Assisted in test data preparation, data cleanup, and reconciliation for multiple telecom modules.
Gained hands-on experience working with large transactional telecom databases and enterprise reporting workflows.

Skills

Jira PostgreSQL Structured Query Language (SQL) GitHub Power BI Tableau Advanced Excel Python (Pandas NumPy) Pivot Tables Power Query VLOOKUP/XLOOKUP Data Cleaning Data Validation Trend Analysis Root Cause Analysis KPI Reporting Python Pandas NumPy
Report this Profile?