Purna Priyatham Kandula
Summary
Data Analyst with 5 years of experience in data analysis, reporting, and visualization across financial services and enterprise IT. Skilled in SQL, Python, Excel, Power BI, and Tableau, with expertise in transforming large, complex datasets into actionable business insights. Strong background in data cleaning, ETL processes, and building dashboards to support decision-making. Adept at collaborating with cross-functional teams, documenting findings, and driving data-driven strategies in cloud and on-premises environments.
Overview
6
6
years of professional experience
Work History
Data Analyst
Voltican
02.2025 - Current
- Designed and deployed Power BI dashboards to monitor financial KPIs and customer transaction trends.
- Built optimized SQL queries for data extraction, enhancing reporting efficiency.
- Conducted predictive analysis on customer churn using Python libraries, including Pandas and NumPy.
- Collaborated with business teams to translate data into strategic recommendations, increasing retention by 12%.
- Automated reporting workflows in Python and Excel, decreasing manual effort by 35%.
- Maintained documentation of all the processes related to Data Analysis.
- Assessed programs to identify risks or problems to determine appropriate responses.
- Identified or monitored current and potential customers using business intelligence tools.
- Created or reviewed technical design documentation to drive accuracy of reporting solutions.
- Identified and analyzed industry or geographic trends with business strategy implications.
- Analyzed competitive market strategies through related product, market or share trends.
- Analyzed data sets to identify trends and patterns for decision-making.
- Assisted in preparing reports using data visualization tools and software.
- Supported the development of dashboards for real-time data monitoring.
- Maintained accurate records of data sources and methodologies used in analyses.
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
Jr Data Analyst
Capgemini
Chennai, India
08.2021 - 12.2022
- Collected and organized data from various sources for analysis.
- Assisted in creating visual reports using data visualization tools.
- Conducted preliminary data analysis to identify trends and patterns.
- Maintained databases by updating records and ensuring data integrity.
- Utilized software tools to automate routine data entry tasks.
- Developed Tableau dashboards to visualize infrastructure performance and incident trends.
- Utilized Excel (Power Query, Macros) for data cleaning and generating weekly and monthly reports.
- Supported ETL processes by integrating multiple data sources into centralized reporting systems.
- Conducted trend analysis and forecasting for IT operations and service delivery metrics.
- Collaborated with cross-functional teams to enhance reporting accuracy and timeliness.
Data Analyst Intern
Gigatude Software Solutions
Hyderabad, India
07.2019 - 07.2021
- Analyzed data trends to support software development decisions.
- Assisted in creating data visualizations for project presentations.
- Maintained databases and ensured accurate data entry procedures.
- Supported senior analysts in preparing reports and summaries of findings.
- Utilized Excel and SQL for data manipulation and querying tasks.
- Participated in team meetings to discuss project progress and challenges.
- Extracted data to build metrics or create dashboards, tracking success toward KPIs.
- Assisted in writing SQL queries to extract and validate data for reporting.
- Built Excel models for daily/weekly sales and operations reporting.
- Supported the development of basic dashboards in Power BI for management reviews.
- Documented processes and contributed to building data dictionaries.
Education
.
Skills
- Data Analysis: SQL, Excel (Pivot Tables, VLOOKUP, Power Query), Python (Pandas, NumPy)
- Visualization Tools: Power BI, Tableau, Matplotlib, Seaborn
- Data Engineering Basics: ETL, Data Cleaning, Normalization, Data Validation
- Databases: SQL Server, MySQL, PostgreSQL, Azure Data Lake
- Cloud & Big Data: Azure Synapse, AWS Redshift, Google BigQuery
- Reporting: KPI Dashboards, Business Intelligence, Ad-hoc Analysis
- Tools & Collaboration: Git, Jupyter Notebook, MS Office Suite
- Soft Skills: Problem-Solving, Communication, Stakeholder Management
Timeline
Data Analyst
Voltican
02.2025 - Current
Jr Data Analyst
Capgemini
08.2021 - 12.2022
Data Analyst Intern
Gigatude Software Solutions
07.2019 - 07.2021
.