Hakan Aras Email & Phone Number

İstanbul, Türkiye

- Followed literature and develop partnerships and touch points with key stakeholders to evaluate data sources, parameters, test, optimize and automate refresh processes with using ML algorithms.- Developed enterprise-scale dashboards and reports, implement row-level security, optimized, and automated multiple complex data sources with Power BI.- Performed general database administrative tasks including user account management, access control, backup operations, database optimization… Show more - Followed literature and develop partnerships and touch points with key stakeholders to evaluate data sources, parameters, test, optimize and automate refresh processes with using ML algorithms.- Developed enterprise-scale dashboards and reports, implement row-level security, optimized, and automated multiple complex data sources with Power BI.- Performed general database administrative tasks including user account management, access control, backup operations, database optimization and error resolution.- Performed analytical project related to People Analytics by manipulating data (cleaning, merging, transforming, analyzing) using tools such as Microsoft Excel, SQL, R, and Python. Show less

- Analyzed the relationship between employee performance and sales data by using training exam results to obtain maximum benefit from training and minimize training costs.- Created a branch manager profile for branch clusters using branch managers’ demographic profile, work performance and company exam results with machine learning methods such as logistic regression, decision tree and k-means.

Course Name: Computational Methods for Industrial Engineering (01/2018 – 06/2018)Conducted problem solving sessions and assisted students with their assignments about Excel and Visual Basic.Course Name: Calculus I (09/2018 – 01/2019)Conducted problem solving sessions and assisted students with their assignments.Course Name: Financial and Managerial Accounting (01/2019 – 06/2019)Conducted problem solving sessions and assisted students with their… Show more Course Name: Computational Methods for Industrial Engineering (01/2018 – 06/2018)Conducted problem solving sessions and assisted students with their assignments about Excel and Visual Basic.Course Name: Calculus I (09/2018 – 01/2019)Conducted problem solving sessions and assisted students with their assignments.Course Name: Financial and Managerial Accounting (01/2019 – 06/2019)Conducted problem solving sessions and assisted students with their assignments.Course Name: Introduction to Financial Engineering (09/2019 – 01/2020)Conducted problem solving sessions and assisted students with their assignments. Show less

- Prepared a project for label controls using artificial intelligence and OCR technology with this project gained man hour by removing possible errors.- Improvements have been made and analyzed reports for easier analysis of the company’s KPI reports via excel.- Work is carried out in the project team to increase the productivity of the production line and autonomation of the machines.

- Prepared monthly NPS reports which uses customer feedback data to improve customer experience.- Assisted data analytics team to have better understanding of customer expectations and to identify possible business opportunities.

- Observed daily warehouse actions, including handling, packing and logistical challenges in FMCG- Developed daily logistics software to decrease manhour via Excel Visual Basic- Observed how logistics contract is performed and took an active role calculating warehouse cost such as warehouse calculation, bonded warehouse, Co-Packing, Shuttle and National Transportation to prepare request for selecting new Warehouse- Took active role supply chain operations and observed receiving… Show more - Observed daily warehouse actions, including handling, packing and logistical challenges in FMCG- Developed daily logistics software to decrease manhour via Excel Visual Basic- Observed how logistics contract is performed and took an active role calculating warehouse cost such as warehouse calculation, bonded warehouse, Co-Packing, Shuttle and National Transportation to prepare request for selecting new Warehouse- Took active role supply chain operations and observed receiving order from Traditional Markets to how to fair distribution activities are performed weekly at Supply Chain Department Show less

Sabiha Gökçen International Airport

- Took an active role in develop and optimize engineering daily operations Approved Technical Data (ATD) revision control- Provided technical support to the engineering projects such as developing new software to reduce the manhour by SQL and Visual Basic- Designed and developed program to check the engine tooling revision compatibility on tool database by SQL and Visual Basic- Observed how aircraft engine testing is performed and learnt how to analyze and optimize engine… Show more - Took an active role in develop and optimize engineering daily operations Approved Technical Data (ATD) revision control- Provided technical support to the engineering projects such as developing new software to reduce the manhour by SQL and Visual Basic- Designed and developed program to check the engine tooling revision compatibility on tool database by SQL and Visual Basic- Observed how aircraft engine testing is performed and learnt how to analyze and optimize engine performance Show less

Bachelor'S Degree, Industrial Engineering, Gpa : 3.45

Activities and Societies: IEEE MEF, MEF University Student Council

Minor Degree, Computer Engineering, Gpa: 3.20

Education record