Summary
Overview
Work History
Education
Skills
Timeline
Generic
Michael O'Callahan

Michael O'Callahan

West End,VAN

Summary

Business Intelligence Specialist with a degree in mathematics and more than 5 years experience working in the data field. Specializing in Power BI, Tableau, Python, SQL, Snowflake and Wherescape Red. Passionate about big data, mathematics, chess and tennis.

Overview

8
8
years of professional experience

Work History

Business Intelligence Specialist

Vector Ltd
Newmarket, Auckland
11.2021 - Current
  • Built and maintained robust ETL systems to bring data from its source into a data warehouse based on Kimball methodology.
  • Used BI tools such as Power BI to create meaningful data visualizations for end-users.
  • Wrote SQL queries and Python scripts to support business insights.
  • Ingested large volumes of data to visualize the working capacity of transformers across the electricity network.
  • Built real time ETLs and dashboards to indicate current outages across the electricity network.
  • Used Windows Powershell to automate the sending of requests and the receipt of responses from business partners to further enhance transparency of outages across the network.
  • Worked closely with business stakeholders, analysts, and data scientists to understand reporting requirements.
  • Ensured the quality, accuracy, and reliability of transformed data.

Data Specialist

Vector Ltd
Auckland, Auckland
10.2018 - 11.2021
  • Ensured the quality and accuracy of data for reporting and auditing purposes.
  • Wrote scripts to automate existing processes, improving business efficiency.
  • Forecasted the impact of implementing new business equipment.
  • Supported the BI team in using data to detect electric vehicle usage across the network.

Data Analyst

Paritech
CBD, Melbourne
02.2016 - 10.2016
  • Collected, and transformed data to enable insights and analysis.
  • Built models to predict stock movements based on sentiment analysis.

Education

Bachelor of Science - Mathematics

Massey University
Palmerston North, NZ
11.2016

Skills

  • SQL
  • Python
  • Powershell
  • Wherescape Red
  • Snowflake
  • Power BI
  • Tableu
  • Excel

Timeline

Business Intelligence Specialist

Vector Ltd
11.2021 - Current

Data Specialist

Vector Ltd
10.2018 - 11.2021

Data Analyst

Paritech
02.2016 - 10.2016

Bachelor of Science - Mathematics

Massey University
Michael O'Callahan