RAVINDERPREET KAUR
Rochedale, Brisbane,Australia
Summary
Results-driven Data Analyst with expertise in SQL, Power BI, and data analysis. Experienced in gathering, cleaning, analyzing, and visualizing large datasets to provide actionable business insights. Skilled at building reports and dashboards that support decision-making processes across multiple departments. Adept at translating complex data into user-friendly formats and working collaboratively with stakeholders to meet business objectives.
Overview
9
9
years of professional experience
Work History
Data Analyst
Smart Careers
Brisbane & Melbourne, Australia
01.2024 - Current
- SQL developer - Proficient with complex SQL queries for data retrieval, including SELECT statements, JOINS, Sub queries and set operations
- Skills in inserting, updating, deleting and manipulating data within database tables using DML
- Experience in writing and optimizing stored procedures and functions for improving performance and reusability
- Knowledge of creating and managing views for simplified access and indexes to enhance database performance
- Competency in using DDL commands to define, alter and manage database schemas, tables and other objects
- Understanding of database design principles, including normalization, table relationships and schema design to ensure data integrity and efficiency
- Ability to optimize query performance through indexing, query refactoring and understanding execution plans
- Working with Power BI - Data Modelling and Preparation: Connecting to various data sources such as SQL, EXCEL, Websites and importing data into Power BI and transforming data using Power Query
- Designing and implementing data models that effectively represent business processes and requirements including establishing relationships, calculated columns and measures
- Creating interactive reports and dashboards that provides actionable insights using Power Bi's visualization tools such as charts, graphs, maps and tables
- Applying best practices in data visualization to ensure reports are clear, engaging and accessible to end users
- DAX (Data Analysis Expression): Working DAX formulas to create complex calculations, aggregations and data analysis with Power BI models
- Ensuring that DAX calculations are optimized for performance and accuracy
- Excel Analyst - Developed and maintained complex financial models using Excel
- Analyzed large data sets to provide actionable insights to management
- Created dynamic dashboards and reports for various departments.
IT Support Engineer
Farmers Trading Company
Wellington, New Zealand
01.2020 - 11.2021
- Installing and configuring computer hardware, software, systems, printers and scanners
- Monitoring and maintaining computer systems and networks
- Responding in timely manner to service issues and requests
- Providing technical support across the company
- Responsible for ensuring high availability and performance of the IT systems.
Customer Service Representative
Mister Mint
Wellington, New Zealand
03.2018 - 10.2019
- Provide superior customer service by focusing on the individual needs of each customer
- Handled customer enquiries and suggestions courteously and professionally
- Answered customer telephone calls promptly to avoid on-hold wait time
- Offered advice and assistance to customers, paying attention to special needs and wants
- Completed bi-weekly payroll for employees.
IT Tutor
Punjab Technical University
Punjab, India
02.2016 - 11.2016
- Database Management System Tutoring, C++ Tutoring, Data Structure Tutoring
- Motivated Students with accurate feedback and positive reinforcement
- Monitored student progress and provided feedback and support
- Used variety of teaching methods to successfully help wide range of students
- Maintained records of student assessments, tutoring activities and results.
Education
Master of Technology in Computer Science -
Punjab Technical University
2016
Bachelor of Technology in Computer Science -
Punjab Technical University
2014
Skills
- SQL querying and optimization
- Power BI (DAX, Power Query, Visualization)
- Data Analysis and interpretation
- Dashboard and report development
- Data Visualization and presentation
- Python Programming
- Excel modelling and analysis
- Problem solving and data-driven decision making
Technical Skills
SQL : Proficient in writing complex queries, optimizing performance and working with stored procedures and views.
Power BI : Data Modelling, Report Design, DAX Calculations, Power Query.
Excel : Advanced data analysis, pivot tables, data models.
Programming Languages : Python, SQL, Java
Tools : Power BI, Excel, MySQL
Data Visualization : Charts, graphs, maps, tables
Languages
English
Punjabi
Hindi
HOBBIES
Playing chess
Listening to music
Travelling
REFERENCES
Available on request
Timeline
Data Analyst
Smart Careers
01.2024 - Current
IT Support Engineer
Farmers Trading Company
01.2020 - 11.2021
Customer Service Representative
Mister Mint
03.2018 - 10.2019
IT Tutor
Punjab Technical University
02.2016 - 11.2016
Master of Technology in Computer Science -
Punjab Technical University
Bachelor of Technology in Computer Science -
Punjab Technical University