Summary
Overview
Work History
Education
Skills
Certification
Languages
Master Thesis
Software
Personal Information
Timeline
SoftwareEngineer
Navya Ail

Navya Ail

Senior Analyst
Berlin

Summary

Master's Student in Engineering Management with experience of BI and Analytics with 3 years of experience in SQL, ETL, data modeling and data quality. Experienced in defining KPIs, owning analytics dashboards, and partnering with product stakeholders to drive data informed decisions.

Overview

5
5
years of professional experience
5
5
Certification
5
5

Years of Post-Secondary education

2
2

Languages

Work History

Data Analyst

BAM Creatives
Remote
10.2024 - Current
  • Analyzed large datasets to identify trends and provide actionable insights for decision-making.
  • Developed interactive dashboards using Tableau to visualize key performance indicators for stakeholders.
  • Collaborated with cross-functional teams to streamline data collection processes, enhancing efficiency and accuracy.
  • Conducted thorough data validation, ensuring integrity and reliability of reports generated for management review.

CUSTOMER SERVICE ASSOCIATE (PART-TIME)

AMREST
Berlin
04.2024 - Current
  • Delivered high-quality, customer-centric service in a fast-paced environment
  • Analyzed recurring customer inquiries and pain points to identify service improvements
  • Ensured accurate and timely order processing during peak hours
  • Resolved customer issues independently to maintain high satisfaction levels
  • Identified operational inefficiencies and provided structured feedback

SENIOR BUSINESS INTELLIGENCE DEVELOPER

CAPGEMINI
Bengaluru
09.2021 - 09.2024
  • Partnered with business stakeholders and product owners to define analytics requirements, success metrics and KPI frameworks
  • Built and maintained ETL pipelines in SAP BODS, ensuring reliable, timely, and self-serve data access
  • Designed and optimized SQL data models to support scalable analytics and performance monitoring
  • Developed interactive dashboards and reports (SAP WebI, Crystal Reports) for performance tracking and decision making
  • Implemented complex SQL procedures and materialized views, improving data accuracy by 80%
  • Owned KPI definitions and reporting logic for key performance dashboards used by business and product teams
  • Created and maintained data dictionaries and technical documentation
  • Implemented data validation, anomaly checks, and governance controls to ensure analytical rigor
  • Supported A/B experiments by defining guardrail metrics, validating data sources, and interpreting results
  • CLIENT: VOLKWAGEN FINANCIAL SERVICES UK

Education

MASTERS IN ENGINEERING MANAGEMENT - Leadership, IOT, Product development, Strategic Management, Marketing

IU Internationale Hochschule
10.2025

BACHELOR'S IN COMPUTER SCIENCE - Database Systems, Algorithms, Software Engineering, Web Development, OOPS, Java, Python

Sahyadri College of engineering
08.2021

Skills

  • SQL
  • Data Modeling (ETL/ELT)
  • Data Quality
  • SAP BO
  • SAP IDT/UDT
  • SAP BODS
  • DBT
  • Tableau
  • Looker
  • Python
  • PL/SQL
  • Agile/ Scrum
  • Jira
  • Confluence

Certification

  • Oracle - The Disruptive Value Proposition of Modern Cloud ERP
  • Aspiring Architect 2023 Certified Foundation Associate
  • OCEAN certification on Agile & SAP BODS - Capgemini
  • Microsoft Azure Fundamentals AZ-900 (on-going)
  • Implementing Provisioning in SAP BW/4HANA (on-going)

Languages

English
Advanced (C1)
German
Intermediate (B1)

Master Thesis

AI-Powered Data Quality in ETL Systems, IU International University, Germany, 06.2025-10.2025 

  • Development of a machine learning framework for automated anomaly detection and data cleansing.
  • Analysis of the relationship between data integrity in ETL processes and reporting accuracy in the banking sectors.
  • Applied machine learning models to improve reporting accuracy, enabling faster and more reliable business decisions.
  • Results: Demonstrated that automated data validation reduces compliance risks and improves decision-making speed.
  • Skills: Machine Learning, Data Analysis, SQL, Python, Quality Management, BI Reporting, Statistics

Software

SAP BODS(ETL/ELT)

SAP BO/BI(Crystal Reports and Web Intelligence)

SAP UDT/IDT

Oracle SQL

Microsoft Office Suite

SAP Management Console

GitHub

Visual Studio

Personal Information

Gender: Female

Timeline

Data Analyst

BAM Creatives
10.2024 - Current

CUSTOMER SERVICE ASSOCIATE (PART-TIME)

AMREST
04.2024 - Current

SENIOR BUSINESS INTELLIGENCE DEVELOPER

CAPGEMINI
09.2021 - 09.2024

MASTERS IN ENGINEERING MANAGEMENT - Leadership, IOT, Product development, Strategic Management, Marketing

IU Internationale Hochschule

BACHELOR'S IN COMPUTER SCIENCE - Database Systems, Algorithms, Software Engineering, Web Development, OOPS, Java, Python

Sahyadri College of engineering
Navya AilSenior Analyst