C Experts in Frankfurt

• Industry: Insurance, Trade, IT
• Customers & Projects: Consulting and selling insurance and similar services
• Main tasks: Insurance consulting (health insurance, retirement planning, wealth building); commercial services, inside and field sales; sales data analysis and forecasting; customer consulting and support; opening a new sales headquarters for private and business customers; business development & innovation management; business use case development; process optimization; stakeholder management; team leadership and training; preparation and delivery of trainings;
• Technologies used: Microsoft Office 365, Microsoft Teams, Jira, Draw.IO, Camunda 8, Java (8, 17,21,25), Git, Spring Boot, Spring Batch, Spring Data REST, Spring Web, Spring Security, J-Unit, Playwright, Lombock, Vaadin, H2, PostgreSQL (16, 17 18), pgAdmin, Docker, LLMs, JasperSoft Studio, JasperReports

• Introduction of 5 different process applications for different teams

• Release planning: scope and time management

• Resource/capacity planning

• Conducting Sprint Planning / retrospectives

• Increment planning (several sprints)

• Preparation of Steering Committee meetings / reporting to the Board

• Coordination / alignment with external suppliers / deliveries

• Resource planning for multiple projects

• Coordination with business department and development team

• Identification of best practices with IBM BAW

• Cost control and planning for the project team and external service providers

• Collection of KPIs using LogScale

• Analysis of application errors with LogScale / Queries

• User Story definitions / coordination of requirements with the business department and development team

• Testing and defect tracking

• UI/UX design of applications

• Preparation and moderation of Brown-Paper workshops

• Test concept, test data, test organization, test execution

• Collection of team velocity / metrics

• Test execution

• Script for automated testing

• Test organization with business department and IT

• Recording and prioritization of defects

• Establishment and operation of the application

• Establishment of application monitoring with LogScale Dashboards

• Checking health endpoints with PowerShell

• Post Mortem analysis

• Establishment of Incident Management

• Establishment of Problem Management

• Analysis of errors using LogScale Queries and Dashboard

• Pre-processing of data for AI

• Evaluation using AI language models (Meta Llama 3.3 LLM and deepset Haystack) and RAG

• Installation of runtime environments for LLMs (Large Language Model)

• Evaluation of various LLMs

• Installation of RAG (Retrieval Augmented Generation) and integration with LLM

• Extraction of unstructured data with LLM and RAG

• Project based on IBM BAW (Business Automation Workflow), Websphere Liberty, Domea, d.3, REST, LogScale (formerly Humio), Swagger, Powershell, JIRA, Confluence, Lucom Interaction Platform (LIP), Mattermost, Jabber

• Analysis of the existing reporting platform, including processes and governance topics, with stakeholders from Sales and Marketing.

• Detailed analysis and evaluation of customer-defined requirements for existing reporting and new dashboards to be established.

• Support for stakeholders in managing sales processes and identifying KPI trends at an early stage.

• Use of Microsoft Power BI as the central analysis and reporting platform.

• Development of a proposal for the required further development of processes and the Power BI platform.

• Documentation of AS-IS business processes and derivation of company-wide KPIs, including coordination with stakeholders.

• Analysis and assessment of the customer's Power BI platform.

• Analysis of processes and data governance.

• Documentation of AS-IS business processes.

• Development of recommendations for further developing processes and the reporting platform.

• Design and implementation of dashboards in Power BI.

• Development of company-wide KPIs and coordination with stakeholders.

• Microsoft Power BI.

• Data analytics.

• KPI definition and reporting.

• Dashboard design and data visualization.

• Stakeholder management and requirements management.

• Responsible for the concept, planning, and delivery of product development for GetMyInvoices 2.0 and its subcomponent InvoiceRails
• Independently handled all aspects of the project, including concept development, writing ticket specifications, and coordinating developers
• Created, managed, and prioritized tickets to ensure all tasks were completed on time and to a high standard
• Conducted and/or coordinated tests and ensured the proper implementation of developed features and functionality
• Worked closely with developers to clarify technical requirements and ensure implementations met specifications
• Regularly reported on project progress and documented key decisions, changes, and risks
• Took the lead on all topics related to e-invoicing and Peppol, especially regarding the InvoiceRails component
• Provided internal guidance and shared knowledge about e-invoicing and Peppol with other teams and departments
• Tracked market trends and new developments in e-invoicing and Peppol to continuously adapt the product strategy
• Ensured the products’ long-term scalability and adaptability to future technological and legal changes in e-invoicing

Statistical Forecasting Algorithm

• Improvement of an statistical probabilistic forecasting algorithm for sales + evaluation
• Migration from R/On-premise to Python/Snowflake
• Productionalization on Snowflake in cooperation with data engineers & DevOps

