Please complete the CAPTCHA to continue
A concise factual answer block for searchers comparing this professional profile.
Hakan Erten is listed as LC Waikiki şirketinde Data Architect at LC Waikiki, a with 10943 employees, based in Istanbul, Turkey. AeroLeads shows a matched LinkedIn profile for Hakan Erten.
Hakan Erten previously worked as Data Architect at Lc Waikiki and BI Developer at Lc Waikiki. Hakan Erten holds Bs, Art History from Mimar Sinan University Of Fine Arts.
This section adds company-level context without repeating Hakan Erten's masked contact details.
Review company-level records connected to Hakan Erten before choosing the right outreach path.
Experienced Business Intelligence Developer with a demonstrated history of working in the retail industry. Strong information technology professional skilled in Databases, Data Warehousing, Management Information Systems (MIS), Business Intelligence, and OLAP.
Listed skills include Microsoft Sql Server, Business Intelligence, Analysis Services, Ssrs, and 28 others.
Company context helps verify the profile and gives searchers a useful next step.
A career timeline built from the work history available for this profile.
İstanbul, Türkiye
Along with my other responsibilities GCP Big Query transformation project. -Analysis, planning and transformation project for moving DWH systems from sql server to gcp bigquery. -Creating the architectural schema to be used in Big Query. -Creating a layered data structure. -Converting SSIS packages to dataflow and dataform according to the new architectural structure. -Creating the scheduling of the related tasks on Composer.
Istanbul, Turkey
- Lead BI Developer, Scrum Team Member.- End to end design and implementation of DWH,ETL and OLAP.Main responsibilities:- Created databases and schema objects including tables, indexes, stored procedures and functions as a part of DWH development.- Built SSIS packages and scheduled jobs to migrate data from disparate sources into SQL server and vice versa- Performed root cause analysis on failures. Resolve performance tuning related issues and queries- SQL tuning, ETL tuning, OLAP Memory & CPU Optimization.- Wrote SQL queries to aggregate data such as profit margin, cost per sales, revenue per Sales.- Creation of analytic reports based on the design in SSRS and Power BI.- POC studies for system updates.- Worked on Microsoft Team Foundation Server (TFS) and Git.-Transfer of data from OLTP to Big Data Cluster with ETL operations (sqoop). Processing of raw data from OLTP and preparing datamart tables (spark, impala, hive). Integration of these data into DWH systems (sqoop, airflow).Information about analitic systems used:DWH- SQL Server 2017- AlwaysOn(2 node)- 40+TB data size.- 400+ table.- 75,000+ transactions per second during peak period.- 700+ unique users.- 2 Billion + row data manipulation every day.- Table partitioning- Columnstore Index- Kimball ModelBigData Cluster-Cloudera cdh6.3.0-1 Edge, 3 Master, 11 Data Node-5760G Ram-984 Core-1,6 PB DiskMultidimensional OLAP Cube- SQL Server 2012- High Availability & Scalability (2 node)- 10+TB data size.- 1000+ unique users.- 1.2 seconds average response rate.Tabular OLAP Cube- SQL Server 2016- 80+ tabular project.- Separate servers for process and presentation.- Custom framework for Schedule, Process and Sync.
Istanbul, Turkey
Performing all ETL processes to be used for transition from Tames program to Trax program on SSIS in Trax MRO Project and performing data cleaning with MSSQL scripts. A total of 27 GB of data has been transferred to nearly 110 tables in Oracle Database. Preparation of QlikView analysis in Trax project.To develop reporting and business intelligence projects needed by various departments in MSSQL and Sharepoint systems.
Sefaköy
Bayrampaşa
Other employees you can reach at lcwaikiki.com. View company contacts for 10943 employees →
Aydın Akyol
Colleague at Lc WaikikiIstanbul, Türkiye, Turkey
View →
ZA
Zuhal Aksu
Colleague at Lc WaikikiKonak, İzmir, Türkiye, Turkey
View →
BU
Baran Ureyil
Colleague at Lc WaikikiIstanbul, Türkiye, Turkey
View →
TK
Tarza Kamal
Colleague at Lc WaikikiSulaymaniyah, Sulaymaniyah Governorate, Iraq
View →
MA
Mehmet Adıguzel
Colleague at Lc WaikikiFatih, Istanbul, Türkiye, Turkey
View →
DR
Dhan Raj
Colleague at Lc WaikikiDubai, United Arab Emirates
View →
MB
Merve Bacin
Colleague at Lc WaikikiIstanbul, Türkiye, Turkey
View →
EK
Esme Köse Gedik
Colleague at Lc WaikikiIstanbul, Türkiye, Turkey
View →
AB
Asmae Bakhoukh
Colleague at Lc WaikikiMeknes, Fès-Meknès, Morocco
View →
MK
Mustafa Karaahmet
Colleague at Lc WaikikiIstanbul, Türkiye, Turkey
View →
Quick answers generated from the profile data available on this page.
Hakan Erten works for LC Waikiki.
Hakan Erten is listed as LC Waikiki şirketinde Data Architect at LC Waikiki.
Hakan Erten is based in Istanbul, Turkey while working with LC Waikiki.
Hakan Erten has worked for Lc Waikiki, Turkish Airlines Technic, Collezione, Özen Group, and İsmar Marketler Zinciri.
Hakan Erten's colleagues at LC Waikiki include Aydın Akyol, Zuhal Aksu, Baran Ureyil, Tarza Kamal, and Mehmet Adıguzel.
You can use AeroLeads to view verified contact signals for Hakan Erten at LC Waikiki, including work email, phone, and LinkedIn data when available.
Hakan Erten holds Bs, Art History from Mimar Sinan University Of Fine Arts.
Hakan Erten is listed with skills including Microsoft Sql Server, Business Intelligence, Analysis Services, Ssrs, Ssis, Olap, Data Warehousing, and Sql.
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial Search contactsCheck these profiles if this is not the Hakan Erten you were looking for.
