Meeting at Kolkatta on 29 th / 30 th June 2007

1. Presentation to BSNL On CDR based Customer Care & Billing SolutionFor EastByHCL INFOSYSTEMS LTD. Meeting at Kolkatta on 29th / 30th June 2007

2. Agenda • Solution Architecture • Assumptions & Exclusions • Hardware sizing for Servers (Application wise) • Power supply calculations • Network Architecture & security set up • Application Functionality • Preliminary Plan of the Project • Q & A

3. Solution Architecture

5. CRM Collection & Mediation Provisioning System

6. Assumptions and Exclusions

7. Assumptions and Dependencies • BSNL shall provide necessary lab environment including all PSTN switches for the testing of Provisioning Solution. • BSNL shall ensure availability of sufficient and concerned staff members for the detailed requirement capture / analysis exercise and training and support during implementation, for which a detailed support manpower requirement will be given. • For any performance SLAs expected that involves switches/exchanges; there would be dependency on the switch/exchange involved and shall totally depend on performance of switch/exchange. • BSNL shall provide all literature and interface details for each of the NEs to be provisioned, also field expertise related to core competency. • The functionality of the Line testing will be within the Switch. • BSNL will provide full information of the various external system to facilitate integration with these systems. • BSNL will ensure the data quality and data enrichment, which is mandatory for execution of the system. • Preparation of environment and site as per specification in terms of power, cooling and infrastructure for installation of equipment and establishment of test / production equipment. • BSNL will provide sufficient bandwidth during testing period as well as for production environment, with provision of peak load. • BSNL will provide support in testing the test cases, involving the switches / exchanges in live environment, to ensure seamless migration.

8. Hardware deployment of Servers

9. Logical Diagram for deployments at BSNL Redundant Ethernet Network for Public access and Clustering Management Console Edge Servers HP Proliant DL360G5 & DL580G4 Servers HP rx6600 CDOT Servers HP rx3600 T&D Servers HP Superdome Servers + IBM P 595 SAN Director Switches SAN Director Switches HP Tape Library VTL Array Storage arrays

10. Enterprise Reporting Servers Mediation Server Accounting Servers Provisioning Servers Web Self Care Servers Billing Servers CRM Servers DQ Servers Inventory Management Servers EAI Servers Bill Formatter Servers EMS Servers NMS Servers Back up Servers Electronic Stapling Servers Revenue Assurance Servers Deployment of Main Applications on Back End Servers at BSNL East Main Server Pool ( 6 HP Superdome) N+1 Server Pool ( 5HP Superdome) IBM P595 (1+1) N+1 IBM P595 IBM P595 DR Servers for south HP Superdome HP Superdome HP Superdome HP Superdome IBM P595

11. Proposed Deployments at BSNL East Redundant Ethernet Network for Public access and Clustering Billing CRM Mediation EMS Backup Provisioning CRM EAI EMS Backup DQ Management Console Billing Edge Servers HP rx6600 Servers HP rx3600 Servers HP Superdome Server + IBM P 595 SAN Switches HP rx3600 Server HP rx6600 Server HP Superdome Server + IBM P 595 N+1 Servers Tape Library Test & Dev Servers VTL Storage Storage System HP rx3600 Server HP rp6600 Server

12. Power Calculation – East Data Center Note: Power Factor = 0.98 1 Watt = 3.413 BTU/hr

13. Power supply Calculations

14. UPS-3 200 KVA BUS-2 BUS-1 UPS Architecture – East Data Center SBP (Service Bypass Panel): The Inputs to UPS’s will be provided through SBP SBP (Service Bypass Panel) : The Inputs to UPS’s will be provided through SBP. UPS-1 200 KVA UPS-2 200 KVA UPS-3 200 KVA UPS-1 200 KVA UPS-2 200KVA SBP (Service Bypass Panel) : The output to load will be provided through SBP. SBP (Service Bypass Panel) : The output to load will be provided through SBP Data Center Load

15. 20 10 15 Space for Stairs & Lift - 300 sq. ft. 15 30 Office Area 450 sq. ft. Visitors Lounge 300 sq. ft. Entrance 1 15 Door 10 Conference Room 625 sq. ft. Printer Room 250 sq. ft. Transparent Glass Window Security Monitor & Guards Room 600 sq. ft. 25 Total Area = 10900 sq. ft. 10 Corridor Tape Store 250 sq. ft. Workstation Hall 625 sq. ft. Entrance 2 25 Store Room 200 sq. ft. 10 Dispatch Room 200 sq. ft. 10 Telecom Equipment Room - 200 sq. ft. 10 NOC 600 sq. ft. UPS Room 400 sq. ft. 60 20 Server Room 3900 sq. ft. Generator Room 400 sq. ft. Testing Room 300 sq. f t. 20 65 15 5 20 DATA CENTER LAYOUT

16. Network Architecture & Security set up

