Stephan F.

NLP/LLM Chatbot

Wiesbaden, Germany

Experience

Oct 2024 - Apr 2025
7 months

NLP/LLM Chatbot

Insurance

  • Conceptualized and implemented an LLM-based case assistant (file assistant).
  • Selected and evaluated RAG methods; designed hybrid RAG information retrieval using Elasticsearch + embeddings.
  • Built ingestion pipelines for multiple document formats; analyzed and aligned with source systems.
  • Developed a Streamlit-based chatbot GUI and performed NLP-based causal chain analysis for regress cases.
  • Evaluated analytical LLM methods; deployed via Jenkins to OpenStage.
  • Technologies used: Streamlit, Elasticsearch/OpenSearch, Hugging Face, Python, OpenAI API, Jenkins
Mar 2024 - Dec 2025
1 year 10 months
Wiesbaden, Germany

Consultant

AWS PoC / Content Analytics

  • Evaluated dashboard approaches and built a prototype dashboard in Streamlit using Google Search data and HTTP logs stored in AWS S3/Athena.
  • Integrated web search and marketing/blog data; designed pipelines for image knowledge extraction and evaluation (LMM / Graph & Vector RAG).
  • Built an AWS Amplify-based service integrating AI-as-a-Service (Mistral, Replicate); data persisted in Neo4j with text-to-graph extraction.
  • Implemented Graph RAG with Neo4j, and deployed with AWS CDK and GitLab CI/CD.
  • Technologies used: AWS Amplify, S3, Athena, Neo4j, Pandas, Streamlit, Mistral API, Replicate API, GitLab CI/CD, AWS CDK
Jun 2023 - Jun 2024
1 year 1 month

Knowledge Graph / NLP / AI Engineer

Federal Criminal Police Office

  • Worked in a security-cleared (SÜ2) and BSI-compliant environment.
  • Explored and advised on Knowledge Graph use; designed & implemented pipelines with Neo4j.
  • Raw data extraction from SQL dumps and mapping to entities; graph data model design.
  • Advanced NLP: NER, topic & event extraction, language detection; extraction of complex relations using POLE (Persons, Objects, Locations, Events).
  • Applied graph algorithms (incoming degree, community detection – Louvain/triangle count) to identify relevant entities and relationships.
  • Integrated GeoIP/domain extraction and URL evaluation; implemented streaming ingestion (Kafka).
  • Built an LLM/Chat Streamlit app deployed on Cloud Foundry on Kubernetes; integrated into BSI-compliant environment.
  • Technologies used: Neo4j, Pandas, Polars, spaCy, OpenNLP, Hugging Face, Kafka, Cloud Foundry, Kubernetes, GitLab CI/CD, Streamlit
May 2022 - Nov 2022
7 months

Corporate Web Portal Engineer

Siemens

  • Designed and implemented daily data pipelines using AWS Glue/PySpark and Athena; monitoring via CloudWatch.
  • Built a GraphQL Apollo Server in AWS Lambda; integrated content items from OpenSearch and usage data from Adobe warehouse.
  • Added an app for readability scoring; integrated an AWS SageMaker endpoint for text classification.
  • Conducted feasibility studies, concept work, and stakeholder alignment; evaluated Athena Query Federation; managed costs and optimization.
  • Technologies used: AWS Glue, PySpark, Athena, CloudWatch, Lambda, DynamoDB, SageMaker, KMS/SSM, EC2 (tests), GraphQL/Apollo, OpenSearch/Elasticsearch, Terraform
Mar 2021 - Mar 2022
1 year 1 month

Data Lake Engineer

BMW Connected Vehicle

  • Led development of large-scale AWS-based data pipelines for multiple datasets (Glue/PySpark, Athena, S3, Lambda, IAM, SQS/SNS, DynamoDB/DAX, Elasticsearch).
  • Processed up to 30+ billion rows; implemented automated restart & recovery procedures and unit tests.
  • Architected daily/historic/housekeeping pipelines; performed production problem analysis and internal advisory.
  • Performed cost analysis, derived measures, implemented cost savings, and monitored reductions.
  • Refactored complex vehicle master data (7 datasets, ~35 tables; mid-level business logic; >1B rows/day).
  • Ran feasibility analyses, requirements refinement, and implementation concepts; authored documentation.
  • Technologies used: AWS Glue, PySpark, Athena, S3, CloudWatch, Lambda, SSM, KMS, IAM, SQS/SNS, Elasticsearch, DynamoDB/DAX, EC2 (tests), Terraform
