U.S. Department of State Fiscal Year 2019 Agency Financial Report

utilizing a collection of overseas posts, a regional bureau, and accounting support staff in Charleston, S.C. to finalize overseas report and information space requirements and report functionality. Training has been formally conducted for about 60 posts in all regions. Several domestic bureaus have also been trained. New functionality added to Global BI in 2019 included a Pipeline report to show spending by country and program, and new Foreign Currency Exchange Rate reporting for the Bureau of Budget and Planning. Improvements were also made to some of the overseas financial reports to address performance and data quality issues. Improvements were also made to Global BI’s external reporting module to improve the Department’s foreign assistance reporting process, as well as reporting for the DATA Act to meet new Treasury requirements. In 2020, the Global BI application will be updated to include versions of the Payroll reports from COAST. Global BI’s Business Objects infrastructure will also be upgraded in 2020 to support the implementation of a new Lumira reporting tool. The GFMS Data Warehouse report migration will also be completed in 2020. The rollout of Global BI to overseas posts will accelerate in 2020. and local laws and practices applicable to all the countries in which civilian agencies operate. The last pay module to be implemented in GFACS is American payroll. It is currently in final testing prior to full implementation. The web-based global time and attendance product, based on the same technology as GFACS, will follow the American payroll implementation. This product has the capability of electronic routing, electronic signature, and self-service features. As a result, it will bring a more efficient and modern process to the Department’s workforce. B usiness I ntelligence P rogram The Department’s Business Intelligence program consists of the GFMS Data Warehouse (DW), COAST Reporting, COAST Payroll Reporting, and the Global BI Reporting. The GFMS DW enables users to access financial information from standard, prepared reports or customized queries. It also provides, on a daily basis, critical financial information to the Department’s enterprise data warehouse. During 2019, the GFMS DW was enhanced to implement new and updated reporting prior to the migration of all reporting content into the Global BI reporting tool in 2020. The GFMS DW will then be retired late in 2020. In 2017, the Department implemented the Global BI application, building on the infrastructure being used for the DW, and adding an in-memory appliance and a new data analytics tool. In 2018, the Global BI application continued to be used to import, reconcile, and export data that meets the requirements of the DATA Act. The Global BI application was updated to complete the full suite of financial reports for overseas posts as well as a second set of analytics information spaces for posts to drill into their overseas transactional data. The Department continued through an agile-like process Madeleine Albright, the 64th Secretary of State, served as Ambassador to the United Nations (1993-1996) under President Clinton until her appointment as the first woman to serve as Secretary of State (1997-2001). Did You Know? M ore information on former Secretaries can be found a t: https://history.state.gov/departmenthistory/ p eople/secretaries 2019 A gency F inancial R eport U nited S tates D epartment of S tate | 151 RESOURCE MANAGEMENT SYSTEMS SUMMARY | OTHER INFORMATION