Doug Hahn

Projects

Planned divestment: 200% return on income through collaboration

Responsibilities:

  • Schedule Development
  • Budgeting
  • Data Visualization
  • Collaboration
  • Roadmapping
  • Motivation
  • Smartsheet

Outcomes:

The company realized a 200% return on income in ¼ time frame.

Case study

Optimizing Decisions Over a Year-Long Closure#

I worked in close collaboration with various leaders to determine scope, timeline, and milestones for a divestment project that would occur over the course of three months, 6 months, or a year. Our aim was to close a plant safely while maximizing return on income within the shortest possible time frame.

Gantt chart & work breakdown structure
Gantt chart & work breakdown structure

To achieve this, I worked closely with subject matter experts to understand the scope of the project and milestones. As this was a distillery certain pieces of equipment needed leads and lags to be properly shut down and cleaned.

After creating detailed timelines for all three scenarios, I implemented a Smartsheet that automated budget calculations based on a variety of salary load outs. I created this system with 100% customizable workforce load-outs that company leaders could use easily. This meant leaders could populate roles on the sheets to estimate costs. This fostered collaboration and allowed us to forecast finances and make informed decisions. We saved the company on labor costs while giving them peace of mind that the closure could be achieved safely and within constraints.

A scenario load out with a pick list for staff
A scenario load out with a pick list for staff

Collaboration with Modern Tools#

By using modern, collaborative, and user-friendly project tools I helped company leaders make value-driven decisions during a challenging closure phase. As a result, the plant successfully transitioned and realized a 200% return on income in one quarter of the initially anticipated time frame. While this project was financial success, it also demonstrates the power of effective collaboration and strategic decision-making.

My Work

Joined the Lab in 2023 in the Office of Strategic Communications; promoted to lead the web team in 2024.

LLNL: Web Editor and Content Strategist 2023–24

I was embedded with executives in the Director's Office, advising on the Lab Director's email campaigns and the mission language on the LLNL website.

Private Consultant2010–23

A distillery's full lifecycle, from earning community support to divestment.

Volunteer2006–present