Dharma Pradeep Borra

Worked cross-functionally with media, sales, research, and analytics teams to deliver end-to-end reporting solutions. Created customized media mix modeling reports with DV360, Google Ads, and Looker Studio. Extracted and transformed data using SQL and advanced spreadsheet techniques. Developed automated reporting frameworks to reduce manual effort. Provided business insights, trend forecasting, and proactive reporting for executive decisions. Managed time-sensitive global reporting ensuring quality under tight deadlines.

Managed 5 account pods supporting 35 global advertisers across home appliances, automotive, banking, eCommerce, and travel verticals. Oversaw $83M+ annual media spend generating $456M in revenue growth YoY with improvements in ROAS and CPA. Led North American automotive digital campaigns aligning to Canadian seasonality and compliance. Built AI-driven predictive campaign models for fast optimization. Collaborated with Google and META on reporting automation saving 3+ hours per report cycle. Managed ad tech stack including Google Ads, DV360, Meta Ads, GA360, and attribution models. Executed audits integrating Smart Bidding, Performance Max, and audience expansion for dynamic media mix optimization. Partnered with teams to deploy predictive dashboards and advanced visualizations using Salesforce, SQL, and Google Cloud. Managed $500K+ monthly budgets and exceeded revenue KPIs by 120%.

Designed and executed multi-channel Google Ads campaigns across Search, Display, Video, App, and Local campaigns driving traffic, leads, and revenue. Built customized Looker Studio dashboards tracking online and offline KPIs. Conducted KPI analysis for performance and optimization using CTR, ROAS, CPA data. Managed daily campaign monitoring, bid adjustments, and optimization. Supported sales forecasting, budget allocation, and ROI modeling. Led and trained junior analysts on campaign optimization and reporting automation. Presented performance reports and collaborated with global clients. Managed automated reporting pipelines using Google Ads, DV360, SQL, and advanced Excel/Google Sheets techniques.