Back to all experience Experience

Energy Utility Analytics Portfolio

Several analytics and warehouse maintenance projects for an energy utility, covering financial reporting, KPI dashboards, project steering information, and Informatica-based warehouse support.

2012 – 2020
  • Energy
  • QlikView
  • Informatica PowerCenter
  • Data Warehousing
  • Financial Reporting
  • KPI Dashboards

Scope

This was not one single project, but a portfolio of analytics work over several years. The areas included self-service analysis, financial and liquidity reporting, management reporting, KPI dashboards, and project execution reporting.

What I did

I maintained and documented an Informatica PowerCenter-based warehouse solution, including cleanup, new development, and defect correction.

I also worked on architecture and development of QlikView models for analysis and reporting. One supporting tool produced wiki-based documentation from Informatica metadata, making the warehouse easier to understand and maintain.

Technologies

Informatica PowerCenter, QlikView, SQL, warehouse documentation, financial reporting, KPI dashboards, and analytics model development.