Jan 2020 - Dec 2025
6 years

Independent Developer

Generative AI Blog & AWS Serverless Experiments

  • Built multiple serverless stacks in AWS using CDK and GitLab CI/CD.
  • Explored LLMs/NLP; experiments in automated image analysis & generation.
  • Implemented AI data pipelines for knowledge extraction and enrichment; built chatbots combining image analysis with knowledge graph context.
  • Developed iOS exploratory apps with Swift/SwiftUI and AWS back ends.
  • Technologies used: AWS CDK, AppSync, Amplify, Lambda, Cognito, API Gateway, Route 53, Glue, Neptune, SageMaker, Bedrock, S3, OpenAI, Mistral, Replicate, spaCy, Swift/SwiftUI, DynamoDB
Jul 2017 - Aug 2020
3 years 2 months

Data Warehouse Engineer

Deutsche Bahn Vertrieb

  • Designed & implemented data model for passenger revenue (ticket sales and other services) considering AWS specifics (sort key, data distribution).
  • Built multi-stage Data Warehouse architecture: two-stage staging, Core (persistent business model), Analytics (optimized for SAP BO), and Output for file interfaces.
  • Designed ETL/Data Pipelines: daily, historic reprocessing, housekeeping; Lambda/S3 events for job control; reload from raw data; processed ~1M rows/day.
  • Implemented jobs with AWS Batch (Python, Docker) using SSM Parameter Store; integrated DynamoDB; limited Red Hat OpenShift on AWS.
  • Managed build pipelines via GitLab CI/CD for >15 projects (dynamic parameterization, Docker images, build scripts, Python merge/deploy).
  • Conducted performance analysis and workshops with AWS Support; optimized Redshift WLM; ensured operations stability with weekly coordination & troubleshooting.
  • Technologies used: AWS Redshift, Lambda, S3, Batch, Docker, DynamoDB, Python, Pandas, SAP BO, GitLab CI/CD, Flyway
Aug 2016 - Jun 2017
11 months

Data Engineer

Opel/GM

  • Designed data model to compute inbound logistics costs based on freight rates, goods receipts, and master data.
  • Calculated inbound costs per produced vehicle and per transport/shipment/material number; extensive analyses with SQL and R to derive business rules and error analysis.
  • Acted across roles as Data Analyst, Business Analyst, and Data Engineer; coordinated interfaces and processes with logistics, network planning, and finance.
  • Produced IT concept and handed over solution to the business unit for operational use.
  • Technologies used: MS SQL Server, Transact-SQL, R, PowerBI/Excel
Apr 2016 - Jun 2016
3 months

Functional Data Analyst

BMW

  • Analyzed materials control and logistics planning; prioritized with stakeholders; investigated the SAP–DWH interface.
  • Investigated Teradata SQL, ETL modules, views, and data models across source, inbound (SAP→DWH), and DWH layers; proposed solutions and documented results.
  • Technologies used: Teradata SQL, ETL analysis, SAP DWH
Apr 2016 - Jun 2016
3 months

Production Data / Big Data Analyst

BMW

  • Authored interface specifications and conducted SQL-based data analysis; captured and analyzed requirements; documented & modeled the solution.
  • Created the IT concept (architecture, interfaces, operations); supported tool selection for change-data-capture.
  • Technologies used: Hadoop/Hive, GoldenGate/Sqoop, Spark, Scala
Jan 2016 - Dec 2025
10 years

Side Project Developer

Social VR Prototype

  • Prototyped collaborative VR space with messaging, user management, and real-time constraints; explored scaling and availability; visual concept and 3D modeling.
  • Technologies used: Akka, Scala, C#, Unity (VR GUI), Blender, WebRTC
Jan 2013 - Dec 2016
4 years

BI/Analytics Consultant

