Alameda County Social Services Agency

1. Alameda County Social Services Agency The Child Welfare Title 4-E Waiver Project in Alameda County; Client Overview, Automated Real-time Alerts & Reporting

2. 2 Topics of Discussion Who, What, Where is Alameda County Child Welfare vs. the 4-E Waiver Program Challenges Facing Alameda County Technical solutions solving business problems Project Objectives Phases I, II, III Social Services Integrated Reporting System Under the Hood The Enterprise Visualizer & a few Reports Automating Social Service

3. 3 About Alameda County Social Services 14 incorporated cities including Oakland and Berkeley, California 5 unincorporated cities Population of Alameda County 1.6 million people 9,000 County Employees 2200 Social Service Agency Employees Five major departments Administration & Finance Adult & Aging Children and Family Services Economic Benefits (TANF) Employment Services (Welfare to Work)

4. 4 Clients Served by SSA 19,200 TANF Cases 60,787 Medicaid Cases 28,230 Food Stamp Cases 9,000 General Assistance Clients 2,896 Children Served 21,200 Adult & Aging Clients

5. 5 Challenges Facing Alameda County 2005 Deficit Reduction Act 4-E Waiver Program (Child Welfare) Data Rich Information Poor Uneven gaps between actions required and actions taken Inability to respond quickly to an ever changing environment Disparate Systems and Tools 2009 Economic Reality

6. 6 The Child Welfare Title 4-E Program

7. 7 The Child Welfare 4-E Waiver Program

8. 8 Desired Outcomes of the 4-E Waiver Increase number of children who can remain safely in their home Increase number of kids in less restrictive settings Increase number of kids in safely and permanently unified in their homes Increase percent of timely guardianships and adoptions Improve self sufficiency and well being of emancipating youth

9. 9 The Social Service Enterprise Solution The Social Services Integrated Reporting System (SSIRS) Addresses the Agency�s Challenges Supports the IV-E Waiver Program

10. 10 Alameda County SSA Objectives, Phase 1: Phase 1 Six System currently feeding SSIRS: Child Welfare Probation (Juvenile) Employment Services (welfare to work) TANF In Home Supportive Services (state system) County Adoptions system Bullet 2 - from multiple State & Local data sources for an Enterprise (alerts and longitudinal) View of the family, services and benefits: Bullet 3 - bring reporting in-house; identify program services, benefits, overlaps Bullet 4 - TANF ES � 18 county consortium system IV-E Waiver � statewide child welfare system TANF, SNAP, Medicaid � 18 county CalWIN system In Home Supportive Services statewide system SMART Adoptions � county database Probation � county system for cross over youth.Bullet 2 - from multiple State & Local data sources for an Enterprise (alerts and longitudinal) View of the family, services and benefits: Bullet 3 - bring reporting in-house; identify program services, benefits, overlaps Bullet 4 - TANF ES � 18 county consortium system IV-E Waiver � statewide child welfare system TANF, SNAP, Medicaid � 18 county CalWIN system In Home Supportive Services statewide system SMART Adoptions � county database Probation � county system for cross over youth.

11. 11 Alameda County SSA Objectives, Phase 2 & 3: Phase 2 � Client Activity Alerts and Outcomes from Safe Measures (Strategic Decision Making) Early Periodic Screening, Diagnosis, and Treatment (EPSDT) Another Road to Safety JURIS/Probation MEDS/DHCS Phase 3 � Health Care Services Agency (HCSA) activities � One Consolidated View across the Alameda SSA and HCSA Enterprise of internal and external Programs and Stakeholders serving families

12. 12 SSIRS Under the Hood IBM D5000 Pre-configured and Pre- Balanced BI Data Warehouse Entity Analytic System DB2 Engine Cognos Reporting, Charting, Dash Boarding Linux Operating System 200 Concurrent Users Web Enabled

13. 13 Centralized Reporting

14. 14 Alameda SSIRS Data Flow Chart

15. 15 What Makes SSIRS Go? It�s a� Resolved Identity Repository Identity Longitudinal View Resolved Family View Individual, Family & Relationships* View Across the Enterprise of programs, partners, providers & services Real-time Enterprise Reporting & Dashboards Drill down Views to client activities & dates

