Summary
Overview
Work History
Education
Skills
Accomplishments
References
Timeline
Generic

Prateek Shekhar

Data Analyst | Data Scientist | Digital Marketing
Bengaluru

Summary

Experienced Digital Analytics Specialist at Epsilon India with a proven track record in delivering actionable insights and optimizing digital performance across US, APAC, and EMEA markets for industries such as Healthcare, BFSI, e-Commerce, and Gaming. Skilled in Google Analytics 4, Adobe Analytics, and Google Tag Manager, with advanced expertise in exporting raw data to BigQuery for impactful reporting and visualization. Proficient in data analysis, query optimization, and data transformation, creating efficient, insightful dashboards in Tableau, Power BI, and Looker Studio. Strong command of SQL, Python, and JavaScript for data manipulation and automation to boost workflow efficiency and reporting precision. Adept in conversion optimization using Adobe Target, VWO, and Google Optimize, with a robust foundation in SEO, UI/UX, and business analytics. Renowned for strategic account management and effectively translating complex data insights into impactful client solutions.

Overview

8
8
years of professional experience
5
5
years of post-secondary education

Work History

Senior Data Scientist / Senior Web Analyst

Epsilon
Bengaluru
06.2021 - Current
  • Proven expertise in Digital Analytics, Account Management, and Business Analytics at Epsilon India, with a strong foundation in Web Analytics and Digital Marketing.
  • Proficient in Data Analysis and SQL with extensive use of Google BigQuery, PostgreSQL, and Relational Databases for data-driven insights.
  • Highly skilled in exporting raw Google Analytics 4 data to BigQuery for insightful reporting:
  • Query Optimization Techniques: Utilizes efficient indexing and partitioning to streamline data retrieval, reducing query execution time.
  • Leverages cost-effective query planning and BigQuery’s caching mechanisms to handle high data volumes without compromising speed.
  • Implements parameterized queries and JOIN optimization for seamless data blending and in-depth analysis across multiple datasets.
  • Data Transformation Strategies: Skilled in using BigQuery SQL functions for data cleansing, aggregation, and categorization to prepare raw GA4 data for reporting.
    Applies ETL (Extract, Transform, Load) best practices to shape raw data into custom structures, enabling easier analysis and visualization.
  • Builds advanced calculated fields to create dynamic KPIs, ensuring reports highlight actionable trends and key performance metrics.
  • Actionable Insights & Dynamic Reporting: Designs real-time dashboards with drill-down capabilities for interactive data exploration, tailored to client-specific goals.
  • Proficient in Google Tag Manager for tracking setup and tag implementation, enabling seamless data collection and enhanced measurement capabilities within Google Analytics 4 and Adobe Analytics environments.
  • Incorporates data segmentation and cohort analysis to reveal behavior patterns, informing strategic decision-making.
  • Creates automated reports with scheduled updates, ensuring stakeholders have timely access to evolving insights.
  • Skilled in Google Analytics (including GA4), Adobe Analytics, Omniture, Google Tag Manager, and Google Search Console for in-depth web analytics and tracking.
  • Experienced in Conversion Optimization with tools such as Adobe Target, VWO, and Google Optimize.
  • Advanced Data Visualization and Performance Dashboard capabilities using Tableau, Microsoft Power BI, and Looker Studio.
  • Proficient in Python and JavaScript for data processing and automation, enhancing analytics workflows.
  • Strong background in Statistics, Marketing Strategy, SEO, UI/UX, and Conversion Optimization to improve digital performance and customer engagement.
  • Skilled in Microsoft Excel, PowerPoint, and Datorama for effective data management, analysis, and presentations.

Lead Strategist - CRO

iQuanti India Pvt. Ltd.
Bengaluru
10.2019 - 05.2021
  • Successfully lead and managed multiple accounts, responsible for analyzing user behavior & understanding target audience though research & user testing, prioritizing recommendations in terms of implementation effort, AB test duration & overall impact
  • Delivered significant improvement in lead quality through personalized content strategy for one of the leading Reverse Mortgage providers in the Canadian region
  • Lead a 4-month CRO program for one of the top Canadian Banks, carried ethnographic research across 100+ BFSI organizations, successfully drew insights after analyzing behavioral data through platforms such as - Adobe Analytics, IBM Acoustic, Hotjar, Mouseflow & Google Analytics, Facebook Analytics etc
  • Extremely proficient in tools such as VWO, Optimizely, Google Optimize & Adobe Target
  • 4.5+ years of experience in client facing role, efficient at building & nurturing client relationships with the leadership group

Product Manager

Gambit Sports
Bengaluru
04.2019 - 10.2019
  • Learning fundamentals and design approaches in gaming domain for mobile devices
  • Implementing octalysis theory for improving the game experience
  • Managing a group of designers for various feature implementations
  • Contributing in strategies for improving the core flows in the product (mobile gaming app)

Product Manager

ConvertCart
Bengaluru
02.2018 - 01.2019
  • Experienced in defining online eCommerce Revenue Optimizing digital products such as Site Search Engine, Product Review Platform (Onsite and Offsite), ESP (Email Service Provider) etc in a product company
  • Experienced in owning the product development, testing and improvement fronts and liaising with different teams to achieve organizational goals
  • Defined product feature road map and timelines by performing qualitative and quantitative analysis
  • Define processes for continuous monitoring, implementation and improvement of multiple products
  • Handling client escalations regarding various product implementations on eCommerce Websites, interfacing with the clients directly and solving client queries along with measuring the rate of client escalations to bring it down
  • Performing Risk Analysis and Measuring its rate on a continuous basis, recommending measures to reduce it
  • Managed a team of more than fifteen members, working with several other teams in different fronts
  • Closely observed different dynamics of client handling according to different client personas and maintained a healthy working environment among highly driven problem solvers and thinkers

