Agenda Packet_2022-12-20 - Laserfiche WebLink

Home Browse Search

Grant Thornton Public Sector LLC City of Santa Ana I RFQ 21- 093 Revised Proposal Subrecipients), the scope and funding allocations provided by FEMA, managing the execution of subgrant agreements with the local governments; providing project oversight and quarterly reporting to TDEM and FEMA; reviewing compliance with FEMA program requirements; and providing reimbursement recommendations to TDEM based on authorized expenditures and compliance with procurement processes. 2.4.2 Provide assistance with preparation of ARPA (SLFRF) compliance reports As discussed in the October 28, 2021 interview, the City will have access to Grant Thornton's complete data analytics team to receive feedback on the City's dashboard. Grant Thornton has deep experience in 2muts Management Executive Summary Dashboard developing, deploying, and maintaining both internal and public facing dashboards for public sector clients Total Obligations Federal Obligations Non -Federal Funding throughout the country. Grant Thornton $3,337,827,981 $744,292,889 $7,903,358 takes a unique approach to developing dashboards by taking a collaborative L_ and business focused approach. Our Top 10CFDAltemsbyF ndmg Top 1OAwarding Agen esbyFunding FundingAll—tio� team will meet with senior leadership to thoroughly understand the City's goals and objectives and develop meaningful °m3M Key Performance Indicators (KPIs) 36, related to the City's Performance Management Initiatives. Our data and Figure 3. Example of Executive Dashboard analytics team leverage a hierarchical, drill -down approach to building dashboards. We have experience building executive summary dashboards that provide senior leadership with a one -stop, at a glance view to see total ARPA funds, where the funds are being distributed, and to which agency. An example dashboard we have developed for other clients is shown in Figure 3. We also have the ability to develop dashboards at the Performance Management Initiative level. Typically, these initiatives are tied to the State's Strategic Plan (e.g., Broadband, Economic Development, and Sustainability). We have experience collaborating with the Program Managers to develop high level KPIs to monitor stimulus funding activity. We have integrated dynamic drill down capabilities which allows the users to research various metrics such total obligations, budget requested, funding approved, and amount disbursed. Grant Thornton also has the Households capability to take geospatial Median HHI approach to our grant g1 6 M & $54'8k management analytics. This approach takes Grant ■ With Broadboand Management reporting to ` Households RaGa1 re kd° the next level by -AL � 329.4k transforming static, tabular data into visually appealing Below Poverty Level maps letting the users Figure 2b. Example of Broadband Equity Dashboard clearly identify where their projects are located. Our maps are integrated into interactive dashboards that allows the users to drill down and analyze data by boundaries such as congressional districts, zip codes, and census tracts. Additionally, we apply layers to the map to transform data into information that allows the users to generate actionable insights. Examples of applicable layers include COVID case counts and racial/demographic data to show equitable distribution of ARPA funds. Grant Thornton's Data Analytics team is comprised with experienced and highly educated data scientists and analysts with a specific skill set for storytelling with data and has developed various business intelligence and data visualization dashboards for state and local government agencies. Additionally, our eftyrC6 fiaof data contained on this sheet is subject to on the title page of this propca��/20?2f®t2r2. 2