Emre Celik Email & Phone Number

Rolling Meadows, Illinois, US

• Experienced in designing and implementing end-to-end supervised & unsupervised machine learning models using Python.
• Built predictive models and data-driven analyses to support strategic business decisions.
• Built CI/CD Pipelines using Azure DevOps Pipelines (YAML) and Databricks Clusters & Jobs & Notebooks. (REST API, Databricks CLI)
• Improved performance by identifying potential claims using supervised machine learning techniques of Gradient Boosting (CatBoost, XGBoost) and Decision Tree / RF.
• Created Python package to automate model training process, including compare/monitor model performance with different classification & regression algorithms, hyper-parameter optimization, log performance metrics and.
• Provide testing, deployment, maintenance, and performance assessment of existing predictive models.

Rolling Meadows, IL, US

• Designed ETL process dealing with different data sources and loaded data into target data sources with manipulations using Python libraries.
• Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from MS SQL database.
• Creating Reports and Dashboards by using different BI Tools (Power BI, Salesforce Reporting)
• Execute data migrations and data quality efforts focused on completeness, standardization, and deduplication.
• Retrieve and analyze data using Data Loader, DemandTools and other data management/BI systems.

Berwyn, PA, US

• Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Designed ETL process dealing with different data sources and loaded data into target data sources by performing transformations using Python libraries.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Developed VBA-driven tool to maintain and update sales territories to help support sales team.

Chicago, IL, US

• Data Science - Part Time
• Instructed 35 students on descriptive statistics, elementary probability rules, sampling, distributions, confidence intervals, correlation, regression and hypothesis testing, hands-on learning of applications using.
• Application of statistical concepts and techniques to a variety of problems in IT areas and other disciplines, using statistical and other packages for simple data analysis.
• Course topics include descriptive statistics, elementary probability rules, sampling, distributions, confidence intervals, correlation, regression and hypothesis testing.

İstanbul, ., TR

• Analyzed performances of business processes and users according to KPI values to improve operational efficiency by developing complex SQL Queries using joins, sub queries and correlated sub queries.
• Created complex Triggers, Tables, Views and SQL Joins and other statements to maintain referential integrity and implement complex business logic.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Experienced in ETL processes involving migrations and in sync processes between two databases.
• Experienced in maintaining one to many and many to one relationship while moving data betweentwo databases.
• Experienced designing visual report solutions, including dashboards and visualization/dashboard tools.

Istanbul, TR

• Leading brand in the apparel and fashion sectors in Turkey with 464 stores, $500+M annual and 11.000+ employees
• Developed categorical financial budget plans to achieve sales and profit goals using Excel (Pivot Tables, Macros and complex Formulations), BI & OLAP cube reports and reported to the C-Level.
• Demand forecasting based on historical performance and recommend actions comparing with historical real performance data from OLAP Cubes.
• In pre-season and in-season OTB and financial planning, replenishment, assortment, inventory forecasting and merchandise allocation for 800+ SKU's.
• Formulated 10%+ Sales growth and 5%+ Inventory turnover through sales reports, markdown strategies.

İstanbul, Bağcılar, TR

• Developed categorical financial budget plans to achieve sales and profit goals using Excel (Pivot Tables, Macros and complex Formulations), BI & OLAP cube reports and reported to the C-Level.
• Demand forecasting based on historical performance and recommend actions comparing with historical real performance data from OLAP Cubes.
• In pre-season and in-season OTB and financial planning, replenishment, assortment, inventory forecasting and merchandise allocation for 800+ SKU's.
• Formulated 10%+ Sales growth and 5%+ Inventory turnover through sales reports, markdown strategies.

Istanbul, TR

Project: Identification of Customer Clustering Criteria by using WEKA / K-means Clustering

Istanbul, TR

Project: Investigation of Factors Affect Man-Hour Durations of Maintenances

Data Science

Master Of Business Administration - Mba, Business Administration And Management, General

Bachelor'S Degree, Industrial Engineering