Lloyds Banking GroupConsolidation Forecasting Senior Manager
Mar. 2019 - Mar. 2020London, United Kingdom- Financial and Capital Markets analysis to provide hedging recommendations
- Presenting forecasted Budgets to Senior Stakeholders, accompanied with financial analytics for both internal planning and reporting (including Treasury) and external reporting (including PRA)
- Managing the Savings Analytics Squad, providing fast analytics and delivering regular financial reporting to Senior Leadership Team
- Leading the Quarterly forecasting on the Group’s Savings Balance Sheet (over £150bn) and Net Interest Margins
- Implementing Pricing Change decisions, affecting forecasted Net Interest Margins of the Group
- Consolidating an executive-level view of the Personal Current Account and Savings Deposit Balance Sheet and 4 Year Operating Plan (over £250bn)
- Managing a team of 3 Junior Forecast Managers and 2 Graduates SME on Savings and PCA Machine Learning and projects
- Steering Machine Learning Product Roadmap Refinement sessions Training forecasting team on the use of Tableau
- Daily complex SQL queries
- Radicalised Customer Behaviour analytics within the Savings department
Software used: SQL, Python, Group Data Warehouse, Excel, Tableau, Microsoft Office, JIRA, Google Analytics, PowerBi, Alteryx, Microsoft Access, Microsoft Teams, Business Objects