Working within the global Manufacturing area of Operations IT, responsible for designing, implementing and documenting multiple solutions for business-critical manufacturing and data analytical systems. Collaborating with Enterprise Architecture, IT Services, Network Operations, Engineering and Cyber Security teams to ensure standardised, documented delivery that meets global enterprise standards. Meeting the operational requirements of the business using enterprise design patterns, analysing and incorporating the latest technologies to co-exist with current platforms. Defining roadmaps for future deployment and alignment across manufacturing.Achievement Summary• Tulip - Global deployment of no code/low code Digital Instruction platform on internal PaaS platform. Solution has reduced yearly costs by around $250m through time-saving and improved quality processes.• Emerson DeltaV – Solution design for a $13m project at Sweden Operations manufacturing site to upgrade key European API manufacturing DCS platform. Contributing to estimated $50m annual saving through process improvements, higher quality and yield. I was further involved in defining support processes, handover to OT and deployment. • Warehouse Control System – Solution Architect for upgrade to existing Warehouse Control System responsible for supporting >$300m packing value. Upgraded the existing physical server to metro cluster service at site for High Availability and GxP requirements.• Demand Backlog – Lead a team to reduce demand backlog across manufacturing projects, from 98% to 0% in 9 months. Training and mentoring external OSP’s to align with architecture processes.• Dashboards/Reports - Architect for multiple reporting requirements using Power BI, QlikSense and BO. Integration from various internal source systems (SAP (ECC, APO, ATTP), LIMS, PAS|X, TrakSYS), external DB’s, Fileshares, using integration tools API’s, SAP PI, Snaplogic, Qlik Replicate, Globalscape, SOAR, BODS, SLT, SDI.

Worked within Finance, HR, Science and R&D areas as BI Engineering Lead to deliver small and large-scale projects, through small-phase and end-to-end delivery. Worked with 3rd party consultants, OPCs and internal employees. • Managed an Agile team across global locations to deliver 40+ Management KPI reports using Agile framework delivery with high business visibility.• Main contact between business requirements and IT team to gather and understand requirements, interpret demand and plan development delivery.• Projects included a Scrum Master and technical lead role within a Finance Transformation program, personally leading a £800k Agile project for management reporting, producing a bespoke output of the reporting catalogue. • Trained and mentored significant number of power users on BI tools across 15+ global sites.• Developed and managed semantic layer and Finance reporting suite accessed by 5000+ users daily.

I worked in a highly skilled team of SME’s to deliver BI solutions to global markets, using a variety of BI tools including SAP BO XI, BO Universe (Designer & IDT), SAP Dashboards, Spotfire, SAP Lumira and BO Explorer. Responsible for developing, supporting and promoting reports through environmentsTraining users and providing key technical knowledge to business areas such as Finance, Marketing and Salesforce managementUsing a variety of BI and Visualisation tools to deliver KPI, management reports, Dashboards and data analysis solutions. Development work was managed centrally in partnership with third party vendors, requiring excellent skills in communication between technical consultants, business end users and key stakeholders. Lead report developer for ‘Amazon Cube’, Astra Zeneca’s global finance reporting system. Technical support for full range of SAP BO toolsDeveloping reporting requirements for over 1000 users worldwideDeveloped innovative Visual Intelligence reporting methods based on latest industry tools. Enabled focused targeting in rep sales saving $0.8 million in EU alone, and significantly improved global customer master data.Full development lifecycle from managing requirement gathering to leading developmentEnabled business to explore and analyse application data in a unique and original way within the areaProvided insight into inventive ways of displaying and analysing data to individual countries Increased end user benefit and self-service. Became product owner and SME for BI tools Lead evaluator for software tools Enabled areas to make informed IS decisions and achieve objective requirements.Mentoring to key individuals within markets to enable self-service of Business Objects reports. Enabled markets to produce in-house reports, reducing budget spend against using external suppliers Produced accompanying documentation to train and coach users, saving markets expenditure against expensive external support costs.

Data warehouse analyst for a government business advice and guidance service. Responsibilities included analysing contractual requirements and creating daily ETL scripts to transfer this data into our data warehouse in an accurate format. Gathering requirements and data migration from various sources into the DW. Using SSIS to update daily. Developed Business Objects Universe to replicate the database schema and created specific data mart views for external and internal dashboards. Established Qlikview as the main reporting resource within the company, and its contractual partners. As technical lead I was responsible for a pioneering project to allow each local council to access and analyse central data regarding thousands of business throughout the North-West.Defined an inventive new credit score metric using Experian data, to analyse nationwide geographical areas and determine links between industry success and location.

Worked within Finance as a business analyst and junior developer during the merger of First Choice and Thomson. Involved in various data projects that involved the full development life-cycle. Designed and developed the reporting mart, and a market leading report suite used for in-flight sales analysis. Enabled accurate product stock and sales records for individual flight routes, increasing retail profits by 18% Developed retail reporting within the airline, responsible for the development and reporting aspects during the merger. This included migrating sales data from both companies onto a common database.

Business Objects developer