Attachment 1_Applications Tracker.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- ECA EX/IT Information Technology Transformation and Operations Support Services (8a set-aside)
- Solicitation number
- 19AQMM21R0302
About this file
This document includes an attachment summarizing federal information technology applications used by the Department of State's Bureau of Educational and Cultural Affairs (ECA), as well as a related solicitation seeking proposals for information technology transformation and operations support services.
The attachment provides details on over 30 existing ECA information technology applications, including their purpose, platform technologies, and supporting offices. Applications support areas such as academic exchange programs, alumni tracking, budget management, data collection and reporting. Platforms include ASP.NET, Oracle, and other technologies. The solicitation seeks proposals on an 8(a) set-aside basis to provide IT transformation and operations support for these ECA applications. Services include application development, maintenance and operations. The period of performance is one base year with four option years. Proposals are due by September 13, 2021 with an anticipated award date of January 2022. The solicitation includes attachments on labor categories, past performance, pricing templates and evaluation criteria.
View the file
Other files
Show all 22
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| ECA EX/IT Applications Tracker | |||||||
| Project/Application | Description | Program | Technical Details | Customer | Comments | ||
| Academic Exchange Information System - AEIS | Tracks grantees and their activities for Fulbright and other academic programs. Maintains participants, organizations and location (US or overseas.) Supports inquiries and generates reports for management, Congress and the Public. Captures post exchange information from COOPs that has demographic information about the exchange. | Academic Programs | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Office of Academic Exchange Programs | ||||||
| Alumni Affairs Management System - AAMS | Tracks the funds and results of activities that are performed to engage former participants (Alumnus) of the exchange programs run by ECA. These activities range from Conferences, workshops, community outreach programs to setting up alumni coordinators in various countries. Has the capability to generate ‘Country Profiles’ that outline how the Alumni Affairs office is engaging with the alumnus of a specific country. | Alumni Affairs | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | The Office of Alumni Affairs | ||||||
| Alumni Archive | Manages all of the contact information for alumnus of exchange and tracks post exchange activities and engagements with Department of State, inlcuding people that were not direct ‘alumnus’, but also those in country that are important contacts. | Alumni Affairs | ColdFusion 2018/Oracle 12c | The Office of Alumni Affairs | |||
| Alumni ETL Tools | Pulls data in from the various exchange applications to put data into the Alumni Archive. This helps reduce ‘double entry’ of the participant information. Currently these are database scripts maintained by the database group and run in and ad-hoc basis once data is finalized for a given fiscal year. | Alumni Affairs | PL/SQL-Oracle 12c | The Office of Alumni Affairs | |||
| Budget Resource Center - BRC | This is to modernize and replace EOS application | Cross-Functional | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Executive-Budget Office | Currently being developoed | |||||
| Citizen Exchange Resource Center - CERC | Used to manage the entire lifecycle of project for the Citizen Exchange programs. Contains some workflow capabilities in the form of ‘ticklers’ that can help remind people to perform work. CERC is planned to have interfaces to COINS, ELVIS, and EOS. | Citizen Exchanges | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Office of Citizen Exchanges | ||||||
| Consolidated Insurance System - COINS | Responsible for managing which participants get enrolled within the ASPE benefit program (health insurance). | Cross-Functional | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Accident and Sickness Program for Exchanges | ||||||
| ECA Enterprise Data Transfer - EDT | Used to load data between the various ECA offices applications into the ESMS system. This is a one time load and is done as each program is deemed fit to be moved. | Cross-Functional | Delphi | ||||
| PL/SQL | Executive-Budget Office | Targeted for conversion to .NET | |||||
| Exchange Statistics Management System - ESMS | Used to collect data from each of the offices on the exchanges that were performed on a fiscal year basis. Financial information here is tied up to the Fiscal Year funding for the office as tracked in EOS. Initially created to feed the FEDS system, it has also been used to give ‘ballpark’ answers to taskers. | Cross-Functional | Silverlight/.Net 4.5.2/Oracle 12c | Executive-Budget Office | Targeted for conversion to .NET | ||
| Exchanges Impact | Used during an exchange, provides the ability for the participant to provide feedback on a daily basis. Also follows up and asks ‘final’ feedback after the exchange has been completed. This feedback is used to track the effectiveness of the programs and of the people/companies executing them. | International Visitors | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Office of International Visitors | ||||||
| Executive Office - EOS | EOS is the system of record for financial accounting for all money within ECA. It works on a Fiscal Year basis using a drawdown accounting model (each ‘account’ has a certain amount of money that is drawn from). Interfaces with Department of States GL system (GFMS) using a nightly file transfer. Contains historical information about grants that ECA has made in the past. Contains many financial reports and is very active near the end of the fiscal year. Drives the workflow within the budget office. | ||||||
| Used by both the ECA and IIP bureaus. Data is segregated through the use of Oracle’s Fine Grained Access Controls (FGAC). | Cross-Functional | Powerbuilder 12.7/Oracle 12c | Executive-Budget Office | ||||
| Executive Office Suite Web - EOSWeb | Contains historical information about proposals (the step before money is awarded as a grant). This functionality is now performed by SAMS Domestic. | ||||||
| The entry point for Academic Exchange’s Quota Sheet functionality that allows the program office to manage their budget in a way that aligns to strategic objectives. | Cross-Functional | ASP.Net v4.5.2 | |||||
| Entity Framework 6/Oracle 12c | Office of Academic Exchange Programs | ||||||
| Federal Exchanges Data System - FEDS | Collects data from various agencies and departments within the federal government regarding any exchange programs they may participate in. This data is aggregated into a larger report produced by the IAWG. Supports Executive Order 13055 (July 15, 1997). | Cross-Functional | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Policy Office | ||||||
| International Visitors Resource Center - IVRC | Used by the posts to enter project information that when ultimately ‘uploaded’ ends up in the EVDBe system to be processed and executed as a project. Also acts as a contact management system for posts for capturing people that do not necessarily participate in exchanges. This will eventually house all of the functionality from EVDBe and ORDIV. | International Visitors | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Office of International Visitors | C/S conversion for EVDBe | |||||
| Monitor 5 - MON5 | Used as a system interface between external entities (COOPs) and ECA for them to request insurance for those participants that are being handled by their own systems. System interface is provided using an email inbox that is periodically checked for requests. These come in a specific format and the COOPs are notified when we receive information. Currently written in .NET. Uses both Email and a secure FTP site for transmission of participant information. | Cross-Functional | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Accident and Sickness Program for Exchanges | ||||||
| Monitor 6 - MON6 | ETL tool that loads spreadsheet data in a specific format into the AEIS database. This data is generally provided once a year by COOPs (grantee organizations) to ECA in order to track the various individuals that are participating in the exchanges. Uses a customized excel spreadsheet (Validation Spreadsheet) with embedded macros to validate the data prior to being loaded. This spreadsheet needs to be digitally signed in order to have the macros enabled within OpenNet. | Academic Programs | Delphi | ||||
| PL/SQL-/Oracle 12c | Office of Academic Exchange Programs | ||||||
| Office of American Spaces Information System - OASIS | This applcaiton is currently being developed to support Office of American Spaces. The first phase is to provide functionality to manage the over 600 American Spaces worldwide. | Office of American Spaces | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Office of American Spaces | Currently being developoed | |||||
| Reporting Service | Reporting tool for AE, CE, IV and Alumni officegroup and run in and ad-hoc basis once data is finalized for a given fiscal year. | Cross-Functional | Business Objects 4.2/Oracle 12c | The Office of Alumni Affairs, Office of International Visitors, Office of Academic Exchange Programs | |||
| The Enterprise Level Visual Interface to Sevis - ELVIS | a web-based application that allows ECA program staff to submit participant information to Dept. of Homeland Security (DHS) Student and Exchange Visitor Information System (SEVIS) system to generate DS-2019 USA entry documentation. | Cross-Functional | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | Office of Academic Exchange Programs, Office of Alumni Affairs, Office of Citizen Exchanges, Office of International Visitor | ||||||
| Tracker II | Used by the Office of the U.S. Speaker Program to effectively manage its resources and fulfill its mission requirements. | Policy - Speaker's Office | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | U.S. Speaker Program | ||||||
| Tracker II - Modernization | This is effort to modernize Tracker II since the application is technogically outdated. | Policy - Speaker's Office | ASP.Net v4.5.2 | ||||
| Entity Framework 6/Oracle 12c | U.S. Speaker Program | Currently being developoed | |||||
| Vision 21 | Reporting System designed to provide high quality data that allows ECA staff to quickly respond to taskers, efficiently manage their program’s businesses, and perform analysis of data using a new executive dashboard with improved visualizations. | Cross-Functional | Business Object 4.2/Power BI/Oracle 12c | Policy Office |
File details come from the government source that posted it. Updated .