CB
Projects
Welcome to my online project gallery. Showcasing selected works, implementation details, and technologies utilized.
Documentation Chatbot
Containerized Llama-based chatbot for documentation summarizing
Backend: API interacting with locally deployed Llama 3.1 8b LLM, through Ollama. It manages, not only interaction with the LLM, but also prompt creation and documentation pre-processing. External documentation is fed to the backend via uploaded files or API integration. Frontend: Simple web interface built with HTML with Tailwind CSS and JavaScript.
Credit Risk Calculators
Various credit risk calculators for financing of renewable energies projects
Built in Python, with Pandas and NumPy, fully dockerized, using a proprietary library for implementation DAG data processing approach.
Multi-user Contract Management App
Tactical application for banking back-office
Web application developed for the local branch of a major European banking group. It was used to keep track of the renewal timelines for tech supplier contracts. Developed using FastAPI + SQLite on the backend and Vue.js+Bootstrap on the frontend. Since the application was supposed to be multi-user, but, due to some security constraints, a database server was not available, I also had to devise a way to use SQLite over the network, while also allowing multiple users, from various locations, to interact and read/write from/to the database.
Cloud Server
Nextcloud server deployed on own hardware
In-location company server running Nextcloud, on Ubuntu 22.04 LTS. Installed repurposed hard drive, extracted from WD Cloud NAS, deployed OS and Nextcloud service. Secured application with SSL certificate and server with firewall, configured port forwarding in router, and added necessary DNS records for the domain.
calinbule.com
developer profile / resume manager
Django application that serves as a presentation website, developer profile, and resume manager, with lead generator capabilities.
EasyLink Studio
Order management system for online services provider
Web application that serves as an e-commerce extension for the main WordPress-based website of the company. Functionalities: user management with role segregation, service listing, purchase & refund (integration with PayPal), order management, ticketing, internal notification system, emailing (integration with SendGrid), bulk data upload from CSV files, analytics & reporting, database template caching. The app is developed with Django, will run on DigitalOcean AppPlatform, and will use a DigitalOcean PostgreSQL managed database. A separate module manages the integration with various APIs in order to update the various metrics of the products/services that the company sells.
Nova Card
Smart business cards
NFC-enabled business cards service, backed by a custom-developed Django-based web service.
Lead Generator
Generation of sales leads from Facebook groups
An app that periodically scans Facebook groups for posts and extracts the ones deemed relevant (contain certain keywords), together with the contact information of the post author, and maintains a dataset with those leads and their status. The leads are then presented in human-readable form by a web app running on the local network.
Scalable App Infrastructure
Automatic WordPress deployment on Kubernetes cluster
Terraform project that deploys e-commerce applications, such as WordPress + WooCommerce, inside a scalable architecture on Digitalocean, using an auto-scalable Kubernetes cluster with a load balancer and volumes for the persistence of the application and database files, all inside a VPC created purposefully for the deployment.
Event Tool
Assesment of potential commercial interest in event participants
An application that looks at all participants at events organized by the company and creates a list of medics that represent further commercial interest. The list is then enriched with relevant information collected from various systems. It does so by connecting via REST to Salesforce, and other systems for the extraction of information. This software is strongly integrated with the Windows OS, making use of its API to generate PDF files from the output files.
Territory Assignment Tool
Application that helps a pharmaceutical company keep track of sales reps territory assignments
In the world of pharmaceutical sales, the representatives of the company are each assigned to a territory inside which they carry out their activity. Given that the variables in this world are ever-changing (medics move away, reps resign, etc.) the company finds it hard to keep track and always have a clear image of what is going on with their sales force. The application extracts information from the client's information systems (via REST API) and updates the assignment of the reps to their respective territories. It is comprised of a back-end that provides the main functionality and a front-end that serves as a GUI and provides access to settings, logs, and statistics.
Room Prices App
App that extracts deals for hotel opeator network
A cloud-native, multi-instance web application that collects hotel room prices that meet certain criteria and displays them, in an aggregated form, on the app website. It uses two AWS EC2 instances for the collector apps, an AWS S3 bucket for storage, and two Google Compute Engine instances for the front-end, database and maintenance/tasks.
Web Scraping
Hotel/Flight data collection
Created a series of web scrapers that extract hotel information from various aggregators/hotel operators' websites.
Notary Fee Calculator
Notary office fees calculator
An application that helps notary offices to quickly compute the fees for their services, in accordance with the guidelines of The National Union of Notaries Public of Romania, and also provides a detailed view of the various cost components.
Enrollment Validator
Validation of enrollment data against preexisting information present in client's Salesforce instance
The application periodically accesses a web-based database to extract reports containing enrollment data for various company-owned websites. Due to the fact that there is no API access, this operation is performed via the front-end, with Selenium. The downloaded data is stored and then checked against the preexisting information, recorded in the company's Veeva instance, which is accessed via REST API. Because the enrollment data is filled in manually, the algorithm uses string matching techniques to overcome potential human error (typos, missing letters, special characters, etc.). The users that are already registered, are validated against a series of business rules provided by the client and divided by the system of provenience. The result is then output to files that are each sent to the person responsible for the respective system.
Spend&Savings ML
Machine Learning enabled version of the previously created reporting tool
Refactoring in Python of the Spend&Savings reporting tool, previously realized in VBA. The most laborious part of the process was reimplemented using the KNN machine learning technique for classification, based on categorical variables. Further reduced report realization time from a few hours to about 30 minutes.
Duplicate Remover
Deduplication of manually-filled data sets
The application takes in structured datasets that have been filled in manually and performs deduplication of records based on one or more fields. Given that the data sets were created manually and thus are prone to contain errors, the deduplication algorithm uses a series of score-based string-matching techniques to aid in the process.
Report Sheets Centralizer
Tool for centralization and structuring of field reports data
The application centralizes the data collected from the reports submitted by the field reps of the company. It then structures them in tabular form to make them ready for analysis and interpretation.
Office Tools Automations
Various tools to help with automation of work inside the Procurement department
Developed tools for automation of reporting for travel expenses, cell phone usage, monthly department activity, automated procurement bid forms, and data collection inside the department, for Procurement. Refactored and optimized for increased performance the Regional Business Plan for Sales, and also created Jira Ticket Report Updater for QA.
Spend&Savings
VBA automation of manually-intensive procurement reporting
Excel VBA-based application that takes multiple inputs and generates the monthly spend and savings report for use in the procurement department. By automating tasks it managed to drastically reduce the time for the realization of the report from days to hours.
