* Betsson Group (Internet): • Application and providers Integrations;
• Data modelling and schema design and implemented a data warehouse covering products performance, support for SEO KPI and Digital sales
• Design and creation of SQL databases and objects including stored procedures, views, UDFs, .net CLR assemblies, constraints, triggers and indexes.
Design and creation of ETL processes in SQL Server, to transfer data from transational Digital sales database, and flat file data sources to a Data warehouse.
• Creation of complex queries including the use of common table expressions and window functions for analysis and reporting using SSRS
• Maintain SSAS, develop new measures
• Administration of the SQL Server, Tuning processes and security.