Vignesh kumar

Data Analyst

Tamil Nadu, India 1+ yrs exp 83 · Excellent

About

Data Analyst with hands-on experience in SQL, MySQL, Power BI, DAX, Power Query, Excel, Tableau, and Python. Experienced in data cleaning, validation, SQL-based analysis, data modelling, KPI development, dashboard creation, and business reporting. Hands-on exposure to fact and dimension tables, Star Schema, ETL concepts, staging, ODS, and SCD Type 2. Currently strengthening Python/Pandas and advanced data analytics skills through practical projects and assignments.

Skills & Expertise (30)

MySql Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Excel Intermediate

7.5/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Joins Intermediate

7.0/10

Years Exp

CASE Statements Intermediate

7.0/10

Years Exp

Subqueries Intermediate

7.0/10

Years Exp

Aggregations Intermediate

7.0/10

Years Exp

KPI Analysis Intermediate

7.0/10

Years Exp

Business Reporting Intermediate

7.0/10

Years Exp

Data Quality Analysis Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Power Query Intermediate

7.0/10

Years Exp

DAX Intermediate

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Data Modelling Beginner

6.5/10

Years Exp

SCD Type 2 Beginner

6.5/10

Years Exp

Staging Beginner

6.5/10

Years Exp

ETL Concepts Beginner

6.5/10

Years Exp

Surrogate Keys Beginner

6.5/10

Years Exp

Star Schema Beginner

6.5/10

Years Exp

Fact & Dimension tables Beginner

6.5/10

Years Exp

Interactive Dashboards Beginner

6.5/10

Years Exp

KPI development Beginner

6.5/10

Years Exp

database design Beginner

6.5/10

Years Exp

Tableau Beginner

6.5/10

Years Exp

MySQL WorkBench Beginner

6.5/10

Years Exp

Python Beginner

6.0/10

Years Exp

Pandas Beginner

6.0/10

Years Exp

Microsoft Excel

Work Experience

Data Analyst

STACKLY

Jan 2026 - Present

Worked with SQL and MySQL for database/table creation, data management, validation, and business analysis. Created relational tables using Primary Keys and Foreign Keys; performed checks for NULLs, duplicates, incorrect values, and inconsistencies. Developed SQL queries using SELECT, WHERE, GROUP BY, ORDER BY, HAVING, CASE, aggregate functions, and JOINs. Used Power Query for data cleaning/transformation and Power BI for KPI cards, charts, slicers, tables, matrices, filters, and conditional formatting. Created DAX measures/calculated columns and worked with data modelling, Star Schema, fact/dimension tables, and relationships. Worked on Hotel Booking, Food Delivery, Airline & Airport, and E-Commerce/Order Management analytics projects. Gained practical exposure to Data Warehousing, Staging, ODS, Dimension/Fact tables, ETL concepts, and SCD Type 2; supported validation, documentation, reviews, and presentations.

Associate Copy Editor

TNQ TECH PVT. LIMITED

Feb 2025 - Dec 2025

Edited academic journal content according to style guides, quality standards, and SOPs. Performed detailed checks for consistency, formatting, grammar, and accuracy while following defined workflows and timelines.