sathiya v

Data Analyst

Bengaluru, India 0+ yrs exp 82 · Excellent

About

Data Analyst with 6 months of hands-on experience in Power BI, SQL, DAX, Power Query, and Excel, building sales dashboards and KPI reports that support business decisions. Skilled in writing optimized SQL, automating reporting workflows, and explaining findings clearly to technical and non-technical stakeholders.

Skills & Expertise (31)

Power BI Advanced

8.2/10

Years Exp

Power Query Advanced

8.0/10

Years Exp

DAX Advanced

7.8/10

Years Exp

SQL Intermediate

7.6/10

Years Exp

Joins Intermediate

7.4/10

Years Exp

CTEs Intermediate

7.4/10

Years Exp

Subqueries Intermediate

7.4/10

Years Exp

Window Functions Intermediate

7.4/10

Years Exp

Stored Procedures Intermediate

7.4/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

Pivot Tables Intermediate

7.0/10

Years Exp

Advanced Excel Intermediate

7.0/10

Years Exp

MySql Intermediate

6.8/10

Years Exp

XLOOKUP Intermediate

6.8/10

Years Exp

VLOOKUP Intermediate

6.8/10

Years Exp

SQL Server Intermediate

6.8/10

Years Exp

VBA Macros Intermediate

6.0/10

Years Exp

Conditional Formatting Intermediate

6.0/10

Years Exp

MIS Reporting Intermediate

6.0/10

Years Exp

Python Basics Intermediate

6.0/10

Years Exp

KPI Reporting Intermediate

6.0/10

Years Exp

Pandas Intermediate

5.8/10

Years Exp

NumPy Intermediate

5.8/10

Years Exp

EDA Intermediate

5.8/10

Years Exp

Data Wrangling Intermediate

5.8/10

Years Exp

Indexing Report Publishing KPI Cards Interactive Dashboards RLS Data Modeling

Work Experience

Data Analyst Intern

BDreamz Global Solutions Pvt Ltd

Apr 2026 - Present

Designed a multi-page Power BI dashboard on SQL Server data to track sales KPIs, revenue trends, and regional performance across 5 business units and 20+ product lines. Wrote SQL (CTEs, window functions, joins, stored procedures) to extract and clean 100K+ transactional records, reducing data preparation time by 60%. Built DAX measures (YoY Growth %, Profit Margin, Gross Revenue, Customer Retention Rate) and implemented row-level security (RLS) for region- and department-based access. Automated monthly reporting with Power Query ETL across SQL tables and Excel sources, saving about 15 hours per month. Recognized as Best Performer for delivering dashboards on time and praised by management for accurate insights.

Operations Executive – Trainee

Infosys

Dec 2020 - May 2021

Gained practical exposure to SQL and Python fundamentals, including querying, filtering, grouping, and basic analysis; coordinated with team members to capture and organize reporting data correctly.