Hasan Alp Caferoğlu

Curriculum Vitae

PDF


Education

Master of Science - Computer Science

Bilkent University

Ankara, Turkey

Jan 2023 - Present

Bachelor of Engineering - Mechanical Engineering

Middle East Technical University

Ankara, Turkey

2016 - 2021

Experience

Teaching Asistant

Bilkent University

Ankara, Turkey

Jan 2023 - Present

CS 101 Algorithms and Programming I

CS115 Introduction to Programming in Python

CS353 Database Systems

Web Developer

Epicflow.io

USA (Remote)

Oct. 2023 - March 2023

Worked on integrating authentication and payment systems. Developed frontend of the application.

(Javascript, React, AWS Cognito, AWS Lambda, Stripe)

Mechanical System and Design Engineer

ASELSAN

Ankara, Turkey

Sept. 2021 - March 2023

Worked on designing mechanical parts, determination and selection of the system components and layout of the system components.

Publications & Preprints

  • H. A. Caferoğlu, O. Ulusoy. E-SQL: Direct Schema Linking via Question Enrichment in Text-to-SQL, 2024. (In Submission)[PDF] [Code]

Projects

Text-to-SQL Translation Using LLMs

June 2024 - Present

Developing a challenging NLP application utilizing large language models (LLMs) for translating natural language queries into SQL statements (i.e., NL2SQL). This approach significantly lowers the barriers to accessing relational databases by parsing and understanding the structure of natural language to accurately generate corresponding SQL queries.

(Python, PyTorch, Hugging Face, OpenAI)

Image Segmentation with R2U-Net

Jan 2024 - May 2024

In this project, the Recurrent Residual Convolutional Neural Network based on U-Net (R2U-Net) is implemented. Unlike the original study, the implemented model is trained and tested on the Oxford-IIIT Ped dataset for the image segmentation task.

(Python, PyTorch)

GelGit Travel: A Cloud-Native Application

Jan 2024 - May 2024

Gelgit Travel is a cloud-native application which showcases transportation ticket management and purchase platform. It is developed to learn and utilize fundamental AWS cloud services.

(VPC, EC2, RDS, API Gateway, Lambda, Cognito, SES, Amplify, IAM, WAF, CloudTrail, CloudWatch, React)

NLIDB Keyword Mapping

Oct 2023 - Jan 2024

An NLP application that employs weak-supervision techniques to identify the relation between natural language query tokens and database entities, treating the keyword mapping problem as a sequence tagging problem using neural network.

(Python, PyTorch, Hugging Face)

Stance Detection - Stream Data

Oct 2023 - Jan 2024

A Stance Detection project that identifies the attitude of a textual content under the changing nature of the data. Adaptive model which tries to maintain its accuracy overtime by fine-tuning itself using new data.

(Python, PyTorch, Tensorflow)

Online Ticket Purchasing Application

May 2022 - June 2022

A website that allows travelers to search travels and reserve/purchase tickets for their desired transportation method, and that allows travel companies to register and manage their trips.

(Python, Flask, MySQL, Docker)

Teachers-Zone Web Application

Sept 2022

Platform where teachers can show their areas of expertise and thus earn additional income by providing lectures for students.

(Next.js, TailwindCSS, MongoDB, Vercel)


You can accompany my story on other platforms.

Hasan Alp Caferoglu © 2024