Meeting at Hyderabad on 2 nd /3 rd July 2007

1. Presentation to BSNL On CDR based Customer Care & Billing SolutionFor SouthByHCL INFOSYSTEMS LTD. Meeting at Hyderabad on 2nd/3rd July 2007

2. Agenda • Solution Architecture • Hardware sizing for Servers (Application wise) • Power supply calculations • Network Architecture & security set up • Application Functionality • Q & A

3. Solution Architecture

5. CRM Collection & Mediation Provisioning System

6. Solution Stack proposed

7. Hardware deployment of Servers

8. 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

9. 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 South 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 EAST HP Superdome HP Superdome HP Superdome IBM P595

10. Proposed Deployments at BSNL South 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

11. UPS-4 200 KVA BUS-2 BUS-1 UPS Architecture – South Data Center Total space required 2000 Sq ft 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-4 200 KVA UPS-1 200 KVA UPS-2 200 KVA UPS-3 200 KVA UPS-1 200 KVA UPS-2 200 KVA UPS-3 200 KVA 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

12. 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 About 80 to 85 racks with requirement of about 4000 Sq ft for server area

13. Network Architecture & Security set up

14. 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

15. 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

16. Application brief functionality

17. 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.

18. 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.

19. 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

20. 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.

21. 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.

22. 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.

23. 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

24. 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.

25. 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

26. 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.

27. 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

28. THANK YOU

29. Distribution of Equipment SSA / Exchange wise. • Power supply requirement, input UPS installation requirement. • Peak power requirement and sustainable power requirement. • AC BTU requiement in terms of available with them as compared to that of actually required • Pulse of UPS, if it really matters ( The input efficiency i.e. Output vs input ration. Frequency variance permitted. • Bandwidth requirement • Exchange to SSA • SSA to Data center • For CDR as well as that for IVRS • Data center space for server requirement. • Data center space for specialised manpower requirement. • Specification of Data center in terms of Network adminstrator , Security administrator, System adminisitrator, application administrator, data base adminsitrator, backup administrator, along with Data center management staff such as UPS, DG set, Access lock, Vender Management, A/C, supervised by Data center Manager. • Specification in terms of Anti fire resistant roofing, Anti fire resistant flooring, partitioning etc. • Specification of Entry, exit, anti roddents, and distance between data and electrical cabling. • Anti-static flooring with vinyl covered by copper strip earthing. • Data cabling and DTF and MTF requirement both in terms of Data and voice. • The process of equipment lifting.