Aakansha Shrivas profile photo 1 on Tal

Aakansha Shrivas

Associate- Reporting & Analyst @IPG Mediabrands

Mumbai

5+ years of work experience

IPG Mediabrands India
Mar 20251 yr 5 mosPresent

Pune

• Automated marketing data ingestion pipelines from Facebook, Google Ads, and YouTube using Python scripts, ensuring seamless and timely data availability for reporting. • Integrated multi-platform marketing data into Snowflake using Adverity, reducing manual data handling efforts by 70% and improving overall data consistency. • Developed optimized Snowflake views to significantly enhance Tableau dashboard performance, resulting in faster load times and more reliable insights. • Maintained 99.9% dashboard uptime by proactively monitoring Adverity–Snowflake–Tableau scheduled pipelines and quickly resolving data refresh issues. • Automated SQL and Python-based QA validation processes, reducing QA time from 30–40 minutes to just 5 minutes, improving team efficiency and ensuring higher data accuracy across dashboards. • Worked extensively with Google BigQuery, including migrating large datasets from BigQuery to Snowflake, ensuring smooth schema alignment, performance tuning, and reliable data synchronization across platforms.
Exotrac, LLC
Apr 20232 yrsMar 2025

Bengaluru

• Unified and harmonized data from diverse sources to create a single, comprehensive commercial supply chain view, enabling stakeholders to access accurate, end-to-end insights for better decision-making. • Automated ticket reporting processes for yard management, reducing manual tracking efforts, improving data accuracy, and streamlining day-to-day operations for internal teams. • Applied advanced data analysis techniques to optimize supply chain workflows, identify bottlenecks, and support data-driven improvements that enhanced overall operational efficiency.
Bombay Stock Exchange Limited
Nov 20211 yr 6 mosApr 2023

Mumbai, Maharashtra, India

• Partnered with business analysts and stakeholders to gather requirements and develop insightful reports, enabling data-driven decision-making. • Created interactive dashboards to visualize key metrics and trends, empowering stakeholders to make informed business decisions. • Collaborated with cross-functional teams to identify business needs and develop data-driven solutions, contributing to business growth and improvement.

Aakansha’s AI Stack

claude
claude
codex
codex

Education

Master's degree, Artificial Intelligence & Machine Learning

The SIA College of Higher Education

20212 yrs2023
Somaiya Vidyavihar University

Bachelor's degree, Inf

Somaiya Vidyavihar University

20173 yrs2020

Join Aakansha and 10k+ other professionals on

Tal Boss

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

Download Tal Boss

Aakansha Shrivas on Tal

Headline

Associate- Reporting & Analyst @IPG Mediabrands

About

I am a data-driven professional with experience across data engineering, analytics automation, and business intelligence. I enjoy building scalable data solutions, automating manual processes, and enabling teams with accurate and meaningful insights. At IPG Mediabrands, I automated marketing data pipelines with Python, integrated multi-platform datasets into Snowflake via Adverity, optimized Tableau dashboards through efficient Snowflake view design, and built QA automation that cut validation time from 40 minutes to 5 minutes. I also worked on BigQuery–Snowflake data migration to strengthen overall data quality. At Exotrac, I unified supply chain data from multiple sources, automated yard management reports, and used analytics to identify operational inefficiencies and improve workflow performance. Earlier, at the Bombay Stock Exchange, I developed SQL-based reports and dashboards to support business teams with reliable insights. With a Master's degree in Artificial Intelligence & Machine Learning from SIA College of Higher Education, I bring a strong academic foundation in data integration, quantitative analytics, and intelligent systems. I am motivated to transform complex datasets into actionable insights that empower organizations to make informed, data-driven decisions and improve operational efficiency.

Location

Mumbai

AI stack

claude

codex

Work experience

Associate- Reporting & Analytics at IPG Mediabrands India, Mar 2025 - Present · 1 yr 5 mos, Pune, • Automated marketing data ingestion pipelines from Facebook, Google Ads, and YouTube using Python scripts, ensuring seamless and timely data availability for reporting. • Integrated multi-platform marketing data into Snowflake using Adverity, reducing manual data handling efforts by 70% and improving overall data consistency. • Developed optimized Snowflake views to significantly enhance Tableau dashboard performance, resulting in faster load times and more reliable insights. • Maintained 99.9% dashboard uptime by proactively monitoring Adverity–Snowflake–Tableau scheduled pipelines and quickly resolving data refresh issues. • Automated SQL and Python-based QA validation processes, reducing QA time from 30–40 minutes to just 5 minutes, improving team efficiency and ensuring higher data accuracy across dashboards. • Worked extensively with Google BigQuery, including migrating large datasets from BigQuery to Snowflake, ensuring smooth schema alignment, performance tuning, and reliable data synchronization across platforms.

Data Analyst at Exotrac, LLC, Apr 2023 - Mar 2025 · 2 yrs, Bengaluru, • Unified and harmonized data from diverse sources to create a single, comprehensive commercial supply chain view, enabling stakeholders to access accurate, end-to-end insights for better decision-making. • Automated ticket reporting processes for yard management, reducing manual tracking efforts, improving data accuracy, and streamlining day-to-day operations for internal teams. • Applied advanced data analysis techniques to optimize supply chain workflows, identify bottlenecks, and support data-driven improvements that enhanced overall operational efficiency.

SQL Developer at Bombay Stock Exchange Limited, Nov 2021 - Apr 2023 · 1 yr 6 mos, Mumbai, Maharashtra, India, • Partnered with business analysts and stakeholders to gather requirements and develop insightful reports, enabling data-driven decision-making. • Created interactive dashboards to visualize key metrics and trends, empowering stakeholders to make informed business decisions. • Collaborated with cross-functional teams to identify business needs and develop data-driven solutions, contributing to business growth and improvement.

Education

Master's degree, Artificial Intelligence & Machine Learning, The SIA College of Higher Education

Bachelor's degree, Inf, Somaiya Vidyavihar University