Summary
Overview
Work History
Education
Skills
Accomplishments
Quote
Work Availability
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

Analyst-1

Nykaa
Gurugram
10.2023 - Current

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
  • Google data Studio, Tableau
  • BigQuery, Redshift
  • MYSQL, Dbeaver, MongoDB,
  • Google Analytics
  • 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

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Analyst-1

Nykaa
10.2023 - Current

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