Business and Requirements Overview

Introduction

A web application that allows GSA users and Federal agency A/OPCs to access rich data visualizations on legacy SmartPay 2 aggregated charge card data and SmartPay 3 charge card data. The SmartPay Cloud system features a Data pipeline that pulls SmartPay 3 bank data files from the SPDW SFTP server, processes and loads them into the Redshift database using Pentaho Data Integrator, visualizes the data using Tableau server w/ row level security, and embeds them into the spdatawarehouse.gsa.gov Angular/Spring Boot portal.

SmartPay Data Warehouse

SmartPay Data Warehouse is a GSA Federal Acquisition Services (FAS) Major Application (MAs). SmartPay Data Warehouse serves as the repository for data provided by the various banks in support of the GSA charge card program. It holds data that can be used to view transaction information, dispute transactions, and create reports. SmartPay Data Warehouse provides a program wide view of government charge card data.

The major requirements that GSA SmartPay Data Warehouse accomplishes are as follows:

• Spend Analysis – Analyzing spend to identify patterns and support strategic sourcing initiatives focused on leveraging volume buys to negotiate merchant discounts and achieve other procurement savings;
• Risk Identification – The use of "rule based" methods and other data mining capabilities to identify high risk transactions, minimize the potential for, and detect incidents of misuse, fraud, waste, and abuse;
• Performance Measurement and Reporting – The use of performance metrics and reporting to improve overall card program management;
• Refund Management and Compliance Monitoring – The use of data and data management tools to improve the receipt of refunds and monitor banks' adherence to refund and fee/pricing commitments;
• Tax Reclamation: Analyzing transaction data to identify and assist with the recovery of State and Local taxes that have been inappropriately assessed on Federal government charge card transactions.