$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Junior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Analyst
Nejat Mert ZILELI
,
London, United Kingdom
Experience
Skills
I'm offering
As a freelancer, I provide the following services:
-Data Wrangling (Python, SQL)
-Feature Engineering (Exploratory data analysis, handling the missing values, handling imbalanced dataset, treating the outliers, scaling down the data, converting the categorical features to the numerical features)
-Feature Selection
- Model Creation
-Hyperparameter Tuning
-Model Deployment
- Data Visualisation with POWER BI ( with DAX)
- Operational Research/ Mathematical Modelling
- Discrete Event Simulation/ Agent-Based Simulation
- Supply Chain Management/ Inventory Optimization
- Operations Management
-Data Wrangling (Python, SQL)
-Feature Engineering (Exploratory data analysis, handling the missing values, handling imbalanced dataset, treating the outliers, scaling down the data, converting the categorical features to the numerical features)
-Feature Selection
- Model Creation
-Hyperparameter Tuning
-Model Deployment
- Data Visualisation with POWER BI ( with DAX)
- Operational Research/ Mathematical Modelling
- Discrete Event Simulation/ Agent-Based Simulation
- Supply Chain Management/ Inventory Optimization
- Operations Management
Markets
United Kingdom
Industries
Language
English
Available
My experience
2021 - ?
job
Self-Employed Data Analyst
STACOMP AI.
• Delivered three data cleaning projects to three different clients from different domains, and achieved 20% improvement in the accuracy of machine learning algorithm. Python pandas, matplotlib, MS Excel is used.
• Analyzed time series data from 25000 store and store outputs to guide demand forecasts and inventory decisions; decreased the excess inventory rate by 2x, 10% increase in space utilization of the warehouse.
• Converted raw data into SQL with ETL application to prepare erroneous data for machine learning.
• Utilised Python (BeautifulSoup) and Spark to scrape, clean and analyse large datasets.
• Successfully designed dashboards and created dynamic documents, reports via MS PowerBI and MS Excel VBA to produce accurate information for senior management.
• Analyzed time series data from 25000 store and store outputs to guide demand forecasts and inventory decisions; decreased the excess inventory rate by 2x, 10% increase in space utilization of the warehouse.
• Converted raw data into SQL with ETL application to prepare erroneous data for machine learning.
• Utilised Python (BeautifulSoup) and Spark to scrape, clean and analyse large datasets.
• Successfully designed dashboards and created dynamic documents, reports via MS PowerBI and MS Excel VBA to produce accurate information for senior management.
Python, Excel, Sql, Machine learning, ETL, VBA, Management, Spark, Analyst, Guide
2020 - 2021
job
Inbound Stower
AMAZON.
Analyzed the time series data to identify the demand patterns using Python pandas and matplotlib. Evaluated forecasting models by monitoring the forecasting errors MAD, MSE, and MAPE. Showed the differences of each on MS Excel and PowerBI interactive dashboards/reports and analyzed what-if scenarios using simulation software to show how KPIs, inventory levels, workforce management were impacted by uncertainties.
• Promoted within 12 months due to strong performance and organizational impact.
• Identified steps to reduce inventory rates by 10% resulting in an eventual $75k cost savings.
• Promoted within 12 months due to strong performance and organizational impact.
• Identified steps to reduce inventory rates by 10% resulting in an eventual $75k cost savings.
2018 - 2019
job
Industrial Engineer
KONFOR- Izmir.
Lean Process improvement. Removed individual workstations in the packing line, introduced moving conveyor to the packaging& hand-craftmanship operations. Grouped workers in each side of the conveyor. Following the successful pilot project, this concept applied in 3 other lines in the factory. Processing time decreased from 1.20 minute mean to under 1 minute in all of handcrafting& packaging operations. Visualizations from PowerBI& MS Excel is used. Arena Simulations used to carry-out what-if analysis before extending the project scope.
Excel, Operations, Packaging, Lean, Processing, Mean
2016 - 2018
job
Optimization Engineer
BOSCH.
• Lean Process Improvement. Mathematical optimization of the production schedule. Automated the old and inefficient hand-made scheduling technique since it was not covering all constraints. It was causing high WIPs and chaos in shop-floor.
• Mathematical model created in IBM CPLEX Solver and a decision support interface had been built in MS Excel VBA. To prove the efficiency of this system, I compared the current state and improved state by using arena simulation software. Results: 41% Decrease in holding times of WIP. Reduction of 15% in the makespan.
LEADERSHIP
• Mathematical model created in IBM CPLEX Solver and a decision support interface had been built in MS Excel VBA. To prove the efficiency of this system, I compared the current state and improved state by using arena simulation software. Results: 41% Decrease in holding times of WIP. Reduction of 15% in the makespan.
LEADERSHIP
Excel, VBA, Leadership, Lean, It, Support, Software, Production
2016 - 2017
job
Team Leader
MPAL Tennis Club.
Prepared intense training program for beginner tennis players in the following Regional Tennis Cup. Won the cup as a team in 2017.
Training
My education
University of Nottingham
Bachelors, Industrial Engineering and Operations Research
Bachelors, Industrial Engineering and Operations Research
Izmir University of Economics
Bachelors, Engineering, Industrial Engineering
Bachelors, Engineering, Industrial Engineering
Nejat's reviews
Nejat has not received any reviews on Worksome.
Contact Nejat Mert ZILELI
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Nejat directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark