Guido K. - BI Consultant / SSRS Expert

Go to Website

Rostock, Germany

Experience

Feb 2024 - Feb 2024

1 month

BI Consultant / SSRS Expert

Nobilis Group GmbH

Supporting the rollout of SQL Server Reporting Services (SSRS).
Training employees on how to use SSRS.
Assisting in the initial setup of reports and structures in SSRS.

Oct 2023 - Dec 2024

1 year 3 months

BI Consultant / DWH Developer

Mitsubishi Electric Europe B.V.

Analyzed six MS SQL databases as part of the SAP migration from R/3 to S/4HANA.
Created a migration plan for the existing databases.
Designed and developed a data warehouse including staging, DWH, and analysis datamart layers.
Extracted data from SAP HANA.
Software used: MS SQL Server 2016, MS Data Tools 2019, SSMS, SSIS (Theobald), MS Azure DevOps.
Technologies used: T-SQL, SSIS, MS SQL Server Project.

Oct 2022 - Mar 2023

6 months

Freelancer, Power BI Report Developer

BSH Hausgeräte GmbH

Adapted existing Power BI reports to new business and technical requirements.
Developed new Power BI reports including data import and transformation.
Built data models and metrics for self-service BI with Power BI.

Jan 2022 - Apr 2025

3 years 4 months

Freelancer, Requirements Engineer / Business Analyst

Raiffeisen Software GmbH

Freelance Requirements Engineer / Business Analyst in reporting/GMP (AuRep).
Conducted business analyses based on DWH data, including FMS, FinRep solo, Anacredit, VERA, WPC, KC, and SC for OeNB reporting (ABACUS system) and Deutsche Bundesbank (B&N model), including covered bond and AWV reporting.
Built analysis datamarts and implemented Bundesbank and SSD reports to the OeNB.
Designed and set up test and monitoring tools and wrote tests.
Created prototypes and Power BI reports.
Worked in agile projects following SCRUM.
Software used: MS SQL Server 2019/2022, MS Data Tools 2019/2022, SSMS, SSIS, SSRS, Jira, Confluence, Azure Data Studio, Power BI Desktop.
Technologies used: T-SQL, C#, VB.Net, SSIS, SSRS.

Jan 2020 - Nov 2021

1 year 11 months

Freelancer, BI Consultant / DWH Developer

Eurofins NDSC Umweltanalytik GmbH

BI and DWH engineering using Data Vault 2.0 methodology.
Created analyses and prepared company data in close collaboration with business units.
Performed requirements analysis, cleansed, and modeled data for analysis and reporting.
Developed and enhanced existing reports.
Designed solutions in business intelligence / data & analytics.
Built data marts.
Created reports with Power BI and improved existing BI solutions.
Software used: MS SQL Server 2017, MS Data Tools 2019, SSMS, SSIS, SSRS, Power BI, TFS, Azure Data Studio.
Technologies used: T-SQL, SSIS, SSRS.

Mar 2019 - Dec 2020

1 year 10 months

Freelancer, BI Consultant / DWH Developer

Eurofins Information Systems GmbH

Connecting data sources to the data warehouse based on Data Vault 2.0.
Performing ad-hoc analyses for the business areas.
Creating analyses in areas such as validated Results and Invoice Allocation.
Designing and implementing reports.
Building test and monitoring tools to ensure the quality of DWH processes.
Working with SCRUM and KANBAN.
Using and maintaining a Power BI report server.
Processing and analyzing geodata.
Software used: MS SQL Server 2017, MS Data Tools 2017, SSMS, SSIS, SSRS, Power BI, Git, TFS.
Technologies used: T-SQL, SSIS, SSRS, Python.

Jan 2016 - Feb 2019

3 years 2 months

Freelancer, Requirements Engineer / Business Analyst

Raiffeisen Software GmbH

Conducting business analyses based on DWH data in the reporting/GMP area (AuRep).
Performing analyses, including FMS, FinRep solo, Anacredit, VERA, WPC, KC and SC for reports to the OENB (ABACUS system) and to the Deutsche Bundesbank (B&N model).
Building analysis data marts.
Implementing Bundesbank reports and SSD reports for the OENB.
Building test and monitoring tools.
Creating prototypes and contributing in agile projects using SCRUM.
Software used: MS SQL Server 2014/2016, MS Data Tools 2015/2017, SSMS, SSIS, SSRS, Jira, Confluence.
Technologies used: T-SQL, C#, VB.Net, SSIS, SSRS.

