Guido Klein
Power BI Report Developer
Experience
NOBILIS Group GmbH
- Support in the introduction of SSRS including SSRS training for employees
Mitsubishi Electric Europe B.V.
Analysis of the 6 MS SQL databases
Creation of a migration concept as part of the SAP R/3 to S/HANA migration
Development and planning of the DWH
Development of staging, DWH, and analytical datamart
Extraction of 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
Power BI Report Developer
BSH Hausgeräte GmbH
- Customization and new development of Power BI reports including data import and preparation
Requirements Engineer / Business Analyst
Raiffeisen Software GmbH
Business analyses from DWH data in the area of regulatory reporting/GMP (AuRep)
Analyses for FMS, FinRep solo, AnaCredit, VERA, WPC, KC, and SC for submissions to the OeNB (ABACUS system) and the Deutsche Bundesbank (B&N model), covered bond reports, and AWV reports
Creation of analytical datamarts
Deutsche Bundesbank reporting, SSD reporting to OeNB
Development of testing and monitoring tools
Writing tests
Working in SCRUM
Creating prototypes
Power BI
Software used: MS SQL Server 2019/2022, MS Data Tools 2019/2022, SSMS, SSIS and SSRS, Jira, Confluence, Azure Data Studio, Power BI Desktop
Technologies used: T-SQL, C#, VB.NET, SSIS, SSRS
BI Consultant / DWH Developer
Eurofins NDSC Umweltanalytik GmbH
BI and DWH engineering according to Data Vault 2.0 methodology
Creating analyses and preparing company data in collaboration with business units
Requirements analysis, cleansing, and modeling of data for analyses and reports
Creating and improving existing reports
Designing solutions in business intelligence / data & analytics
Building data marts
Report development using Power BI
Development of new and existing BI solutions
Software used: MS SQL Server 2017, MS Data Tools 2019, SSMS, SSIS and SSRS, Power BI, TFS, Azure Data Studio
Technologies used: T-SQL, SSIS, SSRS
BI Consultant / DWH Developer
Eurofins Information Systems GmbH
Connecting data sources to the DWH (Data Vault 2.0)
Ad hoc analyses for the business department
Reports and analyses, e.g. in the area of validated results and invoice allocation
Creating reports
Development of test and monitoring tools
Working according to SCRUM, KANBAN
Power BI Report Server
Processing geodata
Software used: MS SQL Server 2017, MS Data Tools 2017, SSMS, SSIS and SSRS, Power BI, Git, TFS
Technologies used: T-SQL, SSIS, SSRS, Python
Requirements Engineer / Business Analyst
Raiffeisen Software GmbH
Business analyses of DWH data in the area of regulatory reporting/GMP (AuRep)
Analyses for FMS, FinRep solo, AnaCredit, VERA, WPC, KC and SC for reports to the OeNB (ABACUS system) and the Deutsche Bundesbank (B&N model)
Building analysis data marts
Bundesbank reporting, SSD reports to OeNB
Development of test and monitoring tools
Working in SCRUM
Creating prototypes
Software used: MS SQL Server 2014/2016, MS Data Tools 2015/17, SSMS, SSIS and SSRS, Jira, Confluence
Technologies used: T-SQL, C#, VB.Net, SSIS, SSRS
BI Consultant / DWH Developer
Gruner + Jahr
Developing ETL processes on various data sources, including SAP, MobileIron, Foreman, etc.
Architecture and deployment process consulting
Database design
Designing and implementing business requirements
Connecting to web services (REST and SOAP)
Software used: MS SQL Server 2014, MS Data Tools 2013, SVN, Theobald
Technologies used: T-SQL, C#, SSIS, VB.Net
BI Consultant / DWH Developer
Bayer Vital
Developing ETL processes on various data sources, including SAP, Salesforce
Architecture and deployment process consulting
Database design, cube design
Designing and implementing business requirements
Reporting for CRM system within the SharePoint environment
Developing analyses and concepts
Software used: MS SQL Server 2008R2/2014, MS Data Tools 2013, TFS 2010, cMore Connect, Theobald
Technologies used: T-SQL, C#, SSRS, SSIS, SSAS, VB.Net
BI Consultant / DWH Developer
AutoScout 24
Defining the architecture of ETL, DWH and analysis processes
Developing data marts on various data sources (Salesforce, Hadoop, Oracle, MySQL)
Database design, cube design
Setting up and managing the database environment
Performance and availability of the database systems (service)
Performance optimization: optimizing and continuously improving the databases
Designing and implementing business requirements
Developing analyses and concepts
Software used: MS SQL Server 2012, MS Visio, MS Data Tools 2010/2012/2014, Git, TFS
Technologies used: T-SQL, C#, SSRS, SSIS, SSAS
BI Consultant / DWH Developer
Axel Springer SE
Report development on ITIL data (ServiceNow)
Software used: MS SQL Server 2008 (R2)
Technologies used: T-SQL, VB.Net, SSRS, SSIS, SSAS
SSRS, SSAS, SSIS Developer
Daimler TSS GmbH
Development of data mart applications for internal reporting
Report integration into 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
SSRS, SSAS, SSIS Developer
Bauer Systems KG
Setup and maintenance of the database environment
Performance monitoring: ensuring performance and availability of the database systems (service)
Performance optimization: optimizing and continuously improving the databases
Design and implementation of functional requirements
Data protection and data security, rights and role management, authorization concept
Software used: MS SQL Server 2008 (R2), MS SQL Server 2012, DeltaMaster, Sybase PowerDesigner
Technologies used: T-SQL, VB.Net, SSRS, SSIS, SSAS
Reporting Services Developer
T-Systems
Development of an assembly for the rendering extension, specifically for a customized CSV export of reports
Idea, design and implementation
VB.Net development
Software used: MSRS 2008R2, Visual Studio 2008
Technologies used: VB.Net
BI Developer for MS-SQL 2005-2008R2 Applications
Prinovis Ltd.
Applications for operational reporting, data mart, and data warehouse analyses in the areas of accounts receivable and energy management
Applications for billing, planning tools, application conception
T-SQL programming, ASP.Net development, report creation, data analysis, VBA, creation of application concepts
Software used: MS SQL Server, MS SQL Server Management Studio, MS SQL Server 2005/08/08R2 BI-Dev Studio, Visual Studio 2008/10, SSIS, SSRS, PL-Developer, Excel 2010, TortoiseSVN
Technologies used: T-SQL, PL-SQL, VB.Net, ASP.Net, Ajax, Webservices
Collaborated on an auditing project for financial service providers
KPMG
Data warehouse application to analyze and process large volumes of data in leasing, loans, funds, and insurance
T-SQL programming, report creation, data analysis, consulting on MDX queries
Software used: MS Excel, MS Word, MS SQL Server, MS SQL Server Management Studio, MS SQL Server 2005/08/08R2 BI Dev Studio, Visual Studio 2008, SSIS, SSRS
Technologies used: T-SQL, VB.Net, VBA, VBScript, TortoiseSVN, SVN
Investment Bank Frankfurt
Prepared and validated business data for insolvency proceedings
Conducted forensic data analysis in LoanIQ, DMS, and Summit systems
Developed data workflows with SQL Server Integration Services, including scripting
Produced reports using SQL Server Reporting Services or VB.Net
Software used: MS Excel, MS Word, MS Access, MS SQL Server, MS SQL Server Management Studio, MS SQL Server BI Dev Studio, Visual Studio 2010, SSIS, SSRS
Technologies used: VBA, T-SQL, VB.Net
Württembergische & Wüstenrot
Planned, designed, and developed Access projects (on MS SQL Server 2005)
Introduced SQL Server at the department level
Developed various software applications, including attendance planning and tracking software, workflow software for loan processing, production control applications, and an Excel tool to support test-to-production database comparison
Coordinated application rollout with IT and trained staff
Programmed application components on SQL Server using T-SQL
Supported the department with creating reports and analyses using SQL Server BI Dev Studio (Reporting Services), report server projects (SSRS), Access, and Excel
Performed database analysis, documentation, and modeling with MS Visio
Software used: MS Excel, MS Word, MS Access, MS SQL Server, MS SQL Server Management Studio, MS SQL Server BI Dev Studio, MS Visio, SSRS
Technologies used: VBA, T-SQL
Regiocom GmbH
Developed a contract management solution for reconciling contract data
Software used: Visual Studio 2005
Technologies used: ASP.NET 2.0, Oracle DB, Telerik controls
Lidl
Programmed data merging from Excel and Word sources into a contract document and automated creation of country-specific contracts
Ported the application to Office 2007
Software used: MS Excel, MS Word
Technologies used: VBA, VBScript
EnTeCo-GmbH - Fischer Appelt-Media AG
Developed an intranet site for Daimler AG to submit projects for the Environmental Leadership Award
Administration tool in MS Access with exports to MS Word and MS Excel, data stored in MS SQL Server 2005, 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
IT Consultant 2nd Level Support - Infrastructure Technology
Citi-Bank
Developed code to optimize ITIL processes (MS Access, MS Excel, VBScript, VBA for MS Excel, MS Word and MS Outlook)
Improved and automated reporting and ticketing systems with 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
Freelancer
Maintained various websites
Software used: MS Expression Studio
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS
Freelancer
Created a website to market condominiums in Greifswald
Software used: MS Expression Studio, MS Access, MS Visual Studio 2005
Technologies used: MS Access, ASP.Net 2.0, XHTML, CSS
IBS-Ost
Developed a website to market townhouses in Greifswald
Software used: MS Expression Studio
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS
IT consulting, business consulting
ITA AG
Created website
Used software: MS Expression Studio
Technologies used: JavaScript, XHTML, CSS
IT consulting, setup of a server-based network system and telephone infrastructure
Centurino GmbH
Business consulting
Developed software for credit application processing
Used software: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VBScript, OLE, ActiveX
IT consulting, setup of a server-based network system and telephone infrastructure
Challenge Marketing AG
Business consulting, maintenance and support
Data preparation for marketing
Created website
Used software: MS Access, MS Excel, MS Word, MS SQL Server
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.Net 2.0, Visual Studio
IT consulting, setup of a server-based network system and telephone infrastructure
Liquid First AG
Developed and implemented software for application processing including modules for call center
Created a website for application submission
Used software: MS Access, MS Excel, MS Word, PC Anywhere
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.Net 2.0, Visual Studio
IT consulting, setup of a server-based network system and telephone infrastructure
Phönix Finanzsanierungs AG
Business consulting
Developed and implemented software for application processing including modules for call center
Automated software distribution
Used software: MS Access, MS Excel, MS Word, PC Anywhere
Technologies used: VBA, VB, VBScript, OLE, ActiveX, ASP.Net 2.0, Visual Studio, MSI, WMI
Managing Director, Head of Sales
Alpha Finanzsanierungs GmbH
IT consulting, setup of a server-based network system and telephony infrastructure
Creativ Business Marketing AG
Business consulting, support and maintenance
Software: VBA programming, MS Access, MS SQL Server
IT consulting, business consulting
Globe Dienstleistungs-AG
Development and implementation of software for processing credit card applications including software modules for a call center
Creation of a website for receiving applications
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VB-Script, OLE, ActiveX, ASP.NET 2.0, Visual Studio
IT consulting, setup of a server-based network system and telephony infrastructure
Globe Advantage AG
Business consulting
Development and implementation of software for restructuring processing including software modules for a call center
Creation of a website
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VB-Script, OLE, ActiveX, ASP.NET 2.0, Visual Studio, WMI
IT consulting, setup of a server-based network system and telephony infrastructure
Euro Finanz Consult AG
Business consulting
Development and implementation of software for processing applications including software modules for a call center
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VB-Script, OLE, ActiveX, ASP.NET 2.0, Visual Studio
IT Consulting, setup of a server-based network system and telephone infrastructure
R&S GmbH Rosenheim
Business Consulting
Development and rollout of software for application processing, including software modules for call centers
Software: VBA programming, MS Access, MS Word
IT Consulting, setup of a server-based network system and telephone infrastructure
Alpha Finanzsanierungs GmbH
Business Consulting
Development and rollout of software for application processing in financial restructuring
Support and maintenance
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VB-Script, OLE, ActiveX
IT Consulting, setup of a server-based network system and telephone infrastructure
Birgits Finanzservice
Business Consulting
Development and rollout of software for application processing in financial restructuring
Support and maintenance
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VB-Script, OLE, ActiveX
Project manager, head of technical department with personnel responsibility
MEDEOCOM GmbH
Project lead for an eBusiness project, technical consulting
Support and maintenance of web, mail, DNS, shop, firewall, reporting, and billing servers, routers for fixed and dial-up lines
Consulting for software and web development
Advising, designing, and preparing proposals for technical solutions for existing and new clients
Environment: automation with VB-Script, Windows, IIS, Mercury, Bind, Cisco, Bintec, INTERSHOP, NT server
Authorized signatory / Managing Director
Telemaxx GmbH
Operation and support of a call center system (Micrologica-Siemens) with 30 workstations
Technical negotiations with Siemens as a technology partner and sales of Micrologica
Environment: Windows NT 4.0, Novell NetWare, DLV 2000 fiber optic link
Freelancer
DLV 2000
- Technical support for IT system Thin Ethernet - Ethernet
- Server: Novell NetWare, Clients: MS Windows 3.0 / 95
- Company software: VBA development, based on MS Access 2.0 (further development)
Freelancer
- First VBA development
- MS Access projects for Franz & Meyer (property developer) (housing management)
- ECOSYL (customer DB) for farmers' association
Summary
Over 20 years of experience in developing database-driven applications in Windows and web environments. In the process, I have gained extensive experience in various industries (especially financial services, direct marketing, call centers, data centers) and with a wide range of technical requirements and in analyzing business processes. When building and planning the physical infrastructure, I gained extensive experience in creating functional specifications and IT concepts. I have very good analytical skills. After initially developing database-driven application programs, I have in recent years specialized in DWH developments on the Microsoft platform. My interest currently focuses on 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 been able to apply them in multiple projects. I am constantly looking for new challenges, for example in the area of data science or Power BI. I have also gained initial experience with QlikView at the Rostock-based company systeon GmbH.
Skills
- Preferred Technical Environment: Ms Sql Including Ms-sdt (Ssis, Ssrs, Ssas), Power Bi, Ms Access, Ms Excel, Ms Word, Ms Outlook (Vba Including Vbscript Programming), .Net Including Ajax
- Preferred Areas Of Work: Dwh Development, Database Design And Development, Application Design And Development, Technical And Strategic Concepts, Code And Sql Optimization
- Programming Languages: Vba, Vbscript, Asp.net, Vb.net, Html, Javascript, Css, Ajax, T-sql, M, Dax
- Databases: Ms Sql Server 7.0-2022, Ms Access, Oracle
- Extensive Experience In: Requirements Analysis, Data Modeling, Identifying And Optimizing Business Processes, Application Development In Web And Windows Environments
- Tools: Ms Visual Studio 2005/2008/2010/2012/2013/2015/2017/2019/2022, Ms Data Tools 2010-2022, Ms Office Programs 2.0-2024 (Vba Programming), Database Development And Documentation With Ms Visio, Crystal Xcelsius, Tortoisesvn, Git, Ms Tfs, Jira, Hp Alm, Confluence
- Strengths: Strong Abstract Thinking, High Technical Understanding, Quick Grasp, Willingness To Learn New Topics, Customer-oriented Problem Solving, Communication Skills With Non-technical Departments
Languages
Education
University of Rostock
Physics studies · Rostock, Germany
Similar Freelancers
Discover other experts with similar qualifications and experience
BI Developer
Senior Business, IT and Data Analyst, Portfolio Analyst
Microsoft BI Specialist
Power BI Expert
Product Owner Frontend
SSIS Development
PRINCE2® Foundation Examination
Interim Controller
Business / Functional Analyst and Oracle Developer DWH
BI consultant
Founder and Managing Director
Senior Data Engineer
Microsoft Azure Synapse and Power BI Developer
Business Data Analyst | PowerBI & Microsoft SQL Server
Quality Assurance Manager (QSV)
Architect & Technical Team Lead & Senior Developer
T-SQL Database Expert
Requirements Engineer
Business Analyst, Data Warehouse Developer
BI Consultant and Power BI Developer
Independent IT Consultant
Measurement data provisioning via LoRa
Contractor
External IT Consultant BI and DWH
Senior Data Architect & Data Engineer
Data Engineer
Data Warehouse Consultant (Development and Analysis)
Digital Finance Consulting – Advanced Data Analysis
Database Expert and Software Developer