BMW

  • Led multiple sub-projects including Strategic Reporting, Time Tracking, Tableau/Teradata Introduction, Warranty Cost Controlling, Special Equipment Planning, and BI in Quality Assurance.
  • Strategic Reporting: coordinated go-live readiness & operations enablement; worked with SAP BW.
  • Time Tracking: managed go-live readiness and test management; authored operating manual.
  • Tableau/Teradata Introduction: introduced BI/DWH environment; architecture analysis; coordinated testing and code reviews.
  • Warranty Cost Controlling: analyzed processes; delivered prototypes in QlikView, SPSS Modeler, Java EJB.
  • Special Equipment Planning: produced high-level and functional concepts; process modeling.
  • BI in Quality Assurance: built UI and analytical requirements in QlikView 11 with VBScript.
  • Technologies used: SAP BW, Java/EJB, Oracle PL/SQL, Teradata, Tableau, QlikView, Informatica, SPSS Modeler, UML, VBScript
Jan 2012 - Dec 2025
14 years
Hybrid

Founder & Lead Engineer

Saganode

  • Designed and built a hybrid AI storytelling/world-building platform combining knowledge graphs, LLMs, and custom entropy-shaping heuristics.
  • Implements multi-layer graph spaces and Graph RAG; integrates generative services for text, image, and music; React-based graph explorer.
  • Security & deployment with AWS AppSync/Amplify back ends, REST/GraphQL endpoints, CI/CD, AWS CDK, Cognito/IAM.
  • Technologies used: Neo4j, Qdrant, Python, React, GraphQL, AWS AppSync/Amplify, AWS CDK
Jan 2012 - Dec 2020
9 years

Prototype Developer

Obylo

  • Explored graph database approaches and semantic BI on Neo4j; built ETL for graph ingestion.
  • Developed social VR experiments with Unity/Blender using Akka/C#; built search and recommendation components.
  • Technologies used: Neo4j, Scala, Play Framework, Akka, HTML/JavaScript, Unity/Blender
Jan 2009 - Dec 2012
4 years

ERP/DWH Migration & Finance Processes Consultant

Deutsche Telekom

  • Analyzed impacts of the One.ERP Integration on DWH-T systems; mapped inbound/outbound data flows across SAP and BW landscapes.
  • Assessed core finance processes: revenue processing, month-end close, dunning/receivables, logistics, sub-ledgers, billing/invoicing.
  • Prepared knowledge materials on Controlling, Treasury, Accounting, IFRS/HGB differences; clarified KPIs (OCF, ROCE, CapEx, EBITDA).
  • Technologies used: SAP BW, SAP ERP, Oracle, DWH-T, ConBW/IKOS
Jan 2008 - Dec 2011
4 years

Senior Consultant

Deloitte

  • Group-level management reporting: high-level and functional concepts; requirements alignment; project management.
  • Advisory engagements for Finanzinformatik, LBB, IKB on reporting and BI flows supporting Controlling and Treasury; OSPlus migrations and data integration.
  • Designed cash-flow prototypes and closing process prototypes; entrepreneurial initiative Ask&Bid business plan development.
  • Technologies used: SAP BW, Oracle, QlikView, OSPlus/DB2, Java, Excel/R
Jan 2008 - Dec 2009
2 years

BI/DWH Architecture & Reporting Consultant

NordLB

  • Consulting across BI/DWH architecture and reporting for banking functions with emphasis on Controlling and risk-related reporting.
  • Technologies used: SAP BW, Oracle, QlikView
Jan 2001 - Dec 2008
8 years

Independent/Freelance

  • Projects across banking, media, and telecom; roles in project management, software engineering, and product management.
Jan 1996 - Dec 2001
6 years

Co-founder & Manager

Scopas Medien AG / FunPage

  • Co-founded and managed agency operations; production planning; delivered multiple client projects; software & multimedia engineering.
Jan 1992 - Dec 1997
6 years

Student

Diploma in Business Informatics (FH), University of Applied Sciences Furtwangen (semester in Leicester, UK)

Jan 1988 - Dec 1991
4 years

Student

Abitur (German A-levels), Werner Heisenberg School, Rüsselsheim

Summary

Consultant and engineer with 20+ years in data engineering, AI/LLM integration, and cloud architectures.

Specialized in scalable data pipelines, knowledge graphs, and retrieval-augmented generation (RAG).

Deep background in NLP/LLM engineering, ontology integration, semantic enrichment, and graph algorithms.

Track record across automotive, finance, telecom, public sector, and law enforcement.

Languages

German
Native
English
Advanced

Education

Oct 1992 - Jun 1997

University of Applied Sciences Furtwangen

Diploma (FH) · Business Informatics · Germany

Oct 1988 - Jun 1991

Werner Heisenberg School

High School Diploma · Germany

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions