Remember to demonstrate empathy for your customer in your response. Interviewers appreciate candidates that are able to connect properly and show understanding as their customers react to difficult news. Also, be sure to describe any steps you took to ameliorate the situation such as the implementation of stop-gap measures.

"I work for a retail company that owns several major clothing stores. I am a program manager for the teams assigned to integrate the inventory systems of the various brands. Initially, each store had a separate inventory management system. Our corporate senior management decided that we needed to streamline the systems and the vendors involved. My team was assigned to develop a plan to get us there.

I worked with our IT Business Consultant, several senior analysts, architects, and senior engineers to review the systems used by each business unit. We partnered with the various IT groups responsible for the development, maintenance, and support of each solution to learn the high-level features and define a roadmap to bring everyone onto NetSuite ERP. It became apparent very quickly that there was a large number of complex customizations that would need to be accounted for. Many of the gaps represented functionality the business users perceived as mission-critical.

I led the presentation to deliver the news that the inventory management system consolidation initiative would be a multi-year and costly process that would cause a significant impact on the workflows of the groups that weren't currently using NetSuite. The steering committee was not thrilled with this news and wanted examples to prove my assertion. I walked them through scenarios and estimates backed by each of the teams we met with. I also presented a technical diagram outlining all of the customizations and framework differences. I let them know I understood their disappointment, but that our team had some ideas about how we could bridge the systems together in a cost-effective manner.

We outlined a proposal to move the groups with the most compatible requirements to NetSuite. Additionally, we proposed standing up a data lake to bring the inventory-based data into a central location. We could then use the data to write integrated reports on the fly. This proposal would require us to hire several business intelligence analysts and a few reporting engineers, but it would allow us to reduce our vendor footprint and deliver the analytic reporting needed to make the level of business decisions that were initially driving the program in the first place."