Chandana S R

Data Analyst

Bengaluru, India 2+ yrs exp 85 · Excellent

About

Data Analyst with hands-on experience in SQL, Python, reporting, data validation, dashboard development, and AI-assisted analysis. Experienced in working with multi-source datasets, building structured analytical reports, validating data accuracy, investigating discrepancies, and translating business requirements into reliable datasets and dashboards.

Skills & Expertise (36)

SQL Intermediate

7.5/10

Years Exp

Python Intermediate

7.3/10

Years Exp

ETL Intermediate

6.8/10

Years Exp

Excel Intermediate

6.5/10

Years Exp

Tableau Intermediate

6.0/10

Years Exp

Power BI Intermediate

6.0/10

Years Exp

Business Analysis Intermediate

5.5/10

Years Exp

Data Interpretation Intermediate

5.5/10

Years Exp

Data Cleansing Intermediate

5.5/10

Years Exp

Process Improvement Data Validation Data Reconciliation Root Cause Analysis AI-Assisted Analysis ChatGPT AI Tools Apache Superset Postgresql MySql MongoDb Data Transformation Data Integration Data Accuracy Data visualisation Dashboard Development Data Analytics Aggregations Window Functions Joins CTEs NumPy Pandas Business Insights KPI Reporting Trend Analysis Reporting

Work Experience

Data Analyst Intern

The/Nudge

Jan 2026 - Jun 2026

Developed SQL-based ETL pipelines integrating 4+ multi-source datasets to support reliable analytical reporting. Processed data from relational databases, MongoDB, and APIs using Python and SQL for downstream analysis. Conducted data validation and cross-system reconciliation to identify discrepancies and improve data accuracy. Investigated data-quality issues by tracing discrepancies to transformation logic, source data, and business rules, supporting reliable reporting. Debugged 3+ production dashboards in Apache Superset by reconciling SQL outputs with business requirements and expected results. Transformed and aggregated data across 5+ business domains using CTEs, joins, window functions, and aggregations. Collaborated with analysts and program managers to understand reporting requirements, resolve data issues, and communicate analytical findings. Worked on Jira-raised issues by investigating assigned bugs, identifying causes, and supporting resolution.

Data Analyst Intern (Virtual Internship)

Quantium

May 2025 - Oct 2025

Analysed 264K+ retail transactions using R to identify customer purchasing patterns, high-value segments, and key sales drivers. Conducted customer segmentation across life stage and customer type, identifying Budget older families and Mainstream young singles/couples as key contributors to chip sales. Applied statistical analysis and hypothesis testing, including a Welch t-test, to evaluate differences in average price paid across customer segments. Identified a 23% higher affinity for Tyrrells chips among Mainstream young singles/couples and recommended targeted product placement to improve visibility and impulse purchases. Translated customer and product-level analysis into actionable insights to support product placement and retail decision-making.

Data Analyst Intern

Elevate Labs

Apr 2025 - May 2025

Analysed 9,000+ Superstore sales records using SQL and Python, aggregating revenue and quantity across 1,800+ products to identify top-performing products. Identified the top 10 revenue-generating products through SQL-based sales analysis, supporting product performance evaluation. Cleaned and standardised an 8,800+ record Netflix dataset in Excel by removing duplicates, standardising fields, and handling missing values. Conducted EDA on 800+ records using Python, identifying patterns across 10+ attributes and communicating findings through visualisations. Used Excel, SQL, Python, and visualisation tools to transform raw datasets into structured insights and analytical outputs.

Research Associate & Science Facilitator

GyanPro Educational Innovation Pvt. Ltd

Aug 2022 - Feb 2024

Developed and standardized 20+ STEAM activities and 100+ structured learning frameworks, translating complex conceptual inputs into actionable educational assets. Executed 60+ high-engagement science sessions and 15+ workshops, tracking participation metrics and optimizing resource delivery for learners. Partnered with cross-functional educators to align program outcomes with core curriculum benchmarks, ensuring structured quality control across learning environments.