Requests
11
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
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Academic WorkSales Consultant
Jul. 2004 - Jun. 2005Gothenburg, SwedenI sold IT products towards companies and authorities.
Intch is a Professional Networking App for the Future of WorkSee more people like Peter on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
69
Frontend developer @ Rubedo
15
CRM Manager
27
AI/Digital Business Transformation Manager and Senior Advisor @ Prosensit Change Management
42353 people
15
CRM Manager
16
AI Engineer @ Vildly AB
18
Consultant @ Freelance