Guido Klein-Report Developer Power BI
Check rate
Experience
NOBILIS Group GmbH
- Support in SSRS implementation, including training staff on SSRS
Mitsubishi Electric Europe B.V.
Analysis of six MS SQL databases
Creating a migration concept for the SAP R/3 to S/HANA migration
Development and design of the DWH
Development of staging, DWH, and analysis data mart
Data extraction from SAP HANA
Software used: MS SQL Server 2016, MS Data-Tools 2019, SSMS, SSIS (Theobald), Azure DevOps
Technologies used: T-SQL, SSIS, MS SQL-Server project
Report Developer Power BI
BSH Hausgeräte GmbH
- Customizing and developing new Power BI reports, including data import and preparation
Requirements Engineer / Business Analyst
Raiffeisen Software GmbH
Business analyses from DWH data in regulatory reporting/GMP (AuRep)
Analyses in FMS, FinRep solo, AnaCredit, VERA, WPC, KC, and SC for reports to the OeNB (ABACUS system) and to the Deutsche Bundesbank (B&N model), covered bond reporting, AWV reporting
Building analysis data marts
Bundesbank reporting, SSD reports for OeNB
Developing test and monitoring tools
Writing tests
Working with 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 using the Data Vault 2.0 methodology
Creating analyses and processing company data in collaboration with business units
Requirements analysis, data cleansing and modeling for analyses and reports
Creation and further development of existing reports
Designing solutions in Business Intelligence / Data & Analytics
Building Data-Marts
Report creation using Power BI
Developing 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 unit
Reporting, e.g., in the areas of validated results and invoice allocation
Creating reports
Setting up testing and monitoring tools
Working according to SCRUM, KANBAN
Power BI Report Server
Processing geospatial data
Used software: MS SQL Server 2017, MS Data Tools 2017, SSMS, SSIS and SSRS, Power BI, Git, TFS
Technologies: T-SQL, SSIS, SSRS, Python
Requirements Engineer / Business Analyst
Raiffeisen Software GmbH
Business analyses of DWH data in the reporting/GMP area (AuRep)
Analyses in the areas of FMS, FinRep solo, AnaCredit, VERA, WPC, KC, and SC for reporting to the OeNB (ABACUS system) and the Deutsche Bundesbank (B&N model)
Building analytical data marts
Bundesbank reporting, SSD reports to OeNB
Setting up testing and monitoring tools
Working according to SCRUM
Creating prototypes
Used software: MS SQL Server 2014/2016, MS Data Tools 2015/17, SSMS, SSIS and SSRS, Jira, Confluence
Technologies: T-SQL, C#, VB.Net, SSIS, SSRS
BI Consultant / DWH Developer
Gruner + Jahr
Developing ETL processes for various data sources, e.g., SAP, MobileIron, Foreman, etc.
Architecture and deployment process consulting
Database design
Design and implementation of business requirements
Connecting web services (REST and SOAP)
Used software: MS SQL Server 2014, MS Data Tools 2013, SVN, Theobald
Technologies: T-SQL, C#, SSIS, VB.Net
BI Consultant / DWH Developer
Bayer Vital
Developing ETL processes for various data sources, e.g., SAP, Salesforce
Architecture and deployment process consulting
Database design, cube design
Design and implementation of business requirements
Reporting for CRM system within the SharePoint environment
Developing analyses and concepts
Used software: MS SQL Server 2008R2/2014, MS Data Tools 2013, TFS 2010, cMore-Connect, Theobald
Technologies: T-SQL, C#, SSRS, SSIS, SSAS, VB.Net
BI Consultant / DWH Developer
AutoScout 24
Creating the architecture for ETL, DWH, and analytics processes
Developing data marts for various data sources (Salesforce, Hadoop, Oracle, MySQL)
Database design, cube design
Setting up and maintaining the database environment
Performance and availability of the database systems (service)
Performance optimization: optimizing and continuously improving the databases
Design and implementation of business requirements
Developing analyses and concepts
Used software: MS SQL Server 2012, MS Visio, MS Data Tools 2010/2012/2014, GIT, TFS
Technologies: T-SQL, C#, SSRS, SSIS, SSAS
BI Consultant / DWH Developer
Axel Springer SE
Development of reports based on ITIL data (ServiceNow)
Used software: MS SQL Server 2008 (R2)
Used technologies: T-SQL, VB.Net, SSRS, SSIS, SSAS
SSRS, SSAS, SSIS Developer
Daimler TSS GmbH
Development of data mart applications for internal reporting
Report integration in a SharePoint environment
Used software: MS SQL Server 2008 (R2), MS SQL Server 2012, MS TFS, MS Visio
Used technologies: 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 business requirements
Data protection and security, rights and role management, permission concept
Used software: MS SQL Server 2008 (R2), MS SQL Server 2012, DeltaMaster, Sybase PowerDesigner
Used technologies: T-SQL, VB.Net, SSRS, SSIS, SSAS
Reporting Services Developer
T-Systems
Development of an assembly for rendering extension, specifically for a custom CSV export of reports
Concept, design and implementation
VB.Net development
Used software: MSRS 2008R2, Visual Studio 2008
Used technologies: VB.Net
BI Developer for MS SQL 2005-2008R2 applications
Prinovis Ltd.
Applications for operational reporting, data mart and DWH analyses in accounts receivable and energy management
Applications for billing, planning tools, application design
T-SQL programming, ASP.Net development, report creation, data analysis, VBA, creation of application designs
Used software: 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
Used technologies: T-SQL, PL-SQL, VB.Net, ASP.Net, Ajax, Web services
Collaborating on a project for auditing financial service providers
KPMG
Data warehouse application for analysis and processing of large data sets in the leasing, loans, funds, and insurance sectors
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
Investmentbank Frankfurt
Data preparation and validation of business data in the context of insolvency
Forensic data analysis in LoanIQ, DMS, and Summit systems
Development of data workflows with SQL Server Integration Services including scripting
Reports via 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
Planning, design, and development of Access projects (on MS SQL Server 2005)
Implementation of SQL Server at department level
Development of various software applications, including attendance planning and tracking software, workflow software for loan processing, production control applications, and an Excel tool to support test-production database comparison
Coordinating application rollouts with the IT department, training staff
Programming application components on SQL Server (T-SQL)
Supporting the controlling department with the creation of reports and analyses using SQL Server BI-Dev Studio (Reporting Services), report server projects (SSRS), Access, and Excel
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
Developing a contract management solution for reconciling contract data
Software used: Visual Studio 2005
Technologies used: ASP.NET 2.0, Oracle DB, Telerik controls
Lidl
Programming data merging from Excel and Word sources into a contract document and automating generation of country-specific contracts
Porting 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 project proposals for the Environmental Leadership Award
Administration tool in MS Access with exports to MS Word and MS Excel, data storage in MS SQL Server 2005, user interface in ASP.NET 2.0
Migration of 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 Technology Infrastructure
Citi-Bank
Developed programs to optimize ITIL processes (MS Access, MS Excel, VBScript, VBA for MS Excel, MS Word, and MS Outlook)
Improved and automated the reporting and ticketing system using 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
Website for marketing terraced houses in Greifswald
Software used: MS Expression Studio
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS
IT consulting, Business Consulting
ITA AG
Created website
Software used: MS Expression Studio
Technologies used: JavaScript, XHTML, CSS
IT consulting, setting up a server-based network system and telephone infrastructure
Centurino GmbH
Business Consulting
Developed software for loan application processing
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VB-Script, OLE, ActiveX
IT consulting, setting up a server-based network system and telephone infrastructure
Challenge Marketing AG
Business Consulting, support and maintenance
Prepared address data for marketing
Created website
Software used: MS Access, MS Excel, MS Word, MS SQL Server
Technologies used: VBA, VB, VB-Script, OLE, ActiveX, ASP.Net 2.0, Visual Studio
IT consulting, setting up a server-based network system and telephone infrastructure
Liquid First AG
Developed and implemented software for application processing incl. software modules for CallCenter
Created website for application intake
Software used: MS Access, MS Excel, MS Word, PC Anywhere
Technologies used: VBA, VB, VB-Script, OLE, ActiveX, ASP.Net 2.0, Visual Studio
IT consulting, setting up a server-based network system and telephone infrastructure
Phönix Finanzsanierungs AG
Business Consulting
Developed and implemented software for application processing incl. software modules for CallCenter
Automated software distribution
Software used: MS Access, MS Excel, MS Word, PC Anywhere
Technologies used: VBA, VB, VB-Script, OLE, ActiveX, ASP.Net 2.0, Visual Studio, MSI, WMI
Managing Director, Head of Sales of the GmbH
Alpha Finanzsanierungs GmbH
IT consulting, setup of a server-based network system and telephone infrastructure
Creativ Business Marketing AG
Business consulting, support and maintenance
Software: VBA programming, MS Access, MS SQL Server
IT and business consulting
Globe Dienstleistungs-AG
Development and implementation of software for credit card application processing, incl. software modules for call centers
Development of a website for application submission
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
Globe Advantage AG
Business consulting
Development and implementation of software for restructuring processing, incl. software modules for call centers
Development of 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 telephone infrastructure
Euro Finanz Consult AG
Business consulting
Development and implementation of software for application processing, incl. software modules for call centers
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
R&S GmbH Rosenheim
Business consulting
Development and rollout of application processing software including software modules for call centers
Software: VBA programming, MS Access, MS Word
IT consulting, setup of a server-based network system and telephony infrastructure
Alpha Finanzsanierungs GmbH
Business consulting
Development and rollout of application processing software for financial restructuring
Maintenance and support
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VBScript, OLE, ActiveX
IT consulting, setup of a server-based network system and telephony infrastructure
Birgits Finanzservice
Business consulting
Development and rollout of application processing software for financial restructuring
Maintenance and support
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VBScript, OLE, ActiveX
Project manager, head of technical department with personnel responsibility
MEDEOCOM GmbH
Project management of an eBusiness project, system engineering consulting
Support and maintenance of web, mail, DNS, shop, firewall, reporting, billing servers, routers for dedicated and dial-up lines
Consulting for software and web development
Consulting, planning, and proposal preparation of technical solutions for existing and new clients
Environment: automation with VBScript, Windows, IIS, Mercury, BIND, Cisco, Bintec, INTERSHOP, NT servers
Authorized officer / 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, connection to DLV 2000 fiber optic
Freelancer
DLV 2000
- Technical support of the IT system (Thin Ethernet and Ethernet)
- Server: Novell NetWare, Clients: MS Windows 3.0 / 95
- Company software: VBA programming, based on MS Access 2.0 (further development)
Freelancer
- First VBA programming
- MS Access projects for Franz & Meyer (property developer) (housing management)
- ECOSYL (customer database) for the farmers' association
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Banking and Finance, Professional Services, Advertising, Manufacturing, and Real Estate.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Customer Service, Finance, Product Development, and Marketing.
Summary
Over 20 years of experience developing database-driven applications in Windows and web environments. During this time, 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 business process analysis. When building and planning the physical infrastructure, I gained extensive experience in creating functional and IT concepts. I have very good analytical skills. After initially developing database-driven application programs, I have specialized in DWH developments on the Microsoft platform in recent years. I am currently interested in developing BI solutions using MS SQL Server and the tools SSIS, SSAS, and SSRS. I am familiar with Kimball and Data Vault designs and have applied them in projects multiple times. I am constantly looking for new challenges, e.g. in data science or Power BI. I also gained initial experience with QlikView at the Rostock 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 Xcselsius, Tortoisesvn, Git, Ms Tfs, Jira, Hp Alm, Confluence
- Strengths: Strong Ability To Abstract, Strong Technical Understanding, Quick Comprehension, Willingness To Dive Into New Topics, Customer-oriented Problem Solving, Communication Skills With Non-technical Departments
Languages
Education
University of Rostock
Physics studies · Rostock, Germany
Statistics
Experience
Global Experience
Expertise
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Guido based?
What languages does Guido speak?
How many years of experience does Guido have?
What roles would Guido be best suited for?
What companies has Guido worked for in recent years?
Which industries is Guido most experienced in?
Which business areas is Guido most experienced in?
Which industries has Guido worked in recently?
Which business areas has Guido worked in recently?
What is Guido's education?
What is the availability of Guido?
What is the rate of Guido?
How to hire Guido?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Germo Görtz
Ronny Herold
William Nguyen
German Popken
Vitali Haberkorn
Marco Skulschus
Stefan Corsten
Andre Wroblewski
Torsten Glunde
Evrim İlden
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a
Stefan Wimmer
Vitali Haberkorn
Germo Görtz
Stefan Corsten
Peter Glöckner
Guino Ndjenndja
Thomas Reick
German Popken
Marco Skulschus
Jochen Rieseberg
Nearby freelancers
Professionals working in or nearby Rostock, Germany
Tobias Stötzer
Michele Heine
Robert Giering
Reza Moini
Jörg Schmidt
Diana Fölsch
Reimar Gluth
Michael Schütt
Norman Richter
Daniela Reinert
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
