Instructions for Scope Category Documents

EXHIBIT 2

Instructions for Scope Category Documents

Following is an explanation of the format and columns of the scope documents, which must be returned in softcopy on a diskette or CD as well as in hardcopy.

-# – Pre-assigned item number

-Questions – Questions are presented in two sections per scope: Qualifier and Detailed.

Qualifier – There are three or more questions in this section, which are meant to determine if a Respondent or its subcontractor has sufficient skills in this scope. These questions generally ask for a Yes/No answer, or a number to rate experience on a defined scale. The rating scale for self-ranking questions is in the footer on every page. If you cannot answer all of the questions in this section to indicate at least average expertise, do not answer the detailed questions.
Detailed – These questions will more thoroughly explore a Respondent’s experience in that scope category. They also require one-word or number answers, or self-ranking.
All questions – Answers for the questions must be complete. In some cases, several tasks or products are listed for a question; your response must address all items listed. Therefore, if you are familiar with only a portion of the items, you must indicate the ones with which you do not have experience. In addition, if requested, you must indicate the specific release level(s) of the software with which your firm has expertise. The City is looking for experience with release levels that are currently certified by the software vendor unless otherwise indicated.

-Response – Input your one-word, number or ranking response in this column. Use the Comments at the far right for any additional text/explanations, or if directed in the question for further information.

-Primary/Subcontractor – Indicate whether the primary provider of services will be the Respondent, or if it will be a subcontractor – Use “Primary” or “Sub” as appropriate. Only one scope response can be submitted for each category. If both the primary Respondent and a sub can provide these services, it is recommended that you select the more capable provider.

-Reference Numbers – If you are including a reference for which you performed the function covered in that question (using the same approach, technology, etc.), provide a number (that you assign) to that reference. Provide the rest of the information about that reference in the Reference Exhibit 11. You must provide a reference for the qualifier questions; it is recommended that you provide one for any question ranked as C- Critical. You may use the same reference for multiple questions, but must include at least three per scope.

-Comments – Use this section to provide additional information as requested in the question or any comments you wish to make. For lengthy comments – please attach a separate sheet or provide a link and include the scope category and question number (e.g., IT Infrastructure Design question n).

EXHIBIT 3

Application Development, Support and Ongoing Maintenance Scope

# / Scope Category: Application Development, Support and Ongoing Maintenance
Scope Questions: Please respond to the Qualifiers questions. If you, or any subcontractors you plan to use, have not performed the items in this section, please skip the remaining detailed questions in this scope and move to the next scope category; otherwise complete the rest of the items for this scope. / Response / Is this a service that you provide or will a subcontractor perform it? (Indicate "primary" or "sub" as needed) / Ref. #s (see foot-note) / Comments

Qualifier Questions

1. / Rate your experience* in Object Oriented application development using Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. Use the Comments section to identify specific tools and methodologies used. Include other Java frameworks you have experience using.
2. / Rate your experience* in design and implementation of an application security infrastructure. Specify if you have experience with PCI or HIPAA applications. Use the Comments section to identify specific tools and methodologies used.
3. / Rate your experience* inOracle database design and development, including current vendor-certified release(s) of:
-OAS
-Forms
-Reports
-PL/SQL
Use the Comments section to identify the release levels as well as any of the above aspects with which your firm does not have experience.
4. / Rate your experience* inUNIX, Linux and Windows system administration in a distributed Java environment. Use the Comments section to identify specific tools and methodologies used.
5. / Rate your experience* in performing ongoing application support for the following situations:
-For an application you developed
-For an application developed by another firm or in-house by that client
-For a packaged application
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
6. / Rate your experience* with enterprise-wide Services Oriented Architecture.

Detailed Questions

