Experience

BI Concepts

• Switzerland
• IT Services and IT Consulting
• 1 - 100 Employee

• Partner | Data Architect

  • apr. 2023 - - heden

  Advisory for all things related to Data & Analytics, with a strong focus on technology, people and processes. Helping customers and partners with getting timely, accurate and consistent reporting and analytics. Coaching/Architect for existing/new data teams - tooling, development &release processes . Advisory for all things related to Data & Analytics, with a strong focus on technology, people and processes. Helping customers and partners with getting timely, accurate and consistent reporting and analytics. Coaching/Architect for existing/new data teams - tooling, development &release processes .



Bank for International Settlements – BIS

• Switzerland
• Banking
• 700 & Above Employee

• Data Architect

  • jul. 2019 - mrt. 2023

  Solution and Data Architect.Subject areas covered by the DWH: Credit Risk, Market Risk, Trading and Asset Management.- Migrated the existing BI DWH to Data Vault 2.0 - Built framework for SQL based ELT loading (removing SSIS)- Designed and built framework for asynchronous SQL execution to increase parallelism - Designed integration with Kafka for intraday data feed (using SQL Server extensions) for both batch and streaming scenarios - Designed ELT patterns utilizing Polybase for external sources - Designed archiving/offload processes utilizing Hadoop (and Polybase)- Designed 8 level testing framework (unit, preflight, smoke, reconciliation, regression and 3 levels of consistency checks)- Designed meta driven test framework for increasing and streamlining regression and reconciliation testing of datasets- Designed CI/CD pipelines for feature, PR, UAT and PROD releases- Designed Blue/Green production release process - Introduced Red-Gate SQL Clone and SCA for increased agility (development, testing and release) and developer effectivity - Advisory role and champion for process improvements, tool selections and more Minder weergeven

• Business Intelligence Expert

  • dec. 2016 - jun. 2019

  Member of the BI Core team rolling out a new BI solution across Risk, Banking and the Finance department.Solution is built on the MS BI stack and includes the following components:MS SQL 2016SSISSSAS (Multidimensional)R ServicesTableauETL/SSIS:show-cased different design and modelling options for handling time variant data in the persistant staging area (PSA)Improved existing load from PSA to Datamarts for full reload scenarios (decreasing load time some 50%)Improve SSIS patterns for delta/full loads into DatamartsDatamarts:Design dimensional modelsDesign temporal solutions for handling complex fact and dimensional relationsDesign solutions for easy roll-back/reload "as-of" scenariosParticipate in the overall design SSAS:Design dimensional modelsDesign partitioning and processing strategies for handling large daily delta loadsImplement MDX based solutions for complex aggregations and calculations, like PnL breakdowns etc.Implement MDX based solutions for dynamic handling of multiple versions for calculations based on time Minder weergeven



Volvo IT

• Italy
• Food Production
• 1 - 100 Employee

