Outcomes Based Business Analytics West Virginia Department of - PowerPoint PPT Presentation

Outcomes Based Business Analytics West Virginia Department of Health & Human Resources

Agenda  Introductions  What is RAFT?  Business Drivers  Goals  Technology Platform  Benefits  Why focus on Work Programs?  Demonstration  Outcomes Consulting On-screen Presentation Template_LARGE_White_042707  What’s Next?  Q/A - 2 - U.S.

Introduction Presenters:  John Maloney – Region 4 Program Manager, West Virginia Department of Health and Human Resources  John Gahr – Deloitte, WV Department of Health and Human Resources. Systems background:  RAPIDS ( R ecipient A utomated P ayment and I nformation D ata S ystem) - West Virginia's integrated eligibility determination and benefit calculation system Consulting On-screen Presentation Template_LARGE_White_042707  RAFT ( R APIDS A nalysis and F ormatting T ool) – West Virginia’s data warehouse system - 3 - U.S.

What is RAFT? System What is it? RAFT “ R APIDS A nalysis and F ormatting T ool” The RAPIDS reporting repository and Data Warehouse (DW)  Contains historical integrated eligibility data that is used specifically for reporting and analytical purposes U.S. Consulting On-screen Presentation Template_LARGE_White_042707 - 4 -

Business Drivers Usability Presentation  Dependency on the  Static technical team  Inflexible Timeliness Cost  Time  Batch-processed Consulting On-screen Presentation Template_LARGE_White_042707  Resources  Time-consuming ad-hoc  Transactional report creation via SQL - 5 - U.S.

Goals  Reduce the burden on the production transaction processing system’s (RAPIDS) resources for reporting purposes  Provide an environment that is optimized to support querying and reporting activity, and will not need to be tuned to support frequent inserts, updates and deletion of data  Deliver an end user interface which hides technical complications that can lead to erroneous reporting results  Reduce IT burden in creating, maintaining, and tweaking the inventory of RAPIDS reports by providing more functionality to RAPIDS power users Consulting On-screen Presentation Template_LARGE_White_042707 - 6 - U.S.

Technology Platform Reporting tool selection: Database selection:  Cognos 8 BI  Oracle 10g  Usability  24/7 accessibility  Presentation  Packaged with an ETL (Extract, Transform, & Load)  Business analysis capabilities tool: Oracle Warehouse Builder 2707 _04 Consulting On-screen Presentation Template_LARGE_White - 7 - U.S.

Benefits zyxwvutsrponmlkihgfedcbaWVUTSRQPOIHGFDCBA Usability Presentation  Rich graphical user  PDF, Excel, HTML interface report formats  Point and click, drag  Interactive OLAP and drop, user- cubes friendly environment Timeliness Accessibility  24/7 availability  100% “thin client” – web-based  Scheduled reporting  Technical team options Consulting On-screen Presentation Template_LARGE_White_042707 independent Business Analysis Capabilities  Simple and intuitive  Single point of access - 8 - U.S.

Why focus on Work Programs? • Drive to a stated goal of the TANF program • It is the correct approach for our constituency • Can’t rely on caseload reduction credit forever • Long term approach Consulting On-screen Presentation Template_LARGE_White_042707 - 9 - U.S.

Consulting On-screen Presentation Template_LARGE_White_042707 U.S. - 10 - Demonstration

i e_042707 RGE Wh t _ pl e_LA creen Presentat on Tem at i s ng On- Consulti U.S. - 11 - Outcomes

What’s next? • Program Effectiveness • TANF Recidivism • Work Program Effectives • Data Exchange Integration • Fraud Detection • SNAP Discounting Consulting On-screen Presentation Template_LARGE_White_042707 - 12 - U.S.

Consulting On-screen Presentation Template_LARGE_White_042707 U.S. Question & Answer Session - 13 -