W I P R O I N F OT E C H Driving Business Momentum From the Editor's desk For the quarter ended December 31, 2007, Wipro Infotech recorded revenues of Rs. 9,716 million, representing a growth of 39% YoY. PBIT grew by 49% YoY to Rs. 874 million. Services business contributed 33% to total Revenue during the quarter and grew by 46% YoY. Wipro Infotech won two large deals during the quarter. Aircel, a Maxis group company awarded Wipro a 9 year Total Outsourcing contract to provide next generation Business Transformation. Wipro also won a 5 year IT services contract for IT infrastructure and application management from Reliance Capital Ltd., in partnership with Tech Reliance. Issue 6 Januar y,2008 D O S S I E R We are also pleased to share that Wipro's Romania Development Centre has successfully cleared both ISO 9001-2000 as well as the ISO 27001: 2005 certifications. This is Wipro BPO's first International location to have done so, that too in just six months of commencing operations. Editor 01. In Focus Case Study BI & DW Solution for a leading Insurance Company in India Client Requirement The client is a leading Insurance company in India with an active customer base of 220 million. In order to implement its Customer Relationship Management (CRM) vision and strategies, the client wanted to set up an Active Data Warehouse. This meant integrating data from disparate systems for the purpose of query, analysis and reporting to provide a decision support environment. The client engaged Wipro for entire turnkey project management, application development, implementation and support for the BI and DW solution. Data Warehousing and Business Intelligence Data Warehousing and Business Intelligence (DW & BI) have become a business necessity for enterprises operating in today's competitive environment. A Data Warehouse contains all historical data of an enterprise, and forms the basis of management's decision support systems. A Data Warehouse needs to offer high levels of scalability, security and stability combined with the ability to optimize storage and retrieve complex sets of data. BI systems in turn, need to have the right set of tools to transform raw data residing in Data Warehouses (and sometimes operations data) into information that makes analytic processing possible. This would help management take the right business decisions based on actual data analysis. As an end-to-end service provider, Wipro Infotech provides consulting, architecting, integration and management of DW/BI solutions. Our solutions provide direct access to information analytics to help you respond quickly to emerging business opportunities and rapidly changing market trends. The Challenge Designing a flexible and scalable Data Model which could incorporate the client's varied businesses ie., Individual Life, Group Life, Housing, Finance etc Referential integrity across 2050+ branches for 10 TB distributed data 9 lakh agents and 2000+ CADW/MIS/DSS concurrent users Maximum scalability and complex query performance across multiple data sources Parallel processing for faster performance Wipro Service Offerings § Underwriting transformations (Ins) § Know Your Customer (Retail) § Credit Risk Analytics (Securities) § Clinical Data Management (HLS) § Customer Analytics (MFG) § ACRM (Telco) es ctic § Dashboard (TMTS) KPI Pra st Be § BI&DW Strategy and Roadmap § BI&DW Assessment § Enterprise Information Architecture § Technology Evaluation and Selection § Process Consulting Migrating from a highly De-normalized data model implemented in COBOL to a highly normalized Data Warehouse Model with minimum data loss Customer Data De-duplication i.e. Single customer view Ce nte ro Industry Solutions Enterprise BI Consulting Core Services fE xce lle n ce § BI&DW Infrastructure § BI&DW Access Value Added Service Enterprise Data Management Wipro’s Solution eth s od Fr a § Packaged Analytics § Technology Migration Services § e-Biz Intelligence § Mining Data § and Active Data BAM § Solution Center Warehousing § Business Analytics § Dashboard Applications § Support and Maintenance § Administration and Performance Management me W or ks Managed Services BI and DW solution using Teradata platform § Integration Data § Architecture Data § Master Data Management § Metadata Management § mart Consolidation Data § Quality Data § Migration Data § Security Data § Archival Data c Pro sM es Tools Used Data modeling: CA ETL: NCR OLAP: Business Objects Why Wipro for BI/DW Solutions BI & DW Specialists aligned to Vertical Industries ie., Finance & Insurance; Retail, CPG & Distribution; Manufacturing; Energy & Utilities; Telecom; Healthcare; Transportation & Logistics Experience in implementing 400+ projects for over 140 customers across industry segments Industry specific solutions -- Reusable Data Models, Methodologies to address Industry specific problems Multiple end-to-end Data Warehousing engagements with team sizes ranging between 50-80 Usage of industry Best Practices and frameworks ie., frameworks for Technology/data migration, ETL/Reporting, Data Mart consolidation, offshore suitability and engagement roadmap Proven process models for BI/DW, Meta Data and Data Quality in terms of checklists, guidelines, templates for implementation Usage of quality processes in service delivery ie., SEI CMMi level 5, Six Sigma Onsite-Offshore delivery ensuring cost savings of up to 35% Key Benefits 360º view of customers – across product lines Analysis of buying patterns and preferences of customers for increased cross-selling and up-selling Single view of the customer MIS reporting with lowest granularity Adhoc reporting for regulatory bodies/ management for making decisions. Market Segmentation Analysis, Market penetrations Performance appraisal of various channels Product Innovation and differentiation Marketing Campaigns with better targeting and improved hit ratios Reducing lop-sided business development Enabling preparation of marketing plans Data mining for event-based decision making 02. CIO Information Desk Gaming PC from Wipro The Morpheus Gaming PC from Wipro is a power-packed machine which can make your gaming experience truly come alive. Aimed at the avid gamer and multimedia enthusiast, it is a great companion for gaming, surfing and multi-media creation. The components are as follows: Directory Services: LDAP based platform/application independent user store Meta/Virtual Directory: Centralized view of user identity built from native user stores within application and database stores Single Sign-on for users accessing multiple applications across an enterprise Provisioning/de-provisioning systems: Workflow based user life cycle management system across enterprise user stores Web Access Management/Web Single Sign-on Federation Services: Creating federal identity for extending internal applications to external users across boundaries Auditor Reporting Systems to meet internal and external audit and compliance requirements Wipro Service Offerings Salient features: Fully loaded for high performance Intel® Core™2 Duo processors Dedicated graphics nVidia graphics card with 256 MB memory Webcam, DVD Writer and 160 GB hard disk 19-inch wide TFT monitor for exceptional clarity Philips 2.1 speakers with headset for mind-blowing audio effect Wireless keyboard and mouse Desktops available in three vibrant colours Role Engineering i.e. definition and implementation of Role Based Access Control across enterprise systems 03. Solution Highlight Identity and Access Management A chain is only as strong as its weakest link. And if one were to consider IT security of an organization, Identity and Access Management (IAM) has shown itself as the weakest link. Requirements Analysis and Business Case development Production Selection Services in terms of choosing the right-fit product to meet the client environment based on product demonstrations, functionality review and proof of concept Implementation Services including process re-definition, Role based Access Control adoption, Access Model development and tool implementation Support Services comprising definition and implementation of a support framework for rollout of the IAM framework in production environment, enhancement and housekeeping With organizations throwing open their networks to increasing number of employees, suppliers and partners, the danger to information systems from the disgruntled employee, internal hacker, unscrupulous third party has become very real. Organizations are faced with the challenge of creating multiple user accounts with appropriate levels of access to applications and resources to meet compliance and regulatory requirements for information security. Industry Verticals Serviced Banking, Telecom, Insurance, Financial Services, Retail, Energy, Government & Pharmaceuticals. Key Benefits of IAM Centralized Authentication and Authorization Services Centralized Policy management and enforcement User life cycle management Role based access control (RBAC) Single sign-on to enterprise systems Auditing and compliance reporting Password Management User self-help services With the maturity of Identity and Access Management (IAM) technologies, organizations can now deliver role-based access to business information systems for internal as well as external entities. The technology components of an IAM framework help achieve a phased maturity, delivering functionalities as the organization adapts the framework through iterative integration of user stores and application systems. 04. Prestigious Assignments Some of our marquee wins are as follows: Developing International Calling service portal for a leading Telecom Service Provider Deploying DWDM based network for Railtel Corporation of India, a subsidiary of Ministry of Railways, Government of India Setting up network for more than 900 locations of Indian Railways for Unreserved Ticketing System (UTS) for Centre for Railways Information System (CRIS) Implementation and maintenance of an enterprise wide Data Warehouse for the Central Board of Excise and Customs (CBEC) End-to-End SAP implementation of all SAP modules for BHEL Hyderabad division Building physical infrastructure for a Tier-3 Data Center for National Informatics Center (NIC) at Hyderabad 3 way DR implementation for existing SAP R/3 system for GAIL India Monitoring and Management of WAN across 345+ branches on a 24x7 basis through Wipro GSMC for Catholic Syrian Bank End-to-End Network security set up for all security components for MetLife Data Center and Disaster Recovery site Enterprise Data Warehousing project for a leading Bank in South East Asia 05. Best Practice Network Performance Monitoring Description Using Multi Router Traffic Grapher (MRTG) tool to monitor traffic load on the network. MRTG is based on Perl and C and works under UNIX and Windows platforms. Challenges Measuring traffic flow through the network (WAN/LAN) and individual node Measuring department/process-wise utilization and driving seat-wise bandwidth utilization Monitoring critical network components' resource consumption ie., CPU utilization Finding Network peak and off-peak production hours for undertaking emergency activities Taking backups of the database for viewing historical data for future reference Troubleshooting performance problems Customer Benefits Enables validation of Service Provider's data and sizing of WAN link Enables customer validation of bandwidth utilization for each Process/Department Enables Management to take decisions on WAN link upgradation well in advance Facilitates sharing of bandwidth utilization report with internal/external clients (MIS report) as well as notifying them about intra/inter link usage Easy accessibility of MRTG graph through the Web Browser from anywhere on the network, as the tool is integrated with the Web server Accolades Wipro ranked among Global 50 in Australia, in MIS magazine's annual publication on 'The 2007 guide to the 100 IT vendors CIOs must watch' Wipro named ‘ Leader in SAP Implementation Services, 2007’ by Forrester Wipro awarded ‘Credit Suisse IT New Business Award’ for Strategic Partnership from Credit Suisse for its contribution in setting up and growing the Center of Excellence in Pune www.wipro.in A b o u t Wi p ro I n fo t e c h Wipro Infotech is a full-line IT services & products organisation. We offer consulting services, infrastructure provisioning and management services, package implementation, ground-up application development and management services. We have the breadth of offerings and the necessary quality processes to become your strategic IT partner. For feedback/suggestions, please write to the Editor at email@example.com This publication is produced by Wipro Infotech and is for private circulation to its customers. While all care has been taken to ensure accuracy of information contained in this publication, Wipro Infotech will not accept any responsibility for any loss or damage to any person resulting from reliance on it.