Summary
Overview
Work History
Education
Skills
Accomplishments
Quote
Timeline
Extracurricular Activities
Generic

Prateek Shrivastava

Gurugram

Summary

Data-driven marketing and product analytics professional with a track record of optimizing customer acquisition and engagement strategies. Deep understanding of customer behavior and market trends. Skilled in leveraging advanced analytics to drive impactful business outcomes. Proficient in utilizing industry-standard tools and methodologies to uncover actionable insights.

Overview

4
4
years of professional experience

Work History

Data Analyst

Storable
Hyderabad
01.2025 - Current
  • Designed and implemented custom event tracking and conversion goals within GA4 and GTM to measure user behavior, product performance, and the customer journey across websites.
  • Defined taxonomies for segment events and tracking.
  • Build a Tableau dashboard to track the page performance.
  • I conducted an analysis to track the growth of the platform over the past three years, based on the visits and reservations.

Analyst-1

Nykaa
Gurugram
10.2023 - 12.2024

Product Analytics -

  • Nykaa Play Optimization : Analyzed user behavior and content consumption within Nykaa Play (in-app video platform), Provided data-driven recommendations to improve content delivery and user engagement within the app.
  • Enhanced Affiliate Marketing: Led the integration of new affiliate partners (WishLink, Lehlah, YouTube, NAP Fashion), developed influencer dashboards and metrics, and conducted in-depth product analytics to optimize platform performance and identify revenue growth opportunities

Customer & Marketing -

  • Tailored marketing strategies to specific customer segments. Segmented customers by affluence (Luxe, Emerging Luxe, Mass, Masstige) and RFM analysis (Active, Inactive, Lapsed, Settled, Advocates) and Dormant & Deep-Dormant.
  • Organic Traffic & Channel Optimization : Analyzed paid and unpaid marketing channels to identify optimal acquisition strategies for different customer segments (New vs Repeat)
  • Marketing Channel Optimization: Analyzed paid and unpaid marketing channels to identify optimal strategies for acquiring, retaining, and converting customers.
  • Conducted A/B Testing: Led A/B testing of coupon campaigns across customer segments to optimize promotional effectiveness and drive incremental revenue.
  • Conducted comprehensive campaign performance analysis to drive data-driven marketing optimization. Developed and maintained robust reporting and dashboards to track key metrics, identified opportunities for improvement, and provided data-backed recommendations to inform strategic decision-making and drive sustainable growth.

Data Analyst

LBB
03.2021 - 10.2023
  • Product Analytics: Incorporated analytics into each of the product processes to track and analyse on-product user actions
  • Measured the performance of various product features by defining and tracking metrics to test different hypothesis
  • Data Warehousing: Devised a holistic solution that reduced manual consolidation effort to track different data and metrics
  • Effectively managed a data warehouse and dashboards to ensure the quality and availability of data for scalability and analysis respectively
  • Utilized cost optimization strategies to reduce expenses associated with data warehouses & data pipelines
  • Business Analytics: Exhibited expertise in the creation of comprehensive and informative reports, charts, and visualizations to effectively present data in a manner that is easily understandable for stakeholders
  • Collaborated with cross-functional teams to identify and resolve challenges pertaining to data, and made decisions while maintaining the precision and authenticity of the information.

Education

Bachelor of Engineering - Electrical - Engineering

MITS GWALIOR
Gwalior, MP
05-2019

Skills

  • SQL, Python
  • Clevertap, Mixpanel
  • Stitch, Dataddo, SuperMetrics
  • Databricks , Segment
  • Google Data Studio, Tableau
  • BigQuery, Redshift
  • MYSQL, Dbeaver, MongoDB,
  • Google Analytics , Googe Tag Manager
  • Google Sheets, MS Excel
  • S3 Bucket
  • A/B Testing
  • Root cause analysis

Accomplishments

  • Drove ETL migration initiative, resulting in a cost-effective solution that reduced expenses by 77%
  • Owned end-to-end affiliate program implementation and management, expanding the program from one to four platforms (WishLink, Lehlah, YouTube, NAP) for both beauty and fashion. Drove a 29% increase in affiliate revenue.

Quote

Stopping advertising to save money is like stopping your watch to save time.
Henry Ford

Timeline

Data Analyst

Storable
01.2025 - Current

Analyst-1

Nykaa
10.2023 - 12.2024

Data Analyst

LBB
03.2021 - 10.2023

Bachelor of Engineering - Electrical - Engineering

MITS GWALIOR

Extracurricular Activities

  • Completed the Tour De 100 Cycling Event as an Iron Finisher
  • Head of Committee Member For College Badminton Tournament
  • Interests: Tabla, Calligraphy
Prateek Shrivastava