Case Study

Premier Water Utility Firm streamlines Business Processes through Oracle

The Client

It is a Premier Water Utility Company in Democratic Republic of the Congo (DRC) charged with production and distribution of water to residential, commercial and industrial customers.

The Business Necessity

Company was running it’s business using legacy applications, which are not integrated and it is unable to derive business benefits that are available in ERP applications using French and English. Multiple applications were running for Finance, Water Meter Reading and Collections. There were challenges in uniform account code across locations and use.

The GreenChain Involvement

A team of three consultants were involved and executed the work from Kinshasa, capital of DRC. Consultants worked with Project Manager, who is bilingual, both French and English, interacted with business users to understand how business transactions are entered in their legacy systems and how reports were generated and used. Consultants configured Oracle ERP Release 11.5.9 covering Financials, demonstrated business processes, explained business benefits, conducted Training in English and French, provided User Manuals, Training Manuals. Consultants migrated data from both Manual and Legacy Applications after checking quality of data available with business users.

The Project Duration

Our Contribution to the project has started in September 2005 and completed in May 2006

The Team Composition


Mr. Sarma Vemparala has acted as Lead Consultant, involved in the project from the beginning till User Acceptance. He has participated in discussion with business users and conducted training to users. He interacted with Oracle on behalf of client for executing the work and to achieve progress.


Mr. Tirumalasetty Raja Sekhar has acted as Lead Oracle Applications DBA, involved in the project from the beginning till installation of applications including patches and brought system to stability. He also added value from offshore as and when necessary.


Mr. Andhavarapu Sagar Gupta has acted as Consultant, involved in the project from the beginning till configuration of all Financial Applications. He facilitated process documentation, configured applications, testing of business cycles as practiced by users in legacy applications.

The Benefits

The company was able to run business transactions, take business related decisions and generate statutory reports.

You will be always aware of all business and financial news !