Loading...
HomeMy WebLinkAboutGIS Consulting Services - Bowne Proposal 01/21/11PROPOSAL SUBMITTAL Town of Southold GIS CONSULTING SERVICES SUBMITTED JANUARY 21, 2011 TO: Bowne Management Systems, Inc. SUBMITTED BY:? Bowne Management Systems, Inc. January 21, 2011 Page: 2 PROPOSED SCOPE OF SERVICES BMS proposes the following scope of work to meet the Town’s requirements outlined in the Request for Quotation (RFQ). In accordance with the Town’s request, our proposal consists of three major tasks: 1. Setting up the GIS Software 2. Implement GIS Geodatabase 3. Load GIS Data into Geodatabase 4. Conduct GIS User Training 5. Application Development The following sections explain tasks and consulting firm’s responsibilities. Task 1 – Setting up the GIS Software Bowne will install, configure, and test ESRI’s ArcSDE Version 10 and Microsoft’s SQL Server 2008. Once ArcSDE is successfully installed, the appropriate SQL Server security roles will be implemented. It is assumed that the Town will have purchased both ESRI’s ArcSDE and Microsoft’s SQL Server software. Task 2 – Implement GIS Geodatabase Bowne will review and update the geodatabase design identified in the “GIS Needs Assessment” and implement the Geodatabase model’s structure within ArcSDE. The implementation will include required SQL Server security. Task 3 – Load GIS Data into Geodatabase Bowne will support the Town and Village in loading approximately 150 feature classes into ArcSDE. It is assumed that Bowne will not be responsible for editing any layers. Task 4 – Conduct GIS User Training Bowne will provide the following types of GIS training services: • Two (2) day on-site “ESRI Introduction to ArcGIS I Course”. Bowne will use an ESRI authorized trainer to conduct this class. It is assumed that all course materials (i.e., reference materials from ESRI) will be purchased by the Town. • Three (3) day on-site “ESRI Introduction to ArcGIS II Course”. Bowne will use an ESRI authorized trainer to conduct this class. It is assumed that all course materials (i.e., reference materials from ESRI) will be purchased by the Town. Bowne Management Systems, Inc. January 21, 2011 Page: 3 • Three (3) day on-site mentoring for the use and operation of ArcSDE within the Town’s current environment. The course should cover the following topics: o Configuring Microsoft SQL Server 2008 for ArcSDE o Training on Geodatabase Concepts o Loading Data o Managing Storage o Administrating ArcSDE and Microsoft SQL Server 2008 Task 5 – Application Development Using open source GIS technology from GeoServer and OpenScales, Bowne will develop a Rich Internet Application (RIA) web-based Land Records GIS Viewer that displays all basemap and land based GIS layers within the Town. These layers include, but are not limited to, parcels, zoning, wetlands, FEMA, street centerline, hamlet boundaries, fire district boundaries, school district boundaries, orthophotography, oblique imagery, and historical imagery. The GIS viewer should provide functionality that integrates with Google’s Street View and Bing Maps. Standard mapping functionality that includes zoom in, in, zoom out, zoom to full extent, pan, measure tools, identify and an overview map should be included as part of the application. Bowne will develop Extraction, Transformation and Load (ETL) routines within SQL Server 2008 (developed as SQL Server Integration Services or SSIS Packages) that will extract and transform data from Municity and RPS (the Town’s Land Management Systems) into the Town’s centralized spatial database management software. Bowne Management Systems, Inc. January 21, 2011 Page: 4 Relevant Experience and Qualifications Nassau County GIS In June of 1990 Bowne was designated as the County’s consultant for the design and implementation of a County-wide Geographic Information System. Bowne’s responsibilities and work tasks included: • Project Management and Oversight • User Needs Assessment: • Accelerated Basemap Development, Operation, and Support: • Aerial Photography and Photogrammetric Compilation: • Network Specification and Implementation: • Phase I Implementation and Acceptance Testing • Countywide Tax Mapping Bowne continues to be the County’s GIS Consultant offering application development services, training and upgrades to the GIS. Town of Riverhead GIS The Town of Riverhead engaged Bowne to prepare a Geographic Information System (GIS) User Needs Assessment as part of a New York State Local Government Records Management Improvement Fund (LGRMIF), formerly known as State Archives and Records Administration Grant in 2005. After conducting surveys and interviews with seventeen (17) Town Departments, Bowne analyzed the existing network infrastructure, identified application requirements and the needs of the departments. Following the analysis phase, Bowne prepared a Conceptual Design and an Implementation plan. The final report included a proposed strategy for an Enterprise GIS implementation along with our recommendations on the data, staffing, training, hardware and software, applications and associated cost schedule. By following the recommendations of the User Needs Assessment and Implementation Plan, the Town of Riverhead will have an opportunity to create a Town-wide GIS System that will allow the Village staff to serve spatial data to both internal and external users in a very effective manner taking advantage of the proposed enterprise GIS architecture. Town of East Greenbush GIS The Town of East Greenbush in Rensselaer County had developed a GIS User Needs Assessment in 2000. However, most of the suggestions made in the the GIS UNA have never been implemented due to the significant staff change in the Town and funding issues. The Town contracted with Bowne to conduct another GIS UNA, updating the existing GIS UNA study. Bowne delivered an educational seminar on GIS and conducted Departmental interviews as part of the study. Village of Lynbrook GIS User Needs Assessment and Implementation Plan The Village of Lynbrook engaged Bowne Management Systems, Inc. to prepare a Geographic Information System (GIS) User Needs Assessment as part of a New York State Local Government Records Management Improvement Fund (LGRMIF), formerly known as State Bowne Management Systems, Inc. January 21, 2011 Page: 5 Archives and Records Administration Grant in 2005. After conducting surveys and interviews with the Village Departments, Bowne analyzed the existing network infrastructure, identified application requirements and the needs of the departments. Following the analysis phase, Bowne prepared a Conceptual Design and an Implementation plan. The final report included a proposed strategy for an Enterprise GIS implementation along with our recommendations on the data, staffing, training, hardware and software, applications and associated cost schedule. By following the recommendations of the User Needs Assessment and Implementation Plan, the Village of Lynbrook will have an opportunity to create a village-wide GIS System that will allow the Village staff to serve spatial data to both internal and external users in a very effective manner taking advantage of the proposed enterprise GIS architecture. Town of Oyster Bay GIS Since 1987, Bowne Management Systems, Inc. has been the Town of Oyster Bay’s consultant for the design and implementation of a Town-wide Geographic Information System. Tasks have included project management and oversight, user needs assessment, database design and development, and wide area network specifications and implementation. Since implementing the Town-wide GIS, Bowne’s role transitioned to database maintenance, user support, user mentoring (knowledge transfer) and training, and application development. Currently, the Town has the latest suite of ESRI’s technologies including ArcSDE, ArcGIS and ArcIMS. Bowne has worked with the Town to develop a GIS Intranet portal page to provide access to various GIS Intranet Viewers for the Department of Public Works, the Receiver of Taxes, the Comptroller’s Office and the Department of Planning & Development. These Intranet GIS Viewers provide Town employees with valuable GIS related data that has been supplemented and linked with Town operational data including tax data, pavement condition data, and concrete condition data. Bowne continues to support the Town expansion of GIS through data collection and application development. Town of Eastchester GIS The Town of Eastchester, Westchester County, applied for and subsequently received funding for a GIS User Needs Assessment support by the New York State Education Department, Archives Program, Local Government Records Management Improvement Fund (LGRMIF). Following the NYS Archives LGRMIF guidelines for GIS, Bowne conducted departmental interviews with the Town’s subject matter experts and developed a needs assessment, conceptual GIS system design and implementation plan. One of the key findings of the study was that the Town needed to develop an Enterprise GIS in order to make spatial data and applications available to the Town staff and residents, while integrating its GIS with Westchester County’s to take advantage of the existing spatial data and services available through the County. The Town secured funding from the New York State Education Department, Department, Archives Program in the next round using the GIS Needs Assessment’s recommendations. The Town has implemented the proposed Enterprise GIS and pursued integration with the County. Bowne Management Systems, Inc. January 21, 2011 Page: 6 Cost Estimate Sheet Vendor Name: Bowne Management System, Inc. Contact : Scott Mastellon, Project Manager Address : 235 E. Jericho Tpke, Mineola, NY 11501 Phone (516) 746-2350 ext. 1406 Fax (516) 747-1396 Email smastellon@bownegroup.com TASK TOTAL HOURS TOTAL COST Task 1: Setting up the GIS Software 24 $2,500.00 Task 2: Implement Geodatabase 24 $2,500.00 Task 3: Load GIS Data into Geodatabse 32 $4,000.00 Task 4: Conducting GIS User Training 100 $13,000.00 Task 5: Application Development 140 $19,000.00 Totals 320 $41,000.00 Bowne Management Systems, Inc. January 21, 2011 Page: 7 COMPANY PROFILE Bowne is a leading integrator of IT and GIS. Since 1982, Bowne has been providing governmental and private sector clients with a broad range of information systems solutions. Bowne services include: • Geographic Information Systems and enterprise GIS • Geospatial data and metadata development • Web-based application development • Handheld computing and wireless applications • System architecture design and implementation • Systems and network integration • Asset management and field data collection • Constituent response and complaint tracking (“311”) • Management consulting and operations analysis • Records management • Staffing solutions Bowne, a certified Small Business Enterprise in the State of New York, is part of the Bowne AE&T Group, a solid and stable organization whose roots date back to 1895. Bowne Management Systems was created in 1982 to deliver quality Information Technology and GIS solutions to existing clients of its parent civil engineering company, Sidney B. Bowne & Son, LLP. Over time, the company has become one of the leading spatial information technology consulting firms in the Northeast U.S. Bowne services encompass full lifecycle consulting and management, ranging from needs assessment, requirements definition and system design through acquisition assistance, implementation, training and on-going support. A full-service IT consulting firm specializing in GIS, Bowne is one of ESRI’s premier Business Partners in the Northeast U.S. The firm offers full life cycle consulting for GIS implementation, web-based application development, and wireless and handheld solutions. Bowne’s permanent staff of over 50 GIS professionals includes certified Project Management Professionals (PMP), business analysts, application developers, and GIS analysts, specialists and technicians. An ESRI Business Partner since 1999, Bowne was named 2005 ESRI Foundation Partner. Bowne has extensive experience delivering GIS and related services. Applications and services developed by Bowne include Geodatabase design, parcel and property information management, land records management, spatial data warehousing, infrastructure asset management, business geographics, transportation modeling, global positioning systems (GPS), mobile GIS, cartographic transformations, field data collection, data conversion quality control and integration with legacy applications. Bowne Management Systems, Inc. January 21, 2011 Page: 8 PROJECT SCHEDULE To complete the five (5) tasks outlined as part of the Request for Quote (RFQ), Bowne will require a total of six (6) months. The following schedule illustrates which tasks will be completed within which month. Task Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Task 1 -Setting up the GIS Software X Task 2 -Implementing Geodatabase X Task 3 -Loading GIS Data X Task 4 -Conduct GIS User Training X Task 5 -Application Development X X X Bowne Management Systems, Inc. January 21, 2011 Page: 9 Project Team Scott Mastellon, Project Manager -Mr. Mastellon has managed major Information Technology projects since 1998. He has been responsible for the following project tasks: Records Management, Internet/Intranet development, Geographic Information Systems (GIS), business process engineering, database management, system integration, and computerized application development. Having been in the IT field since 1995, Mr. Mastellon has a wealth of experience with regard to user needs analysis, system design, workflow analysis, data conversion, imaging, and user support planning. James Hall, GISP, Senior Analyst – Mr. Hall is a senior analyst with over 20 years of experience in geographic information systems (GIS) and information technology (IT) projects. At the present time, his project work is focused on defining customer’s business requirements and developing appropriate designs with application, database and system components, as well as overall project management. Leland Bailey, GIS Analyst – Mr. Bailey has over 35 years of experience in GIS design, data development, and implementation. Since 2002, he has served as the GIS Services Group Leader, directing a staff of 20 professionals. Mr. Bailey has management responsibility for all Bowne services related to GIS design, data development and implementation, including the firm’s ESRI Solutions Group, and is intimately familiar with complex, large-scale GIS implementations (use of spatial database products, internet map servers, desktop GIS spatial analysis, mapping, editing, and Relational Database Security models). Ngoc Van Tran, Senior GIS Application Developer -Mr. Tran is a senior member of Bowne’s Application Development Group. He has been providing services in the areas of system analysis, application design and development and networking since 1998. His core expertise includes defining user requirements, system design, development and implementation. Mr. Tran has worked on many projects spanning from small, single-user databases to multi-user, web-based, Internet Information Servers (IIS), and client-server applications. Joseph Schecther, Senior GIS Analyst -Mr. Schechter’s experience with software includes integration of ArcIMS and ArcSDE utilizing IIS, Oracle 9iAS, Apache, and iPlanet web servers; installation and configuration of high availability ArcIMS using Microsoft’s Network Load Balancing in a Microsoft Windows 2000 cluster; installation and configuration of ArcSDE and MS SQL Server 2000/Oracle Server using failover clustering in a Microsoft Windows 2000 clustered configuration; complex integration of ArcSDE raster databases with pictometry imagery; and configuration and implementation of geodatabase security models in MS SQL Server 2000 and Oracle Server. Mr. Schechter’s technical support of software packages includes Environmental Systems Research Institute’s (ESRI) geographic information system programs ArcSDE, ArcView, ARC/INFO, ArcMap. ArcEdit, and ArcIMS in both the Windows and UNIX environments, and relational database management systems like MS SQL Server and Oracle. He was previously Project Manager of software design for environmental health report generation and statistical data management. Bowne Management Systems, Inc. January 21, 2011 Page: 10 Kristine Blanco, GIS Analyst – Ms. Blanco is a member of Bowne’s GIS Group sand is a skilled GIS analyst and trainer. She also serves the role of project manager, meeting with the customer, managing budgets and ensuring successful project delivery. Ms. Blanco is fluent in desktop GIS and spatial database technology and is an ESRI-authorized ArcGIS trainer (one of the few authorized ArcGIS II trainers in the NYC Metro area). Robert Nossa, GIS Analyst -Mr. Nossa is a member of Bowne’s GIS Group and is experienced in both the design and support of complex IT/GIS environments. Mr. Nossa regularly provides support and mentoring to Bowne’s customer base. He is adept at both desktop GIS issues and the design of server side GIS components. Mr. Nossa is also an ESRI Authorized ArcView, ArcGIS Instructor. Resumes for our project staff appear on the following pages. Mastellon resume Page 1 Bowne Management Systems, Inc. Scott T. Mastellon Project Manager SUMMARY OF PROFESSIONAL LIFE Mr. Mastellon has managed major Information Technology projects since 1998. He has been responsible for the following project tasks: Records Management, Internet/Intranet development, Geographic Information Systems (GIS), business process engineering, database management, system integration, and computerized application development. Having been in the IT field since 1995, Mr. Mastellon has a wealth of experience with regard to user needs analysis, system design, workflow analysis, data conversion, imaging, and user support planning. CURRENT PROFESSIONAL SKILLS Development • SQL GIS Environment • ArcGIS Suite (ArcView, ArcEditor, ArcInfo,) 9.x • ArcSDE 9.x • ArcIMS • ArcGIS Server • MapInfo Professional • AutoCAD/Autodesk Map RDBMS • Microsoft Access • SQL Server 2000/2005 • Oracle 8i, 9i, 10g Hosting Environments • IIS • Apache/Tomcat Operating Systems • Windows 2003 Server Family, XP, NT • • Sun Solaris Document Imaging • FileNET (Panagon IDM) • Hyland (Onbase) • Plexus (Image First Office) • Captaris (Alchemy) • Laserfiche (Laserfiche) • IBM (Image Plus) Structured Analysis/Design • Microsoft Visio • Describe • Enterprise Architect • UML Office Automation • Microsoft Office Suite, including Project • Crystal Reports REPRESENTATIVE ASSIGNMENTS: Mastellon resume Page 2 Bowne Management Systems, Inc. Town of Babylon Drainage Digitization Project, Project Manager – Mr. Mastellon was the project manager for this project where Bowne digitized a total of 53 paper drainage maps for the Department of Public Works. Paper maps were geo-referenced and drainage structures were digitized for the entire Town. Mr. Mastellon worked directly with the Town’s IT personnel, GIS personnel, and DEC personnel to effectively manage task activities, communications, and overall deliverables. Southampton Operational Efficiency Opportunity Project, Analyst – Mr. Mastellon was an analyst for this project where Bowne provided management consulting services to the Town of Southampton in an effort to identify operational efficiency opportunities within Land Management and Code Enforcement. As part of this study, Information Technology was evaluated and Mr. Mastellon provided technology recommendations to support operational efficiencies. Suffolk County DRIVE Maintenance Support, Support, Project Manager – Mr. Mastellon was the project manager responsible for this project where Bowne setup and configured a development and test server environment that was synchronized with software installed in the County’s production environment for DRIVE. Parents for Megan’s Law Content Management System and Offender Mapping, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne provided oversight consulting to support the implementation of an open source content management system (OpenCMS) to support the organization’s website needs. In addition, Mr. Mastellon was the Lead Analyst and Project Manager responsible for implementing a Google mapping interface to support the geocoding and mapping of registered sexual offenders located in New York State. (4/06-1/09) Town of Islip Department of Planning & Development GIS Implementation, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne worked with the Town’s GIS and Information Technology ((IT) resources to design, configure, and implement ESRI’s ArcSDE product within Microsoft SQL Server 2000. Bowne services enabled the Town to efficiently implement a scalable enterprise GIS solution. In addition, Bowne provided mentoring services for data collection using ArcPad, advanced editing using ArcGIS, customization for ArcIMS, and integration with legacy mainframe data using ViaSQL. (12/05 – 3/08) Town of Hempstead Building Department Mobile Inspection System, Project Manager – Mr. Mastellon was the Project Manager and Lead Analyst for this project where Bowne developed a mobile application for the Town’s Building Department inspectors to record inspection results in the field. The mobile application developed utilized GPS technologies to ensure inspection results were only records when the inspector was within 500 feet of the resident’s location. The mobile application was deployed on a ruggedized laptop. (10/07-3/08). Town of Babylon 3-1-1 Constituent Response System, Project Manager – Mr. Mastellon was the Project Manager and Analyst for Bowne’s design and implementation of the Town’s Constituent Response system (CRS). As Project Manager and Analyst, he was instrumental in the design of a new constituent services function, along with the necessary structure of policies, procedures and operations for interacting with constituents, delivering services, monitoring performance and effecting positive change. Mr. Mastellon was a key participant in analyzing issues and requirements, scoping the CRS, assessing the state of current technology and operations in the Town related to the CRS, defining the technical components and operational model, selecting technology vendors, developing implementation plans and implementing an operational CRS system and call center. (2008) Mastellon resume Page 3 Bowne Management Systems, Inc. United Way of Long Island 2-1-1 System, Project Manager -Mr. Mastellon was the Project Manager for this project where Bowne worked with the United Way of Long Island to develop a multi-jurisdictional model, including a feasibility study, implementation plan and call center concept, for a 211 Human Services and Emergency Hot Line capability. The project team collaboratively worked with a number of municipal and not-for-profit organizations to develop a plan that leverages all available local operational resources as well as larger funding sources like New York State and the Federal Government. The project involved a host of operational, technological and logistical issues reaching across municipalities in both Nassau and Suffolk Counties. (2008) Town of Riverhead, GIS Viewer Implementation, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne developed and installed a Town-wide GIS Viewer for the Town using ArcGIS Server. ((2008). Suffolk County Department of Information Technology GIS User Needs Assessment, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne conducted a GIS User Needs Assessment (UNA) for Suffolk County. Bowne conducted surveys and interviews with sixty-one (61) County Departments and Divisions. Bowne analyzed the existing network infrastructure, identified application requirements and the needs of the departments. Following the analysis phase, Bowne prepared a Conceptual GIS Design and an Implementation Plan. The final report included a proposed strategy for an Enterprise GIS implementation along with our recommendations on the data, staffing, training, hardware, software, custom applications and associated cost schedule. (2007) Town of Riverhead Enterprise GIS Implementation, Project Manager – Mr. Mastellon was the project manager on this project where Bowne implemented an enterprise GIS within the Town of Riverhead. The implementation followed the plan outlined in the GIS User Needs Assessment (UNA) developed in the previous year. The project included the implementation of an enterprise geodatabase with ArcSDE and the installation ArcGIS Server to support further GIS applications within the Town. (6/07 – 12/07). Town of Brookhaven 3-1-1 Constituent Response System, Project Manager – Mr. Mastellon was the Project Manager and Analyst for Bowne’s design and implementation of the Town’s Constituent Response system (CRS). As Project Manager and Analyst, he was instrumental in the design of a new constituent services function, along with the necessary structure of policies, procedures and operations for interacting with constituents, delivering services, monitoring performance and effecting positive change. Mr. Mastellon was a key participant in analyzing issues and requirements, scoping the CRS, assessing the state of current technology and operations in the Town related to the CRS, defining the technical components and operational model, selecting technology vendors, developing implementation plans and implementing an operational CRS system and call center. (2006-2008) Town of Oyster Bay,Human Resources Information Technology Management Consulting, Project Manager – Mr. Mastellon was the Project Manager and Lead Analyst of this project where Bowne conducted an assessment of the Town’s Information Technology (IT) environment. The assessment addressed the Town’s internal IT support, local and wide area networks, servers and hosts, maintenance contracts, application software environment, geographic information systems, records management, email environment, web components and hosting, disaster recovery, IT security and telecommunications. Based upon the assessment findings, Bowne was contracted to design and implement a central Information Technology function to replace independent departmental silos of computing. Working with TOB executive level personnel, Bowne developed a two-year strategic plan for IT which included budgetary requirements and an infrastructure standardization and realignment project plan. To assist the Mastellon resume Page 4 Bowne Management Systems, Inc. Town in executing this plan, BMS provided a part-time Chief Information Officer (CIO) and a full-time PC Operations Manager, which gave leadership to the effort and markedly improved the functioning of the IT unit (2005-2007) Town of Riverhead GIS Needs Assessment, Project Manager – Mr. Mastellon was the project manager and lead analyst for this project. Bowne worked with the Town of Riverhead, NY to develop a GIS User Needs Assessment (UNA). Mr. Mastellon led the Bowne team as a GIS Analyst, conducting the UNA related surveys, interviews and writing the technical report that includes a conceptual design and implementation plan. (9/05 – 6/06) New York City Department of Historic Preservation and Development (HPD) Lead Inspection Routing, Lead Analyst – Mr. Mastellon was the lead analyst for Bowne’s design of a scheduling and routing solution for the Department’s code enforcement inspectors. As lead analyst, he was responsible for the analysis of existing inspection data and the design of a customized scheduling solution. In addition, Mr. Mastellon worked closely with RouteSmart Technologies, a sister company at the Bowne AE&T Group, to determine the most effective integration of RouteSmart for ArcGIS into the overall scheduling and routing solution for the Department. (10/04 – 1/06) Suffolk County Office of Consumer Affairs Web Application, Project Manager – Mr. Mastellon was the Project Manager for this project, where Bowne built an enterprise Intranet application that combined functionality previously contained in over 25 various applications into one single Oracle database. Mr. Mastellon was instrumental in Bowne’s efforts, which converted data contained in over 75 database tables and developed over 25 Data Transformation Service (DTS) Packages within SQL Server to convert, clean and standardize the data sources. The application, currently used by the Licensing Bureau, Complaint Bureau, and Weight and Measures Bureau has resulted in improved department communications, increased reporting capabilities and decreased overall workflow inefficiencies. (5/05 – 6/07) Town of Babylon Land Records Viewer and Property Photo Integration System, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne developed an enterprise Land Records GIS Viewer for the Town. The Town of Babylon received a Real Property Tax Administration Improvement Program (RPTAIP) grant from the New York State Office of Real Property Services (ORPS) in 2007 to improve the efficiency of obtaining property related information and cost effectiveness of the various Town related activities that require access to the property related information. The project used GIS and GPS technology to obtain street level digital photographs of over 70,000 parcels within the Town. GPS data was collected using GPS enabled digital cameras and assigned to parcel tax map numbers using customized ArcGIS scripts. To efficiently distribute photographers in the field, a GIS enabled route optimization software product (RouteSmart for ArcGIS) was used to create and optimize routes for each photographer throughout the project. All routes, photos and GPS coordinates were effectively stored in the Town's GIS data warehouse. An existing ArcIMS GIS Viewer used for displaying basic assessment information was enhanced by Bowne to include property card data, links to property card images, links to street level photographs, links to property sketches, sales comparison search capabilities, assessment comparison search capabilities, tax related information, and sales information.(2008-2009) New York City Department of Environmental Protection Water Meter Inspection Routing, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne implemented a pilot implementation of an information technology solution that would generate efficient routes for the Bureau’s inspectors using RouteSmart for ArcGIS® software. The pilot focused on supporting Queens Dispatcher Mastellon resume Page 5 Bowne Management Systems, Inc. and the thirteen inspectors assigned to the borough. The project yielded a solution for BCS that would reduce the amount of time required to create daily inspection routes, improve customer service by enabling improved appointment scheduling, support appointment time windows, and efficiently insert “filler work” into daily inspector routes using both geographic and operations parameters. (2007) Town of Babylon Information Technologies GIS Support, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne worked with the GIS Technical Committee and Information Technology Steering Committee to develop and implement an enterprise GIS for the Town. Mr. Mastellon provided technical guidance and direction to the Town’s GIS initiatives to expand the use of and integration of GIS within all Town Departments. Mr. Mastellon has provided continual project management support and technical direction for GIS initiatives for the Town through through the current date. (1/06 – Current) Town of Oyster Bay Comptroller’s Office GIS Support, Project Manager – Mr. Mastellon was the Project Manager for this project where Bowne worked with the GIS Technical Committee and Information Technology Steering Committee to develop a GIS action plan for 2006. This 2006 GIS action plan was adopted by the Steering Committee and was used in 2006 to guide the direction of the Town’s GIS initiatives to expand the use of and integration of GIS within all Town Departments. Mr. Mastellon has provided continual project management support and technical direction for GIS initiatives for the Town through the current date. (1/06 – Current) New York State Department of Motor Vehicles Accident Location Information System (ALIS), Project Manager – Mr. Mastellon was responsible for the technical direction of programming resources to develop five custom client modules for Location Coding Data Entry (LCDE), Location Editing (LE), Simple Query and Reporting (SQR), Map Maintenance Notification and Tracking (MMNT), and Street Name Editor (SNE). He was also responsible for developing a Unified Modeling Language (UML) model for two of the five modules. (7/01 – 12/05) New York City Department of Parks and Recreation Forestry Management System, Project Manager – Mr. Mastellon was the Project Manager for this project, where Bowne developed a public website for constituents to enter forestry related complaints via the Internet. The public website interfaces with New York City GeoSupport and Azteca’s Forestry Management System (ForMS). Mr. Mastellon was the lead analyst on the system design and was also responsible for the technical direction of programming and GIS resources. (3/05 – 1/09) Town of North Hempstead 3-1-1 Constituent Response System, Lead Analyst – Mr. Mastellon was the Lead Analyst for Bowne’s design and implementation of the Town’s Constituent Response system (CRS). As Lead Analyst, he was instrumental in the design of a new constituent services function, along with the necessary structure of policies, procedures and operations for interacting with constituents, delivering services, monitoring performance and effecting positive change. Mr. Mastellon was a key participant in analyzing issues and requirements, scoping the CRS, assessing the state of current technology and operations in the Town related to the CRS, defining the technical components and operational model, selecting technology vendors, developing implementation plans and implementing an operational CRS system and call center. (4/06 – 6/07) Dow Jones WebGIS System, Project Manager – Mr. Mastellon was the Project Manager for this project, where Bowne built a web based customer marketing geographic information system called WebGIS. Mr. Mastellon was the lead analyst on the system design and was also responsible for the technical direction Mastellon resume Page 6 Bowne Management Systems, Inc. of programming and GIS resources. The system enables circulation teams across the Country with the ability to visually review subscriber distribution patterns to maximize service and efficiency. The system is extremely large and contains millions of customer records and a nationwide street centerline file that contains over 72 million records. As part of his activities, Mr. Mastellon worked with the Dow Jones IT Department to ensure that WebGIS met Dow Jones requirements for Sarbanes-Oxley disclosure. (11/04 – 8/05) New York City Housing and Neighborhood Information System (NYCHANIS), Project Manager – Mr. Mastellon was responsible for the technical direction of programming and GIS resources to develop an interactive, Internet-based GIS application. This website is an online information system based on data presented in the "State of New York City’s Housing and Neighborhoods" annual report. Mr. Mastellon was also responsible for developing a Unified Modeling Language (UML) model for all system modules. (New York University of Law). (3/03 – 12/03) United States Army Corps of Engineering Survey Information Management System (SIMS), Project Manager – Mr. Mastellon was responsible for the technical direction of programming resources to develop a custom web-based workflow management application for the Survey Division of the North Atlantic Division. He was also responsible for the analysis of the existing paper-based business process. This analysis was used to re-engineer the existing process with the automated information management system. (7/01 – 12/02) United States Army Corps of Engineering Integrated Spatial Data System, Project Manager – Mr. Mastellon was responsible for the technical direction of programming resources to develop a custom webbased workflow management application for the Operations Division of the North Atlantic Division He was also responsible for the analysis of the existing paper-based business process. This analysis was used to re-engineer the existing process with the automated information management system. (10/01 – 1/04) County of Tioga Department of Social Services Job Point Program, Project Manager – Mr. Mastellon was responsible for the technical direction of programming resources to develop a custom web-based application to provide driving and walking directions to Temporary Assistance for Needy Family (TANF) clients in Tioga County. The web-based application was built using ESRI’s RouteMAP IMS software as the spatial engine. (4/01 – 12/02) City of New Orleans Department of Public Works, System Analyst – Mr. Mastellon was responsible for integrating a third party asset management system using a workflow analysis. He re-engineered the Traffic, Abandoned Vehicle, and Maintenance Divisions of the Public Works Department after becoming thoroughly familiar with the third party asset management system, CASSWORKS, developed by RJN Group, Inc., in order to provide on-site support for end-users on an as-needed basis. Town of Oyster Bay Planning & Development Department, Project Manager – Mr. Mastellon was responsible for the technical direction of programming resources to maintain custom applications within the Planning Department; Building Permit System, Code Compliance System, and Site Planning System. Town of Oyster Bay Highway Division, Project Manager/System Analyst – Mr. Mastellon was responsible for the development of a custom road evaluation rating system module. Work items included the development of user requirements, database design, system design, system testing, application installation, user training, and user documentation. (4/02 – 4/03) Mastellon resume Page 7 Bowne Management Systems, Inc. Long Island Rail Road Engineering Department Mechanized Reporting System, System Analyst – Mr. Mastellon was responsible for the development of a custom Mechanized Reporting System for the Track Division. Work items included the development of user requirements, database design, system testing, application installation, user training, and user documentation. (6/01 – 6/02) Long Island Rail Road MIS Department FileNET, Systems Analyst – Mr. Mastellon was responsible for implementing FileNET imaging to new departments. Work items included needs assessment, project timeline, workflow analysis, system requirements, design and implementation. (5/01 – 9/02) Town of Oyster Bay Department of Intergovernmental Affairs Computer Support, Project Manager/Systems Analyst – Mr. Mastellon was responsible for overseeing network support and programming services required by the Department. These services included PC installations, PC upgrades, PC moves, design and implementation of Intranet system used by all partner agencies, maintenance of existing software applications, and the maintenance of state regulated reporting requirements. (4/98 – 2/00) ACADEMIC BACKGROUND B.A. /Mathematics /State University of New York at Oswego /1993 LICENSES AND CERTIFICATIONS Certificate in Project Management and Implementation (CPMI) /Hofstra University /1/1/2003 Certified Scrum Master (Danube) /ScrumAlliance/12/3/2009 PUBLICATIONS AND PRESENTATIONS Integrated Spatial Data System (ISDS), A Work Management Solution. With Ray Elmore. Presented at the 2002 CADD/GIS Symposium Conference (San Antonio, TX, 2002) Web Based GIS Application Helps Unemployed Families. Presented at the 2003 Annual Geographic Information System/Special Interest Group (GIS/SIG) Spatial/Digital Mapping Conference (Rochester, NY, 2003) New York City Housing and Neighborhood Information System. Presented at the 2003 Annual New York State Geographic Information System (GIS) Conference (Albany, NY, 2003) Interactive Bathing Beach Advisory Website. Presented at the 2007 Annual New York State Geographic Information System (GIS) Conference (Syracuse, NY 2007) 3-1-1 and 2-1-1 Systems, Discover the Benefits and How it Impacts Your Organization. Presented at the 2006 1st Annual Long Island Government Technology Expo (Long Island, NY 2006) 3-1-1 and 2-1-1 Systems, A Case Study for the Town of Brookhaven. Presented at the 2007 2nd Annual Long Island Government Technology Expo (Long Island, NY 2007) Improved Efficiencies in Government using GIS & GPS Technologies. Presented at the 2008 Annual New York State Geographic Information Systems (GIS) Conference (Albany, NY 2008) Spatial Real Property and Assessment Information Systems. Presented with Girk Cakmak. Presented at the 2009 Spring NEARC Conference (MA, 2009) Mastellon resume Page 8 Bowne Management Systems, Inc. Using Parcel data and GIS in the Planning and Zoning Process. Presented at the 2010 Planning and Zoning Summer Schools in Albany, Binghamton, Geneseo and Middletown. The Association of Towns of the State of New York (NY, 2010). Hall resume Page 1 Bowne Management Systems, Inc. James Hall, GISP Senior Analyst III SUMMARY OF PROFESSIONAL LIFE: Mr. Hall is a senior analyst with over 20 years of experience in geographic information systems (GIS) and information technology (IT) projects. At the present time, his project work is focused on defining customer’s business requirements and developing appropriate designs with application, database and system components, as well as overall project management. Prior to joining Bowne, Mr. Hall managed small and medium sized GIS and IT projects and also a variety of large, multi-year consulting and/or implementation projects for major municipalities and other governmental agencies in the U.S. and abroad. CURRENT PROFESSIONAL SKILLS: Development • SQL,VBA, HTML, ASP, XML, CSS GIS Environment • ArcGIS Suite (ArcView, ArcEditor, ArcInfo, ArcSDE, ArcIMS, ArcGIS Server) • MapInfo Professional, MapXtreme • AutoCAD, Autodesk Map • Microstation, IGDS • GeoMedia, GeoMedia WebMap • RouteSmart • Terramodel • Kork KDMS • Maptitude RDBMS • SQL Server • Microsoft Access • Oracle • MySQL Hosting Environments • Apache/Tomcat • IIS Operating Systems • Windows Server, XP, 2000, Vista • UNIX incl. Solaris, HP-UX, AIX Structured Analysis/Design • Microsoft Visio • Embarcadero ERStudio • Design IDEF Office Automation • Microsoft Office Suite, including Project REPRESENTITVE ASSIGNMENTS: Hall resume Page 2 Bowne Management Systems, Inc. New York City EDC Waterfront Management Project, Senior Analyst – Mr. Hall worked on a multicompany project team that designed and implemented a custom relational data model to manage information about waterfront sites, facilities, systems and components. Data was migrated from a legacy database and over a dozen other digital and hardcopy sources. A custom Web application was developed to support both data access and maintenance. Technologies used: .Net 2.0/3.5, SQL Server 2008, ArcGIS Server 9.3, Wind Image, 3rd party .Net controls (11/2008 – 3/2010). New York City EDC, Business Continuity Planning and Disaster Recovery Implementation, Project Manager/Senior Analyst – Mr. Hall led a multi-discipline team that assessed EDC’s business continuity needs and then designed and implemented an appropriate information systems architecture at two corporate facilities. This project also involved porting the organization’s existing GIS servers to a mix of new hardware and virtual machines. Technologies used: Windows Server 2008, SQL Server 2008, ESRI suite (incl. ArcGIS Server, ArcIMS, ArcGIS Image Server), Symantec suite (11/2009 – 5/2010). Town of East Greenbush Custom GIS Application Development, Senior Analyst – Mr. Hall designed and oversaw the implementation of custom workflows for the quick and efficient mapping of fire hydrants, water customers and building permits. He also designed a Web application module that allows Town staff to identify residents impacted by water main outages, proposed zoning variances or other proximitybased actions and generate mass mailings, in an automated manner. Technologies used: ArcIMS, ArcGIS Desktop, Microsoft Access, .Net 2.0/3.5, Google Maps API (2/2010 -present). Liro Engineers and the Lower Manhattan Construction Command Center, Project Manager/Senior Analyst – In 2006 Bowne created an internet GIS web application called the Interactive Projects Map (IPM) using ESRI’s ArcIMS technology. The application displays capital projects projects in Lower Manhattan and the data displayed has been updated weekly for over three years. In early 2010 Bowne created an alternate version of the same web application using the Google Maps and Google Earth APIs. For both projects, Mr. Hall designed the website, processed data, coordinated with the customer and involved third parties while also managing the projects. Technologies used: Google Maps, Google Earth, .Net 2.0/3.5, ArcIMS (11/2006 – 12/2006 and 2/2010). New York City Department of Housing Preservation and Development Enterprise Metadata Project, Project Manager and Lead Analyst – Project involved design and implementation of a custom metadata service oriented architecture (SOA) solution that includes a custom metadata application profile, custom relational database, custom Web application and a SOAP compliant Web service. Project involved review and synthesis of several metadata standards (FGDC DCSDGM, ISO 19115, Dublin Core) and HPDspecific elements. Mr. Hall led the initial needs analysis analysis and design of the solution (database, Web application, Web service), processed metadata, conducted testing and coordinated with the customer while also managing the project. Technologies used: Oracle 10g, .Net 2.0/3.5, 3rd party .Net controls (2/2009 – 7/2009). New York City Citywide Street Centerline Project (CSCL) Phase II, Senior Analyst – Mr. Hall led the compilation and revising of the four following project documents: CSCL Phase 2 Quality Plan, Transit Data Migration and Conversion Rules, Water Features Data Migration and Conversion Rules and Milepost and Reference Markers Data Migration and Conversion Rules (6/2007 – 6/2009). New York City Department of Housing Preservation and Development GIS Strategic Planning and Migration Project, Project Manager and Lead Analyst – Mr. Hall was the primary author of the plan for migrating HPD’s GIS to ESRI’s latest product line including ArcGIS Server. Bowne compiled the GIS Hall resume Page 3 Bowne Management Systems, Inc. Infrastructure, Assessment, Findings and Recommendations Report for HPD. Bowne also installed and configured all server-side software including the HPD’s new enterprise GIS database (2/2008 – 8/2008). Nassau County GIS Extranet Project, Senior Analyst – Mr. Hall was the lead analyst for the design for the County’s GIS extranet and the supporting HTTP and SOA applications and services architecture (12/2007 -5/2008). Westchester County GIS Program, Project Manager – Bowne provides a range of technical support services to the County including custom application development and systems administration and troubleshooting. The County’s infrastructure is ESRI ArcGIS Server/ArcIMS and Oracle-based and custom application development is done with .Net. Mr. Hall’s role consists of strategic planning and associated implementation tasks and working cooperatively with other vendors (6/2005 -present). Town of Greenburgh, New York, GIS Services, Project Manager – Bowne enhanced the Town’s custom GIS website by enhancing the user interface and updating the Town’s existing web map services. Mr. Hall now provides as-needed GIS technical support and training. Technologies: MySQL, Java, ArcIMS (10/2007 – present). Suffolk County GIS Master Planning Project, Senior Analyst – Mr. Hall participated in over 20 needs assessment interviews and led the analysis of the information collected and the compilation of a 600+ page GIS Master Plan that was delivered to the County Executive. The Plan documented hundreds of specific recommendations for advancing the County’s existing GIS applications, data, systems and organizational infrastructure and staffing resources (12/2006 – 6/2007). Fire Department New York, Emergency Communications Transformation Project (ECTP), Project Manager -As part of the City’s Emergency Communications Transformation Project, Mr. Hall helped develop the geographic data requirements and data solution for the EMSCAD system. This work is being done as part of a subcontract to Hewlett Packard and the technical environment included ArcGIS 9.x and ArcSDE 9.x (6/2005-12/2005) Publishers Circulation Fulfillment (PCF), Geographic Router Deployment, Project Manager – PCF delivers numerous newspapers including the New York Times and Wall Street Journal. This project centered around the specification and development of an internet-available web service (“Geographic Router Service”) that is being used by PCF to determine whether they can deliver a publication to an address. The SOAP web service developed handles both transactional and batch processing requests and accepts and returns XML. Mr. Hall worked with Bowne and RouteSmart staff to complete the solution design while managing the project. (8/2005-12/2005) City of Alexandria, Louisiana GIS Needs Assessment and Implementation Planning, Senior Analyst – Mr. Hall compiled key sections of the GIS Needs Assessment and Implementation Plan including defining needs and documenting recommended solutions to address geographic data, applications, systems infrastructure and organizational and staffing needs (7/2005-9/2005). PRIOR EXPERIENCE: In a prior position with PlanGraphics (1994-2005), Mr. Hall managed and worked on a wide range of project for customers in the New York City area including the following: New York City Department of Information Technology and Telecommunications -Mr. Hall was the Project Manager for the company’s GIS Utility project for the New York City Department of Information Hall resume Page 4 Bowne Management Systems, Inc. Technology and Telecommunications (DoITT) between 2000 and 2002. In this role Mr. Hall managed the efforts of six on-site analysts and more than a dozen off-site specialists in the implementation of a citywide GIS utility. Key project activities included: • Client/Server and web-based application development for over half a dozen City departments, including DoITT, the NYPD, the Department of Design and Construction, the Mayor’s Office of Emergency Management and the Economic Development Corporation. • Completion of GIS needs assessments and/or strategic plans for several City agencies, including the NYC Department of Housing Preservation and Development, the NYC Department of Design and Construction, the NYC Department of Finance, the NYC Office of Management and Budget and the NYC Mayor’s Office of Emergency Management. • Development of data sharing agreements with New York State and local utility companies (including Consolidated Edison and Empire City Subway). • Mapping of 80+ historic districts and 1,000+ landmarks for the New York City Landmarks Preservation Commission. • Study of the feasibility of using GIS to support the City’s One-Call system. • Specialized training and technology transfer. • Mobilization to quickly and effectively staff the Emergency Mapping and Data Center within the City’s Emergency Operations Center on 9/12/2001 and through the end of January 2002. Involved working with other consultants, City staff, and volunteers to process more than 2,600 requests for products or information from more than 70 organizations. New York City Economic Development Corporation -Three back-to-back projects were completed that involved developing and enhancing a custom GIS web application (“PropertyInfo”) with MapXtreme and MapMarker and the specification and configuration of the software and data components of NYCEDC’s first dedicated GIS database server running ArcSDE with SQL Server. New York City Department of Correction -Development of a XML specification for an address normalization and geo-coding Web service. Included integration with both City’s primary geocoder (Geosupport) and a USPS CASS compliance solution in an integrated set of SOAP Web services. Township of Morris, New Jersey -Compilation of a GIS Needs Assessment and Strategic Implementation Plan for the Township and the design and implementation of GIS datasets and a custom GIS website. New York City Department of Environmental Protection’s Bureau of Water and Sewer Operations -Management project to procure, install and configure four GIS servers and software. Personally installed and configured Windows, JRE, Oracle, JRUN and Visual Studio .NET. New York City Department of Information Technology and Telecommunications – Mr. Hall developed the project plan and requirements for the geo-processing (“Geo311”) component of the City’s 3-1-1 CRM system. New York City Department of Environmental Protection’s Division of Emergency Response and Technical Assessment -Managed project to deploy of facility inspection and chemical inventory databases on Hall resume Page 5 Bowne Management Systems, Inc. Toughbook computers for field use and assistance with software selection for the City’s Right To Know program. New York City Department of Environmental Protection’s Bureau of Water and Sewer Operations -Developed database designs for document indexes for the Bureau’s scanned drainage plans and tap cards New York State Office for Cyber Security and Critical Infrastructure Coordination – Worked with CSCIS to evaluate the SDSFIE standard and compiled a Critical Infrastructure Management Plan Department of Sanitation, New York -In cooperation with RouteSmart Technologies, developed a pilot routing database and application to optimize garbage truck routing for the most southern Sanitation District in Staten Island. Department of Sanitation, New York -Integrated Geosupport into the call taker screens for the Department’s complaint system (ACCS) and taught DSNY staff to geocode and generate maps of the data extracted from ACCS. Water and Waste Department, City of Winnipeg, Manitoba, Canada -Mr. Hall performed a thorough technical review and testing of Intergraph’s GeoMedia PublicWorks software package prior to the first commercial release. Other projects that Mr. Hall managed or worked on while with PlanGraphics included: • Custom GIS application and database development for the City of Lynchburg, Virginia • Compilation of a property mapping RFP for Berkeley County, West Virginia • Revision of the City’s GIS Master Plan for Roanoke, Virginia • Compilation of a GIS situation assessment and action plan for Kent County, Delaware • Custom GIS application and database development for Horry County, South Carolina • Custom GIS application development for Madison Metropolitan Sewerage District, Wisconsin • Compilation of a GIS needs assessment and implementation plan for the NYC Department of Environmental Protection • Strategic GIS and AM/FM planning and custom application and database development for the Jacksonville (Florida) Department of Public Works and the Jacksonville Electric Authority • Compilation of an existing GIS environment review, needs assessment and implementation plan for the City of Largo, Florida • Compilation of a RFP and assistance with the selection of a contractor for field data collection for the Gainesville (Florida) Regional Utilities • Compilation of a property mapping database design for Montgomery County, Pennsylvania • Compilation of a phased GIS system design for Greenville (North Carolina) Utilities • Development of a property mapping database design and conversion procedures for Luzerne County, Pennsylvania • Modernization of the map production, GIS, DBMS and contractor oversight capabilities of the National Survey Authority of the Sultanate of Oman Hall resume Page 6 Bowne Management Systems, Inc. Prior to working for PlanGraphics, Mr. Hall served as the Digital Mapping/GIS Department Manager for Air Survey Corporation (1989-1994). Responsible for managing the day-to-day activity of seven operators involved in the production of large-scale topographic maps, GIS databases, digital terrain models, volumetric studies, and digital orthophotos. Me. Hall also personally did all the company’s ArcInfo and UNIX work and as-needed programming in shell scripts, awk, sed, UCM, AutoLISP and FORTRAN. Projects worked on there included: • Quarterly landfill mapping and volumetric studies for Loudoun County, Virginia • Countywide flood plain mapping for Whatcom County, Washington. • Civil engineering road mapping for over 35 miles of U.S. Route 58, Virginia. • Photogrammetric basemapping of Charlottesville, Virginia. • Custom GIS application and data development for Prince William Institute, Virginia. • Countywide photogrammetric basemapping for E911 system for Hanover County, Virginia • Custom GIS application and data development for Stafford County, Virginia. • Countywide photogrammetric basemapping for Guilford County, North Carolina. • Field surveying and mapping of both Reagan National and Dulles Airports for the Metropolitan Washington Airports Authority. • Field inventory and photogrammetric mapping of Blue Plains Wastewater Treatment Plant, Washington, D.C. ACADEMIC BACKGROUND: B.A. /Geography /Virginia Tech /1989 CONTINUED PROFESSIONAL DEVELOPMENT: Completed short courses in the following: • Active Server Pages • ArcIMS customization • ArcInfo • awk, sed • Bourne, Korn, C-Shell • GeoMedia customization • GeoMedia WebMap customization • HMTL • ITIL • Microsoft Project • Microsoft SQL Server administration • Oracle DBMS • Oracle Spatial • Project management • RouteSmart • SDSFIE implementation • SQL programming • SQL Server DBMS • System architecture design for GIS • UNIX administration • VBScript • Windows administration CERTIFICATIONS AND AWARDS: New York City Excellence in Technology Award Program (ETAP) award, 2001 First annual Friend of AURISA award, 2002 Geographic Information Systems Professional (GISP) certification number 52922 SOCIETIES AND AFFILIATIONS: Hall resume Page 7 Bowne Management Systems, Inc. National Emergency Numbering Association (NENA) New York State GIS Association (NYSGISA) Urban and Regional Information Systems Association (URISA) PUBLICATIONS AND PRESENTATIONS: Mr. Hall has published two magazine articles and made over 50 presentations in five countries including the following: Waterfront Management in the Big Apple, 25th Annual New York State GIS Conference, Lake Placid,, New York, October 2009 (also presented at the 24th Annual Northeast Arc Users Group Conference, Nashua, New Hampshire, October, 2009). The Re-Design of Mapping Westchester County, 24th Annual New York State GIS Conference, Liverpool, New York, October 2008. Geographic Web Services: Open Solutions for Local Governments (updated), 14rd Annual MAC URISA Regional GIS Conference, Mount Laurel, New Jersey, April 2008. Geographic Web Services: Open Solutions for Local Governments, 23rd Annual New York State GIS Conference, Albany, New York, October 2007. Unified GIS Services for Westchester County, Co-presentation with Sam Wear (County GIS Manager), 23rd Annual New York State GIS Conference, Albany, New York, October 2007. The Future of GIS—A Big Apple Perspective, GIS and Mapping Operations Users Group, New York, New York, July 2004. GIS and Public Safety—A Big Apple Perspective (Keynote address), Live video link copresentation with Alan Leidner, GIS for Emergency Management Conference, Sydney, Australia, June 2004. Innovative GIS at the New York City GIS Utility, 19th Annual New York State GIS Conference, Liverpool, New York, October 2003. Innovative GIS in the Big Apple, 23rd Annual ESRI Users Conference, San Diego, California, July 2003. Data Integration in NYC Government, New York Area Data Council’s Data Connections XIII, New York, New York, March 2003. Implementing the New York City GIS Utility, 21st Annual GITA Conference, San Antonio, Texas, March 2003. GIS as a Tool for Managing Terrorist Attacks and Other Emergencies (Keynote address), Harvard University's GIS Day, Cambridge, Massachusetts, November 2002. Spatial Systems Integration, Data Warehousing, and OLAP, Co-presentation with Rich Annitto (Bowne AE&T) and Beth Desmarais (SI Systems), Long Island GIS Conference, Upton, New York, November 2002. A Standard Information Architecture to Support both the Enterprise and First Responders Co-presentation with Bruce Goldsmith (PlanGraphics), Oracle’s Critical Solutions Partner Forum, Reston, Virginia, November 2002. Hall resume Page 8 Bowne Management Systems, Inc. Technical Observations on the WTC Emergency Mapping and Data Center and the GIS Utility Activities Since 9/11, 40th Annual URISA Conference, Chicago, Illinois, October 2002. Annual Report on the New York City GIS Utility, 18th Annual New York State GIS Conference, Liverpool, New York, October 2002. Update on NYC GIS Utility Accomplishments and Goals, 3rd Annual New York Technology Forum, Brooklyn, New York, October 2002. Update on NYC GIS Utility Accomplishments and Goals, GIS and Mapping Users Group, New York, New York, September 2002. 9/11 Lessons Learned and Adjustments to the NYC GIS Program, New England GIS Conference, Massachusetts, May 2002. World Trade Center Response and Recovery Effort: Lessons Learned, The GeoTEC Event, Toronto, Canada, April 2002. The Effect of September 11th on Information Technology, Panel discussion/presentation, Fordham University, New York, New York, April 2002. “Notes from a Yankee’s Trip through Australasia,” GIS User magazine, January-February 2002. Contributing writer to World Trade Center issue of GEOWorld magazine, January 2002. Speaking Tour of Australia and New Zealand coordinated and paid for by the Australasian Urban and Regional Information Systems Association (AURISA) – GIS Responds to the WTC Disaster, 16 presentations in nine cities, November – December 2001. Included keynote address at AURISA’s 29th Annual Conference, two radio interviews, two newspaper articles and one magazine article. GIS Responds to the WTC Disaster, GIS Day Showcase, Detroit, Michigan, November 2001. GIS in New York City: Response to the World Trade Center Disaster, Co-presentation with Alan Leidner (New York City GIS Director), 17th Annual New York State GIS Conference, Albany, New York, October 2001. Design and Implementation of the New York City GIS Utility, 39th Annual URISA Conference, Long Beach, California, October 2001. GIS in New York City: Response to the World Trade Center Disaster (Special Plenary Session), 39th Annual URISA Conference, Long Beach, California, October 2001. GIS Responds to the WTC Disaster, Co-presentation with Alan Leidner (New York City GIS Director), GIS and Mapping Operations Users Group, New York, New York, October 2001. Design and Implementation of the New York City GIS Utility, 21st Annual ESRI Users Conference, San Diego, California, July 2001. Implementation of the New York City GIS Utility, 14th Annual Towson University GIS Conference, Baltimore, Maryland, May 2001. Application Development for the New York City GIS Utility, 1st Annual New York Technology Forum, Brooklyn, New York, October 2000. Creating the New York City GIS Utility, 1st Annual New York Technology Forum, Brooklyn, New York, October 2000. Hall resume Page 9 Bowne Management Systems, Inc. Just what have we got here? GIS Metadata Implementation for Four Quite Different Organizations, 13th Annual Towson University GIS Conference, Baltimore, Maryland, May 2000. Application Development Methodologies and Standards, 13th Annual Towson University GIS Conference, Baltimore, Maryland, May 2000. A GIS Migration Report -City of Lynchburg, Virginia, 10th Annual Virginia GIS Conference, Abingdon, Virginia, October 1999. Improving Water and Sewer Utility Operations through GIS Implementation, Florida Atlantic University GIS Workshop, Fort Lauderdale, Florida, May 1997. Digital Mapping for the Sultanate, Florida Joint Geographic Information/Mapping Conference, Daytona Beach, Florida, April 1997. The Quality Control of Digital Mapping Data, 2nd Annual Middle East ESRI Users Group, Dubai, United Arab Emirates, November 1995. Bailey resume Page 1 Bowne Management Systems, Inc. Leland Bailey Senior GIS Analyst III SUMMARY OF PROFESSIONAL LIFE: Mr. Bailey has over 35 years of experience in GIS design, data development, and implementation. Since 2002, he has served as the GIS Group Team Leader, directing a staff of 20 professionals. Mr. Bailey has management responsibility for all Bowne services related to GIS design, data development and implementation, including the firm’s ESRI Solutions Group, and is intimately familiar with complex, largescale GIS implementations (use of spatial database products, internet map servers, desktop GIS spatial analysis, mapping, editing, and Relational Database Security models). In addition to his comprehensive ESRI skills, Mr. Bailey is fluent in the AutoDesk software suite, including AutoCAD 2006. CURRENT PROFESSIONAL SKILLS: Development • SQL, XML GIS Environment • ArcGIS Suite (ArcView, ArcEditor, ArcInfo,) 8.x, 9.x • ArcIMS 4.x, 9.x • ArcSDE 8.x, 9.x • AutoDesk Suite (all versions), MapInfo Professional, SmallWorld RDBMS • Oracle 11g, 10g, 9i, 8i. Clustered technology using RAC and FailSafe. Includes InterMedia • SQL Server 2000, 2003, Express, including MSCS • Microsoft Access Hosting Environments • Oracle 9iAS • iPlanet 6.x • IIS (multiple versions, including load balancing) • Apache/Tomcat (multiple versions) Operating Systems • Windows 2000 Server Family, 2003 Server Family, Windows XP • Sun Solaris 8,10 • HP/UX 11.x • Redhat Linux Structured Analysis/Design Microsoft Visio, SQL Developer, Oracle Enterprise Manager Console Office Automation Microsoft Office Suite, including Project REPRESENTATIVE ASSIGNMENTS: New York City DoITT Citywide Street Centerline Project (CSCL) Phase II, GIS Analyst – Bowne, as a subcontractor to Hewlett-Packard provided GIS services to the CSCL project. The purpose of this project Bailey resume Page 2 Bowne Management Systems, Inc. was to provide the City with a CSCL Geodatabase data model and populate it with the necessary data in order for the City to support the Emergency Communications Transformation Project (ECTP). Mr. Bailey was responsible for the management and oversight in regard to the design, creation, integration and loading of the data into an Oracle SDE Geodatabase. New York City DoITT Citywide Street Centerline Project (CSCL) Phase III, GIS Analyst – The purpose of this project was to provide the City with a custom set of maintenance software tools to edit and support the Citywide Street Centerline that was created under CSCL Phase II. Mr. Bailey was responsible for the management and oversight of several Oracle Sun Solaris Servers that were used to support our software developers during the creation and testing of the CSCL maintenance applications. New York City EDC Waterfront Facilities Mapping Program (Phase II), GIS Analyst – Bowne, as a subcontractor to Turner Construction Company and Ocean and Coastal Consultants, provided GIS and survey services for the mapping of waterfront facilities in New York City. The purpose of this program was to provide EDC with a comprehensive understanding of the waterfront properties which they and other city agencies are responsible for managing. As GIS Analyst, Mr. Bailey was responsible for project management and oversight in regard to the integration and design of the field collected features into the GIS Geodatabase schema. Fire Department of New York, Emergency Communications Transformation Project (ECTP), Solution Architect – As part of the City’s Emergency Communications Transformation Project, Mr. Bailey developed a comprehensive data solution for the EMSCAD system. This included the design and development of a new geofile that will support the Starfire CAD system and data maintenance plan. The environment is ArcGIS 9.1 and ArcSDE/Oracle. This work was done as part of a subcontract to Hewlett-Packard. New York City Department of Finance, Digitization of Tax Maps, GIS Analyst – Mr. Bailey was part of the Bowne Team working on the system integration project to digitize surveyor tax maps. Mr. Bailey worked on the Tax Map Conversion Specification, Data Model and long term ESRI maintenance issues. This work was done as part of a subcontract to BearingPoint. New York City Department of Housing Preservation and Development (HPD), Lead Inspection Routing, GIS Analyst – Mr. Bailey conducted on-site meetings with HPD’s GIS and IT departments to help them determine their GIS needs and security requirements. New York City Department of Housing Preservation and Development (HPD), Urban Renewal Maps, GIS Analyst – Mr. Bailey supervised the migration of the hardcopy urban renewal maps to a seamless Oracle SDE Geodatabase environment. He also designed the multi-user ArcSDE environment and mentored HPD GIS staff in the editing and posting of URA map changes. The environment is Oracle 8i, Oracle Spatial, ArcSDE 8.3, ArcGIS 8.2, and ArcIMS 4.01. New New York City Housing and Neighborhood Information System (NYCHANIS), GIS Analyst – Mr. Bailey was responsible for building the hosting environment to support the internet-based NYCHANIS. This build included spatial database servers (ArcSDE/SQL Server 2000), web servers (ArcIMS/IIS), and firewall configuration. His work also included a GIS security model to support NYCHANIS. The implementation of NYCHANIS was a collaboration between the New York University School of Law and the New York City Department of Housing and Preservation Development (HPD). Bailey resume Page 3 Bowne Management Systems, Inc. Fire Department of New York, Thematic Mapping, Solution Architect – To support the Thematic Mapping Project, Mr. Bailey managed the Bowne team in the creation of an FDNY GIS Repository, which included NYCMAP, DCP data, and orthophotography. This data was all loaded into an Oracle 9i based ArcSDE environment. Mr. Bailey also worked on the team that implemented the FDNY hosting environment, which included Oracle 9iAS and ArcIMS 4.01 (using load balanced spatial servers). This work was completed as pat of a subcontract to Plangraphics. New York City Department of Transportation, Spatial Data Warehouse, GIS Analyst – Mr. Bailey was part of the Bowne team that implemented a Microsoft Clustered Services solution to provide high availability services. This involved failover clustering for ArcSDE/SQL Server 2000 and network load balancing for ArcIMS/IIS. Mr. Bailey also served on the database deployment team which populated the DOT database with NYCMAP, DCP data, and operational datasets. Islip Resource Recovery Agency, Blydenburgh Road Landfill, GIS Project Manager – This project was split between Sidney B. Bowne & Son’s survey department and sister company, Bowne Management System’ GIS department. Mr. Bailey was responsible for oversight, design and implementation of the GIS portion of the project. Additional tasks included the creation of base geographic features from an existing AutoCAD drawing file; loading of new well point field collected data that the survey department collected into the GIS; joining the Town’s existing data files to the newly created well point features; hyper-linking well photographs to the well point data in GIS; creation of overall site maps for the project; creation of individual maps for each well location and assembled them into a bound book; published all data into a GIS data format that is viewable in ESRI’s ArcReader software; installation of the published data on the Town’s server and performed a training session for the Town on how to use and access the data from the ArcReader software. United States Army Reserve 77th Regional Readiness Command (RRC), Enterprise GIS, Solution Architect -Mr. Bailey worked on the implementation of an Enterprise GIS for the 77th RRC. This implementation was compliant with the Federal Spatial Data Standard and conformed to the October 2001 memorandum issued by the Assistant Chief of Staff Installation Management. The GIS encompassed the 77th’s facilities in New York and New Jersey and contained both natural resource and facilities management data layers. Also included were multiple raster data sets contained from commercial or government sources. The dataset also integrated CAD site plans. The 77th’s GIS was based on ESRI’s ArcSDE Geodatabase model. Applications were deployed using web based mapping (ESRI’s ArcIMS) and desktop GIS (ESRI’s ArcGIS). Town of Islip Department of Planning and Development, Inventory for GASB34 Preparation, GIS Analyst – Bowne designed and compiled an ArcGIS Geodatabase. This geodatabase includes datasets such as the GPS field locations of drainage manholes, catch basins, culverts and recharge basins. Additional GPS collection efforts captured signs, utility and light poles, sidewalks, curbs, driveways, and traffic lights. Hardcopy material, such as work orders and drainage/subdivision plans from the Town’s Public Works department were researched and entered into a Microsoft Access database using a custom interface, providing the availability to link legacy attribute data records to the field collected features. (11/02 – 5/04) Nassau County Plan, GIS Support, GIS Analyst – Mr. Bailey is responsible for overseeing the GIS support Bowne provided to Nassau County. Bowne assists over a dozen departments at the County that use the GIS system, including Public Works, Planning, Fire Communications, Police, Assessment, Emergency Management, Health, Parks and Recreation, Policy, and County Attorney – Real Estate. Mr. Bailey manages Bowne’s GIS Solutions Group which provides data management, user and system administrative support, and database design and administrative tasks. Bailey resume Page 4 Bowne Management Systems, Inc. Metropolitan Transit Authority (MTA) Headquarters, GIS Data Warehouse, GIS Analyst – Mr. Bailey was part of the team that designed and implemented the MTA Headquarters GIS Data Warehouse. His tasks included Oracle/ArcSDE installation in a Solaris environment, the design and build of a GIS security model for MTA Headquarters and the population of a multi-jurisdictional GIS database for the MTA. Nassau County GIS, GIS Analyst – Mr. Bailey is part of the overall Nassau County Team. In this role, Mr. Bailey oversees the daily activities of GIS technicians and analysts. His work tasks include data development, QA/QC, database maintenance, including monthly maintenance events and database compression. He is part of the team that designed and implemented a high availability and disaster recovery solution for the County’s GIS. This included blade technology, Oracle 10g RAC, LINUX, clustered database and load balanced servers. Nassau County Department of Assessment, GIS Analyst – Mr. Bailey is part of the Bowne Team that provides a complete program of contract oversight and quality control of the tax mapping compilation contractor. Work items include: • Using Oracle InterMedia and Java, designed a storage methodology for over 1 million property photographs and PDF documents. • Needs and workflow analysis • Software design and implementation • Conduct group and individual training seminars for custom software • Deploy and maintain version control system for digital tax mapping • Integrating digitized AutoCAD drawings into ArcSDE • Oracle support and of the Department’s internet-based Land Records Viewer The technical environment for the Assessor is AutoCAD map, ArcSDE/Oracle and ArcIMS. MTA/Long Island Rail Road, Phase I GIS Implementation, GIS Analyst – Mr. Bailey has served a variety of roles in Bowne’s delivery of services to the LIRR. This began with a pilot project to convert photogrammetric basemap data to AutoCAD format and progressed to full infrastructure data data capture via LIDAR and GPS technology. In addition to data services, Mr. Bailey provided GIS architecture services to LIRR including Enterprise GIS deployment using Solaris, Oracle 8i, and Citrix based deployment of ArcGIS. New York State Department of Motor Vehicles, New York State Accident Location Information System (ALIS), GIS Analyst – Bowne assisted in the development of NYS DMV’s ALIS. The project consists of replacing their obsolete accident location coding with a more efficient and accurate system using modern GIS technology to locate and analyze accidents. Mr. Bailey was part of the implementation team that installed Oracle 9i and ArcSDE 9.0. ACADEMIC BACKGROUND: A.A.S. /Construction Technology /University of New York at Farmingdale /1972 Bailey resume Page 5 Bowne Management Systems, Inc. CONTINUED PROFESSIONAL DEVELOPMENT: Oracle iLearning: Enterprise Learning Management System /2005 Introduction to SQL and PL/SQL /New York Education Center /2001 Enterprise DBA Part 1A: Architecture and Administration /2001 Application Development /SmallWorld /1998 Fli-Map -Airborne Corridor Mapping and Profiling System /1997 SDE 3.0 Training Course (Environmental Systems Research Institute /1997 Construction Inspection of Highway and Drainage Projects Drafting and Design of Sanitation and Drainage Facilities Aerial Photo Interpretation Schechter resume Page 1 Bowne Management Systems, Inc. Joseph Schechter Senior GIS Analyst II SUMMARY OF PROFESSIONAL LIFE: Mr. Schechter joined Bowne Management Systems with more than 20 years experience in Information Technology and 10 years in Geographic Information Systems, including 10 years in management. He is a core member of the firm’s ESRI Solutions Group. Mr. Schechter’s specialties encompass solutions architecture for the complex interoperability of heterogeneous systems. His experience with software includes integration of ArcIMS and ArcSDE utilizing IIS, Oracle 9iAS, Apache, and iPlanet web servers; installation and configuration of high availability ArcIMS using Microsoft’s Network Load Balancing in a Microsoft Windows 2000 cluster; installation and configuration of ArcSDE and MS SQL Server 2000/Oracle Server using failover clustering in a Microsoft Windows 2000 clustered configuration; complex integration of ArcSDE raster databases with pictometry imagery; and configuration and implementation of geodatabase security models in MS SQL Server 2000 and Oracle Server. His technical support of software packages includes Environmental Systems Research Institute’s (ESRI) geographic information system programs ArcSDE, ArcView, ARC/INFO, ArcMap. ArcEdit, and ArcIMS in both the Windows and UNIX environments, and relational database management systems like MS SQL Server and Oracle. He was previously Project Manager of software design for environmental health report generation and statistical data management. CURRENT PROFESSIONAL SKILLS: Development • SQL, XML, ArcXML, JavaScript GIS Environment • ArcGIS Suite (ArcView, ArcEditor, ArcInfo,) 8.x, 9.x • ArcIMS 4.x, 9.x • ArcSDE 8.x, 9.x RDBMS • Oracle 9i, 8i. Clustered technology using FailSafe. • SQL Server 2000, including MSCS • MySQL • Microsoft Access Hosting Environments • Oracle 9iAS • iPlanet 6.x • Weblogic • IIS (multiple versions, including load balancing) • Apache/Tomcat (multiple versions) Operating Systems • Windows 2000 Server Family, 2003 Server Server Family, Windows XP • Sun Solaris 8 • HP/UX 11.x • Linux Structured Analysis/Design • Microsoft Visio Office Automation • Microsoft Office Suite, including Project Schechter resume Page 2 Bowne Management Systems, Inc. REPRESENTATIVE ASSIGNMENTS: Nassau County Fire Alarm Map Web Service, GIS Analyst -Mr. Schechter designed and configured the map service that allows a user (via a web service) to obtain a fire alarm location map in PDF format by providing a valid address, street intersection or latitude & longitude. The resulting map pinpoints the fire incident location and displays the alarm information and search results. The map service accesses the county’s production GIS database for the most up to date information available. Nassau County Plan/GIS Support, GIS Analyst -Mr. Schechter is part of the overall Nassau County Team. His work tasks include data development, QA/QC, database maintenance, including monthly maintenance events and database compression. He is part of the team that designed and implemented a high availability and disaster recovery solution for the County’s GIS. This included blade technology, Oracle 10g RAC, LINUX, clustered database and load balanced services. Nassau County Municipal Data Sharing Portal, GIS Analyst – Mr. Schechter installed and configured ArcGIS Server 9.2 for the Java Platform using Tomcat 6.0.9 web server on a windows 2003 server in support of an internet web based application. He also configured map services utilizing replicated file geodatabases for source information. Fire Department New York Emergency Communications Transformation Project (ECTP), GIS Analyst – As part of the City’s Emergency Communications Transformation Project, Mr. Schechter provides database design and implementation services. The environment is ArcGIS 9.1and ArcSDE/Oracle. This work is being done as part of a subcontract to Hewlett-Packard. New York City Department of Finance Digitization of Tax Maps, GIS Analyst -Mr. Schechter is a member of the team that developed the interface for a web based QA/QC application that DOF has used to review tax maps created as part of the project to Digitize Surveyor Tax Maps. In addition, he is responsible for the design, implementation, support and maintenance of the ArcIMS map services that support the QA/AC application. Westchester County Planning Department Real Property Search Application, GIS Analyst -The County requested a desktop application that it could distribute to each local municipality for parcel lookup and spatial proximity searching. Used primarily for notification purposes, this application had to be easy to use, maintain and distribute with tailored data for each locale. The application was developed by Bowne in Visual Basic .Net with ESRI’s ArcEngine and a personal geodatabase. Fire Department New York Thematic Mapping, GIS Analyst -To support the Thematic Mapping Project, Mr. Schechter worked with the Bowne Team to create an FDNY GIS Repository, which included NYCMAP, DCP data, and orthophotography. This data was all loaded into an Oracle 9i based ArcSDE environment. Mr. Schechter also worked on the Team that implemented the FDNY hosting environment, which included Oracle 9iAS, and ArcIMS 4.01 (using load balanced spatial servers). This work was completed as part of a subcontract to Plangraphics. Westchester County Department of Information Technology Web Mapping Applications, GIS Analyst – As part of the Mapping Westchester County project, Mr. Schechter was responsible for the creation of a GIS based application for the Department of Consumer Protection to provide locations and mapping of gas Schechter resume Page 3 Bowne Management Systems, Inc. stations by lowest price and distance. This required functionality changes, map service changes, symbology and interface changes and result in a more efficient, streamlined internet GIS for the County. Schoharie County ArcSDE Training, GIS Analyst – Bowne provided providing On-site GIS, ArcSDE based mentoring/training consulting services to Schoharie County’s Central Data Processing Unit and the Department of Planning. Mr. Schechter provided technical services for the assessment of the existing GIS environment, architecture and infrastructure, Training County staff on GeoDatabase Concepts, and Administrating ArcSDE and SQL Server Database. New York State Department of Motor Vehicles Accident Location Information System (ALIS), GIS Analyst -Bowne is assisting in the development of NYS DMV’s Accident Location Information System (ALIS). The project consists of replacing their obsolete accident location coding system with a more efficient and accurate system using modern GIS technology to locate and analyze accidents. Mr. Schechter was part of the implementation team that installed Oracle 9i and ArcSDE 9.0. Dow Jones WebGIS System, GIS Analyst -Mr. Schechter was part of the implementation team that installed ArcSDE 9.0 in a MS SQL Server 2000 environment and ArcIMS 9.0 in an IIS/Apache Tomcat environment to support the Dow Jones Geographic Information System. He designed and implemented the geodatabase security model and assisted in the design and loading of data including orthophotography into the Dow Jones geodatabase. Mt. Vernon GIS Services, GIS Analyst – Mr. Schechter provided GIS review and configuration and was responsible for reviewing the existing shapfiles provided by Mt. Vernon and importing them into a personal geodatabase. City of New Rochelle Phase I GIS Implementation, GIS Analyst -Mr. Schechter was part of the implementation team that installed ArcSDE 9.0 in a MS SQL Server 2000 environment and ArcIMS 9.0 in an IIS/Apache Tomcat environment to support the City’s Geographic Information System. He designed and implemented the geodatabase security model and assisted in the design and loading of data including orthophotography into the City’s geodatabase. In addition, he designed and implemented ArcIMS Viewers in support of City Department needs. New York City Department of Housing Preservation and Development (HPD) Map Conversion, GIS Analyst – Mr. Schechter provided design and load support for the georeferenced Urban Renewal maps (in raster format) to a seamless Oracle SDE Geodatabase environment. The environment at HPD is Oracle 8i, Oracle Spatial, ArcSDE 8.3, ArcGIS 8.2, and ArcIMS 4.01. New York City Department of Transportation Spatial Data Warehouse, GIS Analyst – Mr. Schechter was part of the Bowne Team that implemented a Microsoft Clustered Services solution to provide high availability services. This involved failover clustering for ArcSDE/SQL Server 2000 and network load balancing for ArcIMS/Microsoft IIS. Mr. Schechter also served on the database deployment team, which populated the DOT database with NYCMAP, DCP data, and operational datasets. New York City Housing and Neighborhood Information System (NYCHANIS), GIS Analyst – Mr. Schechter is responsible for the maintenance of the NYCHANIS site. In this role he ensures that all map services are functioning, periodically loads data and reviews performance and availability metrics. Mr. Schechter also participated in the build of NYCHANIS, including the web server (ArcIMS/IIS) and firewall configuration. The implementation of NYCHANIS was a collaboration between the New York University School of Law and the New York City Department of Housing Preservation Development. Schechter resume Page 4 Bowne Management Systems, Inc. Town of Babylon Department of Planning and Development GIS Implementation, GIS Analyst -Mr. Schechter was part of the implementation team that installed ArcSDE 8.3 in a MS SQL Server 2000 environment and ArcIMS 4.0.1 in an IIS/Servlet Exec environment and an upgrade to ArcSDE 9.0 and ArcIMS 9.0 to support the Town’s Geographic Information System. He designed and implemented the geodatabase security model and assisted in the design and loading of data including orthophotography into the Town’s geodatabase. U. S. Army 77th Regional Readiness Command GIS Implementation, GIS Analyst – Mr. Schechter was part of the implementation team 77th RRC. This implementation was compliant with the Federal Spatial Data Standard and conformed to the October 2001 memorandum issued by the Assistant Chief of Staff Installation Management. The GIS encompassed the 77th’s facilities in New York and New Jersey and contained both natural resource and facilities management data layers. Also included were multiple raster data sets contained from commercial or government sources. The dataset also integrated CAD site plans. The 77th’s GIS was based upon ESRI’s ArcSDE Geodatabase model. Applications were deployed using web based mapping (ESRI’s ArcIMS product) and desktop GIS (ESRI’s ArcGIS product). Town of Islip Planning & Development GIS Implementation, GIS Analyst – Mr. Schechter was part of the implementation team that installed ArcSDE 9.1 in a MS SQL Server 2000 environment. He also designed and implemented the geodatabase security model and assisted in the loading of data into the Town’s geodatabase. Nassau County Department of Assessment Cadastral Mapping Project, GIS Analyst – Mr. Schechter is part of the County’s GIS consultant team to provide a complete program of contract oversight and quality control of the tax mapping compilation contractor. Work items included: • Needs and workflow analysis • Software design and implementation • Conduct group and individual training seminars for custom software • Provide written software documentation • Integrating digitized AutoCAD drawings into ArcInfo and SDE • Design of the Department’s internet-based Land Records Viewer Town of North Hempstead COPS Grant, GIS Analyst -Mr. Schechter was part of the Bowne Team that implemented a Microsoft Clustered Services solution to provide high availability services. This involved failover clustering for ArcSDE 9.0/SQL Server 2000 and network load balancing for ArcIMS 9.0/Microsoft IIS. Nassau County Department of Public Works Azteca Implementation, Project Manager – Mr. Schechter was responsible for quality control and the correction and integration of digitized sewer network into the County’s GIS database. He assembled a single, seamless topologically correct coverage of the County’s sewer network and incorporated this layer into the County’s GIS database. He ensured that all attribute data was loaded into the appropriate database tables. In addition, Mr. Schechter oversaw the implementation of Azteca Systems’ Cityworks GIS-based system for sewer maintenance management, which integrated the GIS coverage into its wastewater management system. Long Island Rail Road Phase I Implementation, Solution Architect – Mr. Schechter was responsible for Geographic Information Systems (GIS) maintenance and support. His responsibilities include project management for all GIS activities, featuring the upgrade for LIRR-wide GIS client and server side software. The system was successfully upgraded over a three-month period. Major milestones included Schechter resume Page 5 Bowne Management Systems, Inc. hardware upgrade requirements, detailed user training, installation, and data migration to ArcSDE in Oracle 9i on a Sun server. Metropolitan Transit Authority (MTA) Headquarters GIS Data Warehouse, Solution Architect – This project involved an agency-wide GIS data warehouse. Tasks included user needs assessment, high level and detailed designs, implementation, and mentoring and training. Mr. Schechter also participated in multi-agency design meetings to meet MTA requirements for TIGER and NYCMAP where he was responsible for the following: • Implementing TIGER and LION in ESRI's ArcSDE product, using SUN Solaris and Oracle 8i. • Loading MTA Operational Datasets, including MTA assets (rail lines, rail stations bus routes, bus stops, bridges, tunnels) • Capital Projects • Environmental Audit Data • Arts for Transit Mr. Schechter supervised the development of an ArcIMS Viewer (which integrated all components of the Spatial Data Warehouse) and the development of the GeoSupport Object (which allowed web-based application to directly communicate with the Crystal Enterprise for seamless real-time reporting). Nassau County Department of Assessment Cadastral Mapping System, Project Manager – Mr. Schechter was responsible for the design, configuration, installation, and implementation of version control software in support of a digitized tax map maintenance system utilizing Merant PVCS Version Manager. He enabled users to connect a Windows NT PC to a Unix host server through the NFS protocol. The version control software provided a mechanism to restrict user access and allowed for editing and tracking changes to digitized tax maps, which are date and time stamped providing a revision history. This system offered the ability to recreate a tax map for any point in time. PRIOR EXPERIENCE: In his 26 years at the Nassau County Department of Health, Mr. Schechter served in several different departments, as the Deputy Director, managing the Division of Environmental Health ((1998-2000), as the Assistant to the Director of the Division of Environmental Health (1991-1998), as the Office Chief of Various Departments -Groundwater Protection, Industrial and Hazardous Wastes Management, Industrial Wastes, Special Enforcement and Training Officer (1978-1991) and Bureau of Food and Beverage Control (1974-1978). ACADEMIC BACKGROUND: B.S. /Chemistry /Syracuse University /1969 M.S. /Physical Chemistry /Pennsylvania State University /1972 PUBLICATIONS AND PRESENTATIONS: The Generation of Simulated Mass Spectra of Small Organic Molecules by Computerized Pattern Recognition Techniques. With P.C. Jurs. Published in Applied Spectroscopy, 27, 30 (1973) Improved Discriminant Training and Feature Extraction for the Generation of Simulated Mass Spectra of Small Organic Molecules. With P.C. Jurs. Published in Applied Spectroscopy, 27, 225 (1973) Tran resume Page 1 Bowne Management Systems, Inc. Ngoc Van Tran Senior GIS Application Developer SUMMARY OF PROFESSIONAL LIFE: Mr. Tran is a senior member of Bowne’s Application Development Group. He has been providing services in the areas of system analysis, application design and development and networking since 1998. He has had Technical Project Management responsibilities since 2005. His core expertise includes defining user requirements, system design, development and implementation. Mr. Tran has worked on many projects spanning from small, single-user databases to multi-user, web-based, Internet Information Servers (IIS), and client-server applications. He is well-versed in multiple development and database environments such as shown below. CURRENT PROFESSIONAL SKILLS: Development • Microsoft Visual Studio.NET, VB.NET, C#, • Microsoft Visual Studio VB, ASP, Adobe Dreamweaver • Eclipse, Websphere Rational Developer. • JAVA, JSF, JSP, Struts. • ArcObjects, Esri ArcGIS Server, .Net ADF, Java ADF, Javascript API, Flex API, ArcXML • Oracle Server, SQL Server, My SQL GIS Environment • ArcGIS Server • ArcGIS .NET ADF • ArcGIS Java ADF • ArcIMS • ArcGIS Suite (ArcEditor, ArcInfo,) • ArcPad • Bing Map • Google Maps API RDBMS • Oracle Database 11g, 10g, 9i, 8i • SQL Server 2008/2005/2000/CE/7/6.5 • Microsoft Access 2007, 2003, 2000, 97 • FoxPro • IBM DB2 Hosting Environments • IIS • Apache Tomcat • Apache Web Server • iPlanet WebServer • Sun One Web Server • IBM WebSphere Application Server • IBM Webshpere Portal Server Tran resume Page 2 Bowne Management Systems, Inc. • Oracle Weblogic Server Operating Systems • Windows XP/2000/NT/9x • Windows Mobile Structured Analysis/Design • Microsoft Visio • Describe • Enterprise Architect • Rapid SQL Office Automation • Microsoft Office Suite • Crystal Reports REPRESENTATIVE ASSIGNMENTS: Nassau County Sales Comparable Map – Mr. Tran created a batch printing application in ESRI ArcGIS Desktop to locate and annotate comparable sales on the Nassau County GIS map. These maps are used to assist assessment review hearings (8/10) Suffolk County Tax Map Maintenance Application, Lead GIS Website developer, GIS Developer – Mr. Tran developed a tax map maintenance application for the Suffolk County Real Property Tax Service Agency. This application maintains all tax map and parcel boundary data for all town and villages in Suffolk County. Developed a public .NET website with integrated ESRI ADF .NET GIS Mapping that allow paid subscribers (title researchers, realtors) to view tax detail map parcel and boundaries data, deeds and sales information (6/09 – Current) Westchester County Department of Information Technology, Web Mapping Applications, Lead GIS Developer – Mr. Tran is migrating the current ArcIMS viewer (http://giswww.westchestergov.com/gismap) to ArcGIS Server 9.3.1 platform using JavaScript API and Dojo framework (10/09 -Current) Suffolk County Bathing Beaches Website, Lead Developer – Mr. Tran developed a beach management application for the Suffolk County Health Department. The application processes beach water sample data, recommends changes to beach status and allows users to search, maintain and report on beach information. This AJAX-enabled ASP.NET application was programmed using the VB.NET programming language. (8/06 – 3/08) New York City DoITT CSCL Phases II and III, GIS Developer -Bowne is working with DoITT and the New York City Department of City Planning to enhance the City’s existing street centerline (“LION”) and related datasets to support Unified Call Taking (UCT) and the computer-aided dispatch systems (CAD) at NYPD and FDNY. The new Citywide Street Centerline (CSCL) dataset will be used to create extracts that can be loaded into the public safety CAD systems to improve the accuracy of dispatching. Mr. Tran developed an interface and algorithm that generate and assign sequence number to Centerline, Shoreline, Rail, and Subways based on address ranges and spatial location. He finalized system design, solved technical issues, reviewed software architecture and project source code, evaluated software for completeness and accuracy and managed software builds. (10/07 – Present) New York City Department of Finance, DTM Online, Lead Developer – Mr. Tran designed, developed and maintained New York City Finance’s Digital Tax Map System to show lot lines, block and lot numbers, street names, lot dimensions, and easements to the general public user. Digital Tax Map System also includes component integrating ACRIS (Automated City Register Information System) component which Tran resume Page 3 Bowne Management Systems, Inc. allows users to perform property document online search and registration application. The Digital Tax Map System was developed in Websphere Rational Developer using Java Server Faces (JSF) and ESRI JAVA ADF mapping architecture to render GIS data in SDE. The public site is accessible at http://gis.nyc.gov/dof/dtm/index.jsf. Extensive stress and load balance test script were also written for the site. Load performance and application performance scripts written includes: HP Load Runner 9.1 and IBM Application Scan. (8/07 – 8/08) New York State Department of Environmental Conservation FLIT Enhancements, Lead Developer -Mr. Tran was the lead developer on the Facility Locational Improvement Tool Enhancements (FLIT) project. FLIT was a combination of ArcGIS based desktop and mobile tools developed to allow NYS DEC staff at the headquarters and all DEC regions to modify Air Title V facility locations. The desktop FLIT components enabled DEC staff to locate, relocate and move facility and emission points in the Oracle database. Mr. Tran has also worked on the mobile FLIT component where end users (DEC Field Engineers) were able to download relevant GIS data into their handheld GPS units, collect facility and emission point data from the field and upload data back to the DEC’s central database environment. (3/08 – 10/09) Town of Islip Department of Planning & Development GIS Implementation, Lead Analyst – Mr. Tran was the Lead Analyst for this project where Bowne worked with the Town’s GIS and Information Technology (IT) resources to design, configure, and implement ESRI’s ArcSDE product within Microsoft SQL Server 2000. Bowne services enabled the Town to efficiently implement a scalable enterprise GIS solution. In addition, Bowne provided mentoring services for data collection using ArcPad, advanced editing using ArcGIS, customization for ArcIMS and integration with legacy mainframe data using ViaSQL. (12/05 – 3/08) Westchester County Department of Information Technology Web Mapping Applications, Technical Project Manager – As part of the Mapping Westchester County project, Mr. Tran was responsible for management of a team of programmer/analysts for the development of a single ArcIMS, ArcSDE based viewer for the consolidation of four (4) public web sites that the County used to deploy GIS content. This required changes to functionality, map services, symbology and interfaces and resulted in a more efficient, streamlined internet GIS presence for the County. Mr. Tran used Google Maps with an additional layer of Google API for geocoding addresses, routing and driving directions. The viewer can be found at (http://giswww.westchestergov.com/westchester/emap/wc1.htm). (11/05 – 2/07) New York City EDC PropertyInfo Application, Technical Project Manager – Mr. Tran led the development of a GIS web application that provides EDC staff with access to an interactive map and related real estate, assessment, land use/zoning and property information integrated from multiple EDC and City data sources. For this project Mr. Tran supervised all programming staff and Bowne has provided ongoing support, data updates and as-needed modifications since the initial release of the application in 2007. Technologies used: .Net 2.0/3.5, SQL Server 2008, ArcGIS Server 9.3.1 (1/2007 – present). New York City Department of Parks and Recreation Forestry Management System, Lead Developer – Mr. Tran was the Lead Developer for this project, where Bowne developed a public website for constituents to enter forestry related complaints via the Internet. The public website interfaces with New York City GeoSupport and Azteca’s Forestry Management System (ForMS). (3/05 – 12/09) New York City Department of Finance, Digitization of Tax Maps, Lead Developer – Mr. Tran was part of the Bowne Team working on the system integration project to Digitize Surveyor Tax Maps. This work was done as part of a subcontract to BearingPoint. (4/05 – 3/08) Tran resume Page 4 Bowne Management Systems, Inc. Dow Jones WebGIS, Lead Developer -Mr. Tran was the lead developer for this project, where Bowne built a web based customer marketing geographic information system called WebGIS. The system enables circulation teams across the country to visually review subscriber distribution patterns to maximize service and efficiency. The system is extremely large and contains millions of customer records and a nationwide street centerline file of over 72 million records. Mr. Tran developed the required ETL packages (Microsoft DTS) to load weekly mainframe customer extracts (and nightly extracts) to load the WebGIS database. Nationwide customers can report and query on delivery locations for multiple products (e.g. Wall Street Journal, Barrons) and managers can view trends in circulation at a macro and micro level. WebGIS is based on SQL Server 2000, ArcSDE, and ArcIMS. (11/04 – 8/05) Suffolk County Department of Public Works DRIVE Project, Lead Developer – Mr. Tran led the development of the DRIVE system, a web-based (IIS) system for the management of critical infrastructure and accident reporting and tracking. This Oracle 9i-based system uses ArcSDE and ArcIMS as its two core products. The system is also used to inventory and track signals, permits, drainage, guide rails, accidents, and other critical data elements. (10/03 – 6/05) Nassau County Department of Assessment Cadastral Mapping Project, Lead Developer – Mr. Tran was part of the County’s GIS consultant team to provide a complete program of contract oversight and quality control of the tax mapping compilation contractor. Work items included: (12/97 – 2/05) • Needs and workflow analysis • Software design and implementation • Conduct group and individual training seminars for custom software • Provide written software documentation • Integrating digitized AutoCAD drawings into ARC/INFO and SDE Westchester County Planning Department Real Property Search Application, Developer -The County requested a desktop application that it could distribute to each local municipality for parcel lookup and spatial proximity searching. Used primarily for notification purposes, this application had to be easy to use, maintain and distribute with tailored data for each locale. The application was developed by Bowne in Visual Basic .Net with ESRI’s ArcEngine and a personal geodatabase. (7/04 – 2/05) New York City Housing and Neighborhood Information System (NYCHANIS), Developer – As part of the firm’s Web Design and Development Group, Mr. Tran participated in the development of NYCHANIS, an Internet-based inquiry system (IIS) for New York City housing statistics. One of his key assignments was the implementation of ESRI ArcIMS viewer based on Microsoft’s NET environment. (3/03 – 12/03) Nassau County Department of Assessment Internet Land Records Viewer, Lead Developer – Mr. Tran was the lead developer for one of the most comprehensive e-government applications in the nation. This application provides public access to millions of property assessment and sales comparison records related to property in Nassau County (www.nassaucounty.gov, eservices, property assessment). This application provides access to an Oracle based data warehouse that contains current and historical records, including imagery (e.g. property photos and property record card images) and linkage to GIS. As part of this application, Mr. Tran created materialized views and multiple stored procedures to embed business logic on the server side. (12/97 – 2/05) New York City Department of Transportation Spatial Data Warehouse Viewer, Lead Developer – Mr. Tran participated in the development of the Graphical User Interface Protototype, an Intranet-based mapping Tran resume Page 5 Bowne Management Systems, Inc. and inquiry system. Using this viewer, DOT personnel can use a map or reporting interface to query millions of DOT operational records. It was developed using HTML, JavaScript, ASP, ArcIMS, ArcSDE, and web-based IIS. (11/00 – 12/04) New York City Department of Transportation Spatial Street Smarts, Lead Developer – Mr. Tran was the lead developer for Spatial StreetSmarts, a-web based (IIS) application for the definition and tracking of street resurfacing projects in New York City. This is a complex application integrating mapping, reporting and analysis and has a module for directly interfacing with the City’s mainframe. (10/00 – 11/02) Long Island Rail Road Web-Based Viewer, Lead Developer – Mr. Tran created a web-based application using ESRI’s ArcIMS product. This product is used for the management and tracking of the LIRR’s asset inventory and general reporting and analysis. (12/99 – 6/01) Metropolitan Transportation Authority (MTA) Headquarters, GIS Data Warehouse, Lead Developer – This project involved an agency-wide GIS data warehouse. Mr. Tran was the lead developer in designing and building a web based GIS viewer that was used for tracking and reporting MTA assets and capital projects. This viewer was a java based viewer and integrated server based crystal reports for seamless, real-time reporting. (7/01 – 12/03) ACADEMIC BACKGROUND: B.S. /Chemical Engineering /Columbia University of New York CONTINUED PROFESSIONAL DEVELOPMENT: American Institute of Chemical Engineers Blanco resume Page 1 Bowne Management Systems, Inc. Kristine Blanco GIS Analyst I SUMMARY OF PROFESSIONAL LIFE: Ms. Blanco is a member of Bowne’s GIS Group sand is a skilled GIS analyst and trainer. She also serves the role of project manager, meeting with the customer, managing budgets and ensuring successful project delivery. Ms. Blanco is fluent in desktop GIS and spatial database technology and is an ESRIauthorized ArcGIS trainer (one of the few authorized ArcGIS II trainers in the NYC Metro area). CURRENT PROFESSIONAL SKILLS: Development XML, ArcXML, HTML GIS Environment • ArcGIS Suite (ArcView, ArcEditor, ArcInfo,) 8.x, 9.x • ArcIMS 4.x, 9.x • ArcSDE 8.x, 9.x • AutoDesk Suite (all versions), MapInfo Professional RDBMS • Oracle 8i, 9, 10g • SQL Server 2000 • Microsoft Access Hosting Environments • Oracle • IIS Operating Systems • Windows 2003 Server Family, XP, 2000 Structured Analysis/Design • Microsoft Visio Office Automation • Microsoft Office Suite • Crystal Reports REPRESENTATIVE ASSIGNMENTS: Nassau County Department of Information Technology 2009 NCGIS Support, GIS Analyst – Ms. Blanco was responsible for creating materials for and administering ArcGIS mentoring sessions for various County departments, designing and analyzing Nassau County road ownership maintenance application and analyzing landmark data design. She also updated Nassau County GIS data, geocoded BOCES Fiber Locations and geocoded OCFS locations. Ms. Blanco also created documentation for Nassau County GIS (Administration documentation, Georeferencing documentation, System Architecture documentation, Nassau County Pavement Management document). New York City DoITT Citywide Street Centerline Project (CSCL) Phase III, GIS Analyst – Ms. Blanco provided ArcGIS II training for the NYC Department of Planning as part of the Citywide Street Centerline Project. She also created map templates and documented differences between TIGER and CSCL data and differences between CSCL schemas. (9/08 – Present) Blanco resume Page 2 Bowne Management Systems, Inc. New York City DoITT Citywide Street Centerline Project (CSCL) Phase II, GIS Analyst – Ms. Blanco was responsible for quality control of LION segments and address points for the Citywide Street Centerline project. This work was done as part of a subcontract to Hewlett-Packard. Suffolk County Tax Map Maintenance Application, GIS Analyst – Ms. Blanco created a test environment to simulate workflow within the Suffolk County Tax Map Maintenance Application. The test environment was used to create different versioning scenarios for each user where each user would create their own versions of the geodatabase, perform edits, and then reconcile with the default geodatabase. (9/07 – Present) Town of Hempstead Department of Sanitation 2008 Application, GIS Analyst – Ms. Blanco provided onsite mentoring to ease the transition of the new RouteSmart interface. (6/08 – Present) Nassau County Department of Information Technology, 2008 NCGIS Support, GIS Analyst – Ms. Blanco compiled sewer and drainage data and incorporated into the Nassau County GIS. (9/08 – Present) Westchester County 2006 GIS Support, GIS Analyst – Ms. Blanco generated slope data using increments of 15-25% and 25% and over using 5-foot contours as the source data. (4/07 – 8/07) Nassau County Police Department 2007 IT and GIS Support, GIS Analyst – Ms. Blanco updated the Nassau County Street Centerline and associated street dictionary tables to provide street name validation and coordination between Nassau County Fire Communications and GIS data. (1/07 – Present) New York City Department of Finance Digitization of Tax Maps, GIS Specialist – Ms. Blanco was part of the Bowne Team working on the system integration project to Digitize Surveyor Tax Maps. Ms. Blanco provided database design, data loading and editing support for NYC Digital Tax Map. She used Geodatabase Diagrammer to develop Data Model in Microsoft Visio format to support database design. This work was done as part of a subcontract to BearingPoint. (4/05 – 3/08) New York City Department of Transportation Spatial Data Warehouse, GIS Analyst – Ms. Blanco assisted the DOT with the initial installation and configuration of the ArcGIS software and ArcSDE. She was involved with transitioning DOT to the new version of ArcGIS when the upgrade was released. Ms. Blanco loaded and configured all of the basemap data as well as additional LION boundary files that were provided by DOT to an ArcSDE geodatabase. In addition, she was involved with the design and creation of the ArcIMS web page that is being used as a part of the Data Warehouse project. (11/00 – 12/04) Governors Island Preservation and Education Corporation (GIPEC), Facilities Management GIS Database Development GIS Analyst – Ms. Blanco created and updated building features classes based on digital records and paper maps. The building feature class was enhanced by adding a building number and asset number to the attribute table. This work is being done as a subconsultant to Turner Construction Company. (9/06 – Present) Fire Department New York Thematic Mapping Project, GIS Analyst -To support the Thematic Mapping Project, Ms. Blanco was responsible for the design and implementation of an enterprise GIS system in support of a customized Intranet thematic mapping application. Ms. Blanco assisted by configuring and populating the geodatabase with datasets derived from FDNY data, as well as New York City geographic datasets. The Bowne Team implemented the FDNY hosting environment, which included Oracle 9iAS, and ArcIMS 4.01 (using load balanced spatial servers). This work was completed as part of a subcontract to Plangraphics. (4/03 – 10/05) Blanco resume Page 3 Bowne Management Systems, Inc. ESRI Authorized Training – Ms. Blanco provided ArcView and/or ArcGIS training to the following clients: Energy Environmental Analysis, Water Authority of Great Neck North, Village of Massapequa Park, Long Island Rail Road, Town of North Hempstead; and New York State Department of Environmental Conservation, Village of Garden City, New York City Department of Transportation, New York City Fire Department, Village of Great Neck Water Pollution Control District, Nassau County, Suffolk County, the City of Mount Vernon, Village of Plainview Water District, and the Town of Riverhead. Suffolk County Department of Information Technology GIS User Needs Assessment, GIS Analyst – Ms. Blanco completed the training sections for the Suffolk County User Needs Assessment. She provided a summary of training that had already been provided to the County as well as additional training that should be scheduled in order to prevent the GIS from becoming static. (6/07 – 7/07) Suffolk County Community College ArcGIS Training, GIS Analyst – Ms. Blanco helped the County with its transition to ArcGIS version 9. She provided ArcGIS I and ArcGIS II training courses for Suffolk County employees at the Brentwood Campus of the College. (8/05 – 11/05) County of Westchester Department of Information Technology, GIS Analyst – Ms. Blanco generated raster and vector slope data based on existing 5’ contours. Two percentage of slope increments were created, specifically 15-25% and 25% and greater. Two data formats were delivered: a vector shape file with polygonal data and a raster file with 25’ pixel resolution. (6/06 – 9/07) Village of Matinecock, GIS Analyst – Ms. Blanco generated raster and vector slope data based on existing 2’ contours. Two percentage of slope increments were created, specifically 15-25% and 25% and greater. Two data formats were delivered: a vector shape file with polygonal data and a raster file with 25’ pixel resolution. (4/02 – 2/05) Nassau County GIS, GIS Analyst – Ms. Blanco continues to conduct additional rounds of customized ArcGIS training for Nassau County employees. Additional information pertaining to the new version of ArcGIS (9.2) is included in the course. (9/97 – Present) Ms. Blanco performed maintenance on the Street Centerline file including: Duplicate street names found in the street directory were eliminated. The street centerline file was enhanced to indicate centerline features that represent turning lanes. Address ranges for street centerline data were verified and/or modified based on the Address Points file obtained from NCPD. Topology was created for all street centerline features. Ms. Blanco generated metadata for all feature classes and feature datasets in the Nassau County geodatabase. All of the original metadata was transferred over to the new server and new metadata was created when necessary. Ms. Blanco also assisted in the migration of the geodatabase to a new server. She provided quality control reports and made sure that all data had been copied over. Village of Garden City GIS Implementation, GIS Analyst – Ms. Blanco participated in the design and implementation of a GIS for the Village. Her responsibilities included converting data to digital format; quality control and editing of existing data; creating and maintaining layers such as zoning and parcel centroids; updating utility, infrastructure data and basemap updates for integration into the County database; and loading data and creating ArcView projects for Village use. She has been involved with the Blanco resume Page 4 Bowne Management Systems, Inc. design and implementation of the Tree Maintenance application that has been written for the Village. In addition, she has provided the Village with a “hands-on” refresher course using the ArcView GIS software. (10/00 – 4/02) Village of Babylon Department of General Services GIS Implementation, GIS Analyst -Ms. Blanco participated in the design and implementation of a GIS for the Town. Her responsibilities included converting data to a geodatabase format and creating village datasets. She also implemented a security model to support the data maintenance among Town departments. (3/04 – 6/05) United States Army Corps of Engineers, New York District (Execution of Delivery Orders 25 and 26), GIS Analyst – This project involved the design of an integrated GIS system for the Operations Division and a pilot project for the implementation of an integrated GIS system. The design phase consisted of interviews with the various units and personnel of the NY District, a a formal requirements definite, and pilot project alternatives. The selected alternative was the development of a web-based application that used the Operations and Maintenance (O&M) Division’s Project Book as its primary interface. The pilot allowed viewing scanned documents, project maps and support the integration Microstation DGN files in their native format. This pilot laid the groundwork for the development of an Integrated Spatial Data System (ISDS). (10/01 – 1/04) MTA Headquarters GIS Implementation, GIS Analyst -Ms. Blanco was part of the Bowne Team that designed and implemented the MTA Headquarters GIS Data Warehouse. Her tasks included Oracle/ArcSDE installation in a Solaris environment, the design and build of a GIS security model for MTA Headquarters and the population of a multi-jurisdictional GIS database for MTA. (7/01 – 12/03) MTA/Long Island Railroad, Phase I GIS Implementation, GIS Analyst – Ms. Blanco provided with database design, data conversion, and data loading services. She also provided ArcView Training for LIRR employees. (12/98 – 1/02) MTA/Long Island Railroad GIS Database Maintenance, GIS Analyst -Ms. Blanco provided database design, data conversion, and data loading services. She also provided ArcView training for LIRR employees. (5/01 – 9/02) Nassau County GIS – Ms. Blanco provided quality control of converted ArcInfo data received from the County’s Implementation Contractor. She was specifically involved in loading two data reviews to the County’s central GIS server. She also updated HTML codes, designed an interface, and mentored county employees at the Nassau County GIS helpdesk. Ms. Blanco continues to have a major role in the design and implementation of Nassau’s GIS. Her responsibilities include: • Serve as Administrative User responsible for setting up County User Accounts • Prepare documentation for various applications and projects for County Users • Design and maintain GIS database • Application Design and Development • Prepare and analyze GIS data for various departments • Prepare and load data into ArcStorm and into SDE Blanco resume Page 5 Bowne Management Systems, Inc. Because the County is moving toward upgrading the existing GIS system, Ms. Blanco has been involved with the new database and application design. She is also responsible for reviewing pilot data and the quality control of the new database design and application design documents. (9/97 – Present) Village of Garden City and Hewlett Bay Fire Districts Fire District Mapping, Project Manager – Ms. Blanco created map books for use in every district fire truck. She also created Command Post maps for fire chiefs and large scale wall maps for use in firehouses. Creation of these maps involved converting data into the correct format and preparing grids and subsequent street index. (1/97 – 8/98) ACADEMIC BACKGROUND: M.A. /Geography /University of Connecticut /1996 B.A. /Geography /State University College of New York at Geneseo /1994 LICENSES AND CERTIFICATIONS: ESRI Authorized ArcGIS II Trainer /2003 ESRI Authorized ArcGIS I Trainer /2001 ESRI Authorized ArcView Trainer /1997 CONTINUED PROFESSIONAL DEVELOPMENT: Intro to ArcGIS II v. 8.3 (ArcView 8, ArcEditor 8, and ArcInfo 8) /ESRI /August 2003 Creating and Editing Geodatabase Topology /ESRI /July 2003 Creating, Editing, and Managing Geodatabases /ESRI /July 2003 Introduction to ArcGIS I v. 8.x /ESRI /July 2001 Introduction to ArcGIS II v. 8.x /ESRI /July 2001 What’s New In ArcInfo8 /ESRI /April /2001 Enterprise DBA Part 1A: Architecture and Administration /Oracle Training /2000 Introduction to SQL & PL/SQL /Oracle Training /1998 SDE Administration Instruction /ESRI /April 1998 Adjunct Professor /Long Island University C.W. Post Campus /Fall 1999, Fall 2000, Fall 2001, Fall 2002 Long Island Arc Users Group, Co-coordinator CONFERENCES: ESRI User Conference /2000 CAD/GIS Technology Symposium & Exposition /2000 Northeast Arc Users Group Conference /1997, 1999 AM/FM International Conference, New England Chapter /1995 SOCIETIES AND AFFILIATIONS: New York State Recreation & Park Society, Inc. Association of Towns of the State of New York PUBLICATIONS AND PRESENTATIONS: Blanco resume Page 6 Bowne Management Systems, Inc. A Comparison of the Air Passenger Industry and the Air Cargo Industry with Respect to Hub Locations, University of Connecticut (1996 M.A. Thesis) and The Great Lakes Geographer Vol. 3, No. 2 (1996) Nossa resume Page 1 Bowne Management Systems, Inc. Robert Nossa GIS Analyst I SUMMARY OF PROFESSIONAL LIFE: Mr. Nossa is a member of Bowne’s GIS Group and is experienced in both the design and support of complex IT/GIS environments. Mr. Nossa regularly provides support and mentoring to Bowne’s customer base. He is adept at both desktop GIS issues and the design of server side GIS components. Mr. Nossa is also an ESRI Authorized ArcView, ArcGIS Instructor. CURRENT PROFESSIONAL SKILLS: Development • SQL GIS Environment • ArcGIS Suite (ArcView, ArcEditor, ArcInfo,) 9.x • ArcSDE 9.x • ArcGIS Server 9.x • ArcIMS RDBMS • Oracle 11g, 10g 9i, 8i • SQL Server 2000, 2003, 2008 • Microsoft Access Hosting Environments • IIS • Apache/Tomcat Operating Systems • Windows 2000 Server Family, 2003 and 2008 Server Family, Windows XP and Windows 7 • Redhat Linux Structured Analysis/Design • Microsoft Visio, SQL Developer, Oracle Enterprise Manager Console Office Automation • Microsoft Office Suite, including Project • Crystal Reports REPRESENTATIVE ASSIGNMENTS: Nassau County Police Department 2007 IT and GIS Services, GIS Analyst – Mr. Nossa assisted in the data analysis and design work for various GIS datasets used to support the map-based CAD system. His tasks included meeting and coordinating public safety datasets changes with Fire and Police personnel to ensure execution of proper dispatch response plans. Mr. Nossa also provided Police with updates required in the Master Street Address Guide (MSAG). He also helped designing custom applications to provide updates and quality control to address and street data. In addition, Mr. Nossa assists with providing the County and CAD vendor with monthly GIS data updates to incorporate into the CAD system. (1/07 – Present) New York City DoITT, Citywide Street Centerline Project (CSCL) Phase II, GIS Analyst – To support the City’s Citywide Street Centerline (CSCL) project, Mr. Nossa provided GIS data analysis and database design to help define the process for preparing New York City public safety datasets for map-based dispatch. Mr. Nossa has been involved in constructing and documenting a GIS editing methodology that can be adopted to update NYPD GIS datasets. Mr. Nossa was responsible for the management and oversight in regard to the design, creation, integration and loading of the data into an Oracle SDE Nossa resume Page 2 Bowne Management Systems, Inc. Geodatabase. He used Geodatabase Diagrammer to develop Data Model in Microsoft Visio format to support database design. Mr. Nossa assisted in quality control of data migrated to CSCL geodatabase., Mr. Nossa conducted Knowledge Transfer workshops for New York City DoITT, NYC Fire Department, NYC Police Department, NYC Planning. These workshops provided an overall introduction to the CSCL Data Model and the CSCL Geodatabase. This work was done as part of a subcontract to Hewlett-Packard. (10/07 – Present) New York City DoITT Citywide Street Centerline Project (CSCL) Phase III NYPD ETL, GIS Analyst – Mr. Nossa has been involved in the requirements definition, design and data development for an Extract, Transform Load (ETL) Application to support the transformation of New York City public safety datasets to geographic files to be used in a map-based dispatch system. Mr. Nossa has provided data to NYPD and their Computer-Aided Dispatch software vendor to support support system testing and program development. His intimate knowledge of the Citywide Street Centerline (CSCL) data model and NYPD datasets has helped the construction of a data transformation matrix used to support application development. He also provides quality assurance services. (12/09 – Present) Town of Hempstead Street Lighting Division Street Lighting Information System, GIS Analyst – Mr. Nossa used ESRI’s ModelBuilder to automate the extraction and transformation of GIS data stored in the Nassau County GIS. These Models were designed to create GIS dataset into a format compliant with the Town’s custom GIS Application (10/10 – Present) New York City Department of Finance Digitization of Tax Maps, GIS Analyst -Mr. Nossa was part of the Bowne team working on the City’s DOF data model. Mr. Nossa implemented changes to the geodatabase and provided database design and data loading services. This work was done as part of a subcontract to Bearing Point. (4/05 – 3/08) Town of Islip Planning & Development GIS Implementation, GIS Analyst – Mr. Nossa was part of the implementation team that installed ArcSDE 9.1 in a MS SQL Server 2000 environment. He also assisted in the design and implementation of a custom geodatabase security model and assisted in the loading of data into the Town’s geodatabase. (12/05 – 3/08) Publishers Circulation Fulfillment Corporation (PCF) Geographic Router, GIS Analyst – In this project, Bowne developed a web service called GeoRouter to return delivery data for a given location, client and publication by running spatial and attribute queries. Mr. Nossa provided on-site ArcGIS, ArcSDE based mentoring/training services to PCF’s Logistic’s Unit. He designed and implemented the geodatabase security model and assisted in the loading of data into the PCF geodatabase. (6/06 – 2/07) Nassau County Police 2007 IT and GIS Support, GIS Analyst – Mr. Nossa updates Public Safety geographic files used in the Nassau County Police Computer Aided Dispatch System. Mr. Nossa provides data coordination services between Nassau County Police and Nassau County Fire Communications. He provides a monthly data delivery service of extracting, transforming, and loading public safety, address and reference data to support the loading of updated data in the Police CAD system. (1/07 – Present) Nassau County GIS, GIS Specialist – Mr. Nossa assisted in the County’s SDE upgrade activity by performing data analysis and quality control. He continues to perform basemap updating tasks using aerial photography, record plans, and other data sources and participates in the monthly maintenance activity to update the County’s versioned SDE database. Mr. Nossa has helped design geodatabase security and SDE versioning according to department workflow. Mr. Nossa also assists with the implementation of a custom ESRI ArcGIS Mapping Application and provides one on one mentoring for ArcGIS to personnel in various County departments (Police, Health, Planning, Public Works, and Fire Nossa resume Page 3 Bowne Management Systems, Inc. Communications, Board of Elections). Mr. Nossa was involved in creating a seamless mosaic of raster datasets storing historical aerial photos from 1926 and 1950. In addition, Mr. Nossa has held mentoring sessions on SDE versioning and editing for ArcGIS users. Mr. Nossa recently helped design and deploy a Special Facilities Management Application to develop a Landmark /Emergency Facilities layer for Nassau County. (12/05 – 12/06) Town of Oyster Bay, All Hazard Mitigation Plan, GIS Specialist – Bowne was contracted to prepare an All Hazard Mitigation Plan for the Town of Oyster Bay. Mr. Nossa provided Land Use maps of the unincorporated areas of the Town of Oyster Bay. He also provided performed analysis on parcel data in the Town of Oyster Bay to produce a summary of total land use area in the unincorporated areas. (1/03 – 6/05) United States 77th Army Reserve, GIS Specialist – Mr. Nossa provided database design, data conversion, and data loading services for the 77th Army Reserve. All work was in compliance with the Army’s Spatial Data Standards /Facility Management Standards (SDS/FMS). (9/03 – 8/04) Dow Jones WebGIS System, Database Analyst – Mr. Nossa was involved in developing a ArcSDE geodatabase to support a web based customer marketing geographic information system called WebGIS. Mr. Nossa developed a geodatabase schema and migrated datasets to the geodatabase using ESRI’s ModelBuilder. In addition, Mr. Nossa provided ArcGIS support to Dow Jones personnel. (11/04 – 8/05) Nassau County Planning Department, GIS Specialist – Mr. Nossa helped design and implement an SDE versioning model to support the County Executive’s Economic Development Initiative Project. He coordinated the loading of community and Census data to support the project and then assisted with map production and mentoring of ArcGIS users so they are now capable of operating the system independently. In addition, Mr. Nossa continues to provide map development support, as needed, for Planners Planners within the Department. (6/04 – 2/06) New York City Department of Transportation, GIS Specialist – Mr. Nossa helped train City staff in ArcGIS, the NYCDOT Data Warehouse Viewer and ArcSDE. He was instrumental in constructing a seamless citywide orthophotography raster dataset for use by ArcGIS and Data Warehouse users in NYCDOT. In addition, he was involved with the testing and updating of the ArcIMS web page that is being used as a part of the Data Warehouse project. (6/02 – 12/03) ESRI Authorized Training – Mr. Nossa provided ArcGIS training for the following clients: New York City DOT, New York City Fire Department, New York City DCP, New York City DoITT, Village of Freeport, Town of North Hempstead, Town of Babylon, Massapequa Water District, Town of Greenburgh, Town of Oyster Bay, Town of East Greenbush, Nassau County and Suffolk County. He is an Authorized ESRI ArcGIS trainer. Data and Map Production Services – Mr. Nossa has been responsible for the development of numerous GIS databases and custom map products for a variety of local governments. Typical projects have included development of a zoning coverage and mapping for the City of New Orleans, and customized maps for local villages, fire districts, and water districts. These activities included the design and implementation of datasets for environmentally sensitive lands including: FEMA Flood Maps, Slope Maps, and local street conditions. Village of Freeport Enterprise GIS, GIS Specialist – Mr. Nossa participated in the design and implementation of a GIS for the Village. His responsibilities included conducted a GIS Needs Nossa resume Page 4 Bowne Management Systems, Inc. Assessment for the Village, converting data to digital format, quality control and editing of existing data, and creating village datasets. He also implemented a security model to protect sensitive data. In addition, he has provided the Village with Introduction to ArcGIS I training. (11/03 – 5/05) ACADEMIC BACKGROUND: M.S. /Information Systems /Pace University/2004 B.S. /Information Systems /Pace University /2001 LICENSES AND CERTIFICATIONS: ESRI Authorized ArcView Trainer /2003 ESRI Authorized ArcGIS Trainer /2003 CONTINUED PROFESSIONAL DEVELOPMENT ArcGIS 10 Seminar /ESRI /October 2010 ArcGIS Desktop II: Tools and Functionality /ESRI /January 2010 ArcGIS Desktop III: GIS Workflows and Analysis /ESRI /November 2009 Oracle Database 10g: Administration Workshop I /Oracle University /April 2008 Northeast Arc Users Group Conference /2007 Leadership Training, ACE02 Consulting /2007 Assistant Adjunct Professor /Pace University New York City Campus /Spring 2005, Spring 2007 ArcGIS 9.2 Seminar /ESRI /December 2006 GIS System Design Strategies /ESRI /June 2006 Introduction to ArcGIS II Version 9.x /ESRI /May 2006 ESRI User Conference /2003 /Conference workshops /Displayed a map in the ESRI Map Gallery Introduction to ArcGIS I v. 8.x /ESRI /April 2003 Introduction to ArcGIS II v. 8.x /ESRI /April 2003 PUBLICATIONS AND PRESENTATIONS Using GIS in Planning. Presented at the Fourth Annual Nassau County Planning Federation Training Conference, Old Westbury, New York, October 22, 2009 Nossa, R. "Building Tomorrow's Data Warehouse Today." ESRI Map Book Vol. 19 (2004): 103