CENTRAL STATISTICS OFFICE IRELAND ITSIP PROJECT OVERVIEW

1. CENTRAL STATISTICS OFFICEIRELANDITSIP PROJECT OVERVIEW IT Director’s Meeting – Luxembourg 21 October 2004

2. BEGINNINGS • Processing mainly on VAX mainframe • Out of date • Legal requirement to Open Systems • 1999 IT Strategy • ‘Islands of data’ inefficient • Too many applications • Data Management Strategy • Further analysis • Corporate Data Model • Fewer and better applications • ITSIP • Information Technology Strategic Implementation Programme

3. DMS Logical Model • System Comprises Four Databases • Two micro-data databases • Input (Data Capture, Validation, Edit, Imputation) • Clean Unit Data Repository • Two macro-data databases • Aggregation • Dissemination (Publication) • Metadata associated with these databases • Incorporates Register and Survey Management • Metadata driven

4. CORPORATE DATA MODEL - Data Flow Respondent Management Seasonal Data Capture Adjustment Imputation Aggregation Dissemination Input Clean Unit Aggregate Disseminate

5. ITSIP PROJECT STAGES • Stage A (Oct 2002 to Apr 2003) • Requirements specification and high-level architectural design • Stage B (Nov 2003 to Apr 2006) • Detailed design, build and implementation • Go Live 2 May 2006

6. STAGE A OUTCOMES • High-Level Design of Architecture • Functional Design of Applications • Associated Conceptual Database Models and Designs • Migration Plan • Report on WWW Potential

7. DATA MANAGEMENT SYSTEM (DMS)

8. Register Management Data Capture Select Register Data Entry Form Set-Up Search Register Duplicate Search Select Form/Period Create Survey Instance Unit Details Edit Summary Select Coding Type Unit Details Duplicate View CorrectionComment Form Summary File Definition Data Entry/ Correct Data Edit Report Associated Surveys Coding Correction History Imputation Variable Group Set-Up VariableGroup Summary Edit Rule Summary Select Survey /Period Batch Summary View Form Data Detailed Report Sample Selection Select Survey Variable Details CARS Set-Up Variable Edit Rule Set-Up Validation Set up Imputation Cells Set Up Imputation Rules RunImputation Sample Selection Criteria Derived Variables Exclude from Sample Include in Sample CARS LVCF View Imputation Results Set-up Strata Cells Sample Proportions Aggregation Set Up Imputation Cell Merge Settings Time Series Enter Survey/Period Unit Details Nearest Neighbour Direct Imputation Selected Sample (Conditional Census or Random) Stratum Average Exclude Records Set UpAggregation SnapShot ofInput Database Run Aggregation View Rule Summary Survey Management CARS Select Survey/Period Set Up Group Define Aggregate Set Up Aggregate Table View Aggregate Results SetUpPostOut Items Receipting ResponseTracking Follow Up Detail Basic Aggregate Seasonal Adjustment AggregationResults Complex Aggregate Set Up Macro Edits Confidentiality Rules for Aggregate Set Up Weights Seasonal Adjustment Define Relative Postout DetailedReport View Non-Respondents Comments Define Mean Drill Down Rescale Index View Graph Set-Up Seasonal Adjustment Run Seasonal Adjustment Update New Index Weights RecipientList View Results Data Summary Dissemination Respondent Management SelectRespondent View Graph Create Disseminate Tables Footnotes Populate Disseminate Database Timeliness Monitor Extract Disseminate Data CARS ComplianceHistory Survey Instance List Copy Aggregate Data Timeliness Overview Select Facts Disseminate Table Footnote Links Footnote Details View Form Data Report Select Classifications Table Timeliness Data Column Meta Data

9. Respondent Management SelectRespondent • Provides cross-survey view of form data submitted to the CSO • Provides cross-survey view of compliance history of a unit ComplianceHistory Survey Instance List Details View Form Data Report

10. STAGE B REQUIREMENTS • Detailed design • Specify and install infrastructure • Gather data & process migration information required • Build applications (and overall DMS) • User Training • UAT • Migrate business areas’ data & processes • Implement DMS • First Year Maintenance

11. Project Organisation • Contractor: Cognizant Technology Solutions • On-shore off-shore model • On-shore • Fifteen CSO personnel • Six CTS personnel • Off-shore • Twenty – Thirty developers in Chenai, India

12. Project Management • Project Managers • CSO on shore • CTS on shore • CTS offshore • Shared Lotus Notes Database, replicated between Cork and Chennai • Weekly teleconference beween Cork & Chennai

13. OUTLINE PLAN Start-up System Requirements Analysis Increment 1 Increment 2 Increment 3 Integration & System Testing Delivery Acceptance Testing Implementation 0 12 24 36 Project Month

14. DEVELOPMENT/TEST ENVIRONMENT

15. MAIN SOFTWARE TOOLS • Microsoft Windows A/S Server - OS • Microsoft Visual Studio Desktop - Development • Sybase ASE 12.5 Server - Database • Sybase IQ 12.5 Server - Database • BEA Systems Weblogic 7.1 Clustered Server - Application Server • Informatica Power Center 6.2 Server Server - Data Migration • Informatica Power Center 6.2 Client Desktop - Data Migration • JAVA Swing Application (Sun Java Studio)/J2EE

16. E N D