Darren Andrews Email and Phone Number

Director and Consultant specialising in Project and Programme Management of Business Transformation Initiatives.

Oversight of programme setup, delivery and trnsition methods for the Vehicle Remarketing Programme, incl. design and implementation of minimum service interruption transition methods. Alignment and management of cross programme dependencies for broader portfolio of works across Motability Operations.

• Responsible for the formal setup of a significant infrastructure programme of works including all governance, planning, execution and reporting procedures• Scope of projects included but is not limited to; AWS Cloud Platform build using Red Hat Openshift; Production Replatforming and Data Centre Consolidation; Non Production Environment Delivery and Management; Data Management for Data Loss Prevention and GDPR (incl. Data Obfuscation, Data Encryption, Data Purging); and Oracle Cloud Proof of Concept• Delivery of periodic reporting to senior stakeholders• Relationship management across all portfolio projects to ensure cross programme dependencies (in particular env. available and new services delivery to business focussed projects) are appropriately identified, scheduled and managed

Project: Apollo PWS and Apollo Car (Service Migration to ALFA Systems)Role: Programme Manager (Technical and Business Transition)• Programme Management role responsible for delivery and management of programme plans for the transition of legacy services and business procedures onto a new infrastructure / software platform• Utilising Agile / hybrid methods to deliver frequently into production to minimise the duration of business impact during final cutover• Personally responsible for the writing and management of all plans and related resources with the final cutover utilising over 250 resources over a 5 day (24 x 7) schedule• Final cutover period including final commissioning of new infrastructure, final technical releases, data migration and business transition completed was successfully with no material deviation to schedule throughout. Hands on management of all checkpoints and ‘Quality Gates’ including pre-prepared / agreed action plans for unplanned scenarios

Director and Consultant specialising in Project / Programme Management, Oracle Applications Software Development, Data / Migration / Conversion, Technical and Business Transition Management

Project/s: Ricoh Spain, Ricoh Netherlands, Ricoh Sweden, Ricoh Italy, Ricoh Belgium, Ricoh Luxembourg, Ricoh FranceApps: AP, PO, AR, OKL, OKS, INV, IB, BOM, Siebel Service and Sales, JDERole: (CONTRACT) European ERP Deployments Manager (reporting to Program Director)• Responsible for overall Programme Management of Ricoh Europe ERP deployments for 7 countries• Management of scope, quality controls and programme governance procedures to deliver into multiple operating companies across a broad geographic and cultural landscape to strict deadlines• Working with onshore / offshore teams across differing time zones• Delivering full programme lifecycle from inception through to production transition, early life support and formal project / programme exit applying formal best practice governance procedures throughout

Project: Apollo 1 – Oracle R12.1.3 CRM UK DeploymentApps: Oracle CRM - Service, Marketing, Email Center, Install Base, UCM, MI (OBIEE / ODI / OLAP), SOA, OSB, BAMRole: (CONTRACT) Project Manager, Technical Lead, Release and Transition Manager (reporting to Projects Director)• Configuration and Release Management Including Process Definition: Hands on release management across all workstreams including Functional CRM Configuration, SOA and OSB, MI including OBIEE, OLAP and ODI, UCM, as well as Oracle EBS development and release management utilising forms, reports, PL/SQL, UNIX Shell, etc. Definition and execution of Early Life Support release and configuration management procedures to provide tested and controlled deployments of priority defects resolution.• Technical Transition Management: Planning and chairing sequential transition workshops for systems isolation and isolation reversal, roll back and contingency planning, technical deployment and data conversion scheduling and reconciliation. Definition of detailed transition plans concluding with ½ day plan walkthrough with full technical and business SMEs as well as project stakeholders. Hands on management of all technical resources, procedures and tasks throughout phased cut over periods.• SCRUM Chair: Chairing daily project scrum's across all project and business work streams to ensure progression against to planned schedules.

Project/s: • Ricoh Austria, Ricoh Ireland, Ricoh Switzerland Integrations in European Shared Service InstanceApps: • AP, PO, AR, OKL, OKS, INV, IB, BOM, Siebel Service and Sales, JDE, on IBM RAC / IBM AIXRole: • (CONTRACT) European Project and Transition Manager (reporting to Program Director)• Ricoh Austria: Technical and Business Transition Manager responsible for management of all acceptance test and production transition deployment tasks across all application modules and business units.• Ricoh Ireland: Deployment Project Manager and Business Transition Manager responsible for project management of call to fix functionality and production transition deployment tasks across all related applications modules.• Ricoh International: Project Technical Lead and Transition Manager responsible for technical team management, mentoring and deployment planning for technical and business transition.

