pooja kuchanpally @CareerZen

Experience

Tata Consultancy Services

data analyst

Mar 2022 - Jul 2023

India

Built and maintained automated ETL pipelines using SQL and Python, improving data accuracy and reducing manual processing time.
Developed Power BI dashboards integrated with Azure SQL to provide real-time KPI reporting for cross-functional teams.
Performed advanced SQL analysis on large datasets to support finance and operations reporting and business intelligence initiatives.
Collaborated with business users to translate requirements into analytics-ready datasets and scalable reporting solutions.
Created and maintained data models, reporting workflows, and standard operating procedures to support enterprise reporting.
Identified reporting bottlenecks through historical data analysis, improving reporting efficiency and operational performance.

Avya IT Solutions

Junior data analyst

Jan 2020 - Mar 2022

India

Developed and optimized SQL queries to clean, validate, and transform large datasets, improving data quality for enterprise reporting.
Designed and maintained ETL workflows using Python and SQL to automate data extraction, transformation, and loading processes.
Built interactive Power BI dashboards and automated reporting solutions, enabling real-time KPI monitoring.
Performed exploratory data analysis (EDA) to identify trends and business opportunities for sales and finance teams.
Collaborated with cross-functional stakeholders to gather business requirements and deliver analytics-ready datasets for reporting and decision-making.

vanguard

Data analyst

Aug 2025 - Present

united states

Designed and optimized ETL/ELT pipelines using SQL and Python to transform structured and semi-structured data into analytics-ready datasets.
Developed interactive Tableau dashboards for executive KPI reporting, enabling real-time business insights.
Collaborated with business stakeholders to define KPIs, gather requirements, and deliver scalable reporting solutions supporting strategic decision-making.
Validated data quality and implemented governance standards to ensure accurate reporting across finance and operations.
Supported ad hoc analytical requests using advanced SQL queries, reducing turnaround time for business reporting.

Education

Computer science

Auburn University at montgomery - Masters

Aug 2023 - May 2025

I served as a Graduate Teaching Assistant for Python for Data Science, I had the opportunity to help students build confidence in using Python for data analysis and problem-solving. I supported them with concepts like data cleaning, visualization, exploratory analysis, and debugging, while learning how to communicate technical ideas in a simple and approachable way. This experience strengthened both my analytical skills and my ability to collaborate, mentor, and explain data-driven solutions effectively.

pooja kuchanpally