Yvonne is a consultant with a focus on the development of decision support systems (BI) on the Microsoft SQL Server platform. She has experience in most areas of business intelligence solutions, like extract and transformation (ETL), development of data warehouse cubes and report development.
Yvonne has mainly performed assignments for clients in the banking and finance where she has very good business knowledge, but also in the automotive industry and telecommunications. Yvonne also has an extensive background as a software developer of Enterprise solutions with COBOL and Java/J2EE as the programming language.
Yvonne has experience of working in both the shorter and longer projects, and has also worked with Maintenance for several years. She is technically minded and have easy to understand new tools and techniques. Yvonne is accustomed to work analytically and structured and perceived as social and outgoing.
2018, still running - SQL Developer at Volkswagen
Mission: A project to load into data bought from Jato, who collects information about casr brands, models and their properties and equipment. This information is raw data from their databases and then washed and transformed into the data layer, which the web-application Fleet configurator retrieving data.
Yvonne's role: SQL Server consultant for development and most of development with T-SQL to create logic calculations and transformations
2017 to 2018 - BI Developer at Vattenfall
Mission: A mission to build a new application for project monitoring. One team has already built a framework and begun construction on the first application that has to do with Finance Controlling. A platform with Shared data. A Central data Warehouse. The Framework is built on T-SQL and everything is collected in a Visual Studio solution. Scripst that generates the SSIS packages and Stored Procedures by storing data in meta data tables.
Yvonne's role: BI consultant for development and also some architecture and use and some adaptation of the Framework that has been used by the previous team.
MS SQL Server 2016, T-SQL, Integration Services (SSIS), Tabular, Power BI, Packagebuilder
2016 to 2017 - BI Developer at Volvocars
Mission: A mission support in Volvocars decision support support team. Their BI systems are primarily based on Microsoft SQL Server frontend in ssrs and ssas and Tableau reports. The backend is BigData warehouse.
Yvonne's role: BI consultant for support and research in their existing BI systems. This applies primarily to Cubes and reporting research. Receive incidents and investigate errors. And the health checks of applications and verify that all jobs are running as they should.
MS SQL Server 2008 R2, T-SQL, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Tableau
2015 to 2016 - BI Developer at Skandia
Mission: A mission that developers in Skandia Bank decision support development and Maintenance team. Their BI systems are primarily based on Microsoft SQL Server as the backend both extract, Staging, CDW and Marts. And some reports. Skandia Bank's current solution for decision support is mainly built on t-sql, both for retrieval of data for reports is performed using Stored Procedures, but also the SSIS packages using pretty small part logic by using SSIS components. Instead, it has placed logic mostly on views and Stored Procedures.
Yvonne's role: BI consultant for further development and bug fixing in their existing BI systems. This applies primarily to ETL and Report development.
MS SQL Server 2008 R2, T-SQL, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), TFS version control system
2015 - BI Developer at Ramirent
Mission: A mission working with developers in Ramirent BI Development and Maintenance team. Their BI systems are primarily based on Microsoft SQL Server as the backend both extract, Staging, CDW and Marts. And some reports. Most of the reports are based on QlickView. Incident management as reported by the users, in order to solve them in Ramirent BI backend or send them to another instance at errors that do not affect the BI backend.
Yvonne's role: BI consultant for further development and bug-fixing in their existing BI systems. This applies primarily to the cubes and ETL development. Some report development.
MS SQL Server 2008 R2, T-SQL, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), TFS version control system, JIRA incident management and release tracking
2015 - BI Developer at Rejlers
Mission: A new project with only new development to build up Rejlers Data Warehouse, based on the Data Vault architecture. New technology that was being used. Biml As well as cubes which are then used in Excel and PowerPivot reports. Reports for measuring utilization rate, among other metrics. Built the R12 and YTD using MDX in Analysis Services
Yvonne's role: BI consultant for new development with a focus on the cubes and mdx code. But even some ETL with Biml.
MS SQL Server 2008 R2, T-SQL, Integration Services (SSIS), Analysis Services (SSAS), TFS version control system
2014 to 2015 - Application Specialist at H&M
Mission: A mission Applications expert for the system named 13wp2. This system is made up of Budget, Planning and Forecast and is a system used by Controllers and store managers and Group leader in logistics at H & m. means to put budget and workforce planning, and follow-up. Application is purchased by the Board which is a Swiss company that has these features and are made up of cubes and procedures and Layouts are mainly.
Yvonne's role: Applications expert with the main task to take care of administrative matters and Development regarding SQL Server, as well as administrative procedures. Even some investigation and development of the Board.
MS SQL Server 2008/R2, T-SQL, Integration Services (SSIS), Board, BOARD Budget, Planning and forecast tool, Visual Studio
2013 - BI Developer at PostNord
Mission: The project for the CPI for the activities to follow up and fix, which retrieves data from sources and then process it in order to be extracted into xml files that are then taken care of Business Objects Dashboards. MDS was used to both control the business rules of the system but also to load the new letter carrier offices, terminals and Regions and related KPIS and targets. Another project in which you have chosen to move away from dashboards and use Reporting Services to it's easier to query the cubes by using MDX. And aid for two other projects.
Yvonne's role: Build and transform the SSIS packages that follow the flow to create Kpis and to build reports in SSRS against cubes with MDX code and parameters.
MS SQL Server 2008 R2, T-SQL, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), MS SQL Master Data Services 2012
2012 - SQL/BI Developer at Swedish Military
Mission: Projects to build 4 databases and a Data Warehouse Contributing to a better overview of their data and for The compilation of reports that were previously doing Manually. Use of SSIS in a more innovative way, where instead of using more SSIS component. Using t-sql and expressions and variables and parameters between the packages, as well as for control of flow.
Yvonne's role: Build a database project, as well as to participate in constructing an ETL System with a database and databases for Stage 3 Final storage of the data. As well as building automated Tests for each package that was in charge of the extraction Of data to the databases.
MS SQL Server 2008 R2, T-SQL, Integration Services (SSIS)
2012 - SQL/BI Developer at Storstockholms Lokaltrafik
Mission: Projects to upgrade and migrate the legacy system to SQL Server 2008. Meant both relocation and change of PL-sql code and upgrade of SQL Server 2000.
Yvonne's role:convert both PL-sql code to T-sql power to components in SSIS and SSRS. As well as some fixes in the production that was the emergency that was done with t-sql code after searching right in the data that have been wrong and correct this.
MS SQL Server 2005 T-SQL, MS SQL Server 2008 T-SQL, MS SQL Server 2000 DTS, MS SQL Server Integration Services (SSIS)
2011 to 2012 - SQL Developer at Scania
Mission: Management, where everything is written into Stored Procedures yet from downloading files from ftp, transformation to DW and retrieve data for reports. The reports contain statistics on customers, credit and risk.
Yvonne's role: Working with Change requests for the Administration, as well as help to design an upgrade project, which will upgrade from the old servers to the new, upgrade sqlserver2005 to sqlserver2008 and switching from ftp to sftp.
MS SQL Server 2005/2008, T-SQL, Integration Services (SSIS)
2011 - BI Developer at Hunters Association
Mission: The project aims to create easy-to-use and visually appealing reports for presentation of statistics on hunting. The number of abandoned animals per County will be presented in Sweden map with the option to click through to more detailed information. It also includes the clear data and construct a new data warehouse in Microsoft SQL Server.
Yvonne's role: To develop/create a demo report to be presented in order to take a decision on the project's beginning.
MS SQL Server 2008 R2, T-SQL, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS)
2009 to 2011 - BI and Systems Developer, Teacher at iSITE AB
Mission: Development of reports and analysis on the use of Microsoft BI. And Presales and Support in MS Sql Server. As well as other technologies such as COBOL programming and Java Programming.
Yvonne's role: Consulting in the choice of technologies, and some teaching of Report building with SSRS.
MS SQL Server 2005, T-SQL, MS SQL Server 2008 T-SQL, Integration Services (SSIS), Reporting Services (SSRS), IBM OS/390, CICS, IMS, DB2, J2EE
2008 to 2009 - COBOL Developer at Möller Group, Oslo
Mission: The goal of the project was the development of the warranty process in order to adapt existing systems to a java interface used by Volkswagen and is now also used by Møller. The warranty process has been streamlined both temporally and financially, then Møller now has a central warranty process, unlike earlier requiring individual effort to complete the chain of the warranty process.
Yvonne's role: COBOL developer with major tasks to change the existing COBOL applications concerning the warranty process and write new programs where required.
IBM OS/390, CICS, IMS, DB2, MQ, Xpediter
2008 to 2009 - SQL/BI Developer at Sony Ericsson
Mission: Analysis, design and development of cubes and reports related to customer loyalty and marketing campaigns. Yvonne developed ETL components to create tables with the appropriate data from existing Data stores. These formed the basis of 2 cubes and 3 reports that she also developed.
Yvonne's role: Design and requirements of the work also included in the work, and evaluation of the project and documentation of the system.
Microsoft SQL Server 2008 T-SQL, Integration Services (SSIS), Analysis Services (SSAS), ProClarity
2007 to 2008 - System Maintenance at SEB
Mission: Upgrades and extensions in the system to send files with information about stock trading internationally to the FSA. VMS to Windows Server in order to get a more uniform operating environment. At the same time replaced the Oracle RDB with SQL server 2005 as the database.
Yvonne's role: To learn the whole system to be able to take over management responsibility when it was laid out on a third party. Yvonne had to take care of system documentation and became involved in the systemtesterna.
J2EE, MQ, Oracle, Toad, ClearCase
2001 to 2003 - COBOL Developer at Länsförsäkringar Bank
Mission: Development, testing and handing over to the Government. Integration of the mortgage system to other systems. Functional extensions and customizations to other systems.
Yvonne's role: COBOL developers both management and project, which involved both new development and changes.
AS/400, COBOL, DB2
1999 to 2001 - COBOL Developer at Föreningssparbanken (now SwedBank)
Mission: Management LOUSE – interface to the ATLAS system abroad Projects with Reverssystem. And on-call during the day.
Yvonne's role: COBOL developers both management and project, which involved both new development and changes.