Laserfiche WebLink
Grant Thornton Public Sector LLC City of Santa Ana | RFQ 21- 093 <br /> Revised Proposal <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 />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 /> <br />2.4.2 Provide assistance with preparation of ARPA (SLFRF) compliance reports <br /> <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 />both internal and public facing <br />dashboards for public sector clients <br />throughout the country. Grant Thornton <br />takes a unique approach to developing <br />dashboards by taking a collaborative <br />and business focused approach. Our <br />team will meet with senior leadership to <br />thoroughly understand the City’s goals <br />and objectives and develop meaningful <br />Key Performance Indicators (KPIs) <br />related to the City’s Performance <br />Management Initiatives. Our data and <br />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 />capability to take geospatial <br />approach to our grant <br />management analytics. <br />This approach takes Grant <br />Management reporting to <br />the next level by <br />transforming static, tabular <br />data into visually appealing <br />maps letting the users <br />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 />Figure 3. Example of Executive Dashboard <br />Figure 2b. Example of Broadband Equity Dashboard