• Business Intelligence Developer

  • feb. 2016 - jan. 2017

  Full stack MS BI development (SSIS, SSRS, SSAS) Part of team upgrading global datawarehouse and associated data marts to new model based on Data Vault (Penta GDW). Introduced SSIS/SSAS automated unit testing and regression testing using Nunit/NBI test framework. Developed utility (C#) to assist in upgrading 100+ SSIS packages to new control flow patterns. Developed utility (C#) to assist in modifying 100+ SSRS reports to conform to official design in terms of color palettes, positioning, fonts etc. Minder weergeven



Falck

• Denmark
• Hospitals and Health Care
• 700 & Above Employee

• BI Consultant

  • apr. 2014 - feb. 2016

  - Assist client with generic development of various ETL processes using SSIS and Taskfactory between local systems and Salesforce. - Built integration of NN Markedsdata to Falcks CRM tool (Salesforce), using SSIS and Taskfactory. - Model dimensions, measures and calculated measures for datawarehouse and OLAP cubes using SSAS, supporting various requirements such as Campaign Management, Customer analysis etc. - Modeled and built a temporal fact table structure, decreasing the size of the main Portfolio fact-table from 1.3+ billion rows to some 40+ millions, thus greatly improving performance. - Modeled and built the Norwegian sources for a nordic dataware house, using SQL Server 2014 and SSAS Tabular, integrating data from Navision and a Salesforce based Road side Assistance solution. Minder weergeven



Aker Solutions

• Norway
• Oil and Gas
• 700 & Above Employee

• BI Consultant

  • nov. 2013 - apr. 2014

  - Model dimensions, measures for small OLAP cube supporting reporting requirements for an in-house Resource Management System (RMS). - Used common SSAS functionality, such as unknown member handling, many-to-many dimension relationships. - Design and build ETL packages using SSIS, sourcing RMS data from sharepoint/nintex, using standard in-house staging processes and audit framework. - Design and build graphical reports using SSRS, deployed within Sharepoint 2010. - Model dimensions, measures and calculated measures for OLAP cube supporting reporting requirements for an in-house Information Quality System (IQS), supporting engineering projects. - Used common SSAS functionality, such as unknown member handling, multiple measure groups, many-to-many dimension relationships, naturalized hierarchies, junk dimensions, etc. - - Dynamic security within cube. - Design and build ETL packages using SSIS, using standard in-house staging processes and audit framework. Delta load handling. - Design and build graphical reports using SSRS and Performance Point deployed within Sharepoint 2010. - Design and build Trend reports using Excel, deployed within Sharepoint 2010. Minder weergeven



GEA Niro A/S

• BI Developer

  • jul. 2012 - sep. 2013

  Developed OLAP cubes for financial reporting of SBU data using MSAS 2008. - Developed ETL solutions for collecting data from all Units (Excel), loading them into the OLAP cubes (MSAS) using Integration Services (SSIS). - Combining the data during load with basedata from SAP core system - Full exchange rate model for handling local and group currencies - Assist in developing premade reports based on OLAP cubes in Excel. Developed OLAP cubes for financial reporting of SBU data using MSAS 2008. - Developed ETL solutions for collecting data from all Units (Excel), loading them into the OLAP cubes (MSAS) using Integration Services (SSIS). - Combining the data during load with basedata from SAP core system - Full exchange rate model for handling local and group currencies - Assist in developing premade reports based on OLAP cubes in Excel.



Zisson AS

• Norway
• IT Services and IT Consulting
• 1 - 100 Employee

• Database Expert

  • jun. 2011 - jan. 2013

  Database support and programming for internal reporting solutions. Development of stored procedures, views, and data modelling. C# Development for reporting tools. C# Development architectural support. Operational support for MS SQL Databases. Database support and programming for internal reporting solutions. Development of stored procedures, views, and data modelling. C# Development for reporting tools. C# Development architectural support. Operational support for MS SQL Databases.



Numo AS

• Brazil
• International Trade and Development

• Chief Architect & Server Development Manager

  • mei 2009 - mei 2011

  Development Manager for the Server side of Numo (formerly known as Mobile Nordic AS) service offerings. Manage internal and external development resources. Chief Architect for a highly scalable mobile VAS platform. Took the entire platform from serving a thousands of users daily up to 3.8 Million in the course of 2 years, using tools such as NLB, ARR, WFF 2.0 and various caching strategies, taking an IIS hosted solution to the very max of what it can deliver on scalability and fault tolerance. Reduced error rates within the platform with unprecedented numbers, while improving latency and cuncurrency. Streamlined development process, implementing an Continuos Integration workflow, later Continuos Deployment (using Thoughtworks Go). Architect for, and managed migration of existing platform from .net 1.1, asp.net and rpc style POX to .net 4.0, WCF and a RESTful API. Extended API for 3rd party integration for Presence and Location Data. Designed an synchronization protocol and api for use in automatic seamless cloudbased backup solution for mobile handsets (using Azure). Minder weergeven



CPMS

• Civil Engineering
• 1 - 100 Employee

• BI Consultant

  • jun. 2008 - jun. 2009

  Lead technical Consultant for highly specialized BI company, working primarily in the CPM area, using Performancepoint Server and the rest of MS BI stack. Technologies used: MS SQL, Reporting Services, Analysis Services, Sharepoint, Performancepoint and related software. Lead technical Consultant for highly specialized BI company, working primarily in the CPM area, using Performancepoint Server and the rest of MS BI stack. Technologies used: MS SQL, Reporting Services, Analysis Services, Sharepoint, Performancepoint and related software.



EDB Business Partner

• Information Technology & Services
• 100 - 200 Employee

• Database Administrator

  • nov. 2007 - aug. 2008

  Assist in daily operations of hundreds of systems utilizing thousands of SQL Servers for clients such as DNB Nor, Storebrand, Telenor, etc. Patching and maintaining individual Server Instances (hotfixes, servicepacks etc). Operational responsibility for a TB+ sybase archival system. Operational resposiblity for a sybase replication setup spanning Oslo, London, New york and singapore. Implement CA monitoring, including setting standards for metrics, threshold values across customers and systems. Minder weergeven



Telenor

• Norway
• Telecommunications
• 700 & Above Employee

• Sybase Specialist

  • nov. 2006 - nov. 2007

  • Sybase technical expertise given to assist in further development for their Reconciliation software (auditing revenue/billing stream) - Assist in daily operations of Reconciliation System, used to detect leakage in Billing (Revenue Assurance) - Implement configuration and schema changes as required. - Develop new reconciliation jobs and controls - Application Administration & Support (Sybase) - Database Development (Sybase) • Sybase technical expertise given to assist in further development for their Reconciliation software (auditing revenue/billing stream) - Assist in daily operations of Reconciliation System, used to detect leakage in Billing (Revenue Assurance) - Implement configuration and schema changes as required. - Develop new reconciliation jobs and controls - Application Administration & Support (Sybase) - Database Development (Sybase)



JN Data

• Denmark
• IT Services and IT Consulting
• 700 & Above Employee

• DBA

  • jun. 2006 - sep. 2006

  Assist in daily operations of 80+ systems utilizing hundreds of SQL Servers for Jyske Bank and Nykredit. Implement configuration and schema changes as required. Setup, configure and troubleshoot Replication among multiple nodes (cross domain/dmz etc). Patching and maintaining individual Server Instances (hotfixes, servicepacks etc). Create database coding guidelines utilizing best practices for indexing ,common coding, error handling etc for internal development dept. Assist in daily operations of 80+ systems utilizing hundreds of SQL Servers for Jyske Bank and Nykredit. Implement configuration and schema changes as required. Setup, configure and troubleshoot Replication among multiple nodes (cross domain/dmz etc). Patching and maintaining individual Server Instances (hotfixes, servicepacks etc). Create database coding guidelines utilizing best practices for indexing ,common coding, error handling etc for internal development dept.



EDS

• Brazil
• Commercial and Industrial Machinery Maintenance
• 1 - 100 Employee

• Senior System Administrator

  • jun. 2005 - jun. 2006

  Data and ETL Quality Assurance Informatica PowerCenter development Oracle/unix shell scripting Billing system migration support to CSG Kenan for a major Polish telecommunications company. Comparative Billing & Rating Analysis. Unit Testing of Transformation & Load. Mapping/Maplet development in Informatica PowerCenter. Preparation of Usage Data and Billing Process (BIP, CAP, MCAP etc). Rewrote the ICB Discount import function for eliminating potensial breaking faults, with increased functionality of the import function as well (PL/SQL). Identifying data Mapping, Conversion and Load errors. Identifying Kenan configuration issues. Detailed analysis for the migration issues found or reported by other project members. Minder weergeven



Consorte Group ASA

• Senior Database Specialist

  • apr. 2001 - mei 2005

  Lead database developer (ms sql server 7/2000/2005). Senior DBA (ms sql server 7/2000). .NET development.(vb.net, c#) Modelled, designed, and coded (90%) the new backends used for new convergent IN platform, Iqarus. Solution includes: - Logical server partioning (to scale out a system according to need) - Custom built XML versioning system - Custom extended procedures for asynchronous SOAP calls - Completly integrated error handling with SQL Server - Custom defined trace events and perf. counters for use with Profiler and Perfmon - Automated setup of Merge Replication, Log shipping - Custom built advanced installer built in c# and vb.net Other Tasks: - Stabilized ETL software and process for load of Usage Data. - Improved data availibilty for reporting from 1 hour to 15 minutes. - Coached and supported Operational/System DBA's. - Installation, configuration and scripting of Imceda (currently Quest) SQL Litespeed. - Reduced maintenance window with some ~200%. Minder weergeven