A global remit for data and analytics, responsibility for many high value programmes / projects with internal, contractor and external resources working both onshore & offshore. Working with business stakeholders to initiate, design, lead the stand-up of the project teams, and provide an appropriate level of governance throughout the project lifecycleUsing a hands-on approach to guide projects, with mentoring and coaching to improve team member performance• Research and POC of new technologies to deliver faster project cycles and optimised solutions• Provide 3rd level support to all Data Platforms & reporting systems and direct support vendor resources• Conceptualised and directed the creation of Azure data platform for integration of the Global supply chain function, extracting >3 billion rows from 19 systems ( inc 4 SAP Versions), transforming, cleansing, harmonising, and delivering to third party data processor. Project duration 18 months, delivering high quality production build plans for 12 manufacturing sites• Designing and governing production of Key CEO reporting KPI's, provide accurate data to drive business strategy and monitor planned savings of $200Million+ for 2023+• Delivered and governed a global Regulatory document platform to meet increase of submissions to the 16 regulatory bodies. Project duration 2.5 years, 60+ team, protecting $1.2 billion+ sales for EUAMED approval to trade• Initiated and led the introduction of Microsoft Power BI. To deliver multiple dashboard projects, drive user adoption and self-service report / dashboard creation. Influenced enabling all employees to have capability to author, publish and share content. Active daily users are 4,500 out of 17,500 employees• Conceived and directed the build of an on-premises based data platform, extracting from SAP ERP system supporting 80% of company, alongside the implementation of SAP EEC 6. Delivering data 3 times a day to a global user base to enable data driven decisions

Responsible for planning and co-ordination of the on-premises data platform, guiding delivery managers to standing-up the Enterprise Information strategic solution. Working with many stakeholders, from the C-suite to end users to agree MVP requirements. Enabling the project teams to have 5 concurrent development pipelines to optimise delivery. Provided a central point of escalation of any major incidents on the production platform.• Conceptualisation and delivered Global Data platform, to support 6,500 users• Orchestrated the creation of IBM Cognos based reporting solution, using Informatica and Oracle toolset for SAP data ingestion. This represents 80% of the company, across 40+ countries and 6,500 users. • Orchestrated the build and usage of technical data platform, including on-premises and virtual infrastructure and software packages to be used• Designed and execution of a Virtual Disaster Recovery solution, providing real-time replication, saving over $1.2Million• Responsible and accountable for designing the application stack to support the strategic solution• Technologies used: MS Windows, Linux, MS SQL Server, Oracle 12c, IDERA ER Studio, Informatica Powercenter 10.4, IBM Cognos 10.2, IBM TM1, Tableau, HP Loadrunner• Directed the provision of a Global Business Intelligence User Experience, through the design of a “Guided Analytics” vision to provide Dashboards and a cascading experience to deliver the right amount of information to the user to enable actionable decisions to be made

Focused on enabling customers realise the value of business intelligence within their business and market sector. Realised through mentoring sessions, workshops, and product demonstrations. This role exists as an overall wrap around the Business Analytics and Information Management team (Sales and Delivery) from database to delivered Business Intelligence environment.• Creation of high-level design proposals, project plans and delivery work packages• Pre-sales activities for customers and Account Managers• Creating and delivering Seminar Presentations ( Logicalis & IBM )• Liaising with the Delivery consultants to ensure delivery of design proposal objectives• Evaluation of new products and taking them to market (BI READY / BI Accelerator )• Creation of solutions for customers, where no Data warehouses exist, delivering the full end to end vision• Using PRINCE2 methodology to design project lifecycles

The main focus of the role is to provide, support and manage Business Systems within Andrews Sykes Hire Ltd, using project management procedures.Line management of staff ( Support / AS/400 Senior Analyst Programmer / Cognos Analyst )• Providing the day to day duties of an IT Manager, both strategic and managerial.• Introduction, training, rollout and support of IBM Cognos 10.2.1 reporting solution to over 100 users within the company, including 4 report authors.• A proactive approach to information delivery, by delivering information to key users that is pertinent to their role, using my intimate knowledge of the business and industry.• Creation, maintenance and support of many data integrations, from a number of data sources (AS/400, Unix, CSV files, Active Directory, SQL2005 via DTS, MS SQL2008 via SSIS packages, Met Office Weather Data, Post office PAF) through to the AS/400 DB2 PLC wide Data warehouse.• Provide a constant strategic drive on the Cognos Reporting Solution, working with departmental heads to provide dashboards(with many drill-trough’s) with both staged data and real-time data, effective concise reporting, active reports for IPAD users, integration with Google Maps for delivery geo-spatial analysis.• Delivery of many AS/400 developments, from small modifications to large programmes of change, driven by user requirements. Key developments, include complete re-design of order to invoicing cycle to support call centre processing. Resulting in systems that are much faster and easier to use, whilst providing high quality management information and customer electronic forms (Via pdf and email)• Creation and implementation of Project Management standards. This involved formal project management procedures, from initiation, to change management to regular project communications• Identification of key strategic areas to be addresses to form the IS Strategy.

Reporting to the Finance Director, developed, planned and executed a BI culture within the Business. The main drive is to give people back more time by streamlining each function with targeting information and reduce/eliminate MS Excel based analysis.• Created IBM Cognos based Web portal, to provide flexible reporting, cube analysis on a 24 x 7 availability, to provide a holistic view of the company• Provisioned the right information, at the right time, in the right format, to the right people. From shop floor employees with performance detail, up to the board of directors with summarised KPI’s• Full rollout of Cognos Upfront, Powerplay Web and IWR, to the functional areas of the business

Reporting to the Head of IS, managed high-level architecture of business systems and implemented core reporting sources and systems, utilising external resources when required.• Utilised customer data, to cleanse and create a focussed marketing data warehouse on the AS/400, using customer postcodes and Ordnance Survey grid references, for demographic analysis utilising the Cognos suite of software• Created and implemented a key business Data Repository on the AS/400, to standardise common business process throughout the many Plc based sales systems, using customised ETL techniques.• Designed, created and implemented a retail consumer datawarehouse, fed from 2000 handheld terminals operated by the delivery milkmen, gathering 1.9 million records on a weekly basis.• Developed and implemented web reporting functions in the following areas:Weekly plc MIS Reporting, GL Weekly Reporting, Purchase analysis, Sales Ledger debtor analysis, Sales analysis and Human Resource reporting• Developed and implemented an Electronic Data Interchange facility for National Accounts• Managed contract resources to work on projects with a value in excess of £500K• Created an archive of system maps and technical documentation.

Reporting to the Finance Director provided IT services for the doorstep delivery business.Managed a team of 24 permanent, 5 contract personnel with an annual budget of £3.5 million, provided continuous support and major systems development (i.e. Year 2000)• Defined and implemented Cognos Powerplay Web, into the sales and marketing functions across the 6 regional offices. Training of 20 users in these offices• Managed BT contract (96 sites) and Handheld supplier contract (2000 devices)• Consolidated AS/400 machines from 12 to 1, saving £250,000 in annual maintenance costs• Managed Year 2000 project, through identification, correction, testing and compliance• Implemented of Infinium Software financial systems, with many customised modifications• Created a centralised help desk function, serving 80 locations and in excess of 1000 users