Guido Klein
Report Developer Power BI
Experience
NOBILIS Group GmbH
- support in implementing SSRS including training employees on SSRS
Mitsubishi Electric Europe B.V.
Analysis of the 6 MS SQL databases
Creating a migration concept as part of the SAP migration from R/3 to S/HANA
DWH development and design
Development of staging, DWH, and analysis 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
Report Developer Power BI
BSH Hausgeräte GmbH
- modifying and creating new Power BI reports including data import and preparation
Requirements Engineer / Business Analyst
Raiffeisen Software GmbH
Business analyses of DWH data in the field of reporting/GMP (AuRep)
Analyses in the areas of 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 datamarts
Reporting to the Bundesbank, SSD reports to OeNB
Developing test and monitoring tools
Writing tests
Working according to 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 preparing corporate data in collaboration with business departments
Requirements analysis, cleaning, and modeling data for analyses and reports
Creating and further developing existing reports
Designing solutions in the area of business intelligence / data & analytics
Building data marts
Reporting 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 department
Reporting, among others in validated results and invoice allocation
Creating reports
Building 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 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)
Building analytical data marts
Bundesbank reporting, OeNB SSD reports
Building test and monitoring tools
Working according to 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 for various data sources including SAP, MobileIron, Foreman, etc.
Consulting on architecture and deployment processes
Database design
Designing and implementing business requirements
Connecting 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 for various data sources including SAP, Salesforce
Consulting on architecture and deployment processes
Database design, cube design
Designing and implementing business requirements
Reporting for the 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 for 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
Developed reports 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
Developed data mart applications for internal reporting
Integrated 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
SSRS, SSAS, SSIS Developer
Bauer Systems KG
Set up and maintained the database environment
Performance monitoring: ensured performance and availability of the database systems (the service)
Performance optimization: optimized and continuously improved the databases
Designed and implemented business requirements
Data protection and security, rights and role management, permission 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
Developed 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 MS-SQL 2005-2008 R2 Applications
Prinovis Ltd.
Developed applications for operational reporting, data mart, and data warehousing analyses in accounts receivable and energy management
Applications for billing, planning tools, and application design
T-SQL programming, ASP.Net development, report creation, data analysis, VBA, and developing 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
Worked on the auditing project for financial services providers
KPMG
DWH application for analyzing and processing large volumes of data in leasing, loans, funds, 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
Data preparation and validation of business data in insolvency proceedings
Forensic data analysis in LoanIQ, DMS, Summit systems
Data workflow development 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)
Introduction 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, Excel tool to support test-production DB comparison
Coordination of application rollouts in collaboration with IT, training of employees
Programming application components on SQL Server (T-SQL)
Supporting the department in creating reports and analyses with 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
Developed a contract management solution to reconcile 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
Programming an intranet site for Daimler AG for project submission to 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
Programming to optimize ITIL processes (MS Access, MS Excel, VB Scripting, VBA for MS Excel, MS Word and MS Outlook)
Improving and automating reporting and ticket system 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
Freelancer
Maintenance of various websites
Software used: MS Expression Studio
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS
Freelancer
Creation of 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 townhouses in Greifswald
Software used: MS Expression Studio
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS
IT Consulting, Business Consulting
ITA AG
Creation of a website
Used software: MS Expression Studio
Used technologies: JavaScript, XHTML, CSS
IT Consulting, Setup of a Server-Based Network System and Telephony Infrastructure
Centurino GmbH
Business Consulting
Development of software for loan application processing
Used software: MS Access, MS Excel, MS Word
Used technologies: VBA, VB, VBScript, OLE, ActiveX
IT Consulting, Setup of a Server-Based Network System and Telephony Infrastructure
Challenge Marketing AG
Business Consulting, maintenance and support
Address processing for marketing
Creation of a website
Used software: MS Access, MS Excel, MS Word, MS SQL Server
Used technologies: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio
IT Consulting, Setup of a Server-Based Network System and Telephony Infrastructure
Liquid First AG
Development and rollout of software for application processing including modules for call center
Creation of a website for application intake
Used software: MS Access, MS Excel, MS Word, PC Anywhere
Used technologies: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio
IT Consulting, Setup of a Server-Based Network System and Telephony Infrastructure
Phönix Finanzsanierungs AG
Business Consulting
Development and rollout of software for application processing including modules for call center
Automated software distribution
Used software: MS Access, MS Excel, MS Word, PC Anywhere
Used technologies: VBA, VB, VBScript, OLE, ActiveX, ASP.NET 2.0, Visual Studio, MSI, WMI
Managing Director, Head of Sales of the GmbH
Alpha Finanzsanierungs GmbH
IT consulting, building 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 credit card application processing including software modules for call centers
Creation 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, building 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 call centers
Creation of a web presence
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, building a server-based network system and telephony infrastructure
Euro Finanz Consult AG
Business consulting
Development and implementation of software for application processing including 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 implementation of application processing software, including software modules for the call center
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 implementation of application processing software in financial restructuring
Maintenance and support
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 telephony infrastructure
Birgits Finanzservice
Business Consulting
Development and implementation of application processing software in financial restructuring
Maintenance and support
Used software: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VBScript, OLE, ActiveX
Project manager, head of technical department with staff responsibility
MEDEOCOM GmbH
Project management of eBusiness project, technical system consultancy
Support and maintenance of web, mail, DNS, shop, firewall, analysis, billing servers, routers for dedicated and dial-up lines
Consulting for software and web development
Consulting, planning, and proposal creation for technical solutions for existing and new customers
Environment: automation with VBScript, Windows, IIS, Mercury, Bind, Cisco, Bintec, INTERSHOP, NT server
Authorized signatory / Managing Director
Telemaxx GmbH
Operation and support of call center system (Micrologica-Siemens) with 30 workstations
Technical negotiations with Siemens as technology partner and distributor of Micrologica
Environment: Windows NT 4.0, Novell NetWare, DLV 2000 fiber optic connection
Freelancer
DLV 2000
- Technical support for IT system Thin Ethernet - Ethernet
- Server: Novell NetWare, Clients: MS Windows 3.0 / 95
- In-house software: VBA programming, based on MS Access 2.0 (further development)
Freelancer
- Initial VBA programming
- MS Access projects for Franz & Meyer (property developer) (apartment 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 in developing database-driven applications for Windows and web environments. During this time, I 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. I also gained considerable experience in creating business and IT concepts when setting up and planning the physical infrastructure. I have excellent analytical skills. After initially developing database-driven application programs, I have focused on DWH development 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 the Kimball and Data Vault designs and have applied them multiple times in projects. I am always looking for new challenges, for example in the area of data science or Power BI. I also gained my first 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 Tasks: 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: High Abstract Thinking Ability, Strong Technical Understanding, Quick Comprehension, Willingness To Learn New Topics, Problem-solving From The Customer's Perspective, Communication Skills Also 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
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a
Nearby freelancers
Professionals working in or nearby Rostock, Germany
