Lee Phillips

Experience

• 

  Kilmarnock College

  Jan 1997 - Jul 1997

  Computing Lecturer
• 

  JigSaw Electronics

  Jan 1998 - Jan 1999

  Website Designer

  designed websites and outdoor advertising

• 

  Daily Record

  Nov 1999 - Jan 2002

  On-site Producer

  Account Manager and site designer for icScotland.co.uk

• 

  Govan Initiative Ltd

  Aug 2002 - Jun 2005

  ICT Tutor

  Design, development and delivery of non-accredited and accredited learning courses to local non-working residents. Test Centre Manager for ECDL (European Computer Drivers License). Managed staff and ensured level of service delivery met and exceeded BCS (British Computer Society) guidelines. Designed and maintained department website which was part of company portal.

• 

  ScotBall News

  Apr 2005 - Sept 2006

  Business Owner

  Owner of ScotBall News, started initially (and still to this day) as a basketball online forum but has grown to include a licensed grocers/newsagents and a clothing range. Sold the store (for a profit) as it was mainly a business development project. Still run the online forum.

• 

  Dell

  Oct 2006 - Jan 2014

  Part of a Global organisation, I supported DELL’s EMEA Online business, providing key stakeholders with game changing solutions which support and drive the organisation's KPIs, Metrics and strategic objectives. Key Duties: • Business Analytics & Reporting (BI/MI) both globally and in EMEA (37 countries) for Online business.• Produce bespoke analytical solutions to assist stakeholders with running the business decision making.• Create automated, SQL/OLAP-driven solutions to empower users to improve business financial metrics.• Regular communication and presentations to senior management.• Requirements gathering, root cause analysis and prioritisation with key stakeholders.• Technical Authoring – creating, updating, branding and producing supporting documentation and following strict company brand guidelines (User and Build guides).• EMEA and US travel to engage/train key stakeholders & peers.• Design, development and delivery online and face to face training (SQL & OLAP) to stakeholders and peers.Achievements:• Excellent feedback for Global NDBM Dashboard development for Senior VP level communications.• Excellent and consistent customer feedback received for delivering absolutely critical solutions. Show less

  • Performance Analytics Group - Reporting & Business Analytics

    Sept 2011 - Jan 2014

  • Global Portal Data Analytics and Reporting

    Oct 2010 - Sept 2011

  • Global Portal Engagement Manager

    Jul 2010 - Jan 2011

  • Senior Technical Call Coach

    Oct 2006 - Jul 2010

  • Senior Coach/Team Leader

    Oct 2006 - Jun 2010
• 

  Nine18 Wedding Films

  Sept 2013 - now

  Owner/Director

  Nine18 Wedding Films and is an established, Scottish based, film production company, specialising in filming & editing weddings.www.nine18films.co.uk - hello@nine18films.co.uk for #FilmsYouWillLoveWe film all of our events using 4K Panasonic GH4 and GH5 cameras, editing using Adobe Premiere Pro and Pinnacle Studio Ultimate. We cover Scotland, UK and beyond... have passport, will travel.Our website has the facility for you to check your date availability, build your own customised package to fit with your budget and requirements. This will generate a no-obligation quote. You can also view our most recent work in our Vimeo gallery or take a look at (and follow) our Instagram #FollowUsOnInstagram Our portfolio spans weddings from all over Scotland, capturing the emotions at some of the best wedding venues this awesome country has to offer.Included in our Base and Teal Packages is aerial drone footage, which is weather and venue dependent, to give your wedding film that epic WOW factor. We have one fully qualified pilot and fly the DJI Mavic Pro and DJI Inspire 1. Show less

• 

  Barclays Wealth and Investment Management

  Feb 2014 - Oct 2014

  Senior Client Intelligence Analyst

  Recruited to join a team to support the Wealth Direct project, this role focused primarily on Barclays Stockbrokers but included Wealth International Banking, providing MI/BI solutions to allow key stakeholders to make game-changing decisions in line with strategic objectives.Key Duties:• Design & Build of Reporting Dashboard to trend key OLIs for International Bank stakeholders.• Design & Build of Reporting Dashboard to trend key KPIs for Barclays Stockbrokers stakeholders.• Provide decision analytical solutions for Barclays Stockbroker stakeholders.• Interrogate data using Teradata SQL and MS Access to deliver value-add Insight.• Production of Technical Documentation for new processes, User & Guides and Data flows. Show less

• 

  Morgan Stanley

  Oct 2014 - Dec 2014

  Business Data Analyst

  Part of Technology and Information Risk, a Division of Technology in Data, my role, within the COO team, was to provide reporting and insight through data and business analysis to key stakeholders spread throughout the Firm. Key Duties:• Improving the look and performance of existing reporting suites using OLAP and in house data sources.• Designing and implementing new reporting solutions based on requirements gathering and interrogation.• Communication with stakeholders at all levels in the Division.• Ensure supporting technical documentation is up-to-date, accurate and consumable at any level.• Requirements gathering, process improvement and automation of all reporting requirements.• Ad-hoc Excel peer training for groups and 1:1. Show less

• 

  AMCS Group

  Jan 2015 - Apr 2016

  Business Intelligence Reporting Analyst

  AMCS Group is a global leader in recycling and waste management software & on-vehicle technology. Supporting operations management with our ELEMOS (ERP) software; route management, weighbridge management, material sales, recycling data, customer & asset management.As a BI Reporting Analyst, the role supports ELEMOS and the reporting/analytics needs of AMCS Group's global client base using the following Tools and Technolgies:SQL Server Management Studio, OLAP, SSAS/SSRS and the built in reporting/analytics suite in ELEMOS (rebranded as AMCS ERP).* Ensure supporting technical document is kept up to date and is consumable at all levels.* Requirements gathering sessions to understand the needs of the client and set realistic, achievable expectations.* Develop and sustain strong working relationships both internally and with external clients.* Design and develop a range of reporting solutions using SSRS/SSAS, OLAP and SQL to meet client requirements. Show less

• 

  Prudential Assurance

  Apr 2016 - Oct 2016

  MI Risk Analyst

  Part of the Strategic Sourcing & Procurement team in Corporate Services.This role involves producing actionable MI solutions and trend analytics for the Sourcing Operations and Management teams covering procurement and sourcing projects:• Dashboard and Presentation creation and management using MS Access and Excel presented to SLT level• QA Tracker build and development to improve the QA process for all vendor contracts• Technical Documentation and training to support all new tools and trackers, deployed internally• Archer (Business objects) data report extraction and manipulation to support ad-hoc reporting requests• Process improvement – restructure of existing DataCube updating process and data storage to ensure faster update times (78% improvement), improved file size (87% reduction) and performance of tool• Vendor Spend Dashboard created to identify areas for cost reduction, supplier reduction.• Data Cleansing and Integrity checks to improve Vendor classifications. Show less

• 

  Six4 Productions

  Jan 2018 - now

  Business Owner

  www.six4.co.ukSix4 Productions is purely concentrating on the commercial/corporate and aerial side of filmmaking and photography.Duties include: Client meetings, marketing, sales, admin, filming, editing, final production,UAV flying, location scouting, risk assessment, design work, social media, website content creation.Production of HD & 4K video using Adobe Premiere Pro, photo editing using Adobe Photoshop.In collaboration with West College and City College Glasgow I have delivered drone lectures to HND students as well as providing mentoring and work experience for both HND and Degree level students through filming and editing. Show less