Chandana

Entry-level Data Analyst

Hyderabad 85 · Excellent

About

Computer Science graduate with hands-on experience in SQL, Snowflake, Microsoft Excel, and Power BI. Skilled in Data Cleaning, Data Profiling, Feature Engineering, Customer Segmentation, RFM Analysis, DAX, KPI Reporting, and Dashboard Development. Built analytics solutions across customer behavior analysis, revenue recovery, and retail business intelligence. Seeking an entry-level Data Analyst role to apply data-driven decision-making to real business challenges.

Skills & Expertise (20)

SQL Advanced

8.1/10

Years Exp

Dashboard Development Advanced

8.0/10

Years Exp

Churn Analysis Advanced

8.0/10

Years Exp

Microsoft Power BI Advanced

8.0/10

Years Exp

Microsoft Excel Advanced

8.0/10

Years Exp

Customer Segmentation Advanced

8.0/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Data Profiling Advanced

8.0/10

Years Exp

Business Intelligence Intermediate

7.5/10

Years Exp

RFM Segmentation Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Snowflake Intermediate

7.5/10

Years Exp

Data Modeling Intermediate

7.0/10

Years Exp

Feature Engineering Intermediate

7.0/10

Years Exp

Power Query Intermediate

7.0/10

Years Exp

Window Functions Intermediate

7.0/10

Years Exp

Star Schema Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

CTEs Intermediate

7.0/10

Years Exp

Work Experience

Data Analyst

Strategic Revenue Recovery Analysis

Present - Present

Applied Feature Engineering in Excel to build calculated fields tagging Discount Bands and Revenue Leakage Status – Profitability Analysis revealed 20.4% revenue leakage and Discount Impact Analysis showed high-discount orders losing -119% profit margin vs +30% on full-price orders. Performed Customer Segmentation and Churn Analysis across 793 customers into value tiers – revealed 45% churn rate (357 customers), Medium-value customers generated highest revenue (1,153K) while High-value customers delivered strongest margins (13.9%). Designed 3-page interactive dashboard using Pivot Tables, Slicers, and Pareto Analysis for Data Visualization – isolated Tables sub-category as 79% of total profit leakage (-18K) with 4-year monthly Revenue Forecasting trend.

Data Analyst

Retail Customer Behavior Analysis

Present - Present

Profiled and cleaned 1M+ raw retail transaction records in Snowflake through structured Data Profiling and Data Cleaning – removed 261,840 invalid entries including cancelled orders, missing Customer IDs, and negative values to ensure analysis was built on reliable data. Performed end-to-end Customer Behavior Analysis across 5,942 customers using CTEs, Aggregate Functions, and DATEDIFF covering purchase frequency, spending, volume, and recency – revenue was heavily concentrated with top customer generating 608K+ in total spend. Built RFM Segmentation from scratch using NTILE Window Functions and CASE logic to classify customers into 7 behavioral segments – SQL output directly carried forward as the data foundation for Power BI Business Intelligence dashboard.

Data Analyst

Retail Business Performance Intelligence

Present - Present

Extended Retail Customer Behavior Analysis SQL project into a full Business Intelligence solution – reused Snowflake Star Schema reporting layer (5 SQL views) and imported SQL-generated RFM Segmentation into Power BI eliminating redundant rebuilding. Developed 15+ DAX Measures (MoM Growth%, Repeat Customer%, Average Order Value) across 6 dashboard pages – KPI Reporting revealed 72% repeat customer rate, Q4 seasonal revenue peaks, and UK geographic revenue concentration. Delivered interactive Data Visualization dashboard covering Executive KPIs, Customer Segmentation, Product Performance, and Time Intelligence – transforming raw SQL analysis into actionable business insights supporting data-driven decision-making.