Stephen O'Dell

Performance and BI Analyst with over 15 years experience in the financial services sector.

EXPERIENCE 

• Creates and manages complex data visualisation projects using advanced Excel skills, Power Query, SQL and Microsoft Power BI to enhance Supply Planning process and improve business decision-making and identify opportunities. 
• Identifies and implements Continuous Improvement opportunities across Spans of Control and Supply, sharing best practice and helping embed an improvement culture. 
• Leverages extensive knowledge of data analysis tools to streamline MI development processes and enhance productivity. 
• Develops and implements data-driven allocation strategies to investigate 

Performance Analysis & Insight Assistant, Lloyds Banking Group: Apr 2017 - Feb 2022 

• Creation and support of Pipeline management, analysing the flow of lending leads within both Telephony and Branch based teams to accurately evaluate commercial performance across business banking.
• Production, delivery and analysis of critical MI using advanced Excel and SQL to support key business functions and enhance operational performance. 
• Presentation of weekly KPI dashboards to senior stakeholders, providing insights and actionable recommendations to drive business outcomes. 
• Conducts data audits and data cleansing to ensure accuracy and 

Operational Insight Analyst, Lloyds Banking Group: Feb 2016 - Apr 2017 

• Managed and integrated large datasets using Excel for efficient reporting. Analysis of various KPIs within the telephony network including needs met information, call handling efficiency and shift planning. 
• Utilised my problem-solving skills to design innovative MI reporting solutions, enhancing the overall effectiveness of the reporting. 
• Development and production of data-driven reports and dashboards that engage senior stakeholders with meaningful insights to support informed decisions and continuous improvement. 
• First point of contact for incident management, scheduling conflicts, and service continuity resolution in a high-pressure contact centre, ensuring swift issue triage and minimal disruption to operations.

• Production and analysis of regular compliance MI for UK-wide operations, supporting governance forums with clear, actionable insights to ensure regulatory adherence and mitigate risk.

• First point of contact for the Training & Competencies Framework, streamlining communication, clarifying policy interpretation, and supporting managers in embedding best practice across teams. 

• Implementation of site-level test plans to validate adherence to group policies and standards, ensuring robust compliance and reducing operational risk.

UNIVERSITY OF STRATHCLYDE, AUG 2006 - DEC 2011 

Bachelor of Arts Finance & Management Science

Minor: German, Business Law