DbVisualizer Experts in Germany

• The goal of BIENE is to provide a uniform program for tax collection for all states.

• In tax collection, the aim is to collect the assessed taxes. This includes handling due dates, documenting incoming and outgoing payments, triggering reminders or refunds. Statute of limitations and payment reminders also play an important role. All payment transactions with banks and accounting are mapped in BIENE.

• Setting up the architecture and coordinating the provisioning of development and test environments at the Hanover location

• Installing and configuring environments on Linux servers (Apache Kafka, PostgreSQL)

• Interface tasks: coordinating and aligning the integration of software products from other departments and their test data

• Upgrading application server, JDK, Maven project structure

• Environment coordination and build management

• Implementing external interfaces

• Implementing business requirements

• Designing and implementing RESTful APIs and OpenAPI specifications

• Designing and implementing microservice architecture

• Setting up and maintaining CI/CD pipelines

• Deploying applications on OpenShift

• Creating technical documentation and diagrams

• Working with SQL databases (Oracle and PostgreSQL)

• Setting up authentication and authorization for the application and users

• Containerizing the application (automated deployment via CI/CD pipeline)

• Designed a future-proof client database for marketing purposes
• Analyzed requirements, designed, and modeled an entity-relationship model
• Consolidated and optimized a client file from various data sources for targeted marketing campaigns
• Worked closely with marketing and IT in an agile environment to iteratively develop the solution
• Technologies and methods: MS Office (mainly Excel), MS Dynamics CRM, MS SharePoint

• Requirements analysis and replacement of local SharePoint as CMDB with open source NetBox to prepare for deploying Cisco ACI (SD-WAN) with Microsoft Azure
• Coordination with systems like Checkmk and Grasp
• Introduction and coordination of cmdbsyncer as CMDB data hub; further development of the syncer with Kuhn & Ruess GmbH
• Implementation of SNMPv3 on AIX LPAR/VIO, Linux, Windows, SAN/storage, network components (Cisco switches, F5 load balancers, Palo Alto and CheckPoint firewalls, iLO boards)
• Deployment and further development of the network scanner JDisc in cooperation with the vendor (Utimaco HSMs, Linux detection)
• Integration of NetBox, JDisc, and cmdbsyncer into the infrastructure using Docker containers
• End-user training: preparation, creation of materials, and delivery
• Creation of data flow and network diagrams
• Population and planning of IPv4/IPv6 with NetBox including VLAN import
• Dual-stack setup of servers and clients with IPv4 and IPv6
• Connection of REST interfaces for Checkmk, JDisc, vSphere, HMC, i-doit, NetBox Software: Confluence, Jira, MS Office 365, Teams, i-doit, NetBox, JDisc, cmdbsyncer, DB Visualizer, vSphere, HMC

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.

• Supported the International Web Presence project of the Federal Employment Agency (IntWeb) in quality management, taking on responsibility for the quality of processes and project deliverables while adhering to BA standards. The project's main goals are to give professionals abroad a quick overview of their chances to move to Germany and to enable them to take the necessary steps in a consistently digital way.

• Set the fundamental guidelines using the QA handbook

• Summarized test results in QA reports for PLA

• Analyzed project outcomes for improvement opportunities

• Quality management of requirements analysis (especially processes, methods and tools)

• Ensured compliance with SERA guidelines

• Created a cross-project test concept

• Agreed on sprint completion reports

• Conducted formal reviews of deliverables according to guidelines and/or project plan

• Acted as contact person for internal audit and external audits by auditors or the Federal Audit Office (BRH)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes

• Gathering, analyzing, specifying, and prioritizing requirements for the 'Archive and Delete' module of the Chambers of Industry and Commerce in a Scrum team
• Capturing and specifying screen/form designs, functionality, and data types in Confluence, as well as creating user stories in Jira
• Preparing PowerPoint presentations for the 'Archive and Delete' module
• Coordinating and supporting the Chambers of Industry and Commerce in the implementation of the module
• Writing SQL scripts for an Oracle database
• Technologies used: Scrum, Confluence, Jira, MS Office, Postman, JavaScript, REST API, JSON, DBVisualizer, SQL

• Creation and review of test conditions

• Execution of functional tests

• Defect management

• Supplier management

• Team coordination

• Estimation of test effort and reporting

• Test planning

• Ongoing and new development of integrated scheduling systems

• Java web client / Linux server, Oracle Instant Client / Oracle Database Appliance server, Unix, ESB – Enterprise Service Bus, SQL, TIBCO EMS – Enterprise Message Service / JMS, REST, Impero Guest

• HP ALM / Micro Focus Quality Center, Citrix, JIRA, XRAY, Impero Guest, MobaXTerm, Confluence, SharePoint, MS Teams, MS Office

• Managed technical projects for passenger information systems in rail vehicles
• Managed project and requirements management and efficient use of resources
• Created cost plans and conducted risk assessments
• Coordinated staff management

• 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

• Creating a new test strategy for AXA Deutschland
• Analysis of the existing strategy and identification of current pain points
• Creating a survey to determine the status quo of current testing activities for each application system in the group
• Building a business case as a decision template for the executive board
• Building a roadmap and the related capacity planning for implementing the new test strategy
• Optimizing internal planning processes with regard to test capacities
• Coordinating offshore activities and acting as the interface between the onshore team and offshore experts

• Developed and enhanced ETL loading jobs with IBM DataStage and optimized SQL in an IBM DB2 environment as part of the Agree21 data migration
• Analyzed data quality and developed test procedures
• Created PowerShell scripts and documented GIT deployment processes
• Technologies: RedHat Linux, IBM DB2 with DBVisualizer, IBM InfoSphere DataStage 11.7, JIRA, TortoiseGIT, TortoiseSVN, PowerShell scripts

• SBAM (Sendungsbasiert Auftragsmanagement System) is the core component responsible for splitting customer deliveries into individual letters based on contractual agreements (OLA/SLA).
• Transformation from proprietary host-based AS/400 applications to a modern stack using Java, PostgreSQL, Apache Kafka, MinIO S3, Red Hat OpenShift, Keycloak SSO, Salesforce and Angular Material GUI.
• Application design, solution architecture, use case specification and OLA/SLA concept for end customers.
• Conduct solution architecture/design and requirements engineering (elicitation, documentation, validation, negotiation and ongoing management) in Confluence, including UML/BPMN process models.
• Development and analysis according to Scrum using Jira and Confluence.
• Design user journeys and UI experience; wireframing with Balsamiq and Figma.
• Document requirements as user stories and epics in Jira; create stakeholder and technical design documents.
• Participate in end-to-end solution design, architecture and event-driven messaging design.
• Perform process modelling (UML/BPMN with Draw.io), application internal architecture design and ERM/SERM data modelling.
• Lead sprint planning, story refinement, estimation, retrospective and review meetings; deliver C-level management presentations on OLA/SLA and order management.

• Provision of cross-system synthetic test data for test automation for insured persons, companies and external partners in coordination with specialist departments and stakeholders, taking requirements and test cases into account
• Synthesis of test data with regard to data protection and data security

• Analysis, online COBOL software development and testing of dialog and batch programs in the Kranken Leistung (KL) project

• Error analysis, bug fixing and ticket resolution (change requests and defects)

• Documentation in collaboration with the contact office and the mathematics department

• IT skills: Siemens Fujitsu BS2000, CCOM Emulation, Micro Focus Visual COBOL I and II, Eclipse IDE, UDS database system, Atlassian Confluence and Jira, ZULIP, UNIFY