CTR064771_Contract_Amendment_10.pdf

ARIZONA DEPARTMENT OF TRANSPORTATION

1655 W. Jackson Street, MD 100P

Phoenix, AZ 85007

Contract Amendment Summary CONTRACTOR: HDR Engineering Inc AMENDMENT NO.: 10 DESCRIPTION: P3 Program Management Services – State Funded

Rev. 11/2024

Pursuant to the Uniform Terms and Conditions, Section 5, Contract Changes, the above referenced contract is amended. Summary of changes is as follows:

1. The following Key Personnel are hereby added:

HDR Engineering Inc:

Ryan O’Keefe, Planner Joe Macaulay, Senior Planner Siri Simons, Senior Planner

2. All other terms, conditions and provisions of this contract remain unchanged.

hdrinc.com

20 E Thomas Road, Suite 2500, Phoenix, Arizona, 85012-3118 T 602.522.7700 F 602.522.7707

SENT VIA EMAIL: bbrenden@azdot.gov

December 20, 2024

Arizona Department of Transportation Attn: Bambi Brenden, Senior Procurement Specialist 1655 W. Jackson Street, MD 100P Phoenix, AZ 85007

RE: ADOT P3 Program Management Services Contract No. CTR064771 (State Funded) and CTR064774 (Federal Funded)

HDR requests ADOT approval for additional staff on these contracts.

Firm Staff Contract Classification Proposed Rate ($)

Project Role/Responsibilities

HDR Ryan O'Keefe Planner 155 NEVI Program Support

HDR Joe Macaulay Senior Planner 180 Engineering/Design

HDR Siri Simons Senior Planner 235 NEVI Program Support

Resumes are attached for each individual. Please feel free to contact Ben Spargo at 602-770-6620 or ben.spargo@hdrinc.com if you have any questions.

Sincerely, HDR Engineering, Inc.

Aaron Meilleur, PE Senior Vice President/Area Manager

Attachments: Resumes

EDUCATION

Bachelor of Arts, Political Science, MN State University - Moorhead

INDUSTRY TENURE

22 years

HDR TENURE

4 years

OFFICE LOCATION

St. Louis Park, MN

Ryan O’Keefe Database & Qualitative Analytics Coordinator

Ryan O’Keefe is a Database/Qualitative Analytics Coordinator for HDR in the Strategic Communications group. In his current role, Ryan is focused on helping clients manage social and political risks associated with infrastructure development through efficient and flexible collection, management, and analysis of stakeholder engagement data. He empowers his colleagues by developing, documenting, and implementing consistent data practices, and by training and educating staff and clients on using and customizing our data management system and tools. Prior to joining HDR, Ryan served in a variety of roles at the Minnesota Department of Transportation where he worked on performance measures and risk analysis, agency business planning, pavement project selection, and most recently document automation and continuous improvement.

Ryan received his B.A. in Political Science from Moorhead State University, and his public sector experience includes the Minnesota Departments of Transportation and Corrections, the Minnesota House of Representatives, the Minnesota House DFL Caucus Field Team, and the Moorhead City Manager’s Office.

SELECT EXPERIENCE

PUBLIC ENGAGEMENT DATA MANAGEMENT

Comment/Stakeholder Mgmt. Databases, Various Projects, and Locations – Database Coordinator.

HDR has adopted Zoho CRM as its standard stakeholder and comment management database platform. Ryan advises project teams on the appropriate subscription level and customizations to cost effectively support project objectives. Ryan sets up and customizes the databases, provides user training, and supports users throughout database’s life and has initiated over 35 project databases since joining HDR and supports several existing databases. In addition, Ryan supports the databases by cleaning, transforming, and analyzing stakeholder contact and survey data as requested.

Ramsey County, Riverview Corridor Stakeholder Mgmt. System, St. Paul, MN – Database Coordinator.

HDR is supporting Ramsey County’s oversight of their Riverview Corridor transit planning by building a stakeholder management system on the Quickbase platform to track the issues identified by key stakeholder groups and the disposition of those issues, meeting planning and agenda development, document review and sign-off, and control document distribution. Ryan is co-developing the customization and will maintain it and support users upon completion.

Capitol Corridor Joint Powers Authority, South Bay Connect, Oakland, CA

– Database Coordinator.

CCJPA is proposing to relocate passenger rail services to a different corridor to improve service and further separate passenger and freight rail. In addition to supporting the stakeholder database, Ryan leveraged Zoho SalesIQ to provide a

RYAN O’KEEFE

live-chat experience during a recent virtual open house that directly fed data into the stakeholder database.

ONLINE DASHBOARD DEVELOPMENT AND MAINTENANCE

Ameren Missouri, Smart Energy Plan, St. Louis, MO – Database Coordinator and Data Analyst.

