Duval County Public SchoolsProject Controls Manager
Feb. 2025United States, JacksonvilleOversee financial controls and reporting for a $2.9 billion school construction program funded by a voter-approved ½¢ sales-tax; partner with board officials, City Council, and taxpayers to ensure transparency and compliance.
● WBS Reconciliation & Reporting Tools: Architected a custom HTML-based WBS Reconciliation tool to automate variance analysis (budget vs. forecast vs. actual) between SAP Finance and Kahua PMIS, enabling real-time visibility across all projects; Developed a macro-driven Excel workbook that generates dynamic pivot tables and formatted variance reports for the Finance Director and School Board, significantly reducing manual report preparation time.
● Stage-Gate Process & Approval Readiness: Defined key Stage-Gate deliverables and designed an Approval Readiness checklist to standardize phase-gate reviews for Construction Project Managers, ensuring consistent criteria and reducing approval cycle times.
● SAP Integration & Vendor Compliance: Leveraged SAP S/4HANA financial interfaces to drive end-to-end budget reconciliation and vendor compliance tracking across $2.9 billion in capital projects, enhancing fiscal accountability and reporting accuracy.
● Dashboards & Data Visualization: Built and maintained interactive Power BI and SharePoint dashboards (Power Query-backed) to surface key financial-health metrics—order-to-payment cycle times, spend vs. plan variance, vendor performance—empowering stakeholders to make data-driven decisions.
● Governance & Strategic Guidance: Designed SOPs based on a hybrid PMO governance framework for civil-service and construction operations; facilitated regular consultative sessions with Project Managers and the Executive Program Director to optimize resource allocation, enforce SOX controls, and mitigate GRC risks.
● Change Management & Training: Created a centralized SharePoint resource center to onboard staff on Kahua PMIS, SAP, and advanced Microsoft 365 tools—authoring user guides and delivering live training sessions to boost system adoption and productivity