Back to Developers
Komal Chavan

Komal Chavan

Data Analyst

Pune, India 4+ yrs exp 89 · Excellent

About

Results-driven Data Analyst with 4+ years of experience delivering end-to-end business intelligence solutions across data analysis, dashboard development, and reporting automation. Expert in Tableau, Tableau Prep, Power BI, and SQL, with a strong track record of transforming raw data from Excel, CSV, and Oracle databases into interactive dashboards and actionable business insights. Experienced in Tableau and Power BI dashboard development, Tableau Server Administration, ETL, data warehousing, and full SDLC-aligned reporting solution development.

Skills & Expertise (112)

Tableau Desktop Advanced
8.5/10
4
Years Exp
Power BI Advanced
8.5/10
4
Years Exp
Data Analysis Advanced
8.1/10
4
Years Exp
Data Modeling Advanced
8.0/10
4
Years Exp
SQL Advanced
8.0/10
4
Years Exp
Advanced Excel Advanced
8.0/10
4
Years Exp
Python Basics Intermediate
6.5/10
1
Years Exp
Exploratory data analysis Data Profiling Data Validation Data Quality Data Reconciliation Root Cause Analysis Variance Analysis Trend Analysis Anomaly Detection Ad-hoc Analysis Performance Analysis Business Insights KPI Analysis Reporting Decision Support Interactive Dashboards KPI Dashboards Data Storytelling Drill-down Drill-through Tooltips Tableau Prep LOD Expressions Calculated Fields Parameters Sets Hierarchies Data Blending Power BI Desktop Power Query DAX Star Schema Fact & Dimension tables Relationships Calculated Columns Measures CALCULATE Time intelligence YTD MTD YoY MoM Report Development data refresh Power BI Service Microsoft Copilot Claude AI Oracle SQL SQL Query Optimization Joins CTEs Subqueries Window Functions CASE Statements Aggregate Functions NULL handling Views Temporary tables Data Extraction Transformation Excel CSV Oracle Database SQL databases PivotTables XLOOKUP VLOOKUP Index-match SUMIFS Countifs Ifs IFERROR Conditional Formatting Excel Dashboards Reporting Automation Macros VBA Microsoft Power Automate Microsoft Power Automate Desktop Workflow Automation ETL Data Integration data mapping Data Cleansing Source-to-Target Validation Data Quality Checks Pandas Requirements Gathering Business Requirements Analysis Stakeholder Management Cross-Functional Collaboration Problem Solving Critical thinking Business Analysis issue resolution Process Improvement Continuous Improvement Presentation Documentation Production support Management reporting Operational Reporting performance reporting Dashboard Testing SDLC

Work Experience

Data Analyst

Tata Consultancy Services (TCS)

Jun 2022 - Present

Designed and deployed interactive Tableau dashboards for multiple business units, improving reporting efficiency and enabling faster data-driven decision-making. Developed interactive Power BI dashboards and reports to visualize business KPIs, trends, and performance metrics, enabling stakeholders to make data-driven decisions. Used Power Query for data extraction, cleansing, transformation, and preparation from Excel, CSV, and Oracle database sources to create reliable reporting datasets. Performed data modeling in Power BI, including creating relationships between tables, developing calculated columns and measures using DAX, and designing optimized data models for reporting. Extracted, cleaned, transformed, and analyzed large datasets from Excel, CSV, and Oracle database sources to support enterprise business reporting needs. Developed optimized SQL queries for reporting, data extraction, and analysis across multiple enterprise data sources. Leveraged advanced Tableau features — LOD Calculations, Parameters, Actions, and Data Blending — to deliver sophisticated, business-ready analytics solutions. Managed end-to-end Tableau and Power BI dashboard lifecycle, including requirement gathering, design, development, testing, deployment, and post-production support. Collaborated with cross-functional teams and stakeholders to gather requirements, design BI solutions, and deliver actionable insights aligned with business objectives. Led migration of legacy reporting solutions to Tableau and Power BI environments, ensuring continuity and minimal disruption to business operations. Used AI tools such as Microsoft Copilot and Claude to accelerate data cleaning, formula/DAX/LOD drafting, and visualization design across dashboards. Documented all reporting solutions in accordance with SDLC standards, coding best practices, and organizational guidelines.

Education

B.E. – Electrical & Electronics - Dr. BAMU University, Aurangabad

- 2020 · Afghanistan

Polytechnic – Electrical Engg. - MGM's Polytechnic College

- 2017 · Afghanistan

12th (Science) - Jai Bhawani College, Aurangabad

- 2014 · Afghanistan

SSC (10th) - Vyanktesh High School, Aurangabad

- 2011 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 14/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 89/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation