1 / 41

Advanced Data Integration - Business Case for Success

Advanced Data Integration - Business Case for Success. Presented By: Allan Sonkin – Project Manager, Blackboard Consulting Kent Leonard – Director, Blackboard Consulting. Tuesday, April 12, 2005 2:00pm - 3:15pm. A word from our lawyers….

carsyn
Download Presentation

Advanced Data Integration - Business Case for Success

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Advanced Data Integration - Business Case for Success Presented By: Allan Sonkin – Project Manager, Blackboard Consulting Kent Leonard – Director, Blackboard Consulting Tuesday, April 12, 20052:00pm - 3:15pm

  2. A word from our lawyers… • Any statements in this presentation about future expectations, plans and prospects for Blackboard and other statements containing the words "believes," "anticipates," "plans," "expects," "will," and similar expressions, constitute forward-looking statements within the meaning of The Private Securities Litigation Reform Act of 1995. Actual results may differ materially from those indicated by such forward-looking statements as a result of various important factors, including the factors discussed in the "Risk Factors" section of our most recent 10-K filed with the SEC. In addition, the forward-looking statements included in this press release represent the Company's views as of April 11, 2005. The Company anticipates that subsequent events and developments will cause the Company's views to change. However, while the Company may elect to update these forward-looking statements at some point in the future, the Company specifically disclaims any obligation to do so. These forward-looking statements should not be relied upon as representing the Company's views as of any date subsequent to April 11, 2005. Blackboard, in its sole discretion, may delay or cancel the release of any product or functionality described in this presentation.

  3. Opening Slide • Session Objectives: • Integration Technology • Implementation Process • Defining The Value • Innovation • Maturity of the ADI Technology & Experience • Results/Outcomes • Client Case Studies

  4. Integration Technology Better Integration is Possible

  5. Networked Transaction Environment™

  6. A User’s Perspective of theNetworked Transaction Environment Residential Life Securely enters and leaves facilities BbOneSM Local merchants acceptUniversity ID Card as payment The Online Campus Check your account balance, order items online Bookstore Purchase goods and services Campus Activities Purchase game tickets Parking Pay for garage fees Food Service Cafeterias and vending machines

  7. Stumbling “Blocks” Multiple Interfaces + Vendor confusion + Unrealized ROI + Dead ends  Support Issues ________________________ Ubiquity challenge

  8. THIRD PARTY STRATEGY =

  9. Systems Integration • Two categories • Transaction Integration • Transaction Integration Agent (TIA) • Point to Point Interface • Financial Information $ • TIA Host • Data Integration • Data Integration Agent (DIA) • Database Integration • ASCII Data • Building Blocks™ Manager

  10. Transaction Integration 3rd Party Point of Sale Blackboard Transaction System™ 3rd Party Server Transaction Integration Agent Blackboard Building Blocks Application • Third Party Point of Sale Systems • Campus Bookstore • Campus Convenience Stores • Controlled Printing • Fee Payment • Parking Solutions • Arena Concession • Print Management

  11. Data Integration Data Information Blackboard Transaction System Data Integration Agent Data Integration Agent Blackboard Building Blocks Application • Student Information Systems • Door/Event Access Systems • Residential Management Systems • Video Imaging Systems • Blackboard Community System

  12. Blackboard Transaction System Flexibility and Extensibility $ $ Data Blackboard Community System™ Blackboard Learning System™ Data Data Data Data Student Information Systems Blackboard Building Blocks Application Video-Imaging Data $ $ Bookstores, 3rd Party Transactions Residential Management Print/Copy Management

  13. ADI Process and Methodology Building Quality Tools & Documentation

  14. Advanced Data Integration Process Document, Design, Build, Test & Support Technical Design Business Rules & Data Mapping Configuration & Integration Testing & Production Ongoing Support Project Management

  15. Technical Design Business Rules & Data Mapping Configuration & Integration Testing & Production Ongoing Support • Documentation of the business requirements of the various stakeholders in the system • Identify Desired Data • Locate Databases • Unique Users • Multiple Data Sources • Identification of the rules which govern the relationship between data on various systems • Duplicate Records • Privacy

  16. Types of Data to Exchange Other POS/ POA Systems Card Production Privilege Data Card Data Transaction Data Update Blackboard Transaction System Add Delete SIS/HR People Data Privilege Data Blackboard Building Blocks Application Transaction Data Translate Advanced Data Integration provides the ability for the automatic and near real-time update of people, card, privilege and transaction data between systems on campus ensuring the effective management of campus business requirements and rules.

  17. Technical Design Business Rules & Data Mapping Configuration & Integration Testing & Production Ongoing Support • For each data type, identify: • Rules of exchange • Data Management • Master data source, permissible updates • Event Triggers (Translation) • Based on data exchanged, what events need to occur • E.g., Student no longer enrolled  card deactivated; student assign to dorm a  assign privilege a, plan b • Timeliness • Who set the rules (authoritative oversight)? • Who manages/reconciles the exchange?

  18. Technical Design Business Rules & Data Mapping Configuration & Integration Testing & Production Ongoing Support • Technical design • Data Flow • Data ownership • Integration Tools • Blackboard Building Blocks Manager & Integration Agents • Blackboard Extract • Custom Scripts • File Exchange (format, locations) • Third-Party Systems • File Exchange (format, locations) • System Administrator

  19. Technical Design Business Rules & Data Mapping Configuration & Integration Testing & Production Ongoing Support • The technical design of the advanced data integration is then used as the basis for the configuration of the Blackboard Building Blocks Manager (Integration Agents) • In cases where Blackboard Building Blocks Manager cannot fulfill the Business Rules, integration customization services are performed

  20. Technical Design Business Rules & Data Mapping Configuration & Integration Testing & Production Ongoing Support • Testing Plan • Launch Sequence • Approval and Sign-off

  21. Technical Design Business Rules & Data Mapping Configuration & Integration Testing & Production Ongoing Support • Documentation • Hand-Off Call • Integration and Customization Support for Advanced Data Integration • Information and Support Requests

  22. Advanced Data Integration Experience Work Smarter Not Harder

  23. Project Overview (part 1)

  24. Project Overview (part 2)

  25. The ADI Toolbox • Blackboard Consulting Proposal • Kick-Off Call Agenda • Project Plan • Data Collection Worksheets • Data Flow Diagram • I&C Profile • The ADI Planning Workbook

  26. Advanced Data Integration Planning Workbook

  27. Field Mappings

  28. Translation Definitions

  29. Blackboard Building Blocks Manager

  30. Live Viewer

  31. Reports

  32. Reports

  33. Integration Examples

  34. Data Flow

  35. Data Flow

  36. A Platform for Campuswide Expansion and Integration Client Objective • Replace legacy General Meters system • Develop automated connectivity between Blackboard Transaction System, Colleague SIS and Siemens Access on campus Blackboard Delivery • Implemented core system and dining modules • Establish business-rule based near real-time integration with SIS and Access System using Blackboard Building Blocks Client Outcomes • Upgraded commerce program with a platform for phased expansion • Ability to automatically update cardholder status and cards issued

  37. Advanced Integration of Three Campuses and Many Systems Client Objective • Replace Diebold system that had reached its limit • Provide integration with financial, department and retail systems Blackboard Delivery • Implemented automated integration with Athletics, Bookstore, Parking, Payroll, and Micros systems • Developed customized integration of account balances with My UW portal environment Client Outcomes • Replaced previous system and custom integration in roughly 6 weeks • Automated management of athletic debit funds to ensure NCAA compliance

  38. Building New Revenues by Simplifying Accounts Client Objective • Give students more flex spending choices on and off campus • Desire to tightly manage conversion to single account with increased deposits capability Blackboard Delivery • Business analysis, planning, change management controls, and system reconfiguration services Client Outcomes • Smooth and timely delivery of account reconfiguration • 35% overall increase in deposits and commission revenue

  39. Web-based Meal Plan Changes Client Objective • Eliminate the problems associated with processing hundreds of meal plan changes during the first month of the semester Blackboard Delivery • Integrate web-interface with the Transaction System to obtain existing meal plan data • Process necessary change in Transaction System including update of privileges, plans and account balances Client Outcomes • Elimination of long lines and wait times for students who want to change meal plans • Elimination of manual efforts required of office staff to calculate and process required account change

  40. General Ledger Integration Saves Countless Hours of Work Client Objective • Eliminate manual reporting and accounting processes that required significant effort each month Blackboard Delivery • Developed a web interface tool to automate merchant disbursement • User interface provides for user authentication and report configuration • Data file creation integrates with GL system via automatic file transfer Client Outcomes • Elimination of 24 to 36 person days of effort annually (disbursement compilation, authorization, error resolution) • Ability to expand vendor and merchant base without adding more accounting staff

  41. Advanced Data Integration - Business Case for Success • Innovating Together in ‘05: • There is great value to moving toward the Networked Transaction Environment • A key component of which is seamless system integration • Blackboard has developed the Blackboard Building Blocks Program to facilitate that integration • Blackboard Consulting has developed services to help campuses successfully implement and manage that integration • Resources Available: • Blackboard Web Site - http://www.blackboard.com/ • Follow up Contact(s): • Blackboard Sales Engineers 800-929-4244: Michele Neyers x2469, Duane Dalager x 1145, Paul DuBois x 2295 • Kent Leonard, Director of Blackboard Consulting, Blackboard Commerce Suite™, kleonard@blackboard.com, x2492 • IF YOU ONLY REMEMBER 1 THING: • Blackboard has the tools and expertise to integrate your campus, take advantage of it.

More Related