Yağız Esmerligil

Turkey

@Yagizesmer

Data Analyst

Personal Information

yagiz2873@hotmail.com
+90-5300300565
Turkey

Badges

Python
Sql

Certifications

Work Experience

  • Data Analyst Teaching Assistant

    Miuul•  July 2024 - November 2024•  Ankara , Remote

    Monitored progression of students who want to learn Data Analytics at Miuul. Helped students master learning concepts through one-on-one assistance and small group tutoring in Data Analytics. Collaborated with teachers and mentors to devise and execute challenging, stimulating lessons and a lot of homework. Helped arrange and distribute learning materials and a lot of homework. Monitored students' responses to learning activities.

  • Data Analytics Course Attendee

    Miuul•  October 2023 - February 2024•  Ankara , Remote

    Learnt the Data Analytic's fundamentals, tools and programming / query languages that a data analyst implements generally. (such as Excel, PowerBI, Python and SQL) in 5 months. Implemented all of these fundamentals, tools and languages to make a project on a dataset called Superstore. Applied Apriori algorithm to perform Market Basket Analysis to find meaningful associations between product categories; campaigned and gave %20 and %15 discount on selected binder and paper products that have strong associations with each other. Performed an RFM Analysis by using SQL (rule based segmentation) to understand customers' buying behaviors; campaigned and gave $50 discount for the next purchase of $350 or more to a specific customer segment. Performed CLTV calculation by using rule based calculation, BG-NBD and Gamma-Gamma modeling to predict customers' revenues for the next 1st month. Conducted K-Means clustering based on CLTV values and created customer segments based on these values. Generated additional insights based on these techniques, descriptive and diagnostic analyses on the dataset. Performed CRISP-DM stages of project in general.

  • Software Development Specialist Assistant

    Mia Teknoloji•  September 2022 - March 2023•  Ankara , On-Site

    Worked as a Frontend Developer mostly at this company in 6 months. Implemented languages, libraries and frameworks such as HTML5, CSS3, Bootstrap5, JavaScript, TypeScript, AngularJS to design visual side of web pages.

  • Frontend Developer Course Attendee

    BilgeAdam Akademi•  February 2022 - July 2022•  Ankara , Remote

    Learnt the Frontend Development's fundamentals, tools, programming languages and frameworks that a frontend developer implements generally (such as HTML5, CSS3, Bootstrap4, JavaScript, jQuery, ReactJS, AngularJS and VS Code) in 5 months. Implemented all of these fundamentals, tools and languages to design the visual side of web pages as exercises.

  • Intern Data Analyst

    Demir Export•  July 2019 - August 2019•  Turkey , On-Site

    Worked on a big and complex mining dataset to analyze in 1 month. Executed Excel, Python programming language and Python's Numpy and Pandas libraries for performing CRISP-DM stages on the dataset. Applied Microsoft Power BI software for visualizing the dataset.

Education

  • Baskent University

    Computer Science, BE•  August 2016 - September 2020•  CGPA: 3.28

    Graduated from the university with the CGPA of 3.28. Received Bachelor's Degree in Computer Engineering. Prepared reports about graduation project, different classes taken and so on.

Skills

SQL
Python(Intermediate)
PowerBI
Excel
Data Analysis
Data Interpretation
Data Visualization
Data Cleaning and Preprocessing
Statistical Analysis and Modelling
Machine Learning Techniques
Database Management Systems and Tools (Azure Data Studio, SSMS, SQL Server)
Git
Probability and Statistics
Usage of GenAI Tools (ChatGPT , Dream Lab etc.)
English
Jupyter Notebook
Canva
Reporting