System To Analyse & Monitor Service Level Compliance For Utility Services Company

Technology Used

Microsoft SQL Server, SQL Server Analysis Services (SSAS), ASP .Net

Customer Profile

A leading multinational corporation in the business of maintenance of facility like oil, gas, water, power, telephone & roads in the USA

Customer Situation

  • Need for a system to analyze and monitor service level compliance
  • Improve inspection route allotment for efficient resource allocation and utilization
  • Integrated view of information to enhance analysis & decision making
  • Leverage the power of the Data Warehouse to enable Analytical decision making to improve operational efficiency

Congruent's Solution

  • Design, development of a BashUp solution based on virtual earth maps
  • The new solution superimposed the maintenance and inspection information from the data warehouse on Microsoft virtual earth
  • The solution supported analytical needs to improve operational efficiency by letting the decision maker browse through the dimension/s of interest
  • The solution also leveraged the power of OLAP cubes with the functionality of Microsoft virtual earth
  • 100% offshore model. Design, development, implementation and support done in offshore model


  • Visual decision making improved monitoring of SLA
  • Increased resource utilization for facility monitoring and inspection
  • Robust & flexible management by exception
  • Optimized maintenance route allocations
  • Leveraged power of multidimensional data views

Know more about our Data Analytics Consulting Services