Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Co-Owner
CoInWest CapitalCo-Owner
Apr. 2024Västra Götalands län, SverigeI am part of a group of angel investors in Western Region of Sweden and we are looking to use our knowledge from Connect's investment courses and our skills in mostly IT to invest in a quite new Startup and contribute with our knowledge to that company.
SQL Developer
AD Sverige ABSQL Developer
Jan. 2024Varberg, Hallands län, SverigeAs a SQL Developer the main responsibilities are: *By using Business Intelligence mindset renew old reports from Excel to Power BI for the end users and add new analytical insights. * Develop, optimize and administrate AD Sverige's databases * Be part of the development of new applications * Automate work tasks by using UiPath RPA and automation tools * Make new work routines * Develop reports for the organization * Be part of the business development * Further develop the data warehouse * Do data modelling * Fetch data by ETL jobs etc. Main tools: SQL Server, SQL, SSIS, SSRS, Power BI, UiPath Studio, Excel, Git, Jira
Business Intelligence Consultant
Spry ABBusiness Intelligence Consultant
May. 2023 - Dec. 2023Gothenburg, Vastra Gotaland County, Sweden* 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. * Built PowerShell scripts that migrated accounting and general ledger data from the logistics company GP Last’s ERP system to SQL Server. The data was used for a budgeting and forecasting system.
Business Intelligence Consultant
OestDataBusiness Intelligence Consultant
May. 2016Gothenburg, Vastra Gotaland County, Sweden* I have an ongoing collaboration with the company Optento Systems to help their customers with implementation and modification of PIM and ETL systems in the products Sales Layer and EasyMorph. * On a Business Intelligence architect and 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. * As a hired Study Programmer consultant for staff augmentation in AstraZeneca I developed clinical trial databases (CTDs) with SAS software and using data from EDC systems such as Rave for collecting data from EHRs and CTMS. By following the CFR and GCP regulations I have contributed to many studies reaching the next phases in drug development.
Business Intelligence Architect
GEODISBusiness Intelligence Architect
Sep. 2011 - Mar. 2016Gothenburg, Sweden* Implemented for the multinational Geodis several data warehouses and reports using SQL Server’s SSMS, SSIS, SSAS, SSRS, Qlikview, Excel, VBA, .NET,C# and REST APIs to extract supply chain/financial data from the different worldwide departments’ data sources Dynamics (SQL Server, DB2), Sharepoint, XML/CSV/TXT files, Excel, Access, Oracle E-Business Suite (Oracle, DB2) SAP ERP Business Suite (DB2, Excel) and tailor-made sources, create data models and present reports for deeper insights about freights, CO/2 emissions, and various financial aspects. * Implemented several SSRS reports in a cash flow management system for Geodis that was vital for the operations and finance departments to see payment patterns of invoices, effeciently calculate accruals, account receivables (AR) and account payables (AP), and led to a shortening of two months of Days Sales Outstanding (DSO) which significally improved cash flow and enhanced financial performance. * Whilst a BI Architect at Geodis, by using APIs, .NET, C# and SSIS for gathering and recognizing UN/LOCODEs and IATA codes, coordinates and different spellings of country and city names it led to a big increase in accuracy of hub and port data which was very important for the quality of shipping lane statistics. * At Geodis I performed a major overhaul of the database performance by using the SQL Server tools DMVs, Performance Monitor and Profiler and by optimizing indexes, resolve blocking and deadlocks, assign optimal data types, scaling up hardware resources, switch from cursor loops to set-based operations in SQL code the performances of the databases were heavily improved. * During the consolidation of BI systems towards one Nordic BI system at Geodis I led a team of three developers and was lead architect and developer, and created milestones, budget and spoke to stakeholders for the project such as the managers for sales, operations and finance and it lead to a successful implementation.
Business Intelligence Developer
Västra GötalandsregionenBusiness Intelligence Developer
Jan. 2010 - Aug. 2011Gothenburg, Vastra Gotaland County, SwedenWas responsible for further development of the BI systems that hospitals within West Country Region (Västra Götalandsregionen) used for reporting and analysis. Work included collaborations with doctors and management teams for hospitals to do requirements analysis and defining KPIs and then on my own doing ETL, OLAP cubes designs and creating reports. The reports enabled a transition from a deficient overview of, among other things, lead times and care space utilization for patients.
Business Intelligence Developer
FörsäkringskassanBusiness Intelligence Developer
Feb. 2009 - Dec. 2009Stockholm, Stockholm County, SwedenConsult assignment: The work consisted mainly of developing ETL flows by using Oracle Warehouse Builder, SQL, PL-SQL, but also work in toad Toad and Oracle data modeler to construct indexes and documentation. The my created ETL flows had the purpose to load time period data for people that was in rehabilitation periods into a data warehouse. These data was used to help the Swedish Social Security Agency and Ministry of Health and Social Affairs get a better picture of patterns related to certain age groups regarding rehabilitation and sickness benefit rehabilitation allowance.
Business Intelligence Developer
If InsuranceBusiness Intelligence Developer
Oct. 2008 - Jan. 2009Gothenburg, Vastra Gotaland County, SwedenConsult assignment: I designed and developed ETL data flows, data warehouse and reports that helped them analyze their private consumers. Softwares used were SAS OLAP Cube Studio, Ascential DataStage and SAS Web Report Studio.
Clinical Study Programmer
AstraZenecaClinical Study Programmer
Jan. 2008 - Sep. 2008Mölndal, Vastra Gotaland County, SwedenConsult assignment: I fetched and transformed data into new datasets in clinical studies at Clinical Information Science at AstraZeneca R&D in Mölndal. Worked with SAS-programming and constructed RDB:s (report databases) and for electronic documentation (so called e-CRF:s) we used Excel, VBA and Adobe Acrobat. These data in the Phase II-Phase IV studies were prepared by me for analysis by biostatisticians and the management teams for each clinical trial study. During the period I also got experience of FDA Title 21 CFR Part 11, GCP, Clinical Study Protocols, A&RT and CAVE.
Business Intelligence Developer
Volvofinans BankBusiness Intelligence Developer
Apr. 2007 - Dec. 2007Consult assignment: I created ETL data flows and reports for their credit risk reporting according to EU:s rules of a Basel II system. The softwares that were used were SAS DI Studio and SAS Web Report Studio.
Business Intelligence Consultant
KnowitBusiness Intelligence Consultant
Feb. 2007 - Dec. 2009Gothenburg, Vastra Gotaland County, SwedenThe work was to define and implement Business Intelligence solutions at client companies. I worked at following client companies: Försäkringskassan, IF Insurance, Volvofinans Bank, AstraZeneca, Volkswagen IT.
Data Analyst
Lentus ABData Analyst
Sep. 2006 - Dec. 2006StockholmMy job responsibility was to analyze data from market researchs and market campaigns, especially for COOP and the introduction of MedMera credit card. Tools that was used were SQL Server 2000 and Excel and programming was done in SQL.
RFID Consultant
CGIRFID Consultant
Jan. 2006 - Jul. 2006Stockholm, SwedenI constructed a services portfolio within the RFID technology field and presented it for potential customers. Included in the service portfolio were softwares from software vendors such as: IBM, Microsoft, Oracle and Cognos.
Software Prototype Builder
AB ArtimasSoftware Prototype Builder
Sep. 2005 - Oct. 2005Gothenburg, SwedenAs an individual consultant towards the company Artimas I built a prototype payment RFID application using the following softwares and technologies: RFID scanner and RFID tags, Access, SQL, VB.
Master Thesis work - Mobile positioning service development
Kartena ABMaster Thesis work - Mobile positioning service development
Jul. 2005 - Sep. 2005Gothenburg, SwedenFor the former startup Geosition I built a pre-notification system including softwares for mobile device, and webserver. I was using the following softwares and technologies: GIS, VB.NET, C#.NET, J2ME, SQL Server.
Sales Consultant
Academic WorkSales Consultant
Jul. 2004 - Jun. 2005Gothenburg, SwedenI sold IT products towards companies and authorities.

Requests

Touchpoint image
11
Personal Pitch
Maximize Business Potential with Data Insights
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like Peter on Intch
IT
451129 people
16
Full Stack Developer
64
Frontend developer @ Rubedo
16
AI Engineer @ Vildly AB
ITData Analyst
69589 people
19
BI Developer
0
CRM Manager @ Securitas
29
Machine learning engineer @ U-blox