7. / Indicate the percentage of company projects in the last two years (based on total staffing) that used Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. / N/A
8. / Indicate the number of company projects in the last two years that produced revenue ranging up to $100K that used Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. / N/A
9. / Indicate the number of company projects in the last two years that produced revenue ranging from $100K to $500K that used Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. / N/A
10. / Indicate the number of company projects in the last two years that produced revenue exceeding $500K that used Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. / N/A
11. / Please indicate number of staff with at least three years’ J2EE development experience, including the following aspects:
-EJB’s
-JAAS
-JMS
-JTA
-JPD
-JEE Connector Architecture
-JEE Security
-JEE Transaction based applications
Use the Response section to identify the number of staff.
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
12. / Do you perform development using frameworks? (Yes/No)
For example:
-Struts
-JSF
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
13. / Rate your experience* gathering business requirements.
Use the Comments section to identify specific methodologies and tools.
14. / Rate your experience* providing project management for custom software development initiatives.
Use the Comments section to identify specific methodologies and tools.
15. / Rate your experience* with application architecture.
Use the Comments section to identify specific methodologies and tools.
16. / Rate your experience* conducting quality assurance. Include experience with unit, system, integration and user acceptance testing.
Use the Comments section to identify specific methodologies and tools.
17. / Rate your experience* in development for the current vendor-certified release(s) of BEA WebLogic Server, Integration and Portal, including experience with WebLogic Workshop. Include development environments like Eclipse,
Use the Comments section to identify the release levels.
18. / Rate your experience* with the current vendor-certified release(s) of WebLogic Integration and other integration environments like enterprise service bus. Use the Comments section to identify the release levels.
19. / Rate your experience* with open source application servers. Include development tools and ancillary products like Hybernate. Use the Comments section to identify release levels.
20. / Rate your experience* with version 7.x of BroadVision, including the following:

Development
Administration
Troubleshooting
Performance measuring and tuning
BV database schema

Use the Comments section to identify any of the above aspects with which your firm does not have experience.
21. / Rate your experience* with Software Configuration Management in a structured environment, using Open Software Tools such as:
-Bugzilla
-Subversion
-CVS
-Cvsweb
-CruiseControl
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
22. / Rate your experience* building web content management applications using third party toolsets.
Use the Comments section to identify specific vendors and versions.
23. / Rate your experience* integrating web applications with third party enterprise content management systems.
Use the Comments section to identify specific vendors and versions.
24. / Rate your experience* with visual design and usability.
Use the Comments section to identify specific methodologies and tools.
25. / Rate your experience* in design and development of an application that adheres to accessibility standards. Use the Comments section to identify specific tools and methodologies used.
26. / Rate your experience* with automated unit, integration and load testing, such as the following tools:
-Jmeter
-LoadRunner
-Junit
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
27. / Rate your experience* with distributed directory and security services as part of an application development project, such as:
-OpenSSL
-SSL
-LDAP
-PGP
-x.509 digital certificates
-Single sign on
-Challenge and response
-Assertions
-Secure web services
-Encrypted XML
-ActiveDirectory
-eDirectory
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
28. / Rate your experience* in implementing application, data and web security as part of an application development project, as they pertain to HIPAA, PCI and other similar requirements.
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
29. / Rate your experience* with BEA WebLogic Server, Integration, Portal, ALSB, and ALDS administration including:
-Creation of new Domains
-Creation of a clustered environment
-Troubleshooting from a system standpoint
-Performance monitoring and tuning
Use the Comments section to identify the release levels as well as any of the above aspects with which your firm does not have experience.
30. / Rate your experience* in performing the following aspects of ongoing application support:
-Help Desk support
-Monitoring/alert services on a 24/7 basis
-Break/fix
-Additional enhancements
Use the Comments section to identify specific technology of the application (development tools, DB, etc.).
31. / Rate your experience in performing the following aspects of ongoing application support:
-User training
-Other training
-Help Desk and Operational Documentation
-Data entry
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
32. / Rate your experience* in application support and enhancements in a IBM/MVS environment, to include the following activities and tools/platforms:
-Analyze, design, program, test and implement fixes and enhancements
-COBOL
-DB2
-VSAM
-UFO
-CICS
-JCL
-Create reports in SAS and Mark IV
-Develop interfaces to other mainframe or non-mainframe (usually Oracle) applications
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
33. / Have you converted data from applications in a IBM/MVS environment using ISAM/VSAM and/or DB2 to a web-enabled Oracle application, including the following activities (Y/N):
-Analyze, map, design, program, cleanse and perform data conversions to other application(s)
-Convert data from a decommissioned mainframe application to an Oracle database on another platform and provide a user interface to view data only
-Archiving data (use Comments to indicate tools/platforms utilized)
34. / Rate your experience* in converting an application using Oracle forms or an MS Access DB to a web-based application. Use Comments to identify specific tools used.
35. / Rate your experience* in development of Business Objects universes, using the current vendor-certified release(s) of Designer and Supervisor, to include the following activities against Oracle databases:
-Requirements analysis, development, data validation against the application, performance tuning, documentation, and knowledge transfer
-Implementation of row- and column-level security using Designer and Supervisor
Use the Comments section to identify the release levels as well as any of the above aspects with which your firm does not have experience.
36. / Rate your experience* in development of complex reports in Business Objects, including the following components:
-Independent variables
-Multiple queries
-Linking multiple data sources
-Importing/exporting data
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
37. / Rate your experience* in creation of universes, implementation of ETL tools and development/support of reports in a data warehouse environment. Identify tools used and number of users in the Comments section.
38. / Rate your experience* with the current vendor-certified release(s) of the following products/tools in an Oracle DB environment:
-Crystal Reports
-Business Objects Broadcast Agent
-Business Objects WebIntelligence
-Business Objects Data Integrator
-Business Objects Dashboard Manager
-Business Objects Performance Manager
-Business Objects SDK
-Business Objects Analytic Applications
-Business Objects Auditor
Use the Comments section to identify the release levels as well as any of the above aspects with which your firm does not have experience.
39. / Where are the resources located who will provide the above services?

