Exhibit 300 (BY2009) - Centers for Medicare and Medicaid Services (CMS) Data Management Operations - Beneficiary
PART ONE
OVERVIEW
- 1. Date of Submission:
- 2008-02-04
- 2. Agency:
- 009
- 3. Bureau:
- 38
- 4. Name of this Capital Asset:
- CMS Data Management Operations - Beneficiary
- 5. Unique Project Identifier:
- 009-38-01-02-01-1150-00
- 6. What kind of investment will this be in FY2009?
- Operations and Maintenance
- 7. What was the first budget year this investment was submitted to OMB?
- FY2007
- 8. Provide a brief summary and justification for this investment, including a brief description of how this closes in part or in whole an identified agency performance gap.
- This investment is for maintenance of the Medicare Beneficiary Database (MBD). The Medicare Beneficiary Database provides CMS with a singular, authoritative, database of comprehensive data on individuals in Medicare program to support ongoing and expanded program administration, service delivery modalities, and payment coverage options. This collection will contain a complete "beneficiary insurance profile" that reflects the individual's Medicare health insurance coverage and Medicare health plan and demonstration enrollment. This effort requires the integration and standardization of different types of beneficiary data that were previously fragmented and often redundant within isolated CMS legacy systems. Other agencies such as the states, RRB and SSA use MBD data to administer their programs. In addition, MBD data is relied upon by many federal oversight and law enforcement agencies, and hundreds of research projects sponsored by both federal and private research institutions. The MMA legislation significantly expanded the role of the MBD, as well as adding significant changes to the size and functions of the system. The MBD houses current and historical beneficiary data from 2000. MBD data includes beneficiary insurance profile data for over 60M beneficiary, who have been or are currently entitled to Medicare, are disabled and entitled to Medicare, or have End Stage Renal Disease. Maintenance supports continuity for the following fielded system functions: DATA SHARING-MBD centralizes the receipt and storage and protection of large quantities of data, manages entities accessing the data, and provides data to downstream systems. DUAL ELIGIBLES- MBD provides centralized receipt of low income determinations from SSA and the States, deems beneficiary that qualify as dual-eligible according to legislation, ensures low income beneficiaries are covered by identifying those that are uncovered and initiating an automated enrollment into a Plan, and provides critical information to the CMS areas responsible for coordinating the process with the beneficiary and the Plans. GUI/WUI-The MBD user interface provides beneficiary level data for CMS staff to respond to beneficiary issues. QUERY SERVICES-MBD provides online and batch views of Part D data to outside entities within the Part D network of systems.
- 9. Did the Agency's Executive/Investment Committee approve this request?
- yes
- 9.a. If "yes," what was the date of this approval?
- 2007-06-26
- 10. Did the Project Manager review this Exhibit?
- yes
- 11.a. What is the current FAC-P/PM certification level of the project/program manager?
- TBD
- 12. Has the agency developed and/or promoted cost effective, energy-efficient and environmentally sustainable techniques or practices for this project.
- yes
- 12.a. Will this investment include electronic assets (including computers)?
- no
- 12.b. Is this investment for new construction or major retrofit of a Federal building or facility? (answer applicable to non-IT assets only)
- no
- 13. Does this investment directly support one of the PMA initiatives?
- yes
- If yes, select the initiatives that apply:
Initiative Name Broadening Health Insurance Coverage through State Initiatives Expanded E-Government
- 13.a. Briefly and specifically describe for each selected how this asset directly supports the identified initiative(s)? (e.g. If E-Gov is selected, is it an approved shared service provider or the managing partner?)
- MBD reduces decision time by automating:data sharing, dual-eligible deeming, and data integrity checks. Provides single internet interface to plans & Part D entities for both MBD & payment systems. Centralizes receipt of low income determinations from SSA/States, deems dual-eligible benes, ensures low income benes covered by PartD by auto-enrolling the non-covered into plans.
- 14. Does this investment support a program assessed using the Program Assessment Rating Tool (PART)?
- yes
- 14.a. If yes, does this investment address a weakness found during the PART review?
- yes
- 14.b. If yes, what is the name of the PARTed program?
- 2003: CMS - Medicare Program
- 14.c. If yes, what rating did the PART receive?
- Moderately Effective
- 15. Is this investment for information technology?
- yes
- 16. What is the level of the IT Project (per CIO Council's PM Guidance)?
- Level 3
- 17. What project management qualifications does the Project Manager have? (per CIO Council's PM Guidance)
- (1) Project manager has been validated as qualified for this investment
- 18. Is this investment identified as high risk on the Q4 - FY 2007 agency high risk report (per OMB memorandum M-05-23)?
- no
- 19. Is this a financial management system?
- no
- 20. What is the percentage breakout for the total FY2009 funding request for the following? (This should total 100%)
Area Percentage Hardware 1 Software 87 Services 1 Other 11
- 21. If this project produces information dissemination products for the public, are these products published to the Internet in conformance with OMB Memorandum 05-04 and included in your agency inventory, schedules and priorities?
- no
- 22. Contact information of individual responsible for privacy related questions.
Name Maribel Franey Phone Number 410-786-0747 Title Director, Division of Privacy Compliance Data Deve (EDG) Email maribel.franey@cms.hhs.gov
- 23. Are the records produced by this investment appropriately scheduled with the National Archives and Records Administration's approval?
- yes
- 24. Does this investment directly support one of the GAO High Risk Areas?
- yes
SUMMARY OF SPEND
- 1. Provide the total estimated life-cycle cost for this investment by completing the following table. All amounts represent budget authority in millions, and are rounded to three decimal places. Federal personnel costs should be included only in the row designated Government FTE Cost, and should be excluded from the amounts shown for Planning, Full Acquisition, and Operation/Maintenance. The total estimated annual cost of the investment is the sum of costs for Planning, Full Acquisition, and Operation/Maintenance. For Federal buildings and facilities, life-cycle costs should include long term energy, environmental, decommissioning, and/or restoration costs. The costs associated with the entire life-cycle of the investment should be included in this report.
All amounts represent Budget Authority
Note: For the cross-agency investments, this table should include all funding (both managing partner and partner agencies).
Government FTE Costs should not be included as part of the TOTAL represented. Cost Type Py-1 & Earlier
-2006PY
2007CY
2008BY
2009Planning Budgetary Resources 0.000 0.000 0.000 0.000 Acquisition Budgetary Resources 0.000 0.000 0.000 0.000 Maintenance Budgetary Resources 40.587 21.800 22.684 31.184 Government FTE Cost 4.000 1.100 1.100 1.150 # of FTEs 10 5 4 4
- 2. Will this project require the agency to hire additional FTE's?
- no
PERFORMANCE
- Agencies must use the following table to report performance goals and measures for the major investment and use the Federal Enterprise Architecture (FEA) Performance Reference Model (PRM). Map all Measurement Indicators to the corresponding Measurement Area and Measurement Grouping identified in the PRM. There should be at least one Measurement Indicator for each of the four different Measurement Areas (for each fiscal year). The PRM is available at www.egov.gov. The table can be extended to include performance measures for years beyond FY 2009.
Row Fiscal Year Strategic Goal Supported Measurement Area Measurement Grouping Measurement Indicator Baseline Planned Improvement to the Baseline Actual Results 1 2006 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Productivity Expand MBD to support the percentage of MMA Low Income Subsidy and Part D enrollment MBD supports centralized beneficiary data and Drug Card enrollment functions Low Income Subsidy support operational by 8/1; Auto-assignment operational by 8/30; Part D enrollment in testing by 9/15 100% complete 2 2006 Effective Management of Human Capital/Information Technology/Resources Technology Internal Data Sharing Implement middleware to support number of on-line queries of beneficiary information, including 270/271 transactions and the ability of Customer Service Reps and Community Based Organizations to query MBD in real time DA/DBA functions support over 400 CMS databases Implement middleware to support query functions by 5/2005 100% complete 3 2006 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Implement middleware to support number of on-line queries of beneficiary information, including 270/271 transactions and the ability of Customer Service Reps and Community Based Organizations to query MBD in real time DA/DBA functions support over 400 CMS databases Implement middleware to support query functions by 5/2005 Implemented middleware to support query functions 4 2007 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Percent reduction in latency time for responding to eligibility queries for entitlement data 48 Hours 36 Hours TBD 5 2007 Effective Management of Human Capital/Information Technology/Resources Customer Results Response Time Time to respond to a 4Rx inquiry 24 Hours 12 Hours TBD 6 2007 Effective Management of Human Capital/Information Technology/Resources Technology Accessibility Average time the system is fully available to all system users during a 24 hour period (system uptime) 90% availability 91% Availability TBD 7 2008 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Percent reduction in latency time for responding to eligibility queries for entitlement data 36 Hours 24 Hours TBD 8 2008 Effective Management of Human Capital/Information Technology/Resources Customer Results Response Time Time to respond to a 4Rx inquiry 12 Hours 4 Hours TBD 9 2008 Effective Management of Human Capital/Information Technology/Resources Technology Accessibility Average time the system is fully available to all system users during a 24 hour period (system uptime) 91%availability 93% Availability TBD 10 2009 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Percent reduction in latency time for responding to eligibility queries for entitlement data 24 Hours 20 Hours TBD 11 2009 Effective Management of Human Capital/Information Technology/Resources Customer Results Response Time Time to respond to a 4Rx inquiry 4 Hours 3 Hours TBD 12 2009 Effective Management of Human Capital/Information Technology/Resources Technology Accessibility Average time the system is fully available to all system users during a 24 hour period (system uptime) 93% availability 95% Availability TBD 13 2010 Effective Management of Human Capital/Information Technology/Resources Customer Results Response Time Time to respond to a 4Rx inquiry 4 Hours 3 Hours TBD 14 2010 Effective Management of Human Capital/Information Technology/Resources Technology Accessibility Average time the system is fully available to all system users during a 24 hour period (system uptime) 95% Availability 97% Availability TBD 15 2011 Effective Management of Human Capital/Information Technology/Resources Customer Results Response Time Time to respond to a 4Rx inquiry 4 Hours 3 Hours TBD 16 2011 Effective Management of Human Capital/Information Technology/Resources Technology Accessibility Average time the system is fully available to all system users during a 24 hour period (system uptime) 97% Availability 98% Availability TBD 17 2012 Effective Management of Human Capital/Information Technology/Resources Customer Results Response Time Time to respond to a 4Rx inquiry 4 Hours 3 Hours TBD 18 2012 Effective Management of Human Capital/Information Technology/Resources Technology Accessibility Average time the system is fully available to all system users during a 24 hour period (system uptime) 98% Availability 98% Availability TBD 19 2005 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Productivity Expand MBD to support the percentage of MMA Low Income Subsidy and Part D enrollment MBD supports centralized beneficiary data and Drug Card enrollment functions Low Income Subsidy support operational by 8/1; Auto-assignment operational by 8/30; Part D enrollment in testing by 9/15 100% complete 20 2005 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Implement middleware to support number of on-line queries of beneficiary information, including 270/271 transactions and the ability of Customer Service Reps and Community Based Organizations to query MBD in real time DA/DBA functions support over 400 CMS databases Implement middleware to support query functions by 5/2005 100% complete 21 2005 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Implement middleware to support number of on-line queries of beneficiary information, including 270/271 transactions and the ability of Customer Service Reps and Community Based Organizations to query MBD in real time DA/DBA functions support over 400 CMS databases Implement middleware to support query functions by 5/2005 Implemented middleware to support query functions 22 2010 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Percent reduction in latency time for responding to eligibility queries for entitlement data 24 Hours 20 Hours TBD 23 2011 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Percent reduction in latency time for responding to eligibility queries for entitlement data 20 Hours 19 Hours TBD 24 2012 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Percent reduction in latency time for responding to eligibility queries for entitlement data 19 Hours 18 Hours TBD 25 2008 Effective Management of Human Capital/Information Technology/Resources Mission and Business Results System Maintenance Attain and maintain consistency in beneficiary data provided to CMS partners Implement 80% of partners Implement with 90% of partners by 01/2009 TBD 26 2009 Effective Management of Human Capital/Information Technology/Resources Mission and Business Results Information Management Enhance user interfaces for internal, external and common medicare environment Implement 80% Implement 90% TBD 27 2010 Effective Management of Human Capital/Information Technology/Resources Mission and Business Results Record Retention Percent increase in Data Archiving 75% increase 85% increase TBD 28 2011 Effective Management of Human Capital/Information Technology/Resources Mission and Business Results System Maintenance Attain and maintain consistency in beneficiary data provided to CMS partners Implement 90% of partners Implement with 95% of partners by 01/2011 TBD 29 2012 Effective Management of Human Capital/Information Technology/Resources Mission and Business Results Record Retention Percent increase in Data Archiving 85% increase 95% increase TBD 30 2013 Effective Management of Human Capital/Information Technology/Resources Processes and Activities Efficiency Percent reduction in latency time for responding to eligibility queries for entitlement data 18 Hours 17 Hours TBD 31 2013 Effective Management of Human Capital/Information Technology/Resources Mission and Business Results Record Retention Percent increase in Data Archiving 95% increase 97% increase TBD 32 2013 Effective Management of Human Capital/Information Technology/Resources Customer Results Response Time Time to respond to a 4Rx inquiry 3 Hours 2.5 Hours TBD 33 2013 Effective Management of Human Capital/Information Technology/Resources Technology Accessibility Average time the system is fully available to all system users during a 24 hour period (system uptime) 98% Availability 98.5% Availability TBD
Enterprise Architecture
- 1. Is this investment included in your agency's target enterprise architecture?
- yes
- 2. Is this investment included in the agency's EA Transition Strategy?
- yes
- 2.a. If yes, provide the investment name as identified in the Transition Strategy provided in the agency's most recent annual EA Assessment.
- CMS Data Management Operations - Beneficiary
- 3. Is this investment identified in a completed (contains a target architecture) and approved segment architecture?
- no
- 4. Identify the service components funded by this major IT investment (e.g., knowledge management, content management, customer relationship management, etc.). Provide this information in the format of the following table. For detailed guidance regarding components, please refer to http://www.whitehouse.gov/omb/egov/.
Component: Use existing SRM Components or identify as NEW. A NEW component is one not already identified as a service component in the FEA SRM.
Reused Name and UPI: A reused component is one being funded by another investment, but being used by this investment. Rather than answer yes or no, identify the reused service component funded by the other investment and identify the other investment using the Unique Project Identifier (UPI) code from the OMB Ex 300 or Ex 53 submission.
Internal or External Reuse?: Internal reuse is within an agency. For example, one agency within a department is reusing a service component provided by another agency within the same department. External reuse is one agency within a department reusing a service component provided by another agency in another department. A good example of this is an E-Gov initiative service being reused by multiple organizations across the federal government.
Funding Percentage: Please provide the percentage of the BY requested funding amount used for each service component listed in the table. If external, provide the funding level transferred to another agency to pay for the service. Row Agency Component Name Agency Component Description Service Type Component Reused Component Name Reused UPI Internal or External Reuse? Funding % 1 Audit Trail Capture and Analysis Audit Trail Capture and Analysis - Support the identification and monitoring of activities within an application, system, or network. Security Management Audit Trail Capture and Analysis No Reuse 5 2 Identification and Authentication Defines the set of capabilities that support obtaining information about those parties attempting to log on to a system or application for security purposes and the validation of those users. Security Management Identification and Authentication No Reuse 1 3 Access Control Access Control - Support the management of permissions for logging onto a computer, application, service, or network; includes user management and role/privilege management. Security Management Access Control No Reuse 8 4 System Resource Monitoring Defines the set of capabilities that support the balance and allocation of memory, usage, disk space and performance on computers and their applications. Systems Management System Resource Monitoring No Reuse 3 5 Process Tracking Defines the set of capabilities that allow the monitoring of activities within the business cycle. Tracking and Workflow Process Tracking No Reuse 2 6 Standardized / Canned Defines the set of capabilities that support the use of pre-conceived or pre-written reports. Reporting Standardized / Canned No Reuse 9 7 Ad Hoc Defines the set of capabilities that support the use of dynamic reports on an as needed basis. Reporting Ad Hoc No Reuse 9 8 Graphing / Charting Defines the set of capabilities that support the presentation of information in the form of diagrams or tables. Visualization Graphing / Charting No Reuse 4 9 Data Warehouse Defines the set of capabilities that support the archiving and storage of large volumes of data. Data Management Data Warehouse No Reuse 6 10 Data Recovery Defines the set of capabilities that support the restoration and stabilization of data sets to a consistent, desired state. Data Management Data Recovery No Reuse 5 11 Data Classification Defines the set of capabilities that allow the classification of data. Data Management Data Classification No Reuse 3 12 Data Mart Defines the set of capabilities that support a subset of a data warehouse for a single department or function within an organization. Data Management Data Mart No Reuse 1 13 Data Cleansing Defines the set of capabilities that support the removal of incorrect or unnecessary characters and data from a data source. Data Management Data Cleansing No Reuse 8 14 Meta Data Management Defines the set of capabilities that support the maintenance and administration of data that describes data. Data Management Meta Data Management No Reuse 3 15 Extraction and Transformation Defines the set of capabilities that support the manipulation and change of data. Data Management Extraction and Transformation No Reuse 7 16 Loading and Archiving Defines the set of capabilities that support the population of a data source with external data. Data Management Loading and Archiving No Reuse 8 17 Data Exchange Defines the set of capabilities that support the interchange of information between multiple systems or applications; includes verification that transmitted data was received unaltered. Data Management Data Exchange No Reuse 6 18 Data Integration Defines the set of capabilities that support the organization of data from separate data sources into a single source using middleware or application integration and the modification of system data models to capture new information within a single system. Development and Integration Data Integration No Reuse 10 19 Quality Management Defines the set of capabilities that help determine the level that a product or service satisfies certain requirements. Management of Processes Quality Management No Reuse 1 20 Configuration Management Defines the set of capabilities that control the hardware and software environments, as well as documents of an organization. Management of Processes Configuration Management No Reuse 1
- 5. To demonstrate how this major IT investment aligns with the FEA Technical Reference Model (TRM), please list the Service Areas, Categories, Standards, and Service Specifications supporting this IT investment.
FEA SRM Component: Service Components identified in the previous question should be entered in this column. Please enter multiple rows for FEA SRM Components supported by multiple TRM Service Specifications.
Service Specification: In the Service Specification field, Agencies should provide information on the specified technical standard or vendor product mapped to the FEA TRM Service Standard, including model or version numbers, as appropriate. Row SRM Component >Service Area Service Category Service Standard Service Specification (i.e., vendor and product name) 1 Data Exchange Component Framework Data Interchange Data Exchange COBOL 2 Data Exchange Service Interface and Integration Interoperability Data Format / Classification COBOL 3 Data Mart Service Interface and Integration Interoperability Data Format / Classification COBOL 4 Meta Data Management Service Interface and Integration Interoperability Data Format / Classification COBOL 5 Data Cleansing Service Interface and Integration Interoperability Data Format / Classification COBOL 6 Extraction and Transformation Service Interface and Integration Interoperability Data Format / Classification COBOL 7 Loading and Archiving Service Interface and Integration Interoperability Data Format / Classification COBOL 8 Data Classification Service Interface and Integration Interoperability Data Format / Classification COBOL 9 Data Exchange Service Interface and Integration Interoperability Data Transformation COBOL 10 Data Mart Service Interface and Integration Interoperability Data Transformation COBOL 11 Meta Data Management Service Interface and Integration Interoperability Data Transformation COBOL 12 Data Cleansing Service Interface and Integration Interoperability Data Transformation COBOL 13 Extraction and Transformation Service Interface and Integration Interoperability Data Transformation COBOL 14 Loading and Archiving Service Interface and Integration Interoperability Data Transformation COBOL 15 Data Classification Service Interface and Integration Interoperability Data Transformation COBOL 16 Meta Data Management Component Framework Data Management Database Connectivity DbVisualizer 17 Data Cleansing Component Framework Data Management Database Connectivity DbVisualizer 18 Extraction and Transformation Component Framework Data Management Database Connectivity DbVisualizer 19 Loading and Archiving Component Framework Data Management Database Connectivity DbVisualizer 20 Graphing / Charting Service Platform and Infrastructure Software Engineering Modeling ERwin Data Modeler 21 Data Warehouse Service Platform and Infrastructure Database / Storage Database IBM DB2 22 Data Recovery Component Framework Data Management Database Connectivity IBM DB2 23 Process Tracking Component Framework Business Logic Platform Independent IBM WebSphere MQ 24 Data Exchange Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 25 Data Mart Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 26 Meta Data Management Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 27 Data Cleansing Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 28 Extraction and Transformation Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 29 Loading and Archiving Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 30 Data Classification Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 31 Data Classification Service Access and Delivery Delivery Channels Intranet Java 2 Enterprise Edition 32 Data Exchange Component Framework Data Management Database Connectivity Java Database Connectivity 33 Data Mart Component Framework Data Management Database Connectivity Java Database Connectivity 34 Data Classification Component Framework Data Management Database Connectivity Java Database Connectivity 35 System Resource Monitoring Service Access and Delivery Service Requirements Legislative / Compliance Microsoft Office Access 36 Ad Hoc Component Framework Data Management Reporting and Analysis Microsoft Office Excel 37 Standardized / Canned Component Framework Data Management Reporting and Analysis Microsoft Office Excel 38 Access Control Service Access and Delivery Service Requirements Legislative / Compliance Microsoft Project 39 Audit Trail Capture and Analysis Service Access and Delivery Service Requirements Legislative / Compliance Microsoft Project 40 Identification and Authentication Service Access and Delivery Service Requirements Legislative / Compliance Microsoft Project 41 Configuration Management Service Platform and Infrastructure Software Engineering Software Configuration Management MKS Toolkit 42 Access Control Component Framework Security Supporting Security Services Sun Identity Manager 43 Audit Trail Capture and Analysis Component Framework Security Supporting Security Services Sun Identity Manager 44 Identification and Authentication Component Framework Security Supporting Security Services Sun Identity Manager 45 Quality Management Service Platform and Infrastructure Software Engineering Test Management Time Sharing Option 46 Data Integration Service Access and Delivery Access Channels Web Browser Windows Internet Explorer 47 Data Integration Service Access and Delivery Access Channels Web Browser Windows Internet Explorer
- 6. Will the application leverage existing components and/or applications across the Government (i.e., FirstGov, Pay.Gov, etc)?
- no
PART THREE
RISK
Answer the following questions to describe how you are managing investment risks.
- 1. Does the investment have a Risk Management Plan?
- yes
- 1.a. If yes, what is the date of the plan?
- 2007-03-22
- 1.b. Has the Risk Management Plan been significantly changed since last year's submission to OMB?
- no
COST & SCHEDULE
- 1. Was operational analysis conducted?
- no
- 1.a. If yes, provide the date the analysis was completed.
- 2007-08-15
- What were the results of your operational analysis?
- The MBD is meeting, and is expected to continue to meet projected milestones, and the MBD remains within a 10% variance for the planned O&M costs compared to actual O&M costs. We regularly meet with customers on developing expectations. Customers are and will continue to be involved in both refining metrics parameters, and in a feedback loop towards future performance and quality.
- 1.c. If no, please explain why it was not conducted and if there are any plans to conduct operational analysis in the future.
- Not Applicable.





