André W.
Chief Information Security Officer CISO
Experience
Nov 2024 - Present
10 months Lorem ipsum dolor sit amet
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
- Designing the required DB model (MS SQL) and ETL from core system databases (INGRES, MS-SQL) with 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, design, and implementation of the further development of an initial DWH to deliver company-wide KPIs for controlling
- Designing the required DB model (MS SQL) and 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 pipelines with SSIS
- Board database design
- Designing and implementing the authorization concept for the DWH
- Merging production DWH with finance/controlling DWH
Dec 2018 - Feb 2019
3 monthsHaldensleben, 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, design, 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 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 pipelines with SSIS
- Board database design
Feb 2017 - Aug 2018
1 year 7 monthsBad Honnef, Germany
Lorem ipsum dolor sit amet
Career Partner
- Requirements management, design, and implementation of a billing system according to HGB, US GAAP, and IFRS for revenue and deferred income
- Subproject leadership and alignment of requirements with stakeholders
- Designing the additional DB model (MS SQL) and replication via ETL pipelines from core system database (Simovative CARE MySQL) with SSIS into the MS SQL Data Warehouse (Data Vault Pattern)
- Importing MS Excel data via ETL pipelines with SSIS
- Exporting and importing CSV data to and from Datev via ETL pipelines with SSIS
- Designing and implementing the frontend (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, test, production)
Oct 2015 - Jan 2017
1 year 4 monthsHanover, Germany
Lorem ipsum dolor sit amet
HIS eG
- Project lead for designing a project and process framework for the Campus Management System rollout using PRINCE2
- Led change and release management for the Campus Management System at various German universities
- Handled requirements management and feasibility studies during implementation projects of the Campus Management System for various German universities
- Advised on fee and financial management for German universities and HIS eG
- Advised, designed, and implemented various SQL interfaces
Sep 2015 - Oct 2015
2 monthsFrankfurt, Germany
Lorem ipsum dolor sit amet
DZ Bank
- Created an Access database from SAP downloads and Excel inputs to produce volume/margin (value driver) reports for the capital markets business
- Reported BI analyses via Access and Excel
Jul 2015 - Sep 2015
3 monthsOffenbach, Germany
Lorem ipsum dolor sit amet
Helaba
- Developed an archiving concept for an Enterprise Data Warehouse in the regulatory reporting area, covering architectural and security aspects under BSI basic protection
- Implemented a multi-layered MS SQL DWH with partitioning architecture and a metadata repository
Feb 2015 - Jun 2015
5 monthsHanover, Germany
Lorem ipsum dolor sit amet
Nord/LB
- Migrated data feeds to SAP BA 8 and reviewed and updated the IT concept documentation
- Handled defect management
- Migrated VB6 DWH tools (watchdog system, KPI system) to VBA MS Access 2010
Oct 2014 - Dec 2014
3 monthsHörstel, Germany
Lorem ipsum dolor sit amet
W + W Metalltechnik GmbH
- Managed the project to design and implement a quality bonus system based on KPI analysis of productivity and quality
- Reviewed SQL stored procedures and integrated them into the ERP BI system
May 2014 - Sep 2014
5 monthsDüsseldorf, Germany
Lorem ipsum dolor sit amet
HSBC
- Requirements management for designing various regular Cognos reports (KPIs) from the corporate data warehouse (securities processing, trading, delivery, scheduling and event management, SLA)
- 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 monthMü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 portfolio
- Functional enhancements and capturing new business unit requirements
Dec 2013 - Feb 2014
3 monthsFrankfurt, Germany
Lorem ipsum dolor sit amet
DZ Bank
- Requirements, change and release management in the securities settlement system for partner banks
- Business analysis, design and implementation of ETL for Sybase data warehouse
- Implementation of data export
- Creation of process models, IT documentation and test concept
Mar 2013 - Apr 2013
2 monthsFrankfurt, Germany
Lorem ipsum dolor sit amet
DZ Bank
- Requirements, change and release management in the securities settlement system for partner banks
- Business analysis, design and implementation of ETL for Sybase data warehouse
- Implementation of data export
- Creation of process models, IT documentation and test concept
Mar 2009 - Feb 2014
5 yearsHörstel, Germany
Lorem ipsum dolor sit amet
W + W Metalltechnik GmbH
- Overall leadership of analysis, restructuring and optimization of business processes for corporate turnaround
- Business analysis, controlling, benchmarking and corporate management
- Reporting for banks
- Restructuring administration using Lean Administration
- Smooth migration of the existing ERP system to a new ERP system and preparation for implementing a production planning system (PPS)
- Implementation of DIN EN ISO 9001
- Overall CIO responsibility and coordination of the IT landscape
Jan 2008 - Present
17 years 8 months Lorem ipsum dolor sit amet
Various
- Multiple 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 monthsFrankfurt, 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 of the migration phase in the area of change management
- Designing and creating the technical requirements for the new system deployment
Jul 2006 - Sep 2007
1 year 3 monthsFrankfurt, Germany
Lorem ipsum dolor sit amet
DZ Bank
- Design of the SOA architecture and database architecture for retail certificates
- Design and implementation of a web service for master data management
- Feasibility study on using Business Objects Enterprise XI for reporting and forecasting
Mar 2006 - Jun 2006
4 monthsFrankfurt, 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
- Development of a generic architecture and derivation of specific implementation options
- Comparison of BPI solution and 4-tier web application with workflow components
Jan 2006 - Feb 2006
2 monthsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Vodafone D2 GmbH
- Preliminary study on the target vision of the technical information systems
- Analysis of the existing IT infrastructure, business process management and database architecture
- Development of future scenarios for organizational and process structures, architectures and technologies
Sep 2005 - Dec 2005
4 monthsFrankfurt, 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, modelling and further development of the SOA and BPM in the trading system
May 2005 - Nov 2005
7 monthsFrankfurt, Germany
Lorem ipsum dolor sit amet
dit
- Fund 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 monthsCologne, Germany
Lorem ipsum dolor sit amet
KölnTicket
- Various enhancements in call center and ticket billing
Jan 2005 - Jan 2005
1 monthFrankfurt, 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 monthsHörstel, Germany
Lorem ipsum dolor sit amet
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 monthsFrankfurt, Germany
Lorem ipsum dolor sit amet
DZ Bank
- Implementation of ETL and reporting for the securities settlement system of affiliated banks
- Creation of the process model, IT documentation, and test concept
Apr 2004 - Oct 2004
7 months Lorem ipsum dolor sit amet
futura consult
- Customizations to the AnySync program
- Analysis and synchronization of table contents across different database systems
- Loading processes for data warehouse databases
- Reconciliation of mobile data sets with stationary ones
Jun 2003 - Mar 2004
10 monthsDüsseldorf, Germany
Lorem ipsum dolor sit amet
Vodafone D2 GmbH
- Project lead for as-is documentation: high-level design and prototype of a database application for documenting existing applications
- Implementation using MS Access 97/VBA and rollout over the intranet
- Migration testing and creation of a migration guide
- Team coaching and trouble-shooting in MS Office and SQL
- Extension of data quality management with additional functionalities
Jan 2003 - May 2003
5 monthsDü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 as well as maintenance and upkeep of alternative data models
Nov 2002 - Dec 2002
2 monthsDü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 monthsMunich, 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
- Design and partial implementation of a web-based application for managing account and custody authorizations
Jan 2000 - Dec 2000
1 yearFrankfurt, 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 yearMunich, 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 yearFrankfurt, 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 for the PRIMARK ICON host flat-file system
- Quality assurance for the Y2K conversion and Euro extension
- Administration and coaching for NT Server 4.0 and SQL Server 6.5
Jan 1999 - Dec 1999
1 yearBremen, 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 yearsFrankfurt, Germany
Lorem ipsum dolor sit amet
DG-Bank
- Extension of the management system for manual recorded deals as an OPICS interface
- Data transfer of 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 yearRheine, 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
- Maintenance reminders and centralized management
- Client/server system on MS SQL Server and Visual Basic with Crystal Reports
Jan 1997 - Dec 1997
1 yearMü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, frontend in Visual Basic with Crystal Reports
Jan 1996 - Dec 1996
1 yearEssen, 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 administration frontend in Visual Basic
Languages
German
NativeEnglish
IntermediateEducation
Lorem ipsum dolor sit amet
Computer Science
Lorem ipsum dolor sit amet
Business Administration
High School Diploma
...and 1 more
Certifications & licenses
Certified CISO/IT-SIBE (ISO 27001/BSI-Grundschutz)
Certified Data Vault 2.0 Practitioner
Certified PRINCE2 Project Manager
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.