Case Studies - Government

	Client:   Idaho National Lab. / Battelle Energy Alliance Project: EA Services Type:   Enterprise            Architecture	CRI is providing enterprise architecture services to the Idaho National Laboratory (INL) to support the development of their Next Generation Network (NGN). The INL is a federally funded national energy and waste research facility encompassing 890 square miles.  Ultimately, the Enterprise Architecture (EA) will capture not only the concept of the technological infrastructure, but it will capture the vision of the entire Laboratory including all elements of business planning (goals, visions, strategies), and operations (organizations structures, processes, and data).  CRI completed a review of existing INL long term IT and network objectives and a complete review of INL’s current network infrastructure.  A phased approach for the implementation of the new Enterprise Architecture is currently underway at the INL. The new  EA Framework will satisfy federal and security guidelines, and US Department of Energy (DOE) directives using an architectural approach.  CRI’s service deliverables include: ·         Aligning INL network configuration with long-term objectives ·         Refining network segmentation and configuration ·         Reviewing/revising/developing a phased network design ·         Developing and assisting in the implementation of an Enterprise Architecture plan for the INL ·         Providing security architecture services ·         Providing complete documentation
	Client:   California Cancer Registry – University of California, Irvine Project: Database Design and Management Project	The California Cancer Registry (CCR) is a repository that tracks all cancer cases in the State of California. Affiliated with University of California-Irvine, the CCR data is used to determine funding for research and focus on various geographical areas and demographics which exhibited a high incidence of disease. The CCR wanted to create a web-based system of data collection that enabled data scrubbing, assimilation, validation and storage with access allowed to all concerned parties. This goal was supported by the Center for Disease Control (CDC) and National Institutes of Health (NHI). The old system was disorganized, ineffective for research, and data was not available to all regions.  CRI Advantage provided a detailed architectural design and use case analysis to CCR. The new data management system was based on Microsoft’s DNA architecture and product lines. SQL Server 2000 runs the database. Data transportation occurs in XML, which lends itself to object-oriented design and storage. By using XML for memory object storage, underlying data structure changes could be made without affecting the object code. Business objects were written in Inprise Delphi to interact with Microsoft Transaction Server. The user interface was coded in Active Server Pages using JavaScript which is served by Microsoft InternetInformation Server 5.0. Client-side scripting was done in DHTML, DOM and JavaScript. CRI’s n-tier web-based data management system provides instant information access to researchers in all nine regions. The system allows users to drill down to very specific parameters and to make decisions based on data that is current. The system streamlined CCR’s core processes of data accumulation, data quality control and data assimilation. As a result, data entry personnel increased their efficiency by 50 percent and IT staff can focus on assisting researchers instead of controlling data issues. Web-based tools were created to allow the CCR staff to make changes to the system –add import and export file formats, change edit rules and logic, and add or optimize linking logic. Workload and timeliness statistics are captured in reports that allow managers to see where issues may occur, thus improving organizational performance.
	Client:   Idaho Air National Guard Project: Inventory and Equipment Management System Application Development	CRI Advantage (CRI) was contracted by the Idaho Air National Guard (IANG) to convert IANG’s extensive Inventory and Equipment Management System (IEMS) from Microsoft Access to a SQL Server Database with web-based interface.   The project also required the development of an integrated reporting application capable of meeting all the requirements of the military audit process. IANG’s existing MS Access system was utilized for all military purchasing, receiving, general ledger accounting, facility management, and work order scheduling. IANG sought a new platform which would be less expensive to manage then their previous configuration based on MS Access.  Military auditing teams reviewed the functionality of all deliverables. The Idaho Air National Guard site in Boise, ID was the first to test, approve, and fully utilize the new IEMS system and web-based application. Currently the system is being utilized at 125 additional Air National Guard sites across the USA, including stations in Iraq and Afghanistan. The Idaho Air National Guard must fulfill extensive reporting requirements to BOTH federal and state agencies.
	Client:    Idaho National Lab. / Battelle Energy Alliance Project:    Security Remediation Audit Prep.	CRI was contracted by the Idaho National Laboratory in eastern Idaho to assist them in preparation for an audit by the Office of Oversight and Administration within the U.S. Department of Energy (DOE).  DOE originally conducted an audit an INL which identified specific areas of concern and vulnerability as it relates to Cyber Security and segmentation at INL. This audit has resulted in a project plan to achieve best practice policy and architecture within the Lab. DOE hired CRI to help them pass a second audit to review compliance with measures identified earlier.    CRI has dispatched a core 5 person team to ensure INL is in compliance with all DOE directives and will successfully pass the second audit.  CRI consultants have made substantial contribution at the INL to improve in the following areas: Asset Management Certification Accredidation Change Management Cybersecurity Governance Model Minimum Security Configuration Network Infrastructure Improvement Patch Management Policy, Procedures, and Awareness PCSP Evaluation and Gap Analysis Quarantine Management Requirements Management Vulnerabilities Scanning Vulnerability Management These areas are key to ensure that the INL passes the OA audit to be held early in 2008.
	Client:    Idaho National Lab. / Battelle Energy Alliance Project:    Security Assessment	CRI was contracted to provide an independent assessment of the Idaho National Laboratory (INL) current and future network infrastructure and provide recommendations to remediate problems. This was designed to review a network infrastructure plan to accommodate increased demand for access to information with essential security measures and protection. CRI was responsible for:  Reviewing existing INL long-term IT and network objectives as well as INL’s current network configuration; Conducting on-site interviews with key INL personnel and collect data; Based on the results of this review and the on-site interviews, developing recommendations to be summarized in a final report; Presenting findings and recommendations to Battelle senior management in the form of a final report and formal presentation.
	Client:        Idaho Dept of Education Project:   ISIMS Portal Dev.	CRI designed and implemented an Identity Management solution for the Idaho Student Information Management System (ISIMS), an attempt at the country’s first statewide student information system. The primary goal was to use technology to improve individual student achievement by providing access to timely, relevant and appropriate information for all education stakeholders in a secure environment.   ISIMS was developed as a secure web-based, centrally hosted and managed state-wide solution. CRI designed the single sign on integration with third party web based applications.    Netegrity Siteminder was integrated with Oracle 10G Portal SSO as part of the solution. CRI provided expertise in architecture and all aspects of security including host, physical, datacenter, network and policies. Deliverables included: Analysis and design documentation providing User Role mapping to application functions and definition of access privileges Integration of Oracle 10G SSO (Single Sign-On) with Netegrity Siteminder Policy server Developed custom web agent for SiteMinder api integration Development of portal landing pages for core application launch (SSO) LDAP design and implementation using Oracle OID Developed security policies and procedures that were adopted by the State of Idaho Database design for custom application integration to portal 10G application server installation Designed an extremely secure Oracle 10G based data warehouse using Oracle Label Security (OLS) and Virtual Private Databases (VPD)
	Client:   U.S. Dept. of Interior, Bureau of Reclamation Project: Active Directory Migration and Deployment	CRI provided senior system analysts to support the U.S. Bureau of Reclamation’s Boise, ID office in migrating to a Microsoft-centric information technology environment, following the lead of the U.S. Department of the Interior.  The goal of the migration project was to develop, test, and implement a migration from the current environment to an environment using Microsoft and Unix/Linux servers, with Active Directory providing authentication and directory services, SMS managing configurations, MS Exchange used for email and groupware, and MOM used for central monitoring of the infrastructure and servers.
Tanana Chiefs Conference	Client:   Tanana Chiefs Conference Project: Migration to Linux Platform and Oracle Database	CRI completed a platform migration project for the Tanana Chiefs Conference, a tribal consortium of 42 villages in interior Alaska. The Tanana Chiefs provides a unified voice advancing Alaskan tribal governments, economic and social development, educational opportunities, and cultural values. CRI migrated the Tanana Chiefs technology infrastructure and data to a Linux/Oracle environment and is currently providing them with remote support for three years. CRI consultants are remotely managing the Fairbanks-based Oracle database and Linux infrastructure from offices in Boise. CRI consltants have architected a more robust environment that is scalable, adaptable, and flexible enough to accommodate the Tanana Chiefs’ vision for growth and expansion while simultaneously reducing their TCO (Total Cost of Ownership).