Rohan Wagh Email & Phone Number

Stirling, Scotland, United Kingdom

• Cultivated product catalog of 1000+ SKUs on Shopify including inventory tracking, order fulfillment, and volumetric shipping configurations.
• Designed dashboards and reporting to analyze sales volumes, margins, inventory levels, and other KPIs.
• Oversaw order fulfillment logistics including shipping integrations and volumetric weight calculations
• Produce a detailed analysis report of data from different platforms to uncover actionable insights around inventory, logistics, marketing campaigns, and sales funnels.
• Analyzed web traffic and customer analytics to develop buyer personas and optimize landing pages, increasing revenue scale by 40%.
• Identified opportunities for process automation and implemented solutions to enhance efficiency and data quality.

Alloa, Scotland, United Kingdom

• Followed CRISP-DM and agile methodologies on analytics projects. Participated in requirement gathering sessions with stakeholders.
• Cleaned and standardized raw data from multiple Excel files into a structured SQL database to enable analysis; conducted exploratory data analysis to assess data quality issues including inconsistencies, missing.
• Built an ETL pipeline to schedule and automate the extraction and transformation of raw data from CSV files into analytical ready datasets.
• Supported Scot Serve Ltd Company's digital transformation efforts by loading cleansed data into Power BI and creating interactive dashboards to provide business insights.
• Utilized Power BI's data modelling capabilities to build relationships and DAX measures that empowered self-service data analysis for key sales KPIs.
• Uncovered trends in customer behavior and identified revenue growth opportunities through analysis of sales data in Power BI dashboards.

• Implemented data-driven approach to optimize $20K monthly marketing spend, resulting in a 4% MoM increase in conversion rate and a 20% reduction in cost per acquisition.
• Analyzed customer churn and renewal rates from 10K rows in Excel data tables.
• Prepared management reports and client pitch decks for 500 client meetings.
• Conducted system upgrades and provided 24x7 consulting support for 15+ clients; devised and executed successful Meta and Tik Tok strategies.
• Conducted root cause analysis for an E-commerce client to improve customer engagement and sales by 2.5 times.
• Collaborated with product and marketing teams to enhance lead generation, leading to a 40% improvement in retention and user experience.

Pune, Maharashtra, India

• Expanded the company's Indian user base from 2,000 to 100,000 in 4 months through strategic digital marketing efforts.
• Generated a 15% increase in new customers by managing media relations, securing press coverage, and establishing partnerships, including sponsorship with the Chennai Super Kings IPL team.
• Implemented an automated employee timesheet system, saving 10 hours per week by eliminating manual processes.
• Tripled marketing spending for a QSR client through budget optimization, resulting in accelerated growth.
• Led a 7-person team in designing, developing, and launching an online customer interaction platform, increasing customer engagement by 30%.
• Collaborated with product and marketing teams to enhance lead generation, leading to a 40% improvement in retention and user experience.

• Developed advertising strategies for 7 brand verticals based on comprehensive market research and diagnostic analysis across 5 digital platforms.
• Achieved significant improvements, including a 40% increase in user engagement, 15% higher content generation, and a reduction in sign-up drop-offs from 55% to 29% through data analysis and A/B testing for a.
• Executed strategy and budget plans across diverse sectors, including Ecommerce, Financial, OTT, and online food ordering, participating in all 4 quarterly meetings with senior client stakeholder.
• Established a knowledge base of 30 internal resources, streamlining employee onboarding and knowledge transfer, resulting in a 30% reduction in administrative task time per project.
• Analyzed pricing, advertising, and distribution data for a global OTT client, identifying seasonal trends and white space, leading to strategic changes that reversed a sales slump, achieving a +20.5% sales increase.

Mumbai, Maharashtra, India

Master'S Degree, Data Science For Business, Merit

Master Of Business Administration - Mba, Marketing

Pgpm, Marketing, 7.5 Cgpa

Bachelor Of Engineering

Ssc