Data Warehousing Project

Business objective

• An enterprise wide view of data across the world
  
• Local knowledge bases required for holistic analysis of data
  
• Uniform delivery of composite information across business lines
  
• Minimization of dependence on operational reportin

Environment

• AS/400
  
• Cobol/400,
  
• DB2/400, ORACLE 8i
  
• Hyperion Essbase, Alphablox, Data Mirro

System Functionality

• Knack Systems is building a Knowledge Base that encompasses all business lines and functions in the enterprise
  
  
• The data warehouse is designed to address specific local needs while accommodating vertical integration of data across locations within the company.
  
  
• The data warehouse is designed for long term growth and for optimal query performance
  
  
• AlphaBlox provides a cutting edge customizable vehicle for information and knowledge delivery
  
  
• Applies enterprise standards for naming conventions and common data values.

Achievements

• Project cost reduced by 28% due to efficient project execution
  
  
• Increased savings planned for enhancements and maintenance that will be done from Offshore
  
  
• Unit Testing and Integration Testing were done Offshore thus reduction in cost and time for execution.