Stephen Mccormick Email & Phone Number

14 years data analysis experience in using MSSQL and MSExcel/Powerpivot/PowerBI in mostly a manufacturing environment. Over the last six years I have been working with Colour Physics and Colour Prediction data with a Global Thread Manufacturer.Main highlights include Corporate Responsibility reports, this focused mainly on the environmental impact of our operations including energy/water/co2Pareto analysis of redye performance to improve turnaroundDyes and Chemical analysis - Analysing concentrations of both from the perspectives of the environment and financial costs Continual analysis of production performance to find ways in improving first time performance and increasing the repeatability of colour productionPrevious Employment - Facilities ManagementHighlightsWrote a mathematical version of the travelling salesman algorithm in SQL to facilitate better planning of repair jobs as the company was being financially penalised for SLA failuresBuild and set up of databases for new customers Developed multiple reports for different support desks which were displayed on screens to help planning and alert when issues occurred.Developed basic weather forecasting reports for 600+ sites for freezer breakdown planning using BBC RSS feeds Previous Employment - Mobile Phone Repair HighlightsRe-entered IT after a long hiatus (18 years) - relearned SQL over 1-2 months and back up to speed and integrated into all requirements of the data team by month 3.Created scripts which maximised warranty claim payments making sure that all steps were followed for complicated recall repairs

Listed skills include Ssrs 2000, Microsoft Sql Server, Sql Server Management Studio, Pentaho, and 16 others.