Reference #: If you are using one or more reference(s) to demonstrate capability in this section, indicate the identification number of each reference, which will tie to the reference page (See Reference Section).

*Rating scale: 5 = excellent/best-in-class, 4 = above average, 3 = average, 2 = less than average, 1 = minimal exposure, 0 = no experience.

EXHIBIT 4

GIS Application Development, Support and Ongoing Maintenance Scope

# / Scope Category: GIS Application Development and Support
Scope Questions: Please respond to the Qualifiers questions. If you, or any subcontractors you plan to use, have not performed the items in this section, please skip the remaining detailed questions in this scope and move to the next scope category; otherwise complete the rest of the items for this scope. / Response / Is this a service that you provide or will a subcontractor perform it? (Indicate "primary" or "sub" as needed) / Ref. # (see foot-note) / Comments

Qualifier Questions

1. / Rate your experience* in developing GIS Layers and Geodatabases on the current vendor-certified release(s) of the ESRI platform. Use the Comments section to identify the release level(s) with which your firm has experience.
2. / Rate your experience* in developing ArcObject based tools and applications using Visual Basic or Java.
3. / Rate your experience* with GIS Website development using Java and WebServices.
4. / Indicate whether you are a provider of GIS products or GIS data. (Yes/No) Use Comments for more explanation.

Detailed Questions

5. / Indicate the percentage of company projects in the last two years (based on total staffing) that are primarily focused on GIS application development. / N/A
6. / Indicate the number of company projects in the last two years that produced revenue ranging up to $100K that used Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. / N/A
7. / Indicate the number of company projects in the last two years that produced revenue ranging from $100K to $500K that used Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. / N/A
8. / Indicate the number of company projects in the last two years that produced revenue exceeding $500K that used Java as the primary language and related tools such as Struts, Spring, Hibernate and XML. / N/A
9. / Indicate the number of full time consulting staff, the number of dedicated GIS consulting staff and the percent of total staff that is GIS certified, or has a GIS-related degree.
10. / Rate your experience* in Basic Database Design, including the following components:
Relational Data Modeling and normalization.
-Facilitation of design workshops with user teams

Use the Comments section to identify any of the above aspects with which your firm does not have experience.

11. / Rate your experience* in facilitation of design workshops with user teams.
12. / Rate your experience* in modeling of geographic layers.
13. / Rate your experience* in Annotation Feature Class Design.
14. / Rate your experience* in designing Feature Datasets.
15. / Rate your experience* in Geodatabase Design, including the following components:
-Design of Planimetric Feature Data sets
-Design of Cadastral Feature Datasets
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
16. / Rate your experience* in Geodatabase Management, including the following components:
-Current vendor-certified release of the SDE Administration
-Management of multi-editor versioned databases
-Management of Raster datasets
Use the Comments section to identify the release levels as well as any of the above aspects with which your firm does not have experience.
17. / Rate your experience* in Advanced Geodatabase Design, including the following components:
-Design and implementation of topology rules
-Integration of Geodatabase with tables from other enterprise databases
-Geometric Network geodatabase design
Use the Comments section to identify any of the above aspects with which your firm does not have experience.
18. / Rate your experience* in GIS Data Conversion, including the following components:
-Performed enterprise level data migration from coverage/shapefile to geodatabase model
-GIS Conversion Strategy Design and Planning
-Georeferencing Raster Datasets
-GIS Conversion / data creation from paper sources
-GIS Conversion / data creation from raster sources
-GIS Conversion / data creation from CAD
-Quality Control of Conversion Projects