Garv Bansal

Associate Analyst | Aspiring Product Analyst

Gurugram, IN.

About

Highly analytical and results-driven Associate Analyst with experience in product management, business intelligence, and data analytics. Proven ability to leverage data-driven insights to enhance operational efficiency, optimize product performance, and drive strategic decision-making, as demonstrated by improving user engagement by 25% and reducing operational effort by 60%.

Work

United Airlines

|

Associate Analyst

Gurugram, Haryana, India

→

Summary

Currently enhancing business intelligence capabilities for Global Procurement by developing secure Power BI models with Row-Level Security.

Highlights

Enhanced a Power BI self-service model with Row-Level Security, restricting spend cube visibility by teams to ensure secure and role-based access for Global Procurement operations.

The Future University

|

Product Management Intern

Mohali, Punjab, India

→

Summary

Led product ideation, development, and launch initiatives, creating PRDs and leveraging data analytics to optimize product performance and operational efficiency.

Highlights

Spearheaded the ideation, design, development, testing, and successful launch of multiple products and features, generating 15+ Product Requirement Documents (PRDs) for seamless execution.

Leveraged SQL-driven insights for lead tracking and re-targeting strategies, collaborating cross-functionally to reduce operational effort by 60% and improve efficiency.

Created comprehensive data analysis reports using Mixpanel, SQL, and Excel, boosting user engagement and service performance by up to 25%.

Established quality assurance processes, conducted comprehensive tests, and developed Standard Operating Procedures (SOPs) to enhance efficiency and consistency across product development.

Volunteer

Member of the Implementation Body

|

Pec Acm

Contributed to the implementation and execution of various activities for Pec Acm, a technical student body.

Highlights

Actively participated as a Member of the Implementation Body, supporting various technical and organizational initiatives within the student chapter.

Sub-Head

|

IDEATHON Hackathon

Managed the database and logistical coordination for 150+ participants across 50+ teams for the IDEATHON hackathon.

Highlights

Maintained a comprehensive database for 50+ hackathon teams, ensuring smooth functioning and logistical support for over 150 participants at IDEATHON.

Handled the smooth functioning and event coordination for a hackathon with over 150 participants, demonstrating strong organizational and leadership skills.

Analyst Intern

|

EDLIGHTEN (via Start-up Fair)

Secured an analyst internship at EDLIGHTEN through a competitive Start-up Fair, demonstrating strong analytical potential among peers.

Highlights

Bagged an analyst internship at EDLIGHTEN, competing successfully among 60+ students at a Start-up Fair, showcasing strong problem-solving and presentation skills.

Education

Punjab Engineering College, Chandigarh

Chandigarh, Chandigarh, India
→
B.Tech Engineering Grade: 8.49/10 CGPA

Courses

Strategic Management (A+)

Economics (A+)

Financial Management (A+)

Bhavan Vidyalaya

Panchkula, Haryana, India
→
High School Secondary Education Grade: 12th: 96.4/100, 10th: 94.2/100

Certificates

SQL for Data Science

UC Davis

Fundamentals of Visualization with Tableau

UC Davis

Excel Skills for Business

Macquarie University

Skills

Data Analytics & Business Intelligence

SQL, Tableau, Mixpanel, Excel, Data Analysis, Data Visualization, Business Intelligence, Reporting, Exploratory Data Analysis (EDA).

Programming & Machine Learning

Python, Machine Learning, Random Forest Classifier, MySQL, CRUD Operations.

Product Management & Development

Product Management, Product Development Life Cycle, Product Requirement Documents (PRDs), Quality Assurance (QA), Standard Operating Procedures (SOPs), Ideation, User Engagement, Feature Launch.

Professional & Soft Skills

Collaboration, Communication, Problem Solving, Strategic Thinking, Analytical Thinking, Quick Learner.

Projects

Pizzeria Management System

Summary

Developed a Pizzeria Management System using MySQL to streamline operations for customers, orders, pizzas, deliveries, and inventory.

London Bus System Analysis

Summary

Created a Tableau dashboard for analyzing London bus incidents by borough, route, and season to identify patterns and facilitate real-time actions.

Customer Service Analytics and Automation

Summary

Utilized Python, Pandas, and Matplotlib to conduct Exploratory Data Analysis (EDA) on call center data and build a Machine Learning model for call reason categorization.