Malcolm 'Max' DeRungs

myHIway Data Catalog

This mobile and desktop search application helps Providence caregivers discover, collect, compare, and access business intelligence data, analytics, and applications across multiple Providence data environments.

psjh-myhiway-data-catalog-1

In 2014, after several years of business consolidations and mergers, Providence data assets were spread out across a wide variety of sources and vendor platforms. Seeing this as a main cause of inconsistent reporting across the multi-region enterprise, I cobbled together five retired desktop PC's and built a search app with opensource software.

With capital funds from a Data Governance initiative, the app and its underlying platform was able to grow in value and introduce internal caregivers to user engagement features like natural language queries, search suggestions, automatic faceting, result boosting, bookmarks, saved searches, comments, and likes.

In 2015, Providence IS began evaluating several commercially available data catalog applications. But these products were expensive, difficult to use, legally constrained, or not readily adaptable to ad hoc user feature requests. In the end, Providence leadership decided to operationalize my work and make it available to all internal users for free.

They called the app 'myHIway' after the Healthcare Intelligence ("HI") team it came from and its promise to pave the way to health care transformation through better access to data.

In 2016, I released the first version of the myHIway app on Providence datacenter VM servers. As hoped, the product accelerated report consolidation and data quality initiatives by exposing over 40k business intelligence apps, reports, metrics, datasets, analytics, dictionaries, standards, data models, glossaries, training materials, and data science references from over 30 internal and external data and content sources.

In 2020, with over 14,000 unique users, the app and platform continued to demonstrate value despite the introduction of other enterprise cataloging tools, and we started rebuilding it as a microservices PAAS solution on Azure Kubernetes Services.

Features

  • Galleries of reports, scorecards, applications, etc.
  • Search - NLP, auto-suggest, result boosting, saving, facets, and filters.
  • Bookmarks
  • Saved Searches
  • Comments
  • Access Request Forms
  • Personal Preferences
  • Single Sign On
  • System Alerts
  • Blog Posts - research, data news, and general data literacy.

Meta

Responsible for product design, architecture and full stack engineering from proof-of-concept through current releases. Created brand logo and original graphics/theme elements.

2021 to present

Fully opensource Angular9/SCSS web application, Apache Solr cluster, and numerous dockerized Python microservices for logging, validating keys, and managing data from SAP Business Objects, Epic Clarity, Snowflake, SharePoint, Tableau, PowerBI and MariaDB datasets. Deployed from Azure DevOps Repos and Azure Container Registry as Kubernetes cluster on Providence Cloud VM servers.

2017 to 2020

Angular2/LESS web application built on Lucidworks App Studio framework running on Apache HTTPD and Tomcat servers connecting to a Lucidworks Fusion search engine with data ingested from Enterprise Data Warehouse and MariaDB databases on Providence Cloud VM servers.

2014 to 2016

JSP/LESS web application built on Twigkit framework running on Apache HTTPD and Tomcat servers connecting to Apache Solr with data modeled using SmartLogic and ingested from Enterprise Data Warehouse and MySQL databases on Desktop PC's pirated from empty office cubes.

Role: Senior Information Architect, Principal BI Platform Engineer

Setting: Providence St. Joseph Health

Location: Portland, Oregon

Year: 2014 to present

Media: Inkscape scalable vector graphics