It was critical that the company met and sustained the minimum requirements of the International Organization of Standardization (ISO) and the European harmonized version, demonstrating both product accuracy and consistency.
They take data quality very seriously – and for good reason. Gartner estimates that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. It is a serious impediment to digital transformation.
The stakes were even higher for Lifescan. Since it partnered with a number of HIPAA (Health Insurance Portability and Accountability Act) compliant healthcare organizations, Lifescan was required to be HiTRUST certified. Ensuring compliance in a SaaS context was a complex and specialized area, encompassing a variety of technical challenges covering intrusion detection, encryption of data, sophisticated auditing capacity and OS level security establishments.
More notable technical requirements include:
The company’s goal was to create the ability to build and deploy vetted, reusable coding procedures that would save the team significant time and money while meeting mission critical objectives.
It was imperative to identify an ETL tool that could process the glucose monitoring datasets with 100% accuracy, enable in-memory iteration on complex data models at the field level, provide serverless interactive query services, and provide flexibility around query modelling. With the right tool, the company could reduce the cost of on-boarding new diabetic patients by more than half compared to its existing approach.
Amazon Web Services’ (AWS) Glue was the right choice because of its ability to provide a fully managed ETL tool employing an in-memory Spark Engine with a dedicated data frame to handle field-level logics. Its underlying in-memory engine was fully managed Apache Spark, a distributed processing system primarily utilized for big data workloads. Spark enabled in-memory caching, and optimized execution for fast performance. It also supported general batch processing, streaming analytics, machine learning, graph databases, and ad hoc queries.
By moving to a standard configuration that could be self-provisioned, the team was able to deploy new code changes, enhancements, and updates to the transformation logic. This shift allowed for the in-time data provisioning needed to bring visibility to some of the key business KPIs and scalable systems to support sudden data growth.
Testing strategy, planning, and methodology were critical items for ensuring a high level of accuracy in the reports. AWS Enterprise Support also ensured the client’s ability to gain long term access to the product developers behind the services.
However, these migrations are not without their challenges, leading to a number of questions related to:
Design aspects to
load design and
Accurate reporting when the
data processing step truncates
decimals points which can
create huge data discrepancies
Infostretch was able to provide solutions to each of these challenges and enable the company
to transform its data analytics and intelligence platform.
45% Reduction in IT
Saved 2,200 hours of
operational maintenance and over $120K per year
60% less effort via
automation of monthly
analytics reporting scripts
Accelerates release of data
pipelines in new regions;
as fast as 2 weeks
Infostretch leverages a proven combination of technology, processes, and expertise to help enterprises accelerate the execution of their digital strategy. We deliver faster and more effectively by unifying expert professional services and best practices with pre-built software frameworks and products. Our 1,000+ development, testing and integration specialists have deep capabilities in DevOps, QE, app development, Cloud, AI, IoT and mobility.