In my previous role, I analyzed the procurement process which was fraught with inefficiencies and delays. I mapped out the current workflow, identified bottlenecks, and proposed a streamlined process involving automation of data entry and real-time tracking. This reduced processing time by 30% and cut down on errors significantly.

I start by thoroughly understanding the company's strategic goals. During analysis, I focus on metrics that directly support these objectives. For instance, if the goal is to increase market share, I would analyze processes affecting customer acquisition and retention. I also collaborate closely with stakeholders to ensure alignment and gather insights into their needs.

I utilize a variety of tools such as Microsoft Excel for basic data manipulation, Tableau for data visualization, and SQL for database queries. I also apply methodologies like Lean and Six Sigma to identify process improvements. These tools and methodologies help in making data-driven decisions and optimizing business processes effectively.

I address resistance by involving stakeholders early in the process, explaining the benefits of the proposed changes, and addressing their concerns directly. I also provide training and support during the transition to ensure a smooth adoption. By demonstrating the tangible benefits of the new process, resistance is typically minimized.

During a project, we encountered unexpected data discrepancies that threatened the integrity of our analysis. I quickly adapted by implementing additional data validation checks and sourcing supplementary data. This flexibility ensured the accuracy of our findings and allowed us to proceed with confidence in our recommendations.