Challenge
Regional and corporate teams lost hours every week to scattered spreadsheets, duplicated venue master data and email back-and-forth. There was no single source of truth, no role-based access and no self-service for 50 sites.
Objective
Design and deliver — end to end, as sole owner — one internal web platform that unifies the venue master directory, a project/roadmap viewer for managers, staff scheduling and a structured Q&A flow, ready to run on the company's Microsoft 365 stack, in 8 weeks.
Approach
- Wrote the product vision and scope; set one master file as the single source of truth feeding every screen through an automated pipeline — zero duplication.
- Built role-based access (corporate vs. site managers) with account-based identity, SSO-ready for the corporate directory.
- Designed dropdown-driven data entry (departments, scope, venues by SAP code, management regions) so any change reflects instantly across the manager-facing hubs.
- Designed a low-code "local-replica-equals-production" setup on Microsoft 365 (SharePoint Lists + Power Automate) and wrote the deployment runbook for a clean hand-off to IT.
- Ran my own QA/QC like a senior delivery team: end-to-end verification, data integrity, accessibility and responsive checks.
Results
