Scott Allan Email & Phone Number

Glasgow, Scotland, United Kingdom

Glasgow, Glasgow City, United Kingdom

Glasgow, United Kingdom City Centre

o 17 years understanding of the contact centre industry, 15 years within an outsourcing environment o Works with Business Managers and Subject Matter Experts, identifying a program of insight prioritised by business benefito Utilises the investment in the Business Data Warehouse to directly interface and obtain data in relation to insight programs o Undertakes direct SQL Queries and establishes automated extract/refresh objects to identify and produce granular data outputs by which analysis activity occurso Direct analysis of raw data outputs identifying segmentation, uniformity, differentiation and identifies key themes split across a PESTLE and Performance basiso Communicates and presents to senior stakeholders, preparing possible what if scenarios based upon key decisionso Liaises with both the Continuous Improvement and Process Engineers to aid requirements in deliveryo Logical and analytical mind-set with ability to manipulate raw data output into distinct data algorithms o SQL Query ability with 7 years experience of building bespoke data queries through alternate languageso Creates clear, non-technical outputs highlighting approach, findings, impacts and associated actions

Skypark Finnieston Glasgow

Business Intelligence (Management Information Business InfrastructureKey DutiesClient Reporting-Responsible for the integrity of client reporting for all of HML's clients and the checking and secure distribution of the reports.-Responsible for identifying and implementing continuous improvements to client reporting.-Providing standardised MI reporting through effective query coding and data mining capabilities.-Providing key project management disciplines to ensure effective delivery of MI which includes:Portfolio MIOperational MIConsultant MIGovernance MIClient Ad-hoc / 1 time reporting MIAll presented in Excel/PowerPoint.MI Design, Build & Delivery-Consult with end users to provide a pertinent and inclusive reporting suite within Microsoft Reporting Services/Excel/PowerPoint to provide 'interactive' and 'on demand' reporting .-Develop SQL Queries to deliver MI requirements for regular and one-off reporting , for both internal and client driven requests presented within Excel/PowerPoint.-Creation of monthly 'Key Performance Indicator' and 'Red Amber Green (RAG) status reporting within Excel for High Level Executive Leadership monthly meetings.Relationship Management-Manage Key relationships with internal customers and clients.-Responsible for day to day relationships with operations and clients to deliver quality, effective and accurate MI.Knowledge & SkillsCompetent understanding of data warehouse modelling, dimensional modelling & cube designI am also familiar with other database management system programs (MS Access), however my knowledge is primarily based around the data warehouse and using SQL to return/retrieve queries directly from the warehouseExtensive knowledge of MS Excel and PowerPoint softwareUnderstanding of Java/ HTML and .NET software

Education record

Education record