17. Exchange Router (Cisco 2811) Exchange Router (Cisco 2811) Exchange Router (Cisco 2811) Exchange Router (Cisco 2811) Exchange Router (Cisco 2811) Exchange Router (Cisco 2811) Type-1 Switch (Cisco 6513) Exchange Router (Cisco 2811) Type-1 Switch (Cisco 6513) Aggregation Router (Cisco 7507) Aggregation Router (Cisco 7507) Data Center Data Center Router Router (Cisco 7513) (Cisco 7513) PSTN Switch PSTN Switch PSTN Switch PSTN Switch PSTN Switch PSTN Switch PSTN Switch CDR Flow in BSNL Network X.25 Serial Link X.25 over TCP/IP PE Router (Cisco 7613) E 1 l i n k IP over MPLS VPN PE Router (Cisco NIB-2 7613) MPLS VPN Network PE Router X.25 over (Cisco TCP/IP 7613) Data Center LAN Backbone PE Router Router (Cisco PE Router 7613) (Cisco 7609) (Cisco GigE 7613) Backbone Router PE Router (Cisco 7609) (Cisco PE Router E3 / STM- 7613) (Cisco 10/100 7613) 1 link Ethernet PE Router (Cisco 7613) Central Serial Link X.25 Router Serial Link or (Cisco 7513) IP CDR Collectors

18. Detailed Network Connectivity at Data center Internet NIB MPLS Network CSR’s Internet Cisco 7609 Cisco 7609 Cisco 7609 Cisco 7609 Backbone Router Internet Router Cisco AS5350XM Nortel Alteon 2621 Nortel Alteon 6616 Nortel Alteon 6616 Cisco 3400 Symantec Network Security 7160 AAA Servers Reverse Proxy Server HTTP Server DataCenter Router Provisioning Server EAI Server DQ Server RA Server Print Server EMS Server Ent Reporting Server Cisco 6513 Switch Type-1 Cisco 6513 Switch Type-1 Interconnect FMS Server Database Server Mediation Server Billing Server CRM Server Backup Server Cluster Servers Security Servers NACS/DMS Server IM/AM Servers LDAP Servers SMTP & Gateway Servers DNS SAN Man. Server S T O R A G E A R E A N E T W O R K E1 SS7 BSNL BSNL Call Logger Symposium Call Center Server (ACD) CTI CT Connect Nortel CS 1000 EPABX Nortel MPS1000 IVR

19. Application brief functionality

20. 1. Revenue Assurance Product : Connectiva Model : Onereview Why to choose Connectiva Revenue Assurance Application ? • ONEREViEW offers the most comprehensive data acquisition capability through its Adapter Framework to enable data acquisition from multiple, disparate sources. • ONEREViEW also includes the first integrated, modular ETL function optimized for telecom-specific operations and distributed processing support. • ONEREViEW adapters enable single data sourcing for multiple simultaneous targets, including third party solutions. This will allow BSNL to share all the relevant data that ONEREViEW is polling and collecting with other systems and applications seamlessly. • ONEREViEW’s primary strength is its ease of use especially when there is a change in requirements and new functionality needs to be added to the system without having to resort to backdoor techniques.

21. 2. Fraud Management System Product : Neural Technologies Model : Minotaur Why to choose Neural Fraud Management System ? • Minotaur™ Behavioural Models are designed with a sensitive-early architecture that allows them to generate alerts no matter how soon fraud occurs after the creation of a new account. • Minotaur™ Behavioural Models offer an adapt-to-feedback facility, which can be used by the fraud team to provide feedback to a Behavioural Model that generates alerts for events that, upon investigation, are found not to be fraudulent • Minotaur™ behavioural models continuously adapt their profiles to reflect the gradual changes in behaviour that characterise normal calling • The advanced Fraud Detection Engine lowers the false positive rate (i.e. tickets that correspond to actual fraud) and also provided detailed information and reasons to an analyst or investigator as to why calling activity has been flagged as fraudulent.

22. 4. Convergent Billing & Mediation Functional Overview – Kenan BP • data exchange with external systems • customer usage accumulation and rating • correction and reprocessing of errored usage • variable tax rates based on charge type, jurisdiction, account, and location • customer invoice preparation • payments processing from lockbox, credit cards, and electronic funds transfer • invoice formatting and dispatching • financial feeds for general ledger • journalizing of revenue information

23. 3. Bill Formatter, Enterprise Reporting and Electronic Stapling. Product : Group1 Why to choose Group1? • The software enables data connectivity with different system/s to better access multiple data sources and immediately transform the data into useful information for Bill Formatting, Electronic Stapling and Enterprise Reporting. • Enable batch and interactive production delivery to streamline production for high volume or on-demand output. • Enable document archiving and housekeeping to secure BSNL data and documents for retention and retrieval, in an integrated environment . • The Software has front-end modules for document and /or bill creation and resources administration, customer care interface for document navigation, output and delivery management and application administration & monitoring. • The Software generates/retrieves documents from third-party applications to provide fast and efficient service with instant retrieval of exact replica of documents reducing call handling time and call backs, improving customer satisfaction.

