NSCU’s Road to Corporate Business Intelligence

1. NSCU’s Road to Corporate Business Intelligence Presented by: Michael Zywicki September 24th, 2010

2. North Shore Credit Union • Founded May 7, 1941 by deep-sea fisherman and shipbuilders • Head office in North Vancouver. 300 staff. • 11 retail banking branches on the North Shore, in Vancouver, and Whistler (new Broadway branch scheduled for Q2 2011) • $2.03 billion in assets under administration • 41,000 members: • 36,000 retail/personal memberships (approx. 25,000 households) • 5,000 business memberships (SME, SOHO) • Financial Spa/Experience based relationship banking

3. Partnerships • Temenos: • Headquartered in Geneva and serves over 1,000 financial institutions in more than 125 countries. • T-24 Banking System • B.I. tool called Insight • Primisyn • Provides Business Intelligence and profitability solutions • Services 26 Credit Unions across Canada …Both Microsoft partners

4. NSCU B.I. Timeline • Where did we come from - NSCU evolution over last 10 years: • It is a tale of maturity of three main departments: • Sales and Marketing • Finance and Treasury • Operations and IT • Where are we today.

5. Timeline…decision support • NSCU 6-10 years ago • CRM implemented • Microsoft consult to build DW end of 2004. I.C.E is built and refined. • Primisyn profitability and Treasury capability built. • Profit and member information reports and cubes being conceived and developed • Operations rationalizing all business flows • Crystal and standalone Excel workbooks are report vehicles.

6. Warehouse

7. Reports

8. Excel driven Reports

10. Timeline…Shift to develop Strategy • NSCU 3-6 years ago • Marketing and Sales develop data driven target market strategy • Marketing, Finance and Treasury mature to core BI (data driven decision support) pillars. • Excel and MS Access Databases emerge as core • DW expands and ECM is developed. • Conversion to new banking system decision made in 2007

11. Marketing as Sales primary Strategy Focus Break-out point Source: Council on Financial Competition (CFC), May 2004.

12. Marketing Based Models

13. Data relationship • Place holder for database slide

14. Timeline… • NSCU 1-3 years ago… • Marketing and sales shifts from strategy build to implementation to target market • Feb, 2008…Better and more relevant information Indentified by all senior managers as #1 need to deliver growth • Next evolution of warehouse and technology infrastructure planned

15. Timeline… (cont’d) • NSCU 1-3 years ago • Finance’s Line of Business (LoB) develops as core decision support centre • 3 year banking system conversion project went live November 2009 • BI one of top 3 initiatives for the company for 2010 • Next evolution of warehouse and technology infrastructure planned

16. Push BI to Sales

17. Strong Pillars Developed

18. TDWI CBI Maturity Model

19. TDWI CBI Maturity Model cont’d

20. Timeline • NSCU Today • Full corporate BI strategy in place • Structure created to support project/program • 3 phase approach to deliver wins • New warehouse structure to deliver on BI vision

21. BI Charter and Value Prop. • Corporate BI Strategy: • On-time Information • Accurate Answers • Valuable Insights • Actionable Conclusions

22. BI Organization Structure

23. NSCU today

24. Data relationship • Place holder for database slide

25. Integrated views, examples

26. Integrated views (cont’d)

27. Integrated views (cont’d)

28. Learning's on the Road to Corporate B.I. • Identification of need did not lead to action • Critical mass of pain delivered action • Leveraged the existing strong pillars as reasons to deliver more in a better way • Sell, sell, sell the benefits of BI. • Major corporate strategy shifts required creation of pillars of B.I. ( i.e., Marketing, Treasury, Finance) • Evolution not Revolution… Our culture did not allow us to “leap forward” and skip over necessary evolutionary BI steps

29. Questions ?