The EMS Directory Project

1
The EMS Directory Project

• Team PinchHitters
• Heath McLean
• Justin Ricci
• Mark Blakley
• Stephen Hutsal

2
Agenda

• Sponsor
• Background
• Team Hazmats Contribution
• Risks
• Process
• EMS Directory Phases
• Architecture and Database Schema
• Metrics
• Demo

3
Sponsor

• Society for Total Emergency Programs (STEP)
  Council
• Dr. David Kluge, MD
• Former President of STEP
• Current Editor of the EMS Directory
• Rick Voight, RIT graduate has been providing
  business and marketing input

4
Project Background

• EMS Directory reference document for EMS
  providers and related organizations
• Created in 1993
• Four sections
• Ambulance, Fire, Police, Hospitals, Nursing Homes
• Physicians Telephone and Admitting Hospitals
• Resources
• Protocols
• STEPs annual publication appears to be the only
  comprehensive EMS directory in the US

5
Team Hazmats Contribution

• Requirements Elicitation
• Technology
• Microsoft Server and SQL
• .NET
• Web Site Prototype
• Web Pages C and ASPX
• Web Service C
• Printing Research
• Adobe InDesign

6
Risks

• Dr. Kluge is not familiar with software
  engineering
• Dr. Kluge is in Florida
• Weekly teleconferences and frequent email
  discussions
• Continuation of last years project
• Quickly learn about project and assess current
  software

7
Launch Process

• Iterative Approach
• Series of milestones that continually add more
  functionality
• For each Iteration
• Requirements -gt Design -gt Code -gt Test

8
Milestones
ID Name Duration Start Finish
1 Refactor Site 12/9/04 3/1/05
1.1 Redesign Database 32 days 12/9/04 1/15/05
1.2 Redesign Web pages for adding an organization 38 days 1/3/05 2/10/05
1.3 Test Refactored Site 17 days 2/11/05 2/28/05
1.4 Live Site 1 days 3/7/05 3/7/05
2 Create PDF from database 1/17/05 4/30/05
2.1 Finish InDesign Templates 98 days 1/17/05 4/25/05
2.2 Create Database Dumper 98 days 1/17/05 4/25/05
2.3 Test PDF Creation 6 days 4/25/05 4/30/05
3 Continue work on new web pages 3/7/05 4/25/05
3.1 Web pages for searching, updating, and editor functions. 50 days 3/7/05 4/25/05
3.2 Test New Web pages 5 days 4/26/05 4/30/05
4 End To End Testing 14 days 5/1/05 5/13/05
9
EMS Directory Phases

• Information Gathering Storage
• Enter directory information
• Allow organizations to update their information
• Store the directory in a database
• Document Generation
• Create a document template
• Generate XML for template
• Information Searching and Editor Functions

10
Information Gathering StorageImplementation
Testing Activities

• Web Service Implementation Complete
• Web Application Implementation Nearly Complete
  for Phase 1
• Database/Stored Procedure Refactor Complete
• Goal Completion of Phase 1 before Spring Break
• Registration Page for Account Requests has been
  live since beginning of February
• Currently gt 30 Account Requests

11
Architecture
12
Database Schema
13
Metrics

• Metrics
• Slippage Chart
• of test cases per requirement
• Pie chart of defects by type

14
Metrics Continued
15
Metrics Continued

• Test cases per requirement (Phase 1 data)
• Hazmat 4 / 37 0.11
• Initial Rewrites 36 / 28 1.29
• 2nd Rewrite 55 / 33 1.67
• Pie chart of defects by type
• N/A (not enough data yet)

16
Assessment

• Has Worked
• Division of the architecture to separate team
  members
• Communication Teleconferences Email
• Hasnt Worked
• Working directly on the server for ASP C

17
Demo
18
Questions?