Project/s: UK3 (Infotec) and UK4 (Ikon) Integrations in European Shared Service InstanceApps: AP, PO, AR, OKL, OKS, INV, IB, BOM, Siebel Service on IBM RAC / IBM AIXRole: (CONTRACT) Data Conversion and Transition Lead (reporting to UK Deployment Manager)• UK3 Conversion and Transition Lead: Conversion Team management and business liaison to deliver conversion project across all modules including Siebel Service to planned schedule of 14 weeks. Transition planning and management including all aspects of configuration management and solution deployment to production environment.• UK4 Transition Lead: Planning and execution of all data conversion cycles through development, test and production deployments executed to planned schedule of 14 weeks including all Oracle modules and Siebel Service.

Project: R12 Shared Service Centre Greenfield ImplementationApps: AP, AR, CE, FA, GL, PA, PO, INV, HR, PAYRole: (CONTRACT) Data Migration Functional / Technical Lead (reporting to Test and Data Manager)• Delivered functional strategy and technical design for data migration requirements (CV.010 Requirements and Strategy) to aggressive deadlines.• Defined and implemented generic functional and technical procedures (CV.020 Development Standards) to improve management control and reduce development lead time.• Managed extended team of ten development resources to deliver full finance solution in three months in preparation for end to end business testing.• Provided significant contribution to alternative transition strategies with supporting detailed analysis to substantiate preferred approach.• Single point of contact for all finance migration issues presenting project wide issues and updates to project steering groups including Finance, Change Team and Data Migration communities.

Project: Xenon – Dalkia Lighting R11.5.10.2 implementation on existing UK installApps: AP, AR, CE, FA, GL, PA, PO on DELL RAC / Oracle Enterprise LinuxRole: (CONTRACT) Data Migration Functional / Technical Lead (reporting to UK Program Director)• Delivered functional strategy and technical design for data migration requirements.• Hands-on delivery of solutions for PO Transactions, AP Transactions, AR Transactions, GL Chart of Accounts and associated security, PA Chart of Accounts.• Managed third party delivery of GL balances, PA projects and WiP transactions, HR Employees, HR Locations, AR Customers and AP Suppliers.• Deliverables documented using enhanced AIM methodology including CV templates.• Delivered documented transition strategy for rollout and post implementation period.

Project: Third Party Student Systems (Agresso) to Oracle IntegrationApps: R11.5.10.2 AR / GL on Red Hat Linux AS 2.4.9Role: (CONTRACT) Integration Consultant (reporting to Project Manager)• Functional analysis to derive and define detailed functional requirement. Document accordingly.• Technical analysis to design and build solutions for interfacing customer and transactional data from source system into Oracle AR using Oracle open interfaces.• Technical review of Oracle Heterogeneous Transparent Gateways and related tools to conclude appropriate data transfer / sharing mechanism.• Advise on ongoing maintenance and auditing methods to ensure two disparate systems remain synchronised.

Project: R11.5.10.2 FA / IAC ImplementationApps: FA, IAC on HP-UXRole: (CONTRACT) Technical / Functional Consultant (reporting to Project Manager)• Security cleared (SC) to review documented reporting methodology for IAC implementation. Provision of expertise to analyse and document appropriate reporting methods across FA and Public Sector Inflation Accounting for Assets (IAC). Functional and technical analysis of Reports 6i, SQL*Plus, FSG, PL/SQL, Discoverer and RXi to provide concluding position on appropriate reporting methodology to project sponsors.

Project: R11.5.7 to R11.5.10.2 Post Upgrade Issue Resolution and Reports Delivery RationalisationApps: AP, PO, GMS / PA, GL, AR on IBM AIX 5.3Role: (CONTRACT) Technical / Functional Lead Consultant (reporting to Second Line Support Manager)• Resolution of post-upgrade bugs and resultant data corruption relating to GMS / AP / PO / GL commitments / encumbrances. Responsible for management reporting, issue documentation, solution provision, user acceptance testing and transition to production environment.• Use of optimised complex PL/SQL to identify and resolve corrupt data and code related issues.• Review of financial reports delivery. Implementation and management of structured procedures to improve product quality / performance, reduce cost and delivery schedules.• Mentoring of development team to resolve performance related reporting issues.

Project: Genesis – R11.0.3 to R11.5.10.2 UpgradeApps: AP, AR, AS, BOM, CE, FA, GL, INV, MRP, ONT, PO, QA, WIP on IBM AIX 5.3Role: (CONTRACT) Developer (reporting to IBM Project Manager)• Mapped interface and reporting extensions from OE (Sales Order) schema to ONT (Order Management) schema and optimized appropriately using Reports 6i, PL/SQL and UNIX Shell.• Migrated existing FOTL Order Management customisations from R11.0.3 to R11.5.10.2.

