Indian Oil Corporation’s Centralised Indsoft for LPG Distributors

Eradicating malpractices and inefficiencies in the supply chain of LPG that ultimately affects 7 Crore consumers

Indian Oil Corporations: eDARE

India's Top Software Projects 2012

uid-pg44

Govt. of Maharashtra's UID Linked Financial Inclusion

Table : IT Infrastructure

centralised-indsoft-for-lpg

Click here for the latest case studies

 

Nationwide roll-out of changes in the LPG accounting and distribution system was announced by the Ministry of Petroleum and Natural Gas on 14th of September, 2012. A serious challenge was thrown to the IT team of Indian Oil by changing the entire architecture from distributed to centralized, covering 6500 distributors (approx) across India. The architecture, modalities and changed business logic were to be redefined and implemented in two months which was earlier estimated to be an effort of two years.

The Implementation

The answer to curbing diversion of subsidized LPG and other irregularities was to invest in the right technology to identify the source and then putting in place business rules and processes resulting in prompt enforcement. The solution used was a data integration product -`Informatica PowerCenter Real Time Edition' with an in-house developed Java-based application.

screenshot

sdf

Challenges faced

INDSOFT was initially developed on a distributed architecture wherein each distributor premises were designed to have a locally stored database which is accessible through a front-end application. The software was also designed to generate an end-of-the-day file to be automatically transmitted to a central server hosted by IOC. The files accumulated at the central server from various distributor sites were used for generation of various periodical reports and monitoring. This solution had several limitations and shortcomings, however. Information was not available in the central system in real-time. The system only allowed retrospective detection of irregularities or malpractices. For example, detection of diversion of a domestic connection to a commercial establishment could only be determined on a post-facto analysis of the distributor's operations. The local database is owned by the distributor and prone to tamper, misuse of data. There was no support for encryption. Auto-deployment of new software versions were not possible and therefore it was difficult to prevent manipulations at remote end.

Company Scenario

Before deployment:

The management at IOCL was not getting an accurate picture of the sales that were happening at distributor sites in a timely fashion. There were rampant malpractices such as diversion of subsidized LPG and manipulation of sales figures. The challenge that Indian Oil faced was that the subsidy was meant to be provided via their distributor network, whose overall size being 6500 spread across the country, was pretty complex, with almost 60% of them based in remote locations with bad connectivity (dial-up connections) & having a standalone software which was vulnerable to intended or unintended alternation of data and frequent corruption of the local database. It was also important to ensure that no duplicates arise.

What was deployed: A centralised architecture was set up with the help of Informatica PowerCenter Real Time Edition and an in-house Java-based front-end was developed for the client end.

After deployment: The move from distributed to centralized reduced the implementation cost to one third of what was estimated and because of getting accurate and complete sales data in real-time, an enormous amount of savings took place. The transaction time has reduced from 48 hours to less than 2 hours and the deviation of LPG consumption is down to 10%. This has also led to a centralized platform for Aadhar-based subsidy.

Implementation partner: In-house project

 

 

Previous 1
  • Follow PCQuest on
  • become a fan on
  • Stay updated via
  • RSS

LEAVE A REPLY

Notify me of follow-up comments via e-mail address

Post Comment

AYYAJ 16 August 2014 at 12:27 PM Reply

KYC VACILLATION IS NOT SYNCHRONIZATION WITH CENTRAL SERVER LAST FIVE DAYS SO WE ARE UNABLE TO DATE CHANGE ( EOD) PLEASE GIVE ME SOLUTION

6 June 2014 at 05:20 PM Reply

It is good that new technology have come up and it is benefitting the us. As consumers we know know evrything from delivey to booking. But my dear friend, it is also wrong from your end that every time you blame the distributors from malpratices. Even you officers at top level and middle level are also into malpractices in your own way. I as a consumer appeal stop blaming evrytime the distributors that yes there are some distributors who are into malpractices, but not all, Before throwing mud at others, first loo at yourself. I am saying because my aunt to have a LPG Distributor, who runs it very smoothly, but Officers from from your corporation do not know how to behave with a distributor, talks rubbish. you call your distibutors business partners, but you all treat them as they are thief of broad day light, whereas you all not respond to distibutor problems and queries nicely.I am also a consumer of LPG. yes we do face problems from distibutor, sometimes their staff are rude, but that does not mean that they are bad. Make your supply position best from your end without any disturbance thn see if anything arises. Eveything will be normal and good.you people will create problems in delivering LPG to distibutors most of the times and then ask the distributors to make delivery on time, how can it be possible. you people can go for strike for long for not increasing ur salary increament, but when distributor do, you all ask them not to do as it will affect consumer. where was you all moral responsibility when you all went for a strike for long. Didn't you realise that at that time that it could affect the consumers.At least don'try to fool people any more otherwise you all wiil be thrown out. Anyways very good to hear that new system of indsoft is good.

Survey Box

Now that Microsoft has finally discontinued support for Windows XP, which OS are you likely to upgrade to?

Send this article by email

X