Summary
Overview
Work History
Education
Skills
Timeline
Generic

Paul Ferraro

ST MORRIS,SA

Summary

Accomplished Data Engineer with a proven track record at DCP, enhancing data retrieval speeds and integrity through expert ETL development and SQL programming. Spearheaded the creation of insightful dashboards and led strategic data analyses, blending analytical skills with effective communication to drive decision-making. Excelled in roles requiring data warehousing and integration, consistently delivering beyond expectations.

Detail-oriented Report Analysis designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.

Overview

31
31
years of professional experience

Work History

Data Engineer

DCP
11.2017 - Current
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Created visually appealing dashboards that effectively communicated key metrics to stakeholders.
  • Prepared monthly ad hoc reporting in alignment with client needs.
  • Conducted thorough analyses of large datasets to uncover trends and patterns, driving strategic initiatives.

Senior Programmer Analyst

TAFESA / Department of State Development
07.2005 - 11.2017
  • Debugged and modified Oracle software components.
  • Worked closely with clients to establish specifications and system designs.
  • Authored code fixes and enhancements for inclusion in future code releases and patches.
  • Developed in-house applications designed for company needs.
  • Led training sessions for end-users, promoting the adoption of new software applications across the organization.

Analyst Programmer

Education Department / DFEEST
07.1997 - 07.2005
  • Debugged and modified Ingres software components.
  • Provided technical support using knowledge of complex technology to solve problems and support new projects.
  • Updated documentation with project deviations to capture changes.

PC/LAN Support Officer

Education Department / DFEEST
02.1994 - 07.1997
  • Coordinated hardware upgrades and software patches, ensuring compatibility and seamless integration across systems.
  • Participated in IT projects supporting infrastructure improvements or new product launches.
  • Improved customer satisfaction by resolving technical issues in a timely manner.

Education

University of South Australia
Adelaide, SA

Bachelor of Science - Computer And Information Sciences

University of South Australia
Adelaide, SA
02.1994

Associate Diploma - Computer Studies

University of South Australia
Adelaide, SA
02.1992

Skills

  • ETL development
  • Data Warehousing
  • Data Modeling
  • Data Pipeline Design
  • SQL Expertise
  • SQL Programming
  • Data Analysis
  • Data Analytics
  • Report Generation
  • Written Communication
  • ETL processes
  • Microsoft SQL Server
  • Analytical Skills
  • Problem-solving abilities
  • Data integration

Timeline

Data Engineer

DCP
11.2017 - Current

Senior Programmer Analyst

TAFESA / Department of State Development
07.2005 - 11.2017

Analyst Programmer

Education Department / DFEEST
07.1997 - 07.2005

PC/LAN Support Officer

Education Department / DFEEST
02.1994 - 07.1997

University of South Australia

Bachelor of Science - Computer And Information Sciences

University of South Australia

Associate Diploma - Computer Studies

University of South Australia

Similar Profiles

CREATE PROFILE
Paul Ferraro