AVS SYSTEMS, INC

AVS SYSTEMS, INC

www.avssystems.org

IBM Premier Business Partner and InfoSphere Information Server Specialist

Maximize your investments in

IBM InfoSphere Information

Server

Most Organizations, based on their business need and vision, has invested millions of dollars on IBM InfoSphere Information Server tool comprising of DataStage, QualityStage, Information Analyzer, Business Glossary, Metadata Workbench, FastTrack, Change Data Capture (CDC), Information Services Director (ISD), and Master Data Management (MDM).

On top, these Organizations have entrusted the services of implementation to their existing vendor community to seek out qualified resources that are experienced in these tool sets and spent 5 to 10 times more on getting some of their initiatives completed or in progress. Typical implementation initiatives are Data Warehousing, Data Marts, Business Intelligence reporting and analytics, Data Quality Rigor, Data Profiling for column, primary-key-foreign key, table, table, domain, cross-domain, baseline and comparative analysis with the baseline, maintaining Enterprise Business Glossary or simply end-to-end Metadata Management and Master Data Management. With such selection of resources from various vendor agencies where every resource works independently, InfoSphere Information Server best practices, standards, guidelines, sound data integration & ETL strategy, development methodology, performance & tuning traits, knowledge of center of excellence is lost giving way to poor design, development and practices that results in inconsistencies, severe burn out ratio for the Organization or end up with poor quality product being rolled out into Production which creates lot of headaches to the Incumbent Organization management.

This is where we come in

Information as

a Service

I

I

B

B

M

M

CE

C

E

R

R

T

T

I

I

F

F

I

I

E

E

D

D

V

_V

AR

_A

R

F

F

O

O

R

R

I

I

N

N

F

F

O

O

S

_S

P

P

H

H

E

E

R

R

E

E

Rely on our vast dedicated

technical expertise of over 14

years in InfoSphere to closely

guide and advise you on how to

leverage InfoSphere Information

Server as a platform for Data

Integration and using Information

as a Service as an asset for your

organization.

We bring in our innovative

Center of Excellence (COE)

best

practice.

W

W

W

h

h

h

C

C

C

e

e

e

e

e

e

n

n

n

n

n

n

t

t

t

t

t

t

e

e

o

o

e

o

r

r

r

e

e

e

o

o

n

n

o

n

f

g

f

g

f

g

a

a

a

E

E

E

x

g

x

g

x

g

c

e

c

e

c

e

e

e

e

u

u

u

l

l

l

s

s

s

l

l

l

e

e

e

n

n

n

c

c

c

e

e

e

–

–

–

D

D

D

a

a

a

t

t

t

a

a

a

I

I

I

n

n

n

t

t

t

e

e

e

g

g

g

r

r

r

a

a

a

t

t

t

i

i

i

o

o

o

n

n

n

(

(

(

C

C

C

E

E

E

D

D

D

I

I

I

)

)

)

Benefit from our extensive skills, deep industry

experience and knowledge

The Expertise you seek is

augmented by dedicated

professionals who specialize in

specific InfoSphere discipline and

certified by IBM thus ensuring

complete satisfaction that the

technology service is delivered to

you professionally by people who

understands the technology and

your business. Our past

experience with Fortune-500

companies and innovative best

practices combined with our

Center of Excellence

(COE)

guidelines guarantees you of

fool-proof, high quality, high

performance deliverables.

A

AV

VS

S

C

Ce

en

nt

te

er

r

o

of

f

E

Ex

xc

ce

el

ll

le

en

nc

ce

e

(

(C

CO

OE

E)

)

–

–

provides best-in-time

concepts and best practices to overcome the challenges your

business faces and help your team with innovative approaches

to

A

A

G

G

I

I

L

L

E

E

development.

Finally, we offer advisement on product mentoring,

development and exposing InfoSphere Information Server in

batch or real-time as always-on

Web Services

to grow your

business.

Our COE Service, stemming from over 2 decades of experience

with leading fortune-500 cross-industry firms, is highly

innovative, unmatched that provides immense tangible and

intangible benefits that not only drives your business in the

right direction but creates incredible return on investment

