I am a results-driven Data Analyst with 8+ years of experience in data analytics, business intelligence, and data warehousing across telecom, finance, and enterprise domains. I specialize in SQL, Power BI, Tableau, and ETL development, with hands-on experience in AWS Redshift, Snowflake, and Azure Data Factory, and I apply Python and machine learning techniques for forecasting and operational planning.

Kavya Mandugula

I am a results-driven Data Analyst with 8+ years of experience in data analytics, business intelligence, and data warehousing across telecom, finance, and enterprise domains. I specialize in SQL, Power BI, Tableau, and ETL development, with hands-on experience in AWS Redshift, Snowflake, and Azure Data Factory, and I apply Python and machine learning techniques for forecasting and operational planning.

Available to hire

I am a results-driven Data Analyst with 8+ years of experience in data analytics, business intelligence, and data warehousing across telecom, finance, and enterprise domains.

I specialize in SQL, Power BI, Tableau, and ETL development, with hands-on experience in AWS Redshift, Snowflake, and Azure Data Factory, and I apply Python and machine learning techniques for forecasting and operational planning.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Language

English
Fluent

Work Experience

Senior Data Analyst at Lumen Technologies
May 1, 2024 - Present
Engineered complex SQL queries using window functions, recursive CTEs, multi-level joins, and correlated subqueries; verified 30% data extraction scenarios from Workmate task storage. Developed Power BI dashboards with DAX measures, calculated columns, and row-level security to track 35% KPI metrics across task routing, workload distribution, and execution datasets. Designed cloud warehouse schemas in AWS Redshift and Snowflake, optimizing analytical tables and recording 40% query optimization strategies within platform microservice environments. Leveraged Generative AI tools to generate SQL and Python scripts and documented development activities for analytics projects. Constructed predictive models using Scikit-learn on historical task records to forecast task volumes and identify routing risk indicators. Conducted data quality validation and monitoring on Flightdeck microservice datasets, achieving 32% improvement in task assignments and SLA metrics.
Senior Data Analyst at Wipro Limited
May 1, 2021 - June 30, 2023
Designed Power BI dashboards integrating source systems, providing real-time KPIs, sales metrics, and trends; delivered executive reports, driving 35% adoption of actionable decisions. Developed Azure Data Factory pipelines for automated ingestion from SQL Server, Oracle, flat files, and APIs, tracking reliability, and leading to a 30% reduction in manual data loads. Enhanced Power BI data models and SQL queries with aggregation strategies, incremental refresh, and query folding, improving dashboard load times by 40%. Established multi-layer data validation frameworks and automated reconciliation checks, detecting 25% inconsistencies and ensuring data accuracy in enterprise BI reporting workflows. Modeled star-schema data marts for sales, customer, and operational analytics, supporting internal users, documenting metadata coverage, and enabling structured reporting and analysis.
Data Analyst at Wipro Limited
May 1, 2020 - May 31, 2021
Engineered complex T-SQL queries, including stored procedures, views, and functions, contributing to a 35% improvement in data extraction and validation accuracy within enterprise warehouses. Performed data validation and reconciliation on over 3 million records, detecting and resolving inconsistencies, enhancing reporting accuracy in source systems. Implemented ETL/ELT pipelines for streamlined data ingestion, cleansing, and standardization, conducting trend and variance analysis in datasets, and shortening data errors. Documented data workflows and metadata, including source-to-target mappings and data dictionaries covering tables, supporting governance and audit readiness.
Data Analyst at Cognizant Technology Solutions
February 1, 2018 - April 30, 2020
Created Tableau dashboards for financial risk analytics, performance monitoring, and executive KPIs, capturing actionable insights for compliance, risk, and operations teams. Implemented ETL pipelines and end-to-end testing using SSIS packages, validating 35% of data transformation scenarios from transactional systems to the enterprise warehouse. Composed BRDs and FSDs through structured stakeholder interviews, workshops, and system analysis, defining functional requirements for data integration projects. Constructed SQL queries and SSRS reports supporting regulatory compliance and operational reporting for 200+ end users, enabling 25% adoption of actionable business strategies.
Associate Data Analyst at Wipro Limited
July 1, 2016 - January 31, 2018
Generated SSRS reports and Excel dashboards tracking enrollment metrics, eligibility status, and 30+ operational KPIs, capturing program insights for management reporting and strategic planning. Engaged in designing and testing SSIS packages for ETL processes, verifying data transformations, and ensuring correct source-to-target mappings for reporting workflows. Ensured HIPAA compliance for all data handling, storage, and reporting activities, auditing 100% PHI-related processes, and guaranteeing adherence metrics for internal reviews.

Education

Master of Science in Computer Information Systems at Southern Arkansas University
August 1, 2023 - May 1, 2025
Bachelor of Science at Osmania University
August 1, 2012 - September 1, 2016

Qualifications

Add your qualifications or awards here.

Industry Experience

Telecommunications, Financial Services, Professional Services, Software & Internet