**SRA**

**MONTHLY STATUS REPORT**

September 1 -- September 30, 2007

[DOJ Contract No.]{.underline}: DJJ-05-C-1118

[Delivery Order No.]{.underline}: 005

[Status]{.underline}: In Process

[Task Description]{.underline}: IT Systems Development, Maintenance, and
Integration for the Office of Justice Programs (OJP)

[Period of Performance]{.underline}: May 17, 2005 through May 08, 2008

[Actual/Projected Completion Date]{.underline}: May 08, 2008

A.  [Work performed in the current reporting period]{.underline}:

```{=html}
<!-- -->
```
1)  Work Request 001 -- Systems Integration and Management Support

    a.  Prepared detailed DO 005 budget reports and conducted budget
        review meeting with Bruce Whitlock, OCIO.

    b.  Reviewed and updated the draft Weekly Status Report and draft
        Weekly Expenditures Report, and submitted the final reports to
        OCIO.

    c.  Developed DO 5, August 2007 OCIO Internal Progress Review
        briefing.

    d.  Facilitated and participated in several Rational Unified Process
        (RUP) Planning meetings. Worked closely with IBM staff to
        develop the project schedule to for all fiscal year (FY) 08
        major milestones for a RUP Implementation project at OCIO.

    e.  Reviewed Public Safety Officer's Benefits (PSOB) project
        documents.

    f.  Continued to develop the OCIO Customer Relationship Management
        (CRM) Plan.

    g.  Audited Project Management Procedures for the pilot projects.

    h.  Continued planning and coordination efforts for the next COOP
        test scheduled for December 2007.

    i.  Began to document COOP site requirements.

    j.  Updated the Continuity of Operations Plan and submitted it to
        Justice Management Division.

    k.  Completed the Federal Preparedness Circular 65 Checklist and
        submitted it to Justice Management Division.

    l.  Updated the Pandemic Plan and submitted it to Justice Management
        Division.

    m.  Completed the Pandemic Plan Checklist and submitted it to
        Justice Management Division.

2)  Work Request 002 -- Computer Associates (CA) Tools

```{=html}
<!-- -->
```
a)  Continued to assist the Help Desk with user provisioning.

b)  Created and deployed to PROD \"Provisioning Outside of eAdmin\"
    alerts.

c)  Gave a demonstration for ISSN \#
    [12559](http://ociosupport.ojp.usdoj.gov/trackbin/wtms.dll?action=queryDetail&cache=4666af4a&lastAction=queryData&queryName=CATools&intId=12559)
    (SiteScope) to Mike Haggerty and Bruce Whitlock.

d)  Validated new eAdmin GMS (GMOC) roles in eTrust Admin.

e)  Assisted Mike Haggerty in resolving potential security breach on
    OJPWASCDC01T.

f)  Reconfigured RIGEL (LISTS) to use new SMTP relay server.

g)  Created a draft architectural plan for CA deployment to RDC.

h)  Resolved loss of network connectivity between OJPWASDBS01,
    OJPWASDBS02, and OJPWASDBS05.

i)  Coordinated with Mike Sullivan a resource to setup a Proof of
    Concept system for eAC for Windows and ADC.

```{=html}
<!-- -->
```
3)  Work Request 003 -- OJP Systems Operations and Maintenance (O&M)

```{=html}
<!-- -->
```
a)  Deployed GMS v2.9.0.9, the Closeouts Award Emergency Release.

b)  Deployed GMS v3.0.0.1 a monthly O&M release that was delivered along
    with GMOC v3.0.0.0.

c)  Deployed GMS v3.0.0.2, the Multiple Rightfax Server/Quartz Upgrade
    Release.

d)  Developed ESP Locator Job Aid.

e)  Developed ESP Entity Relationship Diagram (ERD).

f)  Refreshed ESP Functional Quality Test (FQT) environment.

g)  Developed ESP Workflow Process diagrams.

h)  Delivered ESP Release 7.6.5.0 to FQT (target installation date of
    October 1, 2007).

i)  Executed DCR August 31, 2007 to roll ESP over to the next fiscal
    year.

```{=html}
<!-- -->
```
4)  Work Request 012 -- Payment Support Migration (PSM)

    a.  Continued to provide support for FMIS2 interface testing.

    b.  Created an Access database and loaded the FMIS2 A2H3 file and
        the corresponding IFMIS A2H3 file and performed comparative
        analysis.

    c.  Received revised sample EIG interface files from JMD. Provided
        return comments and asked Frank Manja to proceed with the
        development of the interface.

    d.  Met with representatives of OC, BJA, and others to review
        interface requirements for BVP, SWBPI, and SCAAP.

    e.  Received updated set of sample files for EIG. All files now
        appear to adhere to agreed formats (although this cannot be
        confirmed conclusively due to the nature of the sample data).

    f.  Created PAPRS payment request file on a daily basis and
        transferred this file to the JMD staging server for FMIS2
        testing purposes.

    g.  Provided specifications for the GMS/FSR interface to JMD.

