Chetan Mazumder
Kolkata
Summary
Experienced data analyst with a proven track record of over 2.5 years in leveraging SQL and Python to drive business insights and automation efficiencies. Demonstrated expertise in digital marketing analytics across diverse industries. Skilled in building and deploying BI solutions using Power BI, Excel, and Looker. Collaborates effectively with business stakeholders to deliver data-driven solutions that address client needs and enhance operational efficiencies.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Havas Media
10.2023 - Current
- 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
- Enabled seamless data aggregation, automated reporting, and enhanced analysis for optimized campaign performance through the use of Funnel's API integration with connected marketing channels.
- 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
11.2021 - 10.2023
- 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.
Education
Bachelor of Technology -
West Bengal University of Technology
Kolkata09.2020
Skills
- Data Analysis
- SQL
- Power BI
- Python Programming
- Advanced Excel
- VBA
- GCP
- GitLab
- Data Warehousing
- Data Wrangling
- Data Governance
- Statistics
- A/B Testing
- Machine Learning
- Communication Skills
- Team Collaboration
Certification
Google Advance Data Analytics
Link - https://www.coursera.org/account/accomplishments/specialization/certificate/JAYSR2A7MY25
Projects
Marketing Campaign, Python:
The primary objective is to maximize the return on investment (ROI) for our clients' advertising campaigns. We have conducted two ad campaigns, one on Facebook and the other on Google Ads, and we need to determine which platform yields better results in terms of clicks, conversions, and overall cost-effectiveness. By identifying the most effective platform, we can allocate our resources more efficiently and optimize our advertising strategies to deliver better outcomes for our clients., https://github.com/chetan78609/Marketing-Campaign
Yelp SQL Data Analysis, Python, SQL:
In a competitive market like the restaurant industry, understanding factors that influence business success is crucial for stakeholders. Utilizing Yelp dataset, this project aims to investigate relationship between user engagement (reviews, tips, and check-ins) metrics review count, ratings) restaurants., https://github.com/chetan78609/Yelp-SQL-Project
Timeline
Senior Data Analyst
Havas Media
10.2023 - Current
Analyst
Publicis Groupe
11.2021 - 10.2023
Bachelor of Technology -
West Bengal University of Technology
Google Advance Data Analytics
Link - https://www.coursera.org/account/accomplishments/specialization/certificate/JAYSR2A7MY25
Similar Profiles
Edward O'ReillyEdward O'Reilly
Senior Programmatic Trader at Havas MediaSenior Programmatic Trader at Havas Media
KARTIK TIWARIKARTIK TIWARI
Senior Media Planner (Media Planning) at Havas MediaSenior Media Planner (Media Planning) at Havas Media
Ramana Sankar VRamana Sankar V
Team Lead at Havas MediaTeam Lead at Havas Media