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)