Andrew Merrill

Providing Data Engineering and SQL Database development & support for three healthcare software products used by the NHS (which promote medicines optimisation and improved population health management)

• Maintained and developed procedures in Azure SQL Server Database, including excellent knowledge of Database Security & Administration
• Databricks Notebook Development (PySpark, SQL) - implemented a process to upload JSON files to Azure Storage, with detailed logging
• Data Analysis in SQL Server and Databricks - detailed auditing & analysis of large datasets, providing comprehensive insights and recommendations
• Involvement with multiple Product Teams concurrently
• QA / Testing

Providing optimised data solutions for the largest Housing Association in the UK

• Responsible for maintenance and development of Data Warehouse
• Advanced SQL development on Azure SQL Database (and SQL Server 2008-2019)
• Performance optimisation of SQL queries/procedures
• Management of Azure resources (e.g. SQL Servers, Automation, Data Factory, Virtual Machines)
• Development of Data Factory Pipelines
• Implementation of DevOps SQL Release Pipelines
• Responsible for team's adherence to coding Standards (SQL, Azure Data Factory)
• Management of small team of BI Developers
• Lead role in QA / Testing team's output
• Development of Power BI Reports
• Close collaboration with Business & IT
• Supporting Business Objects (4.1) Platform

• Data Warehouse Design & Development (SQL Server 2012-2016)
• SQL Server DBA duties
• Business Objects Universe Design and Development
• Data Analysis
• Promoted to Data Warehouse Manager in 01/16

• Design and development of Data Warehouses, Data Marts & Reporting solutions for clients including Intel, Dell, Vauxhall, Microsoft and Systemax
• Developed reporting solutions for Microsoft at their head office in Reading
• SQL development on SQL Server 6.5 - 2012
• Helped implement statistical model for Dell which yielded significant ROI