Alihan Öncel

Data Analytics Team Lead at Trendyol Group

Istanbul, Istanbul, Türkiye

About

Data Analyst with 5+ years track record of analyzing business intelligence, detailed report regarding churn, sales, financial situation of the company. Seeking to leverage skills and experience to guide business decision.

Experience

  • Trendyol Group (Istanbul, Türkiye)
    • Finance Analytics Team Lead
      Jul 2025 - Present · 1 yr

    • Senior Data Analyst/FBP
      Jul 2023 - Jul 2025 · 2 yrs 1 mo

    • Data Analyst/FBP
      Nov 2022 - Jul 2023 · 9 mos

      - Create daily automated report with the help of Python by using BigQuery and Google Sheets APIs - Develop custom data models and algorithms in Looker to provide them to business teams - Calculate company's financial KPI in BigQuery - Make prediction and forecast about company's financial KPI with ML algorithms (Prophet, statsmodels) Tool: Google Cloud Platform, BigQuery, Looker Programming Language: Python, Google Apps Script Querying Languages and Tools: PostgreSQL Project Management and Documentation Tools: Jira, Confluence Version Control System Tools: GitLab

  • Data Analyst at Getir
    Apr 2022 - Nov 2022 · 8 mos

  • DocPlanner (3 yrs 7 mos)
    • Global Enterprise Data Analyst, tuOtempO
      Dec 2021 - Apr 2022 · 5 mos

    • Data Analyst
      Dec 2019 - Jan 2022 · 2 yrs 2 mos

      - Improve the efficiency of ETL processes for all dashboards - Provide clear and actionable reports to Sales and Customer Success, Management - Support daily operations of Finance Team to run efficiently - Visualize all dashboards in BI Tools - Automate some reports with the help of Python/Google Apps Script Tools: Google Data Studio, Looker, Google Cloud Platform, Tableau, G Suite, Microsoft Excel Programming Languages: Python, Google Apps Script Querying Languages: MySQL, BigQuery, PostgreSQL

    • Jr. Finance Specialist
      Oct 2018 - Dec 2019 · 1 yr 3 mos

      - Check new sales and reporting discrepancies within one day - All reported issues related to dashboards have been resolved within 2 days and improvements requested by Sales and CS management have been completed within given deadlines - Apply price changes within one day - Prepare and submit recurring and Ad Hoc reports with no errors within their deadlines.

  • Legal Reporting and Financial Control Intern at Türkiye Finans Katılım Bankası
    Feb 2017 - Jun 2017 · 5 mos