Samsung Electronics

2017 (6 months)

  • 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