"Agilisium Consulting (previously Agileiss) is a US based Systems Integrator (SI) & Big Data solutions company offering optimized and cost-effective IT solutions to clients across media, entertainment and healthcare sectors. Our DNA is Data and Cloud engineering and our key focus is to help clients migrate their existing on-premise BI, Analytics or Big Data systems to Cloud platform solutions such as Amazon Redshift, S3 Data Lake, Kinesis and Elastic MapReduce in a rapid and most economical manner.

Capabilities and Benefits: Agilisium offers a Redshift Test Drive which serves to educate business and IT teams on cloud migration and requirements business case with ROI using the right solution methodology. Our core services include:

  • Review of existing system and requirements & expectations on new system on cloud
  • Provide migration blue print
  • Provide detailed plan with migration design, steps, effort, resources, schedule, cost, and risks
  • Migration data quality and stewardship
  • Migration project management
  • Reporting & analytics migration
  • Deployment, UAT signoff, post deployment support, post production warrantee, production handover, system rationalization and enhancements
  • Amazon Web Services Advisory and Consulting

Benefits: The four to six week engagement with Agilisium’s Redshift Test Drive has proven to benefit organizations in a few specific areas

  • Reduction in time to program kick-off by 90%
  • Reduction in program risks by more than 70%
  • Wider in-house migration experience to deal with migration issues"

Agilisium Consulting (2:22)

Agilisium_logo

Challenge:

A world’s leading media and entertainment company receives a variety of consumer, marketing and social media data from multiple sources at varying intervals for storage, reporting, and analytics purposes. This client’s existing BI & Analytics system was on an on-premise solution that posed serious challenges:

  • Lack of scalability
    • Storage data volume was increasing from 100 terabytes to 500 terabytes
    • Limited computing capabilities for data processing and reporting as they were competing for resources
    • Poor user experience due to inconsistent report performance
    • Unreliable data refresh commitments
  • Lack of quick access to data for users as they had to wait for ETL to complete
  • Expensive enhancement and maintenance with long lead times of up to 6 months for system changes
  • Limited development and innovation possibilities in the current environment resulted in unhappy IT and business stakeholders
  • Obsolete database system

By far the biggest challenge for the M&E Industry in the recent decade has been to rebuild its entire business process and systems in the most cost effective way so it can deal with the transformation caused by the digital disruption. The client wanted a large server setup, to scale with the growing volume of data which required processing 400 million records at a time.

Agilisium’s Solution:

Agilisium deployed their cloud practice professionals to change the existing monolithic ETL system to a scalable cloud based ETL system using the Amazon Web Services. Key highlights include:

  • Provisioning of cloud based data repository for storage (Simple storage service) and SQL repository (Amazon Redshift) to perform data analysis queries
  • Creating a scalable data pipeline to ingest, process and store data in the data lake
  • Defining security policies and audit & logging with services like S3 Permission and S3 CloudTrail
  • Building an API search access the data within the data lake
  • Users were able to get access to data from data lake with no latency

Benefits:

  • Unified 360-degree data reporting & analytics for client
  • Operational cost of BI & Analytics system was reduced by 40%
  • Infrastructure and computing was no longer a limiting factor for innovation
  • IT teams can now deliver enhancements to business teams in a span of 2-8 weeks
  • Business teams are now able to access data from Data Lake with no dependency on IT ETL and reporting teams
  • Delivered capabilities to process multiple data sets in parallel
  • Reduced DBA support from 3 resources to none

Challenge:

A leading music distribution and filming company receives sales and  transaction data from a variety of data sources. The existing Actian Matrix (Paraccel) solution was not able to handle the data influx caused by business growth. This resulted in storage issues and delayed reporting.

Agilisium’s Solution:

Agilisium migrated customer's Actian Matrix (Paraccel) data to Amazon Redshift in a short span of time with minimal business interruption. Key highlights include:

  • Migrated and validated 20 TB+ of data to Redshift
  • Optimized the Redshift cluster with appropriate distribution and sort keys for best performance. Created aggregated tables for consolidated reporting.
  • Developed incremental load processes and retry mechanisms

Benefits:

  • Data storage cost was reduced by 50%
  • Reporting time was reduced by 95%
  • Storage infrastructure is now scalable

 

AgileISS offers a test drive before migration to Amazon Redshift. To learn more please visit: http://www.agilisium.com/amazon_redshift or contact us AgileISS at: http://www.agilisium.com/contact-us

Agilisium_logo