1 / 64

e-BLL

e-BLL. Mass CIS / Billing System for utilities. Introduction. The purpose of this presentation: Who we are? Our work experiences Introduce e-BLL product. Who we are?. ALTARIQ Systems & Projects

finchg
Download Presentation

e-BLL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. e-BLL Mass CIS / Billing System for utilities

  2. Introduction The purpose of this presentation: • Who we are? • Our work experiences • Introduce e-BLL product

  3. Who we are? ALTARIQ Systems & Projects is solution provider company. We have some of the best experiences in their fields, and we are proud of. • We provide solutions in the fields of: •  Enterprise software solutions •  Control Systems & SCADA solutions •  Power Engineering Products

  4. Work Experiences Our Strategy: We focus mainly in the enterprise systems Innovative engineering products PLC & SCADA systems

  5. Products Samples: Enterprise Solutions: • eBill Mass Customer Information System • GEDCO electronic bill www.gedco.ps/eBill • Enterprise Stock Control • Enterprise Procurement System • ALBURAQ for Engineering Project Management • Myschool

  6. Products Samples:

  7. Products Samples: Engineering Products: • Patent for Over-voltage protection System • Automatic Meter Reading Solutions (AMR) PLC & SCADA:  Gaza fodder Factory PLC System and HMI interface

  8. GDECO (Mass electricity Billing System, CIS, and Customer Services): 6 Branches, distributed Database, Online Transaction Techniques. Strong Collection System Meter Reads Management And Now, we work with them to connect all these branches using Microwave Network to have a central Database, with central online management. Our biggest Clients

  9. Our biggest Clients AL-SAKHRA Management System. The biggest Retail in Gaza (More than 10,000 items, 100,000 monthly transaction, and 17 stores, 4 markets, 3 branches): • Branches Management • Stores Management • Sales Management • Procurement Management • POS / Touch Screen • Control & Security Management

  10. e-BLL short definition Is a Mass Billing System designed to serve medium and enterprise size Public sector companies and government institutions’ needs.

  11. Technical Part 1\5 The Application Concepts: OS: Windows2000 server, UNIX, LINUX Database: Oracle 8i, 9i Client Interface: Windows GUI Network Protocol: TCP/IP protocol Multi-user / Multi-session Environment Language: Arabic / English (Can be other in languages later)

  12. Head Center S e c u r i t y L a y e r Data Flow Branch 3 Branch 1 Branch 2 Technical Part 2\5 Topology: The system can work in an single branch structure and/or multi-branches with central head structure.

  13. Technical Part 3\5 Database Container: The database can hold all the other integrated applications: Financial Management Stores Management Operations Management GIS Database …

  14. Main Database CIS / Billing Billing DB Financial System Financial DB Stores Stores & OperationsDB GIS GIS DB & Any Extra

  15. Branch 1 Billing CIS …… Billing CIS Branch 2 Stores Billing …… Replicated sub database CIS …… Using MW Network The distributed main Database 4\34

  16. Technical Part 4\5 Transactions Approach: The System uses Online-Transaction techniques, that gives the following capabilities: • The system knows what are going on anywhere in the system on the real time it occurs. • Any error does not suspend the system! The systems comes over and continue while the error is under processing or hold for later treatment.

  17. The system manages more than one process at the same time (When no dependency) • Error detection at the real time it occurs. • Reduce process time and optimize the performance. • Gives the user/client direct, fast, and accurate answer at the time of the inquiry.

  18. The system uses the Posting techniques, therefore any data operation can be draft, canceled, delayed, and/or posted. (un-posting is available for privileged users) • Commit and / or Rollback are available at any time. • In central/branches environment, online approach gives the exact, right, and fast answer about: Collection, meter reads, and any type of transactions. Specially when using ElectronicCollectioncompensations among Branches!

  19. The system administrator can grant the privilege of any type of transaction on certain module and under certain constraints to a certain user. • Any process can be restricted to certain criteria, and therefore a privileged user can collect/post/calculate and print certain bill in less than 1 minute! • Its possible also to work using batch approach. But with many less features.

  20. Technical Part 5\5 Branches Management: In Central / Branches environment, the branches management is a very hot issue: We developed e-BLL Agent to: • Manage Branch ~ Central ~ Branch relation. • Enables the remote management capability. • Control the branches in-between operations.

  21. E B L L - A G E N T Branch 1 E B L L - A G E N T E B L L - A G E N T Main Center Branch 2 E B L L - A G E N T Branch 3 Branch Database Center Database Using Microwave network Billing CIS Branch Database Billing CAS Billing CIS …. CIS Billing CAS CAS CIS …. CAS …. …. E-BLL Agent diagram

  22. System Modules 1\3 Basic Modules • CIS • Pricing System • Billing • Collection • Meter Reads Management • Security • Control System • Reporting System

  23. System Modules 2\3 Optional Modules • Inspection System • Archiving System • Readers/Collectors affairs • Palm Devices Management System • Integration with GIS

  24. System Modules 3\3 Web Modules • e-BLL CIS Web • Top Management e-BLL Web

  25. CIS Customers Information System treats: • Customer fixed data (Personal, property, contractual, …etc) • Technical information (GIS Link) • Customer historical data (any change/update/Delete ... etc) with date/user of the transaction • Suspension/Activation or any other type of process the customer status. • The System classifies customers according to any (or combination) of: Home/Commercial, Usage, some technical factors, …

  26. Each Customer/Meter Number is a subscription • Full data inquiry • Statistical reports by: Status, Type, Usage, Consumes, locations, regions, … • Each branch has is Customers Database, and the central database has a replication of all branches data. • Full Reporting System. • The system enables classifying Special customers with special procedures.

  27. Pricing (The most powerful pricing tool) • The system have two options for pricing: • Fixed meter unit price • Pricing Slides (Tariffs) • For any pricing policy, the system can assign different tariff for: • Different customers types • Different customers by usage • Different regions (If required) • The system can assign some customers with a special pricing policy, and for a certain period. (for special purposes) • Pricing slides can be fixed for all customers or vary according to certain criteria.

  28. Any used tariff is not updateable, but a new version with new values can be generated. • A draft Tariff can be created for statistical & estimations purposes. Like saying: If we use this Tariff we will get these expected variation in consumes / money. (Impossible in batch techniques) • The System indicates if there are any customers out of the slides before the calculation.

  29. Billing (The fastest) • Very easy graphical procedure to calculate bills (or a bill) • Enables to calculate all, or any criteria of customers (examples): • Certain Customer • From location to location (and regional) • Type (or usage) of customers • The billing automatic assign each customer at run time to its tariff record according to the classification of the customer, the pricing policy, and if the customer may has a special pricing definitions.

  30. The easiest • The system can recalculate any bill (criteria of bills) • In case of any variation on the calculated bill/bills than the previous one(s) the system generates a new version of the bill/bills automatic. So, any modified bill can be tracked historically. • Customers with errors appears through the calculation are listed aside, and stored for correcting their mistakes and recalculated again. • The system is able to assign special 4 lines message to the bills (according to many criteria's) • Its possible to send certain customer a certain message! The criteria can be: Location, Region, Type, Usage, Value of consumes, Consumes, …

  31. The easiest 2 • The calculation is always draft until posting. • The bills can be printed using several printers at the same type, and these printers can be in several locations, without any overlapping. • Any wrong bill can be treated completely alone, from the meter reads process, collection process, and calculation process in no time.

  32. Real Statistics • GDECO customers around 150,000 • The system monthly enlarged with around 600,000 record. • Full calculations for this number is around 20 minutes. • Posting payments make around 800 payments / minute.

  33. General Cycle

  34. Collection Very important goals • The fastest way to enter the collections. Customers may have no time. • The accuracy and verifications are very important also. • Manage the enough number of collection points. • The short time between the consumed units and collecting their values = The success of the business!

  35. Collection Architecture

  36. Very important features • The collection structure works like bank cashiers. • The system accepts payments cash, checks, bank, partial payment, and on debit. • Online verifications take place while the collector and the verifier in 2 different physical places. With online posting/revision request.

  37. Very important features • The system works over normal PC, or on Cashier with receipts, automated stamping the bill, and cash drawers. Compensation

  38. Main DB Central Branch Subscribes of branch2  Pay Ask for user info Ask for Bill info Process Ask for prev payments Payment accepted & processed Response All info available Subscribes Not Exist Compensation Room updated Alert Update Main DB Operation rejected Print Receipts for The subscribes Return to user control Branch 1 11\34

  39. Meter Reads • Meter Reads collected through readers using preprinted reports to fill. • Closed houses, and defected meters are considered. • The system measure over/under average meter consumes. • Palms can be used to get meter reads. • Sheet entries for fast entry and authentication. • Full reports to revision before posting.

  40. Full Cycle Diagram

  41. Security (Strong & Easy to deal with) In addition to the OS Security: • The system inherits Oracle Security • Use the concept of Groups / Roles • The privileges are task-oriented derived. • You do not need a DBA to control your security! We have our own GUI privileges Manager Software. • System can prevent multiple login, and fix special user to login from certain machine!

  42. User usually can login from any machine • Only the privileged modules are enabled. • The system records each change on the database in an special achieving file, and gives full inquiry to the super user(s) to track any user events. • Branches users (when connected to the central) and through the EBLL agent are under full control from the super user in the central. • Certain users can be privileged object access rights (Query, Insertion, Deletion, Update)

  43. Control Monitoring the System: • Monitor each user and his current activities. • Monitor the collection rates, places, and operations. • Monitor the readers activities • Suspend/Disconnect/Activate/Retire any user on the system remotely • See & print statistical graphs describe the system operations grows, and status.

  44. Report Manager • Reports are classified on job-oriented groups. • Each user has certain privileges for certain reports. • User can send his report to any printer in the network. • The system detects any report will be sent to printer by more than one user at a time! • The reports are two types: Laser Reports Goes to laser printers & Character Reports goes to Dot-Matrix Printers.

  45. Inspection System - Team Works, vehicles, engineers, … - Vehicles operations (to be linked with the Accounting) - Inspections, and inspection details, with transactional history. - Customer’s suits or cases and arbitrates. - Cases, cases details, and case’s ankylosis. - Notice management - Meters operations ( Installation, inspection, …) - Legal Consultant notice management. - Inquiries and reporting system.

  46. Meter Reads Management - Readers assignments and control their results. - Manages the vehicles used for readings or shared with other departments/tasks. - Readers comments (linked with the inspection system?) - Readers Management, schedules, and comparing their results with the observer authentications. - Inquiries and reporting system.

  47. Archiving System This module archive every transaction occurs in the system, classified by its type, customer, date, and user. This system is linked to: - The CIS - The payment system - The services and maintenance system - The Customers Services System (CSS) - The Cutting Module - The inspection System - The financial system (in future)

  48. Palms 1 By using Palms we want to achieve: - More accuracy in meter reads - Better performance of readers - Fast entry, leads to more people for analysis and observing. - Reduce the time between issuing the bill and collecting the money.

More Related