General Services Administration ePM Data Warehouse

GSA had a requirement to identify and model data elements used in its current Cognos Electronic Project Management (ePM) reporting package, based on the Merdian Systems Proliance tool. GSA was utilizing a corresponding data warehouse which is solely comprised of data from the Proliance source system since ePM was introduced in 2008. There were fundamental challenges with the current state of the ePM data warehouse which would prevent PBS from sustainably producing the desired future-state of its reporting platform.

The Ventera GSA Report Writers team, with its PwC partner, leveraged its years of Proliance and GSA knowledge to redesign the existing data model for a migration to the Oracle BI platform known has the GSA PBS Project Domain. We had to focus the project scope on all relevant project lifecycle subject areas, including Project Planning, Project Funding & Financial Control, Project Procurement, and Project Execution & Delivery.