Ian Harris

Department - Information and Communication Technology (ICT) Program – Development and Innovation (D&I) . Projects (MS Dynamics 365 - CRM): Waste Carriers Brokers and Dealers (WCBD) - Water Environment Monitoring System (WEMS) - Timber Sales System (TSSv2). . Projects (Other): Customer Identity Management Service (CIMS/B2C), ie. a MS Azure facility providing authentication to NRW's web portal - CIMS Administration system - Waste Carrier Portal (WCP), ie. web application service accessed via CIMS - Content Management System (CMS), ie. Umbraco upgrade - NRW website & Wales Coastal Path, ie. WCAG2.1 compliance - Flood Risk Assessment Wales Data Management (FRAW DM). Program – Transformation . Projects (MS Dynamics 365 - CRM): Permitting solutions Waste & Installations, Water Abstraction, Water Quality (Water Discharge Activities & Landspreading) regimes - Timber Management Package (TMP v1 (MVP) & v1.5) encompassing incoming / outgoing API's, ie. eFIDS, eSales and Justfone plus feed to NRW Finance team. . Projects (Other): Subsistence Billing solution encompassing API's to NRW Finance (MyNRW / Agresso) & CARS database - Wiski. Program - Transition . Projects (MS Dynamics 365 - CRM): - Waste Exemptions - Waste Returns . Projects (Other): Wales Coast Path website (lift & shift) - Waste Carriers & Brokers - GIS upgrade - NRW website improvement. Description - Rationalise & modernise NRW's ICT estate using Microsoft Azure cloud based platforms following merger of the Environment Agency Wales, Countryside Council for Wales and Forestry Commission Wales & associated legacy systems. Development methodology - Agile (up to 12 sprints). Functional testing - Static, Smoke, PAT/ Sprint, UAT, End To End (incl System Integration), Exploratory, Live Data Testing (LDT), Comparative (Billing) and Regression. Non-functional testing (NFR) - Accessibility, Compatibility (BrowserStack, WAVE), Operational Acceptance Testing (OAT), Performance & Load, Security / Penetration and Usability.

Program – HR Transformation Project – MI Reporting Description - Replacement of the HR Core Administration System with a SAP Business Warehouse (SAP BW) solution. Summary - Based on an agile approach to development and technical testing with business test and implementation based on the waterfall model. MI reports launched in SAP BExWeb, InfoObjects (prompts, key figures, characteristics and fixed filters) validated against functional specs and in BEx Query Designer, data modelling validated against SAP BW InfoProviders (InfoCubes), output reconciled to source systems via SAP BW GUI front end transactions. ABAP (Advanced Business Application Programming) data feeds – launched via SAP GUI front end, characteristics and key figures validated against functional specs, output reconciled to source systems via SAP BW GUI transactions. BOBJ (Business Objects) data feeds - WEBI (Web Intelligence) reports executed via BI launch pad, InfoObjects (prompts, key figures, characteristics and fixed filters) validated against functional specs and in BEx Query Designer, output reconciled to source systems via SAP BW GUI transactions. Adhoc Webi reports – executed in SAP BEx Web, report characteristics, key figures and default values evaluated, data modelling interrogated against SAP BW InfoProviders (InfoCubes), output reconciled to source systems via SAP BW GUI front end transactions. Development models - Agile (dev), Waterfall (test) Testing - Static, UAT, BAT, AdHoc Status - Testing of releases 1, 2 and 3 successfully completed.

Course details: Name - BCS ISEB Foundation Certificate in Business Analysis Supplier - Assist e-Learning & Reed.co.uk Type - Online 30 day course Exam date - 25.07.2014 Exam result - Pass

Project - SME Network Simplification (SMENS) - System Segmentation Description - New SME and RBB target operating model within Commercial and Retail Banking divisions incorporating existing and new sector and segments. Summary - Document test model confirming test coverage, identifying front end applications and back end processes impacted by changes, perform testing within a controlled test environment. Development model - V-model. Testing - Static, UAT, BAT, Stakeholder & Regression. Status - Testing successfully completed, SMENS changes deployed into Live.

Project - LBG Rebranding Description - Rebranding of Lloyds Bank Commercial Banking following creation of new TSB Bank. Summary - For all Commercial internal and customer facing applications as well as all Commercial printed output including legal mandates and terms and conditions, test and prove Lloyds rebranding requirements have successfully been deployed and BOS branding remains unchanged. Development model - V-model. Testing - Static, UAT, BAT & Regression. Status - Testing successfully completed, Rebranding changes deployed into Live.

Project - Verde (Product Transition and Separation Day phases). Description - Creation of new Verde bank, transition to new products and separation of data and applications. Summary - Within a controlled environment, tested Verde code changes deployed against ITFR & Dependancy work stream applications in preparation of PT and SD implementation. Development model - V-model. Testing - SIT, UAT, BAT & Regression. Status - Testing successfully completed, new Verde Bank deployed into Live.

Project - Galaxy Description - New Commercial internet banking platform for LTSB and Bank Of Scotland brands. Summary - Engaged in workshop reviews validating business requirements, online security, user journeys, use cases, page layouts, wireframes, copy decks and print specs. Mapped E2E business process tests against workflow specs integrating many systems and applications. Provided impact assessments to change requests. Tested the new IB platform via front end input through to back end processing and delivery of 3rd party collateral. Engaged with Internet Banking Centre (IBC) verifying current procedures, validating changes and supporting IBC stakeholders. Following successful deployment to Live, tested and supported implementation of new IB initiatives, eg. Online Payment Control (OPC). Development model - Agile. Testing - Static, Web, Digital Banking, Content, Business Process, SIT, UAT, BAT, Stakeholder, Non-Functional (Functionality, Usability, Security) and Regression. Status - Testing successfully completed, new Commercial internet banking platform deployed to Live.

Course details: Name - BCS ISEB / ISTQB Foundation Certificate in Software Testing. Supplier - Prometric Type - 3 day residential. Exam date - 21.11.2009 Exam result - Pass

Programme - Commercial Transformation Programme (CTP): Project - Commercial Account Opening (CAO), Project - Commercial Lending (CL). Description - CAO, an internal E2E data capture & data validation system opening commercial primary and secondary accounts in real time. CL, straight through processing of commercial card, loan and overdraft applications. Development model - V-model. Testing - Static, Use Case, Business Process, UAT, Stakeholder, Non-Functional (Functionality, Reliability, Usability, Security) and Regression. Status - Testing successfully completed, CAO and CL applications deployed to Live.

Project - OpenLink Endur. Description - Successful implementation of version 7.5 to the risk management trading system. Development model - Incremental. Testing - Quality Center co-ordinator, Static, UAT, BAT, Stakeholder and Regression. Status - Successfully deployed.

Project - Quarterly Billing system maintenance. Description - Successful implementation of Regulatory changes. Development model - Agile. Testing - System, UAT and Regression. Status - Regulatory changes successfully deployed.

Project - Mortgage De-Regulation. Description - Successfully implemented FSA regulatory changes to the Unisys Financial Services System (UFSS). Development model - Waterfall. Testing - Static, UAT and Regression. Status - Regulatory changes successfully deployed.

Project - Quarterly Billing system maintenance. Description - Successful implementation of MRA changes. Development model - Agile. Testing - Static, System Test, UAT and Regression. Status - Business changes successfully deployed.