Optimizing Warehouse Operations: The Impact of PMO and Data Visualization on New Builds, Retrofits, and Expansions

This thesis paper analyzes the critical role of project management offices (PMOs) and data visualization techniques in improving the operational effectiveness of first-mile warehouse operations. The research begins with a review of current literature on PMO functionality and the strategic use of data visualization and dashboards, laying a theoretical foundation that emphasizes the importance of these tools in managing complex logistics projects. The research then moves to a practical examination in the context of Amazon's European Global Engineering Services PMO, focusing on my direct contributions as a Project Manager and Business Analyst. As Project Manager, my main project was to significantly expand the scope of our team's projects by developing from scratch a new reporting framework for External Fulfilment projects. This effort aimed to simplify project oversight and improve strategic decision-making capabilities. Simultaneously, in my role as a business analyst, I focused on improving data quality and automating the retrieval of critical information to support the team's operational needs. This aspect of my work involved implementing advanced data management and visualization tools such as SQL, Tableau, and Amazon QuickSight. By moving from Tableau's static reports to QuickSight's dynamic dashboards, I facilitated the updating and accessing of data in real time, significantly impacting the team's ability to make informed decisions quickly. This thesis illustrates how integrating PMO facilities with sophisticated data visualization tools can substantially improve the management and operational efficiency of logistics projects, particularly in the dynamic environments of new construction, retrofits, and expansions. The results highlight the transformative potential of these integrations in optimizing first-mile logistics operations, ultimately contributing to the broader field of supply chain management and operations research.