Apurva Arya profile photo 1 on Tal

Apurva Arya

Senior BI Analyst | Turning Messy Data into Decisions | SQL, Power BI, Python, Azure/Fabric | MSc Business Analytics (Exeter)

Bengaluru

6+ years of work experience

element14 Electronics
Jul 20251 yr 1 moPresent

Bengaluru, Karnataka, India

• Reduced report generation and distribution time from 2 hours to 18 minutes (85% faster) by redesigning the reporting workflow using advanced Excel formulas and automation techniques, significantly improving operational efficiency. • Led a zero-data-loss legacy-to-new-system migration by designing source-to-target mappings, validating schemas, and performing comprehensive data integrity checks throughout the migration lifecycle. • Developed and optimized complex SQL queries, stored procedures, and views to extract, validate, and analyze large datasets, improving reporting performance and supporting business decision-making. • Built and maintained Power BI dashboards and SSRS reports using DAX and Power Query (M), enabling leadership to monitor key business KPIs through interactive and automated reporting. • Integrated enterprise data from Vendavo, AS400 (Orbit), and SQL Server into centralized reporting solutions by developing ETL pipelines and dataflows using Azure and Microsoft Fabric. • Performed data profiling, reconciliation, and quality validation across large datasets to ensure reporting accuracy, consistency, and compliance with data governance standards. • Proactively monitored, investigated, and resolved ETL pipeline failures, collaborating with cross-functional teams to maintain reliable data availability for business reporting. • Partnered with business stakeholders to understand reporting requirements, troubleshoot data issues, and deliver scalable reporting solutions that supported operational and strategic decision-making.
Direct Line Group
May 20249 mosJan 2025

Liverpool, England, United Kingdom

As a Claims Handler at Motability Operations, I play a crucial role in delivering exceptional service and support to our clients. My responsibilities encompass the entire claims process, ensuring that each claim is handled efficiently, accurately, and with the utmost care. Key Achievements: Efficiency Improvements: Implemented process enhancements that reduced claim processing time by 20%, leading to faster resolution. High Customer Satisfaction: Consistently received positive feedback from claimants for delivering compassionate and effective support throughout the claims process. Team Collaboration: Contributed to a collaborative team environment, sharing insights and best practices that improved overall team performance and service delivery.
Getir
Sep 20221 yr 7 mosMar 2024

Liverpool, England, United Kingdom

• Automated 6+ ETL workflows using Python and SQL, reducing manual data preparation and improving data quality. • Migrated 12 reporting dashboards from Tableau to Power BI with zero disruption to quarterly business reporting. • Analyzed large insurance claims datasets using SQL to identify trends, anomalies, and business insights. • Applied data profiling and anomaly detection techniques to improve processing accuracy by 16% and reporting reliability.
NTT DATA
Oct 20183 yrsSep 2021

Bengaluru, Karnataka, India

• Designed end-to-end data mapping and ETL processes to integrate multiple source systems into a unified reporting platform. • Developed complex SQL queries, stored procedures, and views to support enterprise reporting and analytics. • Gathered business requirements and translated them into functional specifications and data flow diagrams. • Built Tableau and Excel dashboards used by finance, analytics, and product teams for business reporting. • Reduced manual reporting effort by 40% through standardized and automated reporting templates.

Education

University of Exeter

Master's degree, Business Analytics

University of Exeter

20211 yr2022

Bachelor in Engineering, Information Science

Dayanand Sagar Academy of Technolgy and Management

20144 yrs2018

Join Apurva and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Apurva Arya on Tal

Headline

Senior BI Analyst | Turning Messy Data into Decisions | SQL, Power BI, Python, Azure/Fabric | MSc Business Analytics (Exeter)

About

