Rohan Gupta
Analyst | Business Intelligence & Data-Driven Insights
Ghaziabad
Summary
Process oriented Senior Associate - CX Refunds with 5+ years of experienced in interpreting and analyzing data to drive growth for a e-commerce company. Furnish insights, analytics, and business intelligence needed to guide decisions. Ran a business as a business owner. Partner with various business owner and (SME's).
Overview
8
8
years of professional experience
Work History
Senior Associate - CX Refunds
Urban Company
8 2021 - Current
- Working in Urban Company on Project 'Refunds' as 'Senior Associate'.
- Worked on allocation and execution of missed payments of gig workers using SQL queries.
- Created monthly and quarterly reports for higher management using data visualization techniques.
- Created visual data representations for monthly reports for managers.
- Worked on auditing a large number of data sets to reduce refund cost per booking by 50%, and analyze non-legit and wrongly tagged refunds.
- Defining and documenting functional and nonfunctional requirements and converting them into use cases.
- Collaboration with business partners, users, and team to align on product vision and get things done.
Analyst
Youth Buzz Educom
08.2019 - 07.2021
- I was responsible for analyzing student career counseling data to inform business decisions and drive success in our efforts to support students' career development.
- Created detailed reports and visualizations using tools like Excel and Power BI to present data findings to stakeholders, facilitating informed business decisions.
- Managed multiple projects simultaneously, ensuring timely delivery and alignment with organizational goals while maintaining high-quality standards.
- Developed and monitored key performance indicators (KPIs) to assess business performance and identify areas for improvement.
Owner
Pro-Fit Nutritions
08.2016 - 05.2019
- Co-Founded diet food Cafe in Noida named 'ProFit Nutrition's' shifted it to full-time café name'The Kafeneio'
- Worked on cloud kitchen and counter sale model both
- Collaborated with nutritionist and dieticians to provide handcrafted diet foods to customer
- Analyzing data using statistical techniques and tools such as SQL, & Excel to uncover trends, patterns, & insights
- Communicating data-driven insights & recommendations to relevant stakeholders, including management, teams, and clients
- Developing and maintaining dashboards and reports to provide real-time visibility into key performance metrics.
Education
B.Tech - Mechanical Engineering
DIT School of Engineering
12th - Science Education
Board of Secondary Education Madhya
10th - CBSE Board
Dayawati Modi Public School
Skills
Advanced Excel
MySQL
Power BI
Python
Communication (English & Hindi)
Problem-solving
Critical Thinking
Websites
Accomplishments
- Recognized as Urban Company champion for improving the tagging efficiency of refunds from 68% to 95% and reducing refund cost by 50 percent., 2023
- Training and certification in Data Analysis including Advance excel, MYSQL, Power BI, Python., 2022
- Training and certification in Salesforce Administration and development, 2020
Timeline
Analyst
Youth Buzz Educom
08.2019 - 07.2021
Owner
Pro-Fit Nutritions
08.2016 - 05.2019
Senior Associate - CX Refunds
Urban Company
8 2021 - Current
B.Tech - Mechanical Engineering
DIT School of Engineering
12th - Science Education
Board of Secondary Education Madhya
10th - CBSE Board
Dayawati Modi Public School
Similar Profiles
Mohammed Mahabub PashaMohammed Mahabub Pasha
Plumber at urban companyPlumber at urban company
Chanderhash SinghChanderhash Singh
Category Manager at Urban CompanyCategory Manager at Urban Company
ABISHEK R.SABISHEK R.S
Business Development Associate at Urban CompanyBusiness Development Associate at Urban Company