FATCA Experts in Germany

• Creation of automated tests.
• Extension of the functionality of the enterprise BI data warehouse.
• Design and development in SQL and PL/SQL.
• Data modeling as well as performance measurement and tuning.
• Creation of and contribution to user stories and concepts.
• Technical environment: Windows, Linux.
• Database: Oracle 19c incl. DWH, CDB, PDB.
• Tools: Confluence, CVS, Eclipse, Git, GitLab, Jira, N4, PL/SQL, SQL Developer, utPLSQL.

• Goal: further development of existing end-to-end data distribution, from development partners to dealers and remotely into vehicles; design and implementation of future data distribution in a globally distributed cloud
• Budget / scope undisclosed (approx. 47 external employees)
• Result: The project is running and is on time, in scope, and on budget.
• Responsibility: As part of the management team in a leading role for planning and carrying out project management tasks; scope and time management (from mind map to network plan to project plan); interface to the group finance department, recruiting, budget acquisition (e.g. from model series management, production, IT budgets, etc.), demand management.

• Supports companies and teams in designing and implementing strategies and projects
• Carries out necessary organizational development and change for a VUCA world

Projects & Key Activities:

• Led a company-wide digital transformation project at an insurance company (≥10,000 employees) to boost the use of digital distribution channels, targeting cost savings of around €5 million
• Provided management consulting in agile corporate leadership and project governance for an architecture and engineering firm
• Led a digitalization project at an insurance company to use digital distribution channels, achieving cost savings of around €3.5 million
• Designed and supported the company-wide rollout of Print & Follow, Follow Me Print, and Pull Printing at an insurance company
• Designed and implemented an audit-proof compliance process (FATCA & CRS) at an insurance company
• Led an output optimization project at an insurance company, reducing costs by €1.2 million
• Relocated and set up a new data center infrastructure for a healthcare service provider/software vendor
• Supported the acquisition of a coverholder by a foreign investor (change management, process optimization)
• Co-led a company-wide reporting implementation project (KPI tracking) at an insurance company
• Led the feasibility study for a company-wide output optimization project at an insurance company
• Advised and designed agile corporate leadership and project governance for an architecture and engineering firm
• Continued the digitalization project to implement a digital document management system (DMS) at AOK

• Datastage 11.7, dbt, Oracle 19, Python 3.12 / PySpark 3.5, Azure GitHub, Azure DevOps, Automic
• Development of migration jobs to transfer data from the collection DWH to the new Risk Mart, as well as development of ETL pipelines to migrate historical data from the old Mart to the new Risk Mart.
• Storage of the silver layer on Hadoop and the gold layer in Oracle.
• Translation of DataStage jobs into dbt to publish reporting data in Google Cloud to a PostgreSQL database.
• Creation and optimization of complex SQL queries for data extraction from a data vault, taking into account historical data in the point-in-time tables.
• Creation of Oracle table definitions (DDL) and adjustment of existing stored procedures.
• Versioning changes in GitHub and deployment via the CI/CD portal.
• Refactoring long-running DataStage jobs into Python using PySpark to reduce server load.
• Migration of SAS scripts to PL/SQL, including new development of distribution functions that have no direct equivalent in Oracle.
• Development of Automic jobs to run DataStage pipelines and Python scripts (PySpark jobs) that control the population of the SME and institutional risk tables in the Risk Mart and perform business calculations.
• Participation in the agile process, including creating user stories, estimations, and planning in Azure DevOps.
• Handling Azure DevOps tickets and close collaboration with testers and business teams for error analysis and resolution.

• Responsible for business development, sales, partnerships, and marketing
• Project management and business analysis for regulatory and strategic projects
• Test management
• Expert in digitalization strategies
• Expert in new EU regulations and legislative changes
• Expert in client-related projects
• Implementations in asset management and in the banking sector

• full-service marketing agency for global technology companies

• Auditing processes and controls related to FATCA Germany.
• Checking proper release management for FATCA reporting software.
• Identifying areas for action.

• Planning and control of all testing activities of a test team

• Creation of test strategies for system, integration, and acceptance tests, including coordination with providers and clients

• Creation of test specifications (equivalence class partitioning, boundary value analysis, use case-based tests, exploratory testing)

• Creation and review of test cases

• Execution and documentation of tests for functional requirements, bug retests, performance tests, and regression tests

• Testing of interfaces and APIs

• Responsibility for regression test activities and test automation

• Execution of test sign-off processes and preparation of regular status reports

• Main contact for providers and clients on testing issues

• Responsibility for test environments and bug process

• Moderation and leadership of test stand-ups, team, and project meetings

• Review and creation of requirements documents (Business Requirements and Functional Specifications)

• Maintenance and support of test tools (Java)

• Planning, control, and execution of test cycles for the production of annual tax documents

• Detailed planning of the dress rehearsal and production processes

• Tracking of production schedule

