My Analysis and pre-build analytical model

Fully Functioned open-source models build in python with the ability to read your own data and make predictions

Mobirise Website Builder

LLM pipeline

LLM SQL Optimization Case Study

At Upwork, I designed and implemented a project leveraging LLMs to analyze 4,000+ SQL files for optimization. The system evaluated each query based on runtime cost, data scanned, and Snowflake credits consumed—then generated optimized alternatives using PROM. This initiative now saves the company six figures monthly and is used as a foundation for broader cost management and engineering performance monitoring.

Custom Image Recognition Model

It will allow you based on your picture database (preferably 500-1000 images per object) create a new image with the fully recognized object and its description. There is a potential for video object recognition.
1st --> download python workbook

Mobirise Website Builder

KNN Fruit Classification Model

A customizable model helps identify a class of an object (in the example files used different fruits) based on dimensions and colors. Could be used for various fraud detection cases.
1st --> download csv file for data 
2nd --> use jupyter notebook to run python code 

Car price model

Car Price prediction Model and Data Wrangler for missed data optimization 

Here you can find a model that allows you to predict the price of a car based on linear and multiple regression models weighing different characteristics of a car according to correlation on a price impact allowing you to use your dataset if needed
1st --> download csv file for data for car price prediction 
2nd --> download csv file for data wrangler
3rd -- > use jupyter notebook to run a car price model
4th -- > use jupyter notebook to run a data wrangler 


Mobirise Website Builder

House Price Prediction Model

Based on your personal database allows you to determine the price of a house using multiple regression model counting various variables that correlatively affect the price of a house
1st --> download csv file for data
2nd --> use jupyter notebook to run python code 

Mobirise Website Builder

Image Description

Bot Ban Attributtion Script in SQL

By following the link you can find the attribution model for Email Bot Bans using set of aggregated rules where users open emails for a long period of time, but never click the following link. 


1st --> download sql file with the script for not_clickers_bots 
2nd --> download sql file for too_fast_click_rule script


Mobirise Website Builder

QA Chatbot using RAG

This script allows you to create a UI display for uploading any files and run through an AI model to analyze the PDF file for specific information

Data Visualization Stories

Includes Full Scope Analysis
1st --> download csv file for data
2nd --> download Tableau Workbook to view the Story

Houses_By_Size
By Size

1st Page of a Story reveals avalaibility among the most basic need - Size

Areas_By_Price
Areas

2nd Page unveils another import aspect of the house choice - Location 

Houses_by_Floor
Floors

3rd Page allows to complete the search, choosing the optimal plan/price choice using - Floors

ids_of_houses
House Id

4th Page finishes user-journey by letting him choose his final option - House by ID

Working with Public API

Here is the example of Accessing Public api and saving it locally on your device

  • Access Public Api
  • Request and Pandas library
  • Define functions, create list, embed results in the list
  • Saves CSV formating  
Mobirise Website Builder

© Copyright 2025 - All Rights Reserved

AI Website Creator