Hello, I’m Mohamed AARAB, a Software Engineer and digital solutions expert with extensive freelance experience and over 20 successful projects. I specialize in website creation, ERP implementation, and automation to help businesses save time and optimize their operations. My mission is to provide innovative, efficient, and user-friendly solutions tailored to your needs.

Social

ElectroBill

A Comprehensive Web App for Electricity Bill Management

Overview

ElectroBill is a dynamic web application designed to streamline the management of electricity bills for both customers and suppliers. The application offers a transparent and automated system for generating electricity invoices based on consumption, allowing customers to monitor and manage their billing while enabling suppliers to oversee customer data, annual consumption, and billing operations. With advanced features like a dashboard for statistics and automation of annual consumption uploads, ElectroBill enhances efficiency and reliability in utility management.

Key Features

Customer Portal :

– Enter monthly electricity consumption manually or upload a meter photo for automated calculations.
– View and download electricity bills, both with and without taxes.
– File complaints regarding billing or services directly through the portal.

Supplier Management :

– Add, modify, and manage customer information, including geographical data.
– Verify annual electricity consumption data submitted by agents.
– Automate the generation of bills, including customer details, consumption, and tax calculations.

Agent Functionality :

– Manage customers by geographical area and submit annual consumption data.
– Oversee the accuracy of consumption records for precise billing.

Dashboard and Analytics :

– View detailed statistics, including unpaid bills, monthly electricity consumption, and area-specific data.
– Gain insights into operational trends for better decision-making.

Automation :

– Automatically insert and verify annual consumption data from agents’ uploaded files.

Implementation Highlights

- Backend: PHP 8 for efficient server-side processing.
- Frontend: HTML5, CSS3, and JavaScript for a responsive and user-friendly interface.
- Database: MySQL for structured and secure data storage.
Modules Developed:
- Customer, Admin, and Agent spaces for role-based functionality.
- Dynamic invoice generation with accurate tax calculations.
- Automated workflows for data insertion and processing.
Responsive Design: Ensures seamless usability across devices.

Achievements

– Delivered a comprehensive billing solution that simplifies electricity bill management for customers and suppliers.
– Automated annual consumption uploads, reducing manual workload and improving accuracy.
– Enabled suppliers to track and resolve unpaid bills effectively using an advanced analytics dashboard.
– Improved customer satisfaction by offering a transparent billing system with complaint resolution.