Apr 2015 - Nov 2015

8 months

Freelancer, BI Consultant / DWH Developer

Gruner + Jahr

Developing ETL processes for various data sources, including SAP, MobileIron and Foreman.
Advising on architecture and deployment processes in a DWH/ETL context.
Designing databases to support reporting and analysis requirements.
Designing and implementing functional requirements in the BI environment.
Integrating web services (REST and SOAP) into ETL processes.
Software used: MS SQL Server 2014, MS Data Tools 2013, SVN, Theobald.
Technologies used: T-SQL, C#, SSIS, VB.Net.

Apr 2014 - Apr 2015

1 year 1 month

Freelancer, BI Consultant / DWH Developer

Bayer Vital

Developing ETL processes for various data sources, including SAP and Salesforce.
Advising on architecture and deployment processes in a BI/DWH environment.
Database and cube design for analysis and reporting solutions.
Designing and implementing functional requirements.
Reporting for the CRM system within a SharePoint environment.
Developing analyses and functional concepts in the BI area.
Software used: MS SQL Server 2008 R2/2014, MS Data Tools 2013, TFS 2010, cMore-Connect, Theobald.
Technologies used: T-SQL, C#, SSRS, SSIS, SSAS, VB.Net, BIML script.

Dec 2013 - Apr 2014

5 months

Freelancer, BI Consultant / DWH Developer

Autoscout 24

Designing architecture for ETL, DWH and analytics processes.
Developing data marts based on various data sources (Salesforce, Hadoop, Oracle, MySQL).
Database and cube design.
Setting up and maintaining the database environment.
Ensuring performance and availability of database systems.
Optimizing performance through continuous improvement of database structures and queries.
Designing and implementing functional requirements.
Developing analyses and decision templates.
Software used: MS SQL Server 2012, MS Visio, MS Data Tools 2010/2012/2014, Git, TFS.
Technologies used: T-SQL, C#, SSRS, SSIS, SSAS.

Dec 2013 - Dec 2013

1 month

Freelancer, BI Consultant / DWH Developer

Axel Springer SE

Development of reports based on ITIL data from ServiceNow.
Setup of reporting structures for IT service management.
Software used: MS SQL Server 2008 R2.
Technologies used: T-SQL, VB.Net, SSRS, SSIS, SSAS.

Sep 2013 - Nov 2013

3 months

Freelancer, SSRS / SSAS / SSIS Developer

Daimler TSS GmbH

Development of data mart applications for internal reporting.
Integration of reports into a SharePoint environment.
Software used: MS SQL Server 2008 R2, MS SQL Server 2012, MS TFS, MS Visio.
Technologies used: T-SQL, VB.Net, SSRS, SSIS, SSAS.

Apr 2013 - Sep 2013

6 months

Freelancer, SSRS / SSAS / SSIS Developer

Bauer Systems KG

Setup and maintenance of the database environment.
Performance monitoring to ensure database system performance and availability.
Performance optimization through continuous database improvements.
Design and implementation of functional requirements.
Implementation of data protection and security requirements, including rights and role management and permission concepts.
Software used: MS SQL Server 2008 R2, MS SQL Server 2012, Deltamaster, Sybase PowerDesigner.
Technologies used: T-SQL, VB.Net, SSRS, SSIS, SSAS.

Jul 2012 - Aug 2012

2 months

Freelancer, Reporting Services Developer

T-Systems

Development of an assembly to extend rendering in Reporting Services.
Implementation of a custom CSV export for reports.
Responsible for idea, concept, and implementation.
Software used: MSRS 2008 R2, Visual Studio 2008.
Technologies used: VB.Net.

Jan 2012 - Mar 2013

1 year 3 months

Freelancer, BI Developer MS SQL

Prinovis Ltd.

Development of applications for business reporting, data marts, and DWH analyses in accounts receivable, energy management, billing, and planning.
T-SQL programming for complex analyses.
Development of ASP.Net applications.
Report creation and data analysis.
Use of VBA and development of application concepts.
Software used: MS SQL Server, MS SQL Server Management Studio, MS SQL Server 2005/2008/2008 R2 BI Development Studio, Visual Studio 2008/2010, SSIS, SSRS, PL/SQL Developer, Excel 2010, TortoiseSVN.
Technologies used: T-SQL, PL/SQL, VB.Net, ASP.Net, Ajax, Webservices.

