Project Objective:
The goal of this project was to develop a unified and linked reporting system for the Design and Construction division of the City of Dallas Park and Recreation Department. This system would streamline updates on financials, construction statuses, and visualizations for over 250 capital construction projects. The project was prioritized by the department director, park board, and City leadership, including the Mayor and Council.
The goal of this project was to develop a unified and linked reporting system for the Design and Construction division of the City of Dallas Park and Recreation Department. This system would streamline updates on financials, construction statuses, and visualizations for over 250 capital construction projects. The project was prioritized by the department director, park board, and City leadership, including the Mayor and Council.
Project Overview:
Dominic, in his role as an internal program manager within the Administrative and Business Services division, was tasked with designing and managing the solution. His responsibilities included coordinating deliverables across a team of two senior program managers, eight project managers, an administrative assistant, and a budget analyst.
Dominic, in his role as an internal program manager within the Administrative and Business Services division, was tasked with designing and managing the solution. His responsibilities included coordinating deliverables across a team of two senior program managers, eight project managers, an administrative assistant, and a budget analyst.
Using the organization’s existing Microsoft Office Suite cloud subscription, Dominic created a comprehensive visualization system within Microsoft Excel. The system was designed to ensure data security and mitigate risks by using manual data pulls linked to shared workbooks, allowing for calculated statuses and visual linear progress tracking.
A project proposal and charter were developed within two weeks, with a sample product delivered within Dominic’s first 30 days. Incremental updates were delivered every 20 days to accommodate the heavy data load and limited resources, culminating in detailed visual statuses for all projects.
Deliverables:
The final deliverable was a master spreadsheet with printed margins, detailing financials and visual progress for all 250+ construction projects. The solution included:
The final deliverable was a master spreadsheet with printed margins, detailing financials and visual progress for all 250+ construction projects. The solution included:
∙ Linked workbooks with manual data pulls for security.
∙ Status calculations based on project milestones and timelines.
∙ Visual linear progress indicators for high-level reporting.
This system enabled leadership to easily view project statuses and expenses without direct inquiries to individual project managers.
Challenges and Solutions:
Dominic managed challenges related to heavy data loads and resource constraints by implementing an incremental delivery approach. His innovative use of existing software ensured timely project completion while maintaining data integrity and security.
Dominic managed challenges related to heavy data loads and resource constraints by implementing an incremental delivery approach. His innovative use of existing software ensured timely project completion while maintaining data integrity and security.
Outcome:
The project was delivered on time and received high praise from the department’s leadership. It provided an efficient, high-level reporting tool that enhanced transparency and decision-making within the Design and Construction division.
The project was delivered on time and received high praise from the department’s leadership. It provided an efficient, high-level reporting tool that enhanced transparency and decision-making within the Design and Construction division.
