Ashna Virdikar

Data Analyst

Andheri West, Mumbai 2+ yrs exp 85 · Excellent

About

Data Analyst with 3+ years of experience supporting data operations, reporting, and business analytics across multinational organizations. Proficient in SQL, Python, Advanced Excel, Power BI, and ETL workflows, with hands-on experience managing datasets exceeding 100K+ records through data validation, reconciliation, quality assurance, and reporting automation. Proven ability to improve reporting accuracy by over 60%, automate SQL-based workflows reducing manual effort by 40%, and collaborate with cross-functional business and technology teams to deliver reliable, analytics-ready data. Strong analytical mindset with exceptional attention to detail and a keen interest in financial data management, operational processes, and continuously improving data quality through automation and process optimization.

Skills & Expertise (41)

SQL Advanced

8.2/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Exploratory data analysis Intermediate

7.0/10

Years Exp

Predictive Analytics Intermediate

7.0/10

Years Exp

KPI Reporting Intermediate

7.0/10

Years Exp

Power BI Intermediate

6.8/10

Years Exp

Statistical Analysis Intermediate

6.5/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

KPI Tracking Executive Reporting Data Storytelling Interactive Visualizations validation Deduplication ETL Pipelines Data Transformation Data Integrity Checks Reconciliation Frameworks Insight Communication Stakeholder Management Requirement gathering Cross-Functional Collaboration Agile Dashboard Development Advanced Excel scikit-learn NumPy Pandas Advanced SQL Multi-Source Data Integration Workflow Automation ETL Data Quality Data Reconciliation Business Performance Analysis Anomaly Detection Forecasting Predictive Modelling Trend Analysis

Work Experience

Data Analyst & Scrum Master

Vattenfall GmbH

Aug 2024 - Jan 2025

Owned end-to-end analytics workflows, consolidating and transforming 100K+ records from SQL databases, APIs, and Excel into clean, analysis-ready datasets supporting operational and strategic reporting. Analyzed financial KPIs, procurement performance, and demand trends using SQL and Excel, supporting planning and operational decision-making across Finance functions. Performed SQL-based data validation and reconciliation across 100K+ records from APIs, SQL databases, and Excel sources, improving reporting consistency by over 60% and ensuring reliable downstream reporting. Monitored multi-source data ingestion workflows, investigated data inconsistencies, and resolved quality issues before publishing executive reports. Documented SQL transformation logic, KPI definitions, validation procedures, and reporting workflows, improving knowledge sharing and ensuring consistent operational reporting. Maintained reporting documentation and analytical standards supporting repeatable data operations across business teams. Built Excel-based reconciliation reports and PivotTable analyses supporting operational reporting. Managed standardized operational datasets and reusable reporting models supporting consistent business reporting across Finance and Operations. Supported continuous process improvement by identifying recurring data quality issues and implementing validation controls that improved reporting accuracy by over 60%. Applied data validation, reconciliation, and quality control procedures to ensure compliance with reporting standards.

Working Student - Business Intelligence Analyst

Vattenfall Solar GmbH

Jun 2023 - Mar 2024

Developed and maintained 10+ dashboards tracking operational KPIs, business trends, and performance metrics across multiple business functions. Conducted trend and segment-level analysis to identify performance gaps, operational bottlenecks, and improvement opportunities. Transformed raw multi-source datasets (SQL, Excel, cloud systems) into structured reporting layers improving data usability and reporting consistency. Automated recurring reporting workflows reducing manual effort by ~35% and improving reporting efficiency. Optimized SQL queries and reporting datasets improving data retrieval and processing performance by ~25%. Partnered with stakeholders to gather analytical requirements and deliver scalable reporting solutions supporting business decision-making.

Business Analyst Intern - Finance Department

Nordex Group

Nov 2022 - Mar 2023

Analyzed 50K+ records to identify financial and demand trends, informing planning and strategy. Built KPI dashboards for Procure-to-Pay and financial performance tracking, improving reporting efficiency by ~30%. Performed forecasting and variance analysis, identifying ~20% demand increase impacting business planning.

Working Student - Market Intelligence Analyst

KRÜSS

Apr 2022 - Nov 2022

Analyzed market and customer datasets to identify trends and growth opportunities. Delivered insights supporting sales and marketing strategy decisions. Collaborated with stakeholders to translate business needs into analytical outputs.

Data Science Intern

IISER Pune

Jan 2021 - May 2021

Built Tableau dashboards to visualize geo-spatial climate and public health data across 10+ countries, improving research accessibility. Developed Python-based data pipelines (Pandas, NumPy) for data cleaning, transformation, and preparation of large datasets. Performed data validation and preprocessing, ensuring accuracy and usability for downstream analysis.