Case Studies

About the client
The client is a leading cyber security and antivirus solutions provider for consumers and corporates.

Technology problem
The client was facing the following issues:

The client required to develop a single, open-source–based Business Intelligence (BI) solution instead of maintaining multiple reporting systems based on various technologies.

The existing data warehouse did not have dimensional modeling, which resulted in the lack of integration with new reporting tools.

Limited drill-down capability in the existing Excel-based reporting forced businesses to maintain various reports with the same data set.

Data visualization capability was not available.

The manual data collection and report generation process (Excel-based) in the legacy system was time-consuming and error-prone.

An inefficient reporting system resulted in the unavailability of useful information, which limited company data analysis and decision-making capability.

Technology solution
Cybage provided the following solution to help the client overcome its problems:

Cybage’s BI solution had a 2-tier architecture, which consisted of the Cube layer and the Presentation layer.

We designed and developed a data warehouse on the Oracle 11g server using Informatica as the Extract Transform Load (ETL) tool.

Cube layer: We capitalized on the intelligent compression techniques of QlikView to reduce the amount of data with daily incremental data refreshing cycle.

Presentation layer: We capitalized on the associativity technology of QlikView to establish the relationship among various tables and form a star schema, which, in turn, pulls data from QVD files to generate the reports.

Execution strategy
Cybage adhered to the following plan to provide effective results to the client:

We capitalized on the Scrum methodology for high visibility, active collaboration, effective communication, and predictable rhythm, resulting in a predictable schedule and improved productivity.

We used Planning Poker for agile estimation and effective planning.

We created a Proof of Concept (PoC), which verified the proposed architecture.

We capitalized on the Cenzic security framework to identify potential security vulnerabilities and take appropriate measures.

Value realized
The dashboards and analytical reports developed in QlikView:

Helped business users to uncover hidden trends and make discoveries that drive innovative decisions.

Enhanced productivity of business users by providing access to dashboards having rich reports with drill-up and drill-down facility.

Solution transforms the legacy data set into a common big data file system, create an inventory of all data sets, apply data science modules for imputation, fusion and weighting, and manages dependencies between processing steps and automate job execution.

Maintenance and utilization of versioned data to ensure data accuracy; for instance, storage and retrieval of data in versions.

Creation of cohesive components that could be rapidly plugged into the system for workflows to execute seamlessly.

Execution strategy
Cybage adhered to the following plan to provide effective results to the client:

Adhered to SCRUM and Kanban methodologies to accelerate new adoptions, help overcome common pitfalls and challenges, and to evolve a new framework that could sustain value-delivery and agility over time.

Utilized development tools such as SonarQube for static code analysis and code coverage to keep technical debt under control and manage code quality.

Value realized
The solution provided the following benefits to the client:

Using this platform, the client was able to offer comprehensive insights harmonized with local market intelligence, enabling its customers to make informed decisions.

The platform offered low data processing cost with high scalability and greater flexibility to adopt new data sources.

Extractor for individual sources that were run on AWS-EC2, raw JSON files were stored on AWS-S3, ETL and analytics were done on AWS-EMR cluster using Hive and Impala, result TSVs were stored in AWS-S3, results were copied to AWS-RDS (MySQL) using copy activity in data pipeline, and the reports were run on this data. All the schedules were managed by AWS–Data pipeline.

We perform Manual testing across the entire value chain to accommodate changing requirements in a dynamic smart devices environment.

We capitalized on a keyword-driven framework for automation to validate the stability of various functionalities on the web.

Value realized
Using this platform, the client offered a comprehensive solution for consumers and businesses to secure and remotely monitor homes and offices with a range of devices. The client ensured:

About the client
The client is a leading global Cloud Software-as-a-Service (SaaS) and Platform-as-a-Service (PaaS) provider. Its core solution is an integration platform that enables applications to network and connect with a variety of on-premises and cloud services.

Technology problem
The client was facing the following technology issues:

Rapid increase in customer base and transaction volumes was affecting the technology choices and hampering the scalability of the architecture. They were anticipating the year on year (YoY) load to increase at five times the prevailing rate and this had become an immediate challenge.

The client was also facing high annual licensing costs and insufficient instrumentation for rich reporting.

About Cybage

Cybage Software Pvt. Ltd. is a technology consulting organization specializing in outsourced product engineering services. As a leader in the technology and product engineering space, Cybage works with some of the world's best Independent Software Vendors (ISVs). Our solutions are focused on modern technologies, and are enabled by a scientific, data driven system called the DecisionMines™ for Digital Excellence. This unique model de-risks our approach, provides better predictability, and ensures a better value per unit cost to our clients.