Recommended expert

Andre Wroblewski

PRINCE2® Foundation Examination

Andre Wroblewski
Dannenberg (Elbe), Germany

Experience

Nov 2024 - Present
1 year 5 months

TRIMET SE

  • Requirements management, business analysis, architecture, planning and implementation of migrating another existing classic DWH to a Data Vault 2.0 DWH
  • Designing the required DB model (MS SQL) and the ETL from core system databases (INGRES, MS-SQL) using SSIS
  • Integrating the migrated DWH into the existing MS SQL Data Warehouse (Data Vault 2.0)
  • Analysis, design and implementation of SSAS-based cubes for delivery to Power BI
Nov 2019 - Oct 2024
5 years

TRIMET SE

  • Requirements management, business analysis, architecture, planning and implementation of the further development of a started DWH to deliver company-wide KPIs for controlling
  • Designing the required DB model (MS SQL) and the ETL from core system databases (SAP, INGRES, MS-SQL, ORACLE) with SSIS into the MS SQL Data Warehouse (Data Vault 2.0 pattern)
  • Importing MS Excel data via ETL processes with SSIS
  • Board database design
  • Designing and implementing the authorization concept for the DWH
  • Merging the production DWH with the 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, planning and implementation of the further development of an existing DWH to deliver company-wide KPIs for controlling
  • Designing the additional DB model (MS SQL) and 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)
  • Importing MS Excel data via ETL processes with SSIS
  • Board database design
Feb 2017 - Aug 2018
1 year 7 months
Bad Honnef, Germany

Career Partner

  • Requirements management, planning and implementation of a billing system according to HGB, US GAAP and IFRS for revenues and deferred income
  • Subproject management and coordinating requirements with stakeholders
  • Designing the additional DB model (MS SQL) and the replication via ETL processes from the core system database (Simovative CARE MySQL) with SSIS into the MS SQL Data Warehouse (Data Vault pattern)
  • Importing MS Excel data via ETL processes with SSIS
  • Exporting and importing CSV data to and from Datev via ETL processes with SSIS
  • Designing and implementing the front end (MS Access), the business process logic (stored procedures) and the reports (MS Access/Excel, SSRS, Power BI)
  • Administration of multiple MS SQL server instances (development, testing, production)
Oct 2015 - Jan 2017
1 year 4 months
Hanover, Germany

HIS eG

  • Project lead for designing a project and process framework for campus management system implementation according to PRINCE2
  • Project lead for change and release management of the campus management system for various German universities
  • Requirements management and feasibility studies for campus management system implementation projects for various German universities
  • Advising 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 produce volume/margin (value drivers) for the capital markets business
  • Reporting BI analyses via Access and Excel
Jul 2015 - Sep 2015
3 months
Offenbach, Germany

Helaba

  • Developing an archiving concept for an enterprise data warehouse in the regulatory reporting environment, considering architectural and security aspects according to BSI basic protection
  • Implementing a multi-layer MS SQL data warehouse with a partitioning architecture and metadata repository
Feb 2015 - Jun 2015
5 months
Hanover, Germany

Nord/LB

  • Migrating the data supply to SAP BA 8 and reviewing and redocumenting the IT concept
  • Defect management
  • Migrating VB6 data warehouse 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 designing and implementing a quality bonus system based on KPI evaluations of productivity and quality
  • Reviewing SQL stored procedures and integrating them into the ERP BI system
May 2014 - Sep 2014
5 months
Düsseldorf, Germany

HSBC

  • Requirements management for designing various regular Cognos reports (KPIs) from the corporate DWH (securities settlement, trading, delivery, appointment and event management, SLAs)
  • Implementation support and testing
  • Analysis and coordination with business units and IT
  • Redesign 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 capture of new business requirements
Dec 2013 - Feb 2014
3 months
Frankfurt, Germany

DZ Bank

  • Requirements, change and release management in the securities settlement system for client banks
  • Business analysis, design and implementation of the ETL for the Sybase DWH
  • Implementation of data exports
  • Creation of the process model, IT documentation and the test concept
Mar 2013 - Apr 2013
2 months
Frankfurt, Germany

DZ Bank

  • Requirements, change and release management in the securities settlement system for client banks
  • Business analysis, design and implementation of the ETL for the Sybase DWH
  • Implementation of data exports
  • Creation of the process model, IT documentation and the test concept
Mar 2009 - Feb 2014
5 years
Hörstel, Germany

W + W Metalltechnik GmbH

  • Overall leadership in analyzing, restructuring and optimizing business processes for corporate restructuring
  • Business analysis, controlling, benchmarking and corporate 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
  • Implementation of DIN EN ISO 9001
  • Overall CIO responsibility and coordination of the IT landscape
Jan 2008 - Present
18 years 3 months

Various

  • Several trips to China for sourcing plastic and aluminum 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 change management
  • Designing and setting up the technical requirements for the new system implementation
