Your Privacy

This site uses cookies to enhance your browsing experience and deliver personalized content. By continuing to use this site, you consent to our use of cookies.
COOKIE POLICY

Skip to main content
Healthcare

ETL Tools Leveraged for Healthcare Provider

ETL Tools Leveraged for Healthcare Provider

UDig assisted a large healthcare provider with a migration of their ETL packages from SSIS to Informatica. Before beginning development, an inventory of data sources and an architecture diagram were developed. During development, the client’s staff was trained on Informatica providing the ongoing resource needed to support the new tool.

How We Went from Ideas to Impact

  • The Idea

    Oversee migration of ETL capabilities from SSIS to Informatica and develop transformations for a new architecture.

  • The Process

    Map migration, diagram existing architecture and provide data source inventory to client.

  • The Impact

    Successful migration with minimal disruption, supplemented by training of technical resources for long-term success within organization.

  • While the migration was underway, UDig took extra time to train the clients’ technical resources, and provide hands-on learning experiences to setup the team for the transition.

The Idea

A large healthcare provider sought a partner to migrate their ETL capabilities from SSIS to Informatica, but did not possess the in-house knowledge to do so. In addition to simply migrating existing packages, several new transformations needed to be developed to account for a new architecture going live in the short term. Finally, the client sought to have their technical resources involved in the development of the solution in an “over the shoulder” capacity so they could learn the new tool and provide on going support.

The Impact

UDig’s ETL Developer worked with the client to understand the existing architecture, and map out the migration from SSIS to Informatica. A Visio diagram of the existing architecture as well as a data source inventory was provided as an output of this step. While the migration was underway, UDig took extra time to train the clients’ technical resources, and provide hands-on learning experiences to setup the team for the transition. The SSIS to Informatica migration went smoothly, with minimal disruption to operations. Further Informatica packages were built with the remaining time in the engagement.

  • How We Did It
    Data Sharing Solutions
  • Tech Stack
    SSISInformaticaVisio

Digging In

  • Healthcare

    Streamlining Healthcare Claim Denials for Revenue Recovery

    A robust Denial Notification Authorization (DNA) system that significantly increases the healthcare provider’s overturned denials and revenue.

  • Healthcare

    5 RPA Use Cases in Healthcare

    Fast Deployments for Fast ROI The best way to build momentum with robotic process automation is by deploying proven use cases. Most organizations have hundreds (or more) of bots they could deploy to boost productivity, but when you’re getting started, you’ll want quick wins. Here are five that yield the swiftest results. This eBook contains […]

  • Healthcare

    Automation Creates 24/7 Referral-Acceptance Capabilities for James River Home Health

    A 24/7 automated decision-making system that is 77% faster and accounts for 75% of referral decisions.

  • Healthcare

    RPA in Healthcare | 5 Use Cases for RPA

    If you work in healthcare, you’re familiar with inefficiencies. They exist in all corners of our practices. But it doesn’t have to be that way. Robotic Process Automation (RPA) in healthcare allows professionals to file cleaner claims and generate reimbursement faster. This post will explore use cases for RPA in the Healthcare Market from our […]

  • Healthcare

    RPA Use Case: Monitor Insurer Requirements

    It’s not easy to work in revenue cycle management. In addition to every medical practice having a long list of services they provide, whether or not those services are covered by insurance and how much the practice can charge is determined by what insurance plan the customer happens to have. For this RPA Use Case, […]

  • Healthcare

    RPA Use Case: Clinical Cleanup Bot

    Medical testing plays a crucial role in patients’ early detection, diagnosis, and treatment of conditions. Similarly, clear and correct clinicals are critical to fair and timely insurance claim processing for patients and providers alike. According to Health IT Outcomes, most providers report a 70-85% Clean Claim Rate (CL-1), meaning more work to gain reimbursement from […]

  • Healthcare

    RPA Use Case: Optimize Patient Scheduling

    Though all patient encounters are unique, each begins with an appointment. And because there is a finite number of appointments within a given day, there is a set limit of revenue to be gained. And for all practices, filling the available slots are key to maximizing practice revenue. After all, operating expenses don’t go away […]

  • Healthcare

    RPA Use Case: Drive Referrals

    For medical specialists, referrals are a critical source of revenue. In a world where more consumers turn to Google first, referrals still loom large as a key reason a patient reaches out to book an appointment. Increasingly, medical practices seeking to maximize patient revenue are turning to robotic process automation (RPA). In this Use Case, […]

  • Healthcare

    RPA Use Case: Prep Bots

    Imagine your business had a 25% failure rate. Chances are, you’d want to improve. And for healthcare professionals, prep bots powered by robotic process automation (RPA) offer you the opportunity to do so. A colonoscopy is the procedure of choice for screening and preventing colorectal cancer (CRC). Patients should undergo routine colonoscopy every ten years […]