SQL 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 contextual business information.

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

Build-up of 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, as well as 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

• Led global automation projects in Hybrid Cloud, focusing on process standardization and service delivery optimization across international teams.
• Managed the product roadmap, prioritized backlogs, and aligned business goals with technical inputs using Jira.
• Fostered cross-functional collaboration to define project objectives and ensure alignment with strategic goals across departments.
• Defined and documented user stories and acceptance criteria with stakeholders.

• Spearheaded the integration of a custom Transformer-based encoder into the AFFGANwriting pipeline, replacing the legacy VGG19 architecture to capture richer, high-fidelity writer-style representations.
• Boosted user-study pick-rates by 40%, demonstrating a significant leap in the perceptual quality and realism of the generated handwriting compared to the baseline model.
• Enhanced OCR performance by 20% by implementing a teacher-student framework that leveraged a TrOCR benchmark model for auxiliary training alignment

• Analysis of the role of marriage as an informal insurance in Germany using econometric methods (supervisor: Prof. Dr. Harald Tauchmann).
• Prepared and cleaned multiple panel datasets and extracted relevant variables to create a final panel dataset with over 36,000 observations (2006–2020, SOEP).
• Designed an IV model in Stata to examine the causal link between couple separation and health shocks (mental/physical).
• Conducted robustness checks to ensure stability and validity of the results.

• Designed a target operating model (including strategic mid-term planning and operational staffing) for the restructuring and capacity management process of the product workstreams to increase development efficiency, boost employee retention and improve profitability
• Integrated targeted incentives such as budget targets, contribution margin accounting and incentive schemes into the operating model

• Collected, analysed, and interpreted HR data from multiple systems
• Conducted ad-hoc people data analyses for stakeholders
• Supported Employee Listening and ensured actionable survey insights
• Built intuitive dashboards and visualizations in SuccessFactors, PowerBI, and Qualtrics
• Produced regular reports and dashboards on key HR metrics
• Contributed to people analytics projects as a junior team member
• Collaborated with HR Tech and Data teams to improve data quality
• Ensured ethical and governed data use with Legal, Data Privacy, Labour Relations and Works Council

• Helped to design the AWS infrastructure, integrated services and backend architecture for use cases of an on-premise solution and partial migrations to AWS with fast response times
• Implemented automated AWS integration test suites
• Implemented mission-critical components and delivered them before the deadline in a production-ready state with operation and monitoring concepts
• This 2-month subproject was about building a data-intense pipeline (5 TB) to be enriched continuously with data
• Designed and implemented reusable AWS CDK constructs to be used across the company’s teams to enable faster onboarding with AWS
• Coached on AWS topics, distributed software patterns, security, domain-driven design, agile collaboration and documentation to improve performance and collaboration
• Technologies: AWS, GitHub Actions, ETL, monitoring, operations, TypeScript, Python, AWS CDK, CloudFormation, Java, Docker, AWS ECS, AWS Lambda, serverless, Jenkins, DevOps principles

• 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

• Development of strategies, processes and system requirements to further develop the lead and campaign streams of a Salesforce system for the subsystems Sales Cloud, Marketing Cloud and Analytics Cloud
• Gathering and creation of marketing strategy concepts for direct sales, focusing on lead generation for new and existing customers
• Analysis and optimization of existing and new contact points
• Derivation of system requirements and user tests for new developments
• Establishment of a requirements and implementation process for business needs at the interface between CRM strategy and marketing system operations
• Facilitation of ideation workshops with the project's stakeholders
• Mediation between business and technical project stakeholders
• Analysis and post-documentation of existing marketing strategies and the system functions already created for them
• Analysis of target groups and pre-system data quality as a foundation for new CRM strategies
• Consultation on content and asset strategy for marketing campaigns
• Definition of KPIs and other performance criteria for the system and CRM strategy

• Integrated complex AI-based energy system models into the frontend framework, enabling the visualization of insights for 6+ key clients and maximizing energy utilization.
• Maximized energy efficiency and utilization by architecting the seamless data flow between AI models and the user interface for rapid, actionable reporting.

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

• Technology update
• Microsoft Azure certification