SYSTEM STATUS: ONLINE | MODE: ENGINEER | LOCATION: IZMIR, TR
user@firat: ~/portfolio
import Profile from './career';
return "Hello, I'm Fırat Çelik.";
  // Senior Engineer bridging Software Architecture & Data Intelligence.
run('build_portfolio');
Loading projects... Done.

ls -l ./projects/

:: PERSONAL IOS APPS ::

timora_tasksMY APP

Timora: Focus Tasks

Sleek, focus-oriented iOS task manager for daily workflow organization and mental clarity.

[Flutter][iOS]
pour_coffee_guideMY APP

Pour Coffee Guide

Educational iOS app guiding users through 35+ global brewing methods with offline access.

[Flutter][iOS]

:: FREELANCE WEB PROJECTS ::

the_lead_lab

The LeadLab

Psychometric lead management platform transforming data into intelligence.

[React][TypeScript]
deluxepad

DeluxePad

Luxury digital content platform connecting brands with private aviation travelers.

[Next.js][PostgreSQL]
narcis

Narcis

Swiss artisan glass atelier site reflecting "crystallized poetry".

[Next.js][Design]
newton_meter

Newton Meter

Specialized technical platform for precision measurement solutions.

[React][Next.js]
my_pwb

My-PWB

Personal branding site for mental health and life coaching.

[Next.js][SEO]
ats_generale

ATS Generale

Corporate web presence for a Swiss general services firm.

[HTML5][CSS3]
nant_des_grottes

Le Nant des Grottes

Atmospheric web experience capturing unique Swiss nature.

[Next.js][Lifestyle]
grave_swiss

Grave Swiss

Professional Swiss business portal emphasizing industrial standards.

[React][Corporate]

cat ./experience.log

09/2025 - Present

Azure Data Engineer

Monovi Information Technology A.S. (Izmir, TR)
  • Served as a key data engineer for a major multinational client, delivering a new, end-to-end Data Warehouse platform from scratch using Agile methodologies.
  • Architect and operate Azure native data platforms (Azure Synapse, Microsoft Fabric, Azure Data Lake, Azure Portal) that enable analytics and self-serve reporting.
  • Build, test, and harden Synapse pipelines; develop complex T-SQL queries, database views, and stored procedures.
  • Apply performance tuning (partitioning, indexing) for cost and query efficiency.
  • Design and implement ETL/ELT processes and advanced dimensional models (star/snowflake schemas) for a reliable, scalable data warehouse.
  • Orchestrate automated workflows with Microsoft Power Automate; deliver internal apps with Power Apps.
  • Produce decision-ready dashboards and KPI suites (e.g., Power BI) for business stakeholders, including the development of Tabular models to track operational performance and SLAs.
  • Acquire, cleanse, and integrate data from diverse internal and external sources, including relational databases, files, and API/Web Services (REST/JSON).
  • Establish and enforce data quality, integrity, security, and access governance across environments.
  • Perform ad-hoc and statistical analyses to answer business questions and inform recommendations.
  • Contributed to diverse projects for clients and stakeholders across the Middle East, Africa, and KSA (Kingdom of Saudi Arabia).
2021 - Present

Freelance Full-Stack Developer

Remote (International)
  • Delivered high-performance web applications for international clients using modern JavaScript frameworks and cloud technologies.
  • Engineered full-stack solutions from concept to deployment, focusing on clean architecture, performance optimization, and client collaboration.
  • Key Projects Include: The LeadLab (Psychometric Platform), DeluxePad (Luxury Aviation), Narcis (Swiss Artisan), and Timora/Pour Coffee Guide (Personal iOS Apps).
11/2017 - 07/2025

Senior Data Analyst & Mobile/Backend Developer

AgFlow S.A. (Geneva, CH)
Mobile Application Development
  • Led the development of a mobile application (Flutter) delivering real-time agricultural market data, enhancing user decision making by integrating predictive analytics.
  • Collaborated with designers and stakeholders to implement user-friendly interfaces and features tailored to client needs.
  • Coordinated Agile workflows and ensured timely delivery while maintaining a 99.9% uptime for the mobile and backend systems.
Backend Development
  • Architected scalable backend systems using GoLang, Python, and PostgreSQL, processing millions of daily requests with minimal latency.
  • Designed and deployed RESTful APIs, improving real-time data exchange capabilities and reducing query times by 30%.
  • Built a microservices architecture to decouple systems, improving scalability and fault tolerance.
Frontend Development
  • Utilized React to build, modify, and enhance web-based user interfaces, including internal administrative dashboards and key customer portal pages, improving data accessibility and workflow efficiency.
Predictive Modeling & Data Analytics
  • Developed machine learning models that increased market forecast accuracy by 40%, aiding strategic decision-making.
  • Automated the ingestion and transformation of diverse data formats, such as PDFs, images, and email parsing, enhancing data quality and processing speed.
Automation & API Management
  • Automated data ingestion processes, reducing manual effort by 50% and error rates by 40%.
  • Integrated internal systems with external APIs like Bloomberg, enabling seamless real-time data sharing.
Leadership & Collaboration
  • Managed a cross-functional team of 8 developers, mentoring junior team members and fostering a collaborative environment.
  • Conducted code reviews, improved team productivity by 20%, and implemented best practices for software development.
  • Coordinated projects using Scrum methodology, optimizing workflows and delivering high-impact features on time.
Advanced Solutions
  • Implemented Elasticsearch for enhanced data retrieval speed and accuracy.
  • Developed batch processing systems for large-scale data analytics pipelines.
  • Enhanced system logging and monitoring, improving troubleshooting efficiency and uptime reliability.
07/2017 - 09/2017

C# Instructor

Center for European Initiatives (Sumy, UA)
  • Delivered a structured curriculum on C# and SQL, helping over 50 students build foundational programming skills.
  • Simplified technical concepts, achieving a 95% satisfaction rate among participants.
  • Designed interactive lessons and hands-on projects to cater to diverse learning styles.
06/2016 - 08/2016

Intern .NET Programmer

Kafein Technology Solution (Istanbul, TR)
  • Contributed to the development of HR tools, improving operational efficiency by 20%.
  • Participated in R&D projects using .NET technologies and MSSQL databases, gaining practical experience in software development.
  • Designed and implemented new features while troubleshooting technical issues in a fast-paced environment.
06/2010 - 12/2010

Computer Equipment Operator

FIBA World Championship (Istanbul, TR)
  • Assisted in the creation of network infrastructure for the tournament, ensuring smooth IT operations.
  • Provided on-site technical troubleshooting and IT support, contributing to the successful execution of the event.
05/2009 - 12/2009

Computer Programmer

Yurtiçi Kargo (Istanbul, TR)
  • Contributed to an international .NET automation project, developing scalable and modular software solutions to streamline operations.
  • Collaborated with a team of developers to meet project milestones while ensuring high-quality code.