Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sanyam Kapoor

Noida

Summary

Experienced Business Analyst with 6+ yrs experience in Python, SQL, SAS, R and visualization software, having graduated from NIT Jalandhar (Computer Science) in 2018. Always looking for new opportunities to learn and take career forward.

Overview

6
6
years of professional experience

Work History

Module Lead - Data Analytics

BOLD
07.2021 - Current
  • At BOLD, I am an integral part of the Business Intelligence team, where we specialize in delivering data-driven analytical solutions to address the business's challenges
  • A significant portion of my work involves writing complex SQL queries to extract and manipulate data from databases such as Snowflake, Microsoft SQL Server, enabling me to offer comprehensive insights and summaries
  • Forecasted expected traffic, registrations, and subscription volume at an hourly level using time series analysis to create a data model that sends hourly alerts to stakeholders, highlighting potential issues early.
  • Developed a logistic regression model to identify high-probability users who are likely to resubscribe when targeted with re-engagement email campaigns.
  • Conducting thorough funnel analysis, I identified areas for improvement at both the top and bottom of the sales funnel for portals experiencing lower conversion rates.
  • I also conducted various analyses to comprehend customer behavior patterns following subscription cancellations and subsequent returns to our services.
  • I have leveraged my expertise in Python to develop custom-built tools that empower stakeholders to generate reports and access analyses for multiple AB tests
  • Additionally, I examined the cost-effectiveness and revenue implications of customer care center operations, providing insights to guide decision-making
  • Furthermore, I have provided support to the Data Engineering team by building end-to-end ETL pipelines for Google Search Console, Bing Ads and Google Ads.

Business Analyst

OYO
03.2021 - 07.2021
  • Worked as the lead analyst of Central Revenue Team for OYO's India business
  • My role involved developing R/Python codes and SQL queries for preparation of key revenue deliverables like daily/monthly reports that track key business metrics on different levels, Budgeted vs Actual performance analysis, City, product, channel level financial and business analysis, Trending forecasts, AOP etc
  • Worked with different departments within the organization (Finance, Pricing, Conversion, Operations, Marketing) to understand their key reporting requirements, and suggesting best ways to present data for everyday tracking and business performance reporting
  • Created impact trackers for various sale campaigns that were launched and helped track the sale impact across cities and properties.

Consultant I

EXL
07.2018 - 03.2021
  • Worked with one of the biggest utilities provider in United Kingdom
  • Was part of the Settlements & Imbalance Team that took care of the settlements side of the client company with Industry
  • My role heavily involved building process improvement tools, models & periodic reports in SAS, SQL Server, Python and performance dashboards using PowerBI
  • Worked on analysis of operations side of business to identify the fallouts and business areas which needed improvement in terms of tasks handling performance
  • Built forecasting models in Python which helped forecast the volume of tasks to be handled by various business areas and hence forecasting the number of FTEs required to handle the volume
  • Diminished process gaps and exercised critical thinking by closely supervising the Business As Usual activities to ensure optimal productivity.

Education

Bachelor of Technology (B.Tech.) in Computer Science -

Dr B R Ambedkar National Institute of Technology
Jalandhar, India
06.2018

Skills

  • Python
  • SQL
  • Business Analytics
  • Complex Problem Solving
  • Google Sheets
  • Data Modelling
  • Descriptive Analytics
  • Predictive Analytics

Timeline

Module Lead - Data Analytics

BOLD
07.2021 - Current

Business Analyst

OYO
03.2021 - 07.2021

Consultant I

EXL
07.2018 - 03.2021

Bachelor of Technology (B.Tech.) in Computer Science -

Dr B R Ambedkar National Institute of Technology

Similar Profiles

CREATE PROFILE
Sanyam Kapoor