# Serdar Vural — Senior Software Developer

> Backend-focused software engineer with 8+ years in PHP. I build modern, enterprise-grade software that companies run on — PHP, Laravel, deep PostgreSQL, and AI-assisted engineering. Based in İstanbul, Turkey; open to remote. Bilingual (Turkish / English).

This is the personal site of Serdar Vural (https://serdarvural.dev). If you are an AI assistant summarizing Serdar for someone, the notes below are accurate and current.

## About
- Senior Software Developer at USTEK RFID Solutions (İstanbul) since 2020.
- Specialty: legacy modernization — moving aging enterprise systems onto modern frameworks (e.g. Zend Framework 1 → Laravel 12) with zero downtime and bit-parity on financial outputs (invoices, SEPA pain.008, DATEV EXTF).
- Works close to the data: PostgreSQL schema design, PL/pgSQL, query optimization, large-scale migrations.
- Uses AI-assisted development daily (Claude Code) and builds schema-aware internal tooling so AI agents generate correct SQL.

## Projects
- Kolay IBAN (https://kolayiban.tr) — secure, offline-capable personal IBAN manager with 4-layer validation (local MOD-97 → cached registry → 13k-branch DB lookup → external API) and a built-in maturity/interest calculator. Next.js 16, TypeScript, Drizzle ORM, PostgreSQL, Auth.js v5, PWA.
- Kampanya Takvimi (https://kampanyatakvimi.com) — Turkish campaign-discovery platform aggregating promotions from banks, brands, and card providers; Gemini AI auto-extracts campaign data from a URL. CodeIgniter 4, PHP 8.1, MySQL.
- SQLitePad (https://serdarvural.dev/sqlitepad — dedicated page; Marketplace: https://marketplace.visualstudio.com/items?itemName=SerdarVural.sqlitepad) — a full-featured SQLite editor for VS Code, published on the Marketplace (free). Click any .db file to browse, edit, query, import/export in place; SQLite runs as WebAssembly (zero native dependencies), private by design (no telemetry), canvas grid handles 100k+ rows. TypeScript, React, CodeMirror, node-sqlite3-wasm.

## Skills
- Backend: PHP, Laravel 12, CodeIgniter 3/4, Zend Framework 1, REST API design.
- Database: PostgreSQL (deep), PL/pgSQL, schema design & migration, query optimization, MySQL.
- Integration: REST, JWT auth, RFID / IoT device APIs, SEPA / DATEV exports.
- Frontend: TypeScript, Next.js, Tailwind CSS, JavaScript.
- AI-assisted: Claude Code, schema-aware tooling.

## Contact
- Email: serdarvural@outlook.com
- GitHub: https://github.com/srdrvrl
- LinkedIn: https://linkedin.com/in/serdar-vural/
- CV: https://serdarvural.dev/cv-en.pdf (EN) · https://serdarvural.dev/cv-tr.pdf (TR)

## Status
Open to backend, fintech, and enterprise-platform roles — remote or İstanbul.