Transforming Citizen Services with Centralized Cloud Analytics

Unified operational data across employment services and benefits administration into a centralized Oracle Cloud Analytics platform, enabling self-service reporting, real-time program visibility, and data-driven decision-making. 

2

Major business groups unified through a single analytics platform 

5

Operational systems integrated into a centralized data warehouse 

15+

Analytics areas delivered across employment, benefits, customer service, and case management functions 

Executive Summary

The client relied on multiple operational systems and reporting tools to manage employment services, benefits administration, customer service, and case management programs. The fragmented reporting environment limited visibility into program performance and made it difficult to access timely and reliable information for decision-making. 

DiLytics implemented an Oracle Business Intelligence Cloud Services solution that integrated data from five operational systems into a centralized cloud data warehouse. The solution delivered analytics capabilities spanning Employment Services and Benefits Administration, including workforce programs, customer service, application processing, quality assurance, case management, and operational performance reporting. 

The solution established a single source of truth, improved reporting efficiency and data accessibility, enabled self-service analytics, and empowered agency leadership with timely insights to improve program effectiveness and citizen service delivery. 

Submit Your Details to See the Complete Transformation Story 

Transformation Unlocked!

Use the top navigation menu or scroll down to explore the details.

Client Overview

The San Francisco Human Services Agency (SFHSA) is the primary provider of public assistance programs for residents of San Francisco. The agency delivers a broad range of services, including employment assistance, food assistance, healthcare benefits, financial support, workforce development, and protective services for individuals, families, and communities.  

Bridging the Gap Between Disconnected Data and Actionable Program Insights

SFHSA relied on multiple disconnected systems and reporting tools to manage critical public assistance programs. The fragmented analytics environment limited visibility into operational performance, increased manual reporting effort, and made it difficult to deliver timely insights for program management and executive decision-making.

Fragmented Operational Data

Fragmented Operational Data

Critical information was distributed across multiple systems, databases, spreadsheets, and reporting tools, making enterprise-wide analysis difficult

Limited Program Performance Visibility

Limited Program Performance Visibility

Managers lacked a consolidated view of employment services, customer service operations, benefits administration, and case management activities

Time-Consuming Reporting Processes

Time-Consuming Reporting Processes

Generating reports required significant manual effort due to disconnected data sources and inconsistent reporting processes

Lack of Self-Service Analytics

Lack of Self-Service Analytics

Business users required a centralized analytics platform that enabled ad hoc reporting and self-service access to trusted information

Bridging the Gap Between Disconnected Data and Actionable Program Insights

Fragmented Operational Data

Fragmented Operational Data

Critical information was distributed across multiple systems, databases, spreadsheets, and reporting tools, making enterprise-wide analysis difficult

Limited Program Performance Visibility

Limited Program Performance Visibility

Managers lacked a consolidated view of employment services, customer service operations, benefits administration, and case management activities

Time-Consuming Reporting Processes

Time-Consuming Reporting Processes

Generating reports required significant manual effort due to disconnected data sources and inconsistent reporting processes

Lack of Self-Service Analytics

Lack of Self-Service Analytics

Business users required a centralized analytics platform that enabled ad hoc reporting and self-service access to trusted information

Building a Centralized Analytics Platform for Human Services Excellence

DiLytics partnered with SFHSA to design and implement an Oracle Cloud Analytics solution that consolidated data from multiple operational systems into a centralized cloud-based analytics platform. The solution delivered integrated dashboards, reports, and analytical capabilities supporting both Employment Services and Benefits Administration operations. 

Services provided
  • Conducted business requirements gathering and stakeholder workshops 
  • Designed and implemented a relational star-schema data warehouse 
  • Developed ETL processes to integrate data from multiple source systems 
  • Implemented Oracle Cloud Analytics  
  • Developed KPIs, metrics, dimensional models, dashboards, and reports 
  • Conducted testing, user training, and knowledge transfer 
  • Enabled self-service and ad hoc reporting capabilities 
Business Solution

The solution delivered analytics capabilities across two major business groups:

  • Employment Services Analytics: Providing visibility into caseload management, workforce participation, program eligibility, welfare-to-work initiatives, and overall program effectiveness 
  • Benefits Administration & Citizen Services Analytics: Providing visibility into customer service operations, application processing, case management, workload management, service quality, and workforce productivity 
Technical Solution
  • Integrated data from CIS, Avaya, QFlow, iTasks, and Livelink systems 
  • Implemented a centralized Oracle Database Cloud Service data warehouse 
  • Developed ETL processes using Microsoft SQL Server Integration Services (SSIS) 
  • Created Oracle Cloud Analytics semantic models, KPIs, metrics, and dimensional hierarchies 
  • Delivered interactive dashboards, reports, drill-down analysis, and ad hoc reporting capabilities 
  • Established a scalable cloud analytics architecture to support future agency-wide expansion 

Empowering Better Outcomes Through Unified Analytics

The centralized analytics platform transformed fragmented reporting into a trusted, self-service environment that improved operational visibility, reporting efficiency, and program management across citizen service functions.

Improved Program Visibility

Enabled deeper insights into program performance, effectiveness, and operational outcomes

Faster Access to Critical Information

Provided timely and reliable data for quicker decision-making

Enhanced Reporting Efficiency

Reduced effort required to generate and distribute reports across departments

Unified Analytics Experience

Consolidated multiple reporting tools into a single analytics platform

Greater Self-Service Capabilities

Empowered users to perform ad hoc analysis without IT dependence

Increased Staff Productivity

Accelerated report delivery and improved efficiency for business and IT teams

Tech Stack Summary

The solution consolidated data from multiple operational systems into a centralized cloud-based analytics environment, enabling enterprise-wide reporting and decision support.
Data Sources
Data Integration
Data Warehouse
Data Visualization

Transform Reporting into Faster, Smarter Decisions

Centralize access to critical information and accelerate insight delivery, helping stakeholders improve performance and optimize service delivery.