Open to opportunities

apurva arya

@apurvaarya

Senior BI & Analytics professional turning complex data into decision-ready insights through SQL, pipelines, and Power BI/Tableau dashboards.

India

Message

What I'm looking for

I’m looking for a senior BI/analytics role where I can own SQL-based insights, build reliable pipelines and dashboards, and partner with stakeholders to define success metrics—especially in high-impact migrations, KPI reporting, and process automation.

I’m a Senior Analytics Professional with 6+ years translating complex data into business insights across fintech, retail, insurance, and technology. I build SQL-driven analysis, reliable data pipelines, and stakeholder-ready dashboards so decisions are clear, consistent, and measurable.

I delivered a zero-data-loss legacy-to-new-system migration by designing source-to-target mapping, schema validation, and integrity checks across enterprise platforms including Vendavo and IBM AS400. I also achieved a 40% gain in reporting efficiency through process redesign and standardized, automated reporting templates.

My work is hands-on end-to-end: deep-dive SQL extraction and validation, KPI reporting, data profiling and quality checks, and presenting findings to leadership with root-cause analysis and actionable recommendations. I prioritize pipeline reliability by monitoring and triaging ETL failures in coordination with data engineering teams.

I bring strong dashboarding and reporting expertise using Power BI (DAX, Power Query), Tableau, and SSRS, along with data modeling and ETL transformation using Azure and Microsoft Fabric. I hold an MSc in Business Analytics (University of Exeter, Russell Group) and completed the McKinsey Forward Programme.

Experience

Work history, roles, and key accomplishments

Current

Senior BI Analyst

Current

Element14 (Avnet)

Jul 2025 - Present (1 year)

Led a legacy-to-new-system migration with zero data loss by designing source-to-target mapping, schema validation, and integrity checks. Built Power BI/SSRS reporting using DAX and Power Query and developed Azure/Microsoft Fabric data pipelines integrating Vendavo and IBM AS400 data.

SQL Source To Target Mapping Data Integrity Power BI DAX Power Query Data Pipelines Azure Microsoft Fabric Vendavo

Claims Analyst

Direct Line Group

May 2024 - Jan 2025 (8 months)

Improved data reliability for downstream claims reporting by building ETL workflows and automated data transformations using Python and SQL. Migrated KPI reporting from Tableau to Power BI and performed SQL deep-dives to identify anomalies and data-quality issues.

Python SQL ETL data transformation Tableau Power BI KPI Reporting Anomaly Detection Data Quality SQL Analysis

Data Analyst

Getir

Oct 2022 - Sep 2023 (11 months)

Analyzed transactional delivery and customer-segment patterns using scikit-learn models and root-cause analysis. Built Power BI dashboards for continuous KPI tracking and used Python and advanced Excel to clean, transform, and validate data.

Python SQL scikit learn Classification Clustering Data Cleaning data transformation Data Validation Root Cause Analysis Power BI KPI Tracking Trend Analysis

Senior Software Development Analyst

NTT Data

Oct 2018 - Sep 2021 (2 years 11 months)

Unified fragmented reporting by designing end-to-end data mapping and transformation processes and writing complex SQL for data extraction and analysis. Built Tableau and Excel dashboards and implemented standardized, automated reporting templates to reduce manual reporting effort by 40%.