SDMS_Attachment_1.docx

SDMS Attachment 1

1.0 Examples of Applications:

1.1 ARCNET - The ARCNET Enterprise Software Framework effort encompasses the services required to maintain an information technology platform for developing and hosting AFRC IT applications and software tools that support automated reservist readiness, participation management, and other mission support activities. The framework provides an ARCNET enterprise capability for enabling web-based, AF-GCSS compliant access to a variety of AFRC software tools. Currently, the major focus of the framework is to provide reservists a real-time capability to perform administrative and maintenance-related actions associated with managing reserve readiness and participation. Specific tools include reserve duty planning capabilities; volunteerism capabilities, which provide individuals with access to reserve volunteer opportunities; a readiness dashboard capability; ancillary training delivery and tracking capabilities. The primary user base for these tools will be all AFRC and Air National Guard (ANG) reservists (over 100,000). HQ AFRC/A6, Communications Directorate is responsible for project management for this effort. The contractor shall provide IT support services for the implementation, deployment, and sustainment of the ARCNET enterprise IT framework and associated web based tools and ancillary Air National Guard (ANG) ARCNET systems. Specifically, the contractor shall maintain the framework in accordance with (IAW) AF architecture guidance and AFRC mission needs; continue to field, maintain and enhance the products utilizing the framework; migrate existing AFRC IT systems into the framework as directed by the AFRC CIO; develop new mission support capabilities and services that are deemed by the AFRC CIO to have enterprise-wide applicability suitable for fielding within the framework; and deploy technologies and tools to integrate with the Services Oriented Architecture environment for AFRC.

1.1.1 Technologies: .Net, T-SQL, Telerick Rad Controls, Kendo UI web Controls, Entity Framework, WCF, VB.Net, Web API, HTML 1-5, Bootstrap, Jquery

1.2 ARC Force Visibility - The ARC maintains a geospatial tool, ESRI Geospatial, which displays ARC resources. The contractor shall maintain and administer a GeoBase technical infrastructure; provide technical policy and guidance to Command GeoBase technical staff; manage the technical implementation of GeoBase capability across AFRC A6 responsibilities; perform technical work in geospatial sciences and related web-based programming and database management; develop and/or implement ARC and Air Force geospatial data standards; manage the maintenance of geospatial data residing at AFR. Supports the development and implementation of enterprise GeoBase architectures. (SIPR Required)

1.2.1 Technologies: ESRI Geospatial, JavaScript, MVC, C#

1.3 Electronic DD 2875 Tool is an application to input DD2875 forms electronically and workflows to process them for specific systems.

1.3.1 Technologies: .Net, REACT

1.4 C2 Manning Tool was designed to assigned personnel to open manning position numbers. The app allows you to search for open position number by Units, and whether they are fixed or mobile. It also provide reports by Manning number, Position, Vacancy, Training and Training skills.

1.4.1 Technologies: .Net, Angular

1.5 A3 Aircrew Training Database was designed to automate the flight training requirements, scheduling, and graduated flight training. It capture training in a single repository and eliminate the need for multiple spreadsheets. The data contained in the database would track the training lifecycle, "Cradle-to-combat", archive the aircrew member's training records, and provide historical training data that can be used to project future training funding and schedule needs. The use of the database would ensure courses are scheduled continuously with a break of no less than 30 days until next course.

1.5.1 Technologies: .Net, REACT

1.6 NAF/SORTS Readiness Briefs are generated from the SORTS/ART readiness tool. The scripts are written for each specific AFR Number Air Force (NAF)'s data. AFR has three NAFs: 4th at March ARB CA, 10th at Carswell JRB TX and 22nd at Dobbins ARB GA.

1.6.1 Technologies: Scripting

1.7 AFR Internal Control Measures Dashboard is a repository of performance measurement slides that may be combined into self- updating PowerPoint presentations. The repository includes a presentation site that organizes the display of presentation slides. This tool is expected to be modernized/enhanced.

1.7.1 Technologies: SharePoint/PowerPoint 2013/.Net

1.8 Change Management Tool is a SharePoint 2010 application that provides capability to request network change requests, routed internally for approval and print XML forms.

1.8.1 Technologies: Running in a SharePoint 2013 Farm. Coded for SP2010.

1.9 AFRC Staff Directory is a tool built using scripts that extracts user information from AD including name, military rank or civilian, title, organization, phone number for HQ AFRC personnel. The directory is exportable to pdf.

1.9.1 Technologies: Scripting

1.10 Mobile Applications - The AFR requires a mobile application foundation that provides a common infrastructure for disconnected mobile applications.

1.10.1 Technologies: Native Cross-Platform

1.11 SORTS/ART Readiness Tool is a readiness tool which consists of scripts and batch files that dump, manipulate, and format readiness data which is then linked to Excel & PowerPoint in the format required for the Command's Quarterly Combined Readiness Brief. The tool also includes some ad hoc scripting for specialty reports, when requested. The SORTS & Defense Readiness Reporting System (DRRS) data is also uploaded, stored, and maintained within the Business Intelligence & Reporting Tool (BIRT) Performance Metrics Scorecard database for historical purposes.

1.11.1 Technologies: Classic ASP

1.12 Project, Workflow, Requirements, and Resource Manager (PWRR) is a web-based application which manages content and workflow for a wide range of IT project requirements. Requirements and various roles can be delegated by installation, organization, and office. Most dynamic lookup tables, e.g. funding codes, priority, validations questions, etc. can be managed in the web site. PWRR provides some metrics, e.g. requirements overdue by 30 days. The data is stored in a database in SQL server, allowing queries or modifications to any or all PWRR data, if necessary.

1.12.1 Technologies: Classic ASP

1.13 DoDI 8570 Compliance Reporting Tool serves as a repository for positional, personnel, and accreditation data to meet the reporting needs of the DoDI 8570 Initiative. Positions can be set to require specific criteria for certification, personnel can be set to meet certain criteria to meet said certification, and a hierarchy for the certifications can be established and modified in addition to the requirements for maintaining said certifications. Data can be queried based upon various filters and reports are exported to MS Excel 2010 format (.xlsx) using SQL Server Reporting Services.

1.13.1 Technologies: .Net

1.14 Software Licensing Database is a SharePoint web application to centralize, report, and assign/distribute software licenses to AF Reserve units. Each AFR unit has a SharePoint software licensing site to allow management of software locally purchased, and view the quantity of licenses assigned from HQ.

1.14.1 Technologies: SharePoint 2013

1.15 Command Generals’ Calendar supports the multiple General Officers that reside in the HQ Command Section. The General Officers’ calendar is utilized by the Command Section executive officers to manage the GOs schedules. The application contains jQuery and workflows to color code for each GO and notify the proper personnel when an event organizer submits a request for consideration. Upon approval, the event displays on the daily/weekly calendar

2.0 Technologies:

2.1 SharePoint 2013 Large Farm

2.2 Code and software languages in current use: C, C#, .Net, VB.Net, MVC, REST, REACT, Angular, Classic ASP, Scripting, JavaScript, Xamarin, SharePoint 201X, SSRS, and SOA Web Services.

2.3 Operating Systems in use: MS Windows 2012 and higher

2.4 Database Systems in use: MS SQL 2012 and higher

2.5 COTS in use: SharePoint 2013 (Testing SP 2016), Visual Studio 2015, MS Team Foundation Server 2013