Summary
Overview
Work History
Education
Skills
Timeline
Generic

Hanson Qian

Melrose Park,Australia

Summary

  • Data Migration: Played a significant role in the migration of QlikView reports and dashboards to Tableau. Collaborated with the team to map data sources, transform data structures, and validate content accuracy in a new SQL environment, ensuring a seamless transition for end-users.
  • Collaboration and Communication: Maintained regular communication with the migration team, addressing mapping requirements and resolving challenges, contributing to a disruption-free transition from QlikView to Tableau.
  • Power BI Dashboard Design: Designed and constructed Power BI dashboards that transformed complex data into user-friendly visualizations. These dashboards aided BDEs in analyzing customer floor performance and making informed decisions on game purchases or conversions.
  • Ad-hoc Data Requests: Successfully fulfilled multiple ad-hoc data requests using QlikView/QlikSense, providing stakeholders with actionable insights for decision-making.
  • Data System Maintenance: Played a vital role in maintaining data systems, ensuring data accuracy, reliability, and accessibility to meet the team's analytical needs.

Overview

3
3
years of professional experience

Work History

Business Intelligence Developer

Aristocrat Leisure Limited
12.2021 - Current
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Improved data gathering, analysis and visualization procedures with strategic optimizations.
  • Handled massive quantities of business intelligence data, personally managing as much as 150 gigabytes
  • Developed and managed dashboards using PowerBI, Qlik, Tableau.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
  • Generated reports, updated spreadsheets and presented results.
  • Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.

Data Analyst/Python Developer

Visualisedata
05.2021 - 11.2021
  • Worked independently to design, develop and test code.
  • Stayed current on developments in related Python frameworks.
  • Collaborated with quality assurance team to verify correct implementation of software development changes.
  • Followed best practices with code development, maintenance and testing to improve solution design.

Data Analyst

Bunzl Safety
02.2021 - 09.2021
  • Data collection and integration
  • Data cleansing and management using MS Access and Excel
  • Integrated dataset and information from ERP system
  • Reported the results back to the relevant members of the business
  • Extracted desired information using SQL techniques such as 'joins', 'groupby' and 'where' condition
  • Worked alongside teams within the business or the management team to establish business needs.

Education

Master of Business Analytics -

The University of Technology Sydney
10.2021

Bachelor of Commerce-Professional Accounting -

Macquarie University
10.2014

Skills

  • SQL
  • Python
  • Tableau Desktop
  • Alteryx Designer
  • QlikView/QlikSense
  • SAS (certified)
  • Data Repositories
  • Extraction Transformation and Loading (ETL)
  • Performance Metrics Analysis
  • Data Warehousing

Timeline

Business Intelligence Developer

Aristocrat Leisure Limited
12.2021 - Current

Data Analyst/Python Developer

Visualisedata
05.2021 - 11.2021

Data Analyst

Bunzl Safety
02.2021 - 09.2021

Master of Business Analytics -

The University of Technology Sydney

Bachelor of Commerce-Professional Accounting -

Macquarie University

Similar Profiles

CREATE PROFILE
Hanson Qian