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, NZ11.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
Similar Profiles
Alex RapanaAlex Rapana
Business Support Coordinator at Vector LtdBusiness Support Coordinator at Vector Ltd
ILSE ELISABETH HOOGEVEENILSE ELISABETH HOOGEVEEN
Customer Resolution Manager at VECTOR LTDCustomer Resolution Manager at VECTOR LTD
J Edgar VieraJ Edgar Viera
Warehouse and Logistics at Vector Resources dba Vector USAWarehouse and Logistics at Vector Resources dba Vector USA
Greg ChalmersGreg Chalmers
HC Driver at Morgan's TransportHC Driver at Morgan's Transport
Michael CowanMichael Cowan
Recreation Intern at Pinehurst Country ClubRecreation Intern at Pinehurst Country Club