Established an online Bill of Properties for the Program team to forecast workload into shops. Integrated into workload models, audited for changes, and used to facilitate dialogue and vet priorities between program teams.
SharePoint, Microsoft Flows
Developed a centralized risk tracking and management application for the PMO team that streamlined risk identification, tracking, and reporting, improving visibility and proactive risk mitigation.
Power Apps, Power BI, SharePoint
Created a forecasting system in Microsoft Project for a GM job shop using Mountain charts to model incoming work, enabling critical resource and scheduling decisions while replacing a retiring Tableau tool.
MS Project
Designed a portal that standardized incoming job requests with automated approval workflows, increasing consistency and improving communication across departments compared to previous manual methods.
SharePoint & SharePoint Designer
Built a scheduling system for managing workloads by resource and machine, providing project status visibility and support for proactive schedule adjustments in a large, productive shop.
SharePoint & SharePoint Designer
Automated the creation, labeling, printing, and archiving of shipping documents for thousands of parts, greatly reducing manual labor and improving team work-life balance.
Excel, MS Access, SharePoint
Developed an online interactive tool using SQL Server and Visual Basic for hierarchical system requirements management, enhancing traceability and reducing redundancy for academic research.
SQL Server, Visual Basic