• Management and execution of acceptance tests with clients in the withholding tax project (2009–2010)

• Preparation of management reports on test status for the reporting program (QI, FATCA, CRS, FKB, FSAK, Gift Tax) (2014–2018)

• Tools and standards: Agile test management/Scrum, Jira, Bugzilla, HP ALM 12, Enterprise Architect 13, Confluence, MS Project, MS Visio, MS Office, Tributum, ee2, RDES, OMS, dbPrint, DMS, Oracle 12.1, SQL Developer, Altova XML, MQ Series, Java, Windows, OS/z, Unix

• Responsible for managing three main funds and multiple SPVs, including the preparation and oversight of accounting, financial controlling, fund reporting, and the execution of capital calls and distributions to maximize financial performance and business success.

• Quarterly valuation of portfolio companies for investor reporting and year-end financial statements according to EVCA/IPEV.

• Leading quarterly accounting and financial reporting for the managed funds, ensuring precision and timely delivery in line with HGB/KAGB standards.

• Collaboration with external auditors to support efficient year-end audits.

• Preparation of cap tables, calculation of shareholder loan balances, and distribution simulation (waterfall calculation) for portfolio companies.

• Responsible for the creation of integrated financial models and business plans.

• Project work, such as fundraising, further digitalization of fund control and reporting processes, and undertaking various special valuation projects.

• Collaboration in tax and accounting with external service providers (Aztec Jersey and Lux).

• Oversee regulatory compliance, including reporting to the German Federal Bank, BaFin, FATCA, and CRS.

• Responsibility and operational tasks for the financial accounting including monthly closing for Aurelius Wachstumskapital SE & Co. KG and various holding companies of the Aurelius Group
• Support in consolidation
• Systems: DATEV

• Ad-hoc support in settlement for derivatives

• Settlement of ETD (futures & options), OTC (DTGs), give-up/take-up etc.

• Position and account reconciliation

• Coordination with trading, Eurex, UBS AG and asset management

• New setup of classes for options and series

• Support of the Securities & Operations unit for EMIR REFIT

• Advisory for project management of EMIR REFIT and support for implementation

• Communication and coordination with the software vendor to clarify business issues

• Main responsibility for creating the test concept for go-live on 29.04.2024 (Phase I) and bug fixes/cleanup actions (Phase II)

• Active support during go-live: creation of transaction, valuation and collateral reports; migration of the position report; defect management and bug fixing

• Inventory of cleanup Phase II

• Business test case creation for EMIR REFIT functionalities and coordination with IT teams and the business unit

• Creation and updating of training documents and work instructions for OBS modules WPS and GDH

• Jul 2024 – Feb 2025 Transformation (NDA – Clients)

• Implementation of the value creation plan in a private equity-backed industrial company

• Served as Interim Transformation Officer; responsibilities: central project management including timeline, budget, resources, reporting, risks

• Oct 2023 – Apr 2024 Sourcing, Regulation (Retail Bank DE)

• Change Lead for the implementation of a regulation (CESOP), responsible for project governance, project controlling (budget, resources) and project reporting, stakeholder management, timeline and project risks

• Drafted SLAs and aligned with relevant 2nd lines (Legal, Compliance, Tax, Third Party Risk – MaRisk BAIT, ORM) for sourced services; aligned on the Statement of Work

• Apr 2023 – Aug 2023 IT Program Management (Retail Bank DE)

• Local coordinator for the rollout of a project management software combining program and agile backlog management views

• Responsible for migration preparation, communication of changes and new logic in Germany, stakeholder management

• Oct 2022 – Aug 2023 Regulation (Retail Bank DE)

• Local lead of the global program; combined 4 local projects (retail/wholesale banking) to implement the next generation messaging standard (ISO 20022)

• Implemented local project governance, communicated progress, aligned and managed stakeholders with global HQ

• Jul 2022 – Mar 2023 Digitalization, Data Management (Retail Bank DE)

• Change Lead aligning the local retail data model to the global standard and its implications for internal data providers and consumers

• Designed and aligned a detailed implementation plan with global and local stakeholders

• Project management: set up new project governance and routines, reviewed progress in weekly meetings with product owners, chaired SteerCo meetings, documentation

• May 2022 – Apr 2023 KYC Regulation, Process Management (Retail Bank DE)

• Built a highly automated customer offboarding process for retail clients due to non-compliance

• Change Lead in development, testing and implementation in an agile environment with a 40-FTE project team

• Project management: held SteerCo meetings, accountable for the business case, project risk management, stakeholder management

• Jan 2022 – Mar 2022 Strategy, Product Development (NDA - Exchange)

• Coordinator in the concept phase for developing a cryptocurrency certificate with an external investment bank

• Orchestrated 5 workstreams, provided overarching PMO and stakeholder management

• Created the business case and aligned strategic options

• Oct 2020 – Oct 2021 Business Transformation, Sourcing (Largest German Bank)

