Back to all experience Experience

Public Welfare Data Warehouse

ETL and data warehouse development for public-sector case and production management statistics, including analysis, design, deployment planning, testing support, and operational stabilisation.

2009 – 2012
  • Public Sector
  • Data Warehousing
  • ETL
  • Informatica
  • Oracle
  • SQL
  • Scrum

Scope

The work supported statistics for case handling and production management across several source systems. The data warehouse made information available for line management, operational follow-up, and recurring statistical reporting.

Some reporting areas measured process duration and monthly development over time, including transitions through public welfare workflows.

What I did

I was responsible for the ETL part of the solution, including analysis, design, ETL development, production deployment, test preparation, production planning, and clarification of operational dependencies.

I also worked with Informatica development, system and acceptance test support, data modelling, troubleshooting, operational stabilisation, and support for other warehouse initiatives.

Technologies

Informatica PowerCenter, Oracle, SQL, ETL design, data warehouse development, test planning, production deployment, and operational support.