PL/SQL Experts in Frankfurt

• Holistic responsibility for modernizing and expanding federal networks and upgrading critical data center and telecom infrastructure in the high-security agency environment of BDBOS
• Planning and management of the expansion of national BOS network infrastructure in the VS-NfD/KRITIS environment with technical decision authority at the architecture and component level (Cisco, Layer 2/3, WAN redundancy)
• Planning, tendering (EVB-IT/UVgO) and oversight of the upgrade of security-critical telecom infrastructure for emergency call 110/112 (ACD)
• Capacity planning, rack integration, structured cabling, power supply, cooling concept (CRAC/In-Row) and DCIM monitoring for data center expansion
• Building the IT department from scratch: structures, governance, processes, team recruiting, vendor selection and long-term IT strategy
• Planning and managing infrastructure and application migrations: migration strategies, batch planning, hypercare stabilization and rollback concepts
• Creating vendor-neutral specifications (telecom systems, signature solutions) according to EVB-IT and UVgO; contract award and vendor management
• Setting up a secure IT environment according to BSI basic protection, ISO 27001 and VS-NfD; developing IT security concepts and CMDB analyses
• Hands-on program leadership: decision papers for management and steering committees, risk management, reporting and change request control

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

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

• Hands-on solution architect
• Digital product development - SaaS
• Strategic consulting on software architecture, cloud migration, and DevOps processes
• Coaching SE developers and IT architects

• Introduction of methods for developing and automated deployment of cloud-native software and machine learning applications in OpenShift clusters
• Development of various programs in Python
• Technologies: Kubernetes, OpenShift, Kustomize, ArgoCD, Tekton, Docker, PodMan, Airflow, IntelliJ, PyCharm, Git, Bitbucket, Jira, Confluence, Python

• Participated in project planning and solution design discussions to align business objectives with technical requirements.
• Conducted user requirements gathering, performed unit testing, and supported Conference Room Pilots (CRP) to validate system functionality.
• Implemented Oracle HCM Fusion Cloud modules, ensuring smooth deployment and alignment with client HR processes.
• Designed and developed Oracle OTBI and BI Publisher reports, dashboards, alerts, notifications, page integrations, and autocomplete rules to support business intelligence and automation.
• Worked on HCM data extracts and data migration using HCM Data Loader (HDL) and Spreadsheet Loader for efficient data handling and transformation.
• Managed and maintained project plans, developed project calendars, created change requests (CRs), and coordinated closely with consultants and clients for timely follow-ups.
• Currently acquiring hands-on experience in Oracle Policy Automation and Oracle Redwood UI to expand solution expertise.

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

• General CTO responsibilities (architectural design, operational setup, external runtime product evaluation, investor buy-in, regulatory compliance).
• Software development oversight (implementation on deep-dive-in) plus workflow design.
• Product co-ownership.
• Tech/tools/frameworks: proprietary software (Java, JavaScript), Kubernetes, Postgres, MiniIO, Ollama (internal), several xAI API (external), OpenTofu (Terraform), Keycloak, Kafka, Prometheus, ELK Stack, GitHub, GitHub Workflows, Argo CD, ISO 27001, BSI-ISM, EU AI Act.

• Testing the SekIDP and related components
• Test design, execution and automation, microservices, GitHub Enterprise, Eclipse, Katalon Test Platform, API Testing, Confluence 8, JIRA/Xray, Draw.io, Swagger/OpenAPI, Postman, Docker, Kubernetes, Podman, PuTTY, E-Health, Telematik, Gematik standards, EPA, E-Rezept, sektoraler IDP, encryption, XaDES, PaDES, DICOM, HL7, FHIR, IHE, ICD, SSO, SAML/Shibboleth, OAuth, smartcards, JWT, two factor authentication Android and iOS, Wireshark, BrowserStack, Cypress, gRPC, REST, SOAP, WS-Security, Linux Shell, PowerShell, SSH/SSL, Java, Kotlin, Cordova, Gradle, Groovy, Python, TypeScript

• Participate in quality workshops for requirements gathering and fit/gap analysis
• Demonstrated different QMS modules/processes with focus on customer requirements
• Design and implementation of cloud based quality system reducing manual efforts for the client
• Collaboration with cross functional teams to define and document system requirements
• Understanding the existing business process flow and suggesting improvements over moving to new quality systems
• Managed the implementation of a data migration strategy from legacy system to cloud
• Providing solution walkthrough to the business users
• Involved in integration of quality system with different third party systems
• Preparing weekly status report and presenting the same to business users and project stakeholders

• Highly successful role as lead data analytics expert at a US consulting startup.
• Managed stakeholder expectations by ensuring team delivery velocity using Agile and Lean practices.
• Trained and assembled international offshore data science teams of DevOps engineers, BI developers, and technical support specialists.
• As Sparecodes' data analytics experts, we improved our clients’ business outcomes through requirements management, dashboard and report development, migration, automation, and production support using IBM Cognos, AWS, SAP, Oracle, Teradata, CRM, ERP, Confluence, and Microsoft.
• Provided effective coaching and mentoring for international, multicultural teams in a remote environment, covering new tools and techniques, Agile best practices, internal and external communication, and presentation skills.
• Coordinated technical processes efficiently, including managing and implementing project changes and control processes.
• Promoted strong team engagement and supported employees’ career development, including business change management through coaching.
• Enhanced project status reports by providing insights into team productivity, predictability, and backlog burn-down, leading to improved project outcomes.
• Successfully led the coordination and implementation of software solutions for clients in mechanical engineering, including automation system integration and customization to meet client needs.

• Automation of the (Linux-based) web landscape maintenance.
• Use of SALT, SuseManager, Wildfly, scripting and Kubernetes.
• DevOps tasks and use of Jira.
• Management of "special" applications as well as creating and helping with concepts.
• Focus on security, maintainability, integration and tooling/integration.

• Development and implementation of backend components with PL/SQL and Oracle Forms 12c. Adaptation and further development of the policy administration system. Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.
• The project takes place in the technical environment of BIPRO, SQL databases and Oracle Forms applications. The assigned work includes backend development and technical further development in the above project with the following tasks:
• Development and implementation of backend components with PL/SQL and Oracle Forms 12c to technically map the business processes and ensure a stable and efficient system architecture
• Adaptation and further development of the policy administration system to ensure system functionality in line with the requirements of the new broker communication program
• Analysis of the existing system to identify and avoid errors and technical problems during implementation, in order to enable a smooth transition to the new system
• Carrying out patching and further development of existing Oracle and Oracle Forms applications to ensure compatibility and security of the systems in use
• Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.

Label: PL/SQL, Java, Oracle RDBMS and Oracle Forms

• Newly developed an ASP.NET web application for mortgage financing
• Maintained and enhanced it both functionally and technically (expanded to other loan types, connected to various services, developed custom web services)
• Analyzed business requirements in close cooperation with business units
• Created IT concepts and technical documentation
• Developed backend and frontend
• Designed and implemented automated build, deployment, and testing processes
• Created scripts to automatically generate data access layers (C# classes and SQL scripts) and integrated them into build and deployment processes
• Languages: C#, PowerShell, JavaScript
• Technologies: ASP.NET, Windows Forms, XML Web Services, Windows Services, MS SQL Server, Entity Framework, unit testing, automated build, deployment, and testing processes
• Tools: Visual Studio 2005–2015, Team Foundation Server, DevExpress, Rational ClearCase, Rational ClearQuest, CruiseControl.net