Lew Lightfoot
- MI Analyst
- Weston-Super-Mare, Somerset, UK
Personal Summary
I am Lew Lightfoot, a seasoned professional with extensive experience in change programs across UK Government, banking, telecoms, and aerospace sectors. I excel in data analysis, cleansing, and creating management information to support decision-making. My expertise includes developing dashboards and reporting tools using MS Excel, Access, and other software. I am known for delivering solutions that meet stakeholder needs and have a track record of contract extensions due to my performance.
Skills
- MS Excel expert
- MS Access advanced
- MS Office advanced
- Service Now competent
- Visio competent
- MS Project competent
- SharePoint competent
- SAP BW & Business Objects user
- Jira & Confluence user
- Power BI & Tableau basic
Licenses and certifications
- Prince 2 foundation
- ISEB PSO Foundation Certificate
Awards and achievements
- Winner of 2011 Group Operations Programme of the year
- 4 separate Contractor Nominations for exceptional performance at Lloyds Banking Group
Work Experience
Manual analysis of multiple data sources to identify current operational units, revise and align legacy OUs, and deliver a new target hierarchy. Managed data cleansing activities and alignment with multiple dependent systems.
Supported the Senior Leadership team by developing MI and insight solutions, financial forecasting tools, and managing data quality projects. Achieved multiple contractor nominations for exceptional performance.
Provided insight to stakeholders and developed the Defra blended working blueprint. Acknowledged by senior officials for critical support in delivering Project Horizon.
Provided MI solutions and reporting for video mortgage appointments and software upgrade programs. Developed efficient MI tools that significantly reduced reporting time.
Engaged stakeholders and managed business change for a flexible working program. Developed tools for faster definition of divisions' flexible working capabilities.
Led a team of BAs to embed flexible working for 6000 people, winning the 2011 Group Operations Programme of the year.
Analysed resource forecasting and developed a roadmap for process improvement. Engaged with senior management to clarify the roadmap.