Catglish
An interactive English education application designed to make learning engaging.
ReactVercelEducationInteractive
COMPUTER ENGINEER
Hello, I'm İlkay.
I am a Computer Engineer constantly learning and creating in the fields of Data and AI. In my professional experiences, I develop solutions focused on data performance, system architecture, and visualization. You can take a look below for the rest of the story and technical details.
Career Path
Professional Experience
A track record of taking ownership, from systems administration to leading data engineering initiatives and software development teams.
2024 - Present
İzmir, Turkey
Yıldız Yangın Sön. Sis. San. Tic. A.Ş.
Yıldız Yangın Sön. Sis. San. Tic. A.Ş.
Data Engineer & Team Lead
System Specialist & Developer
Key Achievement:Visible increase in system efficiency, error reduction, and high-performance system development via new processes.
Internal Products & Workflows
Warehouse Counting App
Real-time mobile counting system for warehouse and factory stocks. Reduced cycle time significantly.
Logistics Mobile App
Comprehensive mobile solution for transferring defective fire extinguishers to factory/warehouse.
Field Ops & Cost Analysis
Arvento-integrated tool for tracking vehicle mileage and calculating precise order costs.
Production Tracking System
End-to-end management: Parts replacement, production logs, and billing. (>200% Stability Increase)
Management Reporting (DevExpress)
Unified query screen and dashboard designs for executive decision making.
Audit & Log Architecture
Comprehensive system-wide logging for data recovery, security, and error tracing.
IT Ticket System
Internal support platform for tracking IT requests and bugs.
Digital Certificate System
Identity ID assignment and automated digital certificate generation for fire training.
Retail Price & Barcode
System for updating prices and printing barcodes designed for handheld devices.
IT Project Management
Notion-based system for managing IT tasks and team workflows.
Offer & Approval Process
Streamlined approval hierarchy and digital tracking of offers.
Customer Meeting Workflow
Digital workflow transferring field discovery notes directly to the order team.
Order Process Optimization
Digital report generation, automatic data correction, and workflow enhancements.
Transfer Workflow
Field to Warehouse to Customer product transfer optimization.
Custom Client DB
Specialized database architecture for key accounts.
MSSQLT-SQLPythonC#.NETRest APIWindows ServerDevExpress
2024Volunteering
Menia Games
Game Developer
Volunteer developer for a 2D RPG game. Implemented complex state machines and dialogue systems using Unity and Ink scripting.
Unity 2DC#Ink ScriptGit
2020 - 2021Previous Experience
Bilet Dükkanı
2021Frontend Intern
Completed internship at Bilet Dükkanı. Supported high-traffic platform biletdukkani.com. Focused on responsive UI and agile development.
AngularRxJSSCSSJira
IF Yazılım
2020Embedded Systems Intern
Developed embedded projects using C++ and protocols like I2C, SPI, CAN. Simulated systems via Matlab-Simulink.
C++Embedded CMatlabSimulinkI2C/SPI
Expertise
Technical Arsenal
A holistic approach to technology: managing the hardware, securing the network, structuring the data, and building the interface.
Database Engineering
Expertise in designing robust data architectures, optimizing queries, and ensuring data integrity.
MSSQL Admin
T-SQL Development
Performance Tuning
Data Modeling
PostgreSQL
Backup (VEEAM)
ETL Processes
Stored Procedures
System & Security
Comprehensive management of server infrastructure, network security, and virtualization.
Windows Server
Active Directory
Fortigate Firewall
Virtualization (ESXi)
Network Security
PowerShell
DNS / DHCP
Group Policy
Development
Building end-to-end solutions from embedded systems to modern web applications.
C# / .NET
Python
React / TS
Angular
Excel VBA
Rest API
Git / GitHub
BPM Workflows
Management & Tools
Leading teams, managing workflows, and visualizing data for executive decision-making.
Team Leadership
Notion Architecture
Report Design
Crisis Management
Technical Training
Agile / Scrum
Specialized Expertise
Deep Dive Areas
T-SQL Mastery
Advanced development of Stored Procedures, Triggers, and Dynamic Queries to process data rapidly and securely.
Database Architecture
Designing scalable database architectures from scratch that ensure ACID compliance and disaster recovery.
Optimization
Deep expertise in Execution Plans and Profiler analysis. Achieved massive success in reducing system load and query times.
Security & Backup
Managed physical and cloud backups using VEEAM and Shadow Copy. Implemented Kaspersky endpoint security and strict Fortigate firewall rules.
Agile & Workflows
Expertise in task tracking and workflow management using Notion. Visualizing KPI data with Canvas-style presentations for management.
Portfolio
Featured Projects
Personal creative endeavors and specialized tools.
Personal Stock Analysis
A custom analysis tool connected to PostgreSQL to track and predict market trends using personal algorithms.
PostgreSQLPythonData AnalysisFinance
Lottery
A physics-based lottery simulation. Watch Santa distribute luck in this interactive Canvas animation.
React & TSCanvas (2D Context)Data AnalysisRecharts
Block Rain
A mesmerizing falling block puzzle simulation with parallax effects and glowing aesthetics.
ReactCSS AnimationGame LogicDesign
Let's Connect
I bring speed to your systems and meaning to your data. From solving complex infrastructure problems to building scalable architectures from scratch; I create solutions that bridge technology with business value.
You can preview, print, or download my full resume here.