Project: Emerald – Dalkia Ireland R11.5.10.2 implementation on existing UK installApps: AP, AR, CE, FA, GL, PA, PO on Sun Solaris 8.xRole: (CONTRACT) Data Migration Functional / Technical Lead (reporting to UK Program Director)• Delivered functional strategy and technical design for data migration requirements.• Hands-on delivery of solutions for PO Suppliers, AR Creditor Transactions, AR Customers, HR Employees, GL Chart of Accounts and associated security, PA Chart of Accounts.• Managed third party delivery of GL balances and current year transaction detail, PA projects and associated revenue and expenditure transactions, AR open transactions and receipts.• Advised on and documented optimal Oracle org. structure. • Delivered functional specification for custom PO system interface to / from Oracle including Oracle data model and performance impact / requirements.• Delivered documented transition strategy for rollout and post implementation period.

Project: Joint Personnel Administration (JPA) R11.5.10.2 Greenfield ImplementationApps: AP, BEN, HR, PAY on HP-UXRole: (CONTRACT) Development Technical Lead (reporting to EDS Consultant Senior)• Security cleared (SC) for work on MOD JPA project. Direct management of project deliverables and extensions development team of 20 contract and permanent development staff.• Mentored development team and liaised with senior EDS and military resource to deliver robust and performance efficient solutions on HR and PAY applications.• Controlled promotion of custom code through all development environments to production. All work executed to strict configuration management and design standards.

Project: R11.5.6 to R11.5.10.2 UpgradeApps: AP, AR, CE, FA, GL, PA, PO on Sun Solaris 8.xRole: (CONTRACT) Technical Lead (reporting to UK Program Director)• Planned, documented and reviewed technical and functional tasks required to migrate from 11.5.6 to 11.5.10 efficiently, reliably and with minimal down time.• Redeveloped Dalkia PLC Software Development process to improve developer productivity and reduce number of environments without compromising deliverable quality, cost or schedule.• Implementation of Oracle Web ADI (Applications Desktop Integrator) for GL and PA making use of PA APIs (pre / post processing client extensions) to reduce data entry requirements.• Planned, documented and managed successful production transition.

Date: July 2002 to September 2005Project: R11.5.6 Greenfield Implementation (Data Migration Lead) and Subsequent Technical OwnershipApps: AP, AR, CE, FA, GL, PA, PO on Sun Solaris 8.xRole: (EMPLOYEE) Technical Lead / Application Owner (reporting to CIO)• Delivered functional strategy and technical migration procedures for legacy data from multiple source accounting systems into PA, GL, HR, AR, PO, AP, and FA. • System performance improvement project. Implemented Sun StorEdge 6130 storage array, installation, configuration and migration from current database and disk layout to optimal configuration. Results reduced overnight batch processing from 360 minutes to 120 minutes.• Designed, built and implemented suite of Oracle alerts to maintain visibility of functional and technical KPI. High priority alerts forwarded to hand held devices (Blackberry).• Delivered Dalkia UK Business Continuity Plan (Disaster Recovery) for Oracle applications.• Implemented configuration management of Oracle environment using Microsoft Visual Source Safe 6.0 source control software.

Project: R10.7 to R11.5.5 Upgrade and Subsequent Technical Ownership of LedgersApps: AP, AR, FA, GL, PA on Sun Solaris 8.xRole: (EMPLOYEE) Senior Technical Developer (reporting to EMEA Development Manager)• Technical owner of GL, FA, AP and PO applications, responsible for all standard and custom code for forty GL Sets of Books and associated operating units / asset registers across EMEA time zone. • R11.5.5 implementation. Interface re-coding to facilitate global use of single source code set.• Standardised development documentation templates for Sun Microsystems EMEA time zone. • Designed and coded interfaces to facilitate implementation of R11.0.3 Oracle Projects (PA) instance with R11.5.5 core finance modules.

Project: R10.7 Greenfield ImplementationApps: AP, AR, BOM, ENG, FA, GL, OE on Sun Solaris 8.xRole: (EMPLOYEE) Technical Developer (reporting to UK Development Manager)• Global single instance implementation of Oracle Financials and Manufacturing. Development of reports and interfaces using Reports 2.5, SQL*Plus and PL/SQL• Implementation of Oracle Discoverer and Noetix views reporting environment. Conducted user pilot, training and subsequent production rollout. Advised U.S. parent accordingly.