Aug 2010 - Dec 2011

1 year 5 months

Freelancer, BI Developer / Data Warehouse Developer

KPMG Frankfurt

Participated in a project auditing financial service providers (leasing, loans, funds, insurance).
Developed a data warehouse application for analyzing and processing large data sets.
T-SQL programming for complex queries.
Created reports and carried out data analyses.
Advised on MDX queries in a BI environment.
Used software: MS Excel, MS Word, MS SQL Server, MS SQL Server Management Studio, MS SQL Server 2005/2008/2008 R2 BI Development Studio, Visual Studio 2008, SSIS, SSRS.
Technologies used: T-SQL, VB.Net, VBA, VBScript, TortoiseSVN, SVN.

Apr 2010 - Jun 2010

3 months

Freelancer, Data Analyst / Data Warehouse Developer

Investment Bank Frankfurt

Prepared and validated business data during an insolvency.
Performed forensic data analyses.
Worked with LoanIQ, DMS and Summit systems.
Developed data workflows with SQL Server Integration Services including scripting.
Created reports with SQL Server Reporting Services and VB.Net.
Used software: MS Excel, MS Word, MS Access, MS SQL Server, MS SQL Server Management Studio, MS SQL Server BI Development Studio, Visual Studio 2010, SSIS, SSRS.
Technologies used: VBA, T-SQL, VB.Net.

Apr 2009 - Feb 2010

11 months

Freelancer, Developer / Consultant for Database and Access Solutions

Württembergische & Wüstenrot

Planned, designed, and developed Access projects based on MS SQL Server 2005.
Introduced SQL Server at the department level.
Developed various software applications, e.g. attendance planning and tracking software, workflow software for credit processing, production control applications, and Excel tools to support test/production database comparisons.
Coordinated the rollout of applications in cooperation with IT.
Trained staff.
Programmed application components on SQL Server (T-SQL).
Supported the department with analyses and reports using SQL Server BI Development Studio (Reporting Services), SSRS, Access, and Excel in close collaboration with a consulting firm.
Performed database analysis, documentation, and modeling with MS Visio.
Used software: MS Excel, MS Word, MS Access, MS SQL Server, MS SQL Server Management Studio, MS SQL Server BI Development Studio, MS Visio, SSRS.
Technologies used: VBA, T-SQL.

Feb 2009 - Mar 2009

2 months

Freelancer, Developer

regiocom GmbH

Developed a contract management solution for matching contract data.
Used software: Visual Studio 2005.
Technologies used: ASP.NET 2.0, Oracle database, Telerik controls.

Dec 2008 - Mar 2010

1 year 4 months

Freelancer, VBA Developer

Lidl

Developed a solution to merge data from Excel and Word sources into a contract document.
Automated creation of country-specific contracts.
Ported the application to Office 2007.
Used software: MS Excel, MS Word.
Technologies used: VBA, VBScript for distribution.

Sep 2008 - Dec 2008

4 months

Freelancer, Web/Intranet Developer

EnTeCo-Gmb - fischer Appelt-Media AG

Programming of an intranet site for Daimler AG to submit projects for the Environmental Leadership Award.
Development of an admin tool in MS Access with exports to MS Word and MS Excel.
Implemented data storage in MS SQL Server 2005.
Developed the user interface in ASP.NET 2.0.
Migrated legacy data from Lotus Notes.
Software used: MS Access, Visual Studio 2005, MS Excel, MS Word, MS SQL Server 2005, Lotus Notes.
Technologies used: SQL, VB.Net, VBA, ASP.NET, Ajax, JavaScript, WMI.

May 2008 - Aug 2008

4 months

Freelancer, IT Consultant 2nd-Level Infrastructure Support

Citi-Bank

Programming to optimize ITIL processes with MS Access and MS Excel.
Developed VB scripts and VBA solutions for MS Excel, MS Word and MS Outlook.
Improved and automated reporting and ticketing systems through standalone applications and scripts.
Software used: MS Access, MS Excel, MS Outlook, MS Word.
Technologies used: SQL, VBScript, VB, VBA, OLE, ActiveX, WSH, WMI, ADSI, LDAP.

