Krister Lundmark Email & Phone Number

Uppsala, Sweden

Expert on Business Intelligence Solutions

Uppsala, Sweden

Responsible for all the BI solutions. Designing, maintaining and optimization of data bases. Developing advanced reports using SSIS, SSAS, SSRS, SAP Business Objects, Web Intelligence, Excel and QlikView. For ETL processes we are using Integration Services and SAP Data Services Designer.

Stockholm, Sweden

Worked with ETL processes, data warehousing using Integration Services, Analysis Services. Designing, developing and optimizing databases with very large amounts of data (tables with more than 1 billion of rows). Customers included various departments of IMS which is a global company.

Stockholm, Sweden

SE-banken is a Swedish business bank. They were collecting information of value papers from a lot of global sources (index files). They were sent by ftp every morning before 7. Their data was validated and loaded into different databases (ETL processes). There were hundreds of DTS- and SSIS packages in order to do this job. The packages were executed by a lot of SQL jobs. I was involved in optimizing databases and packages, error correction and developing new functionality.Swedish… Show more SE-banken is a Swedish business bank. They were collecting information of value papers from a lot of global sources (index files). They were sent by ftp every morning before 7. Their data was validated and loaded into different databases (ETL processes). There were hundreds of DTS- and SSIS packages in order to do this job. The packages were executed by a lot of SQL jobs. I was involved in optimizing databases and packages, error correction and developing new functionality.Swedish Ministry of Finance had a number of tools and data sources in order to analyze and show national economic statistics. I worked with Data Ware House Architecture and Design, ETL processes and creating reportsJernbaneverket the Norwegian railway company in Oslo wanted to work with simulations so they could find ways of improve their business, safety and precision. In order to motivate such investments they wanted a possibility of simulations of different scenarios. I worked with Data Ware House Architecture and Design, ETL processes and creating reportsPlatform: Microsoft Business Intelligence Platform (Data Mining, Integration, Analysis and Reporting Services), SQL Server 2005/2008, Visual Studio 2008 and SharePoint 2007. Show less

Uppsala, Sweden

Worked as a consultant for the Swedish church. Developed web applications using C#, Visual Studio 2008 and SQL server 2005. Migrating an application for administrating e-mail accounts in Exchange server 2003 and Active Directory to Exchange 2007. The Swedish church used SCRUM as a method for developing. Platform:Multi layer architecture with MS technique. There was a client-, business logic and data layer including an user interface. Subversion, Visual Studio 2005/2008, C#… Show more Worked as a consultant for the Swedish church. Developed web applications using C#, Visual Studio 2008 and SQL server 2005. Migrating an application for administrating e-mail accounts in Exchange server 2003 and Active Directory to Exchange 2007. The Swedish church used SCRUM as a method for developing. Platform:Multi layer architecture with MS technique. There was a client-, business logic and data layer including an user interface. Subversion, Visual Studio 2005/2008, C#, NHibernate, Ajax, SQL Server 2005, SQL Server Reporting Services 2005. Show less

Umeå, Sweden

Developed some parts of a property system Pondus Pro. It was a web based operating and maintenance system for property management. I developed modules for analysis, searching and reports which were integrated in SQL Reporting Services 2005. Further I have also developed the data layer and optimized SQL queries. We were using DDSM developing method. Customers which have bought this system were for example Astra Zeneca, Stiftelsen Bostaden and KBAB.Platform:Multi layer architecture… Show more Developed some parts of a property system Pondus Pro. It was a web based operating and maintenance system for property management. I developed modules for analysis, searching and reports which were integrated in SQL Reporting Services 2005. Further I have also developed the data layer and optimized SQL queries. We were using DDSM developing method. Customers which have bought this system were for example Astra Zeneca, Stiftelsen Bostaden and KBAB.Platform:Multi layer architecture with MS technique. There was a client-, business logic and data layer including an user interface. Visual Source¬Safe, Visual Studio 2005, C#, Ajax, SQL Server 2005 and SQL Server Reporting Services 2005. Show less

Uppsala, Sweden

Developed and managed two web portals at the e-business company InkClub. They were integrated with the business system Visma Business. Adjustment against Visma was also included in my obligations. Since InkClub had more than 1.5 million customers in 2007, safety and performance had highest priority. I used a major part of my time in increasing performance of the sub systems, including optimizing SQL queries, stored procedures and indexes. At the request of the Board of Directors I wrote a… Show more Developed and managed two web portals at the e-business company InkClub. They were integrated with the business system Visma Business. Adjustment against Visma was also included in my obligations. Since InkClub had more than 1.5 million customers in 2007, safety and performance had highest priority. I used a major part of my time in increasing performance of the sub systems, including optimizing SQL queries, stored procedures and indexes. At the request of the Board of Directors I wrote a complete system documentation which was reviewed by an external consultant. I also wrote a couple of client service applications in VB 6 to validate the input of the system.Platform:Multilayer architecture with MS technique. A client layer, business and data layers using COM object. Visual Source Safe Visual Studio 2000/2005, VB 6.0, VB.NET, Java and VB-script, COM, Internet Inforomation Server (IIS 5.0), ASP and SQL Server 2000/2005. Show less

Umeå

Developed and managed two global web applications, CONTRACT and SFT. CONTRACT was used to administrate all contracts, regarding deliveries of materials to their factories, which Ericsson had with subcontractors. It was a very high business critical system. SFT was used by subcontractors in order to check the stock balance of their own products. The users of the system were situated all over the world. I was also responsible for customer support and education of some users. Ericsson used the… Show more Developed and managed two global web applications, CONTRACT and SFT. CONTRACT was used to administrate all contracts, regarding deliveries of materials to their factories, which Ericsson had with subcontractors. It was a very high business critical system. SFT was used by subcontractors in order to check the stock balance of their own products. The users of the system were situated all over the world. I was also responsible for customer support and education of some users. Ericsson used the case management system Remedy ARS and the language used was English. Platform:Visual Studio 6.0, C, CGI, JavaScript, Html and Oracle 8.0. Show less

Umea, Sweden

Norrmejerier was a Swedish dairy. Developed an application for presentation of the contents of different dairy products on Internet. The possibility to choose between consumers and food service products was demanded. I was also involved in developing the tender documents. My role was technical responsible for developing and designing the database. I did the whole installation at the customer. Developed an application where Norrmejerier could show their receipts on the Internet. The… Show more Norrmejerier was a Swedish dairy. Developed an application for presentation of the contents of different dairy products on Internet. The possibility to choose between consumers and food service products was demanded. I was also involved in developing the tender documents. My role was technical responsible for developing and designing the database. I did the whole installation at the customer. Developed an application where Norrmejerier could show their receipts on the Internet. The system had also administration part for adding, changing and deleting products or users. My role also included customer contacts and installation work. Multi layer architecture with MS technique. A client layer, business and data layers using COM object. Visual Source Safe, Visual Studio 6.0, Visual Interdev 6.0, VB 6.0, Java- and VB-script, COM, Internet Information Server (IIS 5.0), ASP and SQL Server 2000. Show less

Umeå, Sweden

System testing of all student records system at University of Umeå. This was before the milennium shift. We did use Mercury testing tools for this purpose.

Skellefteå

Developed and managed a couple of mainframe system at the Swedish counties. Worked mainly with investigations, programming and user support. Daily customer contacts were also included in my role.Platform:IBM mainframe, COBOL, CICS and DL1 databases.

Degree Of Master Of Education For The Upper Secondary School 180 P., Mathematics And Data Science.

Degree Of Master Of Social Science With A Major In Informatics 160 P., Informatics,Computer Science And Mathematics