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

Pec Acm
|

Member of the Implementation Body

Chandigarh, Chandigarh, India

Summary

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.

IDEATHON Hackathon
|

Sub-Head

Chandigarh, Chandigarh, India

Summary

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.

EDLIGHTEN (via Start-up Fair)
|

Analyst Intern

Mohali, Punjab, India

Summary

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

Issued By

UC Davis

Fundamentals of Visualization with Tableau

Issued By

UC Davis

Excel Skills for Business

Issued By

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.