5)  Work Request 015 -- Grants Monitoring Office of the Comptroller
    (GMOC)

    a.  Successfully deployed GMOC on August 3, 2007.

    b.  Merged GMOC code back to the main CVS branch.

6)  Work Request 016 -- Bullet Proof Vest (BVP)/Southwest Border
    Prosecution Initiative (SWBPI)

    a.  Completed payments for period of April 1-31, 2007.

    b.  Completed eight Data Change Requests (DCRs).

    c.  Completed deployment of two System Change Requests (SCRs).

    d.  Commenced development testing of OC4J migration.

    e.  Delivered two custom reports to DOJ Civil regarding the Zylon
        lawsuit.

    f.  Completed setup of 10g test environment for data tier.

    g.  Completed seven bug fixes in the development environment to fix
        OC4J.

    h.  BVP Help Desk resolved 1105 phone calls and responded to 286
        e-mails.

    i.  Delivered FRD for SWBPI Phase 1 and 2 to BJA.

7)  Work Request 017 -- Portal

```{=html}
<!-- -->
```
a)  Provided 13 solutions specific to the Portal upgrade.

b)  Provided 26 solutions to Portal Operations and Maintenance support.

c)  Developed a solution specific to Portal Gadgets Maintenance of
    Forecaster Timeline and Rolodex.

d)  Completed 13 OJP Internet Listserv Maintenance and Google Search
    reports.

e)  Completed 36 postings to OJP and OJP sponsored sites.

```{=html}
<!-- -->
```
8)  Work Request 018 -- Equal Employment Opportunity Plan (EEOP)

    a.  UAT in process.

9)  Work Request 020 -- Data Management (Production)

    a.  Provided production support for 18 database servers (with 37
        Oracle instances) and 23 application and web servers.

    b.  Monitored database requests for refresh and Help Desk tickets.

    c.  Supported eight production deployments.

    d.  Provided weekly disk space utilization and daily backup status
        reports.

    e.  Coordinated and provided DBA support for EMC after hours work.
        Provided DBA and Mid-tier support for EMC work on Oracle
        servers.

    f.  Supported build out of BVP/SWBPI OC4J test environment.

    g.  Supported build out of T2000 servers in FQT and UAT environments
        for EEOP. Supported build out of T2000 servers in FQT for
        BVP/SWBPI.

    h.  Migrated databases (ATMS, CTS, and Ideas) from Utopia to
        WASDBS40D.

    i.  Created development database for Account Management Automation
        (AMA) project.

    j.  Provided support to IV&V Team during testing of the GMS to FMIS2
        interface.

10) Work Request 022 -- Data Management (Development)

    a.  Continued support of GMOC through development and revision of
        data migration scripts.

    b.  Continued support of development team for Financial Status
        Reports module.

    c.  Completed initial development and testing of interface between
        Financial Status Reports module and FMIS2.

    d.  Investigated and assisted in the resolution of four issues
        related to OJP applications in the production, UAT, and Systems
        Integration Test (SIT) environments.

    e.  Prepared 139 Data Change Request scripts.

    f.  Responded to 38 requests for ad hoc reports.

    g.  Provided support to IV&V Team during testing of the GMS to FMIS2
        interface.

11) Work Request 024 -- ITVERP

    a.  Continued final user acceptance testing.

12) Work Request 026 -- Closeouts Module

    a.  No activity to report.

13) Work Request 027 -- Earned Value Management (EVM) Reporting

    a.  Developed Peer Review estimates for remaining preliminary design
        work for OCIO review and approval (for EVM baseline adjustment).

    b.  Created FY08 EVM Budget for DME & SS work for OCIO approval.

    c.  Provided ITIB / Dashboard July '07 Actuals to Bruce Whitlock and
        Ralph Justus on August 10, 2007.

    d.  Finished incorporating/analyzing July's EVM data and forwarded
        draft CPR Format 1 report and BCWS table to Ralph Justus on
        August 16, 2007 for updating Dashboard.

    e.  Finalized and distributed July EVM Reports to OCIO on August 28.

