Guido Klein-Power BI Report Developer
Check rate
Experience
NOBILIS Group GmbH
- Support during SSRS implementation, including training employees on SSRS
Mitsubishi Electric Europe B.V.
Analysis of 6 MS SQL databases
Creation of a migration concept as part of the SAP R/3 to S/HANA migration
DWH development and design
Development of staging, DWH and analysis datamart
Data extraction 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
- Adaptation and new development of Power BI reports including data import and preparation
Requirements Engineer / Business Analyst
Raiffeisen Software GmbH
Business analysis of DWH data for regulatory 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 the Deutsche Bundesbank (B&N model), covered bond reporting, foreign assets reporting
Building analysis datamarts
Bundesbank reporting, SSD reporting to OENB
Development of test 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 based on the Data Vault 2.0 methodology
Creation of analyses and preparation of company data in collaboration with the business units
Requirements analysis, data cleansing and modeling for analyses and reports
Creation and further development of existing reports
Designing solutions in the area of Business Intelligence / Data & Analytics
Building data marts
Report creation with 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 unit
Reports including in the area of 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 from DWH data in the field of regulatory 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 the German Bundesbank (B&N model)
Building analysis data marts
Bundesbank reporting, SSD reports to OeNB
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 on various data sources including SAP, MobileIron, Foreman, etc.
Consulting on architecture and deployment processes
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
Consulting on architecture and deployment processes
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 2008 R2/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
Designing 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 maintaining the database environment
Performance and availability of database systems (the 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 / Data Warehouse 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: ensuring performance and availability of the database systems (service)
Performance tuning: optimizing and continuously improving the databases
Designing and implementing business requirements
Data protection and security, user rights and role management, authorization concepts
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 custom 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.
Applications for business reporting, data mart, and data warehouse 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, development of application concepts
Software used: MS SQL Server, MS SQL Server Management Studio, MS SQL Server 2005/08/08R2 BI Development Studio, Visual Studio 2008/10, SSIS, SSRS, PL-Developer, Excel 2010, TortoiseSVN
Technologies used: T-SQL, PL-SQL, VB.Net, ASP.Net, Ajax, web services
Project team member for auditing financial service providers
KPMG
DWH application for analyzing and processing large datasets in leasing, loans, funds, and insurance
T-SQL programming, report creation, data analysis, advising 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 the LoanIQ, DMS, and 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, designing, and developing Access projects (on MS SQL Server 2005)
Introducing SQL Server at the departmental level
Developing 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 comparisons
Coordinating application rollouts with IT, training users
Programming application components on SQL Server (T-SQL)
Supporting the team by 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
Developing a KA management solution for matching contract data
Software used: Visual Studio 2005
Technologies used: ASP.NET 2.0, Oracle DB, Telerik controls
Lidl
Programming a data merge from Excel and Word sources into a contract package and automating the creation 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
Programming an intranet site for Daimler AG to submit projects for the Environmental Leadership Award
Admin 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
Migrating 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 Technology Infrastructure Support
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 the reporting and ticketing system 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
Managing various websites
Software used: MS Expression Studio
Technologies used: MySQL, PHP, JavaScript, XHTML, CSS
Freelancer
Creating 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 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
Software used: MS Expression Studio
Technologies used: JavaScript, XHTML, CSS
IT Consulting, setup of a server-based network system and telephony infrastructure
Centurino GmbH
Business consulting
Developed software for loan application processing
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
Challenge Marketing AG
Business consulting, support and maintenance
Data preparation for marketing
Created 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
IT Consulting, setup of a server-based network system and telephony infrastructure
Liquid First AG
Developed and implemented software for application processing, including modules for the call center
Created a website for application submission
Software used: 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 telephony infrastructure
Phönix Finanzsanierungs AG
Business consulting
Developed and implemented software for application processing, including modules for the call center
Automated software deployment
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
Managing Director, Head of Sales of the company
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 credit card application processing including software modules for call centers
Creation of a web presence for application intake
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VBScript, 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 call centers
Creation of a web presence
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VBScript, 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 application processing including software modules for call centers
Software used: MS Access, MS Excel, MS Word
Technologies used: VBA, VB, VBScript, 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 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 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 implementation 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 eBusiness project, technical consulting
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
Advice, design and proposal creation of technical solutions for existing and new customers
Environment: automation with VBScript, Windows, IIS, Mercury, Bind, Cisco, Bintec, INTERSHOP, Windows NT Server
Authorized signatory / managing director
Telemaxx GmbH
Operation and maintenance of call center system (Micrologica-Siemens) with 30 workstations
Technical negotiations with Siemens as a technology partner and sale of Micrologica
Environment: Windows NT 4.0, Novell NetWare, DLV 2000 fiber optic connection
Freelancer
DLV 2000
- Technical support for the IT system (Thin Ethernet - Ethernet)
- Servers: 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) (property management)
- ECOSYL (customer database) for 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 have gained extensive experience in various industries (mainly financial services, direct marketing, call centers, data centers) and with a wide range of technical requirements and business process analysis. I also gained solid experience in creating business and IT concepts when building and planning physical infrastructure. I have very good analytical skills. After initially developing database-driven application programs, 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 tools SSIS, SSAS, and SSRS. I am familiar with Kimball and Data Vault designs and have applied them in multiple projects. I am always looking for new challenges, e.g. in data science or Power BI. I have also gained initial experience with QlikView at systeon GmbH in Rostock.
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 Ability To Abstract, Strong Technical Understanding, Quick Comprehension, Willingness To Learn New Topics, Customer-Focused Problem Solving, Communication Skills With Non-Technical Departments
Languages
Education
University of Rostock
Physics · Rostock, Germany
Statistics
Experience
Global Experience
Expertise
Profile
Frequently asked questions
Have questions? Find more information here.
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
Marco Skulschus
Stefan Corsten
Ronny Herold
German Popken
Germo Görtz
Bernd Steckenbauer
Vitali Haberkorn
William Nguyen
Thomas Reick
Evrim İlden
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a
Stefan Wimmer
Vitali Haberkorn
Stefan Corsten
Germo Görtz
Thomas Reick
Peter Glöckner
Marco Skulschus
Guino Ndjenndja
German Popken
Jochen Rieseberg
Nearby freelancers
Professionals working in or nearby Rostock, Germany
Norman Richter
Tobias Stötzer
Michele Heine
Liisa Preugschat
Niko Schmuck
Angelika Ballosch
Aiman Ragab
Daniel Sedlack
Alexander Block
Hartmut Ullrich
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
