Andre Wroblewski - Data Warehouse Architect, PRINCE2

🚀 FRATCH GPT 2.0 - Find freelancers with a single prompt. Now including price benchmarking.

Recommended expert

Dannenberg (Elbe), Germany

Check rate

Experience

Nov 2024 - Present

1 year 11 months

TRIMET SE

Requirements management, business analysis, architecture, design, and implementation of the migration of another existing classic DWH to a Data Vault 2.0 DWH
Design of the required DB model (MS SQL) as well as the ETL from core system databases (INGRES, MS-SQL) with SSIS
Integration of the migrated DWH into the existing MS SQL Data Warehouse (Data Vault 2.0)
Analysis, design, and implementation of cubes based on SSAS for delivery to Power BI

Nov 2019 - Oct 2024

5 years

TRIMET SE

Requirements management, business analysis, architecture, design, and implementation of the further development of an existing DWH to deliver company-wide KPIs for controlling
Design of the required DB model (MS SQL) as well as the ETL from core system databases (SAP, INGRES, MS-SQL, ORACLE) with SSIS into the MS SQL Data Warehouse (Data Vault 2.0 pattern)
Import of MS Excel data via ETL processes using SSIS
Board database design
Design and implementation of the authorization concept for the DWH
Merge of production DWH with finance/controlling DWH

Dec 2018 - Feb 2019

3 months

Haldensleben, Germany

Remote

IFA Group

Remote administration and monitoring of MS SQL Server instances

Oct 2018 - Sep 2019

1 year

TRIMET Aluminium SE

Requirements management, business analysis, design, and implementation of the further development of an existing DWH to deliver company-wide KPIs for controlling
Design of the additional DB model (MS SQL) as well as the ETL from core system databases (SAP, INGRES, MS-SQL) with SSIS into the MS SQL Data Warehouse (Snowflake and Data Vault 2.0 pattern)
Import of MS Excel data via ETL processes using SSIS
Board database design

Feb 2017 - Aug 2018

1 year 7 months

Bad Honnef, Germany

Career Partner

Requirements management, design, and implementation of an invoicing system according to HGB, US-GAAP, and IFRS for revenues and deferred income
Partial project management as well as coordination of requirements with stakeholders
Design of the additional DB model (MS SQL) as well as replication via ETL processes from the core system database (Simovative CARE MySQL) with SSIS into the MS SQL Data Warehouse (Data Vault pattern)
Import of MS Excel data via ETL processes using SSIS
Export and import of CSV data to and from Datev via ETL processes using SSIS
Design and implementation of the frontend (MS Access), the business process logic (stored procedures), as well as the reports (MS Access/Excel, SSRS, Power BI)
Administration of multiple MS SQL Server instances (development, test, production)

Oct 2015 - Jan 2017

1 year 4 months

Hanover, Germany

HIS eG

Project management for the design of a project and process framework for the implementation project management of the Campus Management System according to PRINCE2
Project management of change and release management for the Campus Management System for various German universities
Requirements management and feasibility studies as part of the implementation projects of the Campus Management System for various German universities
Consulting on fee and financial management for German universities and HIS eG
Consulting, design, and implementation of various SQL interfaces

Sep 2015 - Oct 2015

2 months

Frankfurt, Germany

DZ Bank

Creation of an Access database from SAP downloads and Excel inputs to generate volumes/margins (value drivers) for capital market business
Reporting of BI analyses via Access and Excel

Jul 2015 - Sep 2015

3 months

Offenbach, Germany

Helaba

Creation of an archiving concept for the Enterprise Data Warehouse in the reporting environment, taking architectural and security aspects into account according to BSI baseline protection
Implementation of a multilayer MS SQL DWH with partitioning architecture and metadata repository

Feb 2015 - Jun 2015

5 months

Hanover, Germany

Nord/LB

Migration of data delivery to SAP BA 8 and review and follow-up documentation of the DV concept
Defect management
Migration of VB 6 DWH tools (watchdog system, KPI system) to VBA MS Access 2010

Oct 2014 - Dec 2014

3 months

Hörstel, Germany

W + W Metalltechnik GmbH

Project management for the design and implementation of a quality bonus system based on KPI analysis of productivity and quality
Review of SQL stored procedures and integration into the ERP BI system

May 2014 - Sep 2014

5 months

Düsseldorf, Germany

HSBC

Requirements management for the design of various recurring Cognos reports (KPI) from the company DWH (securities processing, trading, delivery, scheduling and event management, SLA)
Support with implementation and testing
Analysis and coordination with business units and IT
New design of the technical approach to meet future requirements

Mar 2014 - Mar 2014

1 month

Münster, Germany

Westfälische Provinzial Versicherung AG

Migration of a management system for insured objects from MS Office 2003 to 2010
Data quality management for the entire object inventory
Functional enhancements and taking on new requirements from the business unit

Dec 2013 - Feb 2014

3 months

Frankfurt, Germany

