Ahmethan Otsay
Business/Data Analyst
***************@*******.*** +1-813-***-**** Amberly Dr, Tampa, FL 33647 Florida, United States 21/06/1997 https://www.linkedin.com/in/ahmethan-otsay-887b71150/ Turkish Male ABOUT ME
A graduate in Computer Sciences with two years of hands-on data analytics experience. Passionate about working with large amounts of data and to turn this data into information, into insight and insight into business decisions. I also have a keen interest in the field of data visualization and am fascinated by the power to compress complex datasets into approachable and appealing graphics. PROFESSIONAL EXPERIENCE
Business/Data Analyst
Ender Magazalari
-CRM-based and in-house system analysis
-SSRS for in-house reporting and Power BI for data visualization and business intelligence solutions
-Database query optimization, improvement and development
-Creating and developing complex SQL queries
-Campaigns and analyzes to extract and process customer data.(A/B testing, Basket Analysis, Association Analysis, RFM Analysis ..)
-On the business intelligence side, Creating inferences for the actions to be taken with continuity monitoring.
-Working on Python for further inference and prediction.
-Follow related technological trends and developments closely
-Assess current operations, offering recommendations for improvement and implementing new processes
11/2020 – present
Istanbul, Turkey
Research Development Engineering Intern
Öztiryakiler
-R&D projects in the White Goods Industry
-New product design research and development
-Tubitak Supported Patented Projects
-Taking part in the Electric Combi Oven Project
-In the tests of all other industrial products produced in the company 11/2019 – 02/2020
Istanbul, Turkey
Engineer Intern
Net İletişim
-Providing a Wireless Solution Environment
-Providing Technical Problem Solutions
09/2019 – 11/2019
Istanbul, Turkey
Engineer Intern
ISKI
-Smart Meters Test and Review
-New Istanbul Projects Support Activities
-Performing Oracle PL/SQL enhancements
06/2018 – 08/2018
Istanbul, Turkey
Information Technologies Intern
BELBIM
-Internal system operation control
-Providing technical support
06/2014 – 08/2014
Istanbul, Turkey
EDUCATION
Bachelor's degree / Electrical Electronics Engineering Marmara University
2015 – 2020
Istanbul, Turkey
Erasmus Bachelor's degree / Electrical Engineering / Spring Semester West Pomeranian University of Technology
2020 – 2020
Szczecin, Poland
PROJECTS
Ender Loyalty Card Program
Customers Loyalty App
We sell our products in our stores by giving our own credit to the customer (like Affirm). Then we collect these expenses when the installments come. With the loyalty card application, we will be able to add other channels to our SMS option, which is the only channel we have. With this application, we will be able to receive customer e-mail information and communicate via e-mail, and we will provide notifications through the application and stay in contact with them. In order to increase the application usage of the customers, I created options for gamification, creating a spend-win segment and earning points as a result of certain actions.
I created all of this in accordance with the budget we had to give. Our goal at the end of the project will be to increase our customer loyalty and satisfaction, while increasing our knowledge of customers and increasing our ways of getting to know them.
07/2022 – present
SKILLS
SQL
Power BI
T-SQL
Python
Git
SSRS
Excel
Data Analysis
LANGUAGES
English
C1
Turkish
COURSES
Data Science and Machine Learning Bootcamp
Veri Bilimi Okulu
Sorting, Scoring, Dynamic Pricing, AB Testing, KPI & Cohort Analysis BG-NBD: Expected Sales Forecasting, Gamma-Gamma:Expected Average Profit Customer Lifetime Value prediction, Demand Forecasting Model & Time Series Association Analysis and Recommendation Systems, Customer Segmentation with RFM Analysis
House Price Prediction Model, Diabetes Prediction with Machine Learning Corporate Customer Abandonment Modeling, Credit Risk Modeling Home Content Strategy Determination, Create a workspace on AWS and Google Cloud Large scale project development with PyCharm
Production Level Data Science (git, github, linux, makefile, flask, model deployment) 11/2021 – 04/2022
İstanbul, Turkey
Microsoft SQL Server Querying and Developing
Bilge Adam
01/2021 – 03/2021
İstanbul, Türkiye
AWARDS
TEKNOFEST UNMANNED AIRCRAFT COMPETITION
Teknofest
We participated in the competition in the UNMANNED AIRCRAFT category and were qualified to be a finalist. I contributed to the design of the hardware part of this project. 16/09/2019
REFERENCES
Ebru Unal, Financial Planning and Analysis Manager, Yoshino Spirits