Find Your Way Through LCI’s Information Technology

1. Find Your Way Through LCI’s Information Technology USA/Canada Lions Leadership Forum September 25, 2009 Joe Schrepfer Manager, Membership & Web Applications Lions Clubs International

2. Find Your Way Through LCI’s Information Technology

3. Technology Milestones

4. Technology Milestones – The 60’s and 70’s • LCI’s first computer was installed in 1967 and was a Honeywell H-200 with 4KB of Memory and 0KB of Disk Space. • Paper MMR’s were shipped to HQ for entry. • Data Entry was performed on key punched cards.

5. Technology Milestones – The 80’s and 90’s • By the 90’s we were up to 256KB of Memory and 8GB of Disk Space on a Honeywell Bull DPS 7000. • Paper MMR’s could be Faxed to HQ. • Staff had to schedule time at a terminal to do their work (including programmers).

6. Technology Milestones – Y2K through Today • Bull Mainframe replaced with state of the art Hewlett Packard “blade” servers. • 64GB of Memory and 20TB of Disk Space. • 85% of Clubs enter their own MMR’s over the web. • Each employee has their own computer.

7. Recent Accomplishments

8. Recent Accomplishments – Organization & Infrastructure • Redefined IT Organization to better serve you. • Completed major messaging & security systems upgrades. • Implemented VoIP phone system reducing telecommunications costs by more than 50%. • Obtained, configured, and distributed new staff computers. • Upgraded to Office 2007.

9. Recent Accomplishments – Applications & Web • Implemented Business Intelligence and Reporting capabilities. • Added on-line printing of membership cards. • LeoMMR development completed. • Passwords are now sent via E-Mail. • Monthly releases of WMMR resolved over 200 issues. • Added newly chartered clubs functionality to web service.

10. Current Environment

11. Current Environment – IT Organization

12. Current Environment – Applications

13. Current Environment – Challenges

14. Current Projects

15. Current Projects – Organization & Infrastructure

16. Current Projects – Applications & Web

17. Future Direction

18. Billing Membership Web site Membership Web service Applications Future Direction

19. Future Direction – Vision • No Training Needed • Easy to Use • Intuitive • Accessible • Seamless • Reliable • Secure • Current Technology • Single Application

20. Future Direction – Give us your ideas (Comments from Audience) • Suggestions • Continue to support paper MMR’s • Prompt to save when navigating off the page • Locate process manuals in centralized location • Create a Collaboration service to organize lions such as to go to meeting (keep it secure and private) • New member report should have same fields as membership dump • Standardize forms/publications to Letter and identify Legal size forms in advance • Allow MMR Report Downloads • Suggestions • Make it easy to read • Use the same font for everything (Arial or Tahoma) • Allow data entry errors to be corrected (e.g., dropped deceased wrong member) • Validate phone number entry • Include officer title on reports • Add a button to change the font size • Mobile based PU-101’s (especially when helping clubs that are without web access) • Keep it easy for technically challenged

21. Future Direction – Give us your ideas (Comments from Audience) • Suggestions • Activity Reports difficult to use • Educate district governors • Printing club reports (click on club link) • Problems printing activity report • Should club pages be hosted by LCI (since e-Clubhouse just started, we will wait and see). • Can you add documents to e-clubhouse? • Different response on web using same password in different places • Include revision/date on forms • Suggestions • Monthly MMR’s should keep dates in mind with awards and display all dates (keep original reporting month) • .Org search returns too much information and could be improved • Change print button to view button since it doesn’t print • Create customized Club pages (see e-Clubhouse) • Need a new member report for DG’s that shows new members by club. • Focused buttons, pages, and options based on title of user

22. Future Direction – Give us your ideas (Comments from Audience) • Suggestions • Billing link for club secretaries needs a better way to export and use the information in excel or word • Correcting mistakes is difficult/impossible when copying from column based publications (e.g., by laws) • Customize password letter by title to include what to use wmmr for • District Governor training should include LCI HQ overview • The old Membership application form is on the website instead of the new one • Suggestions • Online training • Club health report updated daily (great report but update it more often) • Writable PDF’s for youth exchange and other publications • Standardizing publications and making Doc versions available • Avoid columns to help copying and pasting • Change contact us to make it easier to figure out who to get a hold of • Copying PDF to Word for club publications is difficult

23. Future Direction – Give us your ideas (Comments from Audience) • Websites you like • Use Facebook as an example for a collaboration site dedicated to Lions Clubs • QVC.com • iGoogle.com • FTD.com • Suggestions • Create a way to communicate within the district such as a district forum where clubs can send and receive messages to/from other clubs and to/from the district. Also send a notification via e-mail when messages are posted.

24. Thank you and enjoy the rest of your stay in Memphis!