Summary
Overview
Work History
Education
Websites
Certification
Projects
Timeline
Generic

Aytac Karacalioglu

SAP BW HANA Consultant
Berlin

Summary

As an experienced consultant with over 8 years in designing and implementing financial reporting and analytics solutions, I specialize in SAP BW/4HANA, SAP Analytics Cloud, and SAP SLT, focusing on real-time and batch data replication. My technical expertise includes developing and optimizing data models, managing ETL processes, and applying LSA++ architecture for Enterprise Data Warehouse modeling. I collaborate effectively with functional teams and stakeholders to ensure that solutions align with business requirements and drive continuous improvement.

Overview

7
7
years of professional experience
26
26
years of post-secondary education
1
1
Certification

Work History

Senior SAP BI Consultant

Vektora
01.2014 - 11.2018
  • D-Market, hepsiburada.com (01.2014 - 12.2017)

* SAP BW on HANA Support

* Real-Time Data Replication with SLT (Hana Modelling in Hana Studio)

* SAP Business Objects Reporting (Dashboards and Excel Analysis Reports)
* SAP BW on HANA Near Line Storage Data Archiving to Sybase IQ
* SAP BW on HANA Migration Project


  • Flormar Cosmetics (01.2018 - 06.2018)

* BW on HANA 7.5 Implementation Project

* Designing ECC SD,MM modelling (LSA++ architecture) and reporting

* HANA Modelling including Attribute Views, Analytical Views, Graphical Calculation Views

* Hybrid modelling with SAP HANA models and BW on HANA


  • Brisa (Bridgestone Sabanci Tire) (11.2017 - 11.2018)

* BW on HANA Support (ECC SD,MM modelling and reporting)

* LSA++ architecture with BW 7.5 on HANA


  • Zorlu Holding Companies ( Vestel) (01.2015 -11.2018)

* End to end KPI Dashboard SAP BW/BO Projects for Marketing and Electronics companies
* CRM, SD,MM and PP modelling and reporting on BW on Hana

* HANA Modelling including Attribute Views, Analytical Views, Graphical Calculation Views

* Data Provisioning using SAP BO Data Services 4.0 from HANA database to Sybase IQ

* Forecasting POC- Expert Analytics (CNR-Decision Tree) in SAP Predictive Analytics 3.3.1


  • Celik Motor – Garenta Rent A Car ( 11.2017 - 08.2018)

* SAP BW on HANA Support

* CRM modelling and reporting on BW on Hana 7.5 SP4


SAP BI Consultant

Vektora IT Consulting
01.2012 - 01.2014
  • STFA Companies - SIF Construction Equipments & HMF Makine (07.2013 - 12.2013)
    * NW BW 7.3 Implementation Full Cycle Project
    * Developing, implementing and managing ETL process to bring data from SAP ECC and SAP CRM systems.
    * Financial Accounting , Sales and CRM modelling and reporting on BW 7.3.


  • Fırsat Electronics, morhipo.com ( 01.2013 - 06.2013)
    * NW BW 7.3 Implementation Full Cycle Project

* SAP BW Support


  • D-Market, hepsiburada.com (01.2012 - 12.2013)

* SAP BW Support
* Designing ECC SD,MM, FI modeling and reporting on BW 7.0
* Designing ECC SD reporting on Business Objects Analysis for Excel and for OLAP.


Education

Master of Science - Business Information Systems

Bogazici University
Istanbul
04.2001 - 06.2016

Bachelor of Science - Mathematics Department

Bogazici University
Istanbul
04.2001 - 06.2012

Certification

SAP Certified Application Associate, Business Intelligence with SAP NetWeaver 7.0

Projects

