After a successful five years in the Office of Budget, Dominic promoted over to the Park and Recreation Department within the City of Dallas. Working in the Administrative and Business services division as an internal program manager, Dominic was immediately tasked with managing multiple financial and status reports for the Design and Construction division. This project was of high priority to the department director, the park board, and Mayor + Council. The objective of the project was to create a unified and linked reporting system that would update financials, constructions statuses, and visualizations.
Dominic's responsibilities included managing the timeline of deliverables of two senior program managers, eight project managers, an administrative assistant, and a budget analyst. In addition, Dominic was tasked with finding, creating, and managing the solution for the director.
Using the organization's already purchased cloud subscription to Microsoft Office Suite, Dominic created visualizations using Microsoft Excel. Linking his project spreadsheet to two other copy workbooks for data security - the workbooks included copies of main spreadsheets to primary shared workbooks. Each spreadsheet copy required a manual pull of data (for risk mitigation and data security) and the final spreadsheet calculated formulas based on statuses and dates. The calculations then fed the data visualization linear statuses. The proposal and project charter were developed within 2 weeks. A sample product was submitted within Dominic's first 30 days working the project. Due to the heavy data load and extremely limited resources for the final product delivery -- Dominic delivered project increments every 20 days until all capital construction projects had their own visual status.
The overall deliverable was a spreadsheet with printed margins detailing each of the two-hundred fifty plus projects and their individual statuses. This project was then submitted to two assistant directors and the department director. The project received high praise and has allowed leadership to view project standings and expense statuses from a high level without inquiring directly from individual project managers.
