|
4GL Solutions designed and developed a Data WareHouse to integrate charge data from American Express and First USA Paymentech MasterCard. The WareHouse accommodates over 500,000 - 3 million-charge transactions annually. Summary reporting showing quarterly, annual and/or YTD : Airline, Hotel, and Car Rental charge totals are available online, hard copy and e-mail. Report formats are entirely flexible and can be customized upon request.
From the NT/DB2 WareHouse United Airlines, or corporate travel managers can review records of all transactions and generate a suite of pre-formatted reports on their combined charge card spending. Client access is provided via Brio reporting software, and Microsoft Office suite of product; Excel, Word, Access.
The Data WareHouse receives monthly data files from the credit card companies. A data transformation process provides a cleansing and consistency to the data. The cleansed data is moved into the WareHouse and available for reporting.
|