Optimize Laravel queries using SQL JSON aggregation - reduce multiple relation queries to a single SQL statement

A security and performance inspector for Django & DRF. Features static analysis, config checks, N+1 query detection, and SARIF support for GitHub Code Scanning.

An end-to-end business analytics SQL portfolio built on a custom e-commerce database — designed to answer real business questions about customers, revenue, retention, and product performance using advanced SQL techniques.

Reduce multi-relation Doctrine queries to a single SQL statement using JSON aggregation. Solves Doctrine's N+1 problem.

Database Reliability Engineering platform for HA/DR, 100TB+ migrations, performance guardrails, and self-healing data systems.

AI Query Optimizer Report

A curated knowledge base and second brain for MySQL architecture, query optimization, and database administration. Structured for deep learning via Obsidian.

Documentation-as-Code knowledge base for Platform Engineering: Linux systems, backend development (Java/Python/SQL), infrastructure (Docker/CI-CD), and LTS-safe operations runbooks.

Manage SQL range binning via configuration tables instead of repetitive CASE WHEN statements.

🗄️ IBM Relational Database Administrator with GenAI Certificate Portfolio – A comprehensive collection of projects, labs, and assignments showcasing expertise in relational database administration, 🏘️data warehousing, 🔁ETL pipelines, and 🤖Generative AI integration for modern database management.

Personal portfolio showcasing end-to-end projects in Backend Development, Big Data Pipelines, and BI. Focused on Python, PySpark, Node.js, and SQL optimization.

An enterprise-grade, multi-vendor e-commerce platform built with Django & DRF. Features dual JWT/Session auth, an asynchronous cart API, Khalti payment integration, and highly optimized SQL queries (zero N+1 issues).

19 production-ready PostgreSQL queries solving real e-commerce analytics challenges. Advanced SQL techniques: CTEs, window functions, complex joins & stored procedures.

Scalable ETL pipeline and PostgreSQL optimization for 40M+ records. Features memory-efficient Python preprocessing and B-Tree indexing for a 95% reduction in query latency.

Fast C extension for grouping consecutive monotonic sequences into ranges. O(n), works with any Comparable+succ type. Useful for compacting large IN() clauses in SQL.

Querying, data manipulation, performance optimization, and AWS-specific SQL

Sistema web para mineração e consulta de slow_logs do MySQL.

Interactive Data Analytics Dashboard for German Crime Victim Statistics (2023-2024). High-performance visualization of 430k+ records using PHP, MySQL, and Chart.js.

SQL performance analysis and optimization advisor with SQLMesh integration

Full-stack data analytics platform built with Python, Streamlit, and MySQL, integrating 2M+ Chicago open-data records with relational database design, ETL pipelines, geospatial analytics, and interactive SQL-driven dashboards.