Aniruddha Sengupta

My role involved the creation of automated, cloud-based data pipelines and helping develop custom client software and dashboards. I also leveraged the use of a number of APIs (Google, Facebook, Twitter) to help automate a variety of processes and improve the efficiency within my team and the wider company. Some of my notable achievements were to help create a custom logic-parser in Plotly Dash which was able to create single and complex audience queries using logic gates. I also used GCP cloud functions to make a previous, highly manual process entirely automated and streamlined.

My job involves working with data, including its extraction, manipulation, analysis and validation to understand the market place and client context relevance to each project. All datasets provided per project is analyzed this way, with each KPI understood and explained back to the team. Proficiency in the extraction of data is important here along with familiarity with data extraction tools (Athena, Google Trends, Google Analytics, DoubleClick), often using APIs for efficient extraction. I am also proficient in a variety of tools which helps me to analyse the data and gain meaningful insights out of it. These include Microsoft Excel, SQL and Python (particularly with the use of Pandas). A large part of my work also involves using the data to create comprehensive models based on the client, the project, the KPIs as well as the overall goals. These econometric models are built using custom software and give us a variety of insights on where clients should spend their money against their media activation to gain the most efficient revenues and ROIs. Some of my notable achievements in this role was to develop new and exciting modelling software for the purposes of auto-modelleling using a variety of statistical methods. I also worked with developers on building custom MMM modelling software, keeping particular focus on being memory efficient as well as cutting down on manual modelling time.