1 / 15

Revolutionizing Workplace Reporting with WebFOCUS & iWay ETL

Explore how Workers Compensation Fund leveraged WebFOCUS & iWay ETL to enhance reporting capabilities, streamline operations, and integrate data from diverse sources. Discover their recent initiatives on dashboard integration, reporting automation, and the shift to a Java-based operational system.

nolcha
Télécharger la présentation

Revolutionizing Workplace Reporting with WebFOCUS & iWay ETL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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!!

More Related