(ROI).

Our

InfoSphere

Center of Excellence (COE)

practice includes:



High-performance

- Architecture and topology strategy



Best practices

- end-to-end relating to topology,

InfoSphere installation, administration, configuration,

development, nodes, memory, capacity planning, file

systems, scripting, automation, migration, and

scheduling including Clustering and Grid solutions



ETL strategy and development

- consistent innovative

design vetted against our best practice, parallel

processing, high-performance, loading/update strategy

and error handling.



Conversions /Migrations -

from previous versions to

the latest



Agile Methodology –

innovative iterative and

incremental development approaches designed to

cope and adapt to new ideas from the outset, allows

changes to be made easily and faster but adhering to

the principles and techniques of COE, thereby

reducing overhead, products and code tested

successfully and rolled out, on time and under budget.



Troubleshooting and Issue Resolution

– having over

20 years of experience in diversified platforms and

environments, we are highly skilled in tracking,

monitoring, solving complex issues . Most of these get

automatically resolved when we put our COE in use.



Work exclusively with IBM Technical Support –

To

resolve PMR’s on time does freeing Clients resources

to work on more important tasks.

Gain visibility and trust in your information –Data about Data

 Proactively manage and administer your information infrastructure

- Web-based exploration of metadata relationships – InfoSphere, modeling and BI applications

- Explore and analyze both graphically and textually

- Perform searches and customized queries  Assess and mitigate change management risk

- Assess dependencies across InfoSphere and 3rd party tools

 Support compliance and governance initiatives (e.g. Sarbanes-Oxley, Basel II)

- Trace data lineage of modeling, BI reports and InfoSphere objects

 InfoSphere Metadata Workbench helps support information governance by providing reporting and traceability on InfoSphere data movement, modeling and business intelligence applications, as required by regulations such as the Sarbanes-Oxley Act and Basel II.

 During the design phase of an information agenda, IT personnel can analyze and view the impact of changes to the current information model, avoiding potentially disruptive modifications to existing processes.

 InfoSphere Metadata Workbench relates design and operational and business metadata to drive better understanding and higher trust between IT and LOB employees.



AVS Systems Metadata Management Strategy facilitates answers to the following questions (shown with typical outputs/deliverables):

What data elements are available / needed?

 Inventory of data assets Why are these data needed?

 Business rationale, business processes supported/enabled How do the data-related processes work?

 Manufacture, manipulation, organization, storage and dissemination of data

 Execution of scripts, programs as required by Administrator as well as developers.

Who is responsible for each of these data elements?

 Ownership, stewardship

When do the data-related processes take place?

 Calendar-driven (scheduled), event-driven, user-driven (ad hoc) Where are the data-related processes executed?

 Internal/external organizations, applications/systems within which data is contained

Metadata management

yields the following reports:

-

Business Lineage

-

Data Lineage

-

Impact Analysis

-

Operational Metadata

Explore Metadata

Information assets in the repository of InfoSphere Information Server (IIS)

Analyze

Dependencies and relationships of key assets and business intelligence reports

Manage

Metadata to obtain in-depth analysis reports

Typical Metadata Sources INTERNAL to the InfoSphere Information Server:

- DataStage ETL Jobs

- QualityStage Data Quality Jobs

- Information Analyzer Data Profiling results

- Business Glossary Terms and Definitions

- Master Data Management

Typical Metadata Sources EXTERNAL to the InfoSphere Information Server:

- Informatica/Other ETL jobs

- Data Modeling from Erwin, ER/Studio, etc.

- Business Intelligence metadata from Cognos, Business Objects, Microstrategy, etc.

- RDBMS Structures from Oracle, DB2, etc

- Various other sources via bridges and connectors

WHEN TO ENGAGE US & OUR EXPERIENCE

D

Da

at

ta

a

Q

Qu

ua

al

li

it

ty

y

cr

c

ri

it

ti

ic

ca

al

l

f

f

or

o

r

Bu

B

us

si

in

n

es

e

ss

s

C

Co

on

nf

fi

id

de

en

nc

ce

e

The quality of data within the enterprise is measured according to its reliability and validity; the completeness and accuracy of a data set. It is usually measured by comparing the data set to

