Company - Advanced InSite, Inc

bubblesradiographerΔιακομιστές

4 Δεκ 2013 (πριν από 3 χρόνια και 8 μήνες)

88 εμφανίσεις

1

Advanced InSite


Data Management Toolset


Presentation to [Company]

[xx/xx/xx]

2

Agenda


Introduction to Advanced InSite


Overview of Services / Scope of Work


Preview the Application


Roles & Responsibilities


Qualifications


Assumptions


Next Steps

3


A Tennessee Corporation located near Nashville, Tennessee


During the last 10 years Advanced In
-
Site has serviced companies
such as Bridgestone/Firestone, RR Donnelly, Ingersoll Rand,
SC Johnson, Dollar General, Columbia HCA, Deloitte & Touche
and other clients in various market segments.


Advanced In
-
Site service delivery model is a Distributed Work
environment


We will come to you site for a one day introduction, discussion and small demo for you to see.


We arrive for a second time onsite visit in which we will install the product and provide a Train the
Trainer session.


All maintenance is provided via VPN access. If a further onsite visit is required to resolve a
technical issue, an Advanced In
-
Site employee will be available for an additional onsite visit.


We would ask for an email account on your own internal email system to expedite communications
if that were feasible within your security charter.

Who is Advanced InSite?

4

Data Quality Objective & Scope of Work


Objective


Provide a cost
-
efficient, web based method to evaluate and
improve data quality prior to loading SAP data


Scope of Work


Develop data analysis test plan to evaluate and measure data
quality


Develop and execute data analysis process to evaluate the
quality of legacy data


Review data analysis results, categorize root cause analysis


Implement and monitor corrective actions


Prepare data for load and provide post
-
conversion support


Step 1

Develop
Specification
s

Step 2

Perform
Data
Analysis

Step 3

Perform
Data
Cleansing

3 to 6
iterations
per file

5

Data Cleansing Objective

Perform

Data Cleansing

Optional: Convert

Legacy codes to

SAP Codes

Review Integrity Tests

Review

Unit Test Data

Test Integrity of

Load Data


Cleansing Application Import Legacy data


Import map and format of data is dynamic and provides
Meta
-
data in Documentation section of application


Conversion of Legacy to SAP Codes (optional)


Conversion or Lookup tables provide immediate conversion


Data Cleansing and Manipulation


Conversion or Lookup tables provide immediate conversion


Data Integrity Tests (recorded for historical review)


Produces SAP Load files


Results of Integrity Tests and Unit Test data available through
Corporate Intranet (immediately)


Imports

Legacy Files

Produce SAP

Load Files

6

Preview the Application

Record of every
previous load


Load= Import
Legacy Files,
cleanse convert,
run through each
test, create output
files.

-

And the result of
the Load. Click on
** to view details
of any load

View Routines
(otherwise known
as conversions or
manipulations of
data once
imported.) specific
to this Load

Chose a Load which
is specific to a Wave /
Country Combination

Navigate to:


Load Specific
Activities such as
Import specs,
Mappings, Tests,
etc.

Options not
specific to a
Load


for
example System
Tables (tables
that are used
across Loads for
manipulation of
data.

7

Tests specific to a Load

Link to the details of the
Test (Name of the Test,
Category, Destination
Screen, etc)

View the results of
the latest Test activity

(see next slide)

Allows you to see the
count of the latest
Failures for this Test

-

Click on the link to
view

the Results

8

Test Results

Which if any Output
Fields are tied to this Test

Shows the User which if
any Lookup tables are
used on this Test (works
the same on Routines)

Allows the user to view
the numbers of failures
and the number of
records that were tested
and if any corrective
action was taken

User may record what if
any corrective action was
taken in regards to the
failures of this test

9

Cleansing Tool includes the following Tests


Cleansing Tool includes over 300 inherent tests


Tests are categorized:


Missing Values


Incorrect Field Values


Codes not aligned with Parent


Incorrect Dependent Values


Value not found within Configuration tables


Unacceptable Field Format


Unacceptable Field Range


Value exceeds Field Length


Value not found within Lookup Table


Not all tests will be applicable to your Install


Each test is associated with a specific SAP Screen/Field



Removing Duplicates can be implemented


Etc.

10

Lookup Tables

Lookup tables allow Users to develop and maintain data
used either for Tests or Routines. For example, a Test
may attempt to locate records with invalid Characters in
the Name field. Several Tests and routines can utilize
the same Lookup Table. This table allows the invalid
Characters to be documented and maintained by the
very users responsible for the output (not programmers)

Users may add additional records to the Lookup Table.
They may delete or Edit the records also.


Links are provided to navigate to the Lookup Table from
the Routine, Test or Output field.

11

Technical Requirements for Cleansing Tool


Internally Developed Components


Intranet Web Site


Intranet Web Service


SQL Server Database



External Software utilized


Microsoft SQL Server


Microsoft IIS Web Server



System Access


Company X VPN access for development, etc.

12

Approach to Implementation

1) Input feed formats must be provided along with sample files

Feed formats = position/length/data type from flat files

Subsection of data

2) Company X technical group will provide access to your Network via
Internet VPN.

3) Company X technical group will provide access to new Database
and IIS Web Directory

4) Advanced InSite will provide a detailed list of existing Customer,
Vendor

and Material Tests. Company X will provide a detailed list of
additional tests needed for go
-
live.

5) Advanced InSite will produce database content and Web Site for
Company X

13

Skill Sets and Supporting Structure


Subject Matter Representative


Company X representative knowledgeable with Data being loaded


Backup individual is key in case primary individual is not available


1 business day response is required


“In House” Technical Representative


A Company X representative familiar with the Technical structure that
has needed authority (permissions) to facility any needed modification
to Database, Web or Com+ Server.


Individual response required within 4 hours during business hours.


Database Administrator


An Advanced InSite employee that has have working knowledge of
Cleansing Tool database (Microsoft SQL Server 2000).


Web (Microsoft Active Server Pages) Developer


An Advanced InSite employee that has working knowledge of Cleansing
Tool’s web structure. Must be familiar with Active Server technology.




14

Pricing Structure


Core Application


Fee can be based upon the number of Loads/Countries or Flat fee


Cost can only be provided after initial assessment


Incremental tests added


100 Tests configured per Load


Flat fee of $50 per test after initial 100


Monthly Maintenance


$600/month at 120 days after installation or First Go Live


Application Development or Enhancements


$80/hr.


Development Assumptions in Pricing structure


Development DB


Quality Assurance DB


Production DB


15

How to Contact


Chad Guisewite


Advanced Insite


PO Box 153


White House, TN 37188


1.615.566.6666


Chad@AdvInSite.com


-
www.AdvInSite.com