Vastly experienced Business Intelligence Consultant with over 15 years of hands-on experience. Highly motivated, who excels in BI, SQL, SSIS, ETL, Power BI, SQL Server, Excel, SSAS,SSRS, reporting, Data Warehousing and data modeling. Other tools than mentioned that I use are Azure DevOps, Azure Data Factory,PowerShell, SAS, C#, .NET, Python, MySQL, DB2. Excellent communication, mentoring, team management, and establishing rapport with diverse stakeholders and innate ability to gain confidence and trust. OestData, Sweden May 2016 – Present Data analyst *On a data modeler mission for Västra Götalandsregionen I created a working prototype and data model for a near real-time Business Activity System (BAM) to use for a Hospital Capacity Management System (HCMS) in Sweden’s third largest hospital Sahlgrenska University Hospital. By using SQL Server and SSIS for Change Data Capturing (CDC) and IBM Cognos tools for reporting the hospital got valuable insights regarding planning available beds for patients. I gave data analysis mentoring towards Jumanji in calculating and comparing CO/2 emissions in freights in MySQL for e-commerce companies that are using the Shopify system. *I gave data analysis mentoring towards Jumanji in calculating and comparing CO/2 emissions in freights in MySQL for e-commerce companies that are using the Shopify system. Methodologies: Erwin, Kimball/Inmon, EDW, ETL, ELT, ITIL, Agile Spry AB, Sweden May 2023 – Present Data Analyst *Implemented a variance analysis system for the public works company LPE by creating a data warehouse in SQL Server and reports in Power BI. This compared budgeted costs and actual revenues over time and gave deeper insights into project costs and incomes and led to the customer finding great potential for improvements in many of their customer projects. *Created SQL procedures for ETL jobs that transforms daily customer behavior data from the e-commerce company Nordic Nest’s Dynamics 365 Business Central and Google Analytics into tables in a data warehouse and in data marts for a customer behavior analytics (CBA) system. Geodis Sweden Sep 2011 – Mar 2016 Business Intelligence Architect *Implemented for the multinational Geodis several data warehouses and reports using SQL Server’s SSMS, SSIS, SSAS, SSRS, Qlikview, Excel, VBA, .NET,C# and APIs to extract supply chain/financial data from the different worldwide departments’ data sources. *At Geodis I performed a major overhaul of the database performance by using the SQL Server tools…Vastly experienced Business Intelligence Consultant with over 15 years of hands-on experience. Highly motivated, who excels in BI, SQL, SSIS, ETL, Power BI, SQL Server, Excel, SSAS,SSRS, reporting, Data Warehousing and data modeling. Other tools than mentioned that I use are Azure DevOps, Azure Data Factory,PowerShell, SAS, C#, .NET, Python, MySQL, DB2. Excellent communication, mentoring, team management, and establishing rapport with diverse stakeholders and innate ability to gain confidence and trust. OestData, Sweden May 2016 – Present Data analyst *On a data modeler mission for Västra Götalandsregionen I created a working prototype and data model for a near real-time Business Activity System (BAM) to use for a Hospital Capacity Management System (HCMS) in Sweden’s third largest hospital Sahlgrenska University Hospital. By using SQL Server and SSIS for Change Data Capturing (CDC) and IBM Cognos tools for reporting the hospital got valuable insights regarding planning available beds for patients. I gave data analysis mentoring towards Jumanji in calculating and comparing CO/2 emissions in freights in MySQL for e-commerce companies that are using the Shopify system. *I gave data analysis mentoring towards Jumanji in calculating and comparing CO/2 emissions in freights in MySQL for e-commerce companies that are using the Shopify system. Methodologies: Erwin, Kimball/Inmon, EDW, ETL, ELT, ITIL, Agile Spry AB, Sweden May 2023 – Present Data Analyst *Implemented a variance analysis system for the public works company LPE by creating a data warehouse in SQL Server and reports in Power BI. This compared budgeted costs and actual revenues over time and gave deeper insights into project costs and incomes and led to the customer finding great potential for improvements in many of their customer projects. *Created SQL procedures for ETL jobs that transforms daily customer behavior data from the e-commerce company Nordic Nest’s Dynamics 365 Business Central and Google Analytics into tables in a data warehouse and in data marts for a customer behavior analytics (CBA) system. Geodis Sweden Sep 2011 – Mar 2016 Business Intelligence Architect *Implemented for the multinational Geodis several data warehouses and reports using SQL Server’s SSMS, SSIS, SSAS, SSRS, Qlikview, Excel, VBA, .NET,C# and APIs to extract supply chain/financial data from the different worldwide departments’ data sources. *At Geodis I performed a major overhaul of the database performance by using the SQL Server toolsWWWW…