Vanshika Sharma
Summary
Results-driven Data Analyst with nearly 3 years of experience in Business Intelligence, Product Analytics, Predictive Modeling, and Data Visualization across Media and E-commerce. Currently embedded with the Product team at HT Digital Streams (Hindustan Times), where ~85% of work involves partnering directly with Product Managers — analyzing experiment performance, gathering analytic requirements, and delivering insights that shape new initiatives on livemint.com. Proficient in SQL, Python, BigQuery, Looker, GA4, and Power BI, with a track record of driving data-informed product decisions that improve user engagement and retention.
Overview
3
3
years of professional experience
Work History
Data Analyst
HT Digital Streams
06.2024 - Current
- Embedded with the Product team (~85% of workload), partnering directly with Product Managers to analyze experiment and feature performance on livemint.com and surface insights that informed go/no-go decisions on new initiatives.
- Delivered timely, in-depth user behavior insights that directly supported product engagement goals, contributing to a 20–25% increase in engagement and stronger user retention.
- Built and automated analytical dashboards (SQL, Looker, Python, BigQuery) giving product, editorial, and SEO stakeholders self-serve access to reporting, improving turnaround time and visibility.
- Drove end-to-end delivery of 15+ analytics projects — from requirement gathering through data wrangling, automation, and stakeholder validation.
Data Analyst
STRAUSS Sports
06.2023 - 03.2024
- Conducted data-driven market analysis across major e-commerce platforms to identify demand patterns, contributing to a 15–20% increase in demand for newly launched product lines.
- Performed A/B testing and exploratory data analysis to optimize underperforming products, resulting in a 5% sales uplift.
- Built structured Power BI dashboards and reports to monitor inventory and sales performance, helping business teams track productivity and drive a 10% revenue increase across low-turnover products.
Education
M.com - Accounting
Delhi University
01-2020
B.com - Accounting
Delhi University
01-2023
Skills
- SQL
- Excel
- Google Analytics 4
- Python
- Power Bi
- Tableau
- Looker
- Numpy
- Pandas
- Hypothesis testing
- BigQuery
- Product Analysis
- Marketing Analysis
- Agile
- A/B Testing
- Predictive Modeling
- Time Series Forecasting
- Product Analytics
- Dashboarding
- Data Wrangling
- Data Automation
- Business Intelligence
- Statistical Analysis
- E-Commerce
- Media
Accomplishments
- Received the "Data Master of the Quarter" award for proactive ad hoc analysis that surfaced actionable user insights, driving a 25% increase in website engagement and reinforcing data-led decision-making across the product team.
Projects
Time Series Forecasting (AdEase) | Jan 2025
github.com/Vanshika2506/AdEase-Time_series
- Built and compared ARIMA, SARIMAX, and Prophet models for time series forecasting, with SARIMAX achieving the best performance (MAPE = 4.6%, RMSE = 291) by incorporating seasonality and exogenous variables.
- Reduced prediction error by over 50% compared to ARIMA (MAPE improved from 9% to 4.6%), delivering forecasting insights that enabled more reliable, data-driven business decisions.
Hypothesis Testing & Insights (Yulu) | Oct 2023
github.com/Vanshika2506/Yulu
- Conducted t-test, ANOVA, and Chi-square tests to analyze demand drivers, identifying that weather conditions and day type significantly influence bike usage, with 20% higher demand on weekends.
- Delivered data-driven recommendations for weekend promotions and expanded services, projecting a potential 25% rise in weekend usage based on the analysis.
Timeline
Data Analyst
HT Digital Streams
06.2024 - Current
Data Analyst
STRAUSS Sports
06.2023 - 03.2024
M.com - Accounting
Delhi University
B.com - Accounting
Delhi University