Strategy and Roles5/2/2011

Prepare By:

Mohammed Al-Moayed

SABAFON Success Story

Prepared By :Mohammed Al-MoayedData warehousing & Reporting ManagerSABAFON

SABAFON History with BOE

Why SABAFON decided to move to New BOE version

SABAFON Before New BOE

SABAFON After New BOE

Why the migration from 6.1a to XI 3.1 succeeded

ROI

Obstacles

Conclusion

28/05/2011 2

Objectives

Business Object started with SABAFON in 2004

Version of application was 6.1a

This Application was part of Billing system.

28/05/2011 3

SABAFON History With BOE

Restricted License in old version

New Features

No Support for old Version.

To provide Better Services such as: Scheduling

Bring BI to All Business Users

Creating reports by End users.

Better visualization by using Xcelsius & Explorer

Better Administration for BOE

Utilize Developed Data warehouse

28/05/2011 4

Why BOE XI 3.1

Restricted features

No scheduling

No Visualization tools available.

Increased work load on DWH engineers for on-demand requests.

Lack of Information about Administrating BOE

Many monthly, daily and weekly reports were generated via Excel files

All reports were developed by IT engineers

No auditing reports such as most used reports ….etc

28/05/2011 5

SABAFON before Implementation

Limited number of user licenses (For example: service centres users used to share same user)

Long execution time of reports (15 minutes to hours )

Data warehouse was not completed

Average execution time of 50 minutes

28/05/2011 6

SABAFON before Implementation

Billing SystemLogical Standby

Billing SystemPRD

BOE Repository

28/05/2011

End usersIT Admins.

80% of Reports from Operational61 reports were executed

Old Structure of BOE Before Project.Billing system is main source from Two Databases (BSCS & PRD).

10 Most important

reports were

executed manually

by IT

Small Aggregated DB

20% of reports from aggregated DB

7

Better services due to new features

Generating reports in excel format decreasing to 15%

Future plans decrease to 0%

Load on IT Engineers decreased to 30%

Users licenses were extended

Xcelsius help department administrators to start

developing their own Dashboard

Embed them in BOE

28/05/2011 8

SABAFON after Implementation

Scheduling help end-users to save time and Improve performance ( this also improve network Bandwidth)

Average execution time of reports is now 3 minutes

More information about end-users

Checking most report used

Most used universes

Checking if end users are effective or not (help us to evaluate our services we provide to end users)

Prepaid engineers moved to DWH unit for developing DWH for Prepaid

28/05/2011 9

SABAFON after Implementation

80%

20%

Source of Reports Before Project

Reports Operational DB

Reports Aggregated DB

28/05/2011 10

80%

20%

Source of Reports after Project

Reports from DWH

Reports based Operational DB

Statistics

Other Tasks Out of Reports from BOE

Extending data warehousing Development

Implementation of New applications such as Data Integrator & Meta Data

28/05/2011 11

Statistics

70%

30%

Load in IT Percentage

Other Tasks Out of Reports from BOE

Remaining Tasks belongs to reports out of DWH & BOE

28/05/2011 12

On Demand Request Status

52

36

51

2617

31

137 6 9

5 4 5 4 5 4 5 4 4 3 3 2 2 1

Jan

-10

Ma

r-1

0

Ma

y-

10 Ju

l-10

Se

p-

10

No

v-

10

Jan

-11

Ma

r-11

Ma

y-

11 Ju

l-11

Se

p-

11

No

v-

11

One Demand request – PostPaid

Part of 2011 & expected number of requests in 2011.

60 55 56

3020 15 10 8 7 5 4 4

Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11

One Demand request – PrepaidPart of 2011 & Expected number of request in 2011

28/05/2011 13

Sample of auditing reports.

28/05/2011 14

Sample of Dashboards.

28/05/2011 15

Sample of Polestar Information Space

28/05/2011

Billing SystemLogical Standby

Billing SystemPRD

h

Dept. Admin.

End usersIT Admins.

BO

E R

EP

.

BO

E A

UD

.

Only 20 % of Reports from Operational80% of Reports from DWH

New Structure of BOE After Implementation.Data warehouse is main source O f Reports.

BOE SERVER Production

BOE SERVER Development

Mobile SERVER

16

Data Warehouse concept

Management Support

DWH Team support

Training our end users, Department Administrator & DWH team

Working with Implementer as one team

Using SAP AGS for solution support

Department Administrator activities & support

28/05/2011 17

Why the project succeeded

28/05/2011 18

BOE Licenses.

215

16 20 3412 15 12

160

10 5 10 5 5 1

Web Intelligence Viewing

Web Intelligence Xcelsius Enterprise Xcelsius Viewing Live Office Polestar Mobile

Existing License Status

Existing License Used License

215

16 20 3412 15 12

200

16 16 20 12 12 5

Web Intelligence Viewing

Web Intelligence Xcelsius Enterprise Xcelsius Viewing Live Office Polestar Mobile

Expected used License By End of 2011

Existing License Expected License

New BOE help Saving 30% of staff cost

New BOE help our customers to

Reach information faster

Take faster decisions (Saved 50% of decision makers time)

Within three years I think SABAFON will get the ROI as long as we are in the same progress

This project lead to save 50% of the project overtime spent on extending our Data warehouse

28/05/2011 19

ROI

Many new Tools implemented Web Intelligence

Xcelsius

Live Office

Polestar

Mobile

Change Resistance

Budget Constraints

Decentralized Reporting Biasing

Lack of advance experienced engineers in dashboard development

28/05/2011 20

Obstacles

Bring BI to most Business Users was achieved

Department Administrator are now able to generate most reports from BOE

New benefits for end users:

Fast access to information

Scheduling and other features started to be utilized

Saving staff cost.

28/05/2011 21

Conclusion

Load in DWH – Engineers to generate reports is decreasing

Change in report execution time:

Fast Report generation

Increased end user satisfaction

28/05/2011 22

Conclusion

28/05/2011

?Mohammed.Al-Moayed@sabafon.com.ye

23