Adam Lopatka

Project description: Architecture Review. Enhancement and Improvements of business processes. Role in the project: Database and Software Architect, Consultant, Technical Project Manager and Developer. Activity: Business Application. Creating and maintenance of business application .NET 8 using Clean Code Pattern using Automapper, CQRS, Web API, Swagger and in Frontend Angular and Angular Material with TypeScript Database. Analysis and correction of deadlocks and concurrency exceptions in existing T-SQL queries. Implantation of new databases, stored procedures, functions and views. Optimization of runtimes, indexing, and MS SQL Server database structures with execution plans and query store. Introduction of a database project with Data Tier Application Package (DacPac) for the overall project and migration. TeamCity. Introduction and implementation of CI/CD workflows for development and production environments. Using remote PowerShell with Cred SSP authentication to distribute deployment packages OpenTelemetry. Implementation of distributed logging with Grafana and Loki, along with metrics and tracing for all services Proficiency Level: Expert. Project-based support for customer-specific developments

Business Application. Implementing complex backend

features according to requirements using Clean Code Pattern

with CQRS, Rest API’s and Frontend with JQuery with Kendo

UI, Bootstrap, Razor and ASP.Net MVC

Database. Optimization of runtimes, indexing, and MS SQL

Server database structures

The development of SQL Server Integration Services Extract,

Transform, Load (SSIS ETL) Implementation of controlling the

data flow with Full Data, Incremental Load, Slowly Changing

and Staging Table Pattern, Business Intelligence with SSAS

and Reporting with SSRS as well as developing ASP.NET

applications using the Entity Framework and MS SQL.

Understanding the business requirements and data

integration needs for ETL processes. Clarifying requirements,

including database structure and functionalities.

Creating an ETL design that describes the data flow and

transformation logic.

Test management and technical documentation

Deploying SSIS packages and applications to the respective

servers or hosting environments using Team City CI\CD

Project description: Global Rule Managmenent Tool (GRETEL). Creation and management of governance rules and business processes. Role in the project: IT Architect, Consultant, Technical Project Manager, Developer, and Tester. Activity:

• Integration, assignment, and modeling of business processes.

• Creation of event-driven process chains, Unified Modeling Language, and Business Process Modeling Notation.

• Implementation and introduction and further development.

• Creation and introduction of test scenarios.

Adam Lopatka Position

• Implementation of measures for technical and professional optimization.

• Quality management of software development (iterative software development and test-driven development). Utilized technologies: Web API mit C#, Knockout, Jira, Angular JS und Boostrap JavaScript Frameworks, Angular Materials .NET Framework mit C#, SQL Server development, WebSecurity, HVB SIM Process, Microsoft Entity Framework, Team Foundation Server, HTML5\CSS3