14) Work Request 031-- NIJ Web Site Redesign

    a.  Received approval for access to production from the COTR.

    b.  Delivered four design solutions to NIJ.

    c.  Continued development on Content Migration scripts.

    d.  Continued test script creation.

15) Work Request 032-- Financial Status Reports (SF-269)

    a.  The development and testing of the FSR Module is within the
        estimated budget and duration.

    b.  Supported the Functional Quality Testing of the Financial Status
        Reports the entire month. On an average delivered 2 bug fix VDDs

    c.  Completed the data migration scripts and successfully delivered
        the migrated data in the FQT environment.

    d.  Updated the Software Use Case Specifications document version
        3.0 with several changes identified during FQT phase.

16) Work Request 033 -- Application Peer Review Module

    a.  Completed draft Software Use Case Specifications document for
        the Funding Recommendations, Applicant Feedback, and Reviewer
        Evaluation packages.

    b.  Completed GUI design for the Funding Recommendations, Applicant
        Feedback, and Reviewer Evaluation packages.

    c.  Prepared for and conducted Preliminary Design Review with the
        business stakeholders.

    d.  Presented the Technology Options brief for implementing the Peer
        Review module.

```{=html}
<!-- -->
```
B.  [Deliverables submitted in the current reporting
    period]{.underline}:

```{=html}
<!-- -->
```
1)  SRA Weekly Expenditures Reports submitted on August 6, 13, 20, and
    27, 2007.

2)  Weekly Status Reports submitted on August 1, 8, 15, 22, and 29,
    2007.

```{=html}
<!-- -->
```
C.  [Problems encountered in the current reporting period]{.underline}:

```{=html}
<!-- -->
```
D.  [Work planned for the next reporting period]{.underline}:

```{=html}
<!-- -->
```
17) Work Request 001 -- Systems Integration and Management Support

    a.  Deliver weekly status and expenditures reports.

    b.  Develop and present OCIO Internal Progress Review briefing.

    c.  Update and review budget spreadsheet with OCIO.

    d.  Continue to develop the CRM Plan.

    e.  Audit Project Management Procedures for the pilot projects.

    f.  Work on CIO Portal.

    g.  Supported the OCIO Systems Development Life-cycle Project.

    h.  Provide assistance on the Public Safety Officers\' Benefits
        (PSOB) Project.

    i.  Prepare for the OJP Continuity of Operations (COOP) test
        scheduled for December 2007.

    j.  Plan and implement COOP awareness training for all staff.

    k.  Create and implement a COOP telework policy.

    l.  Coordinate with Human Resources to implement COOP policies.

    m.  Redesign the Emergency/Security page of the OJP Portal.

    n.  Coordinate with OCIO Telecommunications Staff to create a
        Telecommunications Plan.

18) Work Request 002 -- CA Tools

```{=html}
<!-- -->
```
a)  Provide O&M support.

b)  Work to resolve ISSNs such as Custom Reporting, CA Identity and
    Access Management - System and Application Monitoring, CA Identity
    and Access Management - Upgrade Unicenter Asset Manager to release
    11, CA Identity and Access Management - 3 strike user account, and
    CA Identity and Access Management - Intermittently Failing Crontabs.

```{=html}
<!-- -->
```
19) Work Request 003 -- OJP Systems O&M

    a.  GMS v3.0.0.3 -- Technical Assistance Form planned to go to
        production on August 30, 2007.

    b.  GMS v3.0.0.3 -- Technical Assistance Form planned to go to
        production on August 30, 2007.

    c.  ESP 7.6.5.0 -- Delivery to UAT by September 11, 2007.
        (Production October 1, 2007).

    d.  Develop ESP use cases creation and processing packages.

    e.  Develop ESP Database Guide.

    f.  Develop ESP SF-52 and Awards Job Aids.

20) Work Request 012 -- Payment Support Migration (PSM)

    a.  Complete implementing feedback from Legacy Applications
        Functional Migration Requirements document peer review.

    b.  Support all configuration and testing activities for FMIS2
        interfaces.

    c.  Attend OC status meetings.

21) Work Request 015 -- Grants Monitoring Office of the Comptroller
    (GMOC)

    a.  Deploy GMOC reports to Portal.

    b.  Support post deployment.

    c.  Complete all system documentation.

22) Work Request 016 -- Bullet Proof Vest (BVP)/Southwest Border
    Prosecution Initiative (SWBPI)

    a.  Continue to support BVP and SWBPI maintenance activities.

    b.  Continue work on the infrastructure changes for BVP and SWBPI to
        the OC4J platform.

    c.  Develop operational improvements for placing payments on hold.

    d.  Create requirements for improving the payment process.

    e.  Submit use cases for system modifications based on signed
        requirements.

    f.  Process BVP payments for requests from May 1- July 20, 2007.

