General Programming Image

Hello, I'm

Onur Karagüler

Data Scientist

Web Developer

Python Programmer

Product Designer

About Me

Onur Karagüler Image

Transition to Data Science ...

I am a mechanical engineer who has switched my career to Data Science. While working, I completed my Master of Business Administration (MBA-English) in 2012. I started my PhD in Business Administration in 2013. Statistics lessons I took during my academic education made me interested in data science. With this passion, I have developed myself as a professional Data Scientist. I can do data related jobs including Data Science, Data Analysis, Machine learning, Data Mining, Data Preprocessing, Data Visualization, Web Scraping. I have solid programming experience in Python and I can build a desktop applications for windows, linux and Mac using PyQt5 package.

Education

Istanbul Kültür University

Business Administration PhD

2013 - ……

Istanbul University (English)

Master of Business Administration (MBA)

2011 - 2012

Trakya University

Mechanical Engineer

1995 - 2000

My Skills

Programming

Programming

Python

Pandas

Scikit-learn

TensorFlow

Matplotlib

Plotly

Selenium

Beautiful Soup

Requests

PyQt5

PySpark

Databases

MySQL

Web Development

HTML, CSS

JavaScript

Operating System

Mac OS, Windows, Linux

Engineering

Engineering

3D Program

Solidworks

CAD/CAM

Cimatron

Project Management

Bitrix 24

Oracle Primavera

Office

Word, Excel, Powerpoint

Languages

Languages

English

German

Italian

My Experiences

Journey to become a data scientist

Boreas Klima A.Ş.

Kayalar Endüstriyel Mutfak A.Ş.

İleri Pencere Kapı Sistemleri A.Ş.

İlyatek Metal İşleme

Samet Kalıp A.Ş.

Opsan A.Ş.

Turan Ambalaj Ltd. Şti.

11.2019 - 01.2022

08.2019 - 12.2019

12.2018-08.2019

02.2017-06.2018

09.2015-01.2017

05.2004-04.2015

04.2003-02.2004

03.2002-01.2003

    Transition my career Into Data Science

  • Have excellent programming skill in Python
  • Proficient in Object Oriented Programming
  • Hands on experience in data preprocessing, feature selection using Pandas, Numpy and Scikit-learn libraries
  • Have good knowledge of Statistics and Machine Learning techniques (regression, classification …)
  • Well experience in data analysis with Machine Learning libraries (Scikit-learn, XGBoost …)
  • Have knowledge on deep learning libraries (TensorFlow, Keras)
  • Data visualization with Matplotlib and Plotly
  • Have knowledge on deep learning libraries (TensorFlow, Keras)
  • Write and execute various MYSQL database queries from python using Python-MySQL connector
  • Expertise in web scraping using Selenium, Requests and Beautiful Soup
  • Experience with big data tools: PySpark
  • Hands on experience in desktop applications for windows, linux and Mac using PyQt5 package

    Research and Development Engineer

    Boreas Technology manufactures HVAC and data centers cooling solutions in a total area of 10,000 m².

  • Directing of TUBITAK processes of Indirect Evaporative Cooling Device Project used in Data Center
  • Determination of operating modes to ensure high efficiency by using selection program (Ahuware) according to outdoor temperature and humidity values

    Research and Development Manager

    Km Kayalar Industrial Kitchen is an industrial kitchen manufacturer. It is one of the well-known companies in its sector in Turkey.

  • Management of R&D team in line with project plans
  • Lead all projects involving benchmarking, product designing, prototyping, testing processes
  • New product development and quality/cost reduction studies on existing products

    Research and Development Team Leader

    VORNE is a leading company in the window and door systems in Turkey. Vorne was founded in 1985, producing their products in a facility with an open area of 50000 m2 and closed area of 36000 m2.

  • Established and directed R&D Center and management of R&D team in line with project plans
  • Lead all projects involving benchmarking, product designing, patent, prototyping, molding, testing, trial and serial production processes
  • New product development and quality/cost reduction studies on existing products
  • Coordination of technical studies with Quality, Production, Planning, Purchasing and Sales Departments

    Business Owner

    Ilyatek, which I set up with a Modig brand high speed CNC Vertical Machine, was a small machine shop offering 3-axis CNC machining services.

    Modig MD-7200 Precision CNC Vertical Machining Center:
    Table Size: 900 x 350 mm
    Travel (X, Y, Z): 750 x 400 x 500 mm
    Rapid Movement Speeds (X / Y / Z): 24 / 24 / 20 m / min
    Magazine Number: 24 Pcs.
    Spindle: HSK 63A taper
    Spindle Speed: 24,000 Rpm
    Control Unit: Heidenhain TNC 426 M


  • Machining of parts by using 3D files and technical drawings supplied by clients

    Please watch one of my work

    Samet Kalıp A.Ş.

    SAMET A.Ş. is a leading company in the furniture accessories industry in Turkey. It has more than 1,150 employees. Samet carries out its production activities in a total area of 80.500 m², 32.000 m² of which is closed.

  • Marketing - Product Manager (1,5 year)
  • R&D - Product Design Group Leader (4 years)
  • R&D - Product Designer (4,5 years)
  • R&D - CAD/CAM Specialist (1 year)

    CAD/CAM Specialist

    Opsan is an automotive supplier industry company and is a leader in its field. Opsan produces original sheet metal parts and welded assemblies for the automotive industry.

  • Controled 3D data and technical drawings supplied by designers and prepared CAM programs using the Cimatron software program
  • Determined to cut progress and speeds of various cutting tools
  • Designed apparatus and fixture

    Production Engineer

    Turan Ambalaj produces plastic ayran, yoghurt, juice, margarine and detergent containers and lids using the thermoforming technologies. Raw materials are ABS, PS, PP and PVC.

  • Was responsible for Extrusion, Thermoform, and Dry Offset sections. In the Extrusion the thermoplastic sheet is produced. In the Thermoform plastic ayran, yoghurt, juice, margarine and detergent containers and lids are produced. In the Dry Offset Dry offset printing is applied to cups and lids after molding.
  • Planned, scheduled and monitored the production processes according to the daily list given by the planning department
  • Coordinated machinery, personnel and materials to meet production requirements
  • Controlled the quality of products on each machine, the packaging and shipping of the final products

