Dan Norris Email & Phone Number

Sheffield, GB

Sheffield

• I lead the team responsible for ensuring that the reporting function continues to run accurately and without downtime whilst the business is undergoing a critical data migration project of the main source system. I.
• Responsibility for report development and maintenance across the business (Power BI/DAX)
• Responsibility for all reporting data and architecture of data platform (AWS)
• Development and maintenance of data feeds from cloud-based and on-premise data stores
• Management and mentoring of BI Development Team plus 2 external contractors
• Proactively shaping and driving the reporting strategy across the business teams

York, United Kingdom

• Worked on a number of varied projects in a lead consultant role. Including but not limited to:
• Data Warehouse development – developing and optimising the data warehouse and ETL pipeline at Farrow and Ball (SQL Server, SSIS)
• Report development, testing and maintenance at MundiPharma, a multinational pharmaceutical organisation (Cognos)
• Data Modelling and ETL - deduplicating complex datasets from multiple sources at Leeds Beckett University (SQL, Stored Procedures, SQL functions)
• Provided support on the Simpson Associates helpdesk between projects, dealing with a wide range of clients and technologies. (Cognos, Power BI, SQL Server, SSIS, Azure, Data Factory, MySQL)

• Sheffield Hallam University is a large organisation with complex reporting requirements. The Data Warehouse and MI team is responsible for the corporate Data Warehouse and the MI and operational reporting provision.I.
• Technical design, development and maintenance of data warehouse (SQL Server)
• Played major role in developing scalable, reusable ETL packages - Microsoft SSIS
• Multi-dimensional data modelling - SQL Microsoft Analysis Services (SSAS)
• Report development - IBM Cognos, SQL Server Reporting Services (SSRS) and Tableau
• Working in partnership with business users and stakeholders to gather requirements and model data to meet these requirements

• Responsibility for the organisation’s Management Information provision
• Member of the panel for the tender process for acquisition of new reporting tool
• Managed the installation, roll-out and user training and support for IBM Cognos BI
• Created SQL scripts, stored procedures and automated tasks (SQL Server and Oracle)

Sheffield City Airport

• Set up and ran a busy café employing and managing a team of six staff
• Responsible for bookkeeping and tax returns

• Developed SQL Server 2000 database for collection and analysis of Management Information
• Responsible for Business Objects MI reporting and BO Universe development and maintenance
• Responsible for the development of a suite of KPI reports

• Responsible for developing a suite of Excel reports for monitoring and reporting of student and financial information
• Automating manual tasks resulting in efficiency savings
• Presented regular Management Information reports to senior management

• KPI Reporting
• SQL programming
• Microsoft Access programming

Master Of Science (Msc), Information Management

Bachelor Of Arts (B.A.), Psychology

BA Psychology