welfare data portal

Los Angeles County Department of Public Social Services (DPSS) 9320 Telstar Ave El Monte, CA 91731

Requirements Overview

The purpose of the Management Reporting (MR) process is to produce the management reports necessary to comply with Federal and State regulations and with County policies. These reports provide information to be used by DPSS personnel for monitoring Eligibility Worker, system and fiscal performance as well as other activities. MR required the creation of an intranet-based business intelligence portal. The site would provide multi-dimensional reporting on welfare data. 2 Terabytes of Unisys mainframe data would need to be downloaded into SQL Server reporting database. Replace static paper-based reporting system for Welfare Districts.

KBLC's Solution

• Define relevant reporting data from mainframe Welfare system.
• Automate process of downloading and refreshing data.
• Create easy-to-use business intelligence reporting interface.
• Add drill-down capability.
• Implement levels of security.

Results

• Dynamic, multi-dimensional reports introduce trending capability.
• Intranet access enables oversight by all levels of management.
• Provided tools for Districts to effectively manage caseloads.

Key Technologies