• Implemented the organizational target operating model for KYC Germany as project manager

• Managed staffing and location setup (hired 250 FTE, logistics for new site)

• Built the KYC competence center for German large caps (department, team, roles) process-wise and organizationally

• Advised on contract negotiations with procurement for sourcing an external KYC provider

• Jan 2020 – Sep 2020 Digitalization, KYC Regulation (Largest German Bank)

• Germany coordinator (project manager) in an agile project to introduce an AMLD-5 compliant KYC software (MVP)

• Stakeholder management as nexus between local staff and management (back & front office), global project management, product owners, IT

• Incident management (capture, prioritization, tracking) with JIRA

• Jan 2018 – Jun 2019 Business Transformation, Tax Evasion Prevention Act Regulation (Largest German Bank)

• Led the implementation of the Tax Evasion Prevention Act in the global Corporate & Investment Banking division

• Analyzed legal requirements and developed a control concept in alignment with business and infrastructure units

• Successfully implemented IT and process solutions within budget and timeline; prepared initial regulatory reporting to the Federal Central Tax Office

• Project management: initiation, chaired SteerCo meetings, communication

• Dec 2016 – Dec 2017 Business Transformation, Banking Separation Act Regulation (Largest German Bank)

• Led the implementation of the Banking Separation Act in the global Global Transaction Banking (GTB) division

• Developed target operating model and process design (control concept) in coordination with IT and 2nd lines (Legal, Compliance)

• Successfully implemented changes in business units and IT per regulatory requirements

• PMO and represented the internal GTB project management in committees

• Jul 2015 Project Management (Largest German Bank – Asset Management)

• Implemented an asset management front-office system

• Interim head of the global PMO (Frankfurt, New York) with 4 staff

• Planned milestones, budget, regular reporting

• Prepared, attended and followed up on senior governance meetings

• Apr 2015 – Jun 2015 M&A Consulting – Due Diligence (NDA – Asset Management)

• Led a European operational due diligence (buy side) for a European asset manager back-office provider

• Produced red flag reports: screened data rooms, assessed organizational structure, identified risks in acquisitions

• Designed operating model scenarios for operations including business case

• Jan 2015 – Feb 2015 Target Operating Model (Largest German Bank)

• Conducted market and competitor analysis to realign multiple securities processing units (private & corporate clients)

• Ran a strategy workshop to develop a new target operating model for securities processing

• Jan 2014 – Dec 2014 M&A Consulting – Post Merger Integration (Largest German Bank)

• Organizational restructuring and group integration during the post-merger integration phase

• Deputy project manager leading 4 staff in the Integration Management Office (status reporting, attended sponsor meetings with senior management)

• Advised workstreams on cost reduction, synergy realization and business case controlling across 11 subprojects

• Feb 2013 – Dec 2013 Sourcing (State-owned Resolution Agency)

• Coordinated sourcing activities for the bankwide service-level agreement (SLA) creation with an external service provider

• Checked SLAs for completeness and consistency, facilitated cross-functional alignment within the bank

• Advised on preparing negotiation positions and participated in discussions with service providers and senior management

• Jun 2012 – Jan 2013 Sourcing (State-owned Resolution Agency)

• Developed site strategy: scenario analysis for European locations and created business case

• Advised and prepared tender and contract documents per EU procurement rules for outsourcing portfolio management services

• Led a team in drafting portfolio management service-level agreements

• Mar 2012 – Jun 2012 M&A Consulting – Carve-Out (Largest German Bank – Asset Management)

• Global carve-out of the institutional asset management business to a US investor

• Led the global operations workstream focusing on 3rd-party contract review, portfolio analysis, drafting and negotiating transitional service agreements

• Oct 2011 – Feb 2012 Regulation (various banks)

• Central support for FATCA project teams with technical work and Deloitte position papers

• Conducted client workshops for a cooperative bank on FATCA strategy for foreign financial institutions

• Process redesign and advisory support during implementation

• Jul 2011 – Oct 2011 M&A Consulting – Carve-Out (Life Insurance)

• Planned and prepared an M&A carve-out transaction

• Analyzed existing processes and defined target processes; facilitated cross-functional workshops and created day-1 checklists

• Operationally led the PMO with 3 staff for the carve-out (prepared and participated in steering committee, developed project plan)

• Feb 2011 – Jul 2011 Project Management (Life Insurance)

• Operational leadership of the PMO, project risk management

• Prepared post-merger integration steering committee at C-level

• Project reporting, stakeholder management, project and budget controlling

• Nov 2010 – Jan 2011 Securities Processing (Landesbank)

• Created data processing and business concepts for securities trading

• Designed test cases for IT interfaces

• Independently coordinated test execution with business requirements

• Sep 2010 – Oct 2010 Project Management (Asset Manager)

• PMO for introducing an independent P&L

• Budget tracking, prepared and documented steering committee