Malcolm Speedie

mal.speedie@gmail.com

04 880 19532


I am an IT professional with over 35 years of experience supporting a spectrum of business functions, including over 9 years in government organisations. I am experienced in tackling complicated projects for complex multinational organisations. I am people-oriented yet enjoy technically challenging work. I work well leading teams, on a team or working independently, and I have managed teams and projects of global scale.

 

Client Skills:

Technical Skills:

 


Experience:

Manager Data and Analytics

Health Support Services, Western Australia May 2022 to present

         Supervise staff of ten across two teams.

         Ensure timely and accurate maintenance and reporting of workforce data.

         Championed migrating to a central database to allow intersection of data sources.

         Leading automation of data monitoring and data migration.

         Provide centralised Power BI dashboards to allow near real-time monitor of processing activity against KPIs.

 

Data Model Manager, COVID-19 (Acting)

COVID-19 Department of Health, Victoria June 2021 to May 2022

         Managed an eight-person team of employees and contractors.

         Ensured timely and accurate data flow of COVID-19 information.

         Proactively ensured data infrastructure met growing demands.

         Managed Data Model databases (Azure and SQL Server), Azure Data Factory, Azure File Services, JIRA, Confluence, Azure Development Operations, and Active Directory user management to ensure service continuity.

 

Principal Reporting Analyst

Department of Families, Fairness and Housing, Victoria, July 2019 to June 2021

         Performed ETL and data transformations via R and SQL.

         Revise database objects increasing reliability and performance including tables with millions of rows.

         Established an Azure copy data feed for Client data.

         Helped manage the QlikView server and infrastructure.

         Developed QlikView Applications, Power BI reports and Power Automate flows.

 

Senior Consultant, Data Management and Reporting

Department of Education, Western Australia, July 2018 to June 2019

         Designed and developed the infrastructure for the Tableau rollout.

         Provided database design and data management to integrate disparate data sources into a cohesive and normalized data model to support time series analysis.

         Developed and delivered reports using SAS.

         Answered inquiries into school performance using SAS and Tableau.

         Updated the Tableau server and clients from 10.4 through to 2019.1.

 

Senior Project Officer

Department of Education, Western Australia, February 2018 to July 2018

         Managed the training scheduling and forecasting for SIS Classic training.

         Developed the training plan for the upcoming implementation of the new webSIS rollout.

         Generated briefs for Board meetings.

 

Business Systems Analyst

Department of Education, Western Australia, March 2014 to February 2018

 

Chief Database Architect

Dataguise, Inc., June 2009 to Jan 2014

Senior Business Analyst HRMS

VMware, Inc., April 2008 to June 2009

Consultant

JKreative Solutions, Inc., August 2007 to March 2008

Computer Systems Analyst

Genesis Microchip Inc., July 2006 to June 2007

Computer Systems Analyst
Openwave Systems Inc., July 2002 to June 2006

Consultant
JKreative Solutions, Inc., July 2001 to June 2002

Computer Systems Analyst
Eazel Corporation, February 2001 to May 2001

Director of Technology Services
Qbiquity Corporation, January 2000 to February 2001

Programmer Analyst-4 IT
Oracle Corporation, May 1995 to December 1999

Computer Systems Analyst
Ministry of the Attorney General, B.C., January 1994 to May 1995.

Computer Programmer/Analyst
SFG Technologies Inc., January 1993 to December 1993.

Computer Programmer/Analyst
William M. Mercer Ltd., September 1987 - July 1992, November 1992 - January 1993

Computer Programmer/Analyst
Institute of Ocean Sciences, Sidney, B.C., October 1984 February 1985, June 1986 - August 1986

Education:

Diploma of Technology
British Columbia Institute of Technology, Computer Systems, graduated 1984.