23) Work Request 017 -- Portal

    a.  Go live with the Portal Upgrade.

    b.  Continue Forecaster support.

    c.  Continue Portal and OJP web site support.

24) Work Request 018 -- EEOP

    a.  Begin UAT follow-up corrections.

    b.  Production deployment.

25) Work Request 020 -- Data Management (Production)

    a.  Provide ongoing support for production and test environments as
        well as deployments to these environments.

    b.  Complete security risk mitigation items on identified servers.

    c.  Provide hardware and software upgrade schedules for upgrading to
        10gR2.

    d.  Provide support for COOP planning.

    e.  Support build out of T2000 servers in PROD environment for EEOP.
        Support build out of T2000 servers in UAT environment for
        BVP/SWBPI.

    f.  Continue support for "busy season."

    g.  Apply Oracle July CPU patches.

    h.  Continue support for EMC build out.

    i.  Provide support to IV&V Team during testing of the GMS to FMIS2
        interface.

26) Work Request 022 -- Data Management (Development)

    a.  Complete initial data model for Peer Review module. Create new
        development schema for Peer Review and support the development
        team for the Preliminary Design Review. Provide support during
        detail design.

    b.  Provide development support for Financial Status Reports during
        testing.

    c.  Perform ad hoc report generation as requested.

    d.  Continue development of reports for Closeouts and Financial
        Status Reports.

    e.  Support testing of interface between Financial Status Reports
        module and FMIS2.

    f.  Build out EIG structures to accept data from the FMIS2 / EIG
        interface.

    g.  Continue support for "busy season."

    h.  Provide support to IV&V team during testing of the GMS to FMIS2
        interface.

27) Work Request 024 -- ITVERP

    a.  Develop and submit the ITVERP Version Description Document (VDD)
        and related software components to the IV&V team for SIT.

    b.  Work with SecOps on Certification and Accreditation process.

28) Work Request 026 -- Closeouts Module

    a.  All Closeouts Phase 2 activities are on hold.

29) Work Request 027 -- Earned Value Management (EVM) Reporting

    a.  Review and analyze schedules for ETC import, BCWS monthly
        adjustments, and milestone completion. Update milestone weights
        to reflect schedule status.

    b.  Work with team leads in resolving identified procedural issues,
        incorrect actuals, etc.

    c.  Provide BCWS, BCWP, and ACWP data to OCIO prior to report
        preparation and completion.

    d.  Analyze August GMS performance and variances and prepare summary
        explanation.

    e.  Prepare and deliver final August monthly reports for OCIO.

30) Work Request 031-- NIJ Web Site Redesign

    a.  Implement modifications to Rhythmyx production.

    b.  Begin testing.

    c.  Begin content migration.

31) Work Request 032-- Financial Status Reports Module -- SF269

    a.  Support FQT and UAT and regression testing.

    b.  Code all reasonable changes that are requested by the users
        during the FQT and UAT building..

    c.  Support testing of the interface between GMS FSR and FMIS2
        system.

    d.  Support the outreach and rollout activities associated with the
        project.

32) Work Request 033 -- Application Peer Review Module

    a.  Revise and baseline the Software Use Case Specifications
        document.

    b.  Develop detailed design and implementation schedule for the work
        request.

    c.  Develop artifacts necessary for Detailed Design Review.

    d.  Conduct Detailed Design Review.

    e.  Start work on the development of the GMS Application Peer Review
        module.

```{=html}
<!-- -->
```
E.  [Deliverables planned for the next reporting period]{.underline}:

```{=html}
<!-- -->
```
1)  SRA Weekly Expenditures Reports.

2)  SRA Weekly Status Reports.

3)  GMOC Use Case Specifications v3.0

4)  GMOC Detailed Design & Maintenance Manual v1.0

5)  PAPRS Mapping Analysis Report v1.0

6)  Peer Review Use Case Specifications v1.0

7)  September 2007 DO 5 Monthly Status Report

```{=html}
<!-- -->
```
F.  [Problems Anticipated]{.underline}:

```{=html}
<!-- -->
```
1)  We have run out of OJP office space for incoming staff. We presented
    an SRA Facility Concept of Operations document, but we have been
    unable to obtain OJP approval. Until the office space issues are
    resolved, we are unable to process candidates for OJP clearances and
    fill approved billets to meet OJP Work Request requirements.

```{=html}
<!-- -->
```
G.  [Assistance and/or guidance needed]{.underline}:

```{=html}
<!-- -->
```
2)  None