a picture of Allan Ford working at Santos

Allan Ford

Data Analyst / Data Integration Analyst

About Allan Ford

I am, firstly, a husband and a dad, a neighbour, a mate .... workwise, I am an information technology specialist with core expertise in :

• Data Management: Data analysis, data profiling, data reporting, data presentation, data migration, data comparison, data recovery, data quality monitoring, database design, data design including establishing documented entity naming standards and code naming standards,

• Systems integrations: building, testing, maintaining integration processes using Talend, Dell Boomi, SSIS

• IT systems : Build, test, deploy, support.

My qualification is as per: Bachelor of Applied Science in Computer Studies from the University of South Australia (formerly called South Australian Institute of Technology.) (Feb. 1984 - Nov. 1986) (Graduated 1987).

Technical Skills :

• Integration Tools: SSIS, Talend, Dell Boomi, PL*SQL

• Programming Languages: SQL, PL*SQL, C#.net, Excel, Excel VBA, VB.net, Java, Delphi, JS

• Reporting Tools: SSRS, Tableau, Spotfire, SQL, Excel

• Web Page Tools: Sharepoint, HTML, CSS

• Databases: Oracle and Microsoft SQL Server and their related tools.

Career Summary :

[December 2018 through to June 2019] 6 month contract

SA Ambulance Service, - based Greenhill road, EASTWOOD, Adelaide, South Australia, South Australia.

• Job title: Database Developer / Analyst

• My main project at SA Ambulance relates to Microsoft SQL Server data profiling, data re-engineering and related process and reporting re-engineering, relating to Patient Clinical Record data in particular.

• Microsoft SQL Server related work, Reporting and data presentation with SSRS, Tableau and Excel.

• Microsoft SQL Server database items design: tables, views, procedures, triggers, SSIS Job creation, deployment, monitoring.

• A wide variety of “business as usual” type of work in a small Business Intelligence Unit team.

[July 2018]

Helping Hand - IT work for aged care service company - 5 day contract - based in Tranmere, Adelaide, South Australia.

• Consultant - Microsoft SQL Server and report builder work.

[August 1986 through February 2018]

Santos Ltd. - IT work for the oil and gas company Santos Ltd. - based in Adelaide, South Australia.

SANTOS Career Summary :

• Data Analyst [January 2014 – February 2018]

• Application Analyst [January 2009 – December 2013]

• Senior Analyst/Programmer [January 2004 – December 2008]

• Project Manager [January 2003 – December 2003]

• Technical Systems Analyst / Programmer [January 1990 – December 2002]

• Programmer [August 1986 – December 1989]

[January 1986 through August 1986]

Australian Customs - Programmer - IT work for federal government Customs department - based in Canberra, ACT.

Allan Ford's Home page