A Tech Story

Solving time-to-market with Serverless

Skipta, a branch of the Informa Pharma Intelligence group, provides a social network for nearly 1M U.S. healthcare providers (HCPs), connecting them with peers, clinically relevant content by specialty, and brands and product manufacturers within the healthcare field.

The rapid growth of platform users and brands has brought the underlying architectural issues the team inherited to the forefront: maintenance is time-consuming, the rollout of new features is encumbered, and critical data is fragmented and often stale.

Informa Pharma Intelligence

Problem, Approach, Results.

Nothing more, nothing less. Take a quick view of how we identify components of a problem, settle on an approach and drive results.

AdobeStock_135286435_Preview
The Problem

The system issues fall into two arenas: the Contacts database was inherited from another unit, using an outdated PHP framework with a poorly designed schema, and no proper ETL processes for importing, updating, or synchronizing data. The platform architecture was entirely decentralized with over 25 Drupal databases.

AdobeStock_355254981_Preview
This means:

With improved data quality, hygiene, and governance in place, the business will be better positioned to monetize the data and improve targeting and segmentation for brands.

AdobeStock_358963187_Preview
Our Approach

The most impactful change is the data integrity, so we begin with the Contacts database. We tackle the Contact databases issues by rebuilding the contacts storage schema and some ETL processing around the data including DB triggers that will keep the data consistent. PostgreSQL will replace MySQL. We use a Serverless REST API based on node.js and static admin UI hosted in S3 using VueJS. The Contacts service API load isn’t that large so hosting this functionality based on serverless architecture provides fast performance, is easier to maintain, and will cost less from a hosting provider standpoint. Both the API and UI are rebuilt with modern and simple tools like node.js and VueJS using the power of TypeScript to increase system reliability and simplify maintenance and future development.

AdobeStock_500710655_Preview
Tech Stack

Technologies we used are: • AWS Lambda
 • AWS API Gateway
 • AWS Glue
 • AWS S3
 • AWS ElasticSearch
 • Vue 3
 • Typescript
 • Node.js
 • Python
 • PostgreSQL
 • PHP

AdobeStock_244751017_Preview
The Results

The rebuild of the contacts database provides users with confidence in the data in the admin dashboard, with fresh user interactivity and statistics across all platform communities, and enriched data from 3rd party sources like Maropost. The development team has achieved a 50% increase in new feature releases, and the hosting costs have declined by 40%.

Ask Lineate's best and brightest.

Would you like to hear more from our Solutions Architect team about how we solved these technical challenges for this customer ?

Want some technical guidance from our SA's on a related problem?

Fill out the form and we will  cut to the chase - either get an email response or book a 10-minute call to discuss the specifics of the problem you're facing.

And P.S. -  This isn't a sales call in disguise - just an offer to pick our brains.

Enter your details below

Success Stories