another data set identified as the "gold standard", and assessing the level of agreement, thus creating a Master Record.

But, data being data, you are faced with the

following challenges:

B

B

u

u

s

s

i

i

n

n

e

e

s

s

s

s

D

D

r

r

i

i

v

v

e

e

r

r

s

s

 Data is highly fragmented, NOT

insightful, reliable, complete, consistent and accurate.

 Intensifying regulatory

requirements

 Multiple Versions of the same

reference data exists for different reporting environment?

 Lack of Information Standards

(Redundancy nightmare, Structural differences prevalent across disparate sources)

 Data load process overwrites the

results of others

 Cumbersome manual process to

consolidate data

Every Short-term, long-term, just-in-time Services

 Business Assessment & IT Strategy, Roadmap Services

 Data Warehouse/Business Intelligence/Master Data Management

 Experience -20+ years of solid Cross-Industry Experience (Commercial and Federal)

 Expertise - Data Integration and Business Intelligence Specialists  Past Performance - Managed huge

initiatives for Fortune-500 Companies

 Background - Extensive experience in Data and Project Management that involves IBM InfoSphere products for over 14 years ensures that the projects will be done right and on time with outmost dedication and professionalism

 Services – IT Assessment , Strategy and Roadmap, Data Warehouse, Enterprise Architecture, Data Integration, Data Migration, Master Data Management, Business Intelligence, Legacy Reengineering and

Consolidation, Application and Web Solutions, Data

Management, Risk Management and Project Management  IBM Premier Business Partner

(since 2000) –We specialize in InfoSphere Information Server brand and have over 14 years of extensive experience in IBM

product tools such as DataStage, QualityStage, Information Analyzer, Business Glossary, Metadata Workbench, CDC, Information Services Director, IBM MDM.

 Business Needs – We ask the right questions, anticipate challenges, share ideas and work for a better outcome

 High Quality of Deliverables - stemming from our standards and best practices. We are very passionate about our projects and take incredible pride in our deliverables.

 Cost Effective – coming from our years of practice and sound methodology allows us to provide rapid application agile development.

ARE YOU F ACI NG ISSUE S WIT H YOUR MDM/ ETL PROGRAM S DE VE L OPED W ITH I BM INFOSPHERE?

PROTE CT YOUR INVES TM ENT.

WE CAN HELP.

Today’s economy and business trends demand quick action and cohesive handshake among all business processes so that companies can understand the real benefits that are hidden underneath the guise of inaccurate and unreliable data spread across disparate systems and also due to business initiatives taking place such as citizens or corporate name changes, mergers and acquisitions, parent-subsidiary relationships, divestiture, splits, etc.

Businesses are faced with the immediate need to consolidate their data and integrate them so that immense value can be realized. Companies need to be able to work together in a unified environment so that Master Data

Management/Customer Data Integration can take place.

B

B

B

U

U

U

S

S

S

I

I

I

N

N

N

E

E

E

S

S

S

S

S

S

D

D

D

R

R

R

I

I

I

V

V

V

E

E

E

R

R

R

S

S

S



Issues with on-boarding clients?



Citizen/Customer Identification a costly redundant process?



No Trusted Source of Information.



Facing difficulty in consolidating and integrating your data?



Multiple versions of the same reference data for different

reporting environment?



Data load process overwrites the results of others?



Spend more time gathering data manually?



Significant amount of point-to-point integration?



Data quality issues are plenty?



Data Warehouse/Business Intelligence platform not yielding the

right results or you don’t have one?



No Data Governance in place?



No Master Data Integration Strategy in place?

Professional Development

•

•

•

D a t a S t r a t e g y

•

S t r a t e g y

•

•

D e s i g n / R e u s a b l e F u n c t i o n s

•

•

•

I n t e g r a t i o n

•

S c h e d u l i n g

•

S u p p o r t

•

AVS SYSTEMS, INC

IBM INFOSPHERE INFORMATION SERVER 9 Colt Circle West Windsor, NJ 08550 Ph: (609) 649-4174 Fax: (609) 228-1079 Email: info@avssystems.org