Lee Elliot
Dunfermline,Fife
Summary
Accomplished professional with expertise in big data handling, advanced analytics, and stakeholder management. Proficient in Microsoft Office Suite, including Visio, and skilled in SQL expertise and database design. Adept at requirement gathering to drive project success and enhance organisational efficiency. Committed to leveraging analytical skills to support strategic decision-making and achieve business objectives.
Overview
10
10
years of professional experience
1
1
year of post-secondary education
Work history
Business/Data Analyst
Lloyds Banking Group
Edinburgh, Midlothian
06.2019 - Current
- Manage data discrepancies among 30,000 client IDs and verify data integrity to guarantee accurate reporting.
- Extracting and manipulating data from various core Banking systems. Leveraged SQL queries to extract necessary information from databases.
- Identified trends within data sets for valuable business insights.
- Managed strict compliance with GDPR regulations during all stages of data handling.
- Resolved critical business questions by translating them into appropriate analyses and actionable recommendations.
- Engaging with diverse teams and stakeholders at all levels to assess necessary forward fixes, such as client pricing adjustments, alongside cost implications for both client and Bank.
- Stay informed on system rules to guarantee accurate pricing information for customers.
Commercial Analyst
Lloyds Banking Group
Edinburgh, Midlothian
12.2015 - 06.2019
- Contributed significantly to successful delivery of Cheque Clearing system, currently utilised by thousands of banking clients across UK.
- Acted as a liaison between internal teams and large banking clients, ensuring seamless system integration.
- Conducted infrastructure testing to validate compatibility between internal and external systems.
- Identified faults, developed solutions, and presented fixes to stakeholders at varying levels.
- Collaborated within a small local team as part of a larger project group, ensuring coordinated efforts.
- Helped organize and host a client-facing event to showcase products and system capabilities, strengthening industry relationships.
Telephony Business Analyst
Sainsbury’s Bank
Edinburgh
05.2015 - 12.2015
- Leveraged previous experience in telephony and business analysis to support the migration of credit cards and loans books from Lloyds to Sainsbury’s Bank’s standalone platform.
- Led regular discussions with third-party suppliers, conducting business requirement reviews and walkthroughs to align project objectives.
- Engaged in system testing to validate alignment with the current working design. Monitored and managed defects through JIRA, ensuring proper severity assignment and resolution tracking.
- Designed and maintained the Schedule of Events for key telephony migration tasks.
- Documented and gained approval for all platform-impacting work at multiple stakeholder levels.
- Supported the build and configuration of the Verint i360 platform, accelerating the landing of a UAT-ready solution.
- Created and maintained daily stakeholder reports, prioritizing outstanding questions to ensure focus on critical areas.
Education
GDW - Teradata Course - Programming SQL
Lloyds Banking Group
Edinburgh 11.2023 - 11.2023
Outbound Contact 8 Foundation - Contact Centre Best Practices
Genesys University
Stone, England 08.2011 - 08.2011
Operating Outbound Contact 8 - Contact Centre Best Practices
Genesys University
Stone, England 08.2011 - 08.2011
SVQ Level 3 - Information Technology
Carnegie College
Dunfermline 05.1997 - 05.1998
Skills
- Big data handling
- Microsoft Office Suite expertise
- Microsoft Visio
- Advanced analytics
- Stakeholder management
- SQL expertise
- Database design
- Requirement gathering
Timeline
GDW - Teradata Course - Programming SQL
Lloyds Banking Group
11.2023 - 11.2023
Business/Data Analyst
Lloyds Banking Group
06.2019 - Current
Commercial Analyst
Lloyds Banking Group
12.2015 - 06.2019
Telephony Business Analyst
Sainsbury’s Bank
05.2015 - 12.2015
Outbound Contact 8 Foundation - Contact Centre Best Practices
Genesys University
08.2011 - 08.2011
Operating Outbound Contact 8 - Contact Centre Best Practices
Genesys University
08.2011 - 08.2011
SVQ Level 3 - Information Technology
Carnegie College
05.1997 - 05.1998
Similar Profiles
Ankita CampbellAnkita Campbell
Manager, Deloitte USI at Banking and IM - Lloyds Banking Group and Index VenturesManager, Deloitte USI at Banking and IM - Lloyds Banking Group and Index Ventures
Nishant RamNishant Ram
IT Project Manager at American Express, Lloyds Banking Group, Royal London GroupIT Project Manager at American Express, Lloyds Banking Group, Royal London Group
Alfred Cyril ChristopherAlfred Cyril Christopher
Project Manager at Wipro - Lloyds Banking GroupProject Manager at Wipro - Lloyds Banking Group
Shirley O’NeillShirley O’Neill
Founder & Performing Arts Teacher at O’Neill School of Performing ArtsFounder & Performing Arts Teacher at O’Neill School of Performing Arts
Derek McLeanDerek McLean
Amazon Associate at AmazonAmazon Associate at Amazon