Business Intelligence & Controlling

• Analysis, specification and gathering of technical requirements
• Creation and maintenance of functional concepts for reports
• Performing data quality checks across the data lineage (source systems, data integration layer (DIS), DWH layers, REDIX reports)
• Responsible for data governance and data delivery agreements with data suppliers and consumer systems
• Documenting processes, reports, and data models
• Components: Data Management Tool, DB2, DbVisualizer, BCBS 239, MicroStrategy, SQL, JIRA, GIT, Scrum

• Deployed in financial controlling to build, optimize, and manage reporting and planning processes in financial controlling: cost and performance accounting, product portfolio management, segmentation.
• Translating banking requirements (functional and non-functional) for IT
• Designing and further developing processes for product portfolios and cost segments (FP&A)
• Preparing monthly reports and annual financial statements
• Responsible for operating and enhancing the reporting platform
• Technical implementation of business processes: interface connections and data delivery agreements, system-side creation of key figures, hierarchies and reports, master data management
• Conducting functional tests and end-to-end tests
• Business acceptance of the IT-developed packages
• Regular coordination with stakeholders
• Components: IBM Cognos 10 (Framework Manager, Report Query, Analysis Workspace, Event Studio), IBM Planning Analytics (Excel Perspectives, Architect, Web), MS Excel, Oracle 11g, SAP SEM, SAP FICO, HP ALM, GDPR, Scrum

Project: Unity (02/2021 - 03/2022)

• Served as data scientist to build a data platform in data management for Deutsche Bank AG subsidiaries
• Gathering functional requirements, as well as ensuring implementation of non-functional requirements and data governance policies
• Platform architecture, process documentation and selection of appropriate software for data quality and data analysis
• Test conception and offshoring of testing activities
• Components: BCBS 239, MaRisk AT 4.3.4, Data Policy, Apache Hadoop, SQL, JSON
• Served as tester for general SAP sub-ledger in the finance area (commission business) for data analysis and quality assurance of migrated data
• Components: SAP FI Subledger, HP ALM, IBM AS/400

Project: Management Information System (MIS) (07/2018 - 08/2019)

• Served as Controlling Systems Specialist in financial controlling for migrating Postbank brand products to a new reporting platform
• Requirements management and specification in user stories
• Data analysis, preparation, integration and reporting into the new data warehouse
• Stepwise migration of data into target structures
• Functional and acceptance testing
• Components: Tableau, IBM Planning Analytics (Architect, Web), PL/SQL, JIRA, Confluence, HP ALM

• Served as lead developer in logistics to develop a new self-service BI for payment transactions with physicians
• Project management, requirements management, enterprise architecture, data architecture, and implementation of the system landscape including permissions, roles and security
• Implementation of ETL process: interface connections and building data marts, data warehousing (relational data modeling), process automation
• Designing and developing reports/dashboards
• Coordinating with stakeholders and application operations
• Data quality checks, testing/bug fixing/acceptance
• Components: MicroStrategy v9.4 (Developer, Web, Object Manager, Visual Insights), Oracle 11

• Developed MicroStrategy balanced scorecards in the Hercules project from the Maximo system
• Gathering requirements from functional concepts and specifying them
• Developing service reports, balanced scorecards and mobile dashboards
• Various alignments with business units

• Developed processes to identify current disruptions at ATMs (ETL), setting up the operations manual
• Components: Microsoft SQL Server 2008 (Integration Services SSIS, Reporting Services SSRS, Visual Basic procedures, T-SQL)

• Designed automation of individual Excel reports for risk finance
• Rebuilt the reports in Microsoft Reporting Services SSRS

• Worked as programmer in the “BTM Apps and Solutions” department
• Calculating and building key performance indicators from various Excel tables into a final report using Visual Basic programming (VBA for Excel)
• User manual