Oracle SQL Developer Experts in Frankfurt

• 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

• 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

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

Developed a digitalization strategy Analyzed legacy systems and designed a new IT landscape

• Gathered current work structures and processes
• Identified optimization opportunities
• Developed a tool landscape to support business processes
• Created a request for proposal
• Defined epics and user stories
• Modeled processes

Technologies/Methods: Confluence, MSTeams, MindManager, PlantUML, JIRA

• Business analysis of payments for the introduction of Wero EPI in Germany.
• Analysis and optimization of merchant processes in the context of acquiring and issuing.
• Analysis of interfaces for instant payments.
• Analysis of SCT-Inst processes, settlement mechanisms and reporting processes.
• Identification and clarification of gaps in merchant processes.
• Analysis and documentation of clearing and settlement processes.
• OSPlus process analysis and documentation.
• Coordination and alignment with scheme management as well as various payment service providers and financial institutions on merchant processes.
• Preparation and follow-up as well as active participation in EPI meetings on technical coordination and regulatory topics in payments, including content familiarization and prioritization.
• Preparation and documentation of project and steering committees in the EPI environment.
• Creation of status reports for the subproject.
• Maintenance and structuring of Confluence pages for project documentation.
• Coordination and alignment with the issuing teams on individual customer processes as well as aligning with bank processes and acquirer processes in the Wero environment.
• Communication with payment service providers regarding merchant and bank processes in the Wero environment.
• Organizational support for project management in special tasks in the EPI and Wero environment.
• Digital filing and documentation in Confluence and Microsoft Teams.
• Planning, implementation and tracking of work packages and steps.
• Quality assurance and project control.
• Consulting on IT strategy, IT architecture and interface management in the EPI and Wero environment.
• Technical environment: Jira, Confluence, XML, JSON, MS Office (Word, Excel, Teams, PowerPoint), SharePoint, Draw.io, Innovator, 3rd-level support, ITIL, creation and updating of software documentation, interface management, OSPlus, Scrum, KYC, payment, European Payments Initiative (EPI), Wero, Microsoft Loop, Instant Payments, SCT-Inst.

• Close collaboration with development teams to ensure alignment with project goals
• Assessment of in-scope assets, requirements definition and support of the public tender process up to vendor selection
• Creation and maintenance of UML sequence diagrams to document system interactions
• Intensive use of Agile/Scrum methodology and the Spotify model
• Development and implementation of cutover and rehearsal plans together with the application managers

• 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

• 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

• Supported implementation and operation of a portal used online and offline in customer-facing vehicles
• Automated processes by introducing CI/CD pipelines
• Provided enablement and methodological guidance for adopting software engineering best practices
• System environment: NestJS, Node.js, npm, AWS, Docker, Docker Swarm, GitLab CI, WhiteSource, PostgreSQL, Prometheus, Grafana, OpenSearch, REST API

• Ad-hoc support in settlement for derivatives

• Settlement of ETD (futures & options), OTC (DTGs), give-up/take-up etc.

• Position and account reconciliation

• Coordination with trading, Eurex, UBS AG and asset management

• New setup of classes for options and series

• Support of the Securities & Operations unit for EMIR REFIT

• Advisory for project management of EMIR REFIT and support for implementation

• Communication and coordination with the software vendor to clarify business issues

• Main responsibility for creating the test concept for go-live on 29.04.2024 (Phase I) and bug fixes/cleanup actions (Phase II)

• Active support during go-live: creation of transaction, valuation and collateral reports; migration of the position report; defect management and bug fixing

• Inventory of cleanup Phase II

• Business test case creation for EMIR REFIT functionalities and coordination with IT teams and the business unit

• Creation and updating of training documents and work instructions for OBS modules WPS and GDH

• Gather basic requirements
• Plan the project
• Create RfP and tender
• Interview five vendors
• Review proposals and contracts
• Create a vendor shortlist based on hard facts (criteria catalog, price, licenses) and soft facts (quality of documents, software user experience, reputation and references)
• Support the initiation and RfP & vendor selection phases
• Plan the implementation & go-live and hypercare phases for 2025

• Design, architecture & development/programming of ETL/ELT data pipelines, DWH, BI solution
• Technical project lead, POC – proof-of-concept creation
• Liaison between business units and technical teams
• Azure DevOps Boards & Jira
• Data modeling & data engineering – data warehouse & data mart
• Azure (Data Factory, Azure SQL, Azure DevOps CI/CD, Azure Data Lake V2, Business Central REST API, OData API, OAuth2 tokens)
• SharePoint lists & API for ADF, Firebird DB, Postgres DB, DB2
• Power BI (Power Query), DAX, Excel PBI add-on, GIS data
• Automated ETL process monitoring/logging, performance monitoring, error monitoring – capturing & resolution
• Index performance tuning & statistics monitoring, Transact-SQL
• Data security – MFA (multi-factor authentication) & OAuth2, MS Graph, Azure networks & firewalls, gateways, roles, user groups – with read/write permissions
• Sources – Vario Bill, Camunda, Radius, Geo Database, OTRS, PAST, MS Dynamics Business Central, Azure Blob Data Lake, SharePoint lists

• Design and development of modern cloud DWH & data platforms
• Data Vault automation
• Implementation of ELT and CI/CD processes
• Requirements analysis and data modeling
• Building an automated cloud data platform as a reference architecture for financial risk controlling (Snowflake, Data Vault, DBT, Python, GitHub) 2024-10-01 – 2025-06-30, Zurich
• DWH further development, operations and cloud migration (Data Vault, DBT, SAP Data Services, Alteryx, SQL Server, Azure Synapse) 2023-03-01 – 2025-06-30, Frankfurt
• Implementation of a global cloud data platform (Data Vault, WhereScape, Snowflake, AWS, Scrum) 2021-04-01 – 2023-12-31, Cologne
• Proof of concept for a global cloud data platform (Data Vault, Snowflake, Synapse, WhereScape, Azure, Scrum) 2022-04-01 – 2022-07-31, Bonn
• Implementation of a cloud data platform (Data Vault, Snowflake, WhereScape, AWS) 2021-07-01 – 2022-04-30, Karlsruhe
• Big data integration of all source systems related to the ITSM process (Data Vault, Snowflake, WhereScape, AWS, Scrum) 2021-01-01 – 2021-05-31, Prague
• Development and operation of a global self-service BI platform to display around 150 corporate KPIs (Data Vault, WhereScape, Postgres, Jenkins, Talend, AWS, Scrum) 2018-11-01 – 2020-12-31, Frankfurt
• Implementation of a DWH for price management and capacity forecasting in long-distance passenger transport (SAP BODS, SQL Server, AWS) 2017-10-01 – 2018-11-30, Frankfurt
• Introduction of SAP BODS and migration of the existing DWH (SAP, BODS, HANA, Oracle, Cognos) 2017-05-01 – 2017-10-31, Rastatt