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.• Enhanced sales performances by 20% through regular market and competitor analysis

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 values, and outliers in the data. • 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. • Communicated data insights and recommendations regularly to business stakeholders to assist decision making related to marketing, inventory, and operations. • Documented data processes for maintainability. Developed Macros scripts for efficient data preparation. • Gained experience across the data science lifecycle including data collection, cleaning, analysis, modelling, visualization and communication of results. • Demonstrated analytical and problem-solving skills. Exhibited ability to turn raw data into impactful business insights. • Developed strong proficiency in languages like SQL and DAX as well as data tools including Excel, and Power BI over the course of the internship.

• 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 pharmaceutical client.• 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