1 / 16

CENTRAL STATISTICS OFFICE IRELAND ITSIP PROJECT OVERVIEW

CENTRAL STATISTICS OFFICE IRELAND ITSIP PROJECT OVERVIEW. IT Director’s Meeting – Luxembourg 21 October 2004. BEGINNINGS. Processing mainly on VAX mainframe Out of date Legal requirement to Open Systems 1999 IT Strategy ‘Islands of data’ inefficient Too many applications

belldavid
Download Presentation

CENTRAL STATISTICS OFFICE IRELAND ITSIP PROJECT OVERVIEW

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. 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

More Related