Summary
Overview
Work History
Education
Skills
Timeline
Generic
RAJEEV UPADHYAY

RAJEEV UPADHYAY

Senior Data Analyst (XE AI&Data)
Pune

Summary

Results-driven analytics professional with a proven track record of leveraging data-driven insights to optimize business strategies and drive informed decision-making. Proficient in Python, R, SQL, statistical analysis, and Tableau. Experienced in requirements gathering, stakeholder management, user story development, and utilizing service desk and JIRA for task tracking. Skilled in designing and implementing sophisticated data models and visualizations. Successfully identified key performance indicators (KPIs) in finance analytics and sales operations analytics use cases, developing comprehensive dashboards and reports that provide real-time insights into business performance. Seeking a challenging analytics role to utilize skills and experience in a dynamic and fast-paced environment. Also experienced in cloud-based data storage in Redshift, AWS services, and data querying.

Overview

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

Work History

Senior Data Analyst

Redhat
05.2024 - Current
  • Led data analysis and measurement of AI success on XE AI & Data team at X company
  • Identified gaps in data crucial to AI solutions through thorough data analysis
  • Integrated Salesforce, API's, pendo, splunk, and other data sources for comprehensive measurement
  • Successfully achieved $4 million in cost savings towards $5 million target by end of 2024
  • Implemented strong data governance and data quality practices to ensure high-quality data for customer experience at Redhat
  • Developed Tableau dashboards and utilized Python for data cleaning, ETL tasks, and complex SQL queries to solve business problems
  • Played a key role in data migration from legacy systems to modern data warehouse for improved efficiency and accuracy.

Senior BI Engineer

SolarWinds
11.2023 - 05.2024
  • Channel Sales Operations: Data collection from different platforms such as NetSuite and SFDC to integrate bookings, ARR, Pipeline metrics with different stages of sales
  • End goal is to improve sales performance via channel rather than direct sales
  • Analyzing YOY, QTD performance and present the insights to stakeholders to focus on areas of improvement, tracking KPI's that can help the business to take right decisions
  • Using Tableau, SSIS, SQL, Python as a tool to do data analysis and help improve channel sales leaders to take right action
  • Day to day activity involves requirement gathering sessions with stakeholders to elicit and document business needs, ensuring alignment with project objectives and constraints
  • Conducting gap analysis to identify areas for process improvement, recommending solutions to streamline workflows and optimize resource utilization

Sr. Process System Engineer

HERE solutions
06.2023 - 10.2023
  • Unified Modeling Task Project: Data collection from our central operations analytics data sources, doing data wrangling through python and finding KPI'S for operations leader
  • Tableau dashboarding to bring out insights on our key task mapping related data for high priority and low priority task
  • Used SQL queries to create view for storing the snapshot of last week data only and then comparing the numbers from the present data
  • AWS services like Athena and S3 was used for data pipeline creation

Business Intelligence Engineer

Red hat India Pvt Ltd
02.2021 - 06.2023
  • Statistical Bookings Forecast Project: Tableau dashboarding to show the key parameters in the dashboard including forecast numbers, Actuals numbers, historical data and Manager's judgment number in the dashboard
  • Also, to show the Comparison between all and accuracy between forecast numbers and the actuals
  • Using SQL for the query to join 3 dataset including Row level security
  • Used Time-series forecasting models to predict the Bookings numbers for rolling 4 quarters and compared this with targets for the quarter as well as Manger's judgement number for the quarter
  • Used diagnostics to assess the predictors for forecasting the bookings numbers Purpose was to create cross functional alignment to quantitative forecast, provide insights on key levers to drive specific outcomes in the business and accurately measure historical performance
  • Tools used: Python, SQL, Tableau, Time-series forecasting, sales-ops analytics
  • Customer analytics dashboard: This dashboard is mainly used by sales team for the trends and numbers of ARR and revenue
  • Tableau dashboarding to build KPI's that targets customers of our organization
  • Key metrics included: Pipeline conversion rate, Revenue density, Customer cohort, customer segmentation like new customers, existing customers, lost etc
  • Tools used: Python, SQL, Tableau, finance and sales ops-analytics
  • Measuring customer success using feedback from customer, Determining NPS scores, sentiment analysis of customer using NLP

System Engineer

Infosys Limited
05.2018 - 02.2021
  • Predicting and descriptive analytics for new use cases using different attribute/ML modelling
  • Gathering data from different sources using selenium scrapping and other techniques
  • Reports generation using data visualization concept (tableau/R/python)
  • Media domain knowledge, data science concepts
  • Data Cleaning and Exploratory data analysis in python, Modelling techniques, statistical analysis for checking hidden patterns in the data

Analyst

eClerx Services Limited
04.2017 - 05.2018
  • This project deals with Data reconciliation of US & Non-US Option of derivative market data using SQL and Excel
  • It required knowledge of Options, Futures, Loans, Trade Life Cycle, I-match funding reconciling daily reporting
  • Skills Required: Data Reconciliation, Advanced excel, database knowledge using SQL

Education

AMPBA - Advanced Management Program in Business Analytics

Indian School of Business
01.2020 - 04.2022

Bachelor of Engineering - undefined

D.Y. PATIL COLLEGE OF ENGINEERING
Akurdi, Pune
01.2012 - 04.2016

Skills

Python

Timeline

Senior Data Analyst

Redhat
05.2024 - Current

Senior BI Engineer

SolarWinds
11.2023 - 05.2024

Sr. Process System Engineer

HERE solutions
06.2023 - 10.2023

Business Intelligence Engineer

Red hat India Pvt Ltd
02.2021 - 06.2023

AMPBA - Advanced Management Program in Business Analytics

Indian School of Business
01.2020 - 04.2022

System Engineer

Infosys Limited
05.2018 - 02.2021

Analyst

eClerx Services Limited
04.2017 - 05.2018

Bachelor of Engineering - undefined

D.Y. PATIL COLLEGE OF ENGINEERING
01.2012 - 04.2016

Similar Profiles

CREATE PROFILE
RAJEEV UPADHYAYSenior Data Analyst (XE AI&Data)