Collecting and analyzing companies' needsDesigning and developing dashboards (e.g. excel, power bi)-Data analysis-Data visualization

Forecast preparationTaking part in WCM studiesProduction costs are monitored and controlledProcess improvement studies are carried out.Kaizen processes are managed in co-operation with factory departments

-Budget analysis -Inventory analysis -Reporting (forecast,actual,budget)-Data visualization (Power BI)During my working time, I systematized similar works on excel with vba macros. By saving time with macros, I directed my workforce to jobs where I would be more productive.I created reports from scratch for sales, purchasing, stock data on Power BI.I mostly processed the data on Power BI with dax codes.In the existing reports, I made improvements to minimize the problems encountered in excel, since it works with large data in excel. (Excel VBA)I commissioned the transfer of the stock report managed on Excel to the ERP system together with the IT department.All these processes are carried out for 2 different sectors (white goods & construction) and 8 companies in total at the headquarters of the company, which employs a total of 4000 people

-Demand forecasting and planning -Analysis and reporting -Inventory tracking -Supply chain

-Production scheduling -Working on OEE data, I took part in reflecting the current situation and presenting solution suggestions. - Within the scope of the graduation project, I took part in solving the machine scheduling problem for the press shop. I designed a decision support system on Excel VBA.

I have observed the lean production approach concretely. -I learned the relationship between the ERP system used in the business and the PPC unit.

I learned about the functioning of the ERP system in the company. -I observed the R&D working environment. -I learned the relation between BOM concept and ERP system.