Informatica, a platform that saved $470 million for India (& prevented subsidy leakages)

Wed, 2016-08-31 12:32 -- SCC India Staff

Indian Oil

With the Indian government decontrolling petroleum prices, which paved the way for market driven pricing in a highly competitive market, Indian Oil (IOCL) needed to implement a dynamic pricing model that could be controlled at the corporate level through company-run retail outlets as well as distributorships/dealerships.

At present, Indian Oil (IOCL) has a network of over 43,000 customer touch-points that brings petroleum products to every part of the country. The company faced challenges on the retail side of both its petrol and LPG business, for implementing adequate centralised controls while maintaining agility in a distributed s

Here, IOCL deployed a common platform for both businesses using the “Real Time Streaming” capabilities of the Informatica Platform consisting of Vibe Data Stream and Real Time Data Integration components.

How it benefitted India
The solution adopted by IOCL met the goals of the Indian government to remove budget provisioning for LPG subsidy t the tune of roughly $1.5 billion. And the same solution saved $200 million in a year, preventing subsidy leakage by integrating consumer accounts across LPG companies in India.
The solution created a flow of about $2 billion into the banking system while ensuring that the subsidy reached the correct end consumer. According to the Comptroller and Auditor General of India, the audited annual savings from this LPG initiative is to the tune of $470 million.

The solution has enabled better decisions on dynamic pricing of petrol/gas and effective monitoring of stock and dispensing units at the retail outlets. Through proactive monitoring, the solution enabled preventative maintenance and averted market dry-out situations at petrol stations.

Lastly, it enforced better controls with respect to marketing disciplinary guidelines issued by the Ministry of Petroleum & Natural Gas.

What is Vibe Data Stream?
A steady stream of real-time data is pouring into your organisation: Clickstreams from Web servers, application and infrastructure log data, and information from sensors or agents placed on devices and machines comprising the Internet of Things. You can transform it all into actionable data, but only if you gather and analyse it immediately.

Informatica Vibe Data Stream for Machine Data (VDS) helped IOCL manage many small pieces of data as they flow in at high rates and accumulate quickly into large volumes. Vibe Data Stream is purpose-built for efficiently collecting all forms of streaming data and delivering it directly to both real-time and batch processing technologies — so you can analyse and act on it while it’s still fresh and relevant.

A distributed, scalable system, Vibe Data Stream uses Informatica’s proven high-performance brokerless messaging technology to greatly simplify streaming data collection. Features include:

  • Lightweight agents for an ecosystem of sources and targets
  • Brokerless messaging transport using a publish/subscribe model
  • Flexibility to connect sources and targets in numerous patterns
  • High-performance delivery direct to targets over LAN/WAN
  • Simplified configuration, deployment, administration, and monitoring

How it works
Out-of-the-box source and target agents collect and distribute streaming data through the high-performance message bus. The embeddable agents on sources collect data in real-time and stream millions of records per second into big data platform targets such as Hadoop and Cassandra.

Vibe Data Stream also streams data directly into Informatica PowerCenter Real Time Edition, Informatica RulePoint Complex Event Processing, and Storm to enable event processing and operational intelligence in real time.

The solution enabled the “Largest Cash Benefit Program” as recognised by the Guinness Book of World records, with Direct Benefit Transfer affecting over 125 million households.