Summary
Overview
Work History
Education
Skills
Certification
Address
Projects
Chess , Football , Table Tennis
Timeline
Generic
Pranav Vishwakarma

Pranav Vishwakarma

Business Analyst
Hyderabad

Summary

Experienced Business Analyst with a demonstrated history of working in the Hospitality , Education and Media Entertainment Industries. Skilled in SQL, Tableau, Google Sheets , Excel , Python , Few AWS services with a Great Interest and Capability in Data & Business Analysis, Project Management, Leading Teams. Strong Analytical & Operational Professional with a B-Tech focused in Computer Science and Engineering from JSSATE (Bangalore)

Overview

6
6
years of professional experience
4
4
years of post-secondary education
1
1
Certification

Work History

Business Analyst

Apalya Technologies Pvt Ltd
Noida
10.2020 - Current
  • As an Analytics Lead with almost six years of experience now working in the Media and Entertainment industry, I excel in leveraging data-driven insights to inform strategic decisions, optimize content performance, and drive business growth. My role involves overseeing a team of analysts, collaborating with cross-functional teams, and implementing advanced analytics solutions to maximize the impact of data on key business objectives.
  • Some Key Responsibilities that I'm handling :

- Audience Segmentation and Targeting

- Content Performance Optimization

- End to end Events Designing to Track User Behaviour

- Cross-Functional Collaboration

- Advanced Analytics Implementation

- Reporting and Visualization

- Project Management

- Client Handling

- Team Management

  • Tools and Languages : SQL , Clevertap , Kibana , Google Sheets , Excel , Tableau , Google Analytics , Amplitude , Few AWS Services , Python






Business Analyst

OYO Hotels and Homes
Noida
08.2019 - 10.2020
  • Core Team Member providing Business Insights and Empowering Supply, Operation and Finance Heads to take Data Driven Decisions
  • Created Dynamic and Insightful Dashboards to enhance organizational visibility and efficient decision making
  • Worked simultaneously with different teams and Business Stakeholders translating business needs into actionable insights
  • Drove DSRNs and Churn Prevention of Asset Owners and Business Partners for Entire 13 Hub Cities via Automated Trackers , Churn Bucketing and Collaboration with Ground and Central Teams.
  • Pricing Control- Analyzing Occupancy Trends, Avg Room Rate , REVPAR , Walkin Performance and accordingly setting up best price for properties to nurture Revenue , Occupancy and REVPAR
  • MoM and Dod Reports and Performance Analysis - Created MoM Performance Reports for examining Performance of Supply , Operations and Transformation Verticals , Reviewing them with Heads to Identify Performers and Non Performers and planning accordingly for upcoming months
  • Created a CID ( Check in Denial ) Predictor with ~ 70% accuracy . Independent variables such as Prepaid , Low ARR , Past CID % etc were weighted to predict High Alert CID Cases with the aim of Improving Customer Experience.

Data Analyst

SkillsPro Ventures
Hyderabad
05.2018 - 07.2019
  • Worked as a Data Analyst with a focus on the education industry, bringing 2 years of experience in harnessing data to drive informed decision-making and improve educational outcomes using Data Analysis , Python , SQL , Excel , Google Sheets , Tableau
  • Demonstrated expertise in identifying trends, patterns, and anomalies to guide strategic business decisions and elevate revenue generation


Education

Bachelors in Computer Science and Engineering -

JSSATE - Bengaluru
08.2013 - 07.2017

Skills

Data Analysis

undefined

Certification

Data Analysis and Machine Learning using Python from Dexlab Analytics (Gurgaon)

Address

  • Hyderabad
  • Noida

Projects

Loan Prediction, To automate the Loan Eligibility process based on the Customer Details provided and to identify customer segments those are eligible for loan amount so that potential customers can be specifically targeted, Python, Data Cleaning and Munching, Exploratory Data Analysis was done to understand variables, Statistical Tests to identify important variables Housing Prices, Create a Multiple Regression Model to predict the house prices, which had different house, land and locality features, Python, Data Cleaning and Munching, Weighted the different Independent Variables and Created a Regression Model which using Python to arrive at a Potential Transaction Price for all Future Housing Deals. Post Creation Model was Tuned to Increase the accuracy

Chess , Football , Table Tennis

Playing Chess and Football for almost past 2 decades now with a state level experience in both of them 

Chess GOAT for me : Magnus 

Football GOAT for me : Cristiano Ronaldo  

Timeline

Business Analyst

Apalya Technologies Pvt Ltd
10.2020 - Current

Business Analyst

OYO Hotels and Homes
08.2019 - 10.2020

Data Analyst

SkillsPro Ventures
05.2018 - 07.2019

Bachelors in Computer Science and Engineering -

JSSATE - Bengaluru
08.2013 - 07.2017
Pranav VishwakarmaBusiness Analyst