Aditya Pillai

Experience

• 

  Tata Consultancy Services

  Oct 2015 - Sept 2017

  Operations Associate
• 

  Miles International

  May 2019 - Jul 2019

  Strategic Marketing
• 

  C5i

  Feb 2020 - Aug 2021

  Business Analyst

  Integrate disparate sources of data such as campaign, Online and sales data using AlteryxCreate tableau dashboards and creating kpi for above functionsAutomate manual excel reports using Python by importing data in Pandas dataframes.Create pipelines using Apache Nifi to ingest data and transform and store data in DW.Conducting analysis by cleaning data in tableau and importing the cleaned data in python using tableau api

• 

  Digitas India

  Aug 2021 - Jun 2022

  Senior Data Analyst

  Primary tools involved Python, Adobe Analytics Azure Synapse( Azure Data Factory) and Azure SQLIngesting data generated by Adobe Analytics using Analytics api 2.0Create pipelines in Azure data factory to transform data and load in SQL data warehouse(Azure SQL)Build dashboards on multiple projects as per requirements using the DWDoing time series analysis of the data in python and share insightsUsing Alteryx to create workflows to ingest flat file data dynamically using advanced macro functionsPrepare and clean data in Alteryx for data blending Show less

• 

  VML

  Jul 2022 - Oct 2022

  Data Analyst

  Working on PowerBI to create dashboards for multiple projects.Involved in Optimization of PowerBI data models and queries.Conduct the Data extraction process from Cloud data sources (Azure)Creating dashboard using PowerBI by using Salesforce CRM Email campaigns data.Conducting ETL queries in PowerBI using M in power query.Creating Dax calculations to conduct advanced analysis

• 

  PwC India

  Oct 2022 - Jan 2024

  Senior Consultant - Analytics Consulting
• 

  UBS

  Jan 2024 - now

  Data Analyst