Prem R profile photo 1 on Tal

Prem R

Manager Data Analytics, WPP Media | Business Analytics, IIM Trichy

Bengaluru

7+ years of work experience

WPP Media
Feb 20242 yrs 7 mosPresent

Bengaluru, Karnataka, India

•Performed exploratory data analysis (EDA) on large-scale campaign and audience datasets to identify performance drivers and optimization opportunities across CTR, CPC, CPM, ROAS, conversion rate, reach, impressions, and engagement metrics. •Conducted cohort analysis and funnel analysis across the digital journey—Impressions, Clicks, Visits, and Conversions—to evaluate engagement trends, identify conversion drop-offs, and improve campaign performance. •Applied segmentation analysis across brands, channels, audiences, devices, and geographies to identify high-performing segments and support targeting and budget decisions. •Performed root cause analysis on KPI deviations and reporting anomalies, enabling faster identification of underlying campaign and audience performance drivers. •Built scalable data models and transformation pipelines using SQL, dbt, Python, and Google BigQuery, providing reliable datasets for reporting and strategic decision-making. •Designed interactive Power BI dashboards for enterprise clients including Amazon and Britannia, enabling stakeholders to monitor campaign performance, audience engagement, and media-spend efficiency. •Automated reporting and ETL workflows using Python, Pandas, Power Query, VBA, and Power Automate, reducing reporting effort by 98% and turnaround time from 320 hours to 6 hours.
Tata Technologies Limited, Pune
Jul 20221 yr 9 mosMar 2024

Pune District, Maharashtra, India

•Conducted user experience research and competitive benchmarking on forklift models to identify customer pain points, product gaps, and improvement opportunities compared with competitor offerings. •Applied root cause analysis, stakeholder requirement analysis, and weighted feature-prioritization scoring across forklift operators, fleet managers, service personnel, and owners to rank existing, competitor, and proposed features, supporting data-driven feature selection for new product design. •Developed a configurable manufacturing cost model in Excel VBA to support pricing, margin analysis, cost comparisons, and scenario-based business decisions. •Designed and maintained Power BI dashboards for APAC manufacturing programs, improving stakeholder visibility into operational, project, and performance metrics. •Built automated ETL and data-preparation workflows using Excel Power Query and VBA, consolidating inputs from multiple sources into standardized and reliable reporting outputs.
Tata Technologies Limited, Pune
Jul 20202 yrsJun 2022

Pune Division, Maharashtra, India

Tata Technologies Limited, Pune
Jul 20191 yrJun 2020

Pune Division, Maharashtra, India

Prem’s AI Stack

codex
codex
opencode
opencode

Education

Indian Institute of Management Tiruchirappalli

Post Graduate certification in Business Analytics and its Application, Business Analytics

Indian Institute of Management Tiruchirappalli

20231 yr2024
Vellore Institute of Technology (VIT)

Bachelor of Technology, Mechanical Engineering

Vellore Institute of Technology (VIT)

20154 yrs2019

Join Prem and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Prem R on Tal

Headline

Manager Data Analytics, WPP Media | Business Analytics, IIM Trichy

About

Results-driven Data and Analytics professional with 6+ years of overall experience, including 2+ years in analytics, delivering scalable reporting, automation, and data transformation solutions. Proven ability to convert complex business requirements and raw data into actionable insights, streamlined workflows, and decision-ready reporting to support cross-functional stakeholders.

Location

Bengaluru

AI stack

codex

opencode

Work experience

Manager - Data Analytics at WPP Media, Feb 2024 - Present · 2 yrs 7 mos, Bengaluru, Karnataka, India, •Performed exploratory data analysis (EDA) on large-scale campaign and audience datasets to identify performance drivers and optimization opportunities across CTR, CPC, CPM, ROAS, conversion rate, reach, impressions, and engagement metrics. •Conducted cohort analysis and funnel analysis across the digital journey—Impressions, Clicks, Visits, and Conversions—to evaluate engagement trends, identify conversion drop-offs, and improve campaign performance. •Applied segmentation analysis across brands, channels, audiences, devices, and geographies to identify high-performing segments and support targeting and budget decisions. •Performed root cause analysis on KPI deviations and reporting anomalies, enabling faster identification of underlying campaign and audience performance drivers. •Built scalable data models and transformation pipelines using SQL, dbt, Python, and Google BigQuery, providing reliable datasets for reporting and strategic decision-making. •Designed interactive Power BI dashboards for enterprise clients including Amazon and Britannia, enabling stakeholders to monitor campaign performance, audience engagement, and media-spend efficiency. •Automated reporting and ETL workflows using Python, Pandas, Power Query, VBA, and Power Automate, reducing reporting effort by 98% and turnaround time from 320 hours to 6 hours.

Senior Design Engineer at Tata Technologies Limited, Pune, Jul 2022 - Mar 2024 · 1 yr 9 mos, Pune District, Maharashtra, India, •Conducted user experience research and competitive benchmarking on forklift models to identify customer pain points, product gaps, and improvement opportunities compared with competitor offerings. •Applied root cause analysis, stakeholder requirement analysis, and weighted feature-prioritization scoring across forklift operators, fleet managers, service personnel, and owners to rank existing, competitor, and proposed features, supporting data-driven feature selection for new product design. •Developed a configurable manufacturing cost model in Excel VBA to support pricing, margin analysis, cost comparisons, and scenario-based business decisions. •Designed and maintained Power BI dashboards for APAC manufacturing programs, improving stakeholder visibility into operational, project, and performance metrics. •Built automated ETL and data-preparation workflows using Excel Power Query and VBA, consolidating inputs from multiple sources into standardized and reliable reporting outputs.

Design Engineer at Tata Technologies Limited, Pune, Jul 2020 - Jun 2022 · 2 yrs, Pune Division, Maharashtra, India

Graduate Engineering Trainee at Tata Technologies Limited, Pune, Jul 2019 - Jun 2020 · 1 yr, Pune Division, Maharashtra, India

Education

Post Graduate certification in Business Analytics and its Application, Business Analytics, Indian Institute of Management Tiruchirappalli

Bachelor of Technology, Mechanical Engineering, Vellore Institute of Technology (VIT)