16. 16 An Enterprise Based Reporting Model What does an enterprise based reporting model look like?What does an enterprise based reporting model look like?

17. 17 The Identity & Relationship Repository Reducing False-Positives saves investigator�s hours or days, and possibly more critically reducing False-Negatives may save lives.Reducing False-Positives saves investigator�s hours or days, and possibly more critically reducing False-Negatives may save lives.

18. 18 EAS VISULIZER (The Brains Behind SSIRS)

19. 19 EAS VISULIZER (The Brains Behind SSIRS)

20. 20 IBM Global Name Recognition Critical to the identification process Name recognition is a critical component of the identification process especially in Australia which is multicultural. Yet, name recognition is much more of an art than it is a technology, and is by far the most challenging attribute to recognize. Addresses and telephone numbers can be verified. There is no central verification source for names. Names differ based on geography, culture, male and female, tribe and family. Effective name recognition technology must take all of these variables into consideration. IBM�s Global Name Recognition technology is optimized for environments such as this. It is optimized for the multi-cultural nature of most global customer set and is well equipped to deal with name variations, nicknames, shortened names, multiple prefixes, name order, titles, as well as genderizing and phonetic misinterpretations. Across more than 200 countries and one billion namesName recognition is a critical component of the identification process especially in Australia which is multicultural. Yet, name recognition is much more of an art than it is a technology, and is by far the most challenging attribute to recognize. Addresses and telephone numbers can be verified. There is no central verification source for names. Names differ based on geography, culture, male and female, tribe and family. Effective name recognition technology must take all of these variables into consideration. IBM�s Global Name Recognition technology is optimized for environments such as this. It is optimized for the multi-cultural nature of most global customer set and is well equipped to deal with name variations, nicknames, shortened names, multiple prefixes, name order, titles, as well as genderizing and phonetic misinterpretations. Across more than 200 countries and one billion names

21. 21 The Power of Relationship Resolution (�Who Knows Who�) Our resolved family view� and the extended relationships, this is an example of three degrees of separation, we can go beyond this number to six or more today.Our resolved family view� and the extended relationships, this is an example of three degrees of separation, we can go beyond this number to six or more today.

22. 22 EAS & Cognos Together The Longitudinal View And Drill Down Reporting

23. 23 Identity Repository � (Visualizer) Longitudenal View This is the type of longitudinal view that we now receive.This is the type of longitudinal view that we now receive.

24. 24 Longitudinal Analysis� � what happened after foster youth aged out? TANF, SNAP, Medicaid� homelessness Find out to what degree emancipated foster youth in the CWS/CMS system � End up in emergency homeless shelters End up in other Welfare programs Over what time frames.. Two siblings, sister, and a year later, brother both ended up on all programs over time including the homeless shelter, for the young woman, a few weeks after �emancipation�, and for the young man, a few months later. Both were consistently in the public system over the eight years from release until this report was done apx. a year ago.Two siblings, sister, and a year later, brother both ended up on all programs over time including the homeless shelter, for the young woman, a few weeks after �emancipation�, and for the young man, a few months later. Both were consistently in the public system over the eight years from release until this report was done apx. a year ago.

25. 25 Longitudinal Client View

26. 26 Longitudinal Client View

27. 27 SSIRS USE In the 4-E Waiver Program Bring together data on child welfare system clients from Multiple payment and case management systems Gauge the true costs associated with serving clients Analyze the effectiveness of particular interventions All in near real time

28. 28 ES Engagement Summary Executive DashboardWelfare to Work And now.. Dashboard, Summary, with drill down as you see in the next slide.And now.. Dashboard, Summary, with drill down as you see in the next slide.

29. 29 Case Worker�s Client Activity History Drill down to client activities and dates giving us for the first time a view of who specifically is unengaged, even if they�re not supposed to be.Drill down to client activities and dates giving us for the first time a view of who specifically is unengaged, even if they�re not supposed to be.

30. 30 Client Activity Program and Benefit Status

31. 31 Automated Social Services Aggressively Reduces Fraud Reduces the Action Required Action Taken Gap across Programs Improves Business Process Reduces Cost Seeks Revenue Opportunities

32. 32 Automating Social Services

33. Q & A The Child Welfare Title 4-E Waiver Project in Alameda County; Client Overview, Automated Real-time Alerts & Reporting