pandas Experts in Frankfurt

• Porsche ID is a unified digital identity platform providing secure authentication and seamless access across Porsche’s online services, mobile apps, and connected vehicle features
• Designed and implemented new authentication and authorization functionalities for both users and systems
• Ensured high availability, security, and performance to deliver a flawless digital experience for Porsche customers
• Technologies: Auth0, Angular, Tailwind, AWS, Terraform, Github
• Methodologies: Scrum and SAFe

• Analysis of the existing reporting platform including processes and governance topics with stakeholders from sales and marketing.

• Detailed analysis and evaluation of client-defined requirements for existing reporting and new dashboards.

• Supporting stakeholders in managing sales processes and early detection of KPI trends.

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

• Developing a proposal for the necessary evolution of processes and the Power BI platform.

• Gathering current business processes and defining company-wide KPIs in coordination with stakeholders.

• Analysis and inventory of the client's Power BI platform.

• Analysis of processes and data governance.

• Recording and documenting current business processes.

• Developing recommendations for process and reporting platform improvements.

• Designing and implementing dashboards in Power BI.

• Defining company-wide KPIs and aligning them with stakeholders.

• Microsoft Power BI.

• Data analytics.

• KPI definition and reporting.

• Dashboard design and data visualization.

• Stakeholder management and requirements management.

• Implementation of specified DevOps solutions to automate infrastructure (Terraform, Bicep, CloudFormation, Ansible) on-premises datacenter (Ovirt, Proxmox, Ceph Cluster, MinIO) and private cloud.
• Administration, configuration and implementation of CI/CD DevOps pipelines (GitLab, GitFlow) to support development process (Artifactory, Prometheus, Istio, service mesh, Helm Chart, OpenShift (Red Hat Enterprise) / Kubernetes cluster), Red Hat Satellite.
• Administration, setup, monitoring and patching of Linux infrastructure based on Red Hat Enterprise for Dev, Test and QA.
• Use of Scrum and Kanban methods.
• Administration, configuration and implementation of security standards for deploying on Dev, Test, QA and Prod stages of the new ePA applications.
• Development of new plugins and add-ons needed on current infrastructure.
• Database support.
• Data analytics support (Python, Spark, Pandas, Power BI, Splunk Enterprise).
• Implementation of best practices for DevSecOps and BizDevOps using GitOps (ArgoCD), Streamlit framework, Semaphore Ansible UI.
• Configuration and testing of iperf, uperf, sysbench using benchmark-operator for external source data and IoT/MDM devices, creating reports via ELK / OpenSearch.
• Building a new Databricks platform to collect and analyze big data from different sources and IoT devices into Hadoop framework (Python, Pandas, PySpark, Power BI, Apache Airflow).
• Building backend data aggregation and processing to automate configuration deployment between different OpenShift clusters and big data framework (Python, Pandas, PySpark, Apache Spark, PostgreSQL, Django 2, Ansible Automation, Jira JSM).
• Building a new ML pipeline platform using Kubeflow, TensorFlow, KServe.
• Data extraction, transformation and loading from different data sources including structured and unstructured data to analytic DWH / big data cluster using Python, Pandas, Polars, Power BI, Django backend and PostgreSQL.
• Setup of new DevOps Test and QA HashiCorp Vault cluster for PKI and IAM.
• Configuration and testing of automated patching based on CVSS score, SIEM-integrated CVEs.
• Use of Nexpose and InsightVM to scan vulnerability events in network, host, container and application.
• Design and implementation of secure and scalable AWS architectures including VPC, EC2, S3, RDS and Route53 and similar setups on Azure and GCP.
• Automated system provisioning and deployment using CloudFormation templates.
• Configuration of IAM roles, policies and permissions to ensure secure access control.
• Patch management, backup automation and disaster recovery setup on AWS infrastructure.
• Monitoring and optimization of system performance using AWS CloudWatch and AWS Trusted Advisor.
• Support of VMware services (vSphere, Aria, Horizon) and the virtual desktop environment.
• Development and maintenance of CI/CD pipelines using Jenkins, GitLab CI/CD and AWS CodePipeline with interface to Nutanix.
• Configuration of AWS CloudWatch to monitor application performance and system events.
• Planning and execution of migration of on-premises applications to AWS cloud platforms.
• Deployment of containerized applications using Docker and Kubernetes in AWS environments.
• Deployment of internal software packages between availability zones using AWS CodeDeploy.
• Building and deploying ML models using Scikit-learn, XGBoost and Spark MLlib including hyperparameter tuning, model evaluation and production deployment.

