Christian Dröge
Requirements Engineer
Experience
Requirements Engineer
Evangelisches Jugend- und Fürsorgewerk (EJF)
- Document analysis
- Preparation and visualization of results (Excel, PowerPoint)
- Consulting and recommendation for requirements analysis and management
- Presentation and handover
Lead Business Functional Analyst
Deutsche Bank (DWS Investment GmbH)
- Coordination of internal and external teams (IT, business and vendors)
- Change management and incident tracking with ServiceNow
- Task management using JIRA
- Technical concept validation and functional testing in migration contexts
- Database management with MS Access, Oracle and SQL Server
- Control of automated data flows (job scheduling with Control-M, scripts via PowerShell, connections via SFTP)
- Project documentation and knowledge management with Confluence
- Support of disaster recovery planning and execution of DR tests
- Consulting on IT application ownership (ITAO)
- Management and ordering of rights, servers and capacities (CPU, storage)
- Setup and maintenance of the CI/CD pipeline with IBM UrbanCode Deploy
- Management and documentation of ORR controls (application, release, decommission)
- Test coordination, execution and documentation
Agile IT Business Analyst
VTG GmbH
- Analysis and design of data management and business processes
- Documentation of systems, interfaces and processes
- Acting as interface between initiatives and Scrum implementation teams regarding requirements
- Gathering requirements for various initiatives together with stakeholders (storytelling)
- Documenting requirements in user stories according to the INVEST approach
- Preparing user stories for Scrum teams
- Considering and further developing the existing UX/UI concept
- Presenting user stories in refinements and preliminary acceptance after delivery by Scrum teams
- Coordination with IT portfolio project management and business/IT architecture
Requirements Manager
ITZBund
- Creating requirements and functional specifications, communication manuals and technical documentation
- Production support and handling ASPE tickets
- Analysis and concepts (e.g. deletion concept, data models, reporting improvements)
- Creating mockups/wireframes
- Consulting of the business department (BZSt)
- Support of development and QA processes
- Communication with interface partners
- Preparing presentations and talks at workshops and kick-offs
IT Business Consultant, IT project manager
AEW Invest GmbH (NATIXIS)
- Requirements analysis, consulting and design (IT concept, cloud technologies, portfolio management system, ERP, data warehouse, web front-end, dashboards and reporting)
- Creating and maintaining functional specifications and IT concepts
- Application development with VBA (Excel, Access, SQL Server)
- Project management and coordination with internal and external stakeholders
- Automation of processes and interfaces (XML, CSV)
- Support in system selection and integration of the Otris DMS
- Documentation and user training
- Data analysis and modeling
Requirements Manager
ITZBund
- Creation of requirement specifications, communication manuals, and technical documentation
- Production support and handling of ASPE tickets
- Conducting analyses and creating concepts
- Advising the business unit (BZSt)
- Supporting development and QA processes
- Communicating with interface partners
- Preparing presentations and workshops in Bonn and Berlin
- Data analysis and modeling for ad hoc and standard reporting
- Designing and customizing data models and interfaces
- Maintaining and extending data validation rules for the XML ETL process
Requirements Manager, Project Manager, IT Business Analyst
DWS Holding & Services GmbH
- Implementing BlackRock Aladdin as the central investment management platform and replacing MSCI RiskMetrics
- Adjusting interfaces and applications as well as reporting (AM Risk Navigator)
- Requirements engineering for the AM Risk frontend (WPF)
- Configuring and testing a .NET frontend with abstraction and approval layers
- Establishing risk monitoring and reporting (VaR, stress tests, backtesting, leverage, liquidity risk)
- Leverage calculation platform and derivatives reporting
- Improving efficiency of AIFMD and client reporting
- Data warehouse interfaces and SQL Server migration
- Data center migration, Job/Control-M migration
- Integrating QlikView as a BI tool
- Developing new data models (Data Vault)
- IT strategy consulting and various analysis tools and reporting
IT Business Analyst, Developer
Corpnext GmbH
- Preparing data from StaffIt
- Migrating data to Salesforce
- Testing and acceptance
Requirements Manager, Project Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH
- Analyzing and enhancing a complex MS Access solution in risk and control management
- Building an alternative solution (AM Risk Navigator, Risk Data Warehouse) using SQL Server, C#.NET, MS Access, and XML
- Processing several thousand XML files daily, including XML/PDF archiving, monitoring, limit system, master data management, and reporting
- Developing a UCITS IV/KID reporting system, liquidity risk system, and backtesting monitoring & reporting tool
- Testing, analyzing, and evaluating BI systems
- Specifying requirements and regulatory monitoring and reporting solutions
- Developing an early warning system and counterparty risk reporting
- Migrating from VBA/XML loader to C#.NET RiskMetrics XML loader
IT Analyst (Working Student)
AmpegaGerling Investment GmbH
- Integrating a reporting solution for fund factsheets and monthly reporting
- Investment committee reporting
IT Analyst (diploma student)
Quartal Financial Solutions AG
- Performed a study on automating the processing of ongoing commissions in the fund business using SWIFT ISO 20022/UNIFI
IT Analyst, Developer (working student)
Quartal Financial Solutions AG
- Built a complex CRM solution based on MS Access
- Created an application to dynamically map multi-layered sales processes in an international group structure
IT Analyst, Developer (working student)
BWG & Co.KG mbH (voestalpine)
- Supported integration of a Java-based software solution for digital audit result recording
- Improved performance of cross-plant databases
- Optimized and expanded a complex MS Access system environment
Summary
Since 2007, I have been working as a freelance IT business consultant, supporting demanding IT projects in the finance/asset management sector, public sector, and transport and logistics. My focus is on IT business analysis, requirements engineering, and traditional, agile, and hybrid IT project management (Waterfall, Scrum, Kanban, V-Model XT).
I place a special focus on data management: I have extensive experience with relational databases, data warehouse architectures, business intelligence solutions, and interfaces (e.g. ETL, XML, SFTP, APIs). In numerous projects, I have successfully carried out migration initiatives, integration of custom and standard software, and the setup of complex system and data landscapes. Additionally, I bring solid knowledge of IT architectures, business cases, proof-of-concepts, and make-or-buy decisions.
Skills
It Consulting And Management
Business Analysis And Requirements Engineering
It Project Management And It Strategy Consulting
Databases, Data Warehouse (Dwh) And Business Intelligence (Bi)
Application, Database And Interface Development
Requirements Analysis And Management With Confluence, Jira Or Doors
Prototyping
System Integration And Data Migration
Technical Documentation
Proof Of Concept (Feasibility Studies, Make Or Buy)
Requirements Specification And Functional Specification
Process Management And Modeling (Bpmn, Uml, Eepk)
It Change Management (Itil, Itsm, Servicenow)
Analysis, Planning, Design, Development And Testing Of It Solutions With Microsoft Access, Microsoft Sql Server, Vba, Xml, T-sql, Ssis, Ssrs
Operating Systems: Windows 10/11 (Advanced), Linux Suse, Unix (Basic)
Databases: Microsoft Access 2003-2021, Microsoft Sql Server 2000-2022 (Expert), Postgresql, Oracle, Db2, Sybase, Mariadb (Advanced)
Programming Languages: Vba, T-sql, Vbscript (Expert), C#.net, C++, Java, Visual Basic .Net, Javascript, Python, Powershell (Basic)
Methodologies: Waterfall, V-model Xt, Agile (Scrum, Kanban)
Office: Microsoft Word, Powerpoint, Excel, Access, Outlook
Enterprise Architecture Management: Leanix, Archimate
Knowledge Management: Confluence, Sharepoint
Project Management: Jira, Trello, Microsoft Project, Microsoft Planner
Erp: Sap R/3, Sap S/4 Hana, Jaggaer, Microsoft Dynamics 365 Business Central
Requirements Management: Jira, Ibm Rational Doors
Service Management: Servicenow, Ibm Rational Change (Aspe), Hp Alm
Mockup/wireframe: Balsamiq, Figma
Collaboration: Teams, Miro, Zoom
Modeling: Microsoft Visio, Umlet, Draw.io, Lucidcharts
Database Management: Sql Developer, Quest Sql Navigator, Squirrel, Quest Toad, Sql Server Management Studio
Crm: Salesforce, Microsoft Dynamics Crm, Close.io
Automation (Etl/devops): Informatica, Control-m, Ibm Urbancode Deploy, Ssis
Ide: Microsoft Visual Studio, Visual Studio Code, Eclipse
Bi Tools: Qlikview/qliksense, Power Bi, Microstrategy, Tableau
Xml/json: Altova Mapforce, Xmlspy, Soupui, Postman
Version Control: Github, Bitbucket, Artifactory
Ai: Chatgpt, Deepl, Microsoft Copilot
Asset Management: Simcorp Dimension, Blackrock Aladdin
Cloud: Azure, Gcp, Aws
Languages
Education
IU – Internationale Hochschule
Master of Arts program · Project Management · Bad Honnef, Germany
Universität Bamberg (VAWI)
Master of Science program · Business Informatics · Bamberg, Germany
Hochschule Bremerhaven
Diploma in Business Informatics (FH) · Computer Science/Business Informatics · Bremerhaven, Germany · 2.1
Certifications & licenses
Digital Guide (i8 certified)
Mission Top 5
Data Warehouse Developer - Bronze (CeLS)
IREB Certified Professional For Requirements Engineering (CPRE-FL)
Business Intelligence Consultant - Gold (CeLS)
IT Project Team Member - Bronze (CeLS)
IT Project Lead / Manager - Gold (CeLS)
IT-Recruiter - Bronze (CeLS)
SQL Database Developer - Bronze (CeLS)
Business Analyst (ibo certificate)
MCTS SQL Server 2005
Microsoft
Similar Freelancers
Discover other experts with similar qualifications and experience