Sumangala

Data Analyst

Bangalore, Karnataka 80 · Excellent

About

Analytical Data Analyst with professional experience spanning data analytics, AI data quality validation, and end-to-end BI pipelines. Proficient in architecting relational star schemas, querying via MySQL Workbench, developing interactive dashboards, and automating MIS reports using Power BI, Tableau, MySQL Workbench, Microsoft Excel, and Python. Proven track record in anomaly detection, statistical evaluations, and root-cause analysis to deliver actionable business insights.

Skills & Expertise (40)

Power Pivot Intermediate

6.8/10

1.25

Years Exp

Joins Intermediate

6.8/10

1.25

Years Exp

SQL Queries Intermediate

6.8/10

1.25

Years Exp

Calculated Fields Intermediate

6.8/10

1.25

Years Exp

Data Modeling Intermediate

6.8/10

1.25

Years Exp

DAX measures Intermediate

6.8/10

1.25

Years Exp

Dashboard Development Intermediate

6.8/10

1.25

Years Exp

Data Cleaning Intermediate

6.8/10

1.25

Years Exp

Data Transformation Intermediate

6.8/10

1.25

Years Exp

Power Query Intermediate

6.8/10

1.25

Years Exp

PivotTables Intermediate

6.8/10

1.25

Years Exp

Quality Auditing Intermediate

6.3/10

1.25

Years Exp

Data Manipulation Intermediate

6.3/10

1.25

Years Exp

Exploratory data analysis Intermediate

6.3/10

1.25

Years Exp

NumPy Intermediate

6.3/10

1.25

Years Exp

Pandas Intermediate

6.3/10

1.25

Years Exp

Aggregate Functions Intermediate

6.3/10

1.25

Years Exp

CTEs Intermediate

6.3/10

1.25

Years Exp

Subqueries Intermediate

6.3/10

1.25

Years Exp

VLOOKUP Intermediate

6.3/10

1.25

Years Exp

Charts Intermediate

6.3/10

1.25

Years Exp

Conditional Formatting Intermediate

6.3/10

1.25

Years Exp

Index-match Intermediate

6.3/10

1.25

Years Exp

XLOOKUP Intermediate

6.3/10

1.25

Years Exp

MySQL WorkBench Intermediate

6.3/10

1.25

Years Exp

MySql Intermediate

6.3/10

1.25

Years Exp

Window Functions Intermediate

5.5/10

1.25

Years Exp

Stored Procedures Intermediate

5.5/10

1.25

Years Exp

Views Intermediate

5.5/10

1.25

Years Exp

Row-Level Security Intermediate

5.5/10

1.25

Years Exp

Parameters Intermediate

5.5/10

1.25

Years Exp

Star Schema Design Intermediate

5.5/10

1.25

Years Exp

Anomaly Detection Intermediate

5.5/10

1.25

Years Exp

Descriptive Statistics Intermediate

5.5/10

1.25

Years Exp

Probability Intermediate

5.5/10

1.25

Years Exp

Hypothesis Testing Intermediate

5.5/10

1.25

Years Exp

Correlation Intermediate

5.5/10

1.25

Years Exp

Variance Intermediate

5.5/10

1.25

Years Exp

Standard Deviation Intermediate

5.5/10

1.25

Years Exp

Data Validation Intermediate

5.5/10

1.25

Years Exp

Work Experience

Data Analyst

AiVariant

Present - 9 Months

Extracted, cleansed, and modeled multi-source business data using SQL queries (CTEs, Joins) in MySQL Workbench and Power Query to build robust analytical datasets. Engineered interactive dashboards in Power BI and Tableau with custom DAX measures and calculated fields, tracking core operational and performance KPIs.

AI Data Quality Analyst Intern

Rooman Technologies Private Limited

Present - 6 Months

Audited and validated large-scale AI datasets using Python and MySQL to identify mislabeled records, null discrepancies, and anomaly distributions. Formulated data quality metrics and automated error tracking reports, supporting pipeline enhancements and AI model benchmarking.