Yiğitalp Özmen

(sr) Supply Chain Manager | Logistics Supplier Manager Apr 2022 - Present

ASML, Netherlands

Driving operational excellence performance at suppliers to secure 95% On-Time-In-Full (OTIF) delivery performance by analyzing monthly OTIF data.
Investigating capability for the capacity groups of the suppliers against move rates by preparing and analyzing forecast data via using SAP ECC.
Creating a repair order dashboard for a supplier to support the re-use of materials by using Power Query.
Preparing and maintaining a KPI dashboard to measure suppliers’ logistics performances on a monthly basis.
Preventing and resolving critical material escalations by using demand and supply data analytics tool based on SAP BO Analysis for MS Excel.

Team Lead | Supply Chain & Operations Data Analytics Oct 2018 - Mar 2022

Turkish Aerospace, Turkey

Leading a team of 4-8 junior/senior data analysts to design and implement Power BI dashboards, automated, and paginated reports by merging data from various data pipelines for detailed production schedules to minimize costs and lead times.
Identifying bottleneck processes to balance and optimize material flow by creating business rules regarding the capacity of work centers via Power BI dashboards.
Generating ad-hoc Power BI dashboards and paginated reports to compare plan vs. actual in supply chain by embedding T-SQL queries from the ERP/MRP database.
Sales and operations planning to meet customer demands by accordingly allocating supply resources align with production rates and capacity by embedding T-SQL queries into MS Excel spreadsheet to bettter analyze the workload data.
Conducting process improvements by solving batching and scheduling optimization problems by collecting process data and deploying Python code using pandas and numpy packages for data preprocessing and mip package for prescriptive analytics in Anaconda/Spyder IDE via procedural programming.
Planning the capacity and optimizing its utilization for both satisfying ERP/MRP constraints and saving the raw materials with a limited shelf life by ETLing BoM and MES data.

(sr) Data Analyst | Supply Chain & Operations Feb 2016 - Sep 2018

Turkish Aerospace, Turkey

Generating shortage reports via SSRS for procurement and outsourcing departments via both T-SQL querying and drag&drop related tables.
Translating complex and large data into descriptive Power BI KPI dashboards to derive insights for the managers on different levels.
Coaching junior colleagues in terms of business practices and strategies on how to utilize Business Intelligence, Data Analytics, Reporting, and Operations Research tools: MS Excel (formulas, lookups, pivot tables & Power Query), Power BI, Python, SSRS, and T-SQL (relational database management, joining/merging tables & wrangling large scale data sets).
Analyzing current capacity vs. workload on-hand to create fill-up strategies to utilize remaining capacity by writing T-SQL queries in MS Excel via ODBC.
Optimizing the schedules of First Cut, Conventional & NC Machines by writing Python code using pandas and numpy packages for data preprocessing and mip package for prescriptive analytics in Anaconda/Spyder IDE via procedural programming.
Proposing improvement solutions to better utilize production capacities without violating assembly lines’ structured work breakdown schedules and end items' delivery times by performing descriptive, diagnostic, and prescriptive data analytics.

(jr, mr) Data Analyst | Supply Chain & Operations Feb 2014 - Jan 2016

Turkish Aerospace, Turkey

Developing Kanban to determine WIP quantities as business rules for scheduling the complex parts consisting of many production steps by writing T-SQL queries in SSMS for SSRS and SAP BO Crystal Reports.
Creating requirement and WIP reports to generate production plans and monitor them on a daily basis by writing T-SQL queries in SSMS for SSRS and SAP BO Crystal Reports.
Keeping lot size, lead time, order policy, and safety stock parameters of ERP/MRP system up-to-date by creating lot size and (remaining) lead time determination reports based on historic transactional data by writing T-SQL queries in SSMS for SSRS and SAP BO Crystal Reports.

Developing automated processes to track order signals and create business rules by writing T-SQL queries in SSMS for SSRS and SAP BO Crystal Reports.

Over