Key Account Manager/Client Success Manager

ConvertCart
Bengaluru
10.2017 - 01.2018
  • Strong understanding of eCommerce industry from various domains such as health & supplements, apparels, hospitality, travel and booking, electronics, gaming etc
  • Enhancing revenue of industries through online eCommerce Websites
  • Analyzing user behavior on the eCommerce websites to gather a deep understanding of user requirements
  • Evaluating website analytics data to identify problem areas/opportunity
  • Creating & implementing strategies for eCommerce websites across different business domains to improve eCommerce conversion rates
  • Implementing conversion optimizing campaigns on eCommerce websites improving website sales and in turn revenue
  • Crafting hypothesis for A/B testing and website improvement recommendations based on qualitative insights and quantitative data
  • Experienced in identifying, recommending and improving UI/UX aspects of eCommerce Websites
  • Interacting with internal teams for developing and testing of solutions and owning the implementation front
  • Creating traffic and revenue reports and liaising with US/UK clients on a weekly basis to build a healthy relationship
  • Setting up client goals, creating road maps on achieving the goals and successfully presenting the outcome to the clients

Junior Business Analyst

Tech Active Solutions
Bengaluru
09.2016 - 09.2017
  • Gathered client Requirements and presenting those to the internal teams
  • Worked closely with developers and designers, ensuring each requirements is met with the finest of details required for the task
  • Experienced in creating large scale wire framing projects visualizing entire scope of the projects and assisting the UI/UX designers
  • Experienced in estimating project timelines and cost analysis
  • Experienced in successfully liaising with British clients on a week on week basis
  • Experienced in performing user acceptance testing at the end of project completion
  • Gained experience with project management and show cased those skills in couple of major UK eCommerce projects

Education

Bachelor of Engineering - Computer Science

Vishveshwarya technological university
07.2012 - 07.2016

Major in Computer Science - undefined

Kendriya Vidyalaya Hebbal
01.2011 - 03.2012

Skills

  • Google BigQuery

  • Data Analysis

  • SQL

  • Account Management

  • Google Analytics

  • Google Analytics 4

  • Adobe Analytics

  • Web Analytics

  • Adobe Target

  • Data Visualization

  • Tableau

  • Data Analytics

  • Digital Marketing

  • Python (Programming Language)

  • Performance Dashboards

  • Statistics

  • VWO

  • Omniture

  • Google Search Console

  • Microsoft PowerPoint

  • PostgreSQL

  • Conversion Optimization

  • Google Optimize

  • UI/UX

  • Business Analytics

  • Presentations

  • Marketing Strategy

  • Search Engine Optimization (SEO)

  • Microsoft Power BI

  • Microsoft Excel

  • Relational Databases

  • Looker Studio

  • Datorama

  • JavaScript

  • Google Tag Manager

Accomplishments

  • Nominated for Epsilon's Magnitude Award 2023
  • Won iQuanti Gem Award - 2021

References

  • Khushalie Nagpal, Epsilon, Manager - Prateek is a pleasure to work with! We have been working together for over 2 years now, he is through with his thought process, always ready to learn and accept any and every new challenge! A great team player, an amazing colleague. Off lately, his contribution to the project on Big query for GA4 has been commendable!!! It’s great to be working with you!! Looking forward to many more!!
  • Vigya Choudhary, Epsilon, Lead Data Scientist - I have had the pleasure of knowing Prateek for almost two years now, during which time I have witnessed firsthand his exceptional skills and qualities. Prateek is a standout professional with a strong command of SQL and BigQuery, showcasing his analytical prowess and problem-solving abilities.

    In addition to his technical expertise, Prateek is well-versed in Google Analytics, consistently leveraging this to deliver valuable insights and drive data-informed decisions. His proficiency in these areas has significantly contributed to the success of numerous projects.

    One of Prateek's standout qualities is his exceptional presentation skills. He has a unique talent for distilling complex concepts into clear, concise presentations that resonate with both technical and non-technical audiences alike. Whether it's delivering insights from data analysis or pitching strategic recommendations, Prateek consistently captivates and engages listeners with his articulate delivery and compelling visuals.

    However, what truly sets Prateek apart is his remarkable leadership skills. Whether leading a task/project or collaborating with colleagues, Prateek demonstrates exceptional leadership qualities, inspiring others to perform at their best and fostering a collaborative work environment.

    I wholeheartedly recommend Prateek for any opportunity where dedication, skills, and leadership are valued. His passion for excellence and commitment to delivering results make him an invaluable asset to any team.
  • Justin Lee, iQuanti Pvt. Ltd., Account Manager - Prateek is one of the smartest digital marketers I've worked with. He's someone you can rely on as a teammate - I've worked with him on two different US and Canadian clients that required various complex skillsets in SEO and CRO and it has been always a pleasure working with him. Words to describe him: diligent, detail-oriented, and results-focused. I would highly recommend Prateek as he would be a valuable asset to any team.

Timeline

Senior Data Scientist / Senior Web Analyst

Epsilon
06.2021 - Current

Lead Strategist - CRO

iQuanti India Pvt. Ltd.
10.2019 - 05.2021

Product Manager

Gambit Sports
04.2019 - 10.2019

Product Manager

ConvertCart
02.2018 - 01.2019

Key Account Manager/Client Success Manager

ConvertCart
10.2017 - 01.2018

Junior Business Analyst

Tech Active Solutions
09.2016 - 09.2017

Bachelor of Engineering - Computer Science

Vishveshwarya technological university
07.2012 - 07.2016

Major in Computer Science - undefined

Kendriya Vidyalaya Hebbal
01.2011 - 03.2012
Prateek ShekharData Analyst | Data Scientist | Digital Marketing