Business Intelligence & Controlling

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

• Worked 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 enhancing 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 transfer of business processes: interface connections and data delivery agreements, system setup of metrics, hierarchies and reports, master data management
• Conducting functional and end-to-end tests
• Business-oriented acceptance of IT-developed packages
• Regular coordination with stakeholders
• Components: IBM Cognos 10 (Framework Manager, Report Query, Analysis Workspace, EventStudio); IBM Planning Analytics (Excel Perspectives, Architect, Web); MS Excel; Oracle 11g; SAP SEM; SAP FICO; HPALM; GDPR; Scrum

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

• Served as a Data Scientist to build a data platform for data management for Deutsche Bank AG's subsidiaries
• Identifying functional requirements and ensuring implementation of non-functional requirements and data governance policies
• Platform architecture design, process documentation, and selection of suitable software for data quality and data analysis
• Test planning and offshoring test activities
• Components: BCBS 239; MaRisk AT 4.3.4; Data Policy; Apache Hadoop; SQL; JSON
• Worked as a tester on General SAP Sub-Ledger in the finance area (commissions) for data analysis and quality assurance of migrated data
• Components: SAP FI Sub-ledger; HPALM; IBM AS/400

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

• Worked as a Controlling Systems Specialist in financial controlling to migrate Postbank-branded products to a new reporting platform
• Requirements management and specification in user stories
• Data analysis, preparation, integration, and reporting to the new data warehouse
• Step-by-step data migration into target structures
• Functional and acceptance testing
• Components: Tableau; IBM Planning Analytics (Architect, Web); PL-SQL; JIRA; Confluence; HPALM

• Served as lead developer in logistics to build a new self-service BI for payment transactions with doctors
• Project management, requirements management, enterprise architecture, data architecture, and implementing the system landscape including permissions, roles, and security
• Implementing ETL processes: 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
• Gathered requirements from specifications and wrote detailed specs
• Developed service reports, balanced scorecards and mobile dashboards
• Coordinated with different business units

• Developed ETL processes to detect current ATM outages and set up the operations manual
• Components: Microsoft SQL Server 2008 (Integration Services SSIS, Microsoft Reporting Services SSRS, Visual Basic procedures, T-SQL)

• Designed automation of customized Excel reports from Risk Finance
• Rebuilt the reports in Microsoft SQL Server Reporting Services (SSRS)

• Worked as a programmer in the "BTM Apps and Solutions" department
• Calculated and built key performance indicators from various Excel spreadsheets into a final report using Visual Basic for Applications (VBA for Excel)
• Created a user manual