Case Study
Agilisium’s Automated Data Integration solution for SnapLogic quickens Pharma Sales insights
Overview
“Agilisium architected, designed and delivered an elastically scalable Cloud-based Analytics-ready Big Data solution with AWS S3 Data Lake as the single source of truth”
The client is one of the world’s leading biotechnology company, with presence in 100+ markets globally, was looking for ways to maximize impact of their sales & marketing efforts.

The lack of a single source of truth, quality data and ad hoc manual reporting processes undermined top management’s visibility of integrated insights on sales, sales rep interactions, marketing reach, brand performance, market share, and territory management. Understandably, the client wanted to align information that has hitherto been in silos, to gain a 360-degree product movement view, to optimize sales planning and gain competitive edge.

The Challenge


The lack of a single source of truth, quality data and ad hoc manual reporting processes undermined top management’s visibility of integrated insights on sales, sales rep interactions, marketing reach, brand performance, market share, and territory management

High time and effort for Manual upload and download data from the source systems into sales reporting systems
Existing reporting architecture was not conducive for near-real time Advanced Analytics.

Our Solution

Agilisium architected, designed and delivered an elastically scalable Cloud-based Analytics-ready Big Data solution with

  • AWS S3 & HDFS as data lake
  • AWS Redshift as data warehouse
  • SnapLogic to integrate data from multiple source systems to Amazon S3
  • SnapLogic to integrate data from multiple source systems to HDFS
  • SnapLogic to move data from staging to Analytical area in Redshift
  • Tableau as Analytical tool

SnapLogic Details

100 individual integration pipelines have been deployed across the enterprise for 10+ territories by lean team of 4 members and planned to implement 1000 integration pipelines (onboard 40 more territories) by end of 2018

Built an automated integration framework that can accept future integrations of territories of any data source types
Parameterized various data types from several data sources/systems into a standard format in SnapLogic

Results and Benefits
  • The Data Integration solution can now seamlessly integrate multiple integrate systems, technologies, and applications in cloud platform (AWS)
  • 360-degree view on product movement and sales progression is now available with reduced dependency on IT
  • 4x faster data processing & territory onboarding with the customized and automated data integration solution
  • Reduced Total Cost of ownership
  • Comprehensive data and analytics (SnapLogic + AWS + Tableau) solution which improved decision-making