
Aftab
Backend Design with Python, PHP, SQL, Multi Tenancy Mastery, Normalize
Competenze

Consulta i miei servizi


Portfolio
Esperienza lavorativa
Full-Stack Learning Management System — Enterprise Architecture
Self Level • Lavoratore autonomo
Mar 2025 - Sep 2025 • 6 mos
Full-Stack LMS — Solo Built, Production-Ready Backend: PHP Flight micro-framework, JWT auth, dynamic DB connection pooling across multi-tenant schemas. 30-table normalized schema with intelligent MySQL views (15+ denormalized query surfaces). Generic CRUD abstraction handling 25+ entities via schema introspection. Automated org provisioning: DB creation, migrations, filesystem isolation. Frontend: Vanilla JS SPA, zero dependencies. Dynamic route resolution from config-driven tab/subtab matrix with role-gated access. Schema-introspected search UI auto-generates filters by column type. Theme engine (10 variants), print-optimized rendering, inline editing with batch persistence. Key Wins: Database-per-tenant isolation · 6-role permission matrix · Complex 6-table joins exposed as single API surface · Zero-touch org onboarding · Sub-50KB core bundle.
Production-Grade MT5 Trading Broker API — Solo Engineered
ACI group • Freelance
Jan 2025 - Mar 2025 • 2 mos
Core: FastAPI, MT5 integration, Redis, SQLAlchemy/SQLite. Full multitenancy with per-user encrypted database isolation. MT5 Engine: Login/auth, account info, positions, orders, deals, margin/profit calculations. Automated pipelines: M1/D1 rates, tick data, trading history with intelligent cleanup. Analytics: HPR-based gain/performance metrics per account. Security: JWT role-based access (admin/client), AES-encrypted DBs per user, zero cross-tenant data leakage. Infra: Redis caching layer, background logging, real-time update streams. Modular architecture, CORS-enabled, cross-platform. Key Wins: Encrypted DB-per-user isolation · Automated data pipelines with retention policies · Real-time performance analytics · Sub-100ms cached responses.