A note to recruiters: While I'm happy to accept connection requests, I am not actively looking for a new position at this time.
A technology professional with a passion for systems which derive value from data. Five years working with SQL Server, experience building data warehouses, ETL routines and Analysis Services solutions, troubleshooting, tuning and administering.
DevOps Data Engineer @ Currently working as part of a small DevOps team, with a personal focus on data migration using C#, PowerShell and T-SQL to extract, manipulate and import from various data sources in the context of client on-boarding projects.
Outside of these projects the role includes supporting the company's products/client facing infrastructure (SaaS platform based on .NET, IIS, SQL Server, etc.) with my focus being on SQL Server setup, monitoring and troubleshooting. The role is part of, and supports, the company's engineering team, in addition to the internal IT infrastructure. From June 2015 to Present (7 months) London, United KingdomSQL Server Database Administrator @ Working with the company's Management Information team and the BI platform. The role was centred around SQL Server and SSIS and included improving security of the existing SQL instances, establishing documented standards for, and implementing, new SQL installs, and migrating and successfully performance tuning ETL jobs.
Also involved with reviewing SQL Server licensing (company moving from SQL 2005 to newer versions), the development of standard documentation (regular project updates with two week objectives, standardized requests for information, etc.) and the introduction of version control (Git/GitHub). From March 2015 to May 2015 (3 months) Senior Consultant @ Primarily working on software implementation projects, deploying, configuring and troubleshooting .NET applications on the Microsoft stack (Windows Server, IIS, SQL Server, Analysis Services) while supporting and training business users in the run-up to system go-live and beyond. The applications and projects cover all aspects of cinema management from ticketing to film programming to BI reporting.
Recently taking on account and project management responsibilities, running an implementation project from project initiation to system switch-over and software use in the live environment. Continuing role as SQL Server expert for the office. From February 2014 to March 2015 (1 year 2 months) Applications Consultant @ Provided third-line support for .NET applications deployed at large cinema chains across the EMEA region. Acted as project resource for implementation projects to take new customers live with the company's system, including work on a project which broke the company's new-sites-live-per-week record. Spent a significant amount of time on site overseas. Supported the office as SQL Server expert. From June 2013 to January 2014 (8 months) Higher Information Analyst @ Worked as part of the team linking the HES and MHMDS data sets and producing subsequent analysis (http://www.hscic.gov.uk/hesmhmds). Moved on due to the team refocusing efforts away from SQL Server and towards use of SAS software. From February 2013 to May 2013 (4 months) Leeds, United KingdomHealthcare Analyst & DBA @ Focused on the development of a BI solution covering HES, GP prescribing other and healthcare datasets. The solution enables rapid, ad hoc analysis of these rich healthcare datasets by non-technical users in a range of organizations (primarily large pharmaceutical companies).
With the project based on the Microsoft stack the role was focused on development with SQL Server, Analysis Services and Integration Services, while also acting as subject matter expert to support a third party UI development team. From November 2011 to February 2013 (1 year 4 months) Nottingham, United KingdomHealthcare Researcher @ Worked providing bespoke analysis of healthcare data (primarily HES) in Excel for top pharmaceutical companies. Provided access to subsets of very large datasets for the analytic team by setting up custom databases. From September 2010 to November 2011 (1 year 3 months) Nottingham, United Kingdom
Bachelor's Degree, Biochemistry and Genetics, Lower Second @ University of Nottingham From 2007 to 2010 Matthew Swain is skilled in: Databases, Microsoft SQL Server, Business Intelligence, Project Management, SSIS, Analysis Services, Pharmaceutical Industry, Healthcare, Teamwork, Training, Report Writing, Quality Assurance, Biotechnology, Lifesciences, Team Leadership, Powershell