Recommended expert

Andre Wroblewski

PRINCE2® Foundation Examination

Andre Wroblewski
Dannenberg (Elbe), Germany

Experience

Nov 2024 - Present
1 year 3 months
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

IFA Group

  • Remote administration and monitoring of MS SQL server instances
Oct 2018 - Sep 2019
1 year
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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 1 month
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

KölnTicket

  • Various enhancements in the areas of call center and ticket billing
Jan 2005 - Jan 2005
1 month
Frankfurt, Germany
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

HEC

  • Design and implementation of a time tracking system
  • Integration with SAP system and Oracle database
Jan 1998 - Dec 1999
2 years
Frankfurt, Germany
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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
Lorem ipsum dolor sit amet

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

Languages

German
Native
English
Intermediate

Certifications & licenses

PRINCE2® Foundation Examination

APMG International

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

Similar Freelancers

Discover other experts with similar qualifications and experience

Arne Zühlke
Arne Zühlke

Managing Director and Shareholder

View Profile
Philipp Loll
Philipp Loll

Project Management Office (PMO) Sales and Product Management

View Profile
Alexander Döring
Alexander Döring

Interim Manager Procurement | Head of Procurement & Strategic Sourcing

View Profile
Jens Hütwohl
Jens Hütwohl

External Consultant

View Profile
Marc Wiedenmann
Marc Wiedenmann

Supplier Management, Supply Chain Risk & Resilience

View Profile
Germo Görtz
Germo Görtz

BI Developer

View Profile
Robert Regge
Robert Regge

Management Consultant

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Matthias Weber
Matthias Weber

Interim SAP Master Data and Procurement Manager

View Profile
Michael Holle
Michael Holle

Vendor Management Lead

View Profile
Olaf Spinnehörn
Olaf Spinnehörn

Head of Material Management

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Guido Klein
Guido Klein

Power BI Report Developer

View Profile
Tim Safarowsky
Tim Safarowsky

Freelance Business Intelligence Consultant

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Dirk Nold
Dirk Nold

Interim Vice President Procurement

View Profile
Henok Abraham
Henok Abraham

Founder and Managing Director

View Profile
Fabian Knarr
Fabian Knarr

General Manager Global Procurement & Operations Planning

View Profile
Manfred Haas
Manfred Haas

Interim Manager Strategic Purchasing

View Profile
Stefan Leirich
Stefan Leirich

Director Procurement Europe

View Profile
Jörn Baumann
Jörn Baumann

Expert in Process Optimization

View Profile
Ralf Borchardt
Ralf Borchardt

Business Owner of the Central Funding Platform

View Profile
Burkhard Brühmann
Burkhard Brühmann

Interim Project Manager for Company-wide ERP Migration

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Jens Adelsbach
Jens Adelsbach

Head of Purchasing, Materials Management and SCM

View Profile
Rui Moskopp
Rui Moskopp

Interim Project Manager Professional Services Excellence & Digitalization

View Profile
Stefan Weiß
Stefan Weiß

Head of SCM Organization and Local S4H Implementation

View Profile
Henrik Bader
Henrik Bader

External Consultant - Global Procurement

View Profile
Daniel Karge
Daniel Karge

Technical Project Manager & Interim Manager

View Profile
Birgit Drünkler
Birgit Drünkler

Interim Manager / Consultant

View Profile