Puneet Agarwal

Media Analytics

• Extracted Data Using IQVIA Navigator to measure DTC performance.

MSO (Media Science & Operation)

• Build automated dashboards to support CD&A team, significantly reducing manual effort and turnaround time.
• Implemented website engagement re-tagging strategies, improving tracking accuracy

Media Analytics Aug'25 - Dec'25

• T1A Correlation analysis, to evaluate the relationship between media touch point (Engagements & Sales) and User actions (sales conversion), enabling data-driven media optimizations.
• Served as SME for AI-driven creative automation, enabling scalable and efficient creative analysis.
• Performance reporting tracking across branded and unbranded media channels.

Alignment & Placement Jun'23 to Sep'23

• Using Placement Optimization tool JTD, implemented Rep Placement and coverage across assigned territories.

Campaign Analytics Oct'23 to Dec'24

• Frequency Optimization analysis across programmatic channels, reducing overexposure and improving reach efficiency
• Conducted content affinity analysis to identify high-performing creatives and performance drivers to improve campaign efficiency.
• Performed Paid Search optimization, analyzing keywords, which eventually help in reducing VBB amount by 30%.
• Build a Databricks Dashboard (Tableau-like) to track KPIs, pacing charts, and cost-based metrics, reducing manual reporting time by 45%

Media Analytics Jan'25 - Aug'25

• Goal Calculation and performance tracking of digital campaign across different BUs
• Reported and monitored ELLs and key KPIs aligned with top-bottom funnel marketing strategies
• Acted as a client-facing analytics partner, translating complex data into actionable insights.
• Supported startegic decision-making through regular performance reviews and presentation

• Developed RESTful APIs using Spring Boot and optimized API performance
• Conducted API testing/debugging with Postman and ensured scalability & error handling
• Collaborated in Agile teams, using Git for version control
• A startup focused on innovative tech solutions