24. 5. Directory Assistance: BTSLogic Advantages of BTSLogic DA • The BTS-DA search engine can be used by various access points, thus ensuring that only one logical database is required to be maintained. • BTS-Open/Unified Access Layer provides for several points of access to reach information resources connected to the Unified Access Layer. This allows the agent to access not only the BTS-DA Search Engine but also to access a non-BTSLogic DA-database or to access information sources in the Internet. • Real time updates: Updates to the BTS-DA search engine are done in real-time, making updates available to agents immediately. • N+1 fault resilience: The BTSLogic solution is designed for N+1 fault resilience. The single logical database can be distributed in several copies.. • Sub-second response time: Even most complex search queries are performed in a fraction of a second. This is done to ensure avoid unnecessary delays in processing of a customer’s request.

25. 6. Service Provisioning: Clarity Advantages of Clarity • Clarity offers an automatically generated logical schematic of the network showing (level 1) sites and connectivity between sites, (level 2) equipment and connectivity within site, level 3 equipment configuration (e.g. bay, rack, shelf, slot, card and port) • Most other solutions offer minimal inventory and configuration capability relying instead on the capability provided by network elements. Clarity offers a fully featured, independent inventory and configuration master managing geographical, physical and logical inventory and configuration. • The Clarity product provides a full inventory of equipment in the network and details the interconnections of those items and circuits, and then associates each item with real-time status information so that an accurate current view of the network is maintained in real-time. Clarity auto-discovers the configuration and status of the enterprise network and then auto-diagrams the information in a correlated and analysed form.

26. 7. IOBAS – Intec InterconnecT v7 Advantages of InterconnecT Accurate Accounting of interconnection charges • InterconnecT v7.1 covers the interconnect business process starting with a collected EDR and ending with a final, reconciled interconnect charge. InterconnecT v7.1 can handle any number of national and international agreements. It is multi-currency, Euro compliant and supports direct as well as cascade settlement methods. • Increase revenues using volume discounts: InterconnecT v7.1 provides the operator with a very flexible way of offering volume discounts. Discounts can be tiered or fixed and applied on time, data or money. • Keep traffic volumes within agreement limits using volume penalties: In order to ensure that the operator’s own network is not saturated by interconnect traffic volume penalties can be used. A volume penalty is a reverse discount which is applied if the interconnect partner enters more traffic than was stated in the service level agreement. • Reconciliation Dispute data Plug-in: InterconnecT v7.1 provides an accurate rating engine that provides full audit capabilities to substantiate declarations which facilitates dispute resolution. • The basic aim of an interconnect solution is to: • Produce an invoice for the calls delivered for another operator • Validate the invoices received from other operators for the calls delivered

27. 8.Customer Relationship Management: ORACLE/Siebel • Customer relationship management (CRM) is a broad term that covers concepts used by companies to manage their relationships with customers, including the capture, storage and analysis of customer information. • There are three aspects of CRM which can each be implemented in isolation from each other: • Operational CRM- automation or support of customer processes that include a company’s sales or service representative. This helps in maintaining customer database and history of contacts. This improves customer interaction and turn around time is reduced. • Collaborative CRM- direct communication with customers that does not include a company’s sales or service representative (“self service”). Advantages s here include cost reduction, service improvements, etc. • Analytical CRM- analysis of customer data for a broad range of purposes like marketing campaigns, managing customer churn, financial forecast etc.

28. The Siebel solution will allow BSNL to • Differentiate from competition through improved customer satisfaction and deeper understanding of profiles, decision criteria, and behavior • Turn focused insight about customers and products into strategies and action. This includes ability to come to market with innovative offers for targeted segments across multiple sales and communications channels • Enhance user effectiveness by consolidating all customer information across systems, streamline & standardizing processes, and providing a unified desktop to address all service & sales processes for prepaid and postpaid customers • Improve sales effectiveness by automating up-sell and cross-sell recommendations • Reduce order fallout through flexible service validation & streamlined order processing of bundled services • Increase customer loyalty through improved service resolution across all touchpoints • Lower IT cost and complexity through flexible, scalable, and proven architecture & pre-built, industry-specific functionality

29. 9. Enterprise Application Integration: ORACLE • Enterprise Application Integration (EAI) is the process of linking applications in order to realize financial and operational competitive advantages. • When different systems can’t share their data effectively, they create information bottlenecks that require human intervention in the form of decision making or data entry. • With a properly deployed EAI architecture, organizations are able to focus most of their efforts on their value-creating core competencies instead of focusing on workflow management. Purposes of EAI • Data (information) integration: ensuring that information in multiple systems is kept consistent. This is also known as EII (Enterprise Information Integration). • Process integration: linking business processes across applications. • Vendor independence: extracting business policies or rules from applications and implementing them in the EAI system, so that even if one of the business applications is replaced with a different vendor's application, the business rules do not have to be re-implemented. • Common facade: An EAI system could front-end a cluster of applications, providing a single consistent access interface to these applications and shielding users from having to learn to interact with different applications.

30. 10. IVRS –Nortel Functionalities : Automatic Telephone Fault Booking & Clearance Service application Automatic Bill Inquiry Service application Automatic Change Number and Bulk Change Number application Automatic Trunk Booking application Caller message recording (CMR) Interactive Commercial Inquiry and Special Services application Interactive Connection Availability/Booking Status application Outbound Notification application

31. Implementation Plan

32. Macro level Implementation Plan

33. THANK YOU