 |
| Allianz Bajaj Life Insurance Company |
|
|
|
|
Client
|
|
On the Web
|
|
|
Allianz Bajaj
|
|
www.allianzbajaj.co.in
|
|
|
|
Project |
|
Shortcut to |
|
|
Management Reporting through Data warehouse |
|
The Company |
|
|
|
Business Challenge |
|
|
|
How we helped |
|
|
|
|
Deliverables |
|
|
|
Benefits delivered |
|
|
|
Other project details |
|
|
|
Executive Summary |
|
|
Characterised by global presence with a local focus and driven by customer orientation to establish high earnings potential and financial strength, Allianz Bajaj Life Insurance Co. Ltd. faced with a challenge of management reporting and decision making. They required an information technology based solution that would cater to all their analytical requirements. Nihilent proposed to design and develop a data warehouse with interfaces to the OPUS System, the core Insurance Application and Excel sheets. This involved creating and developing 60 plus analytical reports based on Oracle, for five different departments. The system functionality included DSS for the Core Insurance business, Extraction, Transformation and Load (ETL) from OPUS System, Data Extraction from MS-Excel sheets to Data warehouse and Analytical Report generation. |
|
|
|
|
|
|
The Company
|
|
|
Allianz Bajaj Life Insurance Co. Ltd. is a joint venture between Allianz AG and Bajaj Auto Limited. Characterised by global presence with a local focus and driven by customer orientation to establish high earnings potential and financial strength, Allianz Bajaj Life Insurance Co. Ltd. was incorporated on 12th March 2001. The key to Allianz's success world wide, has been its ability to use its global presence and experience while adapting to local market conditions and develop customer-focused solutions. In India, Allianz AG with Bajaj Auto, is confident of replicating this.
|
|
| Top |
|
|
Business Challenge
|
|
|
Management reporting and decision support are key challenges that Allianz Bajaj is tackling in India. They required an information technology based solution that would cater to all their analytical requirements.
|
|
| Top |
|
|
How we helped
|
|
|
MC3 proposed to design and develop a data warehouse with interfaces to the OPUS System, the core Insurance Application and Excel sheets. This involved creating and developing 60 plus analytical reports for five different departments at Allianz Bajaj. Nihilent was responsible for Project Planning, Scheduling, Requirement Management, Data Warehouse Design, Development, Acceptance Testing and Trainers' training.
|
|
|
The system functionality included DSS for the Core Insurance business, Extraction, Transformation and Load (ETL) from OPUS System, Data Extraction from MS-Excel sheets to Data warehouse and Analytical Report generation.
|
|
| Top |
|
|
Deliverables
|
|
|
|
Requirements Specifications |
|
|
|
|
Data Model Design |
|
|
|
|
Facts and Dimension Design |
|
|
|
|
Developed Reports |
|
|
|
|
Test Plans |
|
|
| Top |
|
|
Benefits delivered
|
|
|
Allianz Bajaj is now able to do ad-hoc and innovative reporting using the Nihilent solution. Reporting is now faster and quicker leading to accurate decision making.
|
|
| Top |
|
|
Other project details
|
|
| Software |
|
|
|
Oracle9i DB, Oracle Data Warehouse Builder, Oracle Discoverer, OAS |
|
|
| Hardware |
|
|
|
1 Linux Based Machine for Oracle 9iDB |
|
|
|
|
Win 2000AS machine for the OWB and Discoverer |
|
|
|
|
Win 2000AS machine for the Oracle9iAS |
|
|
| Special productivity tools |
|
|
|
Oracle Warehouse Builder, Oracle Discoverer 4i |
|
|
| Top |