Oct 2007 - Aug 2008

11 months

Freelancer, Web Developer

Bleichtor Internetauftritt Greifswald

Created a website to market condominiums in Greifswald.
Designed and implemented the website including layout and functionality.
Software used: MS Expression Studio, MS Access, MS Visual Studio 2005.
Technologies used: MS Access, ASP.NET 2.0, XHTML, CSS.

Oct 2007 - Aug 2008

11 months

Freelancer, Web Developer

Various Clients' Websites

Maintained and enhanced various websites for different clients.
Managed content and made technical adjustments.
Software used: MS Expression Studio.
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS.

Sep 2007 - Dec 2007

4 months

Freelancer, Web Developer

IBS-Ost

Created a website to market townhouses in Greifswald.
Implemented the layout, structure and functionality of the website.
Software used: MS Expression Studio.
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS.

Dec 2006 - Jun 2007

7 months

Zürich, Switzerland

Freelancer, IT Consultant / Business Consultant / Web Developer

ITA AG

IT consulting and business consulting.
Planning and creating a website.
Software used: MS Expression Studio.
Technologies used: JavaScript, XHTML, CSS.

Sep 2005 - Apr 2006

8 months

Austria

Freelancer, IT Consultant / Software Developer

Centurino GmbH

IT consulting and setup of a server-based network system and telephone infrastructure at a loan broker.
Business consulting in the lending business.
Development of software for loan application processing.
Software used: MS Access, MS Excel, MS Word.
Technologies used: VBA, VB, VBScript, OLE, ActiveX.

Feb 2005 - Aug 2008

3 years 7 months

Zürich, Switzerland

Freelancer, IT Consultant / Business Consultant

Challenge Marketing AG

IT consulting and setup of a server-based network system and telephone infrastructure.
Business consulting, management and support.
Address processing for marketing and sales purposes.
Creation of a website.
Software used: MS Access, MS Excel, MS Word, MS SQL Server.
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio.

Feb 2005 - Aug 2008

3 years 7 months

Zürich, Switzerland

Freelancer, IT Consultant / System Architect / Software Developer

Liquid First AG

IT consulting and setup of a server-based network system and telephone infrastructure.
Business consulting in the financial services environment.
Creation and implementation of software for application processing, including software modules for a call center.
Development of a website for application intake.
Remote support with PC Anywhere.
Software used: MS Access, MS Excel, MS Word, PC Anywhere.
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio.

Sep 2003 - Aug 2008

5 years

Zürich, Switzerland

Freelancer, IT Consultant / Software Developer

Phönix Finanzsanierungs AG

IT consulting and setup of a server-based network system and telephone infrastructure.
Business consulting in the field of financial restructuring.
Creation and implementation of software for application processing, including software modules for a call center.
Implementation of automated software distribution.
Software used: MS Access, MS Excel, MS Word, PC Anywhere.
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio, MSI, WMI.

Sep 2003 - Nov 2003

3 months

Austria

Managing Director, Head of Sales

Alpha Finanzsanierungs GmbH

Managing Director with responsibility for the company's sales.
Leading and controlling sales.
Personnel responsibility and operational management of sales activities.

May 2003 - Dec 2004

1 year 8 months

Zürich, Switzerland

Freelancer, IT Consultant / Business Consultant

creativ business marketing AG

IT consulting and setup of a server-based network system and telephone infrastructure.
Business consulting, maintenance and support of IT systems.
VBA programming and database development.
Software used: MS Access, MS SQL Server.
Technologies used: VBA.

Apr 2003 - Aug 2008

5 years 5 months

Zürich, Switzerland

Freelancer, IT Consultant / Software Developer

Globe Dienstleistungs-AG

IT consulting and business consulting for a credit card sales company.
Development and implementation of software for credit card application processing, including software modules for a call center.
Development of a website for online application submission.
Software used: MS Access, MS Excel, MS Word.
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio.

Oct 2002 - Jun 2009

6 years 9 months

Zürich, Switzerland

Freelancer, IT Consultant / Software Developer

Globe Advatage AG

