DW_Solutions

Data Warehousing Solutions

Data Warehousing Solutions

Reporting/OLAP Cognos Crystal Reports Business Objects Oracle

www.inteqsolutions.com

Overview Inteq offers end-to-end consulting and implementation services in the Plan, Build and Operate phases of the Data Warehousing life cycle.

Plan: Requirements gathering and needs analysis provides a systematic and comprehensive study for identification of customer requirements and for establishing the need for a Data Warehousing solution.

Architecture Blueprint provides specifications of the Technical Architecture and implementation road map in line with the Needs Analysis and Requirements study.

Build: Development and Deployment of the Data Warehousing solution based on the Needs Analysis, Requirements gathering and the recommended solution architecture.

Operations/Maintenance: Undertake all activities in the Data Warehousing life cycle to keep the operations environment up and running, including support for resolving issues.

Competencies The competencies of the Data Warehousing (DW) group revolve around Skill Sets and Processes. The DW group has a resource base of 20 consultants with technical, functional and domain expertise. Our consultants offer value added experience to all clients. In addition to technology experts, the DW Group has a team of Project Leaders and Project Managers who have a wealth of experience in implementing full-life cycle projects.

Data ETL Modeling ERWIN Oracle

DTS Informatica Oracle

DW Engine MS SQL Server 2000 Oracle

Methodology The methodology divides the Data Warehousing project implementation activities into four phases: Requirement Analysis, Design, Development and Deployment. Each phase is further broken down into several sub activities and has specific entry and exit criteria.

Phase 1: Requirement Analysis During this phase, the customer's requirements are gathered with respect to the following areas: l

Business Drivers

l

Business Objectives

l

System Requirements

Phase 2: Design The design phase is divided into five sub phases: l

Technical Architecture Design

l

Logical Data Modeling

l

Physical Database Design

l

ETL Design

l

End User Application Design

The technical architecture for the solution is based on the user requirements and the inputs about the existing infrastructure.

Phase 3: Development The development phase consists of four parallel processes viz. l

ETL Development

l

End User Applications Development

l

Product Installation

l

Integration Testing

Phase 4: Deployment In this phase, all the parallel streams in design and deployment phase converge, and the various parts of the data warehousing solutions are integrated together.

The solution is made accessible from user desktops, and is handed over to the user after a transition phase, which consists of acceptance testing and user training.

Delivery Processes Inteq have established processes for all the phases of the DW life cycle. l

Onsite-offshore Implementation Models

l

Project Communication

l

Change Management

l

Roles and Responsibilities

Experience (Insurance): Enterprise-wide Data Warehouse Client Profile: Our client is one of Canada’s largest niche market providers of insurance products and services. It provides a full range of travel and health insurance products to students, groups, individuals and expatriates. These products are sold and marketed to the end-consumer directly or through insurance brokers, travel agents, consultants and third party administrators. The Company administers over $300 million in premium covering more than 3 million policyholders traveling worldwide. The Company also offers medical case management, cost containment, and assistance and claims services throughout the world via their wholly owned subsidiary which, specializes in services related to the American, Canadian, Caribbean and Mexican health care systems. With over 55 corporate clients located in more than 20 countries around the world, it manages approximately 55,000 inpatient, outpatient and non-medical travel related emergencies per year. From its roots in 1984, the Company has grown rapidly and continually over the years currently having more than 400 employees. www.inteqsolutions.com

Client's Problem: The Client operations were handled by disparate systems for Sales, Claims and Accounting. With this technology it became difficult to compile performance metrics for tracking the Key performance and Risk Indicators. The client needed a central repository of data that could provide a single view of the organizations information for effective management of Key Performance Indicators and Key Risk Indicators. They wanted a solution that will include the information about sales, claims, products, sales channels, accounting information payables and receivables. Also the solution should provide fast, consistent access to company data to employees throughout the enterprise for their reporting needs.

Solution Offered: Inteq recommended the concept of data warehouse, which will act as a central repository for all the organization data from disparate sources. OLAP analysis on the data warehouse for defining what drives the performance of the client business and for compiling the performance metrics and generating complex reports.

The Data Warehouse was built using the multi-dimensional Star Schema approach. The data modeling was done using ERWIN. The main objective of this architecture was to meet the reporting requirements with respect to sales channel analysis, claims analysis, relative risk patterns, acquisition costs, reserve management, business ratios and profitability.

Business Benefits: The solution resulted in a significant improvement in the decision support system of the client organization. In addition to serving as the single repository for enterprise-wide data, the solution offered increased consistent view of corporate data, and never before seen performance indicators.

Technology: Data Modeling

ERWIN

ETL DW Engine OLAP Reporting Data Sources

DTS MS SQL Server 2000 Cognos Powerplay, MS Analysis Services Cognos Reportnet, Impromptu Oracle, MS SQL Server 2000, Foxpro, Excel

We pride ourselves in providing you the best technical services. Your comments and suggestions are important to us as we continue to improve our product and services.

Please feel free to correspond to us through the following contact information:

Inteq Software Pvt. Ltd. India Office: 1365, Road No.45, Jubilee Hills, Hyderabad 500033, India Telefax:+91-40-23552931 / 32 / 33 email: merla@inteqsolutions.com www.inteqsolutions.com

US Office: 2180 West State Road 434 Suite 2104 Longwood, FL 32779 Ph: 407-788-1505 Fax: 407-788-0316 email: nc@acmbs.com