Flormar Cosmetics, 06 Months, Cosmetics, BW Implementation Project, BW/BO-BI Consultant, Designing ECC SD, MM modelling and reporting on BW on HANA 7.5, HANA Modelling including Attribute Views, Analytical Views, Graphical Calculation Views, LSA++ architecture with BW 7.5 on HANA, Hybrid modelling with SAP HANA models and BW on HANA Brisa, 1 year, Automotive - Tire Manufacturing, BW on HANA Support, BW/BO-BI Consultant, Designing ECC FI, SD modelling and reporting on BW on HANA 7.5, LSA++ architecture with BW 7.5 on HANA, Maintenance of and improvements over existing scenarios, 07/18, 07/19 Vestel Marketing - Services Department, 01 Month, Marketing, Forecasting Spare Parts Demand, Predictive Analytics & Hana Modeler Consultant, HANA Modelling including Attribute Views, Analytical Views, Graphical Calculation Views, SQL Script Procedures, Data Provisioning using SAP BO Data Services 4.0 from HANA database to Sybase IQ, Experience in Expert Analytics (CNR-Decision Tree) in SAP Predictive Analytics 3.3.1 Celik Motor - Garenta Rent A Car, 09 Months, Car Rental, BW Project, BW/BO-BI Consultant, Maintenance of and improvements over existing scenarios, CRM modelling and reporting on BW on Hana 7.5 SP4, Delivering BI Reports using Query Designer in Hana Studio BW modelling perspective, SAP Business Objects BI platform Analysis for Excel report development Vestel Electronics, 05 Months, Electronics, Vestel Electronics Dashboard KPI Project, BW/BO-BI Consultant, Responsible for design, development and extraction from ECC Source system and flat files to BW, Designing ECC SD, MM, PP modelling and reporting on BW on HANA, Delivering BI Reports using BEX Query Designer 7x, SAP Business Objects BI platform Analysis for Excel report development Vestel Marketing - Services Department, 03 Months, Electronics, Vestel Marketing Services Department KPI Dashboard Project, BW/BO-BI Consultant, CRM modelling and reporting on BW on Hana D-Market, hepsiburada.com, 02 Months, E-Commerce, Real Time Reporting Project, Hana Modeler - BW/ BO Consultant, Hana modelling for SD module reporting in Hana Studio (Attribute views, Analytic Views, Calculation Views), Data provisioning using SLT Replication server, NLS data archiving to Sybase IQ D-Market, hepsiburada.com, 03 Months, E-Commerce, SAP BW on HANA Migration Project, BW/BO-BI Consultant, Migration and optimizing existence BW models for BW on HANA, Implementing Analysis for MS Edition, Implementing Design Studio 1.3 Dashboards, BW modelling for SAS (Data mining) D-Market, hepsiburada.com, 3.5 Years, E-Commerce, SAP BW/BO Implementation and Support, BW/BO-BI Consultant, Developing, implementing and managing ETL process to bring data from ECC and SQL DB, Designing ECC SD, FI, MM modelling and reporting on BW 7.3, Development of MultiProviders, InfoCubes, DataStore Objects (DSO), Update Rules, Transformations, Data Transfer Process (DTPs) and InfoPackages, Delivering BI Reports using BEX Query Designer 7x and Business Objects Analysis for Excel, Designing FI reports (e.g. Customer Aging, Balance sheet / P&L Analysis, GL Balances, Actual Comparison of Financial Results by period with previous period analysis, Due Date Analysis, Customer Balance Analysis, Vendor Balance Analysis), Designing SD & MM reports (e.g. Sales analysis, Sales Order Analysis, Customer-Sales Analysis, Purchase Order Analysis, Sales Order Billing and Delivery Analysis) SIF Construction Equipments, 06 Months, Construction Equipment's, SAP BW Project, BW Consultant, Developing, implementing and managing ETL process to bring data from ECC and CRM, Designing ECC SD, FI modelling and reporting on BW 7.3, Designing CRM modelling and reporting on BW 7.3, Development of MultiProviders, InfoCubes, DataStore Objects (DSO), Update Rules, Transformations, Data Transfer Process (DTPs) and InfoPackages, Designing FI reports (e.g. Customer Aging, Balance sheet / P&L Analysis, GL Balances, Actual Comparison of Financial Results by period with previous period analysis, Due Date Analysis, Customer Balance Analysis, Vendor Balance Analysis), Designing SD reports (e.g. Sales analysis, Sales Order Analysis, Customer-Sales Analysis, Purchase Order Analysis, Sales Order Billing and Delivery Analysis), Designing CRM reports HMF Makine, 06 Months, Construction Equipment's, SAP BW Project, BW Consultant, Developing, implementing and managing ETL process to bring data from ECC and CRM, Designing ECC SD, FI modelling and reporting on BW 7.3, Designing CRM modelling and reporting on BW 7.3, Development of MultiProviders, InfoCubes, DataStore Objects (DSO), Update Rules, Transformations, Data Transfer Process (DTPs) and InfoPackages, Designing FI reports (e.g. Customer Aging, Balance sheet / P&L Analysis, GL Balances, Actual Comparison of Financial Results by period with previous period analysis, Due Date Analysis, Customer Balance Analysis, Vendor Balance Analysis), Designing SD reports (e.g. Sales analysis, Sales Order Analysis, Customer-Sales Analysis, Purchase Order Analysis, Sales Order Billing and Delivery Analysis), Designing CRM reports Fırsat Elektronik, morhipo.com, 04 Months, E-Commerce, NW BW 7.3 Implementation Project, BW Consultant, Developing, implementing and managing ETL process to bring data from ECC and SQL DB, Designing ECC SD, FI, MM modelling and reporting on BW 7.3, Development of MultiProviders, InfoCubes, DataStore Objects (DSO), Update Rules, Transformations, Data Transfer Process (DTPs) and InfoPackages, Delivering BI Reports using BEX Query Designer 7x and Business Objects Analysis for Excel, Designing FI reports (e.g. Customer Aging, Balance sheet / P&L Analysis, GL Balances, Actual Comparison of Financial Results by period with previous period analysis, Due Date Analysis, Customer Balance Analysis, Vendor Balance Analysis), Designing SD & MM reports (e.g. Sales analysis, Sales Order Analysis, Customer-Sales Analysis, Purchase Order Analysis, Sales Order Billing and Delivery Analysis) Arkas Automotive, 05 Months, Automotive, BW Implementation Project, BW Consultant, Maintenance of and improvements over existing scenarios, Training the employees BI Reporting tools, Developed InfoCubes and queries for sales figures, Designing ECC SD modeling and reporting on BW 7.0 Arkas Shipping and Transport, 06 Months, Shipping, BW Implementation Project, BW Consultant, Developed InfoCubes and queries for sales, purchasing and inventory figures, Created role based and reporting authorizations, Maintenance of and improvements over existing scenarios, Designing ECC SD, MM modeling and reporting on BW 7.0 Arkas Anatolia Logistics, 05 Months, Logistics, BW Implementation Project, BW Consultant, Developed InfoCubes and queries for sales, purchasing, inventory, financials (FI-GL, AR, AP) and cost centre accounting figures, Maintenance of and improvements over existing scenarios, Designing ECC SD, MM, FI, CO modeling and reporting on BW 7.0 Arkas Holding S.A, 08 Months, Group of Companies, Budgeting and Reporting, BW Consultant, End-user support on existing BW reports

Timeline

Senior SAP BI Consultant

Vektora
01.2014 - 11.2018

SAP BI Consultant

Vektora IT Consulting
01.2012 - 01.2014

Master of Science - Business Information Systems

Bogazici University
04.2001 - 06.2016

Bachelor of Science - Mathematics Department

Bogazici University
04.2001 - 06.2012
SAP Certified Application Associate, Business Intelligence with SAP NetWeaver 7.0

Similar Profiles

CREATE PROFILE
Aytac KaracaliogluSAP BW HANA Consultant