Chetan Mazumder

Senior Data Analyst

Havas Media•  October 2023 - Present•  Gurgaon

Designed and implemented interactive dashboards using Power BI and Looker, enhancing campaign performance tracking and KPI reporting, resulting in a 12% increase in Sales. Conducted in-depth data analysis for specific clients using Python programming, resulting in an 18% increase in ad views by optimizing creative content strategies. Optimized data tables and views using SQL within BigQuery on Google Cloud Platform (GCP), enabling advance concepts of Data Warehousing. Contributed to the creation of a comprehensive product for delivering granular planned and actual data, focusing on ad formats and creative sizes, to enhance client reporting accuracy. Played a key role in developing a media planning tool using Power Query, facilitating the reporting of planned data and its subsequent extraction to client dashboards, ensuring alignment with actual data.

Analyst

Publicis Groupe•  November 2021 - October 2023•  Gurgaon

Aligned with data governance of more than 22 EMEA Markets ensuring data quality of media plans. Created Media Planning Template for Specific EMEA Markets, to achieve highest possible level of data quality. Automated weekly reporting for onshore team to ensure timely delivery of spent through different media channels and campaign activity using VBA. Developed Tracker for onshore team to enable efficient bonus calculations. Conducted training sessions to multiple teams and stakeholders on the effective utilization of data governance tools.