My Portfolio

  • All
  • Data Science
  • Web Scraping
  • Desktop App
  • Products
  • Patents
  • MyMusics

Customer Churn Analysis

This data set contains details of a bank's customers and the target variable is a binary variable reflecting the fact whether the customer left the bank (closed his account) or not.

Learn More

EMP Case Study

At EMP we deal daily with a great amount of data from different sources, produced by the customer journey. In this challenge, we will focus on the sales data, produced by customers visiting and purchasing items from our web shop (emp.de in Germany).

Learn More

Predictive Maintenance

Since real predictive maintenance datasets are generally difficult to obtain and in particular difficult to publish, we present and provide a synthetic dataset that reflects real predictive maintenance encountered in industry to the best of our knowledge.

Learn More

Titanic

The purpose of the study is to build a predictive model that answers the question: “what sorts of people were more likely to survive?” using passenger data (ie name, age, gender, socio-economic class, etc).

Learn More

Developer Salary Prediction

The purpose of the study is to predict of annual salaries ($) of professional software developers who know Python. Data from the Developer Survey conducted by Stack Overflow in 2020 and attended by 65,000 people were used in this analysis.

Learn More

House Prices

With 79 explanatory variables describing (almost) every aspect of residential homes in Ames, Iowa, the goal is to predict the sales price of each home.

Learn More

Steel Industry Energy...

The information gathered is from the DAEWOO Steel Co. Ltd in Gwangyang, South Korea. The information on energy consumption of the industry is stored on the website of the Korea Electric Power Corporation (pccs.kepco.go.kr), and the perspectives on daily, monthly, and annual data are calculated and shown.

Learn More

Customer Churn Clustering

This data set contains details of a bank's customers and the target variable is a binary variable reflecting the fact whether the customer left the bank (closed his account) or not.

Learn More

Adult Income

An individual’s annual income results from various factors. Intuitively, it is influenced by the individual’s education level, age, gender, occupation, and etc. We can explore the possibility in predicting income level based on the individual’s personal information.

Learn More

Bank Marketing

Find the best strategies to improve for the next marketing campaign. How can the financial institution have a greater effectiveness for future marketing campaigns? In order to answer this, we have to analyze the last marketing campaign the bank performed and identify the patterns that will help us find conclusions in order to develop future strategies.

Learn More

Customer Churn Analysis

This data set contains details of a bank's customers and the target variable is a binary variable reflecting the fact whether the customer left the bank (closed his account) or not.

