Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic
Alpay Sahin

Alpay Sahin

Data Scientist For Parts Pricing
Tokyo,

Summary

Alpay is a results-driven data scientist and SAP consultant with over 5 years of experience using state-of-the-art technologies and a rich background of internships.
He has developed in-house pricing solutions, applied machine learning for pricing optimizations, and built robust data pipelines and dashboards that generated significant cost savings.
Renowned for his can-do mentality, clear communication, and commitment to underpromising and overdelivering, he consistently achieves outstanding performance, as reflected in annual evaluations and a salary increase of over 65%.
Now, Alpay is seeking new challenges for personal growth and further professional development.

Developed robust analytical and problem-solving skills in data-intensive environment, focusing on extracting actionable insights from complex datasets. Demonstrates expertise in statistical analysis, machine learning, and data visualization for effective decision-making. Seeking to transition into new field, bringing data-driven approach and commitment to innovative solutions.

Overview

7
7
years of professional experience
3
3
Languages

Work History

Data Scientist for Parts Pricing

Mitsubishi Fuso Truck and Bus Corporation
10.2022 - Current

Completed projects

  • Applied machine learning algorithms using Python to detect price outliers based on part's technical value drivers, costs, competitor prices, and competitive intensity, leading to price corrections that improved annual contribution margin by over 100M JPY.
  • Replaced an external Pricefx SaaS pricing system with an in-house solution developed in PySpark on Databricks, achieving annual cost savings of over 10M JPY.
  • Replaced several UIPath automations with Python, achieving annual cost savings of 1M JPY.
  • Developed a SSOT for spare parts cost by integrating 5 cost sources in Databricks, categorizing parts, and allocating the correct cost source. Connected it to Excel via xlwings and the Databricks API. Deployed SSOT across the finance organization.
  • Developed a Rules & Alerts pipeline in Python and SQL to notify stakeholders when a part's contribution margin falls below the minimum threshold due to cost fluctuations. The pipeline runs daily to ensure compliance with internal corporate audit requirements, preventing sales below the minimum CM%.
  • Developed Power BI dashboards with a Databricks backend to visualize sales quantities, sales prices, costs and contribution margins across various aggregation levels (part number, part category, competitive intensity) using Python, SQL, and Power BI.
  • Created a data comparison pipeline in SQL for over 10 tables and 100+ million records, identifying data transfer issues from SAP ERP to BW/4HANA. Supported the BW team in pinpointing and correcting code errors in BW, achieving 100% data quality.
  • Automated 90% of the daily data collection for Parts Pricing using Python, SQL, and VBA, reducing the pricing team’s workload by 20%.

SAP Data & Analytics Consultant

Atos SE
03.2022 - 09.2022
  • Completed an intensive 8-week onboarding program covering both technical skills and soft skills for consultants.
  • Implemented an E2E WBS cost tracking application with SAC as the frontend and BW4/HANA as the backend, programmed in ABAP and JavaScript.
  • Demonstrated and trained clients on SAP frontend solutions, including SAP Analytics Cloud and SAP Analysis for Office.

Bachelor Thesis Student in SAP Authorization Mgmt.

SIVIS GmbH
09.2021 - 02.2022
  • Co-authored and served as the main researcher on "On using Authorization Traces to Support Role Mining with Evolutionary Algorithms," published in the Proceedings of the 14th International Joint Conference on Computational Intelligence (IJCCI 2022).
  • Conducted data analysis and visualization using Python (Pandas, NumPy, Seaborn, and Matplotlib)
  • Applied machine learning algorithms to develop an automated method for creating SAP ERP role concepts from authorization trace data.

Working Student in Change Mgmt. HDEP

Daimler Truck AG
03.2021 - 08.2021
  • Automated the monitoring and management of project tasks using Python and SQL by implementing a tiered reminder system - automatic alerts as due dates approach, follow-up notifications with CCs to managers and senior managers after deadlines - reducing task completion delays by 80%.
  • Developed a Power BI report to monitor and visualize task progress across projects, enhancing oversight and decision-making.

Working Student in E-Procurement

United Internet AG
03.2020 - 02.2021
  • Supported the customization of the cloud-based procurement platform Coupa
  • Automated routine tasks using Power Automate

Intern in Customer Services Eng. (CSE)

Mitsubishi Fuso Truck and Bus Corporation
09.2019 - 02.2020
  • Coordinated cross-functional teams to ensure Customer Services availability for new vehicle launches.
  • Created PowerPoints and Reports for Senior Management about CS readiness across different markets

Working Student in Logistics (CKD)

Daimler Truck AG
10.2017 - 08.2019
  • Supported inventory audits by identifying discrepancies between actual stock and ERP data, contributing to process improvements.
  • Analyzed inventory data to optimize storage solutions, reducing costs and minimizing delays.

Education

B. Sc. - Business Administration And Engineering

Karlsruhe University of Applied Sciences
Karlsruhe, Germany
04.2001 -

Skills

Python

SQL

PySpark

Power BI

Statistical Analysis

VBA

SAP Analytics Cloud

SAP BW/4HANA

Machine Learning

Additional Information

  • Nationality: German
  • LinkedIn: linkedin.com/in/alpay-s/
  • Publication: scitepress.org/publishedPapers/2022/115393/pdf

Timeline

Data Scientist for Parts Pricing

Mitsubishi Fuso Truck and Bus Corporation
10.2022 - Current

SAP Data & Analytics Consultant

Atos SE
03.2022 - 09.2022

Bachelor Thesis Student in SAP Authorization Mgmt.

SIVIS GmbH
09.2021 - 02.2022

Working Student in Change Mgmt. HDEP

Daimler Truck AG
03.2021 - 08.2021

Working Student in E-Procurement

United Internet AG
03.2020 - 02.2021

Intern in Customer Services Eng. (CSE)

Mitsubishi Fuso Truck and Bus Corporation
09.2019 - 02.2020

Working Student in Logistics (CKD)

Daimler Truck AG
10.2017 - 08.2019

B. Sc. - Business Administration And Engineering

Karlsruhe University of Applied Sciences
04.2001 -
Alpay SahinData Scientist For Parts Pricing