Jul 2006 - Sep 2007
1 year 3 months
Frankfurt, Germany

DZ Bank

  • Designing the SOA and database architecture for retail certificates
  • Designing and implementing a web service for master data management
  • Feasibility study on using 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
  • Creating a generic architecture and deriving specific implementation options
  • Comparing a BPI solution with 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 technology information systems
  • Analysis of the existing IT infrastructure, business process management, and database architecture
  • Developing future scenarios for organizational and process structures, architectures, and technologies
Sep 2005 - Dec 2005
4 months
Frankfurt, Germany

DZ Bank

  • Review for a securities trading system for affiliated banks
  • Transaction control of synchronous and asynchronous processes, XML and message brokerage
  • Review, modeling, and further development of the SOA and BPM in the trading system
May 2005 - Nov 2005
7 months
Frankfurt, Germany

dit

  • Funds reporting: business analysis of the department's requirements and definition of 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 enhancements 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 reanonymization 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 affiliated banks
  • Development of the process model, the IT documentation, and the test concept
Apr 2004 - Oct 2004
7 months

futura consult

  • Custom adaptations to the AnySync program
  • Analysis and synchronization of table contents from different database systems
  • Data loading processes for data warehouse databases
  • Data reconciliation between mobile and 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 to document AS-IS applications
  • Implementation using MS Access 97/VBA and rollout via intranet
  • Migration testing and creation of a migration guide
  • Team coaching and troubleshooting in MS Office and SQL
  • Extension of data quality management with additional functionalities
Jan 2003 - May 2003
5 months
Düsseldorf, Germany

Vodafone D2 GmbH

  • Analysis of the existing IT infrastructure and database architecture
  • Investigation of database redundancy and replication mechanisms
  • Study on ROI, TCO, QoS, TTS, TTM, and 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 data quality analysis using MS Access 97/VBA
  • Reporting of quality metrics and conversion into various formats
  • Export and distribution of metrics according to group policies
  • Migration testing and creation of the migration guide
Jan 2001 - Jul 2002
1 year 7 months
Munich, Germany

HypoVereinsbank AG

  • Analysis of migration options from VB 6.0 to J2EE architecture
  • Preparation and integration work as part of a merger
  • Planning and partial implementation of a web-based application for managing account and custody authorizations
Jan 2000 - Dec 2000
1 year
Frankfurt, Germany

AIG Europe

  • Implementation of a customer reporting system and data warehouse on Sybase SQL Server
  • Development of a Visual Basic frontend for data management and reporting with Cognos
Jan 2000 - Dec 2000
1 year
Munich, Germany

HypoVereinsbank AG

  • Detailed design and implementation of an application in the integrated workstation (GEPARD/PASTA)
  • Reviewing and adapting existing applications for multi-client support
  • Code review, bug fixing, enhancements and team coaching
Jan 1999 - Dec 1999
1 year
Frankfurt, Germany

Commerzbank AG

  • Project management and consulting for a customer reporting system in capital management
  • Conversion of the reporting system to an ODBC interface to the PRIMARK ICON host flat file system
  • Quality assurance of 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
  • Integration with SAP system and Oracle database
Jan 1998 - Dec 1999
2 years
Frankfurt, Germany

DG-Bank

  • Expansion of the management system for Manual Recorded Deals as an OPICS interface
  • Import of host ASCII data into Sybase SQL Server using a 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 a management system for maintenance and repair of production equipment
  • Material procurement and management
  • Follow-up scheduling of maintenance tasks and centralized management
  • Client/server system on 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 a management system for insured objects with inspection tasks and status reports
  • Database on MS Access, front end in 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 management front end in Visual Basic

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Manufacturing (18 years), Banking and Finance (10 years), Metals and Mining (7.5 years), Information Technology (4.5 years), Insurance (2 years), and Education (1.5 years).

Manufacturing
Banking and Finance
Metals and Mining
Information Technology
Insurance
Education

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (27 years), Business Intelligence (19.5 years), Procurement (19 years), Quality Assurance (8.5 years), Project Management (6.5 years), and Accounting (1.5 years).

Information Technology
Business Intelligence
Procurement
Quality Assurance
Project Management
Accounting

Languages

German
Native
English
Intermediate

Certifications & licenses

PRINCE2® Foundation Examination

APMG International

Profile

Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Andre based?

Andre is based in Dannenberg (Elbe), Germany.

What languages does Andre speak?

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

How many years of experience does Andre have?

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.

What companies has Andre worked for in recent years?

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

Which industries is Andre most experienced in?

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

Which business areas is Andre most experienced in?

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

Which industries has Andre worked in recently?

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

Which business areas has Andre worked in recently?

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

Does Andre have any certificates?

Andre has 1 certificate: PRINCE2® Foundation Examination.

What is the availability of Andre?

Andre is immediately available for suitable projects.

What is the rate of Andre?

Andre's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Andre?

To hire Andre, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

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

1000
750
500
250
Market avg: 710-870 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.