Business Intelligence
Designed and built a sales data warehouse using WhereScape RED with yellowfin presentation layer
Using the SAS Enterpise BI suite, provided a full star schema EDW. The presentation layer was a SAS Portal website with dashboards for each business unit and with supporting OLAP cubes for analytics
Provided a proof of concept BI solution using Microsoft Office SharePoint Server (MOSS). Developed a sample EDW containing detailed sales information which was then used to construct various dashboard reports for exception reporting for the branch sales network
Redevelopment of a SAS relational data warehouse into an SAS and Oracle EDW solution
Managed the public RFP process for provision of an end-to-end EDW solution culminating in parallel builds of proof-of-concept systems for evaluation (SAP Business Objects Enterprise, WhereScape RED, Microsoft Performance Point Server)
