Rishika Malhotra

Experience

• 

  Renault India

  Dec 2018 - Jan 2019

  Sales And Marketing Intern

  Handled sales, consumer engagement and end-to-end feedback analysis for car buyers and repair activities.

• 

  GYANJULA TECHNOLOGIES

  Jun 2019 - Jul 2019

  Event and Social Media Marketing Intern

  Promoted Gyanjula's General Knowledge mobile application; convinced 12 coaching institutes for live testsHandled social media marketing for multiple platforms; analyzed trends on Excel and developed pitching strategy

• 

  Amity School of Business

  Aug 2019 - Feb 2020

  Placement Coordinator
• 

  Publicis Media

  Jan 2021 - now

  Monthly advertisement performance analysis for American multichannel video programming distributorSupervised 4 analysts to manage end-to-end data extraction, analysis and strategy: Google ad-data > In-house data platform > GSheets analysis > Client dashboardDesigned performance dashboards of 6 ad-channels (e.g. audio); analyzed week-on-week sales through Tableau.Generated comprehensive performance monitoring reports on bi-weekly, monthly, and quarterly basis; presented actionable insights on campaign ROIs to clients; s/w used: MS-Excel Pivot Tables, PPTOptimizing ad-reporting and outreach for US-division of leading German supermarket chain Analyzed 400+ metrics on social media viewership to optimize advertisement outreach through real-time reportingImproved and expanded measurements of watch-time metrics in multiple iterations; handled SQL queries and Tableau outputsDesigned and managed 12 weekly Tableau dashboards, directly communicating KPIs to clients Show less Developed and executed digital marketing strategies for 10+ clients in diverse industries, leveraging Google Analytics, DV360, and Campaign Manager to optimize ROI, resulting in a 40% increase in customer engagement and a growth in sales revenue.Conducted extensive data exploration and visualization, unearthing pivotal patterns and trends in customer behavior and marketing campaigns. These findings proved instrumental in achieving a notable 30% reduction in ad spend, all while maintaining or surpassing campaign performance benchmarks, leading to substantial cost savings.Generated comprehensive performance monitoring reports on a weekly, bi-weekly, monthly, and quarterly basis; provided clients with actionable insights on campaign ROI, resulting in informed decision-making and increased revenue.Analyzed data from diverse market segments to identify patterns and trends, contributing to the harmonization efforts of Data Governance; delivered insights comparing client performance to competitors, facilitating data-driven strategies for improved market positioningOrchestrated integration of diverse datasets to streamline consumer outreach across multiple media platforms, leveraging in-house tools. Resulted in debugging metrics differences across-channel.Guided and supported junior team members in developing their analytical and problem-solving skills, fostering a culture of continuous learning. Show less

  • Associate Manager

    Apr 2023 - now

  • Analyst

    Aug 2021 - Apr 2023

  • Trainee Analyst

    Jan 2021 - Aug 2021