Summary
Overview
Work History
Education
Skills
Technical Skills
Languages
HOBBIES
REFERENCES
Timeline
Generic

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
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
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
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
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

Similar Profiles

CREATE PROFILE
RAVINDERPREET KAUR