DZ Bank

Requirements, change and release management in the securities settlement system for connected banks
Business analysis, design and implementation of ETL for Sybase DWH
Implementation of data export
Creation of the process model, technical documentation and test concept

Mar 2013 - Apr 2013

2 months

Frankfurt, Germany

DZ Bank

Requirements, change and release management in the securities settlement system for connected banks
Business analysis, design and implementation of ETL for Sybase DWH
Implementation of data export
Creation of the process model, technical documentation and test concept

Mar 2009 - Feb 2014

5 years

Hörstel, Germany

W + W Metalltechnik GmbH

Overall management of the analysis, restructuring and optimization of business processes for company recovery
Business analysis, controlling, benchmarking and company management
Reporting for banks
Restructuring of administration under Lean Administration
Smooth migration of the existing ERP system to a new ERP system and preparation for the introduction of a PPS
Introduction of DIN EN ISO 9001
Overall CIO responsibility and coordination of the IT landscape

Jan 2008 - Present

18 years 9 months

Various

Several trips to China for procurement of plastic and aluminum manufacturing parts
Stays in Shanghai, Qingdao, Beijing, Nantong, Guangzhou, Hangzhou, Foshan, Hong Kong

Oct 2007 - Feb 2009

1 year 5 months

Frankfurt, Germany

DZ Bank

Subproject "Interfaces/Technology" in the project "Migration of securities processing from WVS to the new WP2 platform"
Business and process analysis of the systems affected by the migration (DZ Bank, WGZ Bank, Fiducia, GAD, dwpbank)
Support during the migration phase in the area of change management
Planning and creation of the technical requirements for the new system rollout

Jul 2006 - Sep 2007

1 year 3 months

Frankfurt, Germany

DZ Bank

Planning of the SOA architecture and database architecture for retail certificates
Planning and implementation of a web service for master data management
Feasibility study on the use of Business Objects Enterprise XI for reporting and forecasting

Mar 2006 - Jun 2006

4 months

Frankfurt, Germany

DZ Bank

Requirements management, process analysis, preliminary study, and high-level design of the system architecture for retail certificates
Creation of a generic architecture and derivation of specific design alternatives
Comparison of a BPI solution and a 4-tier web application with workflow components

Jan 2006 - Feb 2006

2 months

Düsseldorf, Germany

Vodafone D2 GmbH

Preliminary study on the future vision of information systems technology
Analysis of the existing IT infrastructure, business process management, and DB architecture
Development of future scenarios for organizational and process structures, architectures, and technologies

Sep 2005 - Dec 2005

4 months

Frankfurt, Germany

DZ Bank

Review of a securities trading system for affiliated banks
Transaction control of synchronous and asynchronous processes, XML and message brokerage
Review, modelling, and further development of the SOA and BPM in the trading system

May 2005 - Nov 2005

7 months

Frankfurt, Germany

dit

Fund reporting: business analysis of the requirements from the specialist department and definition of the report structures
Analysis of the database model, design and implementation of new reports
Review and redesign of existing reports

Mar 2005 - Apr 2005

2 months

Cologne, Germany

KölnTicket

Various further developments in the areas of call center and ticket billing

Jan 2005 - Jan 2005

1 month

Frankfurt, Germany

DZ Bank

Proof of concept for a securities trading system for affiliated banks
Transaction control of synchronous and asynchronous processes, XML and message brokerage
Considerations of SOA and BPM

Aug 2004 - Dec 2004

5 months

Hörstel, Germany

Unternehmensberatung UP-Hermes

Design and implementation of a web portal for authentication and re-anonymization using ASP.NET, ADO.NET, and MS SQL Server
Integration of a web service for authorized and standardized access

Jul 2004 - Dec 2004

6 months

Frankfurt, Germany

DZ Bank

Implementation of ETL and reporting for the securities settlement system of the partner banks
Creation of the process model, the technical documentation, and the test concept

Apr 2004 - Oct 2004

7 months

futura consult

Custom adjustments to the AnySync program
Analysis and synchronization of table contents across different database systems
Load processes for data warehouse databases
Data reconciliation of mobile data sets with stationary data sets

Jun 2003 - Mar 2004

10 months

Düsseldorf, Germany

Vodafone D2 GmbH

Project management for as-is documentation: high-level concept and prototype of a database application for documenting the existing applications
Implementation in MS Access 97/VBA and rollout via intranet
Migration test and creation of a migration guide
Team coaching and troubleshooting in MS Office and SQL
Expansion of Data Quality Management with additional functions

Jan 2003 - May 2003

5 months

Düsseldorf, Germany

Vodafone D2 GmbH

Analysis of the existing IT infrastructure and database architecture
Review of database redundancy and replication mechanisms
Study on ROI, TCO, QOS, TTS, TTM, as well as maintenance and upkeep of alternative data models

Nov 2002 - Dec 2002

2 months

Düsseldorf, Germany

