Rohan Wagh

Proof of Experience

Ultimate Insulation Supplies · Oct 2023 – Jun 2026

Sole analytics resource for a D2C ecommerce business — building the full marketing-data, BI and forecasting function from scratch across a 2,000+ SKU Shopify estate and two sister companies.
Analytics engineering & BI: built dbt-modelled data layers and Power BI/DAX dashboards integrating GA4, Shopify, paid media and SEO data — cutting manual reporting time 40% and giving the business self-serve, real-time insight for the first time.
CRO & funnel optimisation: designed and ran structured A/B and multivariate tests across landing pages, product listings and paid-media creative — delivering 52% revenue growth and 40% conversion uplift through iterative testing, buyer-persona analysis and competitor benchmarking.
Forecasting & churn: built Python forecasting models (10% accuracy improvement, 15% cost reduction) and SQL/R churn analysis driving a 10% increase in returning customers.
Custom pricing & shipping engine: designed a rule-based pricing and shipping-cost system across 2,000+ SKUs — including volumetric-weight logic — replacing manual spreadsheets and directly supporting revenue growth.
Cross-platform insight reporting: produced analysis across Shopify, GA4, paid media and CRM, surfacing actionable insight on inventory, logistics, campaigns and sales funnels for senior stakeholders.
Root-cause analysis: analysed service-complaint data to surface failure patterns — improving on-time completion 12% and reducing repeat complaints 15%.

Scot Serve Ltd · Jun 2023 – Sep 2023

Concurrent with MSc Data Science for Business, University of Stirling.
Applied analytics across the full data science lifecycle using CRISP-DM and agile methodologies, supporting Scot Serve's digital transformation programme.
Cleaned and standardised raw data from multiple Excel files into a structured SQL database; conducted exploratory data analysis to identify and resolve inconsistencies, missing values and outliers.
Built an ETL pipeline to schedule and automate extraction and transformation of raw CSV data into analytical-ready datasets, replacing manual processing entirely.
Loaded cleansed data into Power BI and built interactive dashboards using DAX measures and data modelling — empowering self-service analysis of key sales KPIs and cutting manual reporting effort.
Uncovered customer behaviour trends and revenue growth opportunities through sales data analysis; communicated findings and recommendations regularly to business stakeholders to support decisions across marketing, inventory and operations.
Participated in requirement gathering sessions with stakeholders; documented data processes for maintainability and developed macro scripts for efficient data preparation.

Monster Agency® · Jun 2021 – Sep 2022

Agency-side performance marketing across 15+ clients — app-first brands, D2C ecommerce and OTT.
Full-funnel paid media strategy, creative briefing, campaign analytics and 24/7 client support.
Managed $20K monthly paid media spend across Meta and Google; delivered 4% MoM conversion rate increase and 20% CPA reduction through structured A/B testing, creative iteration and bid optimisation.
Planned and executed app install and user acquisition campaigns for mobile app clients — managing the full funnel from ad creative through to install, post-install engagement and retention.
Led influencer-led TikTok campaigns for a US brand, partnering with 5+ creators across brief development, content approvals and performance reporting; devised and executed Meta and TikTok strategies across 15+ client accounts.
Conducted root-cause analysis for an ecommerce client improving customer engagement and sales by 2.5x; collaborated with product and marketing teams delivering 40% improvement in retention and user experience.
Prepared management reports and client pitch decks across 500+ client meetings; analysed customer churn and renewal rates from 10K-row datasets.
Provided 24/7 consulting support and system upgrades across 15+ client accounts, maintaining continuity across campaigns and platforms.

Eminent Digitals · Mar 2021 – Jun 2021

Digital marketing strategy, product growth and operations consultancy for an early-stage technology platform.
Scaled India user base from 2,000 to 100,000 in 4 months through strategic digital marketing, platform distribution partnerships and targeted acquisition campaigns.
Led a 7-person cross-functional team to design, develop and launch a customer interaction platform — delivered with 30% engagement uplift and 40% improvement in retention and user experience.
Generated 15% new customer growth through media relations, press coverage and strategic partnerships including IPL sponsorship with Chennai Super Kings.
Tripled marketing spend for a QSR client through budget optimisation, resulting in accelerated growth.
Designed SLA-focused dashboards tracking turnaround, backlog and accuracy — improving SLA adherence by 10%.
Implemented an automated employee timesheet system saving 10 hours per week by eliminating manual processes.

Merkle Sokrati · Feb 2020 – Feb 2021

Performance marketing analytics at one of India's leading data-driven agencies (Dentsu Aegis Network).
Managed paid media strategy and analytics across 7 brand verticals — including a global OTT subscription platform, a mobile gaming client, pharmaceutical, ecommerce, financial services and food ordering — across 5 digital platforms.
Ran app install and subscription acquisition campaigns for a global OTT platform; reversed a revenue slump through seasonal trend analysis, white space identification and budget reallocation — delivering 20.5% sales recovery.
Managed user acquisition campaigns for a leading mobile gaming platform across Google and Meta — optimising bids, targeting and creative to drive installs and in-app engagement.
Reduced sign-up drop-offs from 55% to 29% for a pharmaceutical subscription app through A/B testing of onboarding flows, landing pages and ad creative — driving 40% uplift in user engagement and 15% higher content generation.
Developed advertising strategies across 7 brand verticals on 5 digital platforms; participated in all 4 quarterly business reviews with senior client stakeholders at Dentsu Aegis Network.
Established a knowledge base of 30 internal resources, streamlining employee onboarding and reducing administrative task time per project by 30%.

Aditya Birla Sun Life Insurance · Feb 2018 – May 2018

No completed sessions yet. Anything Rohan finishes shows up here with the evidence behind it.

University of Stirling · 2022 — 2023

The ICFAI University, Dehradun · 2017 — 2019

IBS Mumbai · 2017 — 2019

St Vincent pallotti college of engineering and technology · 2011 — 2015

Canossa convent high school dhule · 2004 — 2009