Leonardo Zillo

Software Architecture & Full-Stack Development

Turning strategies into scalable, high-performance web systems.

23 years of experience in designing, implementing, and hardening critical applications based on PHP (Laravel/Symfony) and MySQL. Specialized freelance consultancy with an active VAT ID.

Request a Consultation

The Pillars of Your Solution

Scalable Architecture

I design web systems using robust design patterns (MVC, SOLID) and modern frameworks (Laravel, Symfony). The result is clean, secure code built to scale over time without the need for rewrites.

Critical Optimization

Beyond development: I focus on advanced MySQL/MariaDB optimization, from schema design to query tuning. I ensure maximum data processing speed and high availability (99.9%).

Hosting & Proactive Maintenance

More than just coding: I cover the full lifecycle. Hosting, proactive maintenance, and hardening of production Linux servers. Full infrastructure management, CI/CD deployment, and MySQL/PHP configuration.

Results That Matter: Data Driven

~93%

Deployment Time Reduction

Deployment shifted from 3.5 hours to 15 minutes through CI/CD automation.

+40%

DB Performance Boost

Improved database performance through advanced indexing and query optimization.

-30%

Interaction Latency Drop

Optimization of real-time data flows and integration of complex hardware.

Real-World Example

Case Study: Modernization of UTRtek Ltd Management System (London)

Context and Goal
UTRtek Ltd, a London-based company specializing in technical diving, used internal software and a client portal based on a legacy framework (phpMyEdit). The system limited PHP updates, suffered from MySQL query bottlenecks, and had vulnerabilities due to outdated libraries.

Solution
I led the complete redesign of the application, introducing a new architecture in PHP OOP and MySQLi based on solid patterns (MVC, SOLID), caching, extended validation, and structural optimization. I manage hosting and maintenance on optimized Linux servers.

Results
• +40% overall performance increase
• Full compatibility with modern PHP versions
• 99.9% uptime with continuous monitoring

My Tech Stack at Your Service

Core Languages: PHP (OOP, Frameworks: Laravel, Symfony, including support/migration for Legacy versions < 5.5), SQL (Advanced), JavaScript.

Databases: MySQL / MariaDB (Optimization, Stored Procedures), PostgreSQL.

DevOps: Linux Server Admin (Debian/Ubuntu), Docker, Web Server Hardening (Nginx, Apache), CI/CD.

Methodology: Design Patterns, RESTful APIs, Clean Code, SOLID principles, Testing (PHPUnit).

Ready to elevate your software's stability and performance?

Whether you need to design a new architecture, optimize an existing system, or solve critical performance issues, I am here to offer direct consultancy and measurable results.

Before We Start: 30-Minute Free Preliminary Analysis

Send Inquiry

Available as a Freelance Consultant with an active VAT ID.