Oğuzcan Özkara

Senior Data Analyst at Turkcell Technology
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Istanbul, Istanbul, Turkey, TR
Languages
  • Türkçe Native or bilingual proficiency
  • İngilizce Professional working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Power BI - Power Query- Power Pivot - DAX
    Udemy
    Jul, 2022
    - Nov, 2024
  • Professional Scrum Master™ I (PSM I)
    Scrum.org
    Jun, 2022
    - Nov, 2024
  • Professional Scrum Product Owner™ I (PSPO I)
    Scrum.org
    May, 2022
    - Nov, 2024
  • Tableau 10 Training Course
    Simplilearn
    Sep, 2021
    - Nov, 2024
  • 12 Hours Tableau Data Visualization Course
    Udemy
    Aug, 2021
    - Nov, 2024
  • TDWI Advanced Data Modeling Techniques
    Depar Akademi Kurumsal Eğitim Hizmetleri
    Aug, 2021
    - Nov, 2024
  • AI Programming with Python
    Udacity
    Oct, 2020
    - Nov, 2024
  • Two-week Education about 5G Technologies in Hangzhou (China)
    Huawei
    Nov, 2019
    - Nov, 2024
  • Finance for Non-Finance Professionals by Rice University on Coursera
    Coursera
    Aug, 2019
    - Nov, 2024
  • Turkcell Young Talent Business & Innovation Program
    IMD Business School
    Apr, 2019
    - Nov, 2024

Experience

  • Turkcell Technology
    • Türkiye
    • Information Technology & Services
    • 400 - 500 Employee
    • Senior Data Analyst
      • Jan 2021 - Present

      • Interpreting data, analyze results using statistical techniques and develop interactive dashboards, reports etc. • Working closely with production team and performing A/B tests in order to find better solutions to the challenges that production team faced. • Ability to turn data into actionable insights using various big data analytic frameworks. • Collaborate with business stakeholders to prioritize business and information needs. • Analyzing corporate systems to determine the structure, content and quality of the data. • Set up specialized Business Intelligence(BI) projects through in-depth understanding of customer need, administration of data flow, ETL solutions considering design of data warehouse. • Satisfying customer needs by utilizing demonstration tools, scheduled regular reports. • Analysing data in a large number of different source systems and integrating the data under related subject areas by taking dimensional data model into account. • Leading data warehouse projects and moving different analytical environmentals. • Preparation of dashboards consist of network-telecommunication, costumer, internal data for internal clients. • Designing & developing BI solutions with Agile Methodologies ( Scrum-Kanban ) Used tools and technologies: Oracle Data Integrator(ODI), Ab Initio, Oracle, Postgresql, PL/SQL, Microstrategy, Tableau,Power BI Python, Machine Learning Algorithm Show less

  • Veri Bilimi Okulu
    • Türkiye
    • Information Technology & Services
    • 1 - 100 Employee
    • Data Science & Machine Learning Bootcamp Participant
      • Nov 2021 - Mar 2022

      - Python Programming - Statistics - Functional EDA, Data Preprocessing - Measurement Problems (Dynamic Pricing, AB Testing, Sorting) - Demand Forecasting Time Series - CRM Analytics (KPI, Cohort, CLTV, Segmentation) - BG-NBD: Expected Sales Forecasting - Gamma-Gamma: Expected Average Profit - RFM Analysis & CRM Analytics - Churn Analysis - Recommendation Systems (ARL, Collaborative Fil., MF) - Advanced Feature Engineering - Script Level Machine Learning - House Price Prediction Model - NLP (TM, Review Modeling, Word Embeddings) - Kaggle Competitions Show less

  • Turkcell
    • Türkiye
    • Telecommunications
    • 700 & Above Employee
    • Data Analytics Engineer
      • Sep 2018 - Jan 2021

      • Learning all parts of Data warehouse(DWH) systems end-to-end such as analysis, development, visualization, storage. • Implement ETL pipelines regarding quality assurance of data and deploy them into production environments. • Developing and monitoring ETL jobs, reporting administration, analyzing and developing reports and dashboards. • Making analysis and planning about report requirements come from business units responding with T-SQL/PLSQL queries. • Responsibility of a weekly campaign which opens to about 30 million customers. • Ensuring data quality of ETL steps in data warehouse, improving code with SQL Tuning. • Preparing dashboards for the management teams. • Optimizing SQL queries and ETL performance to reduce process times and increase data quality. => Used tools and technologies : Oracle Data Integrator(ODI), Ab Initio, Oracle,Exadata, SQL Server(T-SQL), PL/SQL ,Microstrategy Show less

  • GTech (G Teknoloji Bilişim San ve Tic AŞ.)
    • Türkiye
    • IT Services and IT Consulting
    • 200 - 300 Employee
    • Veri Teknolojileri Akademisi
      • Jun 2018 - Aug 2018

      I received training on SQL, PL/SQL, DWH, OBI, ODI and Business Intelligence. I received training on SQL, PL/SQL, DWH, OBI, ODI and Business Intelligence.

  • sahibinden.com
    • Türkiye
    • Software Development
    • 700 & Above Employee
    • Intern
      • Jul 2016 - Sep 2016

      Quality Assurance (QA) Developer Quality Assurance (QA) Developer

Education

  • İstanbul Üniversitesi
    Bachelor's degree, Computer Engineering
    2012 - 2017
  • Eurocentres
    Eurocentres Language School/Brighton-United Kingdom
    2017 - 2017
  • KDZ. Ereğli Anadolu Lisesi
    2007 - 2011

Community

You need to have a working account to view this content. Click here to join now