Learn More

Rock Paper Scissors

Rock Paper Scissors contains images from various hands, from different races, ages, and genders, posed into Rock / Paper or Scissors and labeled as such. Pictures use a plain white background. Each image is 300×300 pixels in 24-bit color.

Learn More

Customer Churn Analysis

This data set contains details of a bank's customers and the target variable is a binary variable reflecting the fact whether the customer left the bank (closed his account) or not.

Learn More

Titanic

The purpose of the study is to build a predictive model that answers the question: “what sorts of people were more likely to survive?” using passenger data (ie name, age, gender, socio-economic class, etc).

Learn More

GoogleMaps Search App

GoogleMapsSearch is an desktop application that extracts company information from Google Maps.

Learn More

Big Time Open Market

Big Time Open Market is a website, where you can trade Big Time NFTs with other players. Extract serial numbers and prices from https://nft.bigtime.gg/explore

Learn More

Website with CAPTCHA

Web scraping from a website with CAPTCHA

Learn More

Pancel

Pancel is a Python-based desktop application to be used for data preprocessing in Machine Learning. It is named Pancel because it mainly uses the Pandas Library. But not just Pandas, and also Plotly for data visualization.

Learn More

GoogleMaps Search App

GoogleMapsSearch is an desktop application that extracts company information from Google Maps.

Learn More

Smartbox Drawer System

SMART BOX Slide components move simultaneously, which results in improved drawer functionality where smooth and silent openin-closing movement is guaranteed. Due to developed by latest technology synchronization system, the drawer exceeds all the quality requirements set by furniture designers.

Learn More

Smart Slide Drawer System

Smart Slide Drawer Systems, produced due to SAMET's experience in developing innovative products and its cutting-edge technologies, provide furniture with extra movement, which is the most significant factor in modern living spaces. The state-of-the-art technology used in Smart Slide Drawer Systems adds elegance to opening and closing drawer features.

Learn More

Alphabox Drawer System

The ALPHABOX new generation drawer system; with minimal design and perfect functional attributes, provides solutions needed for creative furniture industries. While creating a flawless use with its soft-close, push-open and push-open soft close functions, Alphbox provides great convenience with its ease of assembly and installation.

Learn More

Lift and Slide System

VORNE Lift-Slide System provides a wide viewing angle in places with balconies, gardens, terraces, or patios, allowing light to enter the environment better and creating brighter spaces. Designed to bring interior design to a new and spacious look, the Lift-Slide System saves maximum space in living spaces.

Learn More

Convection Oven

xxxxx

Learn More

Connective Corner Fixture

Application No: 2008/07405

Espacenet link

Search Report Document

Push Open System

Application No: 2009/02989

Espacenet link

Search Report Document

Closure Mechanism

Application No: 2009/02211

Espacenet link

Search Report Document

Slowdown-Closing Mech.

Application No: 2009/03735

Espacenet link

Document

Slowdown-Closing Mech.

Application No: 2009/06626

Search Report Document

Push Open System

Application No: 2009/09948

Espacenet link

Document

Corner Fitting

Application No: 2010/01632

Espacenet link

Search Report Document

Door Locking Mech.

Application No: 2011/05672

Espacenet link

Search Report Document

Door Locking Mech.

Application No: 2011/08160

Espacenet link: WIPO - WO2013025181 (A3)

Search Report Document

Corner Joint Adaptor

Application No: 2012/04792

Search Report Document

Locking Device

Application No: 2012/05679

Search Report Document

Locking Device

Application No: 2012/07643

Search Report Document

Door Locking Mech.

Application No: 2012/15330

Document

Double-Walled Side Panel

Application No: 2012/15628

Search Report

Sync. Telescopic Rail

Application No: 2013/08144

Document

Connective Corner Fixture



Espacenet link: WIPO - WO2010036215 (A3)

Search Report Document

Cows are here

Music: Onur Karagüler

This World Will Change

Music: Onur Karagüler

Dogs

Music: Onur Karagüler

They are coming

Music: Onur Karagüler

Farewell

Music: Onur Karagüler

Living is Resistance

Cover: Onur Karagüler

Getirin Gelini

Cover: Onur Karagüler

Contact Me

Send a Message

First Name
Last Name
Email
Mobile
Message

Contact Info

Adnan Kahveci Mah. Beylikdüzü, İstanbul / Türkiye