Manufacturing

For a large food company specialized in babyfood and clinical nutrition we developed an end-to-end business intelligence solution. Almost all systems used for supporting the primary and administrative processes are being used as a source for the new reporting environment. Authorized employees have direct access to personalized relevant information, and external parties receive personalized information by using a custom built Email distribution system.

Roles and responsibilities
Project lead, analysis, design and development of datawarehouse & rapports, training of users and administrators

Platform
BI frontend
Business Objects 5.1, WebIntelligence 2.6

Datawarehouse
ETL: SQL Server 2000 DTS
RDBMS: SQL Server 2000

Source systems
* AXI Finance
* Various Oracle based custom built sytems