Experience

Tipton & Coseley Building Society

• United Kingdom
• Financial Services
• 1 - 100 Employee

• MI Analyst

  • Mar 2021 - Present



Rexel UK Ltd

• United Kingdom
• Wholesale
• 700 & Above Employee

• Management Information System Analyst

  • Nov 2016 - Sep 2020

  Producing accurate and timely management reports, key performance indicators (KPI’s) and business information through the appropriate use of IT resources • Ran regular reports for various purposes including monitoring business performance, debt reporting, risk mitigation and regulatory reasons. Created new reporting as required, and automated wherever possible through Cognos or Excel to remove need for manual intervention • Automated existing reporting through VBA/Excel and Cognos to reduce running time, manual processing and potential human error • Reviewed existing reports to assess if they were still required and still providing value. Making amendments where necessary to enhance data provided and improve experience of end users • Managed personal workload of ad hoc requests, project work and BAU reporting, prioritising work as required according to customer needs • Built relationships with stakeholders to identify business requirements, provide custom-built reporting and ensure any data or reporting queries are dealt with efficiently and accurately • Trained and assisted team colleagues and members of other teams to write Excel VBA to enable report automation, helping to increase their confidence and allowing further reporting to be automated • Supported team with large projects including a company Divisional merger and Cognos upgrade by undertaking tasks including rewriting reports and working through test scripts • Took ownership of maintaining the Sales Executives ledger MI process, driving account ownership and sales reporting. Collaborated closely with other teams to ensure data was correct to enable production of accurate reporting and quarterly bonuses to be calculated correctly Show less



RBS

• United Kingdom
• Banking
• 700 & Above Employee

• Management Information Analyst

  • Jan 2008 - Sep 2016

  Extracting, analysing and manipulating data in a multi-branded, multi-centre environment from a number of mortgage platforms using a variety of applications and tools • Ran a suite of over 300 regular reports, supplying data for purposes including risk mitigation, regulatory requirements, essential business support & detailing business performance • Created accurate bespoke MI to assist end users with projects, understanding business issues, managing incidents & general requests. Provided ad-hoc support to users to enable understanding of data provided, identify relevant information & solve any issues arising • Created and developed new reports, documented the process & created clear written procedures to enable reports to be run by others • Automated reports using tools including VBA and SQL to reduce processing time and increase team capacity, reduce human error & to enable end users to have data available sooner• Continually reviewed data and reporting to look for improvement opportunities, to streamline processes, decrease run time & ensure data provided was robust and fit-for purpose. Saved approximately 18 hours of team monthly report run time by removing reports from the reporting suite which were no longer providing value • Trained and coached other team members on team processes, report running, MS Access and MS Excel to share knowledge and skills, enabling them to gain confidence, undertake reporting unaided, create new reports & take their skills on to other roles • Managed and assessed personal workload and projects, prioritised items as necessary & balanced with BAU work to ensure all completed within timescales • Established and maintained relationships with external and internal stakeholders to identify business requirements & provide appropriate support and guidance • Undertook contingency support and out-of-hours testing to ensure essential core reporting would be unaffected following a system change or disaster recovery situation Show less

• Customer Service Officer

  • Mar 2005 - Jan 2008

  Providing outstanding customer service within Mortgage Operations• Took ownership of customer queries and ensured the right resolution reached in a timely manner for the customer. Liaised with other teams as required to resolve customer queries and complaints• Reworked mortgage accounts after errors with rates and interest to ensure no customers were disadvantaged, including for a customer who had a number of mortgages with the bank with total value of over £1,000,000. By reworking these accounts, I helped retain the business for RBS and stop a complaint escalating further• Trained colleagues and new team entrants on mortgage systems and team processes• Undertook a 3 month secondment at the newly-opened Mortgage Centre in Dublin, providing support on a variety of mortgage processes. Learned and developed new processes, used MI reports, contacted external stakeholders and took ownership of issues identified. Customer Service Excellence award won as part of a team in 2007 following work undertaken during Dublin secondment Show less