About
Data analyst with 1 year of experience at Vodafone Idea (VI), engaged through Quess Corp payroll, using SQL and Advanced Excel to analyse customer, service and ticket data across voice, data and billing systems. Skilled at querying large telecom datasets, cleaning and validating raw exports, building recurring dashboards and KPI reports, and translating findings into recommendations for both technical and non-technical stakeholders. MCA graduate with working knowledge of Python, Power BI and data-visualisation fundamentals.
Skills & Expertise
No skills listed yet
Work Experience
Data Analyst
Vodafone Idea (VI)
Mar 2022 - Mar 2023
Wrote SQL queries across customer, service and ticket databases to extract datasets for recurring and ad-hoc analysis of voice, data and billing performance. Built and maintained Advanced Excel reports and dashboards using PivotTables, lookups and conditional formatting to track ticket volume, resolution time and SLA compliance for the support organisation. Cleaned and validated raw system exports — deduplicating records, standardising formats and reconciling mismatched fields — so reporting ran on reliable data. Analysed complaint and ticket data to identify the highest-volume recurring issue drivers, sharing findings with network and backend engineering to prioritise permanent fixes over repeat workarounds. Segmented customers by plan, tenure and complaint history to surface at-risk cohorts, supporting retention and service-quality initiatives. Produced weekly and monthly reporting packs summarising key metrics and trends for team leads, presenting insights in plain language for non-technical stakeholders. Documented query logic, data definitions and reporting processes in internal runbooks, making recurring reports repeatable across the team.
Education
Master of Computer Applications (MCA) - Bansal Institute of Science and Technology
- · Afghanistan
B.Sc. Computer Science - Jiwaji University
- · Afghanistan
Certifications
No certifications added yet
