On Prem to Web Based Migration

Project Details

  • Migrate on-prem Med-Web application to browser-driven web-based application to decouple vendor from software & hardware dependencies
  • Design & develop a core functionality & front-end for screens related to benefits, member switch, claims, & member restrictions
  • Design & create various data converters & valuators in the web component layer for masking functionalities for HIPAA
  • Manage ongoing security support: create user accounts & set up user rights on web applications

Business Outcomes

  • The web-based application successfully decoupled users from maintaining local Med-Web software copies on their system; instead, users can connect to a centralized browser-driven application

Supply Chain Digital Transformation

Project Details

  • Identified specific pain points in the current supply chain, point of sale (POS) & inventory processes
  • Consolidated process for inventory optimization (from many disparate steps down to a clean efficient process)
  • Organized, sequenced & synchronized Warehouse Management Systems (WMS)
  • Corrected gaps in ordering process & overhauled payment processing system
  • Turned all retail locations into shipping centers by creating real-time coordination of the POS & inventory systems

Business Outcomes

  • Reduced inventory holding costs while improving inventory stocking & turns & creating quicker & less expensive customer shipping options
  • Personalize customers’ web experience & sent real-time text deals to attract them to nearby locations
  • 2021 revenue increased 19% to $9 billion

Cloud Migration

Project Details

  • Self-service environment allowing users to bring their own data for analytical & reporting purposes
  • Write back capability to increase data governance posture & visibility of data lineage
  • A new CDC model making use of Snowflake Stream & tasks for Type 2 Slowly Changing Dimensions (SCD) (mainly to capture & track delete records)
  • Column level (data masking) & row level security
  • Reporting Tableau dashboards for monitoring compute cost, storage usage, long-running queries, RBAC structure & SSE object creation

Business Outcomes

  • New environment reduced IT resourcing, storage & compute costs
  • Increased data governance, security & visibility of data lineage
  • Data masking allows for the ease of new user bulk onboarding
  • Detailed reporting allows for cost reductions utilizing available usage from different Snowflake accounts