Michael S. Email & Phone Number

United Kingdom

As Senior Data Modeller at Specsavers one of my main responsibilities is the delivery of the Common Data Model, an Enterprise Data Model delivered in a cloud environment to facilitate BI and analytics. Activities in this role include:• Modelling and designing the architecture for the Enterprise Data Model• Setting and documenting modelling/mapping standards.• Conducting discovery sessions with subject matter experts• Data discovery and data profiling•… Show more As Senior Data Modeller at Specsavers one of my main responsibilities is the delivery of the Common Data Model, an Enterprise Data Model delivered in a cloud environment to facilitate BI and analytics. Activities in this role include:• Modelling and designing the architecture for the Enterprise Data Model• Setting and documenting modelling/mapping standards.• Conducting discovery sessions with subject matter experts• Data discovery and data profiling• Source-to-target data mapping• Creating artefacts and DDL for engineers• Providing consultation on all things modelling• Evangelising the Common Data Model Show less

Leeds, England, United Kingdom

Working as a Data Modeller for a large internal data solutions project.Activities include:• Reverse Engineering source systems to create data models and data catalogue document using ER Studio Enterprise• Standardising data modelling practices and naming conventions• Designing Conceptual, Logical and Physical Data Models to facilitate data projects• Designing Data Warehouse solutions adhering to Kimball Methodology, from source into Azure Data Lake and then into the… Show more Working as a Data Modeller for a large internal data solutions project.Activities include:• Reverse Engineering source systems to create data models and data catalogue document using ER Studio Enterprise• Standardising data modelling practices and naming conventions• Designing Conceptual, Logical and Physical Data Models to facilitate data projects• Designing Data Warehouse solutions adhering to Kimball Methodology, from source into Azure Data Lake and then into the Data Warehouse in Azure.• Liaising with Business Analysts/Product Owners to gather business requirements• Producing SQL DDL Scripts for the Database Administrator to create the data objects• Designing and Implementing both RBAC and RLS system for the internal Data Solution• SME for anything pertaining to Data Modelling• Creating and updating Data/Business Glossaries Show less

Leeds, England, United Kingdom

• Designing and Creating Star Schemas to optimize performance of in-memory visualisation software• Implementing Kimball based Data Warehousing Projects and Data Solutions using SQL Server BI Stack and Qlik• Mentoring junior colleagues• Improving legacy Data Warehouses e.g. further normalisation, introduction of SCDs type1 and type2• Integration and migration of data for newly acquired businesses (Data Warehouse Integration and Data Mapping)• Engaging with senior… Show more • Designing and Creating Star Schemas to optimize performance of in-memory visualisation software• Implementing Kimball based Data Warehousing Projects and Data Solutions using SQL Server BI Stack and Qlik• Mentoring junior colleagues• Improving legacy Data Warehouses e.g. further normalisation, introduction of SCDs type1 and type2• Integration and migration of data for newly acquired businesses (Data Warehouse Integration and Data Mapping)• Engaging with senior stakeholders to define business terms and produce Business Glossaries.• Designing the Architecture for the multi-node BI environment• SME for BI (Report Distribution, Requirements Gathering, Administration)• Introducing Best Practices for BI Document coding and design• Improving Performance and Scalability of BI Show less

Castleford, England, United Kingdom

• Developing reports using T-Sql in a MS SQL Server environment• Lead on the creation of National Data Sets and KPIs in line with NHS Data Dictionary.• Producing Data Dictionaries• Automating existing processes and reports using the MS SQL Bi-Stack (SSIS, SSRS)• Facilitating projects through the provision of data, capturing of data and delivery of reports• Converting processes driven by Excel & Access to SQL Server and SSRS• Liaising with stakeholders to agree reporting… Show more • Developing reports using T-Sql in a MS SQL Server environment• Lead on the creation of National Data Sets and KPIs in line with NHS Data Dictionary.• Producing Data Dictionaries• Automating existing processes and reports using the MS SQL Bi-Stack (SSIS, SSRS)• Facilitating projects through the provision of data, capturing of data and delivery of reports• Converting processes driven by Excel & Access to SQL Server and SSRS• Liaising with stakeholders to agree reporting requirements, negotiate timescales and output formats• Investigation data issues found by Senior Analysts• Designing and implementing dashboards to facilitate monthly business strategy meetings• Deputising for my manager in his absence Show less

Leeds, England, United Kingdom

Designing and producing dashboards for the Fraud and Risk Department of the Lloyds Banking Group.• Using SAS and SQL to generate dashboards• Querying data using SAS and SQL• Requirements gathering from stakeholders• Process mapping• Troubleshooting technical issues occurring with reports