Advanced InSite Data Management Toolset

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. Who is Advanced InSite? • 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.

4. Step 1 Develop Specifications Step 2 Perform Data Analysis Step 3 Perform Data Cleansing 3 to 6 iterations per file 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

5. Data Cleansing Objective • 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) Optional: Convert Legacy codes to SAP Codes Imports Legacy Files Perform Data Cleansing Test Integrity of Load Data Review Integrity Tests Review Unit Test Data Produce SAP Load Files

6. Preview the Application Chose a Load which is specific to a Wave / Country Combination 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 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. View Routines (otherwise known as conversions or manipulations of data once imported.) specific to this Load

7. Tests specific to a Load View the results of the latest Test activity (see next slide) Link to the details of the Test (Name of the Test, Category, Destination Screen, etc) Allows you to see the count of the latest Failures for this Test - Click on the link to view the Results

8. Test Results User may record what if any corrective action was taken in regards to the failures of this test Allows the user to view the numbers of failures and the number of records that were tested and if any corrective action was taken 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)

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