CV

Download CV in MS Word format

Ken Russell

email: ken@krussell.co.uk web: www.krussell.co.uk

Profile

I am a senior analyst with extensive experience of successful project delivery for major UK financial services companies, including enterprise migrations involving several million customers.
I am adaptable, and comfortable working in dynamic and complex project environments. I have a good understanding of commercial and business issues, excellent communication skills, and a strong technical background. These skills allow me to fulfil a variety of different roles within project teams, and to provide an effective interface between business and technical functions.

Key Skills

  • Self-starter, able to manage individual responsibilities and also contribute successfully to team deliveries on complex, long term projects.
  • Full life cycle analysis and documentation, including Terms of Reference, Business Requirements, Functional Specifications and Implementation Plans.
  • Excellent verbal and written communication skills. Able to document and present the results of analysis clearly and concisely, using effective written reports and diagrams. Effective workshop facilitator.
  • Effective analysis of business data and delivery of practical MI to support business decisions and resolve issues.
  • Effective management of stakeholder relationships at all levels of the business (both internally and with third party suppliers).
  • Project governance, including day-to-day management and resolution of risks, issues and dependencies.
  • Unified Modelling Language (UML) analysis, including use case documentation and business modelling.
  • Good business-facing skills and ability to successfully solve non-technical business and process issues.
  • Strong technical background and full project life cycle experience gained as a former analyst/programmer delivering enterprise level applications.

Experience

August 2015 – Present Date: Lead Migration Analyst, Tesco Bank, Edinburgh (Contract)

Lead analyst for the migration workstream of the Pyramid project, replacing Tesco Bank's existing CDL Classic car and home insurance platform with a completely new CDL Strata insurance platform. This complex project involves re-engineering a diverse architecture of linked systems, migrating the information in 1.4 million existing insurance policies to a completely new data model, and delivering a new operations platform.
Personally responsible for the following deliverables:

  • Analysing and documenting interfaces and dependencies in the existing architecture
  • Analysis of existing and target data models and the migration ETL process, identifying and resolving issues arising from gaps and data transformation
  • Devising and documenting the approach for operational reconciliation
  • Providing analysis support to migration testing and leading resolution of defects
  • Analysing data migration exceptions to identify root causes and manual cleansing requirements, ensuring all data is migrated successfully
  • Leading operational reconciliation for production events, troubleshooting incidents and accounting for all migrated customers and policies

April 2014 – July 2015: Business Analyst, Sainsbury's Bank, Edinburgh (Contract)

Responsible for analysing and documenting colleague IT requirements for migration of 1000 colleagues from Lloyds Banking Group to J. Sainsbury's, including relocation to new head office premises. Responsible for supporting migration implementation, managing transitional IT process for new starts, resolving migration issues and managing relationships with business stakeholders and service providers within LBG and Sainsbury's Bank.
Subsequently migrated colleagues from Windows XP to a new Windows 8.1 platform, including identifying devices, locations and colleagues, scheduling migration to accommodate BAU activity, managing colleague communications, providing data to the hardware team, supporting day to day migration activity and troubleshooting numerous IT and colleague migration issues.

June 2012 – March 2014: Business Analyst, Lloyds Banking Group, Edinburgh (Contract)

Lead analyst for migration of Sainsbury's Bank Colleagues as part of divestment from Lloyds Banking Group. Responsible for analysing and documenting requirements for internal IT migration and segregation of Sainsbury's Bank Head Office staff within the LBG IT platform, identifying and resolving migration issues, supporting migration implementation and managing the requirements of many different business stakeholders and system owners within LBG and Sainsbury's Bank.
October 2011 – March 2012: Business Analyst, Sky IQ, Livingston (Contract)
Responsible for analysing existing Sky Group data warehouse reporting, and creating a data dictionary of business terms for a new data warehouse solution. This work included developing UML business models to clarify conflicting terminology and concepts used by different business areas. Designed and developed a custom application to publish the contents of the data dictionary via the Sky IQ intranet.

Feb 2009 - May 2011: Business Analyst, Tesco Bank, Edinburgh (Contract)

General Insurance Migration Project – 22 months
Lead migration analyst, responsible for successfully migrating 2.5 million existing Tesco Bank insurance customers from Royal Bank of Scotland to multiple new underwriting platforms provided by Tesco Bank and external partners.
Responsible for analysing migration business requirements and devising appropriate solutions, including commercial requirements, customer experience issues, legal, regulatory and compliance requirements and operational exception processes. Supported live proving and provided troubleshooting support during go live.
Managed relationships with key stakeholders at all levels within Tesco Bank, Royal Bank of Scotland and third party suppliers. Ensured that all migration requirements were captured, risks and issues were identified and resolved, and key pre-migration activities were executed.
Managed the successfully transfer of existing customer direct debit payments. This involved coordinating activities performed by RBS, Tesco Bank, BACS and HBSC, to ensure that the required regulatory paperwork was signed at directorial level and the transfer process was implemented prior to migration.

Banking Migration Project – 6 months

Lead analyst in the final 6 months of the project, moving one million existing savings and loans customers from the Royal Bank of Scotland to Tesco Bank's new banking platform. Responsible for managing outstanding risks, issues and defects, and ensuring that these were successfully addressed and closed. This involved managing complex multi-party relationships with Tesco Bank, RBS and third party suppliers.

Apr 2008 - Dec 2008: Business Analyst, Sky, Livingston (Contract)

Business analyst on a project to replace the existing CRM application for Sky business customers with a new web-based system, using Agile development techniques. Responsible for working with business users and system designers to specify functional requirements, including UML modelling of the existing business structure.

Oct 2007 - Mar 2008: Senior Developer, Intelligent Finance, Livingston (Contract)

Code development and system testing for enhancements to the online mortgage application process.

May 2007 - Sept 2007: Freelance development work (Contract)

Developed Lochmaben Community Initiative website http://www.lochmaben.org.uk to provide new look and feel and full content management system for non-specialist site managers, using open-source software.

Mar 2003 - Apr 2007: Senior Analyst/Developer, Tesco Personal Finance Edinburgh (Contract)

Full life cycle IT development (including analysis, design, code development, testing and implementation). Personally responsible for lead business analysis and documenting functional specifications for various enterprise level projects, including customer migration and development of internal and public web applications.

Apr 2000 - Feb 2003: Senior Consultant, Spektra Group Ltd, Livingston

Responsible for business analysis, design and development of multi-tier web applications, working in Spektra project teams on client sites. Clients included Scottish Equitable, Bright Grey and Bank of Scotland. This work involved successfully managing stakeholders at all levels of the client businesses, working closely with clients to identify and document requirements accurately, and developing functional systems to satisfy client objectives.

April 1998 - March 2000: Senior Developer, Sema Group, Livingston

Software development and support for the Independent Tribunal Service. Promoted to Senior Developer, December 1998, after joining as a trainee in April 1998 from a previous career in mechanical engineering.

Qualifications

M.Eng Manufacturing Sciences and Engineering, University of Strathclyde 1990