Monitoring Dashboard

• Data engineering for preparation & provisioning of necessary data/resources on Snowflake
• Development & deployment of a Streamlit dashboard in Snowflake

ML-based Probabilistic Forecasting on Vertex AI

• Development of a ML-based probabilistic forecasting algorithm from scratch
• Implementation of MLOps pipeline in Kubeflow on Google Cloud Vertex AI

Tech Stack: Python, Snowflake/Snowpark, R, Streamlit, Gitlab/Gitlab CICD, Terraform, Google Cloud, Vertex AI (aiplatform SDK, gcloud CLI, feature store, model registry, etc), kubeflow

• Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
• Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
• Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
• Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
• Designed scalable data foundations suitable for downstream analytics and AI workloads.
• Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.

• Designed and specified the technical network integration of a new business critical application system (MUREX) in the capital market area in a complex interface and outsourcing environment.

• Created component specifications, catalog of measures and implementation plan.

• Ensured proper integration of developed results in accordance with the bank’s framework: IT compliance, IT security, change and release management.

• Selected and integrated a new service provider for the bank; moved critical bank applications to the provider.

• Designed, implemented and supported the new Cisco network and Fortinet security setup at the service provider data center.

• Acted as technical interface between bank, service providers and consulting partners.

• Supported and further developed the network and security infrastructure (clients, servers, networks); performed error analysis and implemented solutions within agreed service levels.

• Analyzed and diagnosed all security and network failures, glitches and malfunctions.

• Initiated continuous enhancements to guarantee efficient resource utilization and acceptable response times to users.

• Provided network support in financial service organization and operational change preparation on production banking network infrastructure for both large and small projects within strict change management discipline.

• Designed, defined, tested, governed and improved engineering standards.

• Performed role of network architect for medium-large projects involving team resources.

• Define the QA strategy and plan for the above mentioned OEMs project.

• Identify applicable processes, methods, and standards to be followed (eg, GS_95014, KGAS, ISO/IEC 15504, ISO 26262, ISO 21434, etc.).

• Plan reviews, audits, and assessments as per the strategy.

• Check whether the project follows defined processes (System, software, mechanical, hardware, testing, change, configuration, problem, risk etc.) as per strategy.

• Provide QA support to software process: software requirement analysis, software architectural design, software detailed design and unit construction, software unit verification, software component verification and integration verification, software verification processes.

• Monitor compliance with organization-wide and project-specific standards.

• Verify that deviations are documented and escalated.

• Review work products (requirements, design docs, test cases, code, reports (MISRA, C0, C1, coding standards), etc.).

• Check compliance with standards, templates, and checklists.

• Ensure that bi-directional traceability exists (e.g., requirements ↔ design ↔ tests).

• Give objective evidence (not influenced by delivery pressure) during assessments.

• Identify non-conformances (process not followed, missing approvals, wrong standard).

• Report deviations and track them until closure.

• Verify that corrective actions are implemented (5why, Ishikawa, 8D, FMEA, FTA, DFM, DRP, PCC, LLBP, PDCA).

• Provide QA status reports to management and project stakeholders.

• Highlight risks related to process non-compliance.

• Deliver objective evidence for assessments/audits (e.g., ASPICE, ISO/IEC 15504, ISO 26262, ISO 21434, ISO_PAS_8800).

• Collect and analyze QA findings.

• Suggest process improvements.

• Support lessons learned activities.

• Achieved ASPICE Level 1 and Level 2 for multiple Audi and Mercedes-Benz projects assessments.

• ITSM consulting, analysis and optimization of IT capacity with BMC TSCO / BMC Helix
• Drafting "Governance guidelines for operational capacity management"

• Maintenance and further development of the Java/Swing-based @rtus FormsEditor
• Design and development of a graphical formula editor based on Google Blockly for representing a project-specific DSL, including parsing and code generation
• Implementation of character-accurate synchronization between the editor and print preview to improve the user experience
• Technologies: Java 17/21, Swing, JavaFX, JBoss/Wildfly, JUnit, Mockito, Blockly, JPedal, ICEPDF, Eclipse

• Provided consulting for modernizing legacy applications
• Delivered critical features under tight deadlines for backend and frontend
• Technologies: C#, .NET, WPF, WCF, REST, Angular, MS SQL Server

• Main developer in an online retail company
• Built an online shop using the Next.JS React framework
• Integrated the site with dozens of third-party apps using REST and GraphQL APIs
• Built a backend for order management, warehouse management (with iPhone app), and supply management
• Automated invoicing and finances with QuickBooks

• 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.

• Recognition of national notified bodies
• Preparation of cybersecurity competency reports
• EU Radio Equipment Directive