Loading...
HomeMy WebLinkAboutRESPONSE - RFP - P1076 WEBSITE UPDATE AND SUPPORT MPONorth Front Range Metropolitan Planning Organization — Website Update / Support by Squaref Techno%gfes Inc Request for Proposal — P1076 Tuesday July 10 2007 Information contained in this proposal shall not be disclosed outside North Front Range Metropolitan Planning Organization (NFRMPO) and shall not be duplicated used or disclosed in whole or in part for any purpose other than to evaluate this proposal If a contract is awarded to this offer or as a result of or in connection with submission of the data contained herein NFRMPO shall have the right to duplicate use or disclose the data to the extent provided in the contract This restriction doesn t limit NFRMPO right to use information contained in the data if it is obtained from another source without restriction The data subject to this restriction comprise the whole of this proposal NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Web Measurement Strategy It is critical to build a measurement plan into the early stages of developing the new sites Squarei typically recommends a measurement strategy early in the project to define the key performance indicators This approach ensures the new sites are built for analysis as we plan the interface architecture and perform site development Measurement Approach & Objectives Our measurement approach is based on the following principles • Identify Objectives - Key objectives defined in the business analysis will serve as the foundation for the measurement planning • Define Key Performance Indicators - Key Performance Indicators (KPIs) represent metrics that align with your objectives KPIs are identified based on your goals and user requirements • Tagging Strategy— We will devise a tagging and reporting strategy that will allow NFRMPO to follow the define conversion activities and other user interactions on the new sites Key Activities & Deliverables • Measurement Plan Review meeting(s) • Analytics Review • Measurement Plan Information Architecture Information architecture refers to the organization of a website's structure and content the labeling and categorization of information and the design of navigation The information architecture, when combined with the creative interface design provides an organization with a meaningful representation of the new website Objectives • Define the top level structure and organization of the site • Define the proposed navigational structure • Develop a persuasive site architecture which effectively moves users through the key tasks CMEW] Page 10 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Define key page -level wireframes which describe layouts and demonstrate the relationship between content on pages • Define the interaction design for any application functionality (ex End user creating an Account) Key Activities & Deliverables • Site Map Review meeting • Wlreframe Review meetings • Site Map • Navigation Standards • Page -level Wireframes ® Page 11 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 North Front Range Metropolitan Planning Organization (NFRMPO) Website Some thoughts as you head into your project Migration of your current pages - How much of this content is actually relevant and recent As you move into generation 2 0 of your website this is one area that directly affects overall scope and establishes key priorities for your project Squarei Technologies has a proven methodology for ensuring relevant and engaging content accompanies the new site Information Architecture During your audit of the current site is an excellent time to evaluate the alignment of your content to your overall goals and the personas of your visitors What content is getting the most traction? Is content structured In a meaningful, easy to understand way throughout the sites? How are you reaching out to members of the community? What are people searching for and how can you leverage that in your content structure The answers to these and other related questions will affect the design elements being developed in the website redesign project Squarei Technologies has added two proposal line items to assist 1) A brief but powerful user research phase, and 2) Production of anew set of information architecture for the site The Web 2 0 Generation - Understanding the expectations of a web savvy generation is key to your sites' success but understanding what they are looking for is only half of the equation Successful websites emphasize bi-directional conversations that incorporate user generated content from tools like wikis, blogs and discussion forums Squarei Technologies has solutions for these dynamic conversations which can transform your site into being relevant and useful for its customers Building Consensus At Squarei Technologies, we have coordinated numerous projects involving multiple departments with a seemingly unending stream of decision makers We are expert consensus builders who listen, understand the goals of each project stakeholder, and work to build a vision which will be vigorously supported by the organization post implementation Our consensus building talents go right to the bottom line, saving money, improving organizational adoption and delivering a crisp, innovative solution devoid of muddy design compromises Page 12 of 29 TECH NOLOGI ES NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Graphic Design & Specification Refinement (User Research Phase) The items presented in this proposal have been componentized This means that NFRMPO can select items to be developed now and leave other items for future phases of development We will work with NFRMPO staff to ensure we fully understand all of the requirements and will present designs and the functional elements for NFRMPO staff to review and choose from After the design is accepted, prototypes of the primary web pages will be developed to ensure that all content, fields and functionality are present and their usability is addressed During this stage NFRMPO staff will have the opportunity to refine their requirements as well as address any navigation or process flow issues Upon acceptance, development of working applications and web pages will begin using the prototypes as the final requirements documentation in conjunction with any supporting written materials or diagrams The following is a brief description of each component Initial Kickoff Meeting The initial kickoff meeting is held to acquaint stakeholders and team member with the project and each other It should be fun, informative and productive A draft meeting agenda is provided, Addendum 1 User Survey Instrument A user survey will be developed and delivered to website users specified by NFRMPO The objective of the survey will be to determine current user's perceptions, opinions, and improvement ideas We will work with NFRMPO staff to evaluate the results and incorporate the appropriate improvements Squarei has used several survey tools in the past, we plan to use Constant Contact's ListenUp Survey tool to create, deliver and evaluate survey results This tool provides easy access to the survey information as well as transparency into the process CREME Page 13 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Data Access & Sharing The ability to make available and share documents, images, and files with your users is powerful and very useful There are many ways to accomplish this task, from Microsoft SharePoint to FTP to a custom solution Although it may be pre mature to select an architecture and methodology for creating users and sharing documents, we expect and propose a custom solution at this time If, during the requirements gathering phase, we determine another solution makes more sense we will re-evaluate to help NFRMPO make the best decision Static Images (gif, jpg, prig, etc ) and geographic data (txt, pdf, xis, mdb, xml) must be exposed to end users for download in the first phase of this project There must also be a manageable methodology for administrative NFRMPO staff to maintain the data and make the content available on the website There are basically three components Square) will create to manage this information 1 Administrative console that allows NFRMPO staff to name, upload, categorize, and establish the content area of a particular data file 2 Establish pages within the overall site that will expose the appropriate category of data files 3 Develop a user sign-up process with a corresponding NFRMPO staff approval process that provides users with access to the shared data files (See Figure 1) Figure 1— Data Access & Sharing Workflow To secure the data files we will ensure any page that displays secure shared data files requires user authentication persisted via session state (or if necessary with expiration enabled unique identifying tokens) Page 14 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Public Access & Involvement The public portion of the website is the opportunity to help inform It will be designed to be visually compelling, easy to navigate and contain valuable information The primary content areas that will be available to the general public are • Sign-up for Email announcements will be woven into the primary navigation This will provide end users with a call to action "Sign Up for Email Announcements Now"" throughout the site For an example of this see the bottom portion of the following web page http //www squares com/Solution_WebDev aspx • About NFRMPO Mission statement, History, etc • News Press Releases, Executive Directors Report, Email announcement signup, etc • Meeting Information NFRMPO, Transportation Advisory Committee, Transit Advisory Group • Calendar Special Events, etc • Employment Opportunities • Contact NFRMPO Contact information for NFRMPO and email submission form to be sent to NFRMPO staff • Misc Site info Terms of Use, Privacy Policy, etc Links to Partnering Agencies Links to partnering agencies and reciprocal links from their website back to NFRMPO will make the NFRMPO content more relevant to search engines and more relevant to users It is important to take advantage of a linking strategy We will design this section to allow for multiple styles of partner logos, organization names, and brief description of the partnership Graphic Design We will work with NFRMPO to create a dynamic and progressive graphic design Website design has several key considerations • Provide a consistent look across all marketing collateral • Template based design -a design that promotes easily adding and removing content and navigation Page 15 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 • Navigation should be as simple and straight forward as possible while complex enough to support the inevitable changes that occur • Too much information on a single page overwhelms end users, proper use of white space is critical Administration Functions - Content Management System (Sttecore) Squarei proposes to implement Sttecore for the NFRMPO content management system Complete Sttecore information is available at www sitecore com Listed below are some of the core features of Sttecore Template Driven Web Pages One of Sitecore CMS strengths is our ability to separate content from presentation in order to facilitate the reuse of content objects or elements Sttecore CMS stores each content object or content element as tagged XML within the Sttecore repository These content elements can be rendered within multiple page layouts as it is defined in the presentation layer For example a news article could have the date, author and title content element used on the homepage and news section of the site, while the full news article (and any accompanying images) itself could be presented as a print friendly page, as a portion of a newsletter layout and inherit the news section layout on the main news section Flexibility Managing content from a business user's perspective is easy in Sttecore They simply navigate to the content they are responsible for, click on green content marker and add or edit content or insert image/media items within a familiar setting very much like MS Word —they can even choose to use MS Word as the editor if they so wish Non -technical users (with permissions) can add pages and even sections by right mouse clicking on the content marker These users can also schedule content to be published on a future date, preview that content and even set the archival or removal date Browser -Based Application Sttecore is 100% browser based for both Developers and non technical users and requires zero client side installation of software Security Sttecore s user management is a module where administrators can administer over the users and roles within the CMS itself and within a group of external users (Extranet users in Sttecore terminology) permissions can be set for what content should be presented outbound for named visitors to your site EMEW Page 16 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 In terms of managing access controls Sitecore works under an inherited security model that can provide CMS roles permission automatically when content is created Individuals within a group or role can be granted more granular access to read, write, rename, delete and administer content elements with Sitecore's User Management interface Sitecore has a connector available to LDAP to bring in users and groups into the CMS where specific permissions and access can be granted (LDAP Connector is an add on) Database -Driven Application SQL Support Sitecore provides a well documented data abstraction layer that can be easily extended by developers Sitecore comes with the ability to store its XML content within a relational database such as Microsoft SQL This ability to store and retrieve the content from the relational database, along with the ability to build dynamically build and update the in memory XML content tree is provided by a Data Provider The benefit in abstracting how the XML is stored and retrieved from the Sitecore developer is that the developer only sees is the XML content tree, which is navigable using standard XSL/XPATH or NET functionality, regardless of how and where the data is stored or retrieved from Short (Friendly) URLs Sitecore can enable permanent, descriptive and friendly URLs All URLs are based on name of the content item and the path of the item within the content tree URLs created by Sitecore do not contain page IDs and are compliant with Google search engine indexing as well MOSS 2007 Integration The valuable link that joins Microsoft SharePomt / MOSS 2007 to Sitecore's world class web Content Management System (CMS) Sitecore's CMS is the leading 100% Microsoft NET compatible way to manage dynamic websites Now you can create, publish and maintain content in a single place and put it to work for you, on any of your websites Sitecore CMS is an award -winning web content management system with over 1200 customers worldwide, and the leading solution that is architected from the ground up to be 100% Microsoft NET compatible The Sitecore SharePoint connector module makes it effortless, with transparent bi directional content access and extranet web security of all MOSS 2007 assets Page 17 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Content Management System Tools & Functionality The Sitecore content management system to provide the following tools Online surveys with the option of Sitecore has a polling module that allows for surveys to be having the results Invisible or built with results being captured and presented/ or displayed live hidden Sign up for electronic newsletters Sitecore has a newsletter module that allows organizations events and workshops with to build newsletter, manage subscriber and have distinct customized URL's URLs or aliases for the destination page RSS feeds RSS feeds are an out of the box function in Sitecore Online calendar with automatic Sitecore has a calendar module that can be updated and update features managed within the CMS Electronic fill able forms Depending on the need Squarei can build simple HTML forms or there are two optional components available in Sitecore Sitecore has a forms module for building forms Content management tool allows for Sitecore ships with a media library that can manage the ability to play quick videos (e g documents images, media files out of the box mov and avi files) and to post large image files Sitecore Web Analytics Sitecore provides standard reporting and analytics via our StatCenter component It provides aged content reports, usage reports, content auditing and exporting reports and broken link reports out of the box Customized reports can be easily configured but for more robust reporting requirements we have found that Webtrends and Google Analytics have been Implemented with Sitecore for more detailed reporting requirements Sitecore Technical Requirements This section describes the minimum requirements for a Sitecore NET server installation A server should at least meet the requirements as set forth by Microsoft and additionally the requirements below Software • Microsoft Windows 2000 Server with Microsoft Internet Information Server version • 5 0 (IIS 5 0), Windows XP or Windows 2003(IIS 6 0) • Microsoft NET framework 11 Page 18 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 • All the latest upgrades for the operating system and NET framework (service packs, patches, etc ) Antivirus Software Some antivirus Software can be detrimental to performance of ASP NET applications (including Sitecore) For this reason, we recommend you to use only those antivirus scanners that are certified for your particular version of Operating System Hardware • Minimum Intel Pentium IV or equivalent • Recommended dual CPU Pentium IV • 2 GB RAM minimum, recommended 2+GB RAM Server Access You need to install some DLLs on the server in order to use Sitecore This requires the access right to install custom software on the server This is straight forward if you have direct access to the server However, if you use a web hotel you must contact the ISP Presently Unit offers a dedicated Sitecore web hotel Database Support Sitecore supports SQL 2000 & 2007, Oracle 81, 91 & 10g, MySQL and various other Open Source databases Sitecore Client requirements This section describes the minimum requirements for a Sitecore web client (editorial and development purposes) Clients should at least meet the requirements as set forth by Microsoft and additionally the requirements below Software • Internet Explorer 6 0 and later (with MS XML 4 0 installed) or Mozilla Firefox 1 x Windows XP Service Pack 2 should be installed on Windows XP client computer Hardware • Intel Pentium III or equivalent Recommend Pentium III, 1000 MHz, 256 MB RAM minimum, recommended 512 MB RAM • ADSL connection of 256Kbit or better • Screen resolution of 1024x768 pixels recommended and is required for some of the advanced operations Resolution requirements may also vary with add -on modules BEEWC Page 19 of 29 TECH NOLOGI ES NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Table of Contents TABLE OF CONTENTS 2 OVERVIEW 5 COMPANY HISTORY 6 LOCATION 6 QUALIFICATIONS 6 ASSIGNED PERSONNEL 7 REPRESENTATIVE CLIENTS 7 PROJECT MANAGEMENT TOOLS AND PROCESS 8 Dedicated Project Manager 8 Project Status Reports 8 Client Extronet 8 Online Issue Management System 8 State of the Art Web Conferennng 8 PROJECT METHODOLOGY 8 Strategic Blueprint 9 Objectives 9 Key Activities & Dehverables 9 WEB MEASUREMENT STRATEGY 10 Measurement Approach & Objectives 10 Key Activities & Dehverables 10 INFORMATION ARCHITECTURE 10 Objectives 10 Key Activities & Dehverables 11 NORTH FRONT RANGE METROPOLITAN PLANNING ORGANIZATION (NFRMPO) WEBSITE 12 Some thoughts as you head into your project 12 Graphic Design & Specification Refinement (User Research Phase) 13 Page 2 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Search Functionality Sitecore ships a robust search engine from Lucene if necessary Sitecore can also be integrated with Google search appliance Coveo Search, FAST, dtSearch and other commonly used search engines Handicap Accessibility Sitecore ships with Section 508 compliance Project Closeout Meeting A closeout meeting is held to formally closeout the project with the team It will also identify the roles of responsibility for ongoing maintenance or future work, and capture 'lessons learned" for future projects It should be a celebration of a job well done with all team members Technology & Software Environment and Tools We propose to develop the application using web and Windows technologies The primary development toolset will include • Host Windows 2000 — IIS 5 1+ • HTML will support latest versions of Internet Explorer and FireFox • Development Tools Microsoft NET 2 0 platform, • Language Microsoft Net C# (c sharp) • Database Microsoft SQL Server 2005 • Reporting DataDynamics ActiveReports, Crystal • Content management Sitecore IMMMKil Page 20 of 29 T E C H N O L O G I E S NFRNIPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Testing During the development process, Squarer will post the application to a test domain, database server, and application server Your staff will have the opportunity to test, examine, and evaluate the application Following approval, Squarer will deploy the application to the production environment The websrte will be tested with Windows 98/2000/XP and the latest two versions of Internet Explorer and Firefox The layout will be optimal in browser versions 5 0 and above but may not be fully functional or identical in older version browsers This will cover approximately 98% of the current browser usage Client Deliverables NFRMPO will provide Squarei with the following 1 Content a Complete written content as desired for all pages described above Text to be delivered in Word format All text should be thoroughly edited by NFRMPO for spelling, typographical, and grammatical errors All content to be provided in electronic format 2 Discovery a To complete the project on time and within budget Squarer will work with NFRMPO staff to fully understand the final requirement details NFRMPO staff will need to be available to devote significant time towards this effort 3 Testing a Upon completion of the initial design cycle, Squarer will post NFRMPO websrte to a test domain NFRMPO personnel will have the opportunity to test, examine, and proofread the site Following approval by NFRMPO, Squarer will post the site to the domain provided by NFRMPO for public access 4 Sign offs — NFRMPO will sign off on the following elements as they are completed a Design — basic layout for each of the pages, navigation, and graphic images to be used throughout the site b Static content —final proofreading of all static content c Dynamic content — setup and configuration of options and lists d Functionality — final testing of the NFRMPO application Database The proposed application data store is Microsoft SQL Server 2005 This database is secure, maintainable, and very scalable Database design will follow industry standard methodologies and naming conventions will be followed As application coding dictates we will create all appropriate database triggers, stored procedures, and views Page 21 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Architecture Diagrams Security All data communications between browser and server requiring secure transmissions will employ Secure Sockets Layer (SSL) technology IMMMI Page 22 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Coding Philosophy Squarei realizes there is more to programming a successful than simple code Equipped with the knowledge to leverage existing components, architectures, and frameworks Squarei is able to create eloquent solutions that are easily extended and maintained Squarei employs a layered n-tier architecture when creating applications to solve most business requirements In its simplest form, an n-tier application applies three high level components Presentation (UI), Business Logic, and Data Access Each component can reside within the same application instance, across application domains, or even across different networks Separation of components solves many application design issues such as scalability, security, and stability A layered architecture spans the full spectrum of development disciplines allowing developers with all skills to effectively contribute to the application Presentation (UI) Tier Presentation logic includes the interfaces an end user interacts with Such interfaces can include ASP NET Web Forms, Windows Application Forms, or console interfaces In addition to form layout logic, coding for user input validation, navigation, UI events such as clicks, and business tier coupling exists Business process logic and all data access logic exist in their respective tier Business Logic Tier This tier is where the brains of the application reside Some of the components within this tier are business rules, processes, and detailed calculation The business tier can reside separately from any UI logic allowing for different interfaces, such as Web Forms or Win Forms, to utilize the same set of business logic Data Access Tier Data access is a layer of application logic that provides business logic coupling with a backend data store All CRUD (Create Read Update Delete) operations are contained within the Data Access Tier When designed properly, this tier can communicate with different data stores such as SQL Server, Oracle, and file storage Page 23 of 29 TECH NOLOGI ES NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Proposed Time Line / Milestones The following timeline is defined without specific dates because the start date is currently unknown The timeline is based on the currently defined scope If there are significant revisions to the scope of the project the timeline will be adjusted Work Description Milestone Completed Time (Est Weeks) Initial Design and Content Definition Design & Functional Specifications 20 Complete Code Development Initial Code Development 60 T Production Release Production Release 10 Totals 12 0 Weeks Cost Outlined below is the cost for all potential items A subset of these items will surely be selected and will require a re-evaluation of the Development Cost Squarei bills all web related services at the rate of $105/hr The only exception is static content migration which is performed at the rate of $50/hr TABLE 1- Development Cost Assessment of current Site / Infrastructure, User Survey Sitecore Implementation Costs $2 100 AM $12 600 Quality Assurance and Testing $6 300 Production Release $840 a-36ffaw9 $ Project Management TOTAL $45,990 BEERC TECH NOLOGI ES Page 24 of 29 NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 TABLE 2 - 3rd Party Software Cost Development Costs TOTAL TABLE 3 - Ongoing Maintenance Hourly Rate Tvpe of Service Design Task Rate* Application Programming 3� AS* .a Functionality additions and enhancements any ma/or $105/hr re design a a 1,0"Vi. g t * All rights to design work are transferred upon payment in full IMEWC T E C H N O L O G I E S Page 25 of 29 NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Client Testimonials If you need the Job done right and on time do it with Squarei on your team Kent Be/cek was a lifesaver for us He does excellent work and is dedicated to producing a product that all can be proud of Ron Kerr Director of Administration / Deputy Assessor Larimer County Squares developed and maintained a customized Access database that enabled us to enter and track data from students and alumni involved in a multi year research and evaluation project Although our primary communication with Squarei was via phone and a mad and work was done electronically, the applications developer took time to understand our specific needs and questions, and responded promptly to remedy any problems we encountered I have no hesitation in recommending their services Linda Pursley Director, Research for Planning & Evaluation Cambridge College Squarei has assisted the Lorimer County Community Corrections Department in the redesign and maintenance of our applications that track offenders throughout the Criminal Justice System We have been extremely impressed with the quality of service and the ethical and professional demeanor of the Squarei staff If you are in need of program design you would not go wrong in calling Squarei Joseph Ferrando Larimer County Community Corrections The staff at Squares was quick to understand the subtleties of our profession and was therefore able to design and implement difficult quantitative applications within the software that we needed It was exciting to see 20 years of data become truly useful again to better understand ecological trends Mindy Walker Wheeler Ecological Services IMERE Page 26 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Client References Thom Hadley —Chief Business Officer Colorado State University College of Veterinary Medicine and Biomedical Sciences 1601 Campus Delivery Fort Collins, CO 80523 1601 Thomas Hadley@colostate edu (970) 4915618 Greg Eslick - Director of Rapid Technologies Colorado State University Morgan Library Fort Collins, CO 80523 greg eslick@colostate edu (970) 6918640 Nancy Griffith -Conklin —Administrator Lanmer County Community Corrections Fort Collins, CO griffin]@co larimer co us (970) 498 7520 Stacey Lustig —VP Software Development Colorado Customware Inc Fort Collins, CO 80525 Stacey Lustig@cci ws (970) 223 6250 x26 Page 27 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 - Draft - Addendum 1- NFRMPO Website Update Kickoff Meeting Agenda Date & Time TBD Welcome & Introductions (5 Min) Meeting Purpose (5 Min) • Purpose To share current information relevant to the NFRMPO Website Update development and to highlight schedule, actions, products and expectations for project Project Overview (20 Min) • Scope • Possible Phases Project Plan (20 Min) • Project Deliverables • Preliminary Project Schedule Team Roles & Responsibilities (10 Min) • Project Manager • Project Team Members • MPO Representative Project Scope Change Control (10 Min) Other Business (10 Min) Wrap-up (5 Min) Inswil Page 28 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P2076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Initial Kickoff Meeting 13 User Survey Instrument 13 Data Access & Sharing 14 Public Access & Involvement 15 Links to Partnering Agencies 15 Graphic Design 15 Administration Functions — Content Management System (Sitecore) 16 Search Functionality 20 Handicap Accessibility 20 Project Closeout Meeting 20 Technology & Software Environment and Tools 20 Testing 21 Client Deliverables 21 Database 21 Architecture Diagrams 22 Security 22 CODING PHILOSOPHY 23 PROPOSED TIME LINE / MILESTONES 24 COST 24 TABLE 1— Development Cost 24 TABLE 1— 3rd Party Software Cost 25 TABLE 3 — Ongoing Maintenance Hourly Rate 25 CLIENT TESTIMONIALS 26 CLIENT REFERENCES 27 ADDENDUM 1 NFRMPO WEBSITE UPDATE KICKOFF MEETING AGENDA 28 ADDENDUM 2 — CERTIFICATE OF INSURANCE 29 IMEWC Page 3 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Friday, July 20 2007 City of Fort Collins Purchasing Division North Front Range Metropolitan Planning Organization 215 North Mason Street Floor 2 Fort Collins, Colorado 80524 Dear Ladies and Gentleman We are pleased to submit this proposal In response to your request for proposal (P1076) for the North Front Range Metropolitan Planning Organization website development project At Squarei we consistently meet project budgets and timelines and we encourage you to call our references we are very proud of our partnerships with our customers Squarei developers are all people people We listen One thing to note in our proposal is the timeline it projects the number of weeks to complete the project We could start working on your project as early as September 1" and estimate completion as early as the beginning of December Also we understand you will be receiving proposals offering very different approaches sometimes making comparison difficult Some may have lower cost estimates The solution suggested here is flexible and very scalable but can be adjusted if you desire Our proposal is intended to provide a cost estimate for a complete solution based on extensive experience This is an excellent opportunity for Squarei Technologies and we look forward to discussing our response with the evaluation team If you have any questions or if I can explain any aspect of the proposal please call 970 377 0077 We look forward to hearing from you Best Regards VJMA lsfo�� Kent Bejcek President kent@sauarei com 970 377-0077 Page 4 of 29 TECH NOLOGI ES NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Overview In response to your request, Squarei Technologies Inc submits this proposal The specification we are providing includes an initial application design and adheres to your specification, it will be necessary to meet with North Front Range Metropolitan Planning Organization (NFRMPO) staff to more fully define the requirements for the first phase of the project Squarei provides consulting services for the design, development and deployment of cost effective business applications Our services range from systems analysis to the complete development / deployment cycle Our major practice areas are three tier distributed Windows'" applications, database design, and interactive web applications We have the expertise and use time -tested methodologies and design guidelines to ensure the solutions we provide are maintainable, scalable, and delivered on time and budget Our Major Goals Are • Exceed the expectations and work items defined in the RFP • Re -develop the current NFRMPO website creating a dynamic and progressive design providing NFRMPO the ability to effectively present and manage their content • Gam a thorough understanding of the needs and wants of NFRMPO staff and website users affording Squarei staff the opportunity to affect real world, long term, positive outcomes related to NFRMPO systems and technologies • Deliver a robust content management using the Sitecore CMS as the underlying architecture • Develop a professional relationship with NFRMPO staff ensuring we understand and effectively communicate together • Complete a design that is reliable, scalable, and flexible allowing for future additions and ease of integration with other systems • Use standards based development and widely accepted development techniques This proposal calls for Project Development In this format Squarei works with the client to design the application and implement the system with a specified set of features and functionality These types of projects have three primary phases 1) Initial Scope, 2) Detail Design, and 3) Implementation Squarei estimates the development cost based on the initial scope, and then if necessary the detail design If the scope of the project does not significantly change and assumptions are accurate the initial cost projected Is normally very accurate IMMME Page 5 of 29 TECHNOLOGIES NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Company History Square) Technologies, Inc was founded in 1996 We provide cost effective, user friendly application and design solutions ranging from interactive Internet applications to database driven business process and Information tracking systems Our areas of expertise Include web application and content management systems, project management solutions, business process automation and database driven applications as well as e-business solutions, Flash websites, customized a mall generation, and customer service tracking to increase your revenues Our customer -centered approach, ability to listen and a wealth of experience in custom software development are what make us different We work with you to determine your needs, establish your goals and offer a strategy that is rooted in your unique business, not just technology Years of Industry experience allow us to Implement the best possible technology solutions as determined by your business requirements We believe that every project must begin with a total understanding of the project purpose and goals We develop software applications using Industry standard technologies, techniques and architecture, planning for future development and scalablllty as business needs dictate Location Fort Collins, Colorado — Headquarters 4025 Automation Way— D4 Fort Collins, CO 80525 Office 970-377-0077 Toll Free 888-SQUAREI Fax 970-377-8488 Website www squares com Qualifications Our staff has been designated as professionals in the field through certification and long term commitments to the technology community both locally and nationally We have renowned software architects on staff having developed over 40 highly complex systems in the past 11 years Page 6 of 29 pow C H N O L O G I E S NFRNIP0 Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Assigned Personnel Kent Bejcek — Director of Strategy With his vast knowledge of information architecture and usability and design practices Kent excels at creating applications that streamline business processes He has worked with organizations across many industries to aid in implementing the right technologies to meet the business needs Kent has extensive experience with content management implementations requirements definition and technical integrations Jim Pavek Interactive Strategist Jim is an experienced developer and user interface specialist Jim has experience creating and implementing user centric interfaces for the web and windows applications He excels at working with customers to identify the requirements of an application and creating a user interface that captures these requirements in a user friendly fashion Jim works on many web properties to provide an easy to use interface for end users Jeff Papp — Director of Technology Jeff serves as the lead developer and primary software architect on many of our projects by designing and implementing the backend processes of applications Jeff has experience with ASP Net and Windows forms development as well as service oriented architecture He excels In building an extensible and scalable foundation for projects using the latest technologies and software design methodologies Lindsey Taylor— Project Manager Lindsey combines her deep technological understanding, entrepreneurial spirit and innovative leadership to help clients succeed She excels in project organization and management Lindsey has experience in ASP Net and Windows Forms allowing her to oversee all aspects of the development life cycle She works with an open communication policy ensuring that stakeholders have the opportunity to express opinions or concerns Representative Clients Examples of our work can be found online at htto //www souarei com/CaseStudies asox Squarei has worked with more than 150 clients including Larimer County, Weld County O LT Colorado State University Libraries, Colorado State University College of Veterinary Medicine, Access Computer Products, City of Fort Collins, Colorado Custom Ware, Fort Collins Soccer Club, Kroll Factual Data. Rocky Mountain Wireless Scuba Schools International, BizByOwner com, Poudre Valley Health Systems, and Honeywell BEEZZE Page 7 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Project Management Tools and Process Squares Technologies believes that strong and effective project management is the key to successful projects We ve invested a lot into our project management staff tools and process to ensure that the deliverables are successfully delivered on time and on budget We have successfully managed projects across the country from Colorado to Boston All of our projects leverage the following project management tools and processes Dedicated Project Manager The NFRMPO will have a dedicated project manager who will serve as the single point of contact Project Status Reports All projects are managed through a single Microsoft Project file and status reports are sent to the entire team that clearly describe recent deliverables, upcoming activities as well as the status of both the timeline and budget Client Extranet All project communication and client deliverables are posted to a client extranet you can access 24 hours a day, 7 days a week The extranet organizes project communication phase by phase and provides you the ability to upload and share documents Online Issue Management System Our online Issue tracking system (SharePomt) keeps all high level project tasks, Issues and feedback organized SharePomt allows our clients to log Issues and requests that will be received by our internal development team SharePomt also allows for monitoring of progress of each Issue progresses from initial logging to resolution and closure State of the Art Web Conferencing Even though in -person meetings are important, for quick discussions and brainstorming sessions, we sometimes rely upon our online conferencing tool for quick project discussions The tool (GoToMeeting or GoToMyPC) allows for remote meetings file sharing, video, notes and online collaboration Project Methodology Square) Technologies is a strong believer in establishing a solid blueprint for each project based on research The following describes our strategic process for mid to large web development projects IMMMU Page 8 of 29 T E C H N O L O G I E S NFRMPO Request for Proposal P1076 WEBSITE UPDATE/SUPPORT NFRMPO 7/20/2007 Strategic Blueprint Requirements analysis focuses on obtaining the information necessary to develop the strategy for designing and developing new websites Following the project kickoff meeting, we meet with key stakeholders to define and outline the goals, objectives and success metrics for the new website Subsequent meetings will help define and plan the content and functionality requirements for the website This information is used as the foundation to plan the site architecture, measurement strategy and functional requirements of the site Objectives • Define how the project will support your objectives and goals • Specify the needs of your audiences including staff, constituents and partner organizations and departments • Define the content types needed in the content management system • Define and prioritize functionality • Define the attributes of each content type • Define the measurable success metrics of the project • Define the relationships between key content • Confirm the budget, timeline and scope Key Activities & Deliverables • Project Kickoff Meeting • Initiative Goals and Objectives Analysis Meetings • Discovery Meeting(s) • Content Inventory, Goals & Requirements • Project Plan IEMWC Page 9 of 29 TECH NOLOGI ES