Loading...
HomeMy WebLinkAboutRESPONSE - RFP - 7396 PFA FIRE SERVICE RESPONSE PERFORMANCE ANALYSIS SOFTWARE & RUN CARD BUILDER SOFTWARE (2)1 PFA Fire Service Response Performance Analysis Software & Run Card Builder Software Submitted in response to the City of Fort Collins Proposal No. 7396 Deccan International 5935 Cornerstone Court West, Suite 230 San Diego, CA 92121 Phone: 1-858-764-8400 Fax: 1-858-764-8401 Principal Contact: Latha Nagaraj (President) Email: lathan@deccanintl.com June 2012 2 Table of Contents 1) Methods and Approach ....................................................................................................................... 3 2) Deliverables......................................................................................................................................... 4 Fire Service Response Performance Analysis Software ......................................................................... 4 Run Card Builder Software ................................................................................................................... 8 Training ............................................................................................................................................... 9 3) Qualifications and Experience ............................................................................................................ 10 Company History ............................................................................................................................... 10 Experience ......................................................................................................................................... 10 Clients ............................................................................................................................................... 11 4) List of Project Personnel .................................................................................................................... 12 5) Organization Chart/ Proposed Project Team ...................................................................................... 20 6) Availability ......................................................................................................................................... 21 7) Estimated Hours by Task.................................................................................................................... 21 CAD Analyst ....................................................................................................................................... 21 Auto Data Updater ............................................................................................................................ 23 ADAM ................................................................................................................................................ 25 BARB ................................................................................................................................................. 27 8) Schedule of Rates and Cost by Task ................................................................................................... 28 CAD Analyst, ADAM Quote ................................................................................................................ 28 BARB Quote ....................................................................................................................................... 29 Hardware Requirements for CAD Analyst, ADAM, and BARB .............................................................. 30 Auto Data Updater Requirements ...................................................................................................... 30 Appendix A – CAD Data needed by Deccan International for CAD Analyst, ADAM and BARB .................. 32 CAD Data ....................................................................................................................................... 32 Incidents and Responses ................................................................................................................ 32 Units and Incident Types Related Data ........................................................................................... 32 Response Criteria ........................................................................................................................... 33 APPENDIX B – Map Data Needed by Deccan International for CAD Analyst, ADAM and BARB ................ 34 Vendor Statement ................................................................................................................................. 35 Insurance .............................................................................................................................................. 36 3 1) Methods and Approach In response to the City of Fort Collins proposal no. 7396, Deccan International offers CAD Analyst, Apparatus Deployment Analysis Module (ADAM), and Box-Area Automated Run-Card Builder (BARB) software. Deccan applications are carefully customized to meet the requirements of each client. Configuring them in a way that maximizes benefit to the department will require a collaborative effort between the Poudre Fire Authority (PFA) and Deccan. The support needed from PFA is primarily in the form of the ability to clarify questions and ensure that data is provided to Deccan in a timely fashion. As such, PFA should assign one primary point of contact with a diverse knowledge and skill set. The following are the qualities this point of contact should possess: • Familiarity with data elements in the CAD data • Knowledge of the incident types used in the CAD • Knowledge of units responding to these incidents • Knowledge of capabilities for the units responding to these incidents • Knowledge of the locations that units respond from • Familiarity with field operations and strategic planning • Familiarity with GIS data • Ability to identify performance criteria as well as performance targets to be used for analysis As requested by PFA, Deccan will use a Microsoft Windows Server with SQL server as our database. Only an estimated timeline can be provided, since it will be dependent on the project complexity, scope and requirements from PFA. Some tasks are also dependent on the return of requested information and feedback in a timely manner. • CAD Analyst can be delivered 15 business days from the receipt of PO. Auto Data Updater is an additional feature of CAD Analyst and can be delivered in an additional 6 business days (within 21 total business days). • ADAM can be delivered 15 business days after delivery of CAD Analyst. • BARB can be delivered 27 working days from the receipt of PO. A detailed list of tasks associated with the software build is listed in section 7. A list of CAD and GIS data that will be required from PFA is in Appendix A and Appendix B. 4 2) Deliverables Fire Service Response Performance Analysis Software The City of Fort Collins is requesting Fire Service Response Performance Analysis Software (for a SOC Study). Deccan International offers CAD Analyst and ADAM to meet the requested deliverables. Each deliverable is listed below, followed by a comment from Deccan. Deccan’s CAD Analyst is in compliance. Deccan’s ADAM is in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s ADAM is in compliance. Deccan’s ADAM is in compliance. Deccan’s ADAM is in compliance. Deccan’s ADAM is in compliance. 5 Deccan’s ADAM is in compliance. Deccan’s CAD Analyst is in compliance. Deccan’s CAD Analyst is in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst and ADAM are in compliance. 6 Deccan’s CAD Analyst is in compliance. Deccan’s ADAM is in compliance. Deccan’s CAD Analyst is in compliance. Deccan’s CAD Analyst is in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst and ADAM can be exported in PDF format. Screen shots of the maps can be exported using the Windows 7 Snipping Tool into other formats including Microsoft Excel, Word and Powerpoint. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst is in compliance. Incidents of a given type or time period may be extracted from the Incidents table to then display their density thematically in a map. Deccan’s CAD Analyst is in compliance. 7 Deccan’s CAD Analyst is in compliance. Deccan’s CAD Analyst is in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan’s CAD Analyst and ADAM are in compliance. Deccan can generate a report of unit responses, upon request, using the CAD data provided to build or update CAD Analyst. Deccan can generate a report of unit responses, upon request, using the CAD data provided to build or update CAD Analyst. Deccan’s CAD Analyst is in compliance. Deccan’s CAD Analyst is in compliance. Deccan’s ADAM is in compliance. 8 Run Card Builder Software The City of Fort Collins is requesting Run Card Builder software. Deccan International offers BARB to meet the requested deliverables. Each deliverable is listed below, followed by a comment from Deccan. Deccan’s BARB is in compliance. Deccan’s BARB is in compliance. Deccan’s BARB is in compliance. Deccan’s BARB is in compliance. BARB can seamlessly incorporate mutual aid stations into the run orders. Deccan’s BARB is in compliance. Deccan’s BARB is in compliance. Deccan’s BARB is in compliance. Deccan’s BARB is in compliance. Deccan’s BARB is in compliance. 9 Deccan’s BARB is in compliance. Training Deccan will be in compliance. 10 3) Qualifications and Experience Company History Deccan International, founded in 1995, is a software company focused on developing and supporting practical data based tools and analyses that enable ambulance, 9-1-1, and firefighting operations to become more efficient. Dr. Raj Nagaraj, Vice President of Engineering and Research, is an industrial engineer who has designed and managed award winning productivity improvement projects in all three types of operations. For more than 20 years, Dr. Nagaraj has used industrial engineering techniques to help departments reinvent their operations. Deccan International’s flagship product is Apparatus Deployment Analysis Module (ADAM). ADAM is groundbreaking software designed to easily evaluate the effectiveness of current stations locations and the impact of adding stations and moving apparatus. It is the only software in the industry developed by a company with extensive fire department experience that combines the power of modern computers and the ease of Windows software with rigorous analytical models. As a result, many fire chiefs use it today to assist them in making decisions that can have major strategic and economic impact. The data and maps it generates can also be used as impartial and persuasive tools to sell decisions to stakeholders who may be more removed from daily department operations. Deccan International has developed several other software programs for use by the industry. CAD Analyst helps fire chiefs make meaningful use of the vast database of incident and response information collected by their CAD or RMS software. LiveMUM identifies holes in coverage and instantaneously recommends optimal move-ups for apparatus. Box-Area Automated Run-Card Builder (BARB) automates the building of static run-cards, or pick lists. Deccan International is a woman owned corporation incorporated in the state of California. Its offices are located at 5935 Cornerstone Court West, Suite 230, San Diego, California 92121. Experience Deccan International has over 16 years of experience working with design, development and implementation of the software described in Proposal No. 7396. ADAM, CAD Analyst, and BARB are Deccan International products that together fulfill the requirements of the proposal. The software is unique in the industry because it is premised on a thorough understanding of fire operations and the impact of various factors on response times and workloads. The applications were built by Raj Nagaraj, a consultant in public safety with a Ph.D. in Industrial Engineering. He has both rigorous academic training and experience working in fire departments. As Deccan’s Vice President of Engineering and Research, he remains intimately involved in the installation process and contributes to constant product improvement. 11 Clients Deccan currently has over 300 clients in the Fire and EMS industry, many of whom have used their software for more than 10 years. Deccan can show sample CAD Analyst, ADAM and BARB installations similar to what will be delivered to PFA via Microsoft Live Meeting upon request. References 12 4) List of Project Personnel Dawn Ohlendorf is the assigned Project Manager for the PFA contract. Working with her to fulfill the deliverables will be Raj Nagaraj, Vice-President of Engineering and Research, Jamie Swartz, Operations Manager and Shiva Subramaniam, Senior Data Analyst. Their resumes follow. Dawn Ohlendorf, Project Manager (858) 764-8337 2011-2012 Project Manager, Deccan International • Implementation of software from requirements definition to delivery and ongoing client support for CAD Analyst, ADAM, LiveMUM and BARB applications • Performing product demonstrations and presentations to current and potential clients, and planning, executing, and finalizing tasks and projects • Acquiring resources and coordinating the efforts of team members and clients in order to deliver projects according to plan 2009-2010 Sr. Project Manager, Principal Consultant, Anthem Commercial Aviation A commercial airliner focused on providing tactical support to US military operations • Defined requirements and developed a training program for small aircraft pilots that met Federal Aviation Administration standards including illustration of aircraft systems, operational procedures and decision • support, mechanical and electrical schema • Audit of company records and documentation to ensure compliance with FAA rules and regulations 2005-2009 Sr. Project Manager, Principal, Brown and Winters LLP, Cardiff, CA An environmental law firm that represents public entities throughout California • Planned, executed and monitored implementation of Concordance case management software • Provided leadership to develop technology solutions that met product benefit or cost expectations • Developed data tagging and retrieval system for evidentiary record, performed SQL queries on loaded data to generate reports for attorneys and legal staff • Oversaw a team of 4 data analysts responsible for evidence review and legal research • Authored white papers based on findings of research and analysis 1999-2003 Director, Implementation Services, Instill Corporation, Redwood City, CA A leader in SaaS supply chain solutions to the food service industry ➢ • Responsible for the successful delivery of each implementation project. Direct reporting team consisted of over 15 project managers and analysts. • Managed multimillion dollar, multiyear implementation projects • Stabilized trading platform resulting in an increase in customer satisfaction and a decrease in customer support call volume • Participated in proposal development to new and existing customers. Provided technical and strategic expertise in the development of proposal responses and validated pricing models. 13 • Re-engineered the distributor data integration implementation processes transforming them into an efficient work flow increasing capacity over 10 times without any headcount increase. Additionally, these implementation projects were completed in less than a third of the time it had taken previously. EDUCATION 1996 Bachelor of Science, Physical Science, Humboldt State University, Arcata, CA ACCOMPLISHMENTS • Inventor of United States Patent 7062509 B1 – System and Method for Product Data Standardization - a process enabling electronic exchange of data between ecommerce trading partners. PREVIOUS DECCAN ASSIGNMENTS INCLUDE: El Paso Fire Department CAD Analyst, ADU, ADAM, BARB implementation and delivery, Kauai Fire Department CAD Analyst, ADU, ADAM implementation and delivery, Fresno Fire Department CAD Analyst, ADU, ADAM implementation and delivery Contact information can be provided upon request. 14 Raj Nagaraj, Vice President of Engineering and Research (858) 764-8325 SUMMARY Over 20 years of experience applying analytical tools to the evaluation of various operational and design issues that confront Fire Chiefs, EMS managers and 9-1-1 Center Directors at municipal, county and state levels. Proven track record designing and implementing optimal solutions to questions that involve: • deployment of fire and EMS apparatus • field provider work schedules and staffing requirements • spatial and temporal deployment of ambulances • choice of ALS/BLS fleet mix • cost analysis of various EMS organizational options • reduction in ambulance response times PROFESSIONAL EXPERIENCE DECCAN INTERNATIONAL, San Diego, CA Vice-President of Engineering and Research (1995 to present) Developed ADAM, CAD Analyst, LiveMUM and Box-area Automated Run card Builder, four pioneering software applications used by fire and EMS departments. DISTRICT OF COLUMBIA GOVERNMENT, FIRE DEPARTMENT, Washington, DC Industrial Engineer (1995 - 1996) Led the Re-Engineering Fire Suppression Operations (RESO) project that developed optimal deployment plans for the fire department. DISTRICT OF COLUMBIA GOVERNMENT, OFFICE OF PRODUCTIVITY MANAGEMENT SERVICES, Washington, DC Senior Project Manager (1986 - 1994) Managed an operations research team that conducted a comprehensive evaluation of Washington, DC's EMS operations and prepared an award winning report titled Improving Ambulance Operations in Washington, DC: A Blueprint For Change. • Demonstrated using operations research models that, counter to normal thinking, a single-tier All-ALS system was cheaper by 33% than an equivalent two-tier ALS/BLS system for meeting the same target response time standards. • Received award for “Answering 9-1-1 Within the First Ring” from Public Technology Inc, for reducing 9-1-1 call waiting times by 68%. 15 URBAN SYSTEMS SERVICES, Bethesda, MD President (1989 - 1994) Provided EMS and 9-1-1 center consulting assistance to private ambulance and local government operations. • Developed manning level standards for meeting target call waiting times, optimal work schedules for minimizing staffing requirements, and cost comparisons of three options for re-configuring New Castle County, Delaware's 9-1-1 center that would, among others, increase the percentage of calls answered within 10 seconds from 69% to over 90%. UNIVERSITY OF IOWA, DEPARTMENT OF MANAGEMENT SCIENCES, Iowa City, Iowa Assistant Professor (1983 - 1985) EDUCATION Ph.D., Industrial Engineering - Purdue University, 1983 M.S., Industrial Engineering - Purdue University, 1979 B. Tech., Civil Engineering - Indian Institute of Technology, India, 1977 PREVIOUS DECCAN ASSIGNMENTS INCLUDE: Fire Department of New York, Los Angeles Fire Department, Seattle Fire Department Contact information can be provided upon request. 16 Jamie Swartz, Operations Manager (858)764-8333 SUMMARY Accomplished and visionary employee with a strong record of academic excellence, natural research capabilities, and proven work ethic. Demonstrated leadership, customer service, communication and training success. Analytical and team-oriented with the capacity to make quick, strategic decisions to support company growth. Well positioned to excel in a new and engaging environment. PROFESSIONAL EXPERIENCE Deccan International – San Diego, California October 2010 to Current Operations Manager Responsible for managing Project Management and Data Analyst teams for small software company specializing in the Fire and EMS industry. Coordinate workflow and client deliverables to ensure a high degree of efficiency and client satisfaction. Interview prospective employees and work closely with upper management to monitor high level task completion. Also serving as a Project Manager for large client sites, delivering application sales demo, attending industry conferences as a company representative, and training new employees. Key Contributions: • Increased employee retention rates each quarter • Substantially minimized application deliverable timelines • Instituted operational policies to balance limited resources with high volume output demands Steam Masters Carpet Care – Temecula, California November 2008 to October 2010 Project Manager Served as project manager to ensure timely service and customer satisfaction for busy carpet cleaning company. Liaised between home owners and insurance companies to coordinate and schedule repairs and cleaning after fires, floods or earthquakes. Maintained daily route schedules for employees and drivers. Prepared financial documents for outsourced accounting firm. Communicated regularly with senior managers at a variety of insurance companies to facilitate placement on preferred contact lists. Directed team of 3 employees. Key Contributions: • Played key role in achieving approximately 13% increase in profits each quarter. • Successfully negotiated status as preferred contractor with three major insurance companies. • Contributed to increased word of mouth business due to exceptional customer service. Yellow Book usa - Temecula, California 2007 to November 2008 Sales Account Representative Service existing accounts for current advertisers and sign new advertisers to the Yellow Book directory. Designing effective advertising programs for individual businesses while focusing on relevant results. Helping small companies grow their customer base by connecting them with potential clients seeking to purchase their services. Making sales both over the phone and in person, and retaining communications with advertisers throughout the 17 year in order to facilitate excellent customer service. Maintaining an effective schedule throughout the day in order to maximize activity and achieving set goals throughout the course of a specific canvas. Key Contributions: • Recognized for achieving the best role-play with a Yellow Book trainer in the Temecula office for sales of new internet products. • Sales return of 107% on all market and book goals. Enterprise Rent-A-Car – Temecula, California 2005 to July 2007 Assistant Manager Train and mentor employees in company systems, policies, and procedures, as well as providing world-class customer service. Motivate and encourage team to meet and exceed company goals. Address customer concerns and issues to encourage repeat business and loyal clientele. Sell insurance packages and upgrade customers to larger cars to drive profitability. Cultivate productive relationships with dealerships, body shops and variety of other business to promote and sell services to corporate accounts. Collect on customer accounts. Use proprietary computer system to track, process, and complete customer transactions. Key Contributions: • Designed and implemented new qualifications procedures to ensure that dealership customers receive faster and more efficient service. • Demonstrated ability to quickly learn, understand and internalize sound business practices. • Earned several MVP awards including two for Enterprise Service Quality index (ESQi) and six for sales. • Recognized for achieving the lowest bad debt ratio as well as the highest Income Per Car (IPC) within the region. EDUCATION Master of Arts, Modern History — University of St. Andrews, St. Andrews, Scotland (2004) Graduated with Second Class Honors Bachelor of Arts, History — University of California Los Angeles, Los Angeles, California (2002) Transfer PREVIOUS DECCAN ASSIGNMENTS INCLUDE: Fire Department of New York, Los Angeles Fire Department, Fairfax County Fire and Rescue Department Contact information can be provided upon request. 18 Shiva Subramaniam, Senior Data Analyst (858) 764-8361 SUMMARY OF QUALIFICATIONS • 4 years of experience with emphasis on Database and Data Analysis, and Business Analysis. • Qualifications and experience in all facets of Software Development Life Cycle from initial planning through requirements gathering, analysis, design, implementation, testing, deployment, and maintenance. EDUCATION • Master of Science in Industrial Engineering, Clemson University, Clemson, SC, Dec 2008 • Bachelor of Engineering - Mechanical Engineering, Anna University, India, May 2005 TECHNICAL SKILLS Data Modeling, Data Analysis, Report Development, User Interface Design and Evaluation, Systems/Software Development Life Cycle, Project Management, Enterprise Analysis, Requirement Planning and Management, Unified Modeling Language (UML), Rapid Unified Process, Human Computer Systems, Usability Evaluation, Web Usability, Rapid Prototyping, Software testing COMPUTER SKILLS • Languages • C, HTML, CSS, SQL, PL/SQL, Python • MS office • Access, Excel, PowerPoint, Project, Publisher, Visio, Word • Databases and Tools • MS Access, Oracle, SQL*Plus, Toad, ERwin Data Modeler • BI Tools • Cognos 8 Business Intelligent Suite • Operating System • MS Windows NT/2000/XP/Vista, MS DOS WORK EXPERIENCE Senior Data Analyst 01/12/2009 – Present Deccan International, San Diego, CA • Data analysis, data mining and database configuration tasks • Perform map processing tasks • Assist with the many technical tasks associated with turnkey installation of decision support software • Maintain and support existing software applications • Interact and communicate with the Project Management and the Engineering team on issues related to software maintenance and support • Design and develop new functionalities and application modules based on the user requirements • Design technical specifications documents and derive implementation techniques for new applications • Responsible for coding enhancements • Build and configure FoxPro and MapInfo database tables for driving client-specific applications • Document and track necessary changes Business Systems Analyst 01/02/2008 – 12/15/2008 Clear Thought Solutions, Cary, NC • Managed the development and analysis of requirements for multiple corporate project initiatives 19 • Interacted with business unit management and customers to identify and document business needs and objectives, current operational procedures, problems, and security requirements • Drafting project plans, identifying and mitigating project risks, and communicating them to customers • Created and maintained functional specifications documents and business Use Case Models using UML • Prepared time and cost estimates for completing projects • Authored software user documentation, instructions, and procedures • Monitored and documented post-implementation problems and revision requests • Provided status updates by presenting project results to the project team, senior management, and clients • Designed complex reports and report using Cognos 8 BI tools like Query Studio and Report Studio • Wrote complex SQL queries for report validation, data extraction, and data comparison PREVIOUS DECCAN ASSIGNMENTS INCLUDE: Fire Department of New York, Orange County Fire Authority, Virginia Beach Fire Department Contact information can be provided upon request. 20 5) Organization Chart/ Proposed Project Team Deccan will be the only vendor involved with the project; no services needed to fulfill the PFA contract will be subcontracted. The organization chart for the proposed team, in addition to a PFA representative, appears below: Assistance that will be required from PFA staff in order to complete the project is detailed in section 7. 21 6) Availability Deccan representatives are available to conduct a “webinar-style” demonstration/interview meeting remotely the week of July 16th, 2012, if selected for the interview round. After award of the PFA contract, key project personnel will be available to deliver the CAD Analyst, ADAM and BARB applications according to the schedule listed in Section 1. 7) Estimated Hours by Task CAD Analyst During the first phase of the project, Deccan would work closely with PFA to retrieve the necessary CAD data required to build the application. (Please see Appendix A near the end of this proposal for details. PFA is referred to as “The CLIENT”.) Deccan would also work with PFA to obtain necessary GIS data. (Please see Appendix B at the end of this for details. PFA is referred to as “The CLIENT”.) A list of tasks associated with building CAD Analyst is listed below. Please note that each working day includes a minimum of 8 hours. Estimated days for each task vary depending on the project size, complexity, extent of scope and requirement. Some tasks are dependent on PFA returning requested information in a timely manner. Therefore, the following task list can only be representative of a typical CAD Analyst build and must be more precisely developed once the specific requirements of PFA are understood. Tasks Task duration/Time from project start date (in estimated working days) Notes Responsible Party 1) Provide CAD and Map/GIS data 1/1 PFA 2) Review data with client and convert into Deccan standard format 1/2 Allows Deccan to learn about department reporting needs, future projects, CAD system, tables, and schemas Deccan and PFA 22 Tasks Task duration/Time from project start date (in estimated working days) Notes Responsible Party 3) Work with client to build the response criteria, define time targets, unit types and capabilities and incident type groupings 1/3 Allows Deccan to learn about current projects in detail and work with the client to define the configuration tables Deccan and PFA 4) Finalize unit and incident type-related configuration tables 1/4 Deccan needs to get final approval of CAD mappings and logic from the client PFA 5) Write programs incorporating mappings and logic to convert data into Deccan standard format 1/5 Deccan 6) Test and revise the computer programs for accuracy and optimization 1/6 Deccan data analysts will work with engineers to test, modify and validate the code Deccan 23 Tasks Task duration/Time from project start date (in estimated working days) Notes Responsible Party 12) Build CAD Analyst 1 /12 Build CAD Analyst by combining the incidents, map layers and configuration tables Deccan 13) Work with the department to set-up CAD Analyst scenarios 1/13 Client can provide details of scenarios to include in CAD Analyst shipment Deccan and PFA 14) Deccan In-House Testing 1/14 Deccan 15) Delivery and installation of CAD Analyst 1 /15 Deccan 16) Training on CAD Analyst via Microsoft Live Meeting 1 /16 Deccan and PFA Auto Data Updater The Auto Data Updater may be delivered together with CAD Analyst. Tasks Task duration/Time from project start date (in estimated working days) Notes Responsible Party 1) Create ADU specifications for Engineering 5/5 This phase will include the 24 Tasks Task duration/Time from project start date (in estimated working days) Notes Responsible Party 3) Testing 5/15 This phase will include exhaustive internal testing of ADU; Data Analyst and Engineering will work together to validate it. Deccan 4) Deployment - On Site Testing 1/16 The first draft of ADU will be made available for deployment at PFA so that it can be tested. Deccan 5) Feedback and Delivery 5/21 This phase will include troubleshooting any issues identified with the first draft of the ADU. If no issues are found, the first draft will become the final version. Deccan and PFA 25 ADAM After CAD Analyst is built, Deccan can complete the set-up and installation of ADAM. A list of tasks associated with building ADAM is listed below. Please note that each working day includes a minimum of 8 hours. Estimated days for each task vary depending on the project size, complexity, extent of scope and requirement. Some tasks are dependent on PFA returning requested information in a timely manner. Therefore, the following task list can only be representative of a typical ADAM build and must be more precisely developed once the specific requirements of PFA are understood. Tasks Task duration/Time from project start date (estimated working days) Notes Responsible Party 1) Revise configuration tables for ADAM based on feedback 2/18 Deccan and PFA 2) Work with client to get a final approval of apparatus deployment and gather some key information to calibrate ADAM 1/19 Deccan and PFA 3) Process CAD and map data 1/20 Deccan and PFA 4) Create routing files 1/21 The routing files are created from the streets network Deccan 26 Tasks Task duration/Time from project start date (in estimated working days) Notes Responsible Party 5) Build ADAM 3/24 ADAM is built by combining the incidents, map layers and configuration tables Deccan 6) Calibrate ADAM 2/26 ADAM is calibrated to match historical performance Deccan 7) ADAM Calibration tests 1/27 The calibration result is tested by comparing projected scores with actual scores in CAD Analyst Deccan 8) Create ADAM scenarios 1/28 Deccan 9) Test ADAM 1/29 Deccan 10) Deliver and Install ADAM 1/30 Deccan and PFA 11) Training on ADAM via Microsoft Live Meeting 1/31 Deccan and PFA 27 BARB BARB can be built concurrently with CAD Analyst and ADAM, using a subset data provided by PFA for CAD Analyst. A list of the associated tasks is listed below. Please note that each working day includes a minimum of 8 hours. Estimated days for each task vary depending on the project size, complexity, extent of scope and requirement. Some tasks are dependent on PFA returning requested information in a timely manner. Therefore, the following task list can only be representative of a typical build and must be more precisely developed once the specific requirements of PFA are understood. Task Estimated task duration (days) Estimated time from project start date (working days) Responsible Party 1) Project kickoff 1 1 Deccan 2) Assign project manager PFA 3) Retrieve and upload raw map data in specified format 10 11 PFA 4) Retrieve all business rules for agency PFA 5) Build up to 3 BARB scenarios 5 26 Deccan 6) Deliver BARB to client via the FTP site (or other arranged method) and provide installation instructions 1 27 Deccan 7) Provide Training Via Microsoft Live Meeting 1 28 Deccan and PFA 28 8) Schedule of Rates and Cost by Task Rates are inclusive of all labor needed to provide the tasks listed in Section 1 and the deliverables listed in Section 2. As such, detailed “line item” costs for components/phases of the project do not apply. CAD Analyst/ADAM Quote 29 BARB Quote As detailed in the above quotes, the total project cost for CAD Analyst/ADAM & BARB is $174,230. 30 Hardware Requirements for CAD Analyst, ADAM, and BARB Deccan does not supply any of the hardware required to run the applications. The below chart contains minimum and recommended hardware requirements needed to run CAD Analyst (exclusive of the Auto Data Updater), ADAM, and BARB. Auto Data Updater Requirements The Auto Data Updater gives the user the ability to pull data directly from the CAD/RMS database into the application, making it available for immediate analysis. This feature will require additional resources from PFA, as listed below. Server: The Auto Data Updater needs a database instance to be created for copying, storing and processing data. This database can be hosted in the CAD Server or any other database server in the network. If it is not hosted in the database server where the CAD database resides, then the connection information for this new database server is required. The name, username and password for this new ADU database is given below. 1. Create an ADU database for storing data queried from the Source database. The initial size of the database should be at least 1 GB with an auto-grow option. 2. Create a username and password with full access permission to ADU database and read permission to the Source database. Workstation: 1. Connection to the ADU database server and the CAD database server by the network 2. User must have permission to install the Auto Data Updater utility 3. User must have permission to read and write to the 'Program Files' folder Hardware Requirements: Small business Server (IBM/HP/DELL with RAID 5) or (Existing Database Server) 1. RAM (4 GB) 2. HDD (250 GB X 2) 3. Keyboard, mouse, monitor and CD/DVD drives, etc. 4. High speed network card 100 mbps or above 31 Software Requirements: 1. Windows Server Operating System (or any other OS already installed) 2. Database Server software (Oracle/SQL Server/MySQL) 3. CAD Analyst/ADAM 4. MapInfo Professional 5. Anti-Virus Security Software 32 Appendix A – CAD Data needed by Deccan International for CAD Analyst, ADAM and BARB CAD Data Deccan will require at least two years of historic CAD data. As a result, if PFA has changed CAD systems recently, Deccan would require CAD data from the previous CAD system as well as the current CAD system. Incidents and Responses Data on both incidents and responses is needed. An incident is a call for emergency, such as “Brush Fire on 2000 Main Street on 01/02/98 at 01:05:25”. Responses correspond to the various units that respond to that incident, one response for each responding unit. Thus, for the above incident example, responses would be those corresponding to units E1, E3, M5, etc. that responded to that incident. Incident data contains incident-specific information such as incident number, incident type, incident location and incident date. Response data contains response-specific information such as unit id, unit name, unit quarters, and all the time stamps associated with the unit response. Deccan would like to obtain incidents and response data for the past 2 years. THE CLIENT would provide the incident and response data as it appears in the CAD or RMS system without filtering any fields in delimited ASCII text, DBF or Access (.mdb) format. Deccan prefers not to use excel format due to its size limitations and tendency to convert text fields to dates. Deccan also requests THE CLIENT to provide field descriptions for the data. Units and Incident Types Related Data In addition to the CAD incident and response data specified above, Deccan wishes to obtain any supporting tables in the CAD or RMS system, or any documents describing units and/or incident types. The purpose of this data is as follows: • To obtain the current units in THE CLIENT department, including their location(s) and capabilities. • To obtain the incident type descriptions so that Deccan can categorize each incident into a particular incident type group (for example, Structure Fire, ALS, BLS, etc.). Deccan also requests THE CLIENT to provide the following: • A list of units within THE CLIENT department, with a description of their type and their primary quarters. • A list of capabilities for each unit-type (i.e. what they can respond as). For example, whether it is an engine, if EMTs or ALS providers (Paramedics) are on the unit, etc. • A list of all the incident types assigned by the CAD system, with a description of each incident type. If available, Deccan also requests THE CLIENT to provide a generalized grouping of all the incident types into common incident type groupings such as Medical (ALS), Medical (BLS), Rescue incidents, etc. • All fields in the CAD or RMS system relevant to units’ statuses. 33 Response Criteria Deccan requests THE CLIENT to provide a list of response criteria that THE CLIENT wishes to be calculated by the applications, along with their corresponding starting and the ending timestamps. If available, Deccan also requests THE CLIENT to provide department-specific time target(s) for each response criterion. An example of a response criterion is “First Paramedic Response Time (Time Dispatch to Time On Scene)”. THE CLIENT can choose from the below sample response criteria or add their own response criteria. Please note that there is a limit of 42 response criteria in CAD Analyst and a limit of 21 response criteria in ADAM. Sample Response Criteria • Call Processing Time (Entry to Dispatch) • Turnout Time of First Unit (Dispatch to En route) • Travel Time Of First Unit (En route to On Scene) • First Unit Total Response Time (Receipt to On Scene) • First Unit Response Time (Dispatch to On Scene) • First ALS Unit Response Time (Dispatch to On Scene) • First BLS Unit Response Time (Dispatch to On Scene) • First Paramedic Response Time (Dispatch to On Scene) • BLS At Patient Side Response Time (Dispatch to At Patient Side) • ALS At Patient Side Response Time (Dispatch to At Patient Side) • First Engine Response Time (Dispatch to On Scene) • Second Engine Response Time (Dispatch to On Scene) • First Transport Response Time (Dispatch to On Scene) • First Chief Response Time (Dispatch to On Scene) • First Alarm Assignment (3E, 1L, 16FF) (Dispatch to On Scene) 34 APPENDIX B – Map Data Needed by Deccan International for CAD Analyst, ADAM and BARB Deccan requests THE CLIENT provide any available map layers for map processing. The maps can be provided in ESRI shape file format, ESRI ArcInfo export format or MapInfo. tab file format. Deccan also requires the projection information (system on which the maps are based). • Streets: This is the most significant map layer Deccan would need, as ADAM uses this streets file to perform routing. THE CLIENT is expected to ensure that the street network provided has good connectivity and is very close to the actual street network in the service area. The following information for each street line needs to be identifiable:  Street name  Co-ordinates of starting and ending nodes  From and to address ranges for the left and right sides of the segment  Alias street name, if any  One-way info  Speed limit  F-level and Z-level, if any • Jurisdiction boundary: The polygon layer that defines the jurisdiction boundary or THE CLIENT service area boundaries. • Dispatch Grids / Boxpolys: The polygon layer would enable Deccan to build CAD Analyst and ADAM response zones. • Census Tracts or any similar polygon layers: Census tracts or any other polygon layers available for THE CLIENT service area. • Fire/EMS Stations: A map layer corresponding to the current Fire/EMS station locations in THE CLIENT jurisdiction and any mutual aid station locations THE CLIENT would like to model. • Possible Fire/EMS station locations: A map layer corresponding to the future Fire/EMS station locations or any possible station locations planned to be built in the future within the Fire/EMS jurisdiction. • Point layers of significant buildings such as schools, hospitals, shopping centers and landmarks. These layers would greatly assist in performing a hazard analysis for the jurisdiction. • Major natural divisions: Polygon layers for lakes and parks. This would enable a CAD Analyst/ADAM user to easily grasp why estimates of time to “seemingly near” locations is high. Please zip the maps using a utility such as “WinZip” before sending to Deccan. 35 Vendor Statement 36 Insurance preparation of data so that it can be used with standardized Deccan algorithms. Deccan 2) Engineering to Configure ADU 5/10 Engineering will create/modify the ADU code based on PFA’s unique client database. Deccan 7) Build the base configuration tables driving CAD Analyst 1/7 Deccan 8) Incorporate any revisions the department may request after review of configuration tables 1/8 Deccan will work with client to get approval Deccan and PFA 9) Finalize map layers to be used in application 1/9 Deccan will work with client to get approval Deccan and PFA 10) Process map data based on client requirements 1/10 Deccan 11) Geocode incidents from the CAD data 1/11 Plot CAD incidents Deccan