Vagga Jayalakshmi

Data Analyst — PG Diploma in Data Science & AI — IIIT Bangalore

Talent

BengaluruMember since April 21, 2026

CTEsJoinsWindow FunctionsMySQLDAXPower QueryKPI DashboardsPivot TablesVLOOKUPSUMIFSMacrosPandasData CleaningStatistical AnalysisEDAStar SchemaData Quality ChecksDocumentationStakeholder Reporting

Hire this person

Send a job offer directly to this candidate

CTEsJoinsWindow FunctionsMySQLDAX

About

Data Analyst with 3+ years of experience in SQL, Power BI, and Advanced Excel — analysing operational datasets, building KPI dashboards, and delivering actionable insights that support business decisions across cross-functional teams. Experienced in data cleaning, ETL workflows, data modeling, and stakeholder reporting with strong ability to identify trends, patterns, and business opportunities from complex multi-source data. Holds PG Diploma in Data Science & AI from IIIT Bangalore with strong exposure to Python, machine learning, and statistical analysis.

Experience

Data and Operations Analyst - Arjate Farm Pvt Ltd

(2022-06 - 2025-12)

Analysed operational datasets from multiple sources using SQL (CTEs, joins, window functions) on MySQL — identified trends, patterns, and business opportunities including 30% demand concentration in key regions, supporting strategic resource allocation decisions.
Designed data models incorporating fact and dimension tables and star schema principles — enabled efficient querying, reduced data redundancy, and improved reporting performance across business teams.
Built and maintained Power BI dashboards with DAX measures and Power Query transformations tracking operational KPIs — replaced manual reports and reduced weekly reporting effort by 40%.
Cleaned and validated multi-source datasets resolving 20–30% data inconsistencies — maintained data quality checks, QA documentation, and data dictionaries ensuring accuracy and consistency across all analytical outputs.
Identified seasonal demand patterns and regional performance trends across 3 states — uncovered 22% revenue concentration in Q2, delivering structured insights that supported inventory planning and business strategy decisions.
Automated Excel reporting workflows using Power Query, Macros, Pivot Tables, VLOOKUP, and SUMIFS — reduced manual reporting effort by 20% and ensured consistent, accurate outputs for stakeholders.

Data Analyst Intern - Namdhari Seeds Pvt Ltd

(2021-10)

Cleaned, validated, and analysed data across 8+ crop variants and 50+ field plots using Excel and SQL — identified performance patterns and delivered data-backed recommendations improving yield efficiency by 15–20%.