Awesh Kumar
Gurgaon,HR
Summary
Business analyst, with hands on experience in interpreting and analyzing data in order to derive successful business solutions. Well equipped with good understanding of business operations and analytics having prior experience in e-commerce, hospitality, finance and automobile Industry.
Overview
9
9
years of professional experience
Work History
Business Analyst
OYO Hotels & Homes Pvt. Ltd.
12.2023 - Current
- Collaborated with cross-functional teams to gather and define business requirements for various projects.
- Conducted detailed gap analysis to identify inefficiencies in current processes, leading to improvement in operational efficiency.
- Facilitated communication between stakeholders and developers to ensure alignment of project goals and technical specifications.
- Documented business processes and requirements
- Assisted in prioritizing project tasks, managing scope, and mitigating risks in agile sprint planning.
- Analyzed large datasets from various sources (e.g., databases) using SQL, resulting in data-driven recommendations that improved specific business outcome.
- Designed and maintained interactive dashboards in Tableau/Advance Excel, allowing different stakeholders to monitor bookings, GVB, Traffic conversion etc. and make informed decisions.
Assistant Manager
Cars24 Service Pvt. Ltd.
02.2022 - Current
- Extracting data from snowflake (SQL) to create various insights of refurb process of cars (from PI to PDI)
- Using the snowflake extracting the data and created various dashboards of vehicle refurb cycle on looker studio
- Automating the process with the help of basic python, SQL and google app script
- Created output matrix dashboard to track vehicle's spares number for central team
- Created Week on Week, Month till date and Yearly automated performance matrices for entire team to track numbers on daily basis
- Maintained entire spares data for all 7 cities MRL's (Mega Refurbishment Labs) and captured their progress by automated timestamp using app scripts
- Moved city wise bulk data from central source G-sheets using app scripts and created data for daily discussion with vendors
- Created different dashboards to track live spares performance using Tableau
Team Lead
Cars24 Services Pvt. Ltd.
05.2021 - 01.2022
- Provided visibility on automated dashboard for post disbursal check points, to avoid loan terms mismatch in partner
- Set up process with automated google sheets for capture of EMI collection for partner loan
- Automated process to analyze and improve partner approval rate and identified major drop off reasons to suggest policy changes
- Identified the process gaps from approval to disbursal stage thereby reducing from 14 days to 10 days by analyzing data and created automated reports on G-sheets
- Created Live dashboards to track listing of vehicles on website
- Created automated reports and dashboards to track listing performance matrix, and help in analyzing different data items which helps in increasing listing count
Senior Executive
OYO Rooms
03.2019 - 04.2021
- Extract and analysis results of hotel data from Big Query/Tableau
- Coordinated statistical data analysis, design, and information flow
- Give Visibility & analysis of new listed properties and their life cycle
- Prepare automated dashboards of quality check of properties live on different OTA's
- Analyzed content sync issues & raise it to tech team to sync with API
- Provide strategies to accomplish the 100% accuracy while listing of properties on different OTA's
- Corrected any data entry error to prevent later issues such as duplication or data degradation
- Developed database objects, including tables, views and materialized views using SQL
- Documented business workflows for stakeholder review
Senior Associate
Paytm Mall
08.2015 - 02.2019
- Used statistical methods to analyze data & generate insightful reports for apparels and accessories categories
- Extract data using Hive for attribute fill rates & increased it to 90% from 65%
- Managed master database in Hive which includes creation, updating and deletion of various catalogs
- Performed and interpreted data studies using advance excel and raised the product requirements for increasing the category conversions
- Identification of top selling product lines and SKU's based on customer search patterns and product attributes
- Launched School Uniforms category by doing a competitive analysis of various marketplaces
- Data cleaning, standardization comprising of duplicates, anomalies and garbage sanitization
- Coordinated with various stakeholders to outline the specific catalog needs for business analysis
Education
B.Tech - Computer Science
Lovely Professional University
Jalandhar, Punjab07.2015
Diploma - Computer Science
Lovely Professional University
Jalandhar, Punjab06.2012
CBSE Board -
Kendriya Vidyalaya No.1
Shahjahanpur, U.P.03.2008
Skills
- SQL
- Tableau
- Advanced Excel
- Google Sheets Reporting
- MS Excel
- G Suite
- Strategic Planning
- MS Excel Application
- MIS Reporting
- Team Management
- Data Analysis
- Process Automation
- Research Skills
Websites
Accomplishments
- Promoted as Assistant Manager, Cars24 Services Pvt. Ltd.
- Best Employee for consecutive 3 quarters, OYO Rooms
- Best employee award with title 'Never Say No', Paytm Mall
- 'ROCKSTART' for best performance in team, Paytm Mall
- Represented school at District level in 'National Science Olympiad'
Timeline
Business Analyst
OYO Hotels & Homes Pvt. Ltd.
12.2023 - Current
Assistant Manager
Cars24 Service Pvt. Ltd.
02.2022 - Current
Team Lead
Cars24 Services Pvt. Ltd.
05.2021 - 01.2022
Senior Executive
OYO Rooms
03.2019 - 04.2021
Senior Associate
Paytm Mall
08.2015 - 02.2019
Diploma - Computer Science
Lovely Professional University
CBSE Board -
Kendriya Vidyalaya No.1
B.Tech - Computer Science
Lovely Professional University
Similar Profiles
RAHUL SHRIVASTAVARAHUL SHRIVASTAVA
Demand Manager at OYO Hotels & Homes PVT LTDDemand Manager at OYO Hotels & Homes PVT LTD
KUMAR JAIKUMAR JAI
Sales Manager - Corporate Sales at OYO Hotels & Homes Pvt Ltd.Sales Manager - Corporate Sales at OYO Hotels & Homes Pvt Ltd.
Surender SinghSurender Singh
Category Head at oyo hotels & homes pvt ltdCategory Head at oyo hotels & homes pvt ltd