Design of Web-Based Customer Relation Management Application for Power Distribution Company: A Case Study of PHCN Owerri Business Unit

Akinloye Bolanle Eunice, Anthony Mfonobong Umoren, Idorenyin Markson


In this paper, the design of web-based customer care application for power distribution company is presented with Power Holding Company of Nigeria (PHCN) Owerri business unit as the case study.  The system is developed to address the problems of poor customer services experienced due to the manual approach that has been used by PHCN. The system provided web-based volunteered information system for capturing, sorting and disseminating customers’ information, as well as for attending to customers’ complaints and bill payments. Furthermore, a mapping functionality is included to enable the system to capture and process spatial information of the customers and PHCN facilities.  A modified waterfall methodology is adopted in the web application development. The activities involve in the modified waterfall model includes requirement engineering, planning, designing, coding, testing integration and deployment. The web application is implemented using PHP as the server side scripting language, Java for the client side scripting language, MYSQL for the database management system and it is hosted locally using Apache web server. Equally, a third party web map application is interfaced based on Google map application program interface (API version 3).  Sample data are used to demonstrate the effectiveness of the customer care and customer cum facility mapping system.


Waterfall Methodology; Web Application; Customer Relationship Management; Volunteered Information System; Database, Scripting Language; Map Application Program Interface

Full Text:



Boyinbode, O., Akinyede, O. (2015). E-Customer Care Service System for Benin Electricity Distribution Company. International Journal of Computer Applications, 116(7), 1-6.

Ardabili, F. S., Daryani, S. M., Molaie, M., Rasooli, E. H., Kheiravar, M. H. (2012). Importance of Mutual Relations on Customer Satisfaction in Industries with No/Low Direct Contact with Customers. African Journal of Business Management, 6(29), 8637-8643.

Amoako, G. K. (2012). Improving Customer Service in the Banking Industry-Case of Ghana Commercial Bank (GCB)-Ghana. International Business Research, 5(4), 134-148.

Addai-Minkah, M. (2011). The Importance of Customer Service in the Banking Industry: The Case of Ecobank Ghana Limited (Doctoral dissertation), KNUSTSpace, Institute of Distance Learning, Kwame Nkrumah University of Science and Technology.

Ngobese, N. (2011). Client Perception of Service Delivery in the South African Police Service Community Service Centres in the Greater Durban Area (Doctoral Dissertation), Department Of Marketing, Durban University of Technology.

Kishore Subban, M., Pillay, P., Bhowan, K., and Raga, K. (2007). Towards Effective Service Delivery via Customer Relationship Management. Alternation, 14(1), 34-58.

Peters, C., & Mazdarani, E. (2008). The Impact of Employee Empowerment on Service Quality and Customer Satisfaction in Service Organizations: A Case Study of Länsförsäkringar Bank AB: The Impact of Employee Empowerment. Västerås: Mälardalens högskola, 71.

Okiro, K., & Ndungu, J. (2013). The Impact of Mobile and Internet Banking on Performance of Financial Institutions in Kenya. European Scientific Journal, 9(13), 146-161.

Claessens, S. (2006). Access to Financial Services: A Review of the Issues and Public Policy Objectives. The World Bank Research Observer, 21(2), 207-240.

Sadeh, T., & Ellingsen, M. (2005). Electronic Resource Management Systems: the Need and the Realization. New Library World, 106(5/6), 208-218.

Turban, E., King, D., Lee J.K., Warkentin, M., Chung, H.M. (2002). Electronic Commerce 2002: A Managerial Perspective. NJ: Prentice-Hall International, USA.

Blakey, A. (2013). SunSpot: A Spatial Decision Support Web-Application for Exploring Urban Solar Energy Potential. UWSpace.

Eldrandaly, K. (2007). Expert Systems, GIS, and Spatial Decision Making: Current Practices and New Trends. Expert Systems: Research Trends, 8, Editor: A.R. Tyler, 207-228.

Mennecke, B. E. (1997). Understanding the role of geographic information technologies in business: Applications and research directions. Journal of Geographic Information and Decision Analysis, 1(1), 44-68.

Sambo, A.S., Garba, B., Zarma, I.H., and Gaji, M.M. (2012). Electricity generation and the present challenges in the Nigerian power sector. Journal of Energy and Power Engineering, 6(2012), 1050-1059.

Adepoju, G.A., Ogunjuyigbe, S.O.A., and Alawode, K.O. (2007). Application of neural network to load forecasting in Nigerian electrical power system. The Pacific Journal of Science and Technology, 8(1), 68-72.


  • There are currently no refbacks.