CASE STUDIES
	Infrastructure Support
	Systems Development and Integration
	Business & Financial Management
	Environmental Consulting

SYSTEMS DEVELOPMENT & INTEGRATION CASE STUDIES

Data Cleansing & Validation

The Office of Finance and Resource Management is the District Government agency responsible for the monthly receipt and payment of Verizon bills for all non-independent agencies. However, due to the immense volume of bills, the burden of reconciling and validating the cost of the monthly bill, typically over $1,000,000, was an impossible task without an automated system. As such, bills were being paid with little to no confidence of accuracy. Verizon bills are delivered in both paper and electronic copy. The electronic copies of bills are delivered on CD with a 'bill viewer' application called 'Powerbill' written in PowerBuilder code.

DBTS was part of the Office of the Chief Technology team assigned the task of assisting OFRM by creating a mechanism to validate Verizon telecommunication invoices against actual data. The mechanism created was the Telecommunication Integration Planning Project (TIPP). By obtaining simple message detail records (SMDR) from Verizon central offices, which was essentially call data illustrating all phone call information for all DC Government agencies supported by the Executive Office of the Mayor, and assigning a call rate (or cost) based upon a Verizon and District Government contract, to each call, the ITTS team 'cleaned' data and provided monthly reports to validate against Powerbill data imported into a SQL Server 2000 database from a Sybase SQL Anywhere database.