I am responsible for designing and building Business Intelligence solutions based on Microsoft SQL Server 2014 and 2016 technologies using Agile Scrum methodology. I use SSIS for data transformation and the packages are created from templates using Business Intelligence Markup Language (BIML). I have designed a bespoke control framework and Master Data capture application to manage the ETL operation (including data quality). This was written in Visual C# 2012 using Entity Framework 5.0. User visualization is achieved by implementing SSAS Cubes, SSRS and Power BI analytical reports.