Andrzej Sztwiertnia available (1 Recommendations)

Andrzej Sztwiertnia

Business analyst, Project manager, Solution architect, Backend developer, Oracle, JAVA, C++, UNIX

available (1 Recommendations)
Profileimage by Andrzej Sztwiertnia Business Analyst, Projekt Manager, Solution Architekt, Backend Entwickler, Oracle, JAVA, C++, UNIX from Freigericht
  • 63579 Freigericht Freelancer in
  • Graduation: PhD at Warsaw Technical University
  • Hourly-/Daily rates:
  • Languages: German (Full Professional) | English (Full Professional) | Polish (Native or Bilingual) | Russian (Elementary)
  • Last update: 02.07.2021
Profileimage by Andrzej Sztwiertnia Business Analyst, Projekt Manager, Solution Architekt, Backend Entwickler, Oracle, JAVA, C++, UNIX from Freigericht
Rreference DeuBa

You need an account to view this information.

Business skills
My business knowledge and experience are based on activities in the following areas:

Financial Instruments Data Management
Analysis and design of a security master data management system WMS.

Market Data management
Analysis, redesign and development of the market data management system. This system is the data source for market data published in stock exchange newspaper (“Börsen-Zeitung”).

Derivative key figures
Analysis and design of solution for calculation of derivative risk figures for WM Gruppe

Portfolio Risk Management
Design and development of a data consolidation solution (PDB) for Portfolio Consulting Tool (PCT). These applications are operated at Private Wealth Management division of Deutsche Bank in cooperation with MSCI.

Structured and Lombard Loans
Analysis and design of global lending and credit risk management solution for Private Wealth Management.

Anti-Money Laundering / KYC Systems
Introduction and deployment of the AML solution at Allianz Group with scope of CDD (Customer Due Diligence), WLF (Sanctions Screening & Watch list filtering), SAM (Suspicious Activity & Transaction Monitoring).

Technical and methodological skills

Development Methods:
Agile (SCRUM), Waterfall, Prototyping (incl. Rapid Prototyping), DevOps

Analysis Methods:
Structured Development, Structured Analysis and Design (Top/down, Bottom/Up), OOP (UML), CASE Methodology, TOGAF, BPMN 2.0

Programming languages:
Phyton, JAVA, C/C++, SQL, PL-SQL, Unix Scripting, Fortran, Pascal, BASIC (VBA)


Operating systems:
UNIX (Linux, AIX, Solaris), Windows (all releases, Windows Server), Novell NetWare, Digital (RSX, VMS), Main Frame (Norsk Data, P&E)

Database management systems:
Oracle, MS-SQL Server, MySQL, MS-Access, SQL-Base

JIRA, Confluence, Eclipse, MS Visual Studio, SSIS, VISO, UC4,, svn, git, etc.
  • 05/2019 - 11/2019

    • VTB Bank (Europe) SE
    • 250-500 employees
    • Banks and financial services
  • Architecture review and documentation of banking systems
    • Review and completion of the system architecture and documentation
    • Migration support

  • 11/2018 - 06/2019

    • Deutsche Bank AG / Corporate and Investment Bank
    • >10.000 employees
    • Banks and financial services
  • Process management for KYC system
    • Review of existing KYC process, proposal of improvements
    • Management of system vendors PwC and Accenture
    • Membership in solution innovation and vendor selection boards

  • 10/2013 - 04/2019

    • Deutsche Bank AG / Private Wealth, Asset Management
  • Global Lending and Risk Management system
  • 09/2013 – 12/2018 – Solution Architect

    • Undertaking of the feasibility study
    • Design of high-level architecture (Functional- and Data Models), definition of working packages, cost estimation
    • Evaluation of the final solution architecture, definition of application layers, definition of technology components

    01/2014 – 08/2016 Team Leader / Project Manager

    • Database and service layer development (detailed database design and service design)
    • Analysis and implementation of the data migration

    09/2016 - 12/2018 Head of Development

    • Coordination of work streams, team and budget planning.
    • Team: ca. 30 developers, Project volume: ca. 5000 PD/Year

    12/2018 – 04/2019 Consultant

    • Supporting knowledge transfer to new offshore team

  • 04/2017 - 12/2017

    • Deutsche Bahn AG
    • >10.000 employees
    • Transport and Logistics
  • Marketing Datawarehouse
    • Architecture design
    • ETL-process development
    • Front-End application developer support
    • User support

  • 05/2010 - 12/2013

    • Allianz Managed Operations & Services SE (AMOS)
    • >10.000 employees
    • Banks and financial services
  • Roll-out of the central AML solution to regional branches
    • Interfaces analysis and setup (ETL)
    • Support of system customizing and implementation
    • Planning and implementation of tests
    • Organization of workshop, coordination of global and local teams
    • Hand over to the business, trainings
    • Project volume: ca. 2000 PD/Year


Lenz und Partner GmbH

Geschäftsführender Gesellschafter ( Frank Lenz )

In verschiedenen Projekten hatten wir als Lenz und Partner GmbH und ich als Geschäftsführer Herrn Sztwiertnia als Functional Analyst im Einsatz. In diesem Kontext hat Herr Sztwiertnia seine ausgewiesene Expertiese im Umfeld mit Datenbanken wie auch Kurs-/Kennzahlenproblemstellungen unter Beweis stellen können. Ich möchte mich bei Herrn Sztwiertnia für seine wertvollen Beiträge bedanken und würde im Rahmen ähnlicher Fragestellungen jederzeit wieder gerne auf seine Expertise zurückgreifen.