Headline

Marketing Data Analyst | Power BI | Advanced SQL | Python | BigQuery | Google Ads Data Hub (ADH) | Marketing & Media Analytics | Dentsu | Turning Campaign Data into ROI Insights

About

I’m a Data Analyst at Dentsu with experience transforming large-scale advertising data into actionable insights that improve campaign performance and ROI. I work with platforms such as Google Ads Data Hub, BigQuery, Amazon Marketing Cloud, and Meta Advanced Analytics to analyze billions of marketing data points and uncover insights around user journeys, attribution, and campaign effectiveness. My work focuses on helping marketing teams answer questions like: • Which channels drive the highest ROI? • Where do users drop off in the funnel? • How can campaigns be optimized for better conversion? I build interactive Power BI dashboards, scalable SQL models, and automated reporting workflows that allow stakeholders to monitor campaign performance and make faster data-driven decisions. Key Skills • Marketing & Media Analytics • Power BI Dashboarding & DAX • Advanced SQL & BigQuery • Google Ads Data Hub (ADH) • Amazon Marketing Cloud • Attribution & Funnel Analysis • Python for Data Automation I’m passionate about using data to help marketing teams optimize campaigns, improve conversion performance, and drive measurable business growth. Always open to connecting with data, marketing, and analytics professionals.

Location

Nagpur

AI stack

claude

cursor

gemini

opencode

Work experience

Data Analyst at dentsu, May 2024 - Present · 2 yrs 3 mos, Pune District, Maharashtra, India, Built 10+ interactive Power BI dashboards used by marketing teams to monitor campaign KPIs across multiple client accounts • Developed optimized SQL queries analyzing billions of advertising records in BigQuery and Ads Data Hub • Reduced manual reporting time by 30% through Power BI data modeling and automated data pipelines • Conducted campaign performance analysis and A/B testing to improve conversion performance and media efficiency • Automated reporting workflows using Python + SQL, saving 8+ hours of weekly manual reporting

Junior Data Analyst at Micropro Software Solutions Limited, Jan 2024 - May 2024 · 5 mos, Nagpur, Maharashtra, India

Education

Bachelor of Technology - BTech, Electronics Engineering, Yeshwantrao Chavan College of Engineering - YCCE

HSC, Computer Science, Nirala Vidyalaya Junior College