US Department of Agriculture (USDA), Animal and Plant Health Inspection Service (APHIS), Veterinary Services (VS) – Process Streamlining Software Development

Veterinary Services (VS) protects and improves the health, quality, and marketability of our nation’s animals, animal products, and veterinary biologics by preventing, controlling and/or eliminating animal diseases, and monitoring/promoting animal health and productivity.

VS contracted with Technik to provide programming and analysis support on the VSPS project by completing the requests from the program staff to enhance, repair, and/update and address security issues for the VSPS System.

[tabs] [tab title=”Project Accomplishments”]

Project accomplishments and associated activities are described below.

Task 1: Project Plan/Schedule

Technik met with the COTR to discuss timing, contacts, documentation and other pertinent information. We performed an analysis of the work and developed a Project Management Plan (PMP), Work Breakdown Structure (WBS), WBS dictionary and project schedule with all milestones outlined.  We developed and presented a project schedule with milestones that corresponded to the CLINs. Work was re-evaluated and re-prioritized at the end of each CLIN. Functionality reports, acceptance testing, code check-in and documentation was accomplished to coincide with the sprint cycles. As required by VS, Technik utilized Earned Value Reports to measure our productivity. All work was performed in compliance with the development environment methods for source control (SVN), unit testing (nUnit), and documentation. Deliverables included:project management plan and project master schedule, weekly status meeting minutes and monthly project status reports.

Task 2: VSPS – Import and Export Product

The VSPS Import and Export TO required Technik to integrate the functionality of Veterinary Services Permits Issuance Tracking System (PITS) with VSPS by creating new functionality within VSPS for the Facilities/ Establishments for the Import of Animal Products (A/E) and the VSPS Facilities module. Successful completion of these tasks enabled VS to retire the PITS application. Deliverables include: updated source code in the version control system, completion and documentation of ClearQuest tickets and other applicable documentation.

Task 3: VSPS – National Animal Identification System Allocator Enhancements (NAIS)

Using USDA design documents, J2EE software code, Clear Quest requests, requirements analysis and Approved Establishments Revisions documents and related use case and change request documents, Technik re-engineered the NAIS Allocator application to function as a single authoritative source which would automatically assign unique Premises ID Numbers for each existing and new animal farm in the United States. Deliverables include: updated source code in the version control system, completion and documentation of ClearQuest tickets and other applicable documentation.

Task 4: VSPS – NAIS Performance and Scalability Analysis

Our staff optimized production code and conducted in-depth analysis of code, data models and database, SAN/storage, web server hardware, operating systems configurations. Based upon this analysis, we developed an application and system architecture report that provided a detailed evaluation and recommended performance improvements for the various NAIS application modules including SPRS, the Allocator, AINM, NPIR, ATPS, and nServices.  Deliverables include: updated source code in the version control system, completion and documentation of ClearQuest tickets and other applicable documentation.

Task 5: VSPS – NAIS Reporting Function Enhancement

Technik staff developed a requirements document that described the business rules; and suggested improvements to the NAIS automated reporting solution data model (SPRS, the AINM and the ATPS applications).  Deliverables include: updated source code in the version control system, completion and documentation of ClearQuest tickets and other applicable documentation.

Task 6: VSPS – Websphere Portal Direction / Development

Supported eGovernment initiative to provide web access and to deploy web applications through a web portal framework. Technik advised and supported program units within APHIS and developed portal applications, portlets, web services, and utilities needed to interface with the Websphere Application.  Deliverables include: updated source code in the version control system, completion and documentation of ClearQuest tickets and other applicable documentation.

Task 7: VSPS – Software Development and Support 2011

Using USDA design documents, J2EE software code, Clear Quest requests, requirements analysis and Approved Establishments Revisions documents and related use case and change request documents, Technik provided enhancements to the software applications “Facilities Approved for the Export of Animal Products (FAEAP)” and the “Approved Establishment (AE)” modules within VSPS.developed the needed functionality and successfully released to production the VSPS/Product Export Module.  Deliverables include: updated source code in the version control system, completion and documentation of ClearQuest tickets and other applicable documentation.

Task 8: VSPS – Digital Signature Pilot

Technik develop digital signature workflow as VS documents are presented for signing, review, and acceptance. Technik is implementing digital signature technology in the Veterinary Services Processes Streamlining (VSPS) Online as well as Off-line applications. Deliverables include: updated source code in the version control system, completion and documentation of ClearQuest tickets and other applicable documentation.

Task 8:  ARS – ARS Internet, Your Two Cents & SharePoint Support, USDA ARS OCIO

Intranet Support – Technik developed test and production environments for ARS Intranet on a current version of SharePoint platform. Developed needed workflows and KPI for the Intranet project. KPI will be developed primarily for the ARS-Your Two Cents application.  SharePoint 2003 / 2010 Support – Technik assisted the Government in providing support for SharePoint 2003 and 2010 environments. Assist the Government in migration effort of all content (My Site data, team site data, shared documents, etc.) from ARS’ existing SharePoint 2003 to department’s SharePoint 2010 environment.  REE Directory and Other ASP.net Web Applications Support – Assist the Government in providing first tier support to users for REE Directory. Assist the Government in a development of the REE Directory and other ASP.net web applications.

 Overall Performance:  Excellent

Delivery: Technik adhered to all deadlines and produced deliverables in a timely manner.
Cost Control: Technik performed within cost and budget.
Corrective Actions Taken: None

Technologies Used

Technologies used include:  Enterprise Edition(J2EE), JSP, EJB, Strubs, Hibernate 3.x, Spring Core Framework (v2.x), Apache CXF, Apache Tiles, jQuery, Oracle Forms, Reports, Discoverer, PL/SQL, SQL, Oracle AS 10.1.2, C3, Visual Basic .NET, ASP.Net, ASP, SML, JavaScript, XML, Web Services, SOAP, JAX-WS, JAX-RS, TOAD, ArcSDE, ESRI ArcIMS, ArcGIS, Windows XP, Windows Server 3002, COGNOS, XML, HL7.