Aadi Bansal
Gurgaon
Summary
Dynamic Analyst with experience at Deloitte India, specializing in building robust ETL pipelines and data warehousing solutions on GCP. Proven ability in automating data processes and delivering insightful Power BI dashboards. Strong in Python and SQL, complemented by effective team leadership and project management skills.
Overview
6
6
years of professional experience
Work History
Analyst
Deloitte India
Gurgaon
01.2025 - Current
- Led government-sector project, building end-to-end ETL pipelines on GCP to streamline data processing
- Automated data ingestion from REST APIs and GZIP/file-based sources using Python & SSIS, enhancing data accessibility
- Designed data models and implemented data warehousing solutions in BigQuery using SQL
- Used Cloud Functions, Cloud Storage, and IAM for secure, scalable processing
- Implemented pipeline monitoring, logging, scheduling automation, and data quality validation to ensure reliable data flows
- Enabled analytics through Power BI dashboards and maintained code using Git
Intern
Ericsson India
Noida
08.2023 - 12.2023
- Contributed to development and deployment of project monitoring, analyzing, and detecting anomalies in incoming traffic data for T-Mobile
- A leading global provider of telecommunications equipment and services
- Collaborated with teams to support project planning and execution for telecommunications solutions.
- Assisted in analyzing data to optimize network performance and service delivery.
- Developed documentation for internal processes to enhance team communication and efficiency.
Team Leader
Artth Transformational Services
Gurgaon
01.2020 - 12.2020
- Led a team of 8 people and worked with Resident Advisors to manage events
- Oversaw finance allocations and logistics for the company
- Provided transformational services in various domains.
Education
Bachelor of Technology -
Vellore Institute of Technology
Vellore05.2025
Class XII -
Delhi Public School
Gurgaon05.2021
Skills
- Data Warehousing
- Data Modeling
- ETL pipeline development
- SQL
- SQL database management
- Python
- Power BI
- Data visualization
- REST API Integration
- Cloud & Data Engineering: GCP (Cloud Storage, BigQuery, Cloud Functions, IAM)
- GZIP / File-based Data Ingestion
- Automation & Scheduling
- C/C
Websites
Projects
Traffic Trend Analyser for Ericsson:
A robust system for monitoring and analyzing traffic data designed to monitor and analyse incoming traffic data, identifying anomalies by comparing current patterns against historical data. Engineered to support rapid response initiatives by generating real-time alerts whenever unusual trends are detected.
Business Performance KPI Dashboard:
Developed an interactive business intelligence dashboard to track KPIs, trends, and performance metrics. Cleaned and modeled data using SQL, performed trend and comparative analysis, and enabled stakeholders to monitor business health and identify improvement areas.
Cloud-Based ETL & Analytics Pipeline:
Designed an end-to-end cloud data pipeline to ingest data from APIs and file sources, transform it using Python, and store it in a BigQuery data warehouse. Implemented data validation, automation, and monitoring, and delivered insights through interactive Power BI dashboards for data-driven decision-making.
Timeline
Analyst
Deloitte India
01.2025 - Current
Intern
Ericsson India
08.2023 - 12.2023
Team Leader
Artth Transformational Services
01.2020 - 12.2020
Bachelor of Technology -
Vellore Institute of Technology
Class XII -
Delhi Public School