Enhanced an existing SSIS ETL mechanism, making a number of non-breaking changes. Incremental improvements were made such as removing unnecessary dependencies and incremental loading of data where feasible. Daily data warehouse load times were reduced from 12 to 7 hours.
Found and fixed ETL issues involving an existing Change Data Capture implementation. Implemented a robust, restartable solution.
Built new and enhanced existing Power BI reports for European subsidiaries based on SSAS multidimensional databases.
Used techniques such as iterative small batch writes for DML operations to keep locking and blocking to a minimum when working with a production OLTP database running close to capacity.
Tools used: SQL Server 2014, TSQL, SSIS, SSRS, SSAS, Power BI, C#, TFS 2013, Agile, Change Data Capture