Problem:
A large, multi-program, revenue-critical division lacked structured, system-level visibility into labor allocation, skill distribution, and forward workload forecasting. Workforce planning relied on disconnected spreadsheets and manual reconciliation, creating risk in cost estimation, contract bidding, and delivery capacity planning at scale.

Scope:
Enterprise workforce planning across 800+ staff supporting 9 large scale programs and 100s of concurrent projects. Required integration of labor tracking, skills metadata, and financial data into a unified reporting and forecasting system aligned with contract obligations.

Approach / Skills:
Led requirements gathering and end-to-end design of a SharePoint-based labor forecasting platform using structured SharePoint Lists as a relational front-end database layer.

Designed monthly and quarterly forecasting workflows tied to deliverables and contract scopes. Built a structured staff skills inventory database, including survey instruments and manager validation processes to support resource matching.

Modeled data relationships between new SharePoint data sources and existing data sources using ERDs and collaborated with IT and ensure accurate reporting flows for new PowerBI reporting dashboards used by Program Managers, Executive Directors and Finance Managers to make coordinated, data‑driven decisions about staffing, labor allocation, and program capacity. Led system implementation, debugging, validation, rollout, and end-user training.

Applied data modeling, enterprise systems thinking, stakeholder facilitation, BI reporting design, and cross-functional technical coordination.

Results:
Established the first integrated labor forecasting and skills intelligence system across programs. Improved bid accuracy, increased staffing alignment precision, reduced manual reconciliation, and enabled leadership to make data-driven resource decisions within a regulated, multi-contract environment.