I turn messy, high-volume data into decisions leadership teams can act on. 6+ years across fintech, retail, insurance, and tech — building SQL-driven analysis, ETL pipelines, and Power BI/Tableau dashboards that give stakeholders real-time visibility into their business. Highlights: ◆ Led a zero-data-loss legacy system migration end-to-end ◆ Cut manual reporting effort by 40% through process redesign ◆ Applied anomaly-detection techniques to structured claims data, surfacing fraud-indicative patterns for investigation What I bring: ◆ Advanced SQL, T-SQL, and Python for deep-dive analysis on large datasets ◆ Power BI (DAX, Power Query), Tableau, and SSRS for stakeholder-ready reporting ◆ ETL/data pipeline design on Azure and Microsoft Fabric — source-to-target mapping, data quality validation ◆ A track record of turning ambiguous business asks into structured, decision-ready insights MSc Business Analytics, University of Exeter (Russell Group). McKinsey Forward Programme alum. Worked across India and the UK — comfortable async, cross-functional, cross-time-zone. Currently exploring BI, data engineering, and analytics consulting roles — open to remote/global opportunities.

Location

Bengaluru

Work experience

Senior BI Analyst at element14 Electronics, Jul 2025 - Present · 1 yr 1 mo, Bengaluru, Karnataka, India, • Reduced report generation and distribution time from 2 hours to 18 minutes (85% faster) by redesigning the reporting workflow using advanced Excel formulas and automation techniques, significantly improving operational efficiency. • Led a zero-data-loss legacy-to-new-system migration by designing source-to-target mappings, validating schemas, and performing comprehensive data integrity checks throughout the migration lifecycle. • Developed and optimized complex SQL queries, stored procedures, and views to extract, validate, and analyze large datasets, improving reporting performance and supporting business decision-making. • Built and maintained Power BI dashboards and SSRS reports using DAX and Power Query (M), enabling leadership to monitor key business KPIs through interactive and automated reporting. • Integrated enterprise data from Vendavo, AS400 (Orbit), and SQL Server into centralized reporting solutions by developing ETL pipelines and dataflows using Azure and Microsoft Fabric. • Performed data profiling, reconciliation, and quality validation across large datasets to ensure reporting accuracy, consistency, and compliance with data governance standards. • Proactively monitored, investigated, and resolved ETL pipeline failures, collaborating with cross-functional teams to maintain reliable data availability for business reporting. • Partnered with business stakeholders to understand reporting requirements, troubleshoot data issues, and deliver scalable reporting solutions that supported operational and strategic decision-making.

Claims Handler- Analyst at Direct Line Group, May 2024 - Jan 2025 · 9 mos, Liverpool, England, United Kingdom, As a Claims Handler at Motability Operations, I play a crucial role in delivering exceptional service and support to our clients. My responsibilities encompass the entire claims process, ensuring that each claim is handled efficiently, accurately, and with the utmost care. Key Achievements: Efficiency Improvements: Implemented process enhancements that reduced claim processing time by 20%, leading to faster resolution. High Customer Satisfaction: Consistently received positive feedback from claimants for delivering compassionate and effective support throughout the claims process. Team Collaboration: Contributed to a collaborative team environment, sharing insights and best practices that improved overall team performance and service delivery.

Data Analyst at Getir, Sep 2022 - Mar 2024 · 1 yr 7 mos, Liverpool, England, United Kingdom, • Automated 6+ ETL workflows using Python and SQL, reducing manual data preparation and improving data quality. • Migrated 12 reporting dashboards from Tableau to Power BI with zero disruption to quarterly business reporting. • Analyzed large insurance claims datasets using SQL to identify trends, anomalies, and business insights. • Applied data profiling and anomaly detection techniques to improve processing accuracy by 16% and reporting reliability.

Senior Software Analyst at NTT DATA, Oct 2018 - Sep 2021 · 3 yrs, Bengaluru, Karnataka, India, • Designed end-to-end data mapping and ETL processes to integrate multiple source systems into a unified reporting platform. • Developed complex SQL queries, stored procedures, and views to support enterprise reporting and analytics. • Gathered business requirements and translated them into functional specifications and data flow diagrams. • Built Tableau and Excel dashboards used by finance, analytics, and product teams for business reporting. • Reduced manual reporting effort by 40% through standardized and automated reporting templates.

Education

Master's degree, Business Analytics, University of Exeter

Bachelor in Engineering, Information Science, Dayanand Sagar Academy of Technolgy and Management