Early Problem Debt Manager

Lead SAS/ SQL Analyst for Debt Sale of Recoveries stock to Debt Purchasers.Automation/ Simplification/ Clarity of Debt Sale code (over 10k lines) to remove requirement from 4 Analysts to 1 to ensure sales achieved within timescales.Governance of Debt Sale process to reduce risk, audit satisfaction, queries, no reputational breaches and better pricing from Debt Purchasers.First ever sale of Business Banking stock, complete end to end process creation, portfolio selection, stakeholder management.BIS Encryption/ Enterprise Guide UAT for Athena changes.Recoveries stock model proposal, code creation, UAT and production to allow for planning of Debt Sale strategy.Data Quality (completeness, accuracy, timeliness, validity) analysis, IVA stock allowing for 50%+ stock availability for sale.Mentoring/Training of Junior Analysts on SAS for good code practice and automation.DMO access control guidelines for prevention of essential data deletion.Sampling/ UAT/ Scenario Based Testing code creation reducing manual checking from 5% to 1%.Deputising for Manager on Paternity Leave.Steering Group/ Exco Paper creation providing insight to achieve Debt Sale plan, Vision and Strategy.

Ad hoc/regular data analysis, interpretation & investigation of Mortgage / Home Insurance Data by extracting and analysis using SAS/ Business Objects/ Excel. Insightful MI to analysis and spotlight sales/ cancellation trends/ product penetration.Preparation and development of Regular MI reports including volume/KPI/Differential/Sales Funnel/ Exco dashboards using all key skills with significant improvements automating reporting suites ensuring fit for purpose.Strong project/ stakeholder management skills used/ developed to high level. Wide range of stakeholders: IT/ senior management/ 3rd party companies.Chair/Lead/Participate in meetings and presentations using my strong presentation skills.Delivery of Ulster data and reporting for Home Insurance MI.Rebuild of Insurance MI SAS batch from scratch removing significant manual intervention/risk adding new insights/perspective,data reconciliation and removing 20+ redundant reports.Excellent Project skills on new Home Insurance datasets, requirements, data specifications inc. Data Dictionary.Mentor of Junior Business Analyst developing soft and technical skills and training frontline users on Business Objects.Recently trained on SAS VA/ Teradata.

System management of Anti Money Laundering programs.

• Ad hoc/regular data analysis & investigation of Wholesale Data/User Management by extracting and analysis using SAS/ Business Objects/ Excel/Access. • Preparation of Regular MI reports by analysis/production & development using all key skills, including development of Service Pack with metrics for control of Wholesales Business Intelligence Repository.• Management of user access (300+ users) to Wholesales Business Intelligence Repository. • Training/mentoring users in data familiarization/SAS/Business Objects, technical/setup.• Led/managed 70 colleagues in LBG Charity initiative, motivating 14 Team Leaders across many activities. Involved planning, visibility, leadership and ‘rallying the troops’. Personal praise received from Head of LBG Wholesale for my Leadership/Management of largest single project.• Strong stakeholder management skills used/ developed to high level developing SAS data access and functionality. Wide range of stakeholders from IT to senior management. • Chair/Lead/Participate in meetings and presentations using my strong presentation skills.• Lead role in design and Implementation of Sarbanes Oxley access controls, leasing with PWC & Ernst & Young/ Internal Audit.• Supporting business requirements alongside Senior Manager for future SAS usage with key stakeholders in Risk to develop and implement changes to improve capability of SAS to Wholesale users.

• Ad hoc/regular data analysis & investigation of Data by extracting and analysis using Access/ SAS/ Business Objects/ Excel for Data Quality, Commercial Management Information Reporting, Credit Risk Reporting (Basel II).• Risk Weighted Asset/ Nexus Exception reporting/ Benchmarking/Metrics/ Scorecard development for Probability of Default/ Pillar 3 controls.• Development/ Preparation of Regular MI reports by production/analysis & development using all key skills. Creation of Benchmarking & Metrics, advising & recommending improvements to Business Users on outcomes.• Design and development to automate Data Quality reporting suite reducing processing time from 10 days to 1. Documented process flows and procedures to mitigate risk.• Creation of Access database to manage workflow of team.• Maintained and developed effective relationships with key stakeholders in delivering professional Data Quality Reports.• Built and maintained effective working with all team members in order to assist in optimizing whole team’s expertise and help build an integrated team.

• Coaching/ mentoring & training team members on new products/ procedures. Winner of European Champions Scheme.• Stakeholder management for new business by selling benefits of Corporate Online to Small Medium Enterprises/FTSE100 co’s.• User Acceptance Testing for new releases of E-Commerce products• Large scale presentations to key stakeholders at all areas within business on E-Commerce products to aid uptake/adoption.• Creation of Access database to remove risk of unused Smartcards by users. Winner of Champions Scheme Award.• Procedure development for risk mitigation and control of processes. Creation of training manuals/ procedures for BAU purposes by team.• Site Visits to customers (Managing Directors to IT) to provide advice on training and installation for FTSE/ SME sectors.• Analysis of flat files (CSV, etc) provided by customers for payroll, to fix errors/formatting.• Key role in project to migrate customers to Corporate Online, cost saving of £6 million PA. Champions Scheme award winner for high profile role.• Creation of Departments internal/external intranets. Highly praised by senior management for role.

• Management of team of 8 Customer Service Officers. • Setting team objectives & annual appraisals• Coaching & developing team members• Organizing and running regular 1-2-1’s• Training of Customer Service Officers in all Branch Banking duties.

Full range of Branch duties. These included account opening, head teller, back office duties. Gained a good understanding of products and services offered by a financial organization covering all Personal and Business products.