portfolio

Creation of ETL routes for filling the financial data warehouse of the company ElipsLife. The tables of the data warehouse are first filled in the stage area and then, after transformation, in the area of the data warehouse. Both the stage database and the data warehouse are filled by calling stored functions that were implemented in T-SQL. Since the data warehouse is a data vault schema, the filling of the tables of the data warehouse is done according to exact rules. Only one statement is provided for filling the hubs, links or satellites. All three are always filled in the same way, only the names of tables and attributes change. The task is to write dynamic stored procedures for filling these tables, test them, document them and integrate them into the system. The development will be implemented using Microsoft SQL Server 2016 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages; these are also tested and documented.

Creation of ETL routes for filling the internet platforms of the company Swisslife. The tables of the databases behind the internet platforms are filled, but also the data of the data warehouse. Depending on the data source, a preload or a load is first made using stored functions in T-SQL. Subsequently, the data is transformed a first time and loaded into the load structure. Subsequently, the data is refined or transformed a second time and the data transformation is carried out using complex stored functions. Afterwards, the data is loaded into the internet databases on the one hand, and into the data warehouse on the other hand, taking into account the key values. The task is to write dynamic stored procedures for filling these tables, test them, document them and integrate them into the system. The development will be implemented using Microsoft SQL Server 2012 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages, which are also tested and documented.

Website for a health company. All advertising services are integrated directly from the website. Every interaction of the user is registered to analyse the efficiency of the advertising. Implementation using HTML5, CSS3, JavaScript. Increase in online sales. The integration of Google ad services led to good results and increased sales.