Information Builders Salt Lake City User Forum April 24, 2012 - PowerPoint PPT Presentation

allie
information builders salt lake city user forum april 24 2012 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Information Builders Salt Lake City User Forum April 24, 2012 PowerPoint Presentation
Download Presentation
Information Builders Salt Lake City User Forum April 24, 2012

play fullscreen
1 / 15
Download Presentation
Information Builders Salt Lake City User Forum April 24, 2012
78 Views
Download Presentation

Information Builders Salt Lake City User Forum April 24, 2012

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Information BuildersSalt Lake City User ForumApril 24, 2012 The Customer Speaks Workers Compensation Fund Darin Lee

  2. History • Purchased WebFOCUS and iWAY ETL solutions in 2001 • Provides data ETL tools for creation and update of data warehouse • Addresses reporting needs from ERP system, legacy data, and new DB2 warehouse • Replaced all other reporting tools and helped consolidate databases • Provides almost ALL reporting functionality

  3. Environment • Currently running WebFOCUS and iWay servers on Z/OS, z/Linux, and IBM P7 Linux systems accessing DB2, ADABAS, SQL Server, and FOCUS databases • ReportCaster and WebFOCUS Client on P7Linux with Tomcat Web & App Server • Active Reports license • Flex Enable license

  4. Staffing • Me (previously full-time, now part-time) • Two part-time WebFOCUS developers • One full-time Data Migrator (data warehouse) specialist • IBI consulting

  5. Recent Initiatives • Completed 3 to 6 month reporting initiatives with Underwriting, Finance, Claims, and Safety departments • Discovered that parameterized reporting was the preferred solution

  6. Recent Initiatives • Moving almost ALL reporting from our legacy production system (TORCS) and integrating reporting functionality with WebFOCUS and ReportCaster • One version of the “truth” • No more fixed fonts, “ugly” mainframe reports • Outputs to PDF and Postscript – technology update • Use of graphics, colors, bar codes, custom fonts • Allows for automated bursting , sorting, stuffing, and delivery

  7. Recent Initiatives • DASHBOARDS!!

  8. Recent Initiatives – Dashboard!!

  9. Recent Initiatives – Dashboard!!

  10. Recent Initiatives – Dashboard!! PDF Demo

  11. New Initiatives • Five year project to rewrite our entire operational system (Finance, Underwriting, Claims Management, etc.) in Java • Automation and integration of all operational and batch reporting using WebFOCUS, Java, and web services • Outputs to PDF and Postscript – technology update • Automated printing, bursting , sorting, stuffing, and delivery

  12. Questions??

  13. Thanks!!