Oracle Database Experts in Nuremberg

Embedded Analytics & AI-assisted BI

Design and development of an integrated analytics solution based on ASP.NET Core, Power BI Embedded, and LLM services to provide context-based business information.

Development of an AI agent with Function/Tool Calling for the secure orchestration of REST APIs, SQL data sources, and technical services within defined business processes.

Building automated BI workflows including workspace management, deployment processes, and scheduled refresh via the Power BI REST API.

Implementation of secure service-to-service communication with Microsoft Entra ID and Service Principal, and integration into existing enterprise system landscapes.

Technologies: ASP.NET Core, C#/.NET, Power BI Embedded, Power BI REST API, LLM API, AI Agents, Function/Tool Calling, Entra ID

• Engaged within the Information and Security Management division for a Proof of Concept (PoC) project focused on developing a Client Security Portal.
• Managed project resources across the UK, India, and Germany.
• Architected and deployed the PoC solution leveraging a modern Java stack, Google Cloud Platform (GCP) with Kubernetes, and Active Directory (Entra ID) for authentication.
• Implemented OAuth 2.0 for authorization.
• Ensured DORA alignment according to Deutsche Bank security rules and regulatory preparation.

• Thorough process analysis to identify weaknesses and assess optimization potential

• Precise modeling of business processes using BPMN 2.0

• Creation of detailed requirements and functional specifications to document use cases

• Comprehensive gathering of existing company processes

• In-depth process analyses to uncover potentials

• Moderation and facilitation of workshops with subject matter experts and executives

• Taking on project management for selecting and implementing a new ETRM system environment

• Operational implementation and handling of the document flow between internal and external partners (such as engineering, contractors, project management, certification body, claim management)
• Formal review of documents in the document management system (thinkproject!)
• Setting up and further developing SharePoints in the early, dynamic development phase of projects in close cooperation with the project teams

• Consulting on functional topics and their feasibility with Zoho technologies
• Implementing solutions based on Zoho
• Integrating Zoho solutions with third-party systems
• Performing data migrations
• Training and support

• Developed KPI dashboards using Power BI and DAX for 4+ business units, improving reporting transparency and strategic decision support.
• Migrated enterprise finance data views into dbt models, implementing modular SQL transformations, version-controlled data pipelines, and automated documentation to create a scalable analytics layer.
• Built dimensional data models in Snowflake for enterprise finance data, enabling scalable forecasting and supporting executive decision-making.
• Designed end-to-end ETL/ELT pipelines using Snowflake and SAP HANA, integrating data from 3+ enterprise systems.
• Automated monthly reporting workflows using SQL and Power BI, delivering strong business impact by reducing manual effort by 80%.
• Collaborated with finance stakeholders to translate business requirements into analytical data models, supporting strategic decision-making cycles.
• Delivered ad-hoc financial reports using Power BI, reducing turnaround time by 60%.
• Implemented data validation logic in SQL, resolving 95% of recurring data quality issues.

• Extension of test software for functional testing of IO modules in WPF with MVVM
• Configuration and extension of a specialized WPF control from Nevron
• Connection to Siemens PLCs via Siemens OPC UA Client and Allen-Bradley/Rockwell PLCs via Codebix OPC UA Client
• Integration of various data sources via REST API and JSON
• Development of stored procedures, views, and triggers for PostgreSQL and SQL Server with ADO.NET and Entity Framework 6

• Acting as the program lead for digitally enabled services, overseeing projects like Transformation, remote scanning (WeScan), e-commerce, and OneGate (budget: ~€5M p.a.).
• Developed the transformation strategy and roadmap for a supply and demand platform on ServiceNow, driving harmonization and integration of legacy systems.
• Led cross-functional teams in designing and rolling out these digital business models on the ServiceNow backend platform.
• Enabled strategic decision-making by building Azure DevOps transparency structures and using Agile methods like PI Planning and WSJF prioritization.
• Served as the business demand manager and digital counterpart for CS CRM.
• Managed internal project organization, external partners, and organizational interfaces and dependencies with other departments.
• Executed RFPs and managed vendors according to contracts and internal requirements.
• Contributed to Project sucCeSs, Northstar, and was part of the RaaS Tiger Team and Spryker Customer Advisory Board.

• Incident handling
• Error analysis

• Web application for contract changes

• Micro frontend development from scratch through production with a Reactive Forms basis, Responsive Web Design, validation, multilingual support, accessibility, unit tests and component tests

• Technologies: Angular 19-20, Nx, Angular CLI, Native Federation, TypeScript, HTML, SASS, Tailwind CSS, Angular Material, Reactive Forms, RxJS, Signals, PDF-Make, ng-openapi-gen, i18n, JSON Server, REST, JWT, Jest, Playwright, IntelliJ, Git, CI/CD with GitLab, Cloud Foundry, Nginx; Scrum

• Analysis and inventory of a system consisting of 2 control units
• Creation and derivation of the static software architecture
• Optimization and standardization of structures for model-based control
• Creation of the dynamic software architecture
• Development of improvement proposals in workshops with the customer

• Tribe Home, Product Area 4 - Customer in Life, Squad Cybertron.
• Analysis, design, development, and testing of new requirements for Optimmo, mortgage financing software.
• Analysis, design, development, and testing of the JEE application MWS kredit-baufi.
• Analysis, design, development, and testing of the Wicket Optimmo application.
• Analysis, design, development, and testing of kredit-baufi batch programs.
• Migration of kredit-baufi batches to RHEL9.
• CiL SCS consumer pacts with Finagle.
• CiL SCS touch point architecture integration.
• Team size: 10.
• Tools / Frameworks: OpenJDK Java 17, Kotlin 1.6.0, Azure, Jenkins, Stash, JEE, GitLab, JIRA, Confluence, git, Spring 6.0, Spring Cloud, Spring Data, Hibernate, JPA, JMS, Kafka, Oracle, PL/SQL, Red Hat Enterprise Linux (RHEL), Maven, REST, JBoss, IntelliJ IDEA, Wicket 9 and 10, Istio.

• enhancements for the City Education Office in warehouse and inventory management
• revision of the picking lists including printing of images
• implementation of the output of reservation slips
• creation of a delivery routing plan
• representing schools as storage locations to track which school has which equipment at any time

• IoT platform to connect, transform and get actionable results
• Built a microservice observability solution to enhance developer and operations insights
• Did advanced performance optimizations in .NET code, DB and time series
• Provided architectural consultation for developer teams on performance, scalability, reliability and code quality
• Evaluated and built PoCs for new technologies including time series DBs and messaging platforms
• Technologies: C#/F#/Rust, InfluxDB, ClickHouse, Prometheus, Grafana, k6, RabbitMQ, EMQX, Docker, Kubernetes, Azure AKS