Summary
Overview
Work History
Education
Skills
Timeline
Generic

AMAN BAJAJ

Gurugram

Summary

As a Business Intelligence Analyst with 9 years of full time experience, I've partnered with different stakeholders on building end to end business reporting for their teams and products.

Overview

9
9
years of professional experience

Work History

Business Intelligence Analyst

C2FO
06.2021 - Current
  • Leading Business Intelligence: Leading the India BI team to create business critical reports that provides data driven decision making to enable revenue generating activities.
  • Data Governance: Responsible for data governance activity across organization to standardize the understanding of common KPIs and their definitions along with the critical processes that generate the data flows.
  • Product Analysis: Providing support to Product and Technology teams to enable the reporting of their weekly/monthly/quarterly business review meetings.
  • Data Modelling: Creating data pipelines to enable performance monitoring of new products and features to understand business impact in terms of dollar value.
  • A/B Testing: Setting up A/B tests to evaluate the performance of new feature launches in terms user behavior or conversion rates.


Team Lead (Growth Team)

Paytm Mall
06.2020 - 06.2021
  • Consumers Growth: Leading the team of analysts and merchandisers to boost the traffic coming to fashion category (Apparel, Footwear and Fashion Accessories) by running multiple experiments and campaigns on Paytm and Paytm Mall app, and increase the DAU/MAUs.
  • Funnel Optimization: Responsible for driving the overall funnel conversion rate by providing the consumer relevant products and best deals using the data insights
  • Real Time Analysis: To track hourly performance of various discounted sales (Festive season, Payday, Weekend bazar, End of season, Flash Sale) and provide real time insights to category teams to maximize the overall revenue

Business Analyst

OYO Rooms
11.2019 - 06.2020
  • Reporting: Developed Daily/Weekly/Monthly business summary reports to enable property level performance management for United States, Canada, Brazil and Mexico region
  • Market Comparison Analysis: Built multiple web scrapers to fetch property level platform and funnel metrics from Booking.com and Expedia.com to enable property level performance comparison against the competitors in the same region
  • Real Time Alerts: Created multiple triggers/alerts at booking level to minimize revenue loss coming through low pricing of hotels
  • Booking Analysis: Developed Booking window/Cancellation window analysis tools to understand consumer behavior difference among different types of properties.

Operations Analyst

Great Learning
01.2018 - 11.2019
  • Data Governance and Dashboarding: Developed operational metrics derived from raw company data to track improvements in business efficiency in terms of student grades, program completion status, student defer/dropout rate, student feedback, in-class attendance, faculty feedback, faculty occupancy index and batch sentiment analysis
  • Data Warehousing: Developed data pipelines for the sales/marketing/operations department to enable the analytical reporting from associate to executive level.

Data Analyst

HOPE Research Group
11.2016 - 01.2018
  • Brand Health Monitoring: Developed end to end reporting layer for American Beverages (AmBev) to track brand health in Caribbean region
  • Sales Prediction: Developed a prediction model for the sale of a leading FMCG giant based on the product placement and supply chain inventory data in Costa Rica.

Trainee Decision Scientist

Mu Sigma Business Solutions Pvt Ltd
09.2015 - 10.2016
  • Dashboarding: Designed and developed multiple dashboards for a leading technology company tracking customer experience metrics for their search engine

Education

B.Tech - Industrial Engineering and Management

National Institute of Technology
Kurukshetra, Haryana

Skills

  • SSMS / Google Big Query / Amazon Redshift / Hive
  • DBT
  • R /Python
  • Advance Excel
  • Tableau / Power BI / Google Data Studio / Pyramid Analytics
  • Business Analysis and Reporting
  • Statistical Modeling (Regression, Classification and Time Series)
  • Data Warehousing / Data Modeling / Database Management
  • Data Visualization and Insights
  • ETL / ELT

Timeline

Business Intelligence Analyst

C2FO
06.2021 - Current

Team Lead (Growth Team)

Paytm Mall
06.2020 - 06.2021

Business Analyst

OYO Rooms
11.2019 - 06.2020

Operations Analyst

Great Learning
01.2018 - 11.2019

Data Analyst

HOPE Research Group
11.2016 - 01.2018

Trainee Decision Scientist

Mu Sigma Business Solutions Pvt Ltd
09.2015 - 10.2016

B.Tech - Industrial Engineering and Management

National Institute of Technology

Similar Profiles

CREATE PROFILE
AMAN BAJAJ