Archiwa: projects - BRIGHTCODE - Michał Żarnecki Portfolio

AI-based company credit rating and financial condition report generator

Posted on 23 May 2025 in projects

In this project I designed pipeline that converts raw financial statements and market data into a fully formatted credit-rating dossier in less than one minute. The application produces a narrative assessment, multi-year ratio analysis, and a suite of visualisations each generated dynamically at runtime.

Functional Overview

Data acquisition – The service ingests three years of balance-sheet, income-statement, and cash-flow data together with current market quotations.
Analytical engine – A carefully curated Expert-Investor system prompt guides OpenAI o3 and Claude 3.7 sonet to draft commentary in German, embedding all referenced figures verbatim for improved traceability.
Credit scoring – Liquidity, solvency, and profitability ratios are computed and weighted to deliver an internal credit rating.
Visual presentation – Matplotlib/Seaborn charts (trend lines, ratio heat maps) are embedded directly into the final PDF.

Business Value

Automated, audit-ready financial commentary shortens the traditional analyst workflow and enables decision-makers without a finance background to evaluate corporate health immediately.

For more technical details and guidance how to approach such topic please refer also to my article “Building Financial Reports with FinGPT and Claude 3.7 Sonnet” (Medium, May 2025).

AI Agents, FinGPT, langchain

[Top]

System for detecting similar companies and competitors

Posted on 1 December 2024 in projects

System for identification of similar companies and competitors based on company description text, texts from company websites, coordinates, industry tags, revenue and size of employment.
System is based on relational database queries that include logistic regression model coefficient trained on large dataset related to German companies.

Logistic regression, PostgreSQL, text similarity

[Top]

System for official industry codes classification

Posted on 21 November 2024 in projects

Solution for multi-class classification of unstructured texts containing company descriptions categorized into over 1800 classes (WZ 2008), using Python libraries, large language models (LLMs) and the Retrieval Augmented Generation (RAG) technique.
This project was evolving since 2021 together with artificial inteligence solutions and initially approached using a Random Forest Classifier, to be later replaced with zero-shot transformer based solution and finally solved with a solution based on RAG and LLMs, yielding significantly improved results.
More details can be found in article

Classification, Llama3, LLM, NLP, Python

[Top]

AI chatbot for analysing companies source documents

Posted on 26 May 2024 in projects

https://chat.companyhouse.de/

AI-based chatbot for retrieving reliable, up to date and precise information about companies.
Chatbot is based on streamlit framework and uses vector database based on postgres pg_vector extension to store and access trade register documents.
Application is using large language model (LLM) Llama3 together with retrieval augmented generation (RAG) approach which allows to ask and get response to any question related company and managers history as well as financial condition and important changes.
Together with response also source documents are listed making this approach reliable business intelligence tool.

Responsibilities:

build application prototype
implement application code parts
implement authentication mechanism
specify and coordinate works related to building chatbot interactions
specify and coordinate works related to sychronizing in real time source documents and make them accessible for LLM
measure answers quality

langchain, Llama3, LLM, Python, PyTorch, RAG, Stremlit, Vector DB

[Top]

Named Entity Recognition system for parsing documents

Posted on 12 December 2023 in projects

The goal of this project was to prepare NER-based system parse information from semi-structured documents.

NER, Spacy

[Top]

Self-driving vehicle based on tensorflow CNN and RasberryPi

Posted on 26 January 2023 in projects

Responsibilities:
– prepare laboratories for students related to computing vision recognition and training autonomus vehicle using convolutional neural network and tensorflow library
– assemble vehicles using Raspberry Pi 4 Model B, motors and other parts
– configure environment for model training and run model on Raspbian OS
– implement module for object detection

CNN, Machine Learning, OpenCV, Python, tensorflow

[Top]

System to collect networking and finance data about German companies

Posted on 1 July 2020 in projects

Web application to collect networking and finance data about German companies.
companyhouse.de

Responsibilities:

Implementing data mining tools and parsers using deterministic algorithms and deep learning models
creating fast and efficient search engine
carrying out integration with external platforms, APIs, web-services
working with Selenium, automation of acceptance, integration, functional and unit tests, TDD
conducting data analysis using Python, R
server environment setup and configuration

AWS, Cassandra, Data mining, data science, DBMS, Docker, Jenkins, Machine Learning, MongoDb, Neo4j, Neural networks, Nginx, NLP, NumPy, Pandas, PHP, regular expression, ScikitLearn, Server administration, Spacy, text mining, TextBlob, Ubuntu, Yii2