Ameren Missouri has embarked on an effort to modernize its energy grid and HDR is supporting this effort with individual outreach to impacted residents and landowners. In addition to supporting the stakeholder database, Ryan created an internal dashboard on the Zoho Analytics platform to help project team members track customer outreach efforts.

Sarpy County, Platteview Road Expressway, La Platte, NE – Database Coordinator and Data Analyst.

Sarpy County contracted HDR to design a four-lane expressway along an approximately 8-mile stretch of Platteview Road. In addition to setting up the stakeholder management system in Zoho CRM, Ryan co-developed an interactive Power BI online dashboard that summarizes the project outreach efforts and stakeholder comments.

TX Dept. of Transp., Border Transp. Master Plan, Texas/Mexico Border, TX

– Database Coordinator and Data Analyst.

This multi-national effort between TxDOT, the Border Trade Advisory Committee and U.S. and Mexican agencies will identify the cross-border challenges of moving people and goods and will analyze current and future transportation needs and strategies. In addition to supporting the stakeholder database, Ryan supported the project by maintaining and revising an internal project dashboard built using Zoho Analytics as needed.

SURVEY AND RESEARCH DATA ANALYSIS

Jefferson County Public Libraries, Southern JC Library Expansion Survey Analysis, Denver, CO – Data Analyst.

Jefferson County is engaging the public with their plans to build a new destination library in southern Jefferson County. Using Power BI desktop, Ryan build data preparation queries and a data model to analyze the data and to build attractive visualizations for inclusion in the project outreach report.

MN Dept. of Transp., 2020 Connected & Automated Vehicle Statewide Survey, St. Paul, MN – Data Analyst.

As part of MnDOT’s efforts to gauge the familiarity, understanding and concerns of Minnesotans about connected and automated vehicles, HDR facilitated a large statewide survey. Ryan built data transformation queries and a data analysis model in Excel using Power Pivot and Power Query to summarize results and interactively analyze them.

FL Dept. of Transp., Brooks Bridge Replacement Online Meeting Analysis, Fort Walton Beach, FL – Database Coordinator and Data Analyst.

The Florida Department of Transportation is gathering public input on the design of a replacement of the Brooks Bridge in Fort Walton Beach. In addition to setting-up the stakeholder database, Ryan built data transformation queries and a data analysis model in Excel using Power Pivot and Power Query to summarize results and interactively analyze them.

RYAN O’KEEFE

WI Dept. of Transp., Connect 2050 Long Range Transportation Plan Update, Madison, WI – Data Analyst.

As part of its long-range transportation plan update effort in 2020, the Wisconsin Department of Transportation gathered public input through a large online survey as well as through several other channels. Ryan built data transformation queries and a data analysis model in Excel using Power Pivot and Power Query to summarize results and interactively analyze them.

WY Dept. of Transp., 2021 Statewide Transp. Improvement Plan Update, Cheyenne, WY – Data Analyst.

The Wyoming Department of Transportation solicited input from the public as part of its 2021-2026 STIP update. Ryan built data transformation queries and a data analysis model in Excel using Power Pivot and Power Query to summarize results and interactively analyze them.

Centralina Regional Council, Connect Beyond Regional Mobility Initiative Online Meeting, Charlotte, NC – Database Coordinator and Data Analyst.

The Centralina Regional Council is conducting a 2-year community engagement process to understand the Charlotte, NC region’s transportation challenges and opportunities. In addition to setting-up and supporting the stakeholder database, Ryan built data transformation queries and a data analysis model in Excel using Power Pivot and Power Query to summarize survey results and interactively analyze them.

MN Dept. of Transp., 2016 Statewide Multimodal Transp. Plan Public Engagement Data Eval., St. Paul, MN – Data Analyst.

In preparation for the next SMTP update, the agency contracted with HDR to analyze comments submitted during the plan’s last update. Ryan coordinated the review and categorization of approximately 3,500 wide-ranging comments about all aspects of transportation and its impacts in Minnesota. Useful categories were created and refined by Ryan and his team throughout the review process and delivered to the client for their feedback and guidance.

Tampa Hillsborough Expressway Authority, South Selmon PD&E Study, Tampa, FL – Database Coordinator and Data Analyst.

The Tampa Hillsborough Expressway Authority is conducting a Project Development and Environment study to determine social, economic, natural, and physical environmental impacts associated with their proposed South Selmon extension. In addition to setting-up and supporting the stakeholder database, Ryan built data transformation queries and a data analysis model in Excel using Power Pivot and Power Query to summarize survey results and interactively analyze them.

PROJECT TASK MANAGEMENT

MN Dept. of Transp., Traffic Safety Eval., Roseville, MN – Data Collection Task Lead.

The agency contracted with HDR to evaluate the safety impact of various policies and treatments on its transportation network. Ryan is serving as the data collection task lead for the project, charged with identifying, resolving, and documenting data collection and processing questions and concerns.