VANSH KALRA
Melbourne,Victoria
Summary
Aspiring Business Analyst with a strong foundation in SQL, Excel, and data visualization tools. Currently pursuing a Bachelor of Business (Information Systems) at RMIT University, I am eager to apply my analytical and problem-solving skills in a dynamic internship role. Passionate about transforming data into actionable business insights, and optimizing processes.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Woolworths Grocery Team Member
Woolworths
MELBOURNE, VIC
01.2024 - Current
- Managed inventory and ensured accurate stock levels, improving operational efficiency.
- Communicated with team members to enhance workflow and reduce discrepancies.
Education
Bachelor of Business (Major: Information Systems) - Business Information Systems
RMIT University
Melbourne, VIC06-2026
Skills
- SQL: Querying, Joins, Data Manipulation, Subqueries, Aggregate Functions
- Excel: Pivot Tables, VLOOKUP, INDEX-MATCH, Data Cleaning, Dashboards
- Data Visualization: Power BI / Tableau (Basic)
- Business Analysis: Requirement Gathering, Process Mapping, and Documentation (BRDs, Use Cases)
- Programming Basics: Python (Pandas, NumPy)
- Other tools include Google Sheets, Jira, Lucidchart, and Microsoft Office Suite
Certification
- Google Data Analytics Certification
- Microsoft business analyst certification
- AI fundamentals
Projects and coursework
Customer Churn Analysis (Excel)
- Analyzed customer churn data using Excel, identifying key factors leading to customer attrition.
- Built interactive dashboards with pivot tables and charts to visualize trends and retention strategies.
- Provided actionable recommendations to reduce churn and enhance customer satisfaction.
Customer Sales Analysis (SQL & Excel)
- Developed SQL queries to extract and analyze sales data from a retail database.
- Created Excel dashboards showcasing sales trends and customer purchasing behavior.
- Provided actionable insights to optimize inventory and marketing strategies.
Process Mapping for Retail Operations (Lucidchart & Excel)
- Mapped and optimized stock management processes at Woolworths.
- Identified inefficiencies and suggested process improvements to reduce errors.
Timeline
Woolworths Grocery Team Member
Woolworths
01.2024 - Current
Bachelor of Business (Major: Information Systems) - Business Information Systems
RMIT University
Similar Profiles
Ishreen KaurIshreen Kaur
Retail Worker at WOOLWORTHSRetail Worker at WOOLWORTHS
Kara JonesKara Jones
Online Personal Shopper at WoolworthsOnline Personal Shopper at Woolworths
Jack AdamcewiczJack Adamcewicz
Customer Service/Online Supervisor at WoolworthsCustomer Service/Online Supervisor at Woolworths