Home | About Us | iDecisions® Video| SCM on Cloud| Contact us | Sitemap
  Tech Mahindra

informatica Winner of Global Insight Award(Informatica) twice for iDecisions® implementation in Asia
iDecisions® implementation helped Tech Mahindra (Erstwhile Mahindra Satyam) to win CNME IT award in Middle East in FY 2011-12
The Client is national carrier of the State of Kuwait. This well-known mid-sized airline as with any other airline has its mission critical systems for Passenger/Cargo reservation; revenue & cost accounting functions amongst others.
On account of its varied systems leading to a very heterogeneous environment, the customer took a strategic decision to implement a world class Data Warehousing and Business Intelligence system. It needed an improved data acquisition with High level of data quality, validation and reconciliation. It also needed improved data integration to provide accurate data for an improved decision support system. Tech Mahindra recommended to implement Business Intelligence solution for the customer.
icon Difficulty in getting external application provider to send data feeds from their systems that were based on legacy platforms
icon Inability to establish or get master data for conformed dimensions from internal and external sources
icon The team encountered a lot of delays and inertia from users majorly in getting HW/SW ready and from getting data from source systems
icon No structured data integration/acquisition mechanism
icon Challenges with timeliness and relevance of data
icon Reports available for only pre-defined queries
icon Integrate the multiple sources into a Data Warehouse, providing one version of the truth
icon Use of Oracle and Informatica for Database management
icon Implementation of OLAP Decision Support layer using Business Objects, helping faster and accurate decision making
icon Providing capability for ad-hoc querying
icon Built about 100 reports
The steps involved :
icon Detailed understanding of Business and Users’ needs
icon Define Technical Architecture of the solution
icon Create Logical & Physical Data Models
icon Develop the DataWarehouse & Business Intelligence system
icon System Testing & UAT support
icon Create Meta Data & Data Dictionary
icon Integration & Implementation of EDW System

Business Benefits
  • Information retrieval and anal ysis without dependency on people and on hosted application
  • Efficient Monitoring of KPI
  • Performance efficiency: Reduced time and efforts in report generation
  • Integrated Reports : Analysis of Integrated Information for Finance, C&M, HR and Networks in reports
  • Enabling the users awareness as well as skills through trainings
  • EDW brings a BI culture – providing data integration and the power of playing with data through sophisticated slice & dice tools
  • Provides top management with Dashboards for high level monitoring of company's health

Implementation Highlights
    Technology used are
    • Optimum deployment of resources in view of the project delay
    • By maintaining a log of follow up actions and delay reasons, we were able to safeguard ourselves from possible penalty clauses for late delivery

The customer gained increase in revenue with new improved systems. They also gained high visibility and credibility on account of benefits received from Business Intelligence application.
Copyright © 2015 Tech Mahindra