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.
- Industry: Government & Human Services
- Location: United States
- Focus Areas: Public Assistance Programs, Employment Services, Benefits Administration, Citizen Services
- Population Served: San Francisco Residents, Including Low-Income Families, Seniors, Veterans, and Individuals with Disabilities
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
Limited Program Performance Visibility
Limited Program Performance Visibility
Time-Consuming Reporting Processes
Time-Consuming Reporting Processes
Lack of Self-Service Analytics
Lack of Self-Service Analytics
Bridging the Gap Between Disconnected Data and Actionable Program Insights
Fragmented Operational Data
Fragmented Operational Data
Limited Program Performance Visibility
Limited Program Performance Visibility
Time-Consuming Reporting Processes
Time-Consuming Reporting Processes
Lack of Self-Service Analytics
Lack of Self-Service Analytics
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.
- 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
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
- 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
- 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
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
- 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
Data Sources
Data Integration
Data Warehouse
Data Visualization
Analytics Cloud
Data Sources
Data Integration
Data Warehouse
Data Visualization
Analytics Cloud
Transform Reporting into Faster, Smarter Decisions
Centralize access to critical information and accelerate insight delivery, helping stakeholders improve performance and optimize service delivery.