Christian Dröge
Lead Business Functional Analyst
Experience
Lead Business Functional Analyst
Bank/Asset Manager
Business analysis and project management for IT projects
- Project management and business analysis in migration projects
- Test coordination, execution, and documentation
- IT change management with ServiceNow
- Task management for migration projects with JIRA
- Concept validation and technical testing for migration projects
- Database management (MS Access, Oracle, SQL Server)
- Job management (Control-M, PowerShell, SFTP interfaces) to define automated data flows for migrated applications/systems
- Documentation with Confluence
- Support for disaster recovery setup and tests
- IT asset ownership advisory
- IT environment: SAP R/3, SAP HANA, GCP Cloud, ServiceNow, IBM UrbanCode Deploy, JIRA, Confluence, HP ALM, Control-M, SQL Server, Oracle, MS Access, Git, Bitbucket
Instructor for IT Business Analysis and IT Project Management
GenoAkademie
Webinars and seminars
Agile IT Business Analyst (Project and Requirements Management)
VTG GmbH
End-to-end business analysis for IT roadmap projects. Coaching and advising on:
- Analysis and design of data management and business processes
- Documentation of systems, interfaces, and processes
- Liaison between initiatives and Scrum implementation teams regarding requirements
- Gathering requirements for various initiatives with stakeholders (storytelling)
- Documenting requirements as user stories following the INVEST principle
- Preparing user stories for Scrum teams
- Considering and evolving the existing UX/UI concept
- Presenting user stories in refinement sessions
- Preliminary approval of user stories after delivery by Scrum teams
- Coordination with IT portfolio project management and business/IT architecture
Selected IT projects (initiatives):
Project 1: Yield management integration with Microsoft Dynamics CRM, microservice, Power Automate, RabbitMQ, ERP: Lead IT business analyst for three development teams (internal scrums + external team) and business unit (analysis, design, advice, documentation on requirements, data, interfaces, etc.)
Project 2: Integration of the supplier management system JAGGAER and ERP carve-out (monolith to microservice architecture and Angular front end): Lead IT business analyst/project manager for development team, JAGGAER support team, and business units
Project 3: Support for LeanIX integration (enterprise architecture management)
Project 4: Documentation of IT systems (including Microsoft Dynamics CRM)
Project 5: Support for digitalizing mobile services & backlog management
Project 6: Establishing business analysis processes and tasks
Project 7: Implementation of various user stories (ERP adjustments)
Project 8: Analysis of managing GeoFences (GeoJSON)
IT environment: Confluence, JIRA, MIRO, FIGMA, LeanIX, JAGGAER, Microsoft Teams, Planner, Office, Visual Studio, Postman, Zephyr, GitLab, Bitbucket, SQL Server, UML, BPMN, Scrum, Kanban, microservices, SAP S/4HANA, data formats (JSON, Protobuf, CSV), RabbitMQ, Angular front ends, AWS, Azure, Microsoft Dynamics 365 CRM, Microsoft Access, etc.
Requirements Manager (Business Design, Concept)
ITZBund
FATCA process
- Create requirements specs, functional specs, communication manuals, and technical documentation
- Production support and ASPE ticket handling
- Create analyses and concepts (e.g., deletion concept, reporting improvements, etc.)
- Create mockups/wireframes
- Advise the business unit (BZSt)
- Support development and QA processes (advise on requirements management, architecture, development, testing, and project management)
- Communicate with interface partners
- Prepare presentations and give talks at workshops, kick-offs, and other events
- IT environment: Oracle, SQL, UML, BPMN, XMLSpy, Visio, SharePoint, DOORS, Balsamiq, UMLet, Java, V-Model XT ITZBund, Microsoft Office, SQL Navigator
IT Business Consultant
AEW Ciloger SAS, AEW Invest GmbH (Natixis)
Design, develop, and integrate business IT systems (PMS, DWH, DMS, BI)
- Requirements analysis, consulting, and design (IT concept, cloud technologies, portfolio management system, ERP, data warehouse, web front end, dashboards, and reporting)
- Create and maintain functional specs and IT concepts
- Application development with VBA (Excel, Access, SQL Server)
- Project management
- Automate processes and interfaces (XML, CSV)
- Support system selection (virtual data rooms, document management systems, data centers/clouds)
- Support system integration of Otris DMS
- Documentation and user training
- Data analysis and modeling
- IT environment: Excel, Access, VBA (ADO, SQL), XML, Easy/Otris DMS, Visio (UML, BPMN), cloud, SQL Server, C#.NET, web technologies
Requirements Manager
ITZBund
ID number process (VIFA, FA-Batch/SpaZI, GDPR deletion concept)
- Create functional specs, communication manuals, and technical documentation
- Production support and ASPE ticket handling
- Create analyses and concepts
- Advise the business unit (BZSt)
- Support development and QA processes (advise on requirements management, architecture, development, testing, and project management)
- Communicate with interface partners
- Prepare presentations and give talks at workshops, kick-offs, and other events in Bonn and Berlin
- Data analysis and modeling
- IT environment: DB2, SQL, UML, BPMN, XMLSpy, Visio, SharePoint, DOORS, Balsamiq, exorbyte MatchMaker, Java, SOA, COBOL, V-Model XT ITZBund, Microsoft Office
Requirements Manager, Project Manager, IT Business Analyst
DeAM Investment GmbH (Deutsche Bank)
Aladdin Green package integration:
- Replace vendor RiskMetrics for market risk with BlackRock Aladdin
- Adjust interfaces, applications, and reporting
Requirements engineering:
Configure and test a .NET front end with abstraction and approval layer
IT environment: SQL Server, T-SQL, Excel, SSRS, RiskMetrics, BlackRock Aladdin, Oracle, XML, HP ALM, dbClarity
Requirements Manager, Project Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH (Deutsche Bank)
- Integrated risk monitoring & reporting (VaR, stress testing, backtesting, leverage, liquidity risk)
- Leverage calculation platform
- AIFMD reporting, client reporting efficiency improvements (OpEx), derivatives reporting
- IT strategy, various analysis tools, and reporting
- IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, SSIS, RiskMetrics, QlikView, SSRS
Requirements Manager, Project Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH (Deutsche Bank)
- Derivatives reporting
- Data warehouse interfaces
- SQL Server 2005/2008 migration
- Data center relocation
- SQL Server jobs/Control-M migration
- Leverage calculation
- Onboarding US portfolios
- Various analysis tools and reporting
- IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, Control-M, SSIS, RiskMetrics, dbClarity
IT Business Analyst, Developer
Corpnext GmbH
Migration from StaffIt to Salesforce (XML/CSV)
- IT environment: Access, VBA, SQL, XML, Salesforce, StaffIt
Requirements Manager, Project Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH (Deutsche Bank)
- UCITS IV/KID reporting system
- Liquidity risk system (RC Banken Liquidity Analyser, RiskMetrics)
- Backtesting monitoring & reporting tool
- Test, analyze, and evaluate a BI system (Armanta)
- Contribute to abstraction layer (expression layer, limit system, approval layer, stakeholder interface)
- Requirement specification
- Various analysis tools and reporting
- IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, Armanta, SSIS, RiskMetrics
Requirements Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH (Deutsche Bank)
- Regulatory monitoring & reporting solutions
- Requirement specification
- Derivative free check process/tool
- Various analysis tools and reporting
- IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, SSIS, RiskMetrics
Requirements Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH (Deutsche Bank)
- Regulatory monitoring & reporting solutions
- Time series upload process (Bloomberg/RiskMetrics)
- Onboarding APAC portfolios
- Dashboard
- Various analysis tools and reporting
- IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, SSIS, RiskMetrics, Bloomberg
Requirements Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH (Deutsche Bank)
- Regulatory monitoring & reporting solutions
- SQL Server 2000/2005 upgrade
- External auditor reporting system (KPMG)
- Migration from VBA XML loader to C#.NET RiskMetrics XML loader
- Reconciliation solution
- Securities lending reporting
- Early warning system (credit spreads, MarkIt data)
- Counterparty risk reporting
- Various analysis tools and reporting
- IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, SSIS, RiskMetrics
Freelance IT Consultant
Requirements Manager, IT Business Analyst, Developer
DWS Holding & Services GmbH (Deutsche Bank)
- Access/SQL Server 2000 upgrade
- Regulatory monitoring & reporting solutions
- RiskMetrics XML correction run
- DeAMFit client reporting
- Test, analyze, and evaluate an Oracle and ETL solution
- Various analysis tools and reporting
- IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, RiskMetrics
IT Analyst
AmpegaGerling Investment GmbH
- Integration of a reporting solution for fund fact sheets and monthly reporting
- Investment committee reporting
- IT environment: Quartal Flow, SQL Server
IT Consultant
Quartal Financial Solutions AG
- Developed a complex CRM solution based on Access
- IT environment: Access, VBA, SQL
- Created a study for automating upfront commission processing in fund business using SWIFT ISO 20022/UNIFI
- IT environment: Access, VBA, SQL, XML, Altova XMLSpy/MapForce, Quartal Commission
IT Analyst, Developer
Quartal Financial Solutions AG
Developed an application to dynamically map multi-layered sales processes in an international corporate structure
- IT environment: Access, VBA, SQL
IT Analyst, Developer
BWG & Co. KG mbH
- Integration support for a Java-based digital audit result capture solution
- Performance improvement for cross-plant databases
- IT environment: Access, VBA, SQL, Java
IT Analyst, Developer
BWG & Co. KG mbH
Optimized and extended a complex Access system landscape
- IT environment: Access, VBA, SQL
Apprentice Wholesale and Foreign Trade Clerk (IHK)
Arthur Friedrichs Nachf. (Industrial Supplies)
Summary
Agile IT consultant focusing on IT business analysis and requirements engineering for data management (databases, DWH, BI) and custom development: As an experienced senior IT consultant, I offer my skills for implementing your IT projects as an IT business analyst (BABOK), requirements engineer (IREB), product owner (Scrum), as well as requirements and project manager.
Since 2007, I have successfully supported and delivered IT projects in finance/asset management, the public sector, and transport and logistics.
I have extensive experience in SQL, relational databases, DWH, and business intelligence.
I am well versed in requirements analysis and management, as well as classic, agile, and hybrid project management, including waterfall (requirements and specification documents), V-Model XT, Scrum (backlog, user stories, etc.), and Kanban. I also have broad knowledge of technologies and approaches (business case, proof of concept, make-or-buy, etc.) for digitalization and digital transformation.
Languages
Education
IU – International University
Master of Arts, Project Management · Bad Honnef, Germany
University of Bamberg (VAWI)
Master of Science, Business Informatics · Bamberg, Germany
Bremerhaven University of Applied Sciences
Diplom Business Informatics · Computer Science/Business Informatics · Bremerhaven, Germany
Certifications & licenses
Digital Guide (i8-certified)
Mission Top 5
Data Warehouse Developer - Bronze (CeLS)
IREB Certified Professional for Requirements Engineering (CPRE-FL)
IT Requirements Engineer (CeLS) Author
Business Analyst (CeLS) Author
Business Intelligence Consultant - Gold (CeLS)
IT Project Member - Bronze (CeLS)
IT Project 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