Case Studies

The client leads hospitality group sales and distribution automation at the global level. They are committed to enabling service excellence, catering, and sales to its customers. Clients team members concentrate on offering a blend of technology and expertise to the customers facilitating them to attain their objectives.

Business Challenge
Inability to deliver reports generated by Client’s ASP hosted environment to printers at various locations across the globe
Inability to set up reports to printers

Business Solution
An architecture framework that provided report printing to various geographical regions
Development of Printer delivery extension for SSRS 2005
A configuration application to map reports to printers

Tools and Technologies
SQL Server 2005, SSSRS

Client’s Global Marketing Operations (GMO) provides strategic recommendations and tactical support to Marketing and Sales organizations to enable optimization of relationship marketing and revenue generation. GMO capitalizes on a number of analytic and technical databases and tools to make it possible to have a full changeover of marketing and sales from intuition-driven to quantity-driven processes and capabilities.

Business Challenge

  • Various reports presented different versions of the same information.
  • Scattered, redundant and inconsistent data.
  • Reporting measures accuracy issues
  • Lack of Central Reporting system
  • Report performance challenges


Business Solution

  • Effective implementation of Dimension model, Star schema data mart with  pre-calculated/aggregated data
  • Application of Data cleansing and integration techniques
  • Views/Index views for OLTP environment
  • Centralized reporting solution for Marketing and Sales department
  • SharePoint Dashboard and reports
  • Improved reporting performance and user experience


Tools and Technologies
SQL Server 2005, SSIS, SSAS, SSRS

Client is a leading service provider in Information Technology. Client is working on a project to automate processes/activities in IT Project Management. The project has a dedicated team to serve internal needs from different departments. The data in the system is highly confidential and cannot be exposed to Dev or QA environment As-Is.

Business Challenge

  • To create a development and test environment where in the test data scenarios are close to production data/replicate production data, without exposing any sensitive information from the production database.


Business Solution

  • Development of Data scrambling / masking framework
  • Implementation of various data scrambling techniques on Production database to create Dev, QA test data
  • Configurable and reusable data scrambling framework


Tools and Technologies
SQL Server 2005, PL/SQL

The automotive Retail industry in the United States has several providers of on-demand software and data solutions, and the client is one of these leading providers. Client product offers a lot of reporting capabilities to auto dealers. The reports offered give the dealers their sales, inventory, and appraisals-related figures along with other vital information, which help dealers run their business more efficiently

Business Requirements

  • Existing reporting solution is built on OLTP database
  • Complex business logic implemented in reports in OLTP environment results in performance challenges
  • Inability of users to take operational business decisions right in time due to unavailability of right information and unfriendly user interface of reporting solution.


Business Solution

  • Star schema based datamart design and  implementation
  • Pre-calculated/aggregated data layer
  • OLAP reporting solution based on cubes
  • Implementation of better report visualization techniques


Tools and Technologies
SQL Server 2005, SSIS, SSAS, SSRS

Client is a leading global media investment management company in the Media and Entertainment industry located worldwide. Client has its specialist services in various media and entertainment budget planning and optimization, which help in in-depth analysis of market spending and ensure better ROI.

Business Requirements

  • Huge amount of data and lot of manual intervention involved in verification, cleansing and formatting the raw data
  • Current process limitations in terms of large data transformations and processing
  • Traditional approach of data processing


Business Solution

  • Development of an ETL SQL framework
  • SSIS Implementation - Faster & Efficient data processing
  • Implementation of complex transformation logic using SSIS
  • Reusable data-cleaning programs, making future data updates from the same data sources in the similar formats fast and affordable.


Tools and Technologies
SQL Server 2005, SSIS

Client is a leading BI reporting vendor. The client delivers integrated BI solutions to all advanced and reporting analytical needs and business data queries and distributes insight to users on-the-go and at their desks. The client supplies the most robust, consummate solutions for BI to a very large number of technology and integration partners and customers across the globe.

Business Challenge

  • Complete ownership of Quality Assurance of vast and feature rich BI product to speed up the release cycles.
  • Need of Technical expertise for Widget Development.
  • Evolving development , quality assurance and documentation needs based on the dynamic market trend
  • Lack of Technical Documentation and User Manuals


Business Solution

  • Created the framework and processes for Quality Assurance of the product.
  • Quality Assurance of the product on variety of test configurations including
    • Server setup: Windows , Sun solaris, AIX, HP-UX, and Linux (RedHat, Suse).
    • Web servers: Apache, IIS, IPlanet, Weblogic, IBM Websphere, Sun Java system application server, Tomcat etc.
    • Databases: Oracle, SQL Server, DB2, MS access, etc
  • End to end QA right from Sanity, Regression , Acceptance, Compatibility, Documentation, Performance and Automation testing

TESTIMONIALS

Michael Meyer Testimonial

Michael Meyer talks about how Rate Highway Inc. has learned...

President and CEO,
RateHighway Inc.
Guy Amoroso

Ten years of relationship speaks volumes...

Managing Director,
123Insight Limited
Patrick Bustraen

We chose Cybage as the software partner and we had...

VP - R&D,
Transics International
Pontus Rogala

The domain understanding of Cybage experts...

Managing Director,
Airfair Flugservice GmbH
John Oberon

Cybage respects its customers' views and inputs...

VP - Engineering,
Intel(Mashery)
Vineet Gupta

Cybage has flexible functioning and friendly culture...

EVP & CIO,
Fairmont Raffles Hotel International
Robert Nix

Cybage team is a part of our company. Our 9 year old...

VP & Principal Architect,
AthenaHealth Inc.
Greg Wiggins

We are impressed with the Indian engineers' way of...

Director - Software Engineering,
Central Logic Inc.
Steven Knapp

Cybage has proven to be consistently reliable since...

SVP - Global Operations,
iCrossing Inc.
Dave Johnson

No team in Cybage works in silos. Our decision...

COO,
iCrossing Inc.
Howie Altman

The delivery team at Cybage has much higher quality management...

VP,
TravelClick
Frank Van Amerongen

The preciseness and quick reaction by Cybage team adds to our business...

Publishing Director,
ThiemeMeulenhoff
Harvey Goldhersz

The stability provided by Cybage has helped us scale-up...

CEO,
GroupM Analytics
Ben Bartel

Cybage's skilled team has helped us in developing healthcare solutions...

VP - Product Development,
Marketware Systems
Donal McGranaghan

Cybage provided us the transparency, and the efficiency of the delivery...

VP - Software Engineering and Quality,
DealerTrack