Business Intelligence Solution for Stock Broking Houses

1. Business Intelligence Solution for Stock Broking Houses for Actionable Information

2. Agenda • About C-BIA • Business Intelligence Solution for Stock Broking Business • XLDashBoard – Demonstration

3. Center for Business Intelligence and Analytics (C-BIA) for Actionable Information

4. Mission “Create business value for clients by enabling superior performance through unleashing hidden wealth in operational and external data sources combined with innovative Analytics.”

5. History C-BIA, a division of TechKnit was founded in 2004 Cyrus Mehta, Ph.D. Founder and President Cytel Inc. Nitin Patel, Ph.D. Founder and Chairman Cytel Inc. www.cytel.com Statistical Software, Consulting and Services for Clinical Trials BI Solutions and Analytics Services e-Tutoring and Educational Content

6. Team of 40 people in Pune, consisting of: Business Analysis and Solution Design (Ph.D. and MBAs) Application Development Statisticians (Masters in Statistics) Web Interface Data Managers (MCAs) Tools Development (Masters in Statistics and Computer Science) Information Technology (Engineers and MCAs) Platforms SAS Microsoft Oracle Cognos Business Objects People Capabilities

7. C-BIA Management • Mayank ShahChartered Accountant Mayank has over 27 years' experience as Consultant in the field of MIS & BI applications. • Ajay SathePGDM, IIM, Ahmedabad Ajay has over 17 years' experience in IT industry specializing in Software Development and Technology Management. • Shrikant Athavale, Industrial Engineer Shrikant has nearly 36 years' experience in Industrial Engineering and Quality Management. • Vanaja Vaidyanathan, MBA and Cost and Works Accountant Vanaja has over eight years of experience in Business Intelligence practice. • Dan Crowell, MSc. in Economics, London School of Economics Dan is our associate based in USA, looking after business development and client interaction.

8. Experts Panel • Nitin Patel, Ph. D. Dr. Patel is a leading expert on the development of fast and accurate computer algorithms to implement computationally intensive statistical methods. • Suresh Ankolekar, Ph.D. Dr. Ankolekar has over 23 years of academic and consulting experience at Indian Institute of Management,Ahmedabad (IIMA) and Maastricht School of Management, Netherlands (MSM). • Ashok Nag, Ph. D. Dr. Nag, a former senior executive of the Reserve Bank of India, is a well-known expert in the banking and financial analytics, data warehousing and data mining. • Sunil Lakdawala, Ph. D. Dr. Lakdawala has over 20 years' of consulting experience in IT applications for business including Data Warehousing and Data Mining. • V. Chandran, Aeronautical Engineering Chandran has over 22 years' experience in technology functions, including CTO positions in companies with sizeable software teams.

9. C-BIA Partnerships • SAS: Silver Alliance partner… • Mastek: BI Solutions… • Cytel-Cognizant: Pharmaceuticals- clinical trials… • Statistics.com:XLMiner marketing in USA • Syscon: BI solutions to logistics vertical…

10. ProfitLogic, US B harat Petroleum, India Mastek, India Dainik Jagran, India Trumac, India TAM Media Research, India Savita Chemicals, Ind ia KPIT Cummins Infosystems Ltd. , India Tata Motors Ltd., India HDFC Standard Life Insurance KR Choksey, India Selected Customers

11. Business Intelligence for Stock Broking Houses

12. Our Offering • Business Intelligence Solution • Business Intelligence Platform – End User BI Tool • Data Warehouse • Extract Transform and Load Process • System Administration Processes • Customization and Implementation • Support Service on Annual Contract Basis • Solution on Microsoft or SAS platform

13. Critical Success Factors for BI • Actionable Information • Summary information to assess performance v/s target and benchmark • Discover low performing and high performing areas • Discover causes of low / high performance • BI Design • Key Performance Indicators (KPI) • OLAP Views • Reports • Leverage technology • Dash Board • Drill-down, Slice and Dice information • Reports – filter / sort information • Deploy analytical techniques – correlation, pareto analysis, trend analysis, distribution analysis

14. Illustrative Business Processes • Capital Market • Derivatives – Earnings • Derivatives – Risk Management • Equity • Depository • Distribution • IPO’s • NFO’s, Mutual Funds • Life Insurance • Non-Life Insurance • Any other Fixed Income Instruments • Fund and Wealth Management • Portfolio Management • Portfolio Advisory • Knowledge Management – Customer Profiling • Research Distribution • Privilege Customer Services • Customer Call Effectiveness • Business Overview • Financial Performance

15. Performance Management Issues What is the share of total business of my top few channels? Which are the most popular scrips traded in? Who are my most valued client’s w.r.t trade values? What is the share of total equity business of my top few channels? Who are my most valued client’s w.r.t equity? KPI and Trends Purchase Qty./Amt. Traded Sale Qty./Amt. Traded Purchase Amt. Delivered/Settled Sale Amt. Delivered/Settled Total Trade Amount Dimensions Exchange Scrip Channel Client wise Transaction Type Equity

16. Key Performance Indicators and Their Performance Trends…Total No. of Trades…

17. XLDashBoard Demonstration for Actionable Information

18. Look at All Reports and Views Available Subject-wiseSelect Information from Chosen Subject

19. Key Performance Indicators and Their Performance Trends…Total No. of Trades…

20. Graphical Dash Board for Your Favorite Performance Charts….

21. Study Details….find Performance Levels…Customer Type-wise Average Trade per Transaction…

22. Drill down ...to Study Low and High Performing Customer Category within Customer Type to Look at Avg. Trade Value

23. Look at User-friendly GraphsCustomer Type-wise Avg. Trade Value…

24. Analyse Age Group that Contribute to Trade….Pareto Chart…Age Group-wise Average Trade per Transaction…

25. Generate Trend Chart of Transactions and Net Brokerage Across Periods...

26. Generate a Report…of Scrip-wise Analysis

27. User-wise Customized Access • Separate logon for each role • Customized portal page • Customized KPIs, Graphs, Views • Access restrictions based on • Role • span-of-control • Level of Information requirement

28. Technology and Architecture XLDashBoard tools and applications are built on Microsoft platform using tools:

29. Implementation Approach

30. Capability Presentation Workshop Pilot Pilot Assessment Build BI Application: Continuous Improvement Multiple Processes Describe Capability Credentials Give examples of potential benefits Discover Vision Where does the client want to be? What are the client’s information needs? Build a business case Calculate the ROI Present findings to project sponsor Data Source Review including Quality Assessment Project Scoping Time to Information (as-is and to-be) Project Approach

31. Why XLDashBoard? • Key Benefits • Enterprise wide application providing ‘single version of truth’ • Corporate and Departmental Managers can Analyze their Own Performance…and….save a lot of energy in constructing Excel based Reports and Charts • How delivered • Data stored in dedicated Data Warehouse and Information Cubes • Protected data • No voluminous queries run on transaction systems • Instantaneous response to users with summary information, drill-downs, slice and dice functions • BI delivered on Excel, a most familiar platform • Ability to build ad-hoc reports, new Query and Analysis Views • BI functionality comparable to any world class BI Application…. Plus, statistical analysis and data mining…. • Access control mechanisms • Cost Effective

32. Why C-BIA • We understand the language of business… • Experts at designing KPIs given business strategy and Critical Success Factors • Right methods for generating actionable information • Experts at Analytics …..show approaches for improving business performance • Leverage technology to its best potential

33. Thank You Any Questions?