Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Aditya Mandhana

Indore

Summary

Dynamic Business Intelligence Engineer with 8+ years of experience, proven track record at Amazon, specializing in Tableau and SQL. Strong project management skills and expertise in AWS Redshift enhance data-driven decision-making across diverse domains, including telecom, app and risk analytics.

Overview

8
8
years of professional experience

Work History

Business Intelligence Engineer II

Confluent
Remote
03.2024 - Current
  • Worked on Tableau to create the dashboard for the product launch, predictive modeling, and finance reports.
  • I did a deep dive analysis on making the decision regarding the product launch.
  • Designed a data model and pipeline using Airflow to source data in Tableau.
  • Created SOP for the cleanup and license management over the Tableau server to decrease the overall cost of the license.

Business Intelligence Engineer II

Amazon
Bangalore
11.2021 - 03.2025
  • I worked on Tableau to create the dashboard for the product launch and app feature launch using Redshift, Athena, and Tableau.
  • Worked on designing the aggregated table for the 700-800 TB of data in Redshift, so it can be easily consumed by the Tableau dashboard. I did write multiple complex SQL queries to retrieve the data on the right grains.
  • Set up a code review process in the team of 13 members to avoid mistakes in production.
  • Set up an operation process to manage the Tableau Server workbook that is being utilized by our stakeholders. I created a process to minimize the number of extracts that are running over the Tableau server and consuming most of the Redshift connections. It led to a cost reduction of $1,000 per month.
  • Worked on splitting the data source to minimize the size of the hyper file.

Consultant

Fractal Analytics
Bangalore
03.2021 - 11.2021
  • Worked on designing the Qlik dashboard for Human Resources – Retention, Requisition, and Learning of employees.
  • Managing end-to-end projects with the stakeholders to find insights on improving the retention rate for employees.
  • Created a data model out of the Workday data.
  • Led a 4-member team and created proper guidelines to optimize the dashboard.
  • Worked on access management of the user’s data to ensure data privacy within the different teams.

Senior Risk Analyst

Uber
Hyderabad
03.2020 - 03.2021
  • Worked on dashboard creation to stop account takeover frauds that are happening on the Uber platform.
  • Identifying fraud patterns and creating rules to stop fraudsters from taking rides, I have created over 40 rules that saved approximately $500,000 in the US and Europe region.
  • Worked with ops teams to create a SOP to take action over the account takeover users, and worked on converting email OTP accounts to SMS OTP accounts in order to reduce the fraud over the platform.

Business Technology Analyst

ZS Associate
Pune
07.2019 - 03.2020
  • Led a 3-member team in developing BI applications to deliver data-driven narratives and insights to pharmaceutical brand teams. This supported field sales analysis and biosimilar impact readiness analysis, employing SQL, Qlik Sense, and data modeling.
  • Assisted a crucial client by enhancing the performance of a critical BI application, resulting in a 65% improvement. This was achieved through data model optimization, and simplification of calculations and visualizations.
  • Worked on the design and implementation of an incentive dashboard that can be utilized by the field reps to check the projection of incentives, sales, and benefits.

Software Support Engineer

Amdocs
Pune
01.2017 - 07.2019
  • Created a data pipeline to transform the data, which can be utilized by the BI tool to create reports. While creating the pipeline, we use complex SQL to write and find the desired result to gain insight.
  • Created a Qlik Star schema data model to create the dashboard for 100 TB of data.
  • Created a Qlik dashboard that can be utilized by the stakeholders to make business decisions.

Education

Bachelor of Engineering - Information Technology

Medicaps Institue of Science And Technology
Indore
07-2016

Skills

Business Intelligence Tools - Tableau, SQL, Git, Excel, airflow, python

Cloud Platform - AWS S3, AWS Athena, GCP

Database - AWS Redshift, BigQuery, Cassandra, Postgres

Soft skills - project management, team leadership, client management, critical thinking, leadership, Scrum/Agile, ownership

Domain - Telecom, Incentives, Traveling, Risk, Human Resources, Device, and App Analytics

Accomplishments

  • Received the Star Award in 2021 for managing the stakeholders and improving customer experience.
  • Received Employee of the Quarter 2017 for automating the current running operational activity.

Timeline

Business Intelligence Engineer II

Confluent
03.2024 - Current

Business Intelligence Engineer II

Amazon
11.2021 - 03.2025

Consultant

Fractal Analytics
03.2021 - 11.2021

Senior Risk Analyst

Uber
03.2020 - 03.2021

Business Technology Analyst

ZS Associate
07.2019 - 03.2020

Software Support Engineer

Amdocs
01.2017 - 07.2019

Bachelor of Engineering - Information Technology

Medicaps Institue of Science And Technology

Similar Profiles

CREATE PROFILE
Aditya Mandhana