• Configured and automated data extracts from Oracle databases, achieving 100% data accuracy in a critical migration project, significantly reducing manual errors and accelerating the migration timeline.

• Designed and implemented interfaces with Order Management Systems (OMS), enabling seamless and automated data exchange and improving operational efficiency through faster, error-free order processing across business units.

• Developed and deployed data extraction workflows to support regulatory compliance and customer reporting, ensuring timely delivery of key reports, reducing manual effort, and increasing customer satisfaction.

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

AI-powered platform for automated UX validation and designer support

• Designed and led technical implementation of an enterprise-wide AI solution for automated UX review that improved design quality and significantly reduced manual review processes in teams
• Developed an automated UX validation tool as a Figma plugin and web application that generates test cases based on internal guidelines and reliably checks current designs for consistency and standard compliance
• Implemented an interactive designer chat based on RAG that answers questions about the current design and the company's UX guidelines, and designed the deployment architecture using containerized services
• Python, Azure OpenAI, PostgreSQL, REST API, Docker, OpenShift, Helm, CI/CD, Figma MCP, LLM, RAG, Prompt Engineering, GenAI, XAI, AI Architecture, AI Strategy

• Completed a job simulation involving reading web activity logs.
• Supported a client in a cybersecurity breach.
• Answered questions to identify suspicious user activity.

• Development of a central billing app for cloud costs at DB
• AWS
• Python
• AWS CDK
• RDS
• Spark (PySpark)
• Glue
• Lambda
• CI/CD (GitLab)
• React/Typescript
• data optimization
• Scrum

• Analyze system requirements and mapping concepts (ETL requirements) for data flows and transformation logic in the bank's DWH
• Analyze data in DB tables and views of the DWH using SQL (DB2)
• Independently define, create, and execute test cases in JIRA Xray (SIT)
• Write SQL queries in DB2 to verify data scenarios and mappings
• Create test plans for SAP FSDP and concurrent projects
• Conduct error and root cause analyses in coordination with business analysts, developers, test managers, and the infrastructure team
• Thoroughly document test results in JIRA Xray
• Coordinate between business analysis, development, DB infrastructure, business units, and external vendors

• Practice-oriented coaching on core aspects of data science
• Teaching advanced concepts in Python as well as automation (with Make and n8n) and ETL processes with Apache Airflow
• Weekly preparation and delivery of practice-oriented programming courses using real-world examples
• Promoting practical programming skills among participants through interactive exercises and individual support
• Developing didactic materials and adapting content to participants' skill levels
• Close collaboration with the team for continuous improvement of course quality and learning outcomes

• Led an international team of six developers in a Scrum environment
• Defined strategic goals for the project in coordination with stakeholders and the development team
• Prompt engineering for language models to improve the accuracy and relevance of generated responses
• Implemented LangChain components for a RAG chatbot to answer legal questions
• Technologies: GPT-4, LangChain, Python (Pandas, sklearn, streamlit), Docker, GitLab, ChromaDB

• Built Power BI dashboards and enabled data-driven strategies across digital platforms

• Engineered and automated a data pipeline using GitLab CI/CD for data ingestion, validation, and loading into a central database.
• Developed Python scripts for data validation and transformation, ensuring data quality and compliance with metadata standards.
• Managed the entire data lifecycle from file-based repositories to a structured SQL Server database.
• Worked in an interdisciplinary team to establish a central database for-omics data and ensure reproducibility of computational analyses.

• Credit risk
• Quantitative methods
• Development and validation of IRBA rating systems
• Analysis and monitoring of the credit portfolio
• Reporting
• Development and validation of models for risk provisioning (PWB)
• Support for internal and external audits