Andre Wroblewski
PRINCE2® Foundation Examination
Experience
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
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
IFA Group
- Remote administration and monitoring of MS SQL server instances
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
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)
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
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
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
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
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
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
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
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
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
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
Various
- Several trips to China for sourcing plastic and aluminum parts
- Stays in Shanghai, Qingdao, Beijing, Nantong, Guangzhou, Hangzhou, Foshan, Hong Kong
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
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
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
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
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
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
KölnTicket
- Various enhancements in the areas of call center and ticket billing
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
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
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
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
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
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
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
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
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
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
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
HEC
- Design and implementation of a time tracking system
- Integration with SAP system and Oracle database
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
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
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
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).
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).
Languages
Certifications & licenses
PRINCE2® Foundation Examination
APMG International
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Andre based?
What languages does Andre speak?
How many years of experience does Andre have?
What companies has Andre worked for in recent years?
Which industries is Andre most experienced in?
Which business areas is Andre most experienced in?
Which industries has Andre worked in recently?
Which business areas has Andre worked in recently?
Does Andre have any certificates?
What is the availability of Andre?
What is the rate of Andre?
How to hire Andre?
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
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a
Nearby freelancers
Professionals working in or nearby Dannenberg (Elbe), Germany