Vodafone D2 GmbH

Detailed design and implementation of an automated tool for analyzing data quality in MS Access 97/VBA
Reporting of quality metrics and conversion into different formats
Export and distribution of metrics according to group policies
Migration test and creation of a migration guide

Jan 2001 - Jul 2002

1 year 7 months

Munich, Germany

HypoVereinsbank AG

Analysis of the migration options from VB 6.0 to a J2EE architecture
Preparation and integration work as part of a merger
Planning and partial implementation of a web-based application for managing account and portfolio powers of attorney

Jan 2000 - Dec 2000

1 year

Frankfurt, Germany

AIG Europe

Implementation of a customer reporting system and data warehouse under Sybase SQL Server
Development of a Visual Basic front end for data control and reporting with Cognos

Jan 2000 - Dec 2000

1 year

Munich, Germany

HypoVereinsbank AG

Detailed design and implementation of an application in the integrated workplace (GEPARD/PASTA)
Checking and adapting existing applications for multi-client capability
Code review, bug fixing, extensions, and team coaching

Jan 1999 - Dec 1999

1 year

Frankfurt, Germany

Commerzbank AG

Project management and consulting for a customer reporting system in the area of capital management
Conversion of the reporting system to an ODBC interface to the PRIMARK ICON host flat file system
Quality assurance for the Year 2000 conversion and EURO expansion
Administration and coaching of NT Server 4.0 and SQL Server 6.5

Jan 1999 - Dec 1999

1 year

Bremen, Germany

HEC

Design and implementation of a time tracking system
Connection to an SAP system and Oracle database

Jan 1998 - Dec 1999

2 years

Frankfurt, Germany

DG-Bank

Expansion of the administration system for manual recorded deals as an OPICS interface
Data transfer from host ASCII data into Sybase SQL Server via Visual Basic front end and stored procedures
Definition and management of quality parameters and data validation
Dynamic mask control and batch processing

Jan 1998 - Dec 1998

1 year

Rheine, Germany

apetito AG

Planning and implementation of an administration system for maintenance and repair of production equipment
Material procurement and management
Follow-up of maintenance tasks and centralized management
Client/server system with MS SQL Server and Visual Basic with Crystal Reports

Jan 1997 - Dec 1997

1 year

Münster, Germany

Westfälische Provinzial Feuersozietät Versicherung der Sparkassen

Planning and implementation of an administration system for insured objects with inspection tasks and status reports
Database under MS Access, front end under Visual Basic with Crystal Reports

Jan 1996 - Dec 1996

1 year

Essen, Germany

Ruhrgas AG

Implementation of access and authorization mechanisms within a new security concept for Oracle databases
Integration of new roles and rules for groups and users
Implementation of the front end for administration under Visual Basic

Industry experience

See where this freelancer has spent most of their professional time.

Experienced in Manufacturing, Banking and Finance, Metals and Mining, Information Technology, Insurance, and Education.

Manufacturing

Banking and Finance

Metals and Mining

Information Technology

Insurance

Education

Business area experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Procurement, Quality Assurance, Project Management, and Accounting.

Information Technology

Business Intelligence

Procurement

Quality Assurance

Project Management

Accounting

Languages

German

Native

English

Intermediate

Certifications & licenses

APMG International

Statistics

Experience

Total positions 39

Experience in Manufacturing 18.5 y

Avg length 1 y 4 m

Longest experience 18 y 8 m

Global experience

Countries worked in 1 (Germany)

Primary country Germany

Expertise

Main industries Manufacturing, Banking and Finance, Metals and Mining

Main business areas Information Technology, Business Intelligence, Procurement

Qualifications

Certifications earned 1

Profile

Member since

August 2025

Last update

August 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Andre is based in Dannenberg (Elbe), Germany.

Andre speaks the following languages: German (Native), English (Intermediate).

Andre has at least 30 years of experience. During this time, Andre has worked and for 25 different companies. The average length of individual experience is 1 year and 9 months. Note that Andre may not have shared all experience and actually has more experience.

In recent years, Andre has worked for TRIMET SE and Various.

Andre is most experienced in industries like Manufacturing, Banking and Finance, and Metals and Mining. Andre also has some experience in Information Technology, Insurance, and Telecommunication.

Andre is most experienced in business areas like Information Technology, Business Intelligence, and Procurement. Andre also has some experience in Quality Assurance, Project Management, and Accounting.

Andre has recently worked in industries like Manufacturing and Metals and Mining.

Andre has recently worked in business areas like Procurement, Business Intelligence, and Information Technology.

Andre has 1 certificate: PRINCE2® Foundation Examination.

The availability of Andre needs to be confirmed.

Daily rate distribution

0 1 2 3 4

<€640 €720-800 €880-960 €960+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000

750

500

250

Daily rate avg. 806 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1000

750

500

250

Median rate 820 €

The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.

Calculated based on our freelancers’ daily rates as of 6 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.