Ahmet Kalafat

I have a robust career profile with over 24 years of experience spanning education, retail, and technology sectors. I graduated from Abant İzzet Baysal University's Physics Department in 1999 and have since worked in different roles in BilgeAdam, Goldaş Kuyumculuk, and LC Waikiki. In BilgeAdam, I served as an office, web, sql server and software trainer, while simultaneously earning my master's degree in Financial Economics at Marmara University. I then transitioned into a Senior Analyst Software Developer role at Goldaş Kuyumculuk where i developed multiple business applications. I've been with LC Waikiki since 2010, progressing through various roles from a Business Intelligence Development Specialist (Data Engineer) to a Data Architect, eventually becoming the Big Data Management and Data Architecture Manager in 2017. I've implemented significant data projects, some of which have been published as success stories by Microsoft Global and Microsoft Turkey. I also lead a team of 18 people and manage over a million dollar budget. My core competencies include enterprise data architecture, data modeling, IT/data lifecycle management, AI developments, IT project management, team building, cross-functional business partnership, supplier management, business/process analysis, system & process development, and budget management, among others. I've also served on the board of directors of Cloudera User Group Turkey and have experience as a Scrum Master , Analytical Data Product Owner and Data Engineering & Architecture Chapter Lead..

• MCPD:Enterprise Application Developer(C# 2.0), 2008
• MCTS: Web Developer( C# 2.0), 2007
• MCTS: Windows Developer( C# 2.0), 2007
• MCTS: Distributed Applications ( C# 2.0), 2007
• MCP, 2001

Post Graduate Thesis, Development and Investment Incentives in Turkish Economy

• Gives importance to personal development, communication and teamwork
• Theatre
• Aquarium
• Travel
• Cinema
• Internet
• Model airplane

• Microsoft TR “SQL Saturday”, Building DWH using ColumStoreIndex in SQL Server 2016, 2016
• Microsoft TR “SQL Saturday”, OLAP Scale Out, 2017
• Beykent University (Computer Engineering Post Graduate students), Business Intelligence usage areas, what Business Intelligence does and what benefits it provides, 2018
• TRAI[Turkey Artificial Intelligence Initiative] Meetup, Artificial intelligence applications in retail, 2019
• Istanbul Data Science Academy, Analytical Data Architecture in LCWaikiki, ETL Offloading Projects, 2021

• BigQuery Basics for Data Analysts, cloudskillsboost.google, 2023
• BigQuery for Data Warehousing, cloudskillsboost.google, 2023
• Data Engineering, cloudskillsboost.google, 2023
• Preparing for your Professional Data Engineer Journey, cloudskillsboost.google, 2023
• BigQuery Partitioning & Clustering, cloudskillsboost.google, 2023
• Leadership Through Coaching, 2018
• Situational Leadership, 2017
• Toyota Style Lean Leadership, 2018
• Biplane leadership, 2017
• Analytical Thinking (Priority Analysis, Root Cause Analysis, Solution Analysis), 2016
• Cloudera DataScience – Komtaş (10 Days), 2019
• Cloudera Bigdata Enterprise Apache Spark – Komtaş (10 Days), 2019
• Cloudera Bigdata Admin – Komtaş (7 Days), 2019
• Statistics for Business Analytics AZ, Udemy(Kirill Eremenko), 2018
• Introduction to R, Datacamp, 2017
• A to Z Applied Hadoop and Big Data Training, Udemy(Erkan Şirin), 2017
• The Data Scientist's Toolbox, Johns Hopkins University, Coursera, 2017
• R Programming, Johns Hopkins University, Coursera, 2017
• Getting and Cleaning Data, Johns Hopkins University, Coursera, 2017
• Exploratory Data Analysis, Johns Hopkins University, Coursera, 2017
• Cloudera Data Analyst Training, Dilisim, 2016
• Cloudera Developer and Spark Training, Dilisim, 2016
• SQL Server Performance Tuning, Microsoft, 2011
• Software Engineering (MCPD C#), NETRON, 2007
• Software Engineering (MCSD.NET VB), NETRON, 2005
• Computer Expertise–(Office+Software+Hardware+Network), BilgeAdam, 2000
• English - ILM, 2000
• Web Design (Html-Dhtml-Javascript), A.İ.B.
• 1998/1999
• Introduction to Programming and Algorithm, QBasic, TPascal, A.İ.B.
• 1997/1998

Current references will be provided upon request.

DataPlatform Modernization(2023), We identified our pain points in the data warehouse and started a modernization project based on these. We model the data again in our Landing Staging Core and DataMart layers and we are doing our technology transformation on bigquery. Before choosing Google BigQuery, we did POCs with SnowFlake, Oracle, Vertica products. Although SnowFlake is a few steps ahead of BigQuery as a product, we decided on BigQuery with consultant and ecosystem parameters. We are advancing our project using DataFlow and DataForm on BigQuery., 2023 DOAR(2022), We had difficulties in presenting the DOAR (Detailed Option Analysis Report) that we developed as SQL Server Tabular Service in OnPremise on Powerful servers. This system had over 1200 unique users and the usage trend was decreasing from Monday to Friday. We transformed this project in Azure Cloud using AzureDataFactory, Azure Synapse, BlobStorage, AzureAutomate and Azure Analysis Service. With this project, we earned a cost of $110,000, achieved high customer satisfaction, and reduced the number of support calls by 100 calls per month. Our project won the 2nd Prize in the field of IDC Cloud Cost Efficiency., 2022 Data Democratzation With GCP(2022), We moved our finance data marts to Google Bigquery and enabled our customers to perform Self-Service analysis with Googlesheet., 2022 Bigdata ETL Offloading Project-2019, Over 50 of our most resource consuming ETL processes on DWH have been redeveloped with spark in the BDA environment. Earned 200K$ SQL License per Year (- 320K$ SQL, + 120K Cloudera). Our data processing performance has improved by 15 times on average and by 120 times at the maximum. Our longest data collection job decreased from 5 months to 2 weeks. Reduced CPU requirement on DWH. I ensured the dissemination of BDA in data science, data analytics, business analytics teams and other stakeholders. The success story of our project was published by Komtaş. We used Hive, Impala, Sqoop, Spark, Scala, Airflow, Yarn and Cloudera Manager in this project., 2019 DWH with ColumStoreIndex & Always On in SQL Server 2014, With the examination of SQL Server 2014 innovations, I have achieved the data warehouse architecture to be changed from fasttrack to columnar (Column Store index) structure, to provide HA with Always on, query time optimization up to 4000% and a compression ratio of 35X with the architectural change. I personally oversaw this project and transition. The project was presented at SQL Saturday 2014., 2014 LC Waikiki's First Data Warehouse with Fast Track Reference Architecture, We have developed the first Fast Track Architecture data warehouse in Turkey from scratch, designed with Star schema and kimball model. And updated the compression ratio from 4X to 7X from the ms whitepapers on SQL Server 2008 R2. The project was published by Microsoft as a success story. The tables in the data warehouse are updated only with insert and partition swapping, with the partition swap method designed in a partition structure, so that fragmentation does not occur and fast data loading is ensured., 2010 ETL/SSIS Framework, It is the structure that carries out the process of collecting the data in the OLTP system to the data warehouse with SSIS technology. It communicates different data collection methods with the SSIS template structure in the background, ensuring data collection while maintaining integrity. It supports and executes data aggregation methods by capturing the last x days, consecutive y-day blocks or changing records according to the specified time interval. ETL/SSIS templates. In the sense of rapid development, it enables updating the relevant table/datamart in the data warehouse in integrity by making only inserts in the partiton structure. are drafts. OLAP Processing Framework, It is the structure that allows updating the 15 TB OLAP cube. Provides updating by capturing the changing days in the data warehouse and ensuring integrity Tabular Processing Framework, Integrated with the data warehouse of up to 80 tabular cubes, it is updated on the process servers and synced to the production environment. OLAP ScaleOut, Enables high availability in OLAP cubes as Active-Active. You can set up a distributed structure by placing as many nodes as you want behind the F5 lad balancer. It makes your hours of OLAP updates with 100% uptime on your Olap cube systems. LCWGlobalCube(MultiDimensional OLAP Cube), It is the largest and fastest OLAP cube project in the EMEA region with a size of 15 TB with Microsoft SSAS infrastructure. OLAP Tabular, I took part in optimization studies of nearly 70 projects Pakhet.com, E-Commerce-Marketing Platform where MLM-Multi-Layer Marketing Model and Direct Sales model are combined, where more than one supplier can track their own stocks and sell them. (7 months) [ ASP.NET 2.0 , SQL 2005, T-SQL, Ajax, XML Web Services, Windows Services] FEMSGEM, Special E-Commerce (BTC-BTB), CRM, Call Center applications that allow multi-site management of the jewelry industry. (Tübitak supported project)(36 Months) [ASP.NET 2.0, SQL 2005, T-SQL, Ajax] Goldas.com, Corporate and E-Commerce-Marketing site of Goldas Jewellery. (8 Months) [ ASP.NET 2.0, SQL 2005, T-SQL, Ajax] Chipgold.com, Chipgold E-Commerce site. (1 Month) [ASP.NET 2.0, SQL 2005, T-SQL, Ajax, OOP] Goldas / Accounting, An integrated, multilingual program that automatically creates the basic accounting activities of holding companies in line with the data coming from other commercial programs, opens automatic accounts, and can receive multi-currency Trial Balance, Assistant, P&L Reports. (14 Months), [ASP.NET 2.0, SQL 2000, T-SQL, Ajax] Goldas / Current, An integrated, multilingual program where payment orders can be created parametrically, and payment days and approvers can be selected parametrically for each Firm that Holding companies track Current. (6 Months) , [ASP.NET 2.0, SQL 2000, T-SQL, Ajax] Goldas / Treasury, A multilingual program in which Goldaş's Treasury Department's transactions in the Futures Market in Dubai are recorded and reported. (Dubai Futures Market has been studied and analyzed) (6 Months) [ASP.NET 2.0, SQL 2000, T-SQL, Ajax, XML Web Services, Windows Services] Goldas / GOS (Goldaş Automation Systems), A system that gathers all web-based programs used by holding companies under one roof, regardless of the technology used, with a single user name and password entry. (1 month) [ASP.NET 1.1, SQL 2000, Ajax] Goldas / Finance, A program that enables holding companies to execute and manage financial transactions. There are Cash, Deposit, Credit, Leasing, Check, Promissory Note, Guarantee, Deposit, Blocked Check and Fund management module. (18 Months), [ASP, SQL 2000, T-SQL, Ajax, JavaScript, XML] Goldas / Insurance-Contract Tracking, A program that enables Holding Companies' Contracts and Insurances to be entered with dynamically created contract forms, to execute and track transactions. (3 months), [ASP, SQL 2000, T-SQL, Ajax, JavaScript, XML]