E-Enterprise & Business Intelligence System

Abstract

Our project E-Enterprise and Business Intelligence System is composed of two main subsystems i.e., E-Enterprise System and Business Intelligence System (BIS). E-Enterprise consists of further two systems Fixed Asset Management System (F AM) and Order Transaction Processing System (ODTPS). These systems replace the legacy online transaction processing (OL TP) systems running at AITL, by providing distributed multi tier, Internet ready OL TP capabilities. Fixed Asset Management System provides them anagement of fixed assets, which the company owns, and Order Transaction Processing System provides the management of company sales. The client's interaction with these systems is browser based. . Business Intelligence System has two data marts one for Fixed Assets and other for Sales information. It also contains Extraction Transformation and Loading routines (ETL) and BI reporting client. The two data marts are designed for analysis and reporting purpose, by storing historical data, consolidated from FAM and ODTPS (OLTP) data sources respectively. ETL routines are used for the Extraction of data from OLTP data sources, transforming it for data marts and then loading in the data warehouse. These routines leverage Oracle 9i ETL features for performance and scalability. The BI reporting client equipped with state of the art graphs and reports provides an insight of the company's assets and sales to the executives. In addition to this the whole software development I ifecycle is controlled by Rational Unified Process (RUP), with special emphasis on software documentation.