SHIVAM VARSHNEY
San Jose,CA
Summary
Driven Senior Data Consultant with 8 years of proven expertise in breaking down complex business problems into data-driven solutions. Proficient in leveraging data to provide innovative solutions to business problems in a fast-paced environment. Possessing adeptness across diverse statistical methodologies, tools, and programming languages.
Overview
8
8
years of professional experience
Work History
Senior Data Consultant
Tiger Analytics
San Jose, CA
05.2024 - Current
- Collaborating with cross-functional teams to establish a data foundation layer and dashboard providing a comprehensive view of KPIs for paid search campaigns across major Pet Nutrition retailers in North America. This enables users to track, analyze, and optimize campaign effectiveness, comparing performance metrics such as impressions, clicks, click-through rate (CTR), cost per click (CPC), conversion rate, and return on ad spend (ROAS) across retailers.
Senior Data Consultant
Tiger Analytics
Toronto, Ontario
01.2023 - 05.2024
- Led a cross-functional team to develop a unified demand retail data model for a Pet Nutrition client in North America, integrating data from 30+ sources across 8 retailers. Created a centralized, clean data product with KPIs to address business queries. Ensured structured and harmonized data served as the authoritative source of truth for all retailers. Enabled cross-retailer insights, enhanced decision-making processes, and established a robust governance process for effective data management.
- Collaborated with a team of data engineers, BI developers, and consultants to develop a holistic portfolio management solution. As part of this effort, we delivered a portfolio health dashboard to assess RAT SKUs using PQA analysis based on SKU performance (MAC). This entailed gathering business requirements, understanding data, storytelling, and stakeholder management.
- Provided support and leadership to the team in developing demand transference models across various global regions. These models aimed to identify alternative products to replace delisted SKUs and ensure adequate coverage.
Assistant Manager Data Science
Genpact
Bengaluru, INDIA
01.2021 - 12.2022
- Led a three-person team to develop predictive models for financial planning and analysis using a blend of statistical and machine learning forecasting techniques. These models offered more insightful earnings guidance to executive and investor teams.
- Automated the generation of complex reports using web scraping techniques in Python, which serve as a feed for various dashboards. These dashboards aid the Group Purchasing Organization in negotiating discounts with manufacturers, distributors, and other vendors for healthcare organizations, resulting in productivity benefits of approx 600 hours annually.
Senior Data Analyst
Tiger Analytics
Chennai
04.2019 - 12.2020
- Developed Market Mix models using Bayesian, utilizing Mixed Effect Modeling algorithm to optimize ROI across marketing channels. Analyzed national and market-level variables extensively, conducting EDA through univariate and multivariate analysis.
- Built models for preventive maintenance that can be scaled to thousands of pieces of equipment in the steel manufacturing process for machine anomaly detection and parameter forecasting (e.g., vibration, temperature, pressure, etc.).
- Optimized the route to market for the retail client. Built linear models and conducted hypothesis testing to identify the ROI from Merchandiser visits. Conducted store group analysis to determine the optimal visit frequency to stores. Developed ETL pipelines in Azure to automate the data refresh process in dashboards.
Programmer Analyst
Cognizant Technologies Solutions
Kolkata
06.2016 - 03.2019
- Developed CLTV calculation modules for an insurance company. Conducted uni-variate and multivariate analysis on market-level attributes for various insurance products. Identified key prospects using regression modeling algorithms to reduce mail expenses.
- Predicted lead conversion rates and devised marketing strategies for diverse life insurance products. Conducted data sanity checks and exploratory data analysis to eliminate irregularities. Implemented logistic regression to prioritize leads across products.
Education
Bachelor of Engineering Technology - Electrical, Electronics And Communications Engineering
SRM UNIVERSITY
Chennai05.2016
Skills
- Analytical Thinking
- Critical Thinking
- SQL Proficiency
- R Programming
- Python Programming
- Microsoft Office
- Advanced Excel
- Data Cleaning
- Data Analysis
- Data Modeling
- Data Storytelling
- Machine Learning
- Time-series analysis
- Gap analysis
- A/B Testing
- Statistical Analysis
- Azure Data Factory
- Azure Databricks
- Power BI Experience
Hobbies and Interests
- Biking
- Travelling
Timeline
Senior Data Consultant
Tiger Analytics
05.2024 - Current
Senior Data Consultant
Tiger Analytics
01.2023 - 05.2024
Assistant Manager Data Science
Genpact
01.2021 - 12.2022
Senior Data Analyst
Tiger Analytics
04.2019 - 12.2020
Programmer Analyst
Cognizant Technologies Solutions
06.2016 - 03.2019
Bachelor of Engineering Technology - Electrical, Electronics And Communications Engineering
SRM UNIVERSITY
Similar Profiles
LAKSHMI SRAVANI RENDUCHINTALALAKSHMI SRAVANI RENDUCHINTALA
Senior Analyst at Tiger AnalyticsSenior Analyst at Tiger Analytics
Arun WadeyarArun Wadeyar
Senior Data Engineer at Tiger AnalyticsSenior Data Engineer at Tiger Analytics
Akshay BankarAkshay Bankar
Senior Analyst - Data Science at Tiger AnalyticsSenior Analyst - Data Science at Tiger Analytics
Chockalingam BChockalingam B
Machine Learning Engineer at Tiger AnalyticsMachine Learning Engineer at Tiger Analytics
Ajith KattilAjith Kattil
Engineering Leader at Neural LabsEngineering Leader at Neural Labs