IT consulting and setup of a server-based network system and telephone infrastructure at an asset manager.
Business consulting in the asset management environment.
Development and implementation of software for restructuring processing, including software modules for a call center.
Development of a website.
Software used: MS Access, MS Excel, MS Word.
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio, WMI.

Jan 2002 - Dec 2004

3 years

Zürich, Switzerland

Freelancer, IT Consultant / Software Developer

Euro Finanz Consult AG

IT consulting and setup of a server-based network system and telephone infrastructure.
Business consulting in the financial services sector.
Development and implementation of software for application processing, including software modules for a call center.
Software used: MS Access, MS Excel, MS Word.
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio.

Jan 2002 - Oct 2002

10 months

Rosenheim, Germany

Freelancer, IT Consultant / Software Developer

R&S GmbH

IT consulting, setting up a server-based network system and a telephony infrastructure.
Business consulting in the financial services sector.
Development and implementation of software for application processing, including software modules for a call center.
Software used: MS Access, MS Word.
Technologies used: VBA, VB.

Oct 2001 - Feb 2004

2 years 5 months

Freelancer, IT Consultant / Software Developer

Alpha Finanzsanierungs GmbH

IT consulting, setting up a server-based network system and a telephony infrastructure.
Business consulting in the area of financial restructuring.
Development and implementation of software for application processing in financial restructuring.
Support and assistance for the business units.
Software used: MS Access, MS Excel, MS Word.
Technologies used: VBA, VB, VBScript, OLE, ActiveX.

Oct 2001 - Aug 2003

1 year 11 months

Germany

Freelancer, IT Consultant / Software Developer

Birgits Finanzservice

IT consulting, setting up a server-based network system and a telephony infrastructure.
Business consulting in the area of financial restructuring.
Development and implementation of software for application processing in financial restructuring.
Administration and technical support of the solution.
Software used: MS Access, MS Excel, MS Word.
Technologies used: VBA, VB, VBScript, OLE, ActiveX.

Jan 2000 - Oct 2001

1 year 10 months

Rostock, Germany

Project Manager / Technical Department Head

Medeocom GmbH

Project manager for eBusiness projects in an internet systems house.
Head of technology department with personnel responsibility for up to 10 staff.
Technical consulting, support and maintenance of web, mail, DNS, shop, firewall, reporting and billing servers as well as routers for leased lines and dial-up connections.
Consulting for software and web development.
Advising, designing and preparing proposals for technical solutions for existing and new clients.
Automating processes with VBScript.
Environment used: Windows, IIS, Mercury, Bind, Cisco, Bintec, Intershop, NT server.

Jan 1999 - Dec 2000

2 years

Rostock, Germany

Authorized Signatory / Managing Director

Telemaxx GmbH

Authorized signatory / managing director with responsibility for up to 10 internal staff.
Operation and support of a call center system (Micrologica-Siemens) with 30 workstations.
Technical negotiations with Siemens as technology partner.
Sales of the Micrologica solution.
Environment used: Windows NT 4.0, Novell NetWare, connection to DLV 2000 via fiber optics.

Jan 1997 - Dec 1999

3 years

Freelancer, IT Technician / Developer

Freelance work for DLV 2000

Technical support for the IT system with Thin Ethernet and Ethernet structures.
Administration of a Novell NetWare server and clients running MS Windows 3.0/95.
Further development of the company software based on MS Access 2.0.
VBA programming to extend and automate business processes.

Jan 1995 - Dec 1996

2 years

Freelancer, VBA / MS Access Developer

Freelance work

Initial VBA programming and MS Access projects.
Developed an application for property management for a property developer.
Developed a customer database (ECOSYL) for a farmers' association.

Summary

Over 20 years of experience developing database-driven applications in Windows and web environments. I have gained extensive experience in various industries (especially financial services, direct marketing, call centers, data centers) and with different technical requirements and business process analysis. I have also gathered a lot of experience in creating functional and IT concepts when building and planning physical infrastructure. I have very good analytical skills. After initially developing database-driven applications, I have specialized in DWH development on the Microsoft platform in recent years. I am currently interested in developing BI solutions using MS SQL Server and the SSIS, SSAS, and SSRS tools. I am familiar with Kimball and Data Vault designs and have applied them in several projects. I am always looking for new challenges, for example in data science or Power BI. I also gained first experience with QlikView at the Rostock-based company systeon GmbH.