Client

A Major Health Care Payroll Provider

Vertical

Health Care Services

Technologies

Microsoft Reporting Services, Microsoft Analytics, SQL Server

Solution

Business Intelligence, Dataware Housing, IOTAP Solutions for Microsoft Platform Partners

Business Scenario

The health care service provider had launched a service where they had tied up with different fitness centers and were offering promotional discounts to its subscribers to use the fitness centers around the country. The existing OLTP application held several records containing information about enrollees and the associated fitness centers. However the marketing department needed access to the following information

• Have the ability to forecast enrollments based on historical trends

• Understand profitability ratios and compute which fitness centers were not cost effective

• Which age group within their membership was using the offering effectively

• And other reports to make the future marketing more effective

IOTAP Solution

IOTAP along with the help of a Microsoft Platform Partner (MPP) came up with an innovative solution which helped the customer's marketing group to view the required reports.

MPP was engaged in functional specification of the application and gathered all of the different business rules of the processes.

• Screen Mockups

• Functional Specification

• Database Schema

The functional spec was then shared with IOTAP and IOTAP developed a Sharepoint Services solution to tackle the problem.

Here are the technical steps, which IOTAP followed to implement the solution

1. Understand the database structure and reporting requirements as per the functional specification

2. Step2 Develop Report using MSRS Visual Studio 2003 plug-in

3. Build Multiple Intelligent Report Delivery Model and ..

4. Publish to portal, send email alerts using SMTP, etc

Business Benefits

Key benefits include the following:

• The Reporting solution has already helped Customer to increase its ability to make decisions.

• The reporting solution on an automated basis pulls data from backend systems and generates (almost) real time reports.

• Easy integration with active directory helped customer tie the application with existing user base

• Out of the box Microsoft Reporting solution, seamless integrated with SQL Server, provided unparallel cost and maintenance advantages

• - Eliminated service costs. Deploying an in-house solution enabled Customer to gain more timely access to data, and also enabled it to eliminate the ongoing cost of an outsourced solution.

IOTAP Engagement Model

Microsoft Partner engaged in the following activities

• Functional Specification

• Onsite Planning

• Product Architecture

• Product Design

• Project Management

• Interfacing with end client

IOTAP was engaged in the following activities

• Application Development

• Application Migration

• Customized Reporting

• Build & QA Automation

• Application Integration

• Interfacing with the partner to meet client requirements