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