Istanbul, Türkiye
-Senior Business Intelligence Consultant(NTT Data Business Solutions, July 2021-Present) -Associate Material Planning & Control(Pfizer Türkiye , Feb 2020-June 2021) -Marketing Part Time(Pfizer Türkiye , May 2019 - Jan 2020) -Sales and Operation Intern(L'Oreal Türkiye , Apr 2018 - May 2019) -Process and Quality Intern(KoçSistem Bilgi ve İletişim Hizmetleri , Nov 2017 - Apr 2018)
- Participated data warehouse (DWH) development projects, overseeing end-to-end processes such as requirements analysis, solution design, system testing, data quality monitoring, and building robust dimension and fact tables. - Integrated and managed data flows from various large-scale data sources (Hadoop, MongoDB, Google Cloud etc.) into Vertica, and automated data mart scheduling using Azkaban for one of Turkey’s largest online classifieds platforms. - Gathered business requirements, wrote complex queries (T-SQL, MySQL) for customized dashboards and reports. - Defined KPIs and conducted advanced analytics (funnel, conversion, and A/B test analysis) to support business decisions. - Troubleshot user issues, redeveloped user reports based on evolving needs, and ensured testing accuracy. - Managed the migration from QlikView to Tableau, designing scalable data models and developing dynamic dashboards and reports to meet evolving business needs. - Measured and optimized the performance of data marts, Tableau, and QlikView models in a big data environment, handling extremely large datasets and high-volume data sources. - Used critical thinking to break down problems, evaluate solutions and make data-driven decisions
-Participation in Pernod Ricard Turkey ,Mercedes Benz Global BI , Sun Textile Sustainability, Internal HR and several projects. -Experience in Power BI Cloud and Report Server, SQL Management Studio, Tableau, SAP HANA tools for Eclipse. -Responsible for the creation, editing and development of Supply Chain, Finance and Sales datasets via PowerBI and SQL Server. -Creating a Data Warehouse and Datamarts using SQL server. -Optimizing PowerBI-Query performance and accelerated processing speed. -Perform data cleaning, transformation and modeling for accurate and reliable analysis. -Performing data analysis and prediction of the relevant computer game using Python and AI systems within the scope of a personal goal project.(Football Manager) -Implementation of business intelligence solution for family business using Bigquery and Looker.
-Responsible for Receiving , Rejected Good and Customer Returns warehouses. Analyzing and preparing storing and shipping KPI's of Pfizer Distribution Center warehouses. -Managing a team with 1 foreman and +10 warehouse operators efficiently for all storing and shipping materials on time; ensuring all activities to be compliant with RHS/GMP rules, regulations and local procedures. -Assisting warehouse process improvement and development projects(EDispact, Field Management etc.) -Using SAP ECC/WM modules in warehouse operations. -Planning and organizing material and finished good transfers between contracted manufacturing sites and Pfizer Distribution Center checking the stock levels of sreceiving , rejected good an customer returns warehouses.
-Coordinating Social Listening Project for Hospital Business Unit(about user trends) -Collecting user behaviour data and conducting academic research for Social Listening Project -Analyzing and interpreting Dermatology Products Campaign Assisting product launches and sales plans -Responsible for creating Montly Competition and KIT reports -Assisting all manner of Marketing process for Regional Healt Summits