BI & Data Platform Architect | Microsoft Azure, Fabric & Power BI | Trusted Analytics, Semantic Models, Data Products, AI-Ready Analytics
Aktualisiert am 30.05.2026
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 15.04.2026
Verfügbar zu: 50%
davon vor Ort: 50%
Microsoft Fabric
Data Platform Architecture
Semantic Modeling
Data Platform Modernization
Analytics Governance
Data Product Architecture
Power BI
Data Engineering
Datawarehouse
Data Lake
Berechtigungen
AI-Ready Analytics
Data Products
Trusted Analytics
SQL
Turkish
Muttersprache
English
Muttersprache
German
Verhandlungssicher

Einsatzorte

Einsatzorte

Düsseldorf (+100km) Frankfurt am Main (+50km)
Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

1 month
2026-04 - now

dentsu - Microsoft Fabric Data and Analytics Project for EMEA

BI and Data Solutions Architect / Senior Consultant Data Platform Architecture Data Platform Modernization Data Warehousing ...
BI and Data Solutions Architect / Senior Consultant

Project Description:

Ongoing EMEA data and analytics project focused on extending dentsu EMEA's on premises MS SQL Datawarehouse based BI architecture towards Microsoft Fabric. The project covers Operational and Finance data products, Lakehouse and Warehouse design, semantic modeling, reporting enablement, governance, and platform modernization across EMEA.


Tasks:

  • Working on the architecture and implementation of the EMEA data and analytics platform.
  • Extending the existing global Azure-based architecture for EMEA reporting and analytics requirements.
  • Designing Microsoft Fabric Lakehouse, Warehouse, and Semantic Model structures based on Medallion Architecture.
  • Developing reusable, domain-oriented data products, starting with the Finance domain.
  • Supporting the transition of existing MS SQL Based Data Vault 2.0 Datawarehouse, Azure Analysis Services, and Power BI workloads towards Microsoft Fabric.
  • Designing data ingestion, transformation, dimensional modeling, and semantic modeling layers.
  • Optimizing Power BI semantic models using Tabular Editor, DAX, aggregations, calculation groups, and incremental refresh patterns.
  • Supporting development standards, version control, and CI/CD deployment processes using Azure DevOps.
  • Collaborating with business and technical stakeholders to translate requirements into scalable and maintainable data solutions.
Microsoft Fabric Power BI ETL Azure Devops MS Azure SQL Database
Data Platform Architecture Data Platform Modernization Data Warehousing Data Vault 2.0 Lakehouse Architecture Warehouse Architecture Medallion Architecture Domain-Oriented Data Products Data Product Design Data Ingestion Data Transformation Dimensional Modeling Semantic Modeling Tabular Modeling DAX T-SQL Aggregations Calculation Groups Incremental Refresh Performance Optimization Governance CI/CD Version Control Requirements Analysis Stakeholder Management C# Python SQL
dentsu
Germany - Remote
1 month
2026-04 - now

dentsu - Germany Process Optimisation and Program Efficiency Project

Process and Solutions Architect / Senior Consultant Process Analysis Process Optimisation Digitalisation ...
Process and Solutions Architect / Senior Consultant
Project Description

Ongoing process optimisation and digitalisation project for dentsu Germany, focused on improving operational efficiency, reporting automation, master data quality, and internal delivery processes. The project includes the transition from Excel-based reporting to Power BI, the design of a Customer 360 master data management solution, customer contract and team management capabilities, self-service master data maintenance, self-service authorization processes, and DevOps-based delivery practices.


Tasks

  • Analysing existing business processes, reporting structures, and operational workflows.
  • Supporting the digitalisation of Excel-based reporting processes by moving recurring reports to Power BI.
  • Designing a Customer 360 master data management solution.
  • Working on master data concepts, data ownership, data quality, and governance requirements.
  • Designing customer contract and team management capabilities.
  • Designing self-service functionality for tactical master data maintenance.
  • Designing a self-service authorization and access request portal.
  • Supporting the setup of DevOps-based delivery practices, requirement management, release planning, and development governance.
  • Collaborating with business and technical stakeholders to translate operational requirements into maintainable solutions.


MS Excel Microsoft Fabric MS Power BI MS Fabric Low Code / No Code Applications Gapteq
Process Analysis Process Optimisation Digitalisation Reporting Automation Master Data Management Customer 360 Data Governance Self-Service Portal Design Authorization Management DevOps Practices Requirements Management Stakeholder Management SQL C#
dentsu
Germany - Remote
1 year 7 months
2025-06 - 2026-12

dentsu - Project Sakura - A Self-Service Authorization & Access Governance Portal (OLS/RLS) for Microsoft Fabric / Power BI

Product Owner, Solution Architect, Software Developer Product Architecture Authorization Management Access Governance ...
Product Owner, Solution Architect, Software Developer

Project Description:

Product and architectural leadership of Sakura, a self-service authorization management portal that standardizes how enterprise users request, approve, and manage access to Power BI reports and datasets. Sakura orchestrates governance workflows across Object-Level Security (OLS) and Row-Level Security (RLS), provides auditing and notifications, and aligns access outcomes with enterprise security controls via Entra group-based mechanisms and data platform integrations.


Tasks:

  • Owned product vision and architecture of Sakura as a centralized portal for requesting/approving/managing analytics access.
  • Defined functional scope covering OLS and RLS, including lifecycle workflows, approval routing, auditing/logging, delegation patterns, and support operations.
  • Designed the conceptual model mapping Sakura objects (workspaces, apps, audiences, reports) to Microsoft Fabric / Power BI governance needs.
  • Architected system components and integrations: portal UI, identity/authentication, application database, ETL patterns, and downstream sharing of approved access outputs.
  • Established OLS governance patterns, including managed vs unmanaged scenarios and Entra group-based access control principles.
  • Defined roles and responsibilities across requesters, line managers, OLS approvers, RLS approvers, workspace owners, support, and central administration.
  • Led version evolution and stakeholder alignment across Sakura 1 ? Sakura 2.x discussions, readiness topics, and rollout planning.
  • Managed cross-team backlog shaping and iterative improvements for Sakura 2.x based on domain feedback and rollout constraints.
  • Governed dependencies between access management and master data / hierarchy quality (including operational workarounds where required).
MS Azure SQL Database Angular Node.js Azure Azure Devops
Product Architecture Authorization Management Access Governance OLS RLS Workflow Design Approval Processes Audit Logging Identity and Access Management Entra Group-Based Access Control Data Platform Integration Backlog Management Stakeholder Alignment Rollout Planning Master Data Governance C# JavaScript SQL Angular .NET API
dentsu
Germany - Remote
2 years
2024-04 - 2026-03

dentsu - Microsoft Fabric Migration and Data Product Architecture Project

Lead Enterprise BI and Data Solutions Architect Data Platform Modernization Semantic Modeling Data Modeling ...
Lead Enterprise BI and Data Solutions Architect

Project Description:

Migration and architectural evolution of dentsu?s Azure Synapse-based data platform towards Microsoft Fabric. The project focused on Lakehouse and Warehouse design, Medallion Architecture, domain-oriented data products, semantic modeling, governance, and scalable analytical workloads.

Tasks:

  • Led the architectural transition from Azure Synapse towards Microsoft Fabric.
  • Designed Fabric Lakehouse, Warehouse, Semantic Model, and Power BI structures.
  • Applied Medallion Architecture principles for Bronze, Silver, and Gold layers.
  • Designed reusable, domain-oriented data products.
  • Delivered the Finance domain as an initial Fabric-based data product.
  • Designed Spark-based data engineering patterns in Microsoft Fabric.
  • Supported the migration of Synapse, Azure Analysis Services, and Power BI workloads.
  • Optimized semantic models using DAX, Tabular Editor, aggregations, calculation groups, and incremental refresh.
  • Defined platform standards, development guidelines, and governance principles.
  • Supported CI/CD, version control, and structured deployment practices using Azure DevOps.
Microsoft Fabric Fabric Lakehouse Fabric Warehouse Power BI Power BI Semantic Models Azure Synapse Analytics Azure Analysis Services Azure Data Lake Storage Gen2 Tabular Editor Azure DevOps
Data Platform Modernization Semantic Modeling Data Modeling Medallion Architecture Lakehouse Architecture Warehouse Architecture T-SQL DAX CI/CD Delta/Parquet Data Product Architecture
dentsu
Germany - Remote
3 years 10 months
2022-03 - 2025-12

dentsu - Project Ronin - Centralized Data Collection & Master Data / Mapping Platform

Product Owner, Software Developer Product Architecture Master Data Management Workflow Design ...
Product Owner, Software Developer

Project Description:

Product and architecture leadership of Ronin, an internal platform designed to centralize business inputs such as forecasts, targets, master data mappings, and security-relevant datasets, and to integrate them into the Samurai analytics layer consumed by Power BI reporting. The platform combines structured data capture with governance workflows, historization, and controlled access patterns to enable scalable and auditable operations across domains.

Tasks:

  • Led end-to-end product ownership, strategy, and solution architecture for , translating stakeholder needs into a scalable platform roadmap and technical solution.
  • Designed Ronin?s enterprise data platform integration, including staging, enrichment, and output layers, ensuring master data and mappings flow reliably into Power BI / Samurai analytics.
  • Delivered domain-specific Ronin modules that brought master data mappings, parameters, ratios, and business inputs previously managed in personal satellite Excel files under a modern, governed, and auditable application platform.

  • Established database-centric implementation patterns such as stored procedures, triggers, historization, change data capture, entry/history handling, and safe rollback support.

  • Designed and operationalized controlled change request workflows, including draft, submission, stakeholder review / veto window, approval or rejection, execution, confirmation, and audit record keeping.

  • Implemented governance, role-based access control, and segregation-of-duties principles to ensure sensitive master data changes are authorized, transparent, traceable, and auditable.

  • Led adoption of the Ronin UI for mapping maintenance, improving reporting consistency and reducing manual or fragmented maintenance activities.

  • Defined refresh, synchronization, and propagation expectations so approved mapping changes appear near real-time in downstream analytics layers.

  • Transitioned Ronin into BAU operations through release cycles, release notes, user communication, monitoring, support processes, and continuous improvement practices.

MS Azure SQL Database DevExpress Gapteq Azure Devops
Product Architecture Master Data Management Workflow Design Role-Based Access Control Historization SQL Data Governance Solution Architecture Change Data Capture Stored Procedures Audit Logging T-SQL HTML Data Platform Integration Javascript Release Management Stakeholder Management BAU Transition CSS
dentsu
2 years 2 months
2022-02 - 2024-03

dentsu - Global Data Platform Modernization, SQL Server to Azure Synapse Upgrade Project

Lead Enterprise BI and Data Solutions Architect Dedicated SQL Pool Serverless SQL T-SQL ...
Lead Enterprise BI and Data Solutions Architect

Project Description:

Modernization of dentsu?s on-premises Microsoft BI and data warehouse environment into an Azure-based analytical platform. The project covered the migration from SQL Server, SSIS, SSAS Tabular, and Data Vault-based structures to Azure Synapse, ADLS Gen2, Azure Analysis Services, and Power BI.

Tasks:

  • Led the modernization of the on-premises SQL Server, SSIS, SSAS, and Data Vault-based BI environment.
  • Designed the target Azure-based data platform architecture.
  • Migrated the SSAS Tabular model to Azure Analysis Services.
  • Optimized ETL and data warehouse structures for performance, stability, and maintainability.
  • Designed scalable data integration and transformation patterns in Azure Synapse.
  • Used Dedicated SQL and Serverless SQL capabilities for analytical workloads.
  • Standardized dimensional and tabular modeling practices using Tabular Editor.
  • Implemented aggregations, calculation groups, and incremental refresh automation.
  • Implemented version control and CI/CD deployment workflows using Azure DevOps.
  • Supported the transformation into a reusable, scalable, Azure-based analytics platform.


Azure Synapse Analytics Azure Analysis Services Power BI SQL Server SSIS SSAS Tabular ADLS Gen2
Dedicated SQL Pool Serverless SQL T-SQL DAX Tabular Editor Azure DevOps CI/CD Data Vault
dentsu
2 years
2020-02 - 2022-01

dentsu - Financial Data Warehouse and BI Platform Project

Senior Consultant BI & Data Management Data Warehousing ELT ETL ...
Senior Consultant BI & Data Management
Project Description:
Business intelligence and data warehouse project for dentsu, delivered as a Senior Consultant at Qunis GmbH. The project focused on building and improving an on-premises Microsoft BI environment for financial, operational, and management reporting. The solution covered SQL Server-based data warehouse development, SSIS-based data integration, SSAS Tabular semantic modeling, and Power BI reporting.

Tasks:

  • Designed and implemented SQL Server and Data Vault based data warehouse and ELT solutions.
  • Developed SSIS packages for data ingestion, transformation, orchestration, and operational data processing.
  • Built and optimized SSAS Tabular semantic models for financial and management reporting.
  • Implemented aggregations, calculation groups, and custom incremental refresh automation to improve model performance and reduce processing time.
  • Developed Power BI dashboards and analytical reporting layers for business stakeholders.
  • Refactored existing ETL processes, data models, and refresh patterns to improve stability, scalability, and maintainability.
  • Coordinated requirements, engineering tasks, timelines, and client communication.
  • Supported end-to-end BI project delivery from requirements analysis to implementation and reporting enablement.


SQL Server SQL Server Analysis Services Tabular MS SQL Server Integration Services Power BI Tabular Editor Azure DevOps SSIS MS SQL Server Analysis Services SQL Server Integration Services SSAS
Data Warehousing ELT ETL Semantic Modeling Tabular Modeling Dimensional Modeling T-SQL DAX Calculation Groups Aggregations Incremental Refresh Performance Optimization Requirements Analysis Stakeholder Management Project Delivery
dentsu
Germany - Remote
1 year
2018-01 - 2018-12

Comdata / Konecta - Call Center Reporting and Data Product Transformation Project

BI & DWH Architect, Senior BI Consultant Call Center Reporting Data Product Design Data Warehousing ...
BI & DWH Architect, Senior BI Consultant

Project Description

Business intelligence and data warehouse transformation project for a large call center and BPO organization. The project focused on moving from fragmented ad-hoc reporting and direct operational database queries towards a standardized, scalable, and governed BI platform. It covered call center reporting, agent performance, cost analysis, operational KPIs, customer-specific reporting models, master data standardization, tenant-based DWH structures, and the transition towards reusable data products.

Tasks

  • Analysed the existing reporting landscape across multiple operational call center systems and reporting tools.
  • Reviewed more than 300 existing reports and identified duplication, inconsistent KPI definitions, data quality issues, and multiple-version-of-truth problems.
  • Designed and implemented a Microsoft BI-based data warehouse approach to reduce direct reporting load on operational systems.
  • Developed ETL/ELT processes for call center, agent performance, cost, operational, and customer-specific reporting data.
  • Designed tenant-based DWH structures to ensure customer data isolation and support scalable customer-specific reporting.
  • Established master data management concepts, data catalog structures, KPI definitions, and reporting standards.
  • Designed standardized reporting templates and reusable data models for operational and management reporting.
  • Implemented change request and report lifecycle processes to improve control, traceability, and maintainability.
  • Designed parallel and multi-threaded ETL processing patterns to support scalable data processing.
  • Supported the shift from ad-hoc report delivery towards reusable data products and service packages.
  • Designed concepts for custom data and report models for customers requiring reporting beyond the standard package.
  • Supported governance, data privacy, customer isolation, and operational stability improvements.
  • Worked with business and technical stakeholders to stabilize BAU reporting, reduce manual effort, and improve reporting reliability.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Power BI QlikView AVAYA SYTEL ININ Visual Studio Team Services
Call Center Reporting Data Product Design Data Warehousing ELT OLAP Management Reporting Operational Reporting Tenant-Based Architecture Master Data Management Data Governance KPI Standardization Data Catalog Change Request Management ETL Optimization Performance Optimization Data Modeling T-SQL Requirements Analysis Stakeholder Management
Comdata Group / Konecta
Istanbul
2 years
2017-01 - 2018-12

Apollo / Grand Vision - Customer, Retail, and Loyalty Experience Management and Reporting Project (CXM, RXM, LXM)

Solution Architect, Software Developer, Senior BI Consultant, Project Lead Customer Experience Management Loyalty Management Retail Analytics ...
Solution Architect, Software Developer, Senior BI Consultant, Project Lead

Project Description

Business-critical customer experience, loyalty management, and retail intelligence platform for an optics retailer. The project focused on designing both the operational processes and the analytical foundation for a customer-centric retail environment. It enabled Customer 360 views, omnichannel customer access, campaign management, loyalty processes, customer satisfaction tracking, and operational order management across stores, call center, and central HQ.

Tasks

  • Designed and implemented a business-critical operational and analytical platform for customer experience and loyalty management.
  • Worked with the customer to design and improve operational business processes where no mature operational infrastructure existed before.
  • Built a centralized Customer 360 view by consolidating customer, order, store, call center, loyalty, and interaction data.
  • Enabled omnichannel access to customer information across stores, call center, marketing, sales, and management users.
  • Designed operational capabilities for offers, order tracking, returns, customer satisfaction processes, and reward management.
  • Integrated operational data from the platform into analytical and reporting structures.
  • Supported marketing teams with customer segmentation, A/B testing, campaign planning, campaign execution, and performance tracking.
  • Established a single version of truth for customer data across operational and analytical processes.
  • Designed and implemented loyalty program capabilities, including reward tracking and customer engagement processes.
  • Supported customer satisfaction and recommendation survey processes and enabled analytical evaluation of survey results.
  • Improved retail intelligence, customer visibility, campaign effectiveness, and operational process transparency.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Dynamics AX Microsoft Excel
Customer Experience Management Loyalty Management Retail Analytics Omnichannel Analytics Campaign Management Customer Segmentation A/B Testing Survey Analytics Order Management Customer 360 Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Apollo / GrandVision
Istanbul
1 year
2017-01 - 2017-12

Penti - Replenishment and Allocation Management Project

Solution Architect, Software Developer, Senior BI Consultant Retail Analytics Replenishment Allocation Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Replenishment, allocation, and inventory optimization project for a retail organization. The project focused on improving store stock management, automated stock distribution, campaign stock protection, inter-store stock transfers, and reporting around sales velocity, stock turnover, and store performance. The solution combined operational application development with BI and analytical reporting capabilities.

Tasks

  • Analysed replenishment, allocation, stock distribution, campaign planning, and store stock management requirements.
  • Designed and implemented a custom solution for replenishment and allocation management.
  • Developed logic for automated stock distribution based on sales velocity, stock turnover, store characteristics, and product performance.
  • Designed reporting and analytical structures for stock turnover, sales velocity, inventory levels, and store performance.
  • Implemented campaign stockout protection algorithms to improve product availability during campaign periods.
  • Developed store size classification logic to support differentiated replenishment and allocation strategies.
  • Designed and implemented inter-store stock transfer algorithms.
  • Enabled users to manage operational inputs and allocation parameters through application and Excel-based interfaces.
  • Integrated operational replenishment and allocation data into analytical reporting structures.
  • Supported merchandising, supply chain, planning, category management, store operations, and management teams with reporting and decision support.
  • Reduced manual effort in stock distribution and improved transparency in replenishment and allocation decisions.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Excel
Retail Analytics Replenishment Allocation Management Inventory Optimization Stock Distribution Stock Turnover Analysis Sales Velocity Analysis Campaign Stockout Protection Inter-Store Stock Transfer Store Performance Analysis Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Penti Lingerie
Istanbul
1 year
2017-01 - 2017-12

Penti - Store Shift/Timesheet Management Reporting Project

Solution Architect, Software Developer, Senior BI Consultant Retail Analytics Workforce Planning Staff Transfer Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Store workforce planning and digitalization project for a retail organization. The project focused on managing staff transfers between stores, personnel rotation planning, timesheet-related processes, and workforce visibility across stores, regional management, HR, finance, and operations. The solution replaced paper-based and Excel-based processes with a structured digital application and reporting environment.

Tasks

  • Analysed staff transfer, rotation planning, timesheet, and workforce planning requirements.
  • Designed and implemented a digital solution for managing personnel transfers between stores.
  • Developed functionality for store staff rotation planning and operational workforce coordination.
  • Replaced paper-based and Excel-based planning processes with structured digital workflows.
  • Designed reporting structures for workforce planning, staff allocation, store capacity, and personnel cost visibility.
  • Supported HR, store operations, regional managers, store managers, finance, and management users.
  • Integrated operational workforce data into analytical reporting structures.
  • Developed application and reporting components using Microsoft BI and .NET technologies.
  • Improved transparency, traceability, and efficiency in store workforce planning processes.
  • Reduced manual effort and improved digital process control across store operations.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Excel
Retail Analytics Workforce Planning Staff Transfer Management Rotation Planning Timesheet Management Store Operations Digitalization Process Automation Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Penti Lingerie
Istanbul
1 year
2016-01 - 2016-12

Penti - Master Data Management and Data Governance Project

Solution Architect, Software Developer, Senior BI Consultant Master Data Management Data Governance Data Quality Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Master data management and governance project for a retail organization with significant master data quality and consistency issues. The project focused on establishing a single version of truth across product, customer, store, supplier, and hierarchy-related master data. It aimed to improve data quality, reporting reliability, system-to-system data exchange, and governance across business and IT processes.

Tasks

  • Analysed existing master data structures, data quality issues, ownership gaps, and system integration problems.
  • Identified the impact of inconsistent master data on reporting, analytics, and data exchange between operational systems.
  • Proposed and designed a centralized master data management approach to establish a single version of truth.
  • Designed master data structures for product, customer, store, supplier, and hierarchy management.
  • Defined data governance principles, guardrails, responsibilities, ownership models, and maintenance processes.
  • Designed validation rules and control mechanisms to improve data quality and reduce duplicate or inconsistent records.
  • Implemented MDM-related data models, workflows, and reporting structures using Microsoft BI technologies.
  • Supported business and IT stakeholders in defining master data responsibilities and governance processes.
  • Improved reliability of analytical reporting and operational data exchange through standardized master data.
  • Established a governed foundation for future retail analytics, operational systems, and management reporting.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services
Master Data Management Data Governance Data Quality Management Single Version of Truth Hierarchy Management Data Ownership Data Validation Data Modeling T-SQL Requirements Analysis Stakeholder Management .NET ASP.NET Excel Add-in ERP integration
Penti Lingerie
Istanbul
1 year
2016-01 - 2016-12

Penti - Customer, Retail, and Loyalty Experience Management Project (CXM, RXM, LXM)

Solution Architect, Software Developer, Senior BI Consultant Customer Experience Management Retail Experience Management Loyalty Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Customer and retail experience management project for a large retail organization. The project focused on creating a structured customer intelligence foundation by designing and implementing a loyalty card program, customer analytics capabilities, campaign management support, and retail experience reporting. A key objective was to make anonymous retail transactions identifiable through loyalty card usage, enabling customer-level analysis based on shopping behaviour, demographics, store visits, and product preferences.

Tasks

  • Designed and implemented a customer and retail experience management solution for marketing, CRM, store operations, sales, and management users.
  • Designed the loyalty card program concept, including card lifecycle, customer registration, POS integration, point collection, and bonus management.
  • Developed an internet-facing loyalty card portal for customer usage and account-related interactions.
  • Integrated loyalty card data with POS transactions to identify customers behind receipt-based retail purchases.
  • Enabled customer-level analysis of purchasing behaviour, product preferences, store visits, demographics, and campaign responses.
  • Designed Customer 360 and retail intelligence structures based on customer, transaction, product, store, and campaign data.
  • Supported customer segmentation and targeted campaign planning based on customer habits and demographic attributes.
  • Built reporting and analytical structures for loyalty performance, campaign effectiveness, customer behaviour, and retail experience.
  • Helped transform anonymous POS sales data into identifiable customer insight.
  • Improved marketing, campaign management, customer profiling, and retail decision support capabilities.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework POS Systems
Customer Experience Management Retail Experience Management Loyalty Management Customer 360 Retail Analytics Customer Segmentation Campaign Management Demographic Analysis POS Data Integration Customer Identification Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Penti Lingerie
Istanbul
1 year
2015-01 - 2015-12

Bayer - Datawarehouse and Sales Reporting Project

Senior BI Consultant Data Warehousing ELT OLAP ...
Senior BI Consultant

Project Description

Sales reporting, field force performance, and management reporting project for a pharmaceutical organization. The project focused on building analytical structures for sales, brick-level performance, business unit reporting, therapeutic area analysis, exceptional sales detection, bonus and performance calculations, and scenario-based simulations.

Tasks

  • Analysed sales reporting, field force performance, CRM, IMS, and management reporting requirements.
  • Designed and implemented data warehouse structures for pharmaceutical sales and performance analysis.
  • Developed ETL/ELT processes to integrate sales, CRM, IMS, field force, and product-related data.
  • Built reporting and analytical models for brick sales analysis, business unit performance, and therapeutic area analysis.
  • Implemented exceptional sales detection logic to identify unusual sales patterns and outliers.
  • Designed bonus and performance calculation logic for sales and field force reporting.
  • Supported what-if scenarios and simulations for sales, performance, and business planning use cases.
  • Built management reports and analytical views for sales, field force, marketing, finance, and management users.
  • Improved visibility into sales performance, territory-level activity, and pharmaceutical business KPIs.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services IMS
Data Warehousing ELT OLAP Management Reporting Sales Reporting Pharmaceutical Reporting Field Force Performance Brick Sales Analysis Business Unit Analysis Therapeutic Area Analysis Bonus Calculation Performance Calculation What-If Analysis Simulation Exceptional Sales Detection Data Modeling T-SQL Requirements Analysis Stakeholder Management
Bayer
Istanbul
1 year
2015-01 - 2015-12

Domino?s Pizza - Datawarehouse and Management Reporting Project

Senior BI Consultant Management Reporting Operational Reporting Restaurant Analytics ...
Senior BI Consultant

Project Description

Data warehouse and management reporting project for a large quick service restaurant network with more than 300 stores. The project focused on consolidating store sales, order, delivery, online sales, offline restaurant sales, campaign, customer, and operational performance data into a central BI environment. A key challenge was reliable data collection from many store-level servers under varying network conditions, closing times, and operational constraints.

Tasks

  • Analysed store sales, order management, delivery performance, campaign, customer, and management reporting requirements.
  • Designed and implemented data warehouse structures for restaurant, store, order, customer, delivery, and campaign analysis.
  • Developed ETL/ELT processes to collect data from more than 300 store servers and local order management databases.
  • Designed resilient data extraction logic to handle slow internet connections, connection losses, and repeated data transfer risks.
  • Implemented retry and repeat-protection mechanisms to improve reliability of distributed store data collection.
  • Designed logic to track different store closing times and trigger end-of-day reporting processes accordingly.
  • Integrated online sales and offline restaurant sales data to support unified customer and order analysis.
  • Built Customer 360 and preference analysis structures based on ordering behaviour, product choices, and pizza topping customization.
  • Analysed customer preferences and product customization patterns to support product and menu improvement decisions.
  • Developed reporting for 30-minute delivery guarantee performance, delivery delays, and delay reasons.
  • Built management reports and analytical views for operations, store management, franchise management, marketing, finance, and executive users.
  • Supported international scale-out of the solution to Azerbaijan and Turkic republics using a dynamic and configurable ETL structure.
  • Enabled rapid technical rollout to new countries through reusable and configurable data integration patterns.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services POS Systems Online Ordering Systems Store Order Management Systems
Management Reporting Operational Reporting Restaurant Analytics Store Performance Analysis Order Analysis Delivery Performance Analysis Campaign Analysis Customer 360 Customer Preference Analysis Distributed ETL Resilient Data Integration ETL Optimization Configurable ETL Design Data Modeling T-SQL Requirements Analysis Stakeholder Management Data Warehousing ELT OLAP
Domino?s Pizza
Istanbul
1 year
2014-01 - 2014-12

Kuveyt Türk Bank - Management Reporting, Budgeting and Planning Project

Senior BI Consultant, Software Developer Data Warehousing ELT OLAP ...
Senior BI Consultant, Software Developer

Project Description

Management reporting, budgeting, and planning project for a banking environment with strict security and governance requirements. The project covered bank-wide financial reporting, P&L and balance sheet reporting, regulatory reporting support for Turkish Banking Regulation and Supervision Agency, target entry and tracking, and budgeting processes for Bank Branches. As Microsoft Office PerformancePoint Server was being discontinued, a custom Excel-based writeback solution was developed to replace the existing budgeting functionality and later evolved into a commercial product, the BudgetPort? Suite.

Tasks

  • Analysed budgeting, financial reporting, branch performance, regulatory reporting, and management reporting requirements.
  • Designed and implemented Microsoft BI-based data warehouse and reporting structures for banking and finance use cases.
  • Developed reporting layers for P&L, balance sheet, branch deposit targets, and management reporting.
  • Supported regulatory reporting requirements related to Turkish Banking Regulation and Supervision Agency reporting processes.
  • Designed and implemented budget and target entry functionality for branch deposit planning and tracking.
  • Developed an Excel Add-in-based writeback solution to replace Microsoft Office PerformancePoint Server budgeting functionality.
  • Implemented budgeting, planning, forecasting, consolidation, and cost allocation capabilities.
  • Built ETL/ELT processes and analytical models to support finance, controlling, branch management, and executive reporting.
  • Worked within a highly secure banking environment with strict access, deployment, and operational constraints.
  • Contributed to the productization of the Excel writeback and budgeting solution into BudgetPort? Suite.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Office PerformancePoint Server Microsoft Excel .NET Framework BudgetPort? Suite
Data Warehousing ELT OLAP Management Reporting Budgeting Planning Forecasting Financial Reporting Regulatory Reporting P&L Reporting Balance Sheet Reporting Branch Performance Reporting Excel Writeback Cost Allocation Consolidation Data Modeling T-SQL C# Requirements Analysis Stakeholder Management Banking Reporting
Kuveyt Türk Bank
Istanbul
1 year
2014-01 - 2014-12

MSF - Field Data Entry and Synchronization Project

Software Developer, BI Consultant Data Synchronization Field Data Collection Client-Server Architecture ...
Software Developer, BI Consultant

Project Description:

Field data entry, synchronization, and reporting project for a humanitarian non-profit organization. The project focused on enabling field teams to capture operational and treatment-related data under challenging connectivity conditions and synchronize it with a central reporting environment. The solution combined Windows and web applications, a client-server architecture, and reporting capabilities to support centralized visibility and analysis.

Tasks:

  • Analysed field data entry, synchronization, and reporting requirements together with operational and central reporting stakeholders.
  • Designed and implemented a client-server architecture for distributed field data collection.
  • Developed Windows and web application components using .NET technologies.
  • Enabled field users to capture data locally and synchronize it with a central system.
  • Designed synchronization logic to support environments with limited or unstable connectivity.
  • Built reporting structures to support central monitoring and analysis of field data.
  • Supported data validation, consistency checks, and controlled data exchange between field locations and central reporting.
  • Improved data availability, reporting reliability, and operational visibility across distributed field activities.
MS SQL Server .NET Framework Windows Forms ASP.NET
Data Synchronization Field Data Collection Client-Server Architecture Offline Data Capture Distributed Application Design Data Validation Data Modeling Data Warehousing T-SQL C# Requirements Analysis Management Reporting Stakeholder Management ELT
MSF / Doctors Without Borders
Geneva, Istanbul
1 year
2013-01 - 2013-12

Apollo / GrandVision - Order Processing and Management Project

Software Developer, BI Consultant Order Management Order Tracking Store Operations ...
Software Developer, BI Consultant

Project Description:

Order processing and management project for an optics retail organization with around 300 stores. The project focused on managing the full order-to-delivery lifecycle between stores, headquarters, workshops, and supporting departments. The solution was integrated with the ERP environment and enabled stores to capture customer orders, workshops to manage production tasks, and business users to monitor delivery commitments, delays, repair processes, and operational requests.

Tasks:

  • Analysed order processing, store operations, workshop coordination, delivery tracking, and management reporting requirements.
  • Designed and developed Windows and web application components using .NET technologies.
  • Implemented order entry and tracking functionality for store users.
  • Enabled workshops to view work orders, update production status, and report production-related issues.
  • Designed logic to calculate and communicate estimated delivery dates to customers.
  • Implemented delay tracking and notification logic for order, production, repair, and delivery processes.
  • Supported the full order-to-delivery lifecycle across stores, workshops, headquarters, and management users.
  • Developed functionality for consumable material requests and store marketing material planning.
  • Integrated operational order data with ERP and reporting structures.
  • Created reporting views to improve visibility of order status, production issues, delivery performance, and store operations.
  • Helped establish a central operational bridge between stores and headquarters.
  • Supported rollout and usage across approximately 300 stores.
.NET Framework Windows Forms ASP.NET MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ERP Systems
Order Management Order Tracking Store Operations Workshop Coordination Delivery Tracking ERP Integration Operational Reporting Process Automation Data Modeling T-SQL C# Requirements Analysis Stakeholder Management Data Warehousing ELT OLAP Management Reporting
Apollo / GrandVision
Istanbul
1 year
2013-01 - 2013-12

Azerfon - Management Reporting and Datawarehouse Project

Lead BI Consultant, Project Manager Data Warehousing ELT OLAP ...
Lead BI Consultant, Project Manager

Project Description:

Data warehouse and management reporting project for a telecom operator with millions of subscribers. The project focused on enabling detailed analysis of call records, subscriber behaviour, revenue, operational KPIs, and management reporting requirements. The solution involved very large fact tables with billions of rows and dimension tables with millions of records, requiring scalable data modeling and performance-oriented BI design.

Tasks:

  • Analysed telecom reporting, subscriber analytics, revenue analysis, call detail analysis, and management reporting requirements.
  • Designed and implemented data warehouse structures for large-scale telecom data.
  • Developed ETL/ELT processes for integrating call detail records, subscriber data, revenue-related data, and operational reporting data.
  • Built analytical models to support detailed analysis of call records and subscriber behaviour.
  • Worked with very large fact and dimension tables requiring performance-oriented data modeling and query optimization.
  • Supported management reporting, telecom KPI reporting, operational reporting, and revenue-related analysis.
  • Worked in an international project environment together with external BI consultants from Pyramid Analytics.
  • Supported the implementation and usage of Pyramid Analytics as the analytical reporting tool.
  • Improved analytical visibility across high-volume telecom data and enabled scalable reporting for business stakeholders.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Pyramid Analytics
Data Warehousing ELT OLAP Management Reporting Telecom Reporting Call Detail Record Analysis Subscriber Analytics Revenue Analysis Large-Scale Fact Tables Performance Optimization Data Modeling T-SQL Requirements Analysis Stakeholder Management
Azerfon
Baku, Aserbaidschan
1 year
2013-01 - 2013-12

Metro AG - Sales and Management Reporting DWH Project

Senior BI Consultant Data Warehousing ELT OLAP ...
Senior BI Consultant
Project Description
Operational and management reporting project for the sales department of a large retail organization. The project focused on customer and sales analytics, store performance reporting, POS transaction analysis, campaign performance analysis, and retail KPI reporting.

Tasks

  • Analysed reporting requirements together with business stakeholders from the Sales & Marketing department.
  • Designed and implemented data warehouse structures for customer, sales, store, campaign, and POS transaction analysis.
  • Developed ETL/ELT processes to integrate POS and Teradata-based source data into the reporting environment.
  • Built analytical data models to support sales, customer, store, and campaign performance reporting.
  • Implemented operational and management reports for store sales, receipt-level transaction details, customer behaviour, and retail KPIs.
  • Supported weekly and monthly campaign/prospect performance analysis.
  • Improved reporting automation and reduced dependency on manual analysis and Excel-based reporting.


MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Teradata POS Systems
Data Warehousing ELT OLAP Management Reporting Operational Reporting Retail Analytics Sales Analytics Customer Analytics Store Performance Analysis Campaign Performance Analysis POS Data Analysis Data Modeling T-SQL Requirements Analysis Stakeholder Management
Metro AG
Istanbul
1 year
2012-01 - 2012-12

Mercedes-Benz - Financial Reporting, Budgeting and OLAP Writeback Solution

Senior BI Consultant / Software Developer Data Warehousing ELT OLAP ...
Senior BI Consultant / Software Developer

Project Description:

Financial reporting, budgeting, and forecasting solution for the Controlling department of Mercedes-Benz Financial Services. The project focused on replacing an existing IBM TM1-based budgeting process with a Microsoft BI-based solution, enabling finance users to enter budget and forecast values directly through Microsoft Excel while writing back to the most granular level of the analytical model.

Tasks

  • Designed and implemented a Microsoft BI-based budgeting and forecasting solution for the Controlling department.
  • Developed an Excel Add-in (Product Name: Spectra) and COM automation solution for OLAP writeback scenarios.
  • Enabled business users to enter budget and forecast data directly through Microsoft Excel.
  • Implemented writeback logic from aggregated Excel views to granular-level analytical data structures.
  • Supported the replacement of IBM TM1-based budgeting processes with a custom self developed solution.
  • Built reporting and analytical structures for financial planning, controlling, and management reporting.
  • Developed application components using .NET and C#.
  • Supported automation of the financial planning process and reduced dependency on manual budgeting workflows.
  • Contributed to a solution that reduced IBM TM1 license dependency and later evolved into a commercial product.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Excel IBM TM1 .NET Framework
Data Warehousing ELT OLAP OLAP Writeback Budgeting Forecasting Financial Planning Controlling Management Reporting Data Modeling T-SQL C# .NET Development Requirements Analysis Stakeholder Management
Mercedes-Benz Financial Services
Istanbul
1 year
2012-01 - 2012-12

Peugeot - Dealer Performance Management and Operational Portal

Senior BI Consultant, Software Developer Data Warehousing ELT OLAP ...
Senior BI Consultant, Software Developer

Project Description:

Dealer performance management and operational reporting project for Peugeot Turkey. The project focused on measuring dealer performance across sales, test drives, vehicle requests, operational processes, and dealer network activities. As part of the BI initiative, an ASP.NET-based dealer portal was designed and implemented to capture operational data that was previously managed in Excel files or not available in a structured way.

Tasks:

  • Analysed dealer performance management requirements together with sales, dealer network, and management stakeholders.
  • Designed and implemented BI structures for dealer performance, sales performance, operational KPIs, and management reporting.
  • Developed data warehouse and reporting layers based on Microsoft BI technologies.
  • Designed an ASP.NET-based dealer portal for Peugeot dealers across Turkey.
  • Enabled dealers to log in and manage operational processes such as test drives, vehicle requests, and dealer-related activities.
  • Replaced fragmented Excel-based data collection with a structured portal and database-driven process.
  • Integrated portal data into the BI environment to enable new analyses and improve reporting quality.
  • Built reports and analytical views for dealer KPIs, target achievement, operational performance, and management visibility.
  • Improved central visibility of dealer operations and reduced manual reporting effort.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Excel
Data Warehousing ELT OLAP Management Reporting Operational Reporting Dealer Performance Management Retail Analytics KPI Reporting Portal Design Data Collection Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Peugeot
1 year
2012-01 - 2012-12

Pfizer - Field Performance and Bonus Management Reporting Project - Part II

Senior BI Consultant Data Warehousing ELT OLAP ...
Senior BI Consultant

Project Description

Business-critical field performance and bonus management reporting system for Pfizer Turkey. The project focused on calculating sales representatives? performance bonuses based on complex business rules, sales targets, visit performance, field activities, and territory-related performance indicators. The solution also enabled each field representative to monitor their own sales and visit performance and estimate expected bonus outcomes.

Tasks

  • Analysed complex bonus calculation rules, field performance KPIs, sales targets, and visit performance requirements.
  • Designed and implemented data warehouse structures for field force performance and bonus management reporting.
  • Developed ETL/ELT processes to integrate sales, visit, employee, territory, and performance-related data.
  • Implemented complex calculation logic for performance bonus estimation and management reporting.
  • Built analytical models and reports for sales representatives, field managers, HR, finance, and management users.
  • Enabled individual field representatives to monitor their own performance and estimated bonus results.
  • Integrated relevant outputs with Oracle PeopleSoft for downstream HR/payroll-related processes.
  • Supported validation and quality control of sensitive bonus calculation results.
  • Improved transparency, accuracy, and automation in a highly sensitive and business-critical incentive process.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Oracle PeopleSoft
Data Warehousing ELT OLAP Management Reporting Field Force Reporting Bonus Calculation Incentive Management Sales Performance Analysis Territory Performance Analysis KPI Reporting Data Modeling T-SQL Requirements Analysis Stakeholder Management Business-Critical Reporting
Pfizer
Istanbul
1 year
2011-01 - 2011-12

Philip Morris - Financial Forecasting and Reporting Project

Senior BI Consultant, Software Developer Financial Forecasting Treasury Reporting P&L Modeling ...
Senior BI Consultant, Software Developer

Project Description:

Financial forecasting and reporting project for the Treasury department of Philip Morris. The project had two main phases: first, moving an advanced Excel-based financial forecasting model into a data warehouse and reporting environment; second, developing an Excel Add-in that allowed controlled simulation parameter changes and direct writeback into the database. The model covered an integrated P&L, balance sheet, and cash flow forecast and supported scenario simulations based on financial, operational, and macroeconomic parameters.

Tasks:

  • Analysed the existing Excel-based financial forecasting model used by the Treasury department.
  • Translated complex financial forecast logic into a database-driven calculation and reporting model.
  • Designed data warehouse structures for integrated P&L, balance sheet, and cash flow forecasting.
  • Implemented scenario simulation capabilities based on parameters such as inflation, interest rates, sales volumes, labour efficiency, machine efficiency, depreciation, tax assumptions, and dividend payments.
  • Developed reporting structures to analyse the impact of business activities on P&L, balance sheet, cash flow, tax burden, and shareholder-related financial outcomes.
  • Implemented complex financial calculations such as WACC, CAPM, Shareholder Value, and Operating Free Cash Flow.
  • Developed an Excel Add-in to manage simulation parameters and write controlled changes directly into the database.
  • Enabled business users to run forecast simulations and compare financial outcomes based on different parameter sets.
  • Improved governance, consistency, and maintainability of a previously Excel-based forecasting process.
  • Supported Treasury, finance, controlling, and management users with financial forecasting and scenario analysis capabilities.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Excel .NET Framework
Financial Forecasting Treasury Reporting P&L Modeling Balance Sheet Modeling Cash Flow Modeling Scenario Simulation What-If Analysis Excel Writeback Financial Modeling WACC CAPM Shareholder Value Operating Free Cash Flow Tax Impact Analysis Data Modeling T-SQL C# Requirements Analysis Stakeholder Management Data Warehousing ELT OLAP Management Reporting
Philip Morris
Istanbul
1 year
2010-01 - 2010-12

Pfizer - Oracle PeopleSoft and Local Payroll Integration

Senior BI Consultant, ETL Developer ETL ELT Data Integration ...
Senior BI Consultant, ETL Developer

Project Description:

Business-critical ETL and data integration project for Pfizer Turkey. The project focused on establishing a bi-directional data exchange between the local payroll system and the global Oracle PeopleSoft HRMS environment. The integration handled sensitive employee and payroll-related data for all Pfizer Turkey employees and required a high level of confidentiality, accuracy, validation, and operational reliability.

Tasks:

  • Analysed HR, payroll, and global HRMS integration requirements together with business and technical stakeholders.
  • Designed and implemented bi-directional ETL processes between the local payroll system and Oracle PeopleSoft.
  • Developed data extraction, transformation, validation, and loading processes for sensitive employee and payroll data.
  • Implemented data quality controls, consistency checks, and error handling mechanisms.
  • Supported secure and controlled processing of confidential HR and payroll-related data.
  • Designed integration logic to ensure accurate data exchange between local and global HR systems.
  • Worked on a business-critical integration process where data accuracy and reliability were essential.
  • Supported testing, reconciliation, and validation of integration results.
  • Completed the integration without data errors in a highly sensitive payroll and HR environment.
MS SQL Server MS SQL Server Integration Services Oracle PeopleSoft Local Payroll System
ETL ELT Data Integration HR Data Integration Payroll Integration Bi-Directional Data Exchange Data Validation Data Quality Management Error Handling Data Reconciliation Sensitive Data Handling Business-Critical Integration T-SQL Requirements Analysis Stakeholder Management
Pfizer
Istanbul
1 year
2010-01 - 2010-12

Pfizer - IMS Sales and Field Force Performance Reporting Project

Senior BI Consultant MDX Data Warehousing ELT ...
Senior BI Consultant

Project Description:

Sales and field force performance reporting project for Pfizer Turkey. The project served as the first phase of a broader field performance and bonus management initiative. This phase focused on reverse engineering, extracting and converting IMS sales data from OLAP-based structures into a relational analytical model, cleaning and preparing the data for reporting, and making the reports available to field force users both online and offline.

Tasks:

  • Analysed IMS sales data, field force performance, territory, brick, and management reporting requirements.
  • Reverse engineered IMS data structures and converted OLAP-oriented source data into relational analytical formats.
  • Designed and implemented ETL processes to extract, transform, clean, and prepare IMS sales data for analysis.
  • Built data warehouse and analytical structures for sales, field force, territory, and brick-level performance reporting.
  • Developed reports and analytical views for sales, field force, marketing, finance, and management users.
  • Enabled field force users to access performance reports online.
  • Created local cube structures to support offline reporting and analysis for field force users.
  • Improved data usability, reporting consistency, and analytical accessibility of IMS sales data.
  • Established the analytical foundation for later field performance and bonus management reporting.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services IMS
MDX Data Warehousing ELT OLAP Management Reporting Sales Reporting Field Force Reporting IMS Data Processing OLAP to Relational Conversion Reverse Engineering Territory Analysis Brick Sales Analysis Offline Reporting Local Cubes Data Cleansing Data Modeling T-SQL Requirements Analysis
Pfizer
Istanbul
2 years
2009-01 - 2010-12

Pfizer - P&L Reporting and OPEX Allocation Project

BI Consultant Financial Reporting P&L Reporting OPEX Allocation ...
BI Consultant

Project Description:

P&L reporting and OLAP business intelligence project for Pfizer Turkey. The project focused on building a data warehouse and OLAP reporting solution for TRG and HTG P&L analysis based on SUN ERP ledger data, Excel-based master data, budgeting inputs, adjustments, HFM distribution data, and allocation ratios. The solution supported Actual and Budget scenarios, multiple reporting versions, product and account dimensions, and business-rule-based OPEX allocation over departments, business units, and master products.

Tasks:

  • Analysed P&L reporting, allocation, budgeting, and finance reporting requirements.
  • Designed and implemented data warehouse structures for P&L reporting and OLAP analysis.
  • Integrated SUN ERP ledger data as the primary source for financial fact figures.
  • Integrated Excel-based inputs for allocation ratios, filters, mappings, dimensions, budget figures, manual adjustments, and HFM distribution records.
  • Built ETL processes to extract, transform, validate, and prepare finance data for OLAP processing.
  • Designed dimensions for product, account, division, market, legal entity, scenario, version, currency, and date.
  • Implemented P&L structures covering gross sales, returns, allowances, net sales, cost of goods sold, marketing expenses, distribution expenses, R&D, G&A, other income, deductions, OPEX, and IBA.
  • Implemented allocation logic for common figures across departments, business units, and master products.
  • Supported different allocation methods for field selling, other marketing expenses, distribution, R&D, G&A, other income, and other deductions.
  • Implemented validation rules for account mappings, product mappings, department allocation rules, marketing group mappings, and HFM-related structures.
  • Built SSAS OLAP structures to support multidimensional P&L analysis and management reporting.
  • Improved transparency, consistency, and maintainability of finance reporting and allocation calculations.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services Microsoft Excel SUN ERP HFM
Financial Reporting P&L Reporting OPEX Allocation Budgeting Scenario Analysis Data Validation Allocation Logic Finance Data Modeling Data Modeling T-SQL MDX Requirements Analysis Data Warehousing ELT OLAP Management Reporting
Pfizer
Istanbul
1 year
2009-01 - 2009-12

Pfizer - Product Master Data Management Project

BI Consultant Product Master Data Data Integration Data Validation ...
BI Consultant

Project Description:

Product master data management and SSIS integration project for Pfizer Turkey. The project focused on centralizing and synchronizing product-related master data from multiple source systems into a controlled Product MDM database. The scope included product attributes, MPG definitions, samples, forms, distributors, companies, ATC classifications, molecules, origin and business information, including validation, history tracking, error handling, and post-processing controls.

Tasks:

  • Analysed product master data integration requirements across multiple source systems.
  • Designed and implemented SSIS packages for Product MDM data integration.
  • Integrated product-related master data from various ERP and MRP source systems.
  • Built data flows for MPG, sample, form, distributor, company, ATC3, ATC4, molecule, origin, and business definitions.
  • Implemented temporary staging tables, validation logic, and controlled transfer processes into the Product MDM database.
  • Designed logic to detect new, updated, deleted, invalid, duplicate, and inconsistent records.
  • Implemented error logging, information logging, execution tracking, and notification mechanisms.
  • Developed post-check logic to ensure consistency between MPG, sample, and form status information.
  • Supported product hierarchy, product attribute, price, launch date, GTIN, and source-system-code synchronization.
  • Improved master data quality, consistency, traceability, and reliability for downstream reporting and analytics processes.
MS SQL Server MS SQL Server Integration Services
Product Master Data Data Integration Data Validation Data Quality Management Data Warehousing ELT Master Data Management History Tracking Source System Integration Data Modeling T-SQL Requirements Analysis
Pfizer
Istanbul
1 year
2008-01 - 2008-12

Pfizer - BI Infrastructure Modernization and Digital Transformation Project

BI Consultant BI Modernization Data Warehousing ELT ...
BI Consultant

Project Description:

BI infrastructure modernization project for Pfizer Turkey. The project focused on the full modernization of an existing Microsoft BI landscape based on SQL Server 2000, DTS packages, and OLAP 2000 cubes. The legacy environment was migrated to SQL Server 2008, SSIS, and SSAS to improve maintainability, performance, operational reliability, and long-term supportability of the reporting infrastructure.

Tasks:

  • Analysed the existing SQL Server 2000, DTS, and OLAP 2000-based BI landscape.
  • Supported the modernization of approximately 20 data marts from SQL Server 2000 to SQL Server 2008.
  • Rewrote more than 300 DTS packages as SSIS packages.
  • Converted 15 OLAP 2000 cubes into SSAS cubes.
  • Performed data validation and reconciliation between legacy and modernized environments.
  • Supported migration testing, issue analysis, and operational readiness activities.
  • Improved maintainability and stability of ETL and OLAP processing workflows.
  • Supported the transition from legacy BI components to a more modern Microsoft BI architecture.
  • Helped make the modernized BI environment operational for business-critical reporting and analytics processes.
MS SQL Server 2000 MS SQL Server 2008 MS SQL Server Data Transformation Services MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services
BI Modernization Data Warehousing ELT ETL Migration OLAP Migration Data Mart Migration Legacy System Modernization Data Validation Data Reconciliation OLAP Management Reporting Data Modeling T-SQL Requirements Analysis
Pfizer
Istanbul
1 year
2008-01 - 2008-12

Darty/fnac - Retail Reporting and Analysis Project

BI Consultant Retail Analytics Sales Reporting Stock Turnover Analysis ...
BI Consultant

Project Description:

Retail reporting and analysis project for an electronics retailer. The project focused on building analytical and management reporting capabilities for retail performance, including sales velocity, stock turnover, product profitability, store profitability, sales bonus reporting, and revenue-based incentive reporting. The solution used Microsoft BI technologies and integrated retail data from Microsoft Dynamics AX / Axapta.

Tasks:

  • Analysed retail reporting, sales performance, stock analysis, profitability, and incentive reporting requirements.
  • Designed and implemented reporting structures for retail analytics and management reporting.
  • Developed ETL/ELT processes to prepare sales, stock, product, store, and finance-related data for analysis.
  • Built analytical models and reports for stock turnover, sales velocity, product profitability, and store profitability.
  • Developed reports for sales bonus and revenue-based incentive calculations.
  • Integrated Microsoft Dynamics AX / Axapta data into the reporting environment.
  • Supported finance, sales, store operations, category management, and management users with analytical reporting.
  • Improved visibility into retail performance, product performance, store profitability, and sales incentive processes.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Dynamics AX / Axapta
Retail Analytics Sales Reporting Stock Turnover Analysis Sales Velocity Analysis Product Profitability Analysis Store Profitability Analysis Incentive Reporting Data Modeling T-SQL Data Warehousing ELT OLAP Management Reporting
Darty/fnac
Istanbul
1 year
2007-01 - 2007-12

L?Occitane - MS Dynamics NAV ERP Implementation & SQL 2005 CPM Reporting Project

ERP Consultant, BI Consultant ERP Implementation ERP Process Design Data Warehousing ...
ERP Consultant, BI Consultant

Project Description:

ERP implementation and retail reporting project for a cosmetics retail organization. The project started with Microsoft Dynamics NAV process design, technical implementation, and system customization, followed by financial and retail analytics reporting after go-live. The strong understanding of the ERP data model enabled effective reporting design and highlighted the importance of master data quality, process guardrails, and governance directly at the operational system level.

Tasks:

  • Analysed ERP, finance, retail operations, and reporting requirements together with business stakeholders.
  • Designed business processes and ERP structures in Microsoft Dynamics NAV.
  • Implemented technical customizations and adaptations in the ERP environment.
  • Supported ERP go-live activities and operational transition.
  • Designed and implemented financial and retail analytics reporting after ERP go-live.
  • Developed reporting structures based on a detailed understanding of the ERP data model.
  • Identified master data quality issues originating from ERP processes and operational data entry.
  • Supported the definition of process guardrails to improve data quality and reporting reliability.
  • Built analytical views for finance, sales, store operations, and management reporting.
  • Gained hands-on experience in how ERP process design, master data governance, and BI reporting are connected.
MS Dynamics NAV MS SQL Server 2005 MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Excel
ERP Implementation ERP Process Design Data Warehousing ELT OLAP Management Reporting Financial Reporting Retail Analytics Master Data Management Data Governance Data Quality Management Process Design Data Modeling T-SQL Requirements Analysis Dynamics NAV C/Side
L?Occitane
Istanbul
1 year
2006-01 - 2006-12

Roche - Management Reporting Project

BI Consultant Data Warehousing ETL OLAP ...
BI Consultant

Project Description:

Management reporting project for a pharmaceutical organization, mainly focused on finance-oriented reporting with additional sales and operational reporting requirements. This was an early BI consulting project involving ETL development, SQL query writing, OLAP cube design, MDX measure development, report design, and authorization setup based on a Microsoft SQL Server 2000 and OLAP 2000 backend with MIS onVision as the reporting frontend.

Tasks:

  • Supported the implementation of management reporting requirements for finance, sales, and operational reporting.
  • Developed ETL processes using SQL Server DTS to prepare data for reporting and analysis.
  • Wrote SQL queries and transformation logic for analytical reporting needs.
  • Designed and maintained OLAP cube structures using MS OLAP Services 2000.
  • Developed MDX measures and analytical calculations for management reports.
  • Designed reports using MIS onVision as the reporting frontend.
  • Supported authorization and access setup for reporting users.
  • Worked as part of a BI project team and gained hands-on consulting experience in ETL, OLAP, reporting, and pharmaceutical management reporting.
MS SQL Server 2000 MS SQL Server Data Transformation Services MS OLAP Services 2000 MIS onVision Data Transformation Services MIS
Data Warehousing ETL OLAP Management Reporting Financial Reporting Sales Reporting Operational Reporting Cube Design MDX Report Design Authorization Management Data Modeling T-SQL
Roche
Istanbul
1 month
2006-01 - 2006-01

Collezione - Budgeting and Management Reporting Project

BI Consultant Budgeting Planning Corporate Performance Management ...
BI Consultant

Project Description:

Budgeting, planning, and management reporting project for a textile retail organization. The project focused on implementing a corporate budgeting and planning process and extending it with actual reporting capabilities. The solution supported financial and management reporting by combining budget data, planning structures, and actual performance analysis.

Tasks:

  • Supported the implementation of budgeting and planning processes.
  • Analysed budgeting, planning, actual reporting, and management reporting requirements.
  • Worked on the implementation of budgeting models using CPM and OLAP-based MIS ALEA planning tools.
  • Supported the preparation and loading of planning and actual data into the analytical environment using Cubeware Import Master / Importer.
  • Developed management reports and analytical views using MIS onVision.
  • Helped business users compare budget, plan, and actual performance.
  • Supported finance, controlling, sales, and management users with reporting and analysis capabilities.
  • Gained practical experience in corporate budgeting, planning, and management reporting implementation.
MIS MIS Alea MIS OnVision Cubeware Cubeware Import Master Cubeware Importer Microsoft Excel
Budgeting Planning Corporate Performance Management OLAP Management Reporting Actual Reporting Financial Reporting Retail Reporting Data Import Data Modeling ETL
Collezione
Istanbul
1 year
2005-01 - 2005-12

Nexum - Excel-Based Controlling Reporting Automation

Junior Financial Controller Financial Controlling Excel Reporting Automation IAS Reporting Support ...
Junior Financial Controller

Project Description:

Internal finance and controlling reporting automation project. The project focused on transforming recurring Excel-based reporting models into a more automated and structured reporting process for sales, workforce performance, accounting, and controlling reports. The reports were prepared for the CFO and account managers and also supported IAS-based financial reporting activities for Nexum Group Worldwide.

Tasks:

  • Prepared periodic sales, workforce performance, accounting, and controlling reports for the CFO and account managers.
  • Analysed recurring manual Excel reporting processes and identified automation potential.
  • Improved and automated Excel-based reporting models for recurring management and controlling reports.
  • Consolidated financial and operational data into structured reporting templates.
  • Supported sales performance, workforce performance, cost controlling, and accounting reporting processes.
  • Supported the CFO in IAS-based group financial reporting activities.
  • Improved reporting consistency, repeatability, and preparation efficiency.
  • Reduced manual effort and increased reliability of recurring finance and controlling reports.
  • Gained early hands-on experience in finance, controlling, management reporting, and business-oriented data analysis.
Microsoft Excel VBA Microsoft Office
Financial Controlling Excel Reporting Automation IAS Reporting Support Sales Reporting Workforce Performance Reporting Management Reporting Data Consolidation Accounting Reporting Data Validation KPI Reporting Process Automation Business Analysis
Nexum
Istanbul

Aus- und Weiterbildung

Aus- und Weiterbildung

1 year
2025-11 - 2026-10

Fabric Analytics Engineer Associate

DP-600 Certificate, Microsoft
DP-600 Certificate
Microsoft
1 year
2025-11 - 2026-10

Fabric Data Engineer Associate

DP-700 Certificate, Microsoft
DP-700 Certificate
Microsoft
2 years
2008-08 - 2010-07

Technology and Industrial Economics

MA, University of Istanbul
MA
University of Istanbul
4 years
2002-08 - 2006-07

Economics (Major) with Econometrics (Minor)

BA, University of Istanbul
BA
University of Istanbul
8 years
1994-09 - 2002-08

High School

Kadiköy Anatolian High School, Istanbul
Kadiköy Anatolian High School, Istanbul

Position

Position

I currently work as an independent BI and Data Solutions Architect and Senior Consultant with 20 years of hands-on project experience across business intelligence, data platforms, analytics architecture, and enterprise reporting.

Over the course of my career, I have delivered around 40 projects for approximately 30 enterprise customers across industries such as media, finance, retail, pharmaceuticals, automotive, telecommunications, and consumer goods.

My strengths are in modernizing BI and data warehouse landscapes, designing scalable Microsoft-based data platforms, building governed semantic models, and translating business requirements into practical, maintainable data solutions. I combine hands-on technical implementation with architecture, stakeholder management, and end-to-end project delivery experience.

I am particularly interested in projects related to Microsoft Fabric, Azure Synapse, Power BI, data warehousing, Lakehouse and Warehouse architectures, semantic modeling, data product architecture, finance and operational reporting, master data management, and AI-ready analytics platforms. I am especially interested in helping organizations build trusted semantic layers, governed data products, and reliable data foundations that make enterprise data usable not only for human reporting, but also for AI-assisted and agentic analytics scenarios.

Kompetenzen

Kompetenzen

Top-Skills

Microsoft Fabric Data Platform Architecture Semantic Modeling Data Platform Modernization Analytics Governance Data Product Architecture Power BI Data Engineering Datawarehouse Data Lake Berechtigungen AI-Ready Analytics Data Products Trusted Analytics SQL

Schwerpunkte

Business Intelligence
Data Warehousing
Data Lakehouse
Data Platform Architecture
Microsoft Fabric
Azure Synapse Analytics
Power BI
Semantic Modeling
Data Modeling
Enterprise Reporting
Management Reporting
Data Product Architecture
Data Governance
Master Data Management
BI Modernization
AI-Ready Analytics

Aufgabenbereiche

Requirements Analysis
Data Warehouse Design
Data Lakehouse Design
ETL Pipeline Design
ELT Process Design
Analytical Reporting Layer Design
Semantic Model Design
Performance Reporting
Management Reporting
Planning
Budgeting
Forecasting
Finance Reporting
Sales Reporting
HR Reporting
Executive Reporting
Stakeholder Management
Project Management
Data Product Design
Data Platform Modernization
Solution Architecture
BI Architecture
Technical Leadership
Governance
Business Process Optimization
AI-Ready Analytics

Produkte / Standards / Erfahrungen / Methoden

Agile Delivery
Scrum
DevOps
CI/CD
Requirements Engineering
Data Governance
Dimensional Modeling
Data Vault
Medallion Architecture
Data Product Design
Master Data Management
Self-Service BI
AI-Ready Analytics
Microsoft Fabric
Power BI
Azure Synapse Analytics
Azure Analysis Services
SQL Server
SSIS
SSAS
SSRS
Tabular Editor
Azure DevOps
Azure Data Lake Storage Gen2
Microsoft Excel
Microsoft Dynamics
Microsoft Dynamics AX
Microsoft Dynamics NAV
Azure
Elastic Search
RabbitMQ
Entity Framework
Redis
ASP.NET
Winforms
ASP.NET Core
WCF
WebAPI
GraphQL
Bootstrap

Developed and Owned Commercial Products:

Spectra?

Developed an Add-in and a COM Automation for Mercedes Benz which simply enables end users to write back over aggregated data at the most granular level by using daily life Microsoft Excel to replace existing IBM TM1 for Budgeting and Forecasting operations. First started as a project (which was also internally awarded by the firm for reducing existing IBM TM1 Software License cost to zero) and became a registered commercial product which was finally merged into the BudgetPort? Suite.


BudgetPort? Suite

Developed to be an alternative for Microsoft Office PerformancePoint Server after it was discontinued. This is fully functional Corporate Budgeting and Planning software with Forecasting, Cost Allocation, Consolidation and Reporting capabilities which was used by multi branch/store companies like Banks, Retailers and Fast-Food Companies.


Piv-Hoc

Developed as a side project to address a need of lightweight, simple, plug and play reporting tool for corporate end-users where they can download, install and use within 5 minutes to analyze mainly OLAP Cubes and Databases. This tool is finally merged into the BudgetPort? Suite and created the awareness that is required to develop our next wave reporting product: Dashsense?.  


Dashsense?

After success and the acceptance of Piv-Hoc by our customers and the idea of being able to access corporate data hassle-free and easily, we?ve developed our fully functional Business Intelligence Reporting Tool and Portal with our prior knowledge and practical experience that we?ve gathered from our Business Intelligence consultancy background. Dashsense can connect all major data sources like SQL Server, Oracle, MySql, PostgreSQL, SAP Hana, Amazon Redshift etc. Dashsense has more than 10 corporate customers (like Pernod Richard, Bayer, Peugeot etc.) and around 2000 active corporate users.


Portaxis

Developed as a side project but turned into a licensed product to facilitate data entry and integration without requiring ETL just by using an ordinary Microsoft Office Excel. Portaxis enables end users to edit and enter any relational data to support scenarios like master data editing, updating parameters, budget entries, mass/bulk transactional data import, legacy data integration or merging user data in satellite excels into a database without omitting the business rules. This also helps reducing amount of creating small ETL packages for IT/BI departments. Portaxis also acts as a single-version-of-truth master data source for end-users who are willing to export and use structured data in their ad-hoc analyses.


Rethubs Suite?

Rethubs is a SaaS based B2C Customer Data Platform (CDP) and Loyalty Management software which is in latest phase before release and is being developed with latest .Net Core Stack (along with ElasticSearch, RabbitMQ, Redis, Azure Functions) and Microservice Architecture that is hosted in Microsoft Azure. Core software architecture and infrastructure solely designed by me and being implemented by the special task force team that I was leading. Rethubs currently has following functionalities: automatic customer data cleansing, merging and deduping; customer 360 views, customer segmentation; automatic customer clustering (with statistical algorithms like K-Means), campaign management and loyalty management. Rethubs is my masterpiece of my software career so far which combines near-big-data, ETL process and data integration, business knowledge, reporting, hard-core statistics and software development techniques altogether.

Programmiersprachen

T-SQL
MDX
DAX
VBA
VB
VB.NET
C#
Python
JavaScript
HTML
CS

Datenbanken

MS SQL Server
Azure SQL Database
Azure Synapse Analytics
Microsoft Fabric Warehouse
Microsoft Fabric Lakehouse
Azure Data Lake Storage Gen2
SQL Server Analysis Services
Azure Analysis Services
Oracle
PostgreSQL
MySQL
Delta/Parquet

Datenkommunikation

ETL
ELT
Data Synchronization
BI-Directional Data Exchange
API Integration
ERP Integration
CRM Integration
HRMS Integration

Berechnung / Simulation / Versuch / Validierung

Financial Forecasting
Budgeting
Planning
Scenario Simulation
What-If Analysis
OPEX Allocation
Cost Allocation
Bonus and Incentive Calculation
Forecast Simulation
Data Validation
Data Reconciliation
KPI Calculation
Business Rule Validation
Test-Driven Data Platforms

Design / Entwicklung / Konstruktion

BI and Data Solutions and Platform Design
Data Warehouse Design
Lakehouse Design
Semantic Model Design
ETL - ELT Design
Database Design
Dimensional Modeling
Tabular Modeling
Power BI Report Design
Portal Design
.NET Development
ASP.NET Development
Excel Add-in Development

Buchhaltung

Financial Accounting
General Ledger
Chart of Accounts
Journal Entries
Month-End Closing
Year-End Closing
Statutory Reporting
IAS Reporting
IFRS Reporting

Controlling

Financial Controlling
Management Reporting
Budgeting
Planning
Forecasting
Budget vs Actual Analysis
Cost Center Reporting
Profitability Analysis
P&L Analysis
Balance Sheet Analysis
Cash Flow Analysis
Cost Allocation
OPEX Allocation
KPI Reporting
Performance Reporting
Sales Controlling
Operational Controlling
Executive Reporting
Scenario Analysis
What-If Analysis

Cash Management / Treasury

Treasury Reporting
Cash Flow Forecasting
Financial Forecasting
Working Capital Analysis
WACC
CAPM
Operating Free Cash Flow
Shareholder Value
Scenario Simulation
P&L Simulation
BS Simulation
Tax Impact Analysis

Finance & HR

Financial Reporting
Finance Data Modeling
FP&A
Budgeting
Planning
Forecasting
P&L Reporting
Balance Sheet Reporting
Cash Flow Reporting
Budget vs Actual Analysis
Cost Center Reporting
Profitability Analysis
Cost Allocation
OPEX Allocation
Bonus Calculation
Incentive Management
HR Reporting
Payroll Integration

Riskmanagement

Data Quality Management
Reporting Reliability
Process Control
Governance
Auditability
Access Control
Operational Risk Reduction
Business-Critical Reporting
Data Reconciliation
Validation Controls

Compliance & Sicherheit Finanzwesen

Row-Level Security
Object-Level Security
Authorization Management
Access Governance
Role-Based Access Control
Entra Group-Based Access Control
Audit Logging
Approval Workflows
Data Privacy
Sensitive Data Handling
Governance Workflows

Managementerfahrung in Unternehmen

Team Leadership
Technical Leadership
Product Owner
Project Leadership
Delivery Management
Roadmap Definition
Resource Planning
Engineering Team Management
Stakeholder Management
R&D Management
Product Strategy

Personalverantwortung

Team Leadership
Team Building & Hiring
Engineering Team Leadership
Coaching
Resource Planning
Task Coordination
Delivery Coordination
Capability Development
Mentoring

Branchen

Branchen

I have strong industry expertise across business intelligence, data platforms, analytics, reporting, and data-driven business transformation initiatives in a wide range of enterprise environments.

One of my key strengths is my extensive business and domain knowledge. Because I have worked closely with business stakeholders throughout my career and started my professional journey in finance as a Financial Controller, I am able to understand business requirements and flaws in the process quickly and translate them into effective analytical and technical solutions. Business users often find it easy to communicate their needs to me, as I can speak both the language of business and the language of technology, helping bridge the gap between operational requirements and data-driven solutions.

My experience spans pharmaceuticals, retail, media, finance, automotive, banking, telecommunications, and customer experience / BPO sectors. Throughout my career, I have delivered solutions supporting financial management, sales performance analysis, operational reporting, customer analytics, master data governance, supply chain optimization, workforce performance management, and executive decision-making processes.

In pharmaceutical and life sciences organizations, I supported commercial effectiveness, sales performance monitoring, territory and market analysis, incentive management, financial performance tracking, operational planning, and data integration initiatives that enabled reliable and timely business insights.

In retail and consumer goods environments, I worked on customer experience improvement, loyalty and retention programs, campaign effectiveness analysis, customer segmentation, inventory optimization, replenishment planning, store performance management, order lifecycle visibility, and data-driven operational decision-making.

In finance, banking, and automotive finance organizations, I contributed to budgeting, forecasting, profitability analysis, financial performance management, cash flow monitoring, treasury processes, branch and channel performance analysis, regulatory reporting, risk and compliance reporting, and enterprise planning initiatives. Having started my career as a Financial Controller, finance remains one of my strongest domains. I have a deep understanding of management reporting, budgeting, forecasting, P&L analysis, balance sheet structures, cash flow management, cost allocation, profitability analysis, and financial planning processes, allowing me to work effectively with finance teams and senior management.

Across all industries, my focus has been on transforming business data into actionable insights, improving reporting and analytical capabilities, streamlining business processes, strengthening data quality and governance, and enabling more effective strategic and operational decision-making.

I combine this industry knowledge with deep technical expertise in Microsoft BI, Microsoft Fabric, Azure Synapse, Power BI, SQL Server, data warehousing, semantic modeling, and enterprise analytics platforms.

Einsatzorte

Einsatzorte

Düsseldorf (+100km) Frankfurt am Main (+50km)
Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

1 month
2026-04 - now

dentsu - Microsoft Fabric Data and Analytics Project for EMEA

BI and Data Solutions Architect / Senior Consultant Data Platform Architecture Data Platform Modernization Data Warehousing ...
BI and Data Solutions Architect / Senior Consultant

Project Description:

Ongoing EMEA data and analytics project focused on extending dentsu EMEA's on premises MS SQL Datawarehouse based BI architecture towards Microsoft Fabric. The project covers Operational and Finance data products, Lakehouse and Warehouse design, semantic modeling, reporting enablement, governance, and platform modernization across EMEA.


Tasks:

  • Working on the architecture and implementation of the EMEA data and analytics platform.
  • Extending the existing global Azure-based architecture for EMEA reporting and analytics requirements.
  • Designing Microsoft Fabric Lakehouse, Warehouse, and Semantic Model structures based on Medallion Architecture.
  • Developing reusable, domain-oriented data products, starting with the Finance domain.
  • Supporting the transition of existing MS SQL Based Data Vault 2.0 Datawarehouse, Azure Analysis Services, and Power BI workloads towards Microsoft Fabric.
  • Designing data ingestion, transformation, dimensional modeling, and semantic modeling layers.
  • Optimizing Power BI semantic models using Tabular Editor, DAX, aggregations, calculation groups, and incremental refresh patterns.
  • Supporting development standards, version control, and CI/CD deployment processes using Azure DevOps.
  • Collaborating with business and technical stakeholders to translate requirements into scalable and maintainable data solutions.
Microsoft Fabric Power BI ETL Azure Devops MS Azure SQL Database
Data Platform Architecture Data Platform Modernization Data Warehousing Data Vault 2.0 Lakehouse Architecture Warehouse Architecture Medallion Architecture Domain-Oriented Data Products Data Product Design Data Ingestion Data Transformation Dimensional Modeling Semantic Modeling Tabular Modeling DAX T-SQL Aggregations Calculation Groups Incremental Refresh Performance Optimization Governance CI/CD Version Control Requirements Analysis Stakeholder Management C# Python SQL
dentsu
Germany - Remote
1 month
2026-04 - now

dentsu - Germany Process Optimisation and Program Efficiency Project

Process and Solutions Architect / Senior Consultant Process Analysis Process Optimisation Digitalisation ...
Process and Solutions Architect / Senior Consultant
Project Description

Ongoing process optimisation and digitalisation project for dentsu Germany, focused on improving operational efficiency, reporting automation, master data quality, and internal delivery processes. The project includes the transition from Excel-based reporting to Power BI, the design of a Customer 360 master data management solution, customer contract and team management capabilities, self-service master data maintenance, self-service authorization processes, and DevOps-based delivery practices.


Tasks

  • Analysing existing business processes, reporting structures, and operational workflows.
  • Supporting the digitalisation of Excel-based reporting processes by moving recurring reports to Power BI.
  • Designing a Customer 360 master data management solution.
  • Working on master data concepts, data ownership, data quality, and governance requirements.
  • Designing customer contract and team management capabilities.
  • Designing self-service functionality for tactical master data maintenance.
  • Designing a self-service authorization and access request portal.
  • Supporting the setup of DevOps-based delivery practices, requirement management, release planning, and development governance.
  • Collaborating with business and technical stakeholders to translate operational requirements into maintainable solutions.


MS Excel Microsoft Fabric MS Power BI MS Fabric Low Code / No Code Applications Gapteq
Process Analysis Process Optimisation Digitalisation Reporting Automation Master Data Management Customer 360 Data Governance Self-Service Portal Design Authorization Management DevOps Practices Requirements Management Stakeholder Management SQL C#
dentsu
Germany - Remote
1 year 7 months
2025-06 - 2026-12

dentsu - Project Sakura - A Self-Service Authorization & Access Governance Portal (OLS/RLS) for Microsoft Fabric / Power BI

Product Owner, Solution Architect, Software Developer Product Architecture Authorization Management Access Governance ...
Product Owner, Solution Architect, Software Developer

Project Description:

Product and architectural leadership of Sakura, a self-service authorization management portal that standardizes how enterprise users request, approve, and manage access to Power BI reports and datasets. Sakura orchestrates governance workflows across Object-Level Security (OLS) and Row-Level Security (RLS), provides auditing and notifications, and aligns access outcomes with enterprise security controls via Entra group-based mechanisms and data platform integrations.


Tasks:

  • Owned product vision and architecture of Sakura as a centralized portal for requesting/approving/managing analytics access.
  • Defined functional scope covering OLS and RLS, including lifecycle workflows, approval routing, auditing/logging, delegation patterns, and support operations.
  • Designed the conceptual model mapping Sakura objects (workspaces, apps, audiences, reports) to Microsoft Fabric / Power BI governance needs.
  • Architected system components and integrations: portal UI, identity/authentication, application database, ETL patterns, and downstream sharing of approved access outputs.
  • Established OLS governance patterns, including managed vs unmanaged scenarios and Entra group-based access control principles.
  • Defined roles and responsibilities across requesters, line managers, OLS approvers, RLS approvers, workspace owners, support, and central administration.
  • Led version evolution and stakeholder alignment across Sakura 1 ? Sakura 2.x discussions, readiness topics, and rollout planning.
  • Managed cross-team backlog shaping and iterative improvements for Sakura 2.x based on domain feedback and rollout constraints.
  • Governed dependencies between access management and master data / hierarchy quality (including operational workarounds where required).
MS Azure SQL Database Angular Node.js Azure Azure Devops
Product Architecture Authorization Management Access Governance OLS RLS Workflow Design Approval Processes Audit Logging Identity and Access Management Entra Group-Based Access Control Data Platform Integration Backlog Management Stakeholder Alignment Rollout Planning Master Data Governance C# JavaScript SQL Angular .NET API
dentsu
Germany - Remote
2 years
2024-04 - 2026-03

dentsu - Microsoft Fabric Migration and Data Product Architecture Project

Lead Enterprise BI and Data Solutions Architect Data Platform Modernization Semantic Modeling Data Modeling ...
Lead Enterprise BI and Data Solutions Architect

Project Description:

Migration and architectural evolution of dentsu?s Azure Synapse-based data platform towards Microsoft Fabric. The project focused on Lakehouse and Warehouse design, Medallion Architecture, domain-oriented data products, semantic modeling, governance, and scalable analytical workloads.

Tasks:

  • Led the architectural transition from Azure Synapse towards Microsoft Fabric.
  • Designed Fabric Lakehouse, Warehouse, Semantic Model, and Power BI structures.
  • Applied Medallion Architecture principles for Bronze, Silver, and Gold layers.
  • Designed reusable, domain-oriented data products.
  • Delivered the Finance domain as an initial Fabric-based data product.
  • Designed Spark-based data engineering patterns in Microsoft Fabric.
  • Supported the migration of Synapse, Azure Analysis Services, and Power BI workloads.
  • Optimized semantic models using DAX, Tabular Editor, aggregations, calculation groups, and incremental refresh.
  • Defined platform standards, development guidelines, and governance principles.
  • Supported CI/CD, version control, and structured deployment practices using Azure DevOps.
Microsoft Fabric Fabric Lakehouse Fabric Warehouse Power BI Power BI Semantic Models Azure Synapse Analytics Azure Analysis Services Azure Data Lake Storage Gen2 Tabular Editor Azure DevOps
Data Platform Modernization Semantic Modeling Data Modeling Medallion Architecture Lakehouse Architecture Warehouse Architecture T-SQL DAX CI/CD Delta/Parquet Data Product Architecture
dentsu
Germany - Remote
3 years 10 months
2022-03 - 2025-12

dentsu - Project Ronin - Centralized Data Collection & Master Data / Mapping Platform

Product Owner, Software Developer Product Architecture Master Data Management Workflow Design ...
Product Owner, Software Developer

Project Description:

Product and architecture leadership of Ronin, an internal platform designed to centralize business inputs such as forecasts, targets, master data mappings, and security-relevant datasets, and to integrate them into the Samurai analytics layer consumed by Power BI reporting. The platform combines structured data capture with governance workflows, historization, and controlled access patterns to enable scalable and auditable operations across domains.

Tasks:

  • Led end-to-end product ownership, strategy, and solution architecture for , translating stakeholder needs into a scalable platform roadmap and technical solution.
  • Designed Ronin?s enterprise data platform integration, including staging, enrichment, and output layers, ensuring master data and mappings flow reliably into Power BI / Samurai analytics.
  • Delivered domain-specific Ronin modules that brought master data mappings, parameters, ratios, and business inputs previously managed in personal satellite Excel files under a modern, governed, and auditable application platform.

  • Established database-centric implementation patterns such as stored procedures, triggers, historization, change data capture, entry/history handling, and safe rollback support.

  • Designed and operationalized controlled change request workflows, including draft, submission, stakeholder review / veto window, approval or rejection, execution, confirmation, and audit record keeping.

  • Implemented governance, role-based access control, and segregation-of-duties principles to ensure sensitive master data changes are authorized, transparent, traceable, and auditable.

  • Led adoption of the Ronin UI for mapping maintenance, improving reporting consistency and reducing manual or fragmented maintenance activities.

  • Defined refresh, synchronization, and propagation expectations so approved mapping changes appear near real-time in downstream analytics layers.

  • Transitioned Ronin into BAU operations through release cycles, release notes, user communication, monitoring, support processes, and continuous improvement practices.

MS Azure SQL Database DevExpress Gapteq Azure Devops
Product Architecture Master Data Management Workflow Design Role-Based Access Control Historization SQL Data Governance Solution Architecture Change Data Capture Stored Procedures Audit Logging T-SQL HTML Data Platform Integration Javascript Release Management Stakeholder Management BAU Transition CSS
dentsu
2 years 2 months
2022-02 - 2024-03

dentsu - Global Data Platform Modernization, SQL Server to Azure Synapse Upgrade Project

Lead Enterprise BI and Data Solutions Architect Dedicated SQL Pool Serverless SQL T-SQL ...
Lead Enterprise BI and Data Solutions Architect

Project Description:

Modernization of dentsu?s on-premises Microsoft BI and data warehouse environment into an Azure-based analytical platform. The project covered the migration from SQL Server, SSIS, SSAS Tabular, and Data Vault-based structures to Azure Synapse, ADLS Gen2, Azure Analysis Services, and Power BI.

Tasks:

  • Led the modernization of the on-premises SQL Server, SSIS, SSAS, and Data Vault-based BI environment.
  • Designed the target Azure-based data platform architecture.
  • Migrated the SSAS Tabular model to Azure Analysis Services.
  • Optimized ETL and data warehouse structures for performance, stability, and maintainability.
  • Designed scalable data integration and transformation patterns in Azure Synapse.
  • Used Dedicated SQL and Serverless SQL capabilities for analytical workloads.
  • Standardized dimensional and tabular modeling practices using Tabular Editor.
  • Implemented aggregations, calculation groups, and incremental refresh automation.
  • Implemented version control and CI/CD deployment workflows using Azure DevOps.
  • Supported the transformation into a reusable, scalable, Azure-based analytics platform.


Azure Synapse Analytics Azure Analysis Services Power BI SQL Server SSIS SSAS Tabular ADLS Gen2
Dedicated SQL Pool Serverless SQL T-SQL DAX Tabular Editor Azure DevOps CI/CD Data Vault
dentsu
2 years
2020-02 - 2022-01

dentsu - Financial Data Warehouse and BI Platform Project

Senior Consultant BI & Data Management Data Warehousing ELT ETL ...
Senior Consultant BI & Data Management
Project Description:
Business intelligence and data warehouse project for dentsu, delivered as a Senior Consultant at Qunis GmbH. The project focused on building and improving an on-premises Microsoft BI environment for financial, operational, and management reporting. The solution covered SQL Server-based data warehouse development, SSIS-based data integration, SSAS Tabular semantic modeling, and Power BI reporting.

Tasks:

  • Designed and implemented SQL Server and Data Vault based data warehouse and ELT solutions.
  • Developed SSIS packages for data ingestion, transformation, orchestration, and operational data processing.
  • Built and optimized SSAS Tabular semantic models for financial and management reporting.
  • Implemented aggregations, calculation groups, and custom incremental refresh automation to improve model performance and reduce processing time.
  • Developed Power BI dashboards and analytical reporting layers for business stakeholders.
  • Refactored existing ETL processes, data models, and refresh patterns to improve stability, scalability, and maintainability.
  • Coordinated requirements, engineering tasks, timelines, and client communication.
  • Supported end-to-end BI project delivery from requirements analysis to implementation and reporting enablement.


SQL Server SQL Server Analysis Services Tabular MS SQL Server Integration Services Power BI Tabular Editor Azure DevOps SSIS MS SQL Server Analysis Services SQL Server Integration Services SSAS
Data Warehousing ELT ETL Semantic Modeling Tabular Modeling Dimensional Modeling T-SQL DAX Calculation Groups Aggregations Incremental Refresh Performance Optimization Requirements Analysis Stakeholder Management Project Delivery
dentsu
Germany - Remote
1 year
2018-01 - 2018-12

Comdata / Konecta - Call Center Reporting and Data Product Transformation Project

BI & DWH Architect, Senior BI Consultant Call Center Reporting Data Product Design Data Warehousing ...
BI & DWH Architect, Senior BI Consultant

Project Description

Business intelligence and data warehouse transformation project for a large call center and BPO organization. The project focused on moving from fragmented ad-hoc reporting and direct operational database queries towards a standardized, scalable, and governed BI platform. It covered call center reporting, agent performance, cost analysis, operational KPIs, customer-specific reporting models, master data standardization, tenant-based DWH structures, and the transition towards reusable data products.

Tasks

  • Analysed the existing reporting landscape across multiple operational call center systems and reporting tools.
  • Reviewed more than 300 existing reports and identified duplication, inconsistent KPI definitions, data quality issues, and multiple-version-of-truth problems.
  • Designed and implemented a Microsoft BI-based data warehouse approach to reduce direct reporting load on operational systems.
  • Developed ETL/ELT processes for call center, agent performance, cost, operational, and customer-specific reporting data.
  • Designed tenant-based DWH structures to ensure customer data isolation and support scalable customer-specific reporting.
  • Established master data management concepts, data catalog structures, KPI definitions, and reporting standards.
  • Designed standardized reporting templates and reusable data models for operational and management reporting.
  • Implemented change request and report lifecycle processes to improve control, traceability, and maintainability.
  • Designed parallel and multi-threaded ETL processing patterns to support scalable data processing.
  • Supported the shift from ad-hoc report delivery towards reusable data products and service packages.
  • Designed concepts for custom data and report models for customers requiring reporting beyond the standard package.
  • Supported governance, data privacy, customer isolation, and operational stability improvements.
  • Worked with business and technical stakeholders to stabilize BAU reporting, reduce manual effort, and improve reporting reliability.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Power BI QlikView AVAYA SYTEL ININ Visual Studio Team Services
Call Center Reporting Data Product Design Data Warehousing ELT OLAP Management Reporting Operational Reporting Tenant-Based Architecture Master Data Management Data Governance KPI Standardization Data Catalog Change Request Management ETL Optimization Performance Optimization Data Modeling T-SQL Requirements Analysis Stakeholder Management
Comdata Group / Konecta
Istanbul
2 years
2017-01 - 2018-12

Apollo / Grand Vision - Customer, Retail, and Loyalty Experience Management and Reporting Project (CXM, RXM, LXM)

Solution Architect, Software Developer, Senior BI Consultant, Project Lead Customer Experience Management Loyalty Management Retail Analytics ...
Solution Architect, Software Developer, Senior BI Consultant, Project Lead

Project Description

Business-critical customer experience, loyalty management, and retail intelligence platform for an optics retailer. The project focused on designing both the operational processes and the analytical foundation for a customer-centric retail environment. It enabled Customer 360 views, omnichannel customer access, campaign management, loyalty processes, customer satisfaction tracking, and operational order management across stores, call center, and central HQ.

Tasks

  • Designed and implemented a business-critical operational and analytical platform for customer experience and loyalty management.
  • Worked with the customer to design and improve operational business processes where no mature operational infrastructure existed before.
  • Built a centralized Customer 360 view by consolidating customer, order, store, call center, loyalty, and interaction data.
  • Enabled omnichannel access to customer information across stores, call center, marketing, sales, and management users.
  • Designed operational capabilities for offers, order tracking, returns, customer satisfaction processes, and reward management.
  • Integrated operational data from the platform into analytical and reporting structures.
  • Supported marketing teams with customer segmentation, A/B testing, campaign planning, campaign execution, and performance tracking.
  • Established a single version of truth for customer data across operational and analytical processes.
  • Designed and implemented loyalty program capabilities, including reward tracking and customer engagement processes.
  • Supported customer satisfaction and recommendation survey processes and enabled analytical evaluation of survey results.
  • Improved retail intelligence, customer visibility, campaign effectiveness, and operational process transparency.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Dynamics AX Microsoft Excel
Customer Experience Management Loyalty Management Retail Analytics Omnichannel Analytics Campaign Management Customer Segmentation A/B Testing Survey Analytics Order Management Customer 360 Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Apollo / GrandVision
Istanbul
1 year
2017-01 - 2017-12

Penti - Replenishment and Allocation Management Project

Solution Architect, Software Developer, Senior BI Consultant Retail Analytics Replenishment Allocation Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Replenishment, allocation, and inventory optimization project for a retail organization. The project focused on improving store stock management, automated stock distribution, campaign stock protection, inter-store stock transfers, and reporting around sales velocity, stock turnover, and store performance. The solution combined operational application development with BI and analytical reporting capabilities.

Tasks

  • Analysed replenishment, allocation, stock distribution, campaign planning, and store stock management requirements.
  • Designed and implemented a custom solution for replenishment and allocation management.
  • Developed logic for automated stock distribution based on sales velocity, stock turnover, store characteristics, and product performance.
  • Designed reporting and analytical structures for stock turnover, sales velocity, inventory levels, and store performance.
  • Implemented campaign stockout protection algorithms to improve product availability during campaign periods.
  • Developed store size classification logic to support differentiated replenishment and allocation strategies.
  • Designed and implemented inter-store stock transfer algorithms.
  • Enabled users to manage operational inputs and allocation parameters through application and Excel-based interfaces.
  • Integrated operational replenishment and allocation data into analytical reporting structures.
  • Supported merchandising, supply chain, planning, category management, store operations, and management teams with reporting and decision support.
  • Reduced manual effort in stock distribution and improved transparency in replenishment and allocation decisions.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Excel
Retail Analytics Replenishment Allocation Management Inventory Optimization Stock Distribution Stock Turnover Analysis Sales Velocity Analysis Campaign Stockout Protection Inter-Store Stock Transfer Store Performance Analysis Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Penti Lingerie
Istanbul
1 year
2017-01 - 2017-12

Penti - Store Shift/Timesheet Management Reporting Project

Solution Architect, Software Developer, Senior BI Consultant Retail Analytics Workforce Planning Staff Transfer Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Store workforce planning and digitalization project for a retail organization. The project focused on managing staff transfers between stores, personnel rotation planning, timesheet-related processes, and workforce visibility across stores, regional management, HR, finance, and operations. The solution replaced paper-based and Excel-based processes with a structured digital application and reporting environment.

Tasks

  • Analysed staff transfer, rotation planning, timesheet, and workforce planning requirements.
  • Designed and implemented a digital solution for managing personnel transfers between stores.
  • Developed functionality for store staff rotation planning and operational workforce coordination.
  • Replaced paper-based and Excel-based planning processes with structured digital workflows.
  • Designed reporting structures for workforce planning, staff allocation, store capacity, and personnel cost visibility.
  • Supported HR, store operations, regional managers, store managers, finance, and management users.
  • Integrated operational workforce data into analytical reporting structures.
  • Developed application and reporting components using Microsoft BI and .NET technologies.
  • Improved transparency, traceability, and efficiency in store workforce planning processes.
  • Reduced manual effort and improved digital process control across store operations.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Excel
Retail Analytics Workforce Planning Staff Transfer Management Rotation Planning Timesheet Management Store Operations Digitalization Process Automation Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Penti Lingerie
Istanbul
1 year
2016-01 - 2016-12

Penti - Master Data Management and Data Governance Project

Solution Architect, Software Developer, Senior BI Consultant Master Data Management Data Governance Data Quality Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Master data management and governance project for a retail organization with significant master data quality and consistency issues. The project focused on establishing a single version of truth across product, customer, store, supplier, and hierarchy-related master data. It aimed to improve data quality, reporting reliability, system-to-system data exchange, and governance across business and IT processes.

Tasks

  • Analysed existing master data structures, data quality issues, ownership gaps, and system integration problems.
  • Identified the impact of inconsistent master data on reporting, analytics, and data exchange between operational systems.
  • Proposed and designed a centralized master data management approach to establish a single version of truth.
  • Designed master data structures for product, customer, store, supplier, and hierarchy management.
  • Defined data governance principles, guardrails, responsibilities, ownership models, and maintenance processes.
  • Designed validation rules and control mechanisms to improve data quality and reduce duplicate or inconsistent records.
  • Implemented MDM-related data models, workflows, and reporting structures using Microsoft BI technologies.
  • Supported business and IT stakeholders in defining master data responsibilities and governance processes.
  • Improved reliability of analytical reporting and operational data exchange through standardized master data.
  • Established a governed foundation for future retail analytics, operational systems, and management reporting.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services
Master Data Management Data Governance Data Quality Management Single Version of Truth Hierarchy Management Data Ownership Data Validation Data Modeling T-SQL Requirements Analysis Stakeholder Management .NET ASP.NET Excel Add-in ERP integration
Penti Lingerie
Istanbul
1 year
2016-01 - 2016-12

Penti - Customer, Retail, and Loyalty Experience Management Project (CXM, RXM, LXM)

Solution Architect, Software Developer, Senior BI Consultant Customer Experience Management Retail Experience Management Loyalty Management ...
Solution Architect, Software Developer, Senior BI Consultant

Project Description

Customer and retail experience management project for a large retail organization. The project focused on creating a structured customer intelligence foundation by designing and implementing a loyalty card program, customer analytics capabilities, campaign management support, and retail experience reporting. A key objective was to make anonymous retail transactions identifiable through loyalty card usage, enabling customer-level analysis based on shopping behaviour, demographics, store visits, and product preferences.

Tasks

  • Designed and implemented a customer and retail experience management solution for marketing, CRM, store operations, sales, and management users.
  • Designed the loyalty card program concept, including card lifecycle, customer registration, POS integration, point collection, and bonus management.
  • Developed an internet-facing loyalty card portal for customer usage and account-related interactions.
  • Integrated loyalty card data with POS transactions to identify customers behind receipt-based retail purchases.
  • Enabled customer-level analysis of purchasing behaviour, product preferences, store visits, demographics, and campaign responses.
  • Designed Customer 360 and retail intelligence structures based on customer, transaction, product, store, and campaign data.
  • Supported customer segmentation and targeted campaign planning based on customer habits and demographic attributes.
  • Built reporting and analytical structures for loyalty performance, campaign effectiveness, customer behaviour, and retail experience.
  • Helped transform anonymous POS sales data into identifiable customer insight.
  • Improved marketing, campaign management, customer profiling, and retail decision support capabilities.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework POS Systems
Customer Experience Management Retail Experience Management Loyalty Management Customer 360 Retail Analytics Customer Segmentation Campaign Management Demographic Analysis POS Data Integration Customer Identification Data Warehousing ELT OLAP Management Reporting Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Penti Lingerie
Istanbul
1 year
2015-01 - 2015-12

Bayer - Datawarehouse and Sales Reporting Project

Senior BI Consultant Data Warehousing ELT OLAP ...
Senior BI Consultant

Project Description

Sales reporting, field force performance, and management reporting project for a pharmaceutical organization. The project focused on building analytical structures for sales, brick-level performance, business unit reporting, therapeutic area analysis, exceptional sales detection, bonus and performance calculations, and scenario-based simulations.

Tasks

  • Analysed sales reporting, field force performance, CRM, IMS, and management reporting requirements.
  • Designed and implemented data warehouse structures for pharmaceutical sales and performance analysis.
  • Developed ETL/ELT processes to integrate sales, CRM, IMS, field force, and product-related data.
  • Built reporting and analytical models for brick sales analysis, business unit performance, and therapeutic area analysis.
  • Implemented exceptional sales detection logic to identify unusual sales patterns and outliers.
  • Designed bonus and performance calculation logic for sales and field force reporting.
  • Supported what-if scenarios and simulations for sales, performance, and business planning use cases.
  • Built management reports and analytical views for sales, field force, marketing, finance, and management users.
  • Improved visibility into sales performance, territory-level activity, and pharmaceutical business KPIs.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services IMS
Data Warehousing ELT OLAP Management Reporting Sales Reporting Pharmaceutical Reporting Field Force Performance Brick Sales Analysis Business Unit Analysis Therapeutic Area Analysis Bonus Calculation Performance Calculation What-If Analysis Simulation Exceptional Sales Detection Data Modeling T-SQL Requirements Analysis Stakeholder Management
Bayer
Istanbul
1 year
2015-01 - 2015-12

Domino?s Pizza - Datawarehouse and Management Reporting Project

Senior BI Consultant Management Reporting Operational Reporting Restaurant Analytics ...
Senior BI Consultant

Project Description

Data warehouse and management reporting project for a large quick service restaurant network with more than 300 stores. The project focused on consolidating store sales, order, delivery, online sales, offline restaurant sales, campaign, customer, and operational performance data into a central BI environment. A key challenge was reliable data collection from many store-level servers under varying network conditions, closing times, and operational constraints.

Tasks

  • Analysed store sales, order management, delivery performance, campaign, customer, and management reporting requirements.
  • Designed and implemented data warehouse structures for restaurant, store, order, customer, delivery, and campaign analysis.
  • Developed ETL/ELT processes to collect data from more than 300 store servers and local order management databases.
  • Designed resilient data extraction logic to handle slow internet connections, connection losses, and repeated data transfer risks.
  • Implemented retry and repeat-protection mechanisms to improve reliability of distributed store data collection.
  • Designed logic to track different store closing times and trigger end-of-day reporting processes accordingly.
  • Integrated online sales and offline restaurant sales data to support unified customer and order analysis.
  • Built Customer 360 and preference analysis structures based on ordering behaviour, product choices, and pizza topping customization.
  • Analysed customer preferences and product customization patterns to support product and menu improvement decisions.
  • Developed reporting for 30-minute delivery guarantee performance, delivery delays, and delay reasons.
  • Built management reports and analytical views for operations, store management, franchise management, marketing, finance, and executive users.
  • Supported international scale-out of the solution to Azerbaijan and Turkic republics using a dynamic and configurable ETL structure.
  • Enabled rapid technical rollout to new countries through reusable and configurable data integration patterns.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services POS Systems Online Ordering Systems Store Order Management Systems
Management Reporting Operational Reporting Restaurant Analytics Store Performance Analysis Order Analysis Delivery Performance Analysis Campaign Analysis Customer 360 Customer Preference Analysis Distributed ETL Resilient Data Integration ETL Optimization Configurable ETL Design Data Modeling T-SQL Requirements Analysis Stakeholder Management Data Warehousing ELT OLAP
Domino?s Pizza
Istanbul
1 year
2014-01 - 2014-12

Kuveyt Türk Bank - Management Reporting, Budgeting and Planning Project

Senior BI Consultant, Software Developer Data Warehousing ELT OLAP ...
Senior BI Consultant, Software Developer

Project Description

Management reporting, budgeting, and planning project for a banking environment with strict security and governance requirements. The project covered bank-wide financial reporting, P&L and balance sheet reporting, regulatory reporting support for Turkish Banking Regulation and Supervision Agency, target entry and tracking, and budgeting processes for Bank Branches. As Microsoft Office PerformancePoint Server was being discontinued, a custom Excel-based writeback solution was developed to replace the existing budgeting functionality and later evolved into a commercial product, the BudgetPort? Suite.

Tasks

  • Analysed budgeting, financial reporting, branch performance, regulatory reporting, and management reporting requirements.
  • Designed and implemented Microsoft BI-based data warehouse and reporting structures for banking and finance use cases.
  • Developed reporting layers for P&L, balance sheet, branch deposit targets, and management reporting.
  • Supported regulatory reporting requirements related to Turkish Banking Regulation and Supervision Agency reporting processes.
  • Designed and implemented budget and target entry functionality for branch deposit planning and tracking.
  • Developed an Excel Add-in-based writeback solution to replace Microsoft Office PerformancePoint Server budgeting functionality.
  • Implemented budgeting, planning, forecasting, consolidation, and cost allocation capabilities.
  • Built ETL/ELT processes and analytical models to support finance, controlling, branch management, and executive reporting.
  • Worked within a highly secure banking environment with strict access, deployment, and operational constraints.
  • Contributed to the productization of the Excel writeback and budgeting solution into BudgetPort? Suite.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Office PerformancePoint Server Microsoft Excel .NET Framework BudgetPort? Suite
Data Warehousing ELT OLAP Management Reporting Budgeting Planning Forecasting Financial Reporting Regulatory Reporting P&L Reporting Balance Sheet Reporting Branch Performance Reporting Excel Writeback Cost Allocation Consolidation Data Modeling T-SQL C# Requirements Analysis Stakeholder Management Banking Reporting
Kuveyt Türk Bank
Istanbul
1 year
2014-01 - 2014-12

MSF - Field Data Entry and Synchronization Project

Software Developer, BI Consultant Data Synchronization Field Data Collection Client-Server Architecture ...
Software Developer, BI Consultant

Project Description:

Field data entry, synchronization, and reporting project for a humanitarian non-profit organization. The project focused on enabling field teams to capture operational and treatment-related data under challenging connectivity conditions and synchronize it with a central reporting environment. The solution combined Windows and web applications, a client-server architecture, and reporting capabilities to support centralized visibility and analysis.

Tasks:

  • Analysed field data entry, synchronization, and reporting requirements together with operational and central reporting stakeholders.
  • Designed and implemented a client-server architecture for distributed field data collection.
  • Developed Windows and web application components using .NET technologies.
  • Enabled field users to capture data locally and synchronize it with a central system.
  • Designed synchronization logic to support environments with limited or unstable connectivity.
  • Built reporting structures to support central monitoring and analysis of field data.
  • Supported data validation, consistency checks, and controlled data exchange between field locations and central reporting.
  • Improved data availability, reporting reliability, and operational visibility across distributed field activities.
MS SQL Server .NET Framework Windows Forms ASP.NET
Data Synchronization Field Data Collection Client-Server Architecture Offline Data Capture Distributed Application Design Data Validation Data Modeling Data Warehousing T-SQL C# Requirements Analysis Management Reporting Stakeholder Management ELT
MSF / Doctors Without Borders
Geneva, Istanbul
1 year
2013-01 - 2013-12

Apollo / GrandVision - Order Processing and Management Project

Software Developer, BI Consultant Order Management Order Tracking Store Operations ...
Software Developer, BI Consultant

Project Description:

Order processing and management project for an optics retail organization with around 300 stores. The project focused on managing the full order-to-delivery lifecycle between stores, headquarters, workshops, and supporting departments. The solution was integrated with the ERP environment and enabled stores to capture customer orders, workshops to manage production tasks, and business users to monitor delivery commitments, delays, repair processes, and operational requests.

Tasks:

  • Analysed order processing, store operations, workshop coordination, delivery tracking, and management reporting requirements.
  • Designed and developed Windows and web application components using .NET technologies.
  • Implemented order entry and tracking functionality for store users.
  • Enabled workshops to view work orders, update production status, and report production-related issues.
  • Designed logic to calculate and communicate estimated delivery dates to customers.
  • Implemented delay tracking and notification logic for order, production, repair, and delivery processes.
  • Supported the full order-to-delivery lifecycle across stores, workshops, headquarters, and management users.
  • Developed functionality for consumable material requests and store marketing material planning.
  • Integrated operational order data with ERP and reporting structures.
  • Created reporting views to improve visibility of order status, production issues, delivery performance, and store operations.
  • Helped establish a central operational bridge between stores and headquarters.
  • Supported rollout and usage across approximately 300 stores.
.NET Framework Windows Forms ASP.NET MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ERP Systems
Order Management Order Tracking Store Operations Workshop Coordination Delivery Tracking ERP Integration Operational Reporting Process Automation Data Modeling T-SQL C# Requirements Analysis Stakeholder Management Data Warehousing ELT OLAP Management Reporting
Apollo / GrandVision
Istanbul
1 year
2013-01 - 2013-12

Azerfon - Management Reporting and Datawarehouse Project

Lead BI Consultant, Project Manager Data Warehousing ELT OLAP ...
Lead BI Consultant, Project Manager

Project Description:

Data warehouse and management reporting project for a telecom operator with millions of subscribers. The project focused on enabling detailed analysis of call records, subscriber behaviour, revenue, operational KPIs, and management reporting requirements. The solution involved very large fact tables with billions of rows and dimension tables with millions of records, requiring scalable data modeling and performance-oriented BI design.

Tasks:

  • Analysed telecom reporting, subscriber analytics, revenue analysis, call detail analysis, and management reporting requirements.
  • Designed and implemented data warehouse structures for large-scale telecom data.
  • Developed ETL/ELT processes for integrating call detail records, subscriber data, revenue-related data, and operational reporting data.
  • Built analytical models to support detailed analysis of call records and subscriber behaviour.
  • Worked with very large fact and dimension tables requiring performance-oriented data modeling and query optimization.
  • Supported management reporting, telecom KPI reporting, operational reporting, and revenue-related analysis.
  • Worked in an international project environment together with external BI consultants from Pyramid Analytics.
  • Supported the implementation and usage of Pyramid Analytics as the analytical reporting tool.
  • Improved analytical visibility across high-volume telecom data and enabled scalable reporting for business stakeholders.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Pyramid Analytics
Data Warehousing ELT OLAP Management Reporting Telecom Reporting Call Detail Record Analysis Subscriber Analytics Revenue Analysis Large-Scale Fact Tables Performance Optimization Data Modeling T-SQL Requirements Analysis Stakeholder Management
Azerfon
Baku, Aserbaidschan
1 year
2013-01 - 2013-12

Metro AG - Sales and Management Reporting DWH Project

Senior BI Consultant Data Warehousing ELT OLAP ...
Senior BI Consultant
Project Description
Operational and management reporting project for the sales department of a large retail organization. The project focused on customer and sales analytics, store performance reporting, POS transaction analysis, campaign performance analysis, and retail KPI reporting.

Tasks

  • Analysed reporting requirements together with business stakeholders from the Sales & Marketing department.
  • Designed and implemented data warehouse structures for customer, sales, store, campaign, and POS transaction analysis.
  • Developed ETL/ELT processes to integrate POS and Teradata-based source data into the reporting environment.
  • Built analytical data models to support sales, customer, store, and campaign performance reporting.
  • Implemented operational and management reports for store sales, receipt-level transaction details, customer behaviour, and retail KPIs.
  • Supported weekly and monthly campaign/prospect performance analysis.
  • Improved reporting automation and reduced dependency on manual analysis and Excel-based reporting.


MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Teradata POS Systems
Data Warehousing ELT OLAP Management Reporting Operational Reporting Retail Analytics Sales Analytics Customer Analytics Store Performance Analysis Campaign Performance Analysis POS Data Analysis Data Modeling T-SQL Requirements Analysis Stakeholder Management
Metro AG
Istanbul
1 year
2012-01 - 2012-12

Mercedes-Benz - Financial Reporting, Budgeting and OLAP Writeback Solution

Senior BI Consultant / Software Developer Data Warehousing ELT OLAP ...
Senior BI Consultant / Software Developer

Project Description:

Financial reporting, budgeting, and forecasting solution for the Controlling department of Mercedes-Benz Financial Services. The project focused on replacing an existing IBM TM1-based budgeting process with a Microsoft BI-based solution, enabling finance users to enter budget and forecast values directly through Microsoft Excel while writing back to the most granular level of the analytical model.

Tasks

  • Designed and implemented a Microsoft BI-based budgeting and forecasting solution for the Controlling department.
  • Developed an Excel Add-in (Product Name: Spectra) and COM automation solution for OLAP writeback scenarios.
  • Enabled business users to enter budget and forecast data directly through Microsoft Excel.
  • Implemented writeback logic from aggregated Excel views to granular-level analytical data structures.
  • Supported the replacement of IBM TM1-based budgeting processes with a custom self developed solution.
  • Built reporting and analytical structures for financial planning, controlling, and management reporting.
  • Developed application components using .NET and C#.
  • Supported automation of the financial planning process and reduced dependency on manual budgeting workflows.
  • Contributed to a solution that reduced IBM TM1 license dependency and later evolved into a commercial product.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Excel IBM TM1 .NET Framework
Data Warehousing ELT OLAP OLAP Writeback Budgeting Forecasting Financial Planning Controlling Management Reporting Data Modeling T-SQL C# .NET Development Requirements Analysis Stakeholder Management
Mercedes-Benz Financial Services
Istanbul
1 year
2012-01 - 2012-12

Peugeot - Dealer Performance Management and Operational Portal

Senior BI Consultant, Software Developer Data Warehousing ELT OLAP ...
Senior BI Consultant, Software Developer

Project Description:

Dealer performance management and operational reporting project for Peugeot Turkey. The project focused on measuring dealer performance across sales, test drives, vehicle requests, operational processes, and dealer network activities. As part of the BI initiative, an ASP.NET-based dealer portal was designed and implemented to capture operational data that was previously managed in Excel files or not available in a structured way.

Tasks:

  • Analysed dealer performance management requirements together with sales, dealer network, and management stakeholders.
  • Designed and implemented BI structures for dealer performance, sales performance, operational KPIs, and management reporting.
  • Developed data warehouse and reporting layers based on Microsoft BI technologies.
  • Designed an ASP.NET-based dealer portal for Peugeot dealers across Turkey.
  • Enabled dealers to log in and manage operational processes such as test drives, vehicle requests, and dealer-related activities.
  • Replaced fragmented Excel-based data collection with a structured portal and database-driven process.
  • Integrated portal data into the BI environment to enable new analyses and improve reporting quality.
  • Built reports and analytical views for dealer KPIs, target achievement, operational performance, and management visibility.
  • Improved central visibility of dealer operations and reduced manual reporting effort.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services ASP.NET .NET Framework Microsoft Excel
Data Warehousing ELT OLAP Management Reporting Operational Reporting Dealer Performance Management Retail Analytics KPI Reporting Portal Design Data Collection Data Modeling T-SQL C# Requirements Analysis Stakeholder Management
Peugeot
1 year
2012-01 - 2012-12

Pfizer - Field Performance and Bonus Management Reporting Project - Part II

Senior BI Consultant Data Warehousing ELT OLAP ...
Senior BI Consultant

Project Description

Business-critical field performance and bonus management reporting system for Pfizer Turkey. The project focused on calculating sales representatives? performance bonuses based on complex business rules, sales targets, visit performance, field activities, and territory-related performance indicators. The solution also enabled each field representative to monitor their own sales and visit performance and estimate expected bonus outcomes.

Tasks

  • Analysed complex bonus calculation rules, field performance KPIs, sales targets, and visit performance requirements.
  • Designed and implemented data warehouse structures for field force performance and bonus management reporting.
  • Developed ETL/ELT processes to integrate sales, visit, employee, territory, and performance-related data.
  • Implemented complex calculation logic for performance bonus estimation and management reporting.
  • Built analytical models and reports for sales representatives, field managers, HR, finance, and management users.
  • Enabled individual field representatives to monitor their own performance and estimated bonus results.
  • Integrated relevant outputs with Oracle PeopleSoft for downstream HR/payroll-related processes.
  • Supported validation and quality control of sensitive bonus calculation results.
  • Improved transparency, accuracy, and automation in a highly sensitive and business-critical incentive process.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Oracle PeopleSoft
Data Warehousing ELT OLAP Management Reporting Field Force Reporting Bonus Calculation Incentive Management Sales Performance Analysis Territory Performance Analysis KPI Reporting Data Modeling T-SQL Requirements Analysis Stakeholder Management Business-Critical Reporting
Pfizer
Istanbul
1 year
2011-01 - 2011-12

Philip Morris - Financial Forecasting and Reporting Project

Senior BI Consultant, Software Developer Financial Forecasting Treasury Reporting P&L Modeling ...
Senior BI Consultant, Software Developer

Project Description:

Financial forecasting and reporting project for the Treasury department of Philip Morris. The project had two main phases: first, moving an advanced Excel-based financial forecasting model into a data warehouse and reporting environment; second, developing an Excel Add-in that allowed controlled simulation parameter changes and direct writeback into the database. The model covered an integrated P&L, balance sheet, and cash flow forecast and supported scenario simulations based on financial, operational, and macroeconomic parameters.

Tasks:

  • Analysed the existing Excel-based financial forecasting model used by the Treasury department.
  • Translated complex financial forecast logic into a database-driven calculation and reporting model.
  • Designed data warehouse structures for integrated P&L, balance sheet, and cash flow forecasting.
  • Implemented scenario simulation capabilities based on parameters such as inflation, interest rates, sales volumes, labour efficiency, machine efficiency, depreciation, tax assumptions, and dividend payments.
  • Developed reporting structures to analyse the impact of business activities on P&L, balance sheet, cash flow, tax burden, and shareholder-related financial outcomes.
  • Implemented complex financial calculations such as WACC, CAPM, Shareholder Value, and Operating Free Cash Flow.
  • Developed an Excel Add-in to manage simulation parameters and write controlled changes directly into the database.
  • Enabled business users to run forecast simulations and compare financial outcomes based on different parameter sets.
  • Improved governance, consistency, and maintainability of a previously Excel-based forecasting process.
  • Supported Treasury, finance, controlling, and management users with financial forecasting and scenario analysis capabilities.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Excel .NET Framework
Financial Forecasting Treasury Reporting P&L Modeling Balance Sheet Modeling Cash Flow Modeling Scenario Simulation What-If Analysis Excel Writeback Financial Modeling WACC CAPM Shareholder Value Operating Free Cash Flow Tax Impact Analysis Data Modeling T-SQL C# Requirements Analysis Stakeholder Management Data Warehousing ELT OLAP Management Reporting
Philip Morris
Istanbul
1 year
2010-01 - 2010-12

Pfizer - Oracle PeopleSoft and Local Payroll Integration

Senior BI Consultant, ETL Developer ETL ELT Data Integration ...
Senior BI Consultant, ETL Developer

Project Description:

Business-critical ETL and data integration project for Pfizer Turkey. The project focused on establishing a bi-directional data exchange between the local payroll system and the global Oracle PeopleSoft HRMS environment. The integration handled sensitive employee and payroll-related data for all Pfizer Turkey employees and required a high level of confidentiality, accuracy, validation, and operational reliability.

Tasks:

  • Analysed HR, payroll, and global HRMS integration requirements together with business and technical stakeholders.
  • Designed and implemented bi-directional ETL processes between the local payroll system and Oracle PeopleSoft.
  • Developed data extraction, transformation, validation, and loading processes for sensitive employee and payroll data.
  • Implemented data quality controls, consistency checks, and error handling mechanisms.
  • Supported secure and controlled processing of confidential HR and payroll-related data.
  • Designed integration logic to ensure accurate data exchange between local and global HR systems.
  • Worked on a business-critical integration process where data accuracy and reliability were essential.
  • Supported testing, reconciliation, and validation of integration results.
  • Completed the integration without data errors in a highly sensitive payroll and HR environment.
MS SQL Server MS SQL Server Integration Services Oracle PeopleSoft Local Payroll System
ETL ELT Data Integration HR Data Integration Payroll Integration Bi-Directional Data Exchange Data Validation Data Quality Management Error Handling Data Reconciliation Sensitive Data Handling Business-Critical Integration T-SQL Requirements Analysis Stakeholder Management
Pfizer
Istanbul
1 year
2010-01 - 2010-12

Pfizer - IMS Sales and Field Force Performance Reporting Project

Senior BI Consultant MDX Data Warehousing ELT ...
Senior BI Consultant

Project Description:

Sales and field force performance reporting project for Pfizer Turkey. The project served as the first phase of a broader field performance and bonus management initiative. This phase focused on reverse engineering, extracting and converting IMS sales data from OLAP-based structures into a relational analytical model, cleaning and preparing the data for reporting, and making the reports available to field force users both online and offline.

Tasks:

  • Analysed IMS sales data, field force performance, territory, brick, and management reporting requirements.
  • Reverse engineered IMS data structures and converted OLAP-oriented source data into relational analytical formats.
  • Designed and implemented ETL processes to extract, transform, clean, and prepare IMS sales data for analysis.
  • Built data warehouse and analytical structures for sales, field force, territory, and brick-level performance reporting.
  • Developed reports and analytical views for sales, field force, marketing, finance, and management users.
  • Enabled field force users to access performance reports online.
  • Created local cube structures to support offline reporting and analysis for field force users.
  • Improved data usability, reporting consistency, and analytical accessibility of IMS sales data.
  • Established the analytical foundation for later field performance and bonus management reporting.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services IMS
MDX Data Warehousing ELT OLAP Management Reporting Sales Reporting Field Force Reporting IMS Data Processing OLAP to Relational Conversion Reverse Engineering Territory Analysis Brick Sales Analysis Offline Reporting Local Cubes Data Cleansing Data Modeling T-SQL Requirements Analysis
Pfizer
Istanbul
2 years
2009-01 - 2010-12

Pfizer - P&L Reporting and OPEX Allocation Project

BI Consultant Financial Reporting P&L Reporting OPEX Allocation ...
BI Consultant

Project Description:

P&L reporting and OLAP business intelligence project for Pfizer Turkey. The project focused on building a data warehouse and OLAP reporting solution for TRG and HTG P&L analysis based on SUN ERP ledger data, Excel-based master data, budgeting inputs, adjustments, HFM distribution data, and allocation ratios. The solution supported Actual and Budget scenarios, multiple reporting versions, product and account dimensions, and business-rule-based OPEX allocation over departments, business units, and master products.

Tasks:

  • Analysed P&L reporting, allocation, budgeting, and finance reporting requirements.
  • Designed and implemented data warehouse structures for P&L reporting and OLAP analysis.
  • Integrated SUN ERP ledger data as the primary source for financial fact figures.
  • Integrated Excel-based inputs for allocation ratios, filters, mappings, dimensions, budget figures, manual adjustments, and HFM distribution records.
  • Built ETL processes to extract, transform, validate, and prepare finance data for OLAP processing.
  • Designed dimensions for product, account, division, market, legal entity, scenario, version, currency, and date.
  • Implemented P&L structures covering gross sales, returns, allowances, net sales, cost of goods sold, marketing expenses, distribution expenses, R&D, G&A, other income, deductions, OPEX, and IBA.
  • Implemented allocation logic for common figures across departments, business units, and master products.
  • Supported different allocation methods for field selling, other marketing expenses, distribution, R&D, G&A, other income, and other deductions.
  • Implemented validation rules for account mappings, product mappings, department allocation rules, marketing group mappings, and HFM-related structures.
  • Built SSAS OLAP structures to support multidimensional P&L analysis and management reporting.
  • Improved transparency, consistency, and maintainability of finance reporting and allocation calculations.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services Microsoft Excel SUN ERP HFM
Financial Reporting P&L Reporting OPEX Allocation Budgeting Scenario Analysis Data Validation Allocation Logic Finance Data Modeling Data Modeling T-SQL MDX Requirements Analysis Data Warehousing ELT OLAP Management Reporting
Pfizer
Istanbul
1 year
2009-01 - 2009-12

Pfizer - Product Master Data Management Project

BI Consultant Product Master Data Data Integration Data Validation ...
BI Consultant

Project Description:

Product master data management and SSIS integration project for Pfizer Turkey. The project focused on centralizing and synchronizing product-related master data from multiple source systems into a controlled Product MDM database. The scope included product attributes, MPG definitions, samples, forms, distributors, companies, ATC classifications, molecules, origin and business information, including validation, history tracking, error handling, and post-processing controls.

Tasks:

  • Analysed product master data integration requirements across multiple source systems.
  • Designed and implemented SSIS packages for Product MDM data integration.
  • Integrated product-related master data from various ERP and MRP source systems.
  • Built data flows for MPG, sample, form, distributor, company, ATC3, ATC4, molecule, origin, and business definitions.
  • Implemented temporary staging tables, validation logic, and controlled transfer processes into the Product MDM database.
  • Designed logic to detect new, updated, deleted, invalid, duplicate, and inconsistent records.
  • Implemented error logging, information logging, execution tracking, and notification mechanisms.
  • Developed post-check logic to ensure consistency between MPG, sample, and form status information.
  • Supported product hierarchy, product attribute, price, launch date, GTIN, and source-system-code synchronization.
  • Improved master data quality, consistency, traceability, and reliability for downstream reporting and analytics processes.
MS SQL Server MS SQL Server Integration Services
Product Master Data Data Integration Data Validation Data Quality Management Data Warehousing ELT Master Data Management History Tracking Source System Integration Data Modeling T-SQL Requirements Analysis
Pfizer
Istanbul
1 year
2008-01 - 2008-12

Pfizer - BI Infrastructure Modernization and Digital Transformation Project

BI Consultant BI Modernization Data Warehousing ELT ...
BI Consultant

Project Description:

BI infrastructure modernization project for Pfizer Turkey. The project focused on the full modernization of an existing Microsoft BI landscape based on SQL Server 2000, DTS packages, and OLAP 2000 cubes. The legacy environment was migrated to SQL Server 2008, SSIS, and SSAS to improve maintainability, performance, operational reliability, and long-term supportability of the reporting infrastructure.

Tasks:

  • Analysed the existing SQL Server 2000, DTS, and OLAP 2000-based BI landscape.
  • Supported the modernization of approximately 20 data marts from SQL Server 2000 to SQL Server 2008.
  • Rewrote more than 300 DTS packages as SSIS packages.
  • Converted 15 OLAP 2000 cubes into SSAS cubes.
  • Performed data validation and reconciliation between legacy and modernized environments.
  • Supported migration testing, issue analysis, and operational readiness activities.
  • Improved maintainability and stability of ETL and OLAP processing workflows.
  • Supported the transition from legacy BI components to a more modern Microsoft BI architecture.
  • Helped make the modernized BI environment operational for business-critical reporting and analytics processes.
MS SQL Server 2000 MS SQL Server 2008 MS SQL Server Data Transformation Services MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services
BI Modernization Data Warehousing ELT ETL Migration OLAP Migration Data Mart Migration Legacy System Modernization Data Validation Data Reconciliation OLAP Management Reporting Data Modeling T-SQL Requirements Analysis
Pfizer
Istanbul
1 year
2008-01 - 2008-12

Darty/fnac - Retail Reporting and Analysis Project

BI Consultant Retail Analytics Sales Reporting Stock Turnover Analysis ...
BI Consultant

Project Description:

Retail reporting and analysis project for an electronics retailer. The project focused on building analytical and management reporting capabilities for retail performance, including sales velocity, stock turnover, product profitability, store profitability, sales bonus reporting, and revenue-based incentive reporting. The solution used Microsoft BI technologies and integrated retail data from Microsoft Dynamics AX / Axapta.

Tasks:

  • Analysed retail reporting, sales performance, stock analysis, profitability, and incentive reporting requirements.
  • Designed and implemented reporting structures for retail analytics and management reporting.
  • Developed ETL/ELT processes to prepare sales, stock, product, store, and finance-related data for analysis.
  • Built analytical models and reports for stock turnover, sales velocity, product profitability, and store profitability.
  • Developed reports for sales bonus and revenue-based incentive calculations.
  • Integrated Microsoft Dynamics AX / Axapta data into the reporting environment.
  • Supported finance, sales, store operations, category management, and management users with analytical reporting.
  • Improved visibility into retail performance, product performance, store profitability, and sales incentive processes.
MS SQL Server MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Dynamics AX / Axapta
Retail Analytics Sales Reporting Stock Turnover Analysis Sales Velocity Analysis Product Profitability Analysis Store Profitability Analysis Incentive Reporting Data Modeling T-SQL Data Warehousing ELT OLAP Management Reporting
Darty/fnac
Istanbul
1 year
2007-01 - 2007-12

L?Occitane - MS Dynamics NAV ERP Implementation & SQL 2005 CPM Reporting Project

ERP Consultant, BI Consultant ERP Implementation ERP Process Design Data Warehousing ...
ERP Consultant, BI Consultant

Project Description:

ERP implementation and retail reporting project for a cosmetics retail organization. The project started with Microsoft Dynamics NAV process design, technical implementation, and system customization, followed by financial and retail analytics reporting after go-live. The strong understanding of the ERP data model enabled effective reporting design and highlighted the importance of master data quality, process guardrails, and governance directly at the operational system level.

Tasks:

  • Analysed ERP, finance, retail operations, and reporting requirements together with business stakeholders.
  • Designed business processes and ERP structures in Microsoft Dynamics NAV.
  • Implemented technical customizations and adaptations in the ERP environment.
  • Supported ERP go-live activities and operational transition.
  • Designed and implemented financial and retail analytics reporting after ERP go-live.
  • Developed reporting structures based on a detailed understanding of the ERP data model.
  • Identified master data quality issues originating from ERP processes and operational data entry.
  • Supported the definition of process guardrails to improve data quality and reporting reliability.
  • Built analytical views for finance, sales, store operations, and management reporting.
  • Gained hands-on experience in how ERP process design, master data governance, and BI reporting are connected.
MS Dynamics NAV MS SQL Server 2005 MS SQL Server Integration Services MS SQL Server Analysis Services MS SQL Server Reporting Services Microsoft Excel
ERP Implementation ERP Process Design Data Warehousing ELT OLAP Management Reporting Financial Reporting Retail Analytics Master Data Management Data Governance Data Quality Management Process Design Data Modeling T-SQL Requirements Analysis Dynamics NAV C/Side
L?Occitane
Istanbul
1 year
2006-01 - 2006-12

Roche - Management Reporting Project

BI Consultant Data Warehousing ETL OLAP ...
BI Consultant

Project Description:

Management reporting project for a pharmaceutical organization, mainly focused on finance-oriented reporting with additional sales and operational reporting requirements. This was an early BI consulting project involving ETL development, SQL query writing, OLAP cube design, MDX measure development, report design, and authorization setup based on a Microsoft SQL Server 2000 and OLAP 2000 backend with MIS onVision as the reporting frontend.

Tasks:

  • Supported the implementation of management reporting requirements for finance, sales, and operational reporting.
  • Developed ETL processes using SQL Server DTS to prepare data for reporting and analysis.
  • Wrote SQL queries and transformation logic for analytical reporting needs.
  • Designed and maintained OLAP cube structures using MS OLAP Services 2000.
  • Developed MDX measures and analytical calculations for management reports.
  • Designed reports using MIS onVision as the reporting frontend.
  • Supported authorization and access setup for reporting users.
  • Worked as part of a BI project team and gained hands-on consulting experience in ETL, OLAP, reporting, and pharmaceutical management reporting.
MS SQL Server 2000 MS SQL Server Data Transformation Services MS OLAP Services 2000 MIS onVision Data Transformation Services MIS
Data Warehousing ETL OLAP Management Reporting Financial Reporting Sales Reporting Operational Reporting Cube Design MDX Report Design Authorization Management Data Modeling T-SQL
Roche
Istanbul
1 month
2006-01 - 2006-01

Collezione - Budgeting and Management Reporting Project

BI Consultant Budgeting Planning Corporate Performance Management ...
BI Consultant

Project Description:

Budgeting, planning, and management reporting project for a textile retail organization. The project focused on implementing a corporate budgeting and planning process and extending it with actual reporting capabilities. The solution supported financial and management reporting by combining budget data, planning structures, and actual performance analysis.

Tasks:

  • Supported the implementation of budgeting and planning processes.
  • Analysed budgeting, planning, actual reporting, and management reporting requirements.
  • Worked on the implementation of budgeting models using CPM and OLAP-based MIS ALEA planning tools.
  • Supported the preparation and loading of planning and actual data into the analytical environment using Cubeware Import Master / Importer.
  • Developed management reports and analytical views using MIS onVision.
  • Helped business users compare budget, plan, and actual performance.
  • Supported finance, controlling, sales, and management users with reporting and analysis capabilities.
  • Gained practical experience in corporate budgeting, planning, and management reporting implementation.
MIS MIS Alea MIS OnVision Cubeware Cubeware Import Master Cubeware Importer Microsoft Excel
Budgeting Planning Corporate Performance Management OLAP Management Reporting Actual Reporting Financial Reporting Retail Reporting Data Import Data Modeling ETL
Collezione
Istanbul
1 year
2005-01 - 2005-12

Nexum - Excel-Based Controlling Reporting Automation

Junior Financial Controller Financial Controlling Excel Reporting Automation IAS Reporting Support ...
Junior Financial Controller

Project Description:

Internal finance and controlling reporting automation project. The project focused on transforming recurring Excel-based reporting models into a more automated and structured reporting process for sales, workforce performance, accounting, and controlling reports. The reports were prepared for the CFO and account managers and also supported IAS-based financial reporting activities for Nexum Group Worldwide.

Tasks:

  • Prepared periodic sales, workforce performance, accounting, and controlling reports for the CFO and account managers.
  • Analysed recurring manual Excel reporting processes and identified automation potential.
  • Improved and automated Excel-based reporting models for recurring management and controlling reports.
  • Consolidated financial and operational data into structured reporting templates.
  • Supported sales performance, workforce performance, cost controlling, and accounting reporting processes.
  • Supported the CFO in IAS-based group financial reporting activities.
  • Improved reporting consistency, repeatability, and preparation efficiency.
  • Reduced manual effort and increased reliability of recurring finance and controlling reports.
  • Gained early hands-on experience in finance, controlling, management reporting, and business-oriented data analysis.
Microsoft Excel VBA Microsoft Office
Financial Controlling Excel Reporting Automation IAS Reporting Support Sales Reporting Workforce Performance Reporting Management Reporting Data Consolidation Accounting Reporting Data Validation KPI Reporting Process Automation Business Analysis
Nexum
Istanbul

Aus- und Weiterbildung

Aus- und Weiterbildung

1 year
2025-11 - 2026-10

Fabric Analytics Engineer Associate

DP-600 Certificate, Microsoft
DP-600 Certificate
Microsoft
1 year
2025-11 - 2026-10

Fabric Data Engineer Associate

DP-700 Certificate, Microsoft
DP-700 Certificate
Microsoft
2 years
2008-08 - 2010-07

Technology and Industrial Economics

MA, University of Istanbul
MA
University of Istanbul
4 years
2002-08 - 2006-07

Economics (Major) with Econometrics (Minor)

BA, University of Istanbul
BA
University of Istanbul
8 years
1994-09 - 2002-08

High School

Kadiköy Anatolian High School, Istanbul
Kadiköy Anatolian High School, Istanbul

Position

Position

I currently work as an independent BI and Data Solutions Architect and Senior Consultant with 20 years of hands-on project experience across business intelligence, data platforms, analytics architecture, and enterprise reporting.

Over the course of my career, I have delivered around 40 projects for approximately 30 enterprise customers across industries such as media, finance, retail, pharmaceuticals, automotive, telecommunications, and consumer goods.

My strengths are in modernizing BI and data warehouse landscapes, designing scalable Microsoft-based data platforms, building governed semantic models, and translating business requirements into practical, maintainable data solutions. I combine hands-on technical implementation with architecture, stakeholder management, and end-to-end project delivery experience.

I am particularly interested in projects related to Microsoft Fabric, Azure Synapse, Power BI, data warehousing, Lakehouse and Warehouse architectures, semantic modeling, data product architecture, finance and operational reporting, master data management, and AI-ready analytics platforms. I am especially interested in helping organizations build trusted semantic layers, governed data products, and reliable data foundations that make enterprise data usable not only for human reporting, but also for AI-assisted and agentic analytics scenarios.

Kompetenzen

Kompetenzen

Top-Skills

Microsoft Fabric Data Platform Architecture Semantic Modeling Data Platform Modernization Analytics Governance Data Product Architecture Power BI Data Engineering Datawarehouse Data Lake Berechtigungen AI-Ready Analytics Data Products Trusted Analytics SQL

Schwerpunkte

Business Intelligence
Data Warehousing
Data Lakehouse
Data Platform Architecture
Microsoft Fabric
Azure Synapse Analytics
Power BI
Semantic Modeling
Data Modeling
Enterprise Reporting
Management Reporting
Data Product Architecture
Data Governance
Master Data Management
BI Modernization
AI-Ready Analytics

Aufgabenbereiche

Requirements Analysis
Data Warehouse Design
Data Lakehouse Design
ETL Pipeline Design
ELT Process Design
Analytical Reporting Layer Design
Semantic Model Design
Performance Reporting
Management Reporting
Planning
Budgeting
Forecasting
Finance Reporting
Sales Reporting
HR Reporting
Executive Reporting
Stakeholder Management
Project Management
Data Product Design
Data Platform Modernization
Solution Architecture
BI Architecture
Technical Leadership
Governance
Business Process Optimization
AI-Ready Analytics

Produkte / Standards / Erfahrungen / Methoden

Agile Delivery
Scrum
DevOps
CI/CD
Requirements Engineering
Data Governance
Dimensional Modeling
Data Vault
Medallion Architecture
Data Product Design
Master Data Management
Self-Service BI
AI-Ready Analytics
Microsoft Fabric
Power BI
Azure Synapse Analytics
Azure Analysis Services
SQL Server
SSIS
SSAS
SSRS
Tabular Editor
Azure DevOps
Azure Data Lake Storage Gen2
Microsoft Excel
Microsoft Dynamics
Microsoft Dynamics AX
Microsoft Dynamics NAV
Azure
Elastic Search
RabbitMQ
Entity Framework
Redis
ASP.NET
Winforms
ASP.NET Core
WCF
WebAPI
GraphQL
Bootstrap

Developed and Owned Commercial Products:

Spectra?

Developed an Add-in and a COM Automation for Mercedes Benz which simply enables end users to write back over aggregated data at the most granular level by using daily life Microsoft Excel to replace existing IBM TM1 for Budgeting and Forecasting operations. First started as a project (which was also internally awarded by the firm for reducing existing IBM TM1 Software License cost to zero) and became a registered commercial product which was finally merged into the BudgetPort? Suite.


BudgetPort? Suite

Developed to be an alternative for Microsoft Office PerformancePoint Server after it was discontinued. This is fully functional Corporate Budgeting and Planning software with Forecasting, Cost Allocation, Consolidation and Reporting capabilities which was used by multi branch/store companies like Banks, Retailers and Fast-Food Companies.


Piv-Hoc

Developed as a side project to address a need of lightweight, simple, plug and play reporting tool for corporate end-users where they can download, install and use within 5 minutes to analyze mainly OLAP Cubes and Databases. This tool is finally merged into the BudgetPort? Suite and created the awareness that is required to develop our next wave reporting product: Dashsense?.  


Dashsense?

After success and the acceptance of Piv-Hoc by our customers and the idea of being able to access corporate data hassle-free and easily, we?ve developed our fully functional Business Intelligence Reporting Tool and Portal with our prior knowledge and practical experience that we?ve gathered from our Business Intelligence consultancy background. Dashsense can connect all major data sources like SQL Server, Oracle, MySql, PostgreSQL, SAP Hana, Amazon Redshift etc. Dashsense has more than 10 corporate customers (like Pernod Richard, Bayer, Peugeot etc.) and around 2000 active corporate users.


Portaxis

Developed as a side project but turned into a licensed product to facilitate data entry and integration without requiring ETL just by using an ordinary Microsoft Office Excel. Portaxis enables end users to edit and enter any relational data to support scenarios like master data editing, updating parameters, budget entries, mass/bulk transactional data import, legacy data integration or merging user data in satellite excels into a database without omitting the business rules. This also helps reducing amount of creating small ETL packages for IT/BI departments. Portaxis also acts as a single-version-of-truth master data source for end-users who are willing to export and use structured data in their ad-hoc analyses.


Rethubs Suite?

Rethubs is a SaaS based B2C Customer Data Platform (CDP) and Loyalty Management software which is in latest phase before release and is being developed with latest .Net Core Stack (along with ElasticSearch, RabbitMQ, Redis, Azure Functions) and Microservice Architecture that is hosted in Microsoft Azure. Core software architecture and infrastructure solely designed by me and being implemented by the special task force team that I was leading. Rethubs currently has following functionalities: automatic customer data cleansing, merging and deduping; customer 360 views, customer segmentation; automatic customer clustering (with statistical algorithms like K-Means), campaign management and loyalty management. Rethubs is my masterpiece of my software career so far which combines near-big-data, ETL process and data integration, business knowledge, reporting, hard-core statistics and software development techniques altogether.

Programmiersprachen

T-SQL
MDX
DAX
VBA
VB
VB.NET
C#
Python
JavaScript
HTML
CS

Datenbanken

MS SQL Server
Azure SQL Database
Azure Synapse Analytics
Microsoft Fabric Warehouse
Microsoft Fabric Lakehouse
Azure Data Lake Storage Gen2
SQL Server Analysis Services
Azure Analysis Services
Oracle
PostgreSQL
MySQL
Delta/Parquet

Datenkommunikation

ETL
ELT
Data Synchronization
BI-Directional Data Exchange
API Integration
ERP Integration
CRM Integration
HRMS Integration

Berechnung / Simulation / Versuch / Validierung

Financial Forecasting
Budgeting
Planning
Scenario Simulation
What-If Analysis
OPEX Allocation
Cost Allocation
Bonus and Incentive Calculation
Forecast Simulation
Data Validation
Data Reconciliation
KPI Calculation
Business Rule Validation
Test-Driven Data Platforms

Design / Entwicklung / Konstruktion

BI and Data Solutions and Platform Design
Data Warehouse Design
Lakehouse Design
Semantic Model Design
ETL - ELT Design
Database Design
Dimensional Modeling
Tabular Modeling
Power BI Report Design
Portal Design
.NET Development
ASP.NET Development
Excel Add-in Development

Buchhaltung

Financial Accounting
General Ledger
Chart of Accounts
Journal Entries
Month-End Closing
Year-End Closing
Statutory Reporting
IAS Reporting
IFRS Reporting

Controlling

Financial Controlling
Management Reporting
Budgeting
Planning
Forecasting
Budget vs Actual Analysis
Cost Center Reporting
Profitability Analysis
P&L Analysis
Balance Sheet Analysis
Cash Flow Analysis
Cost Allocation
OPEX Allocation
KPI Reporting
Performance Reporting
Sales Controlling
Operational Controlling
Executive Reporting
Scenario Analysis
What-If Analysis

Cash Management / Treasury

Treasury Reporting
Cash Flow Forecasting
Financial Forecasting
Working Capital Analysis
WACC
CAPM
Operating Free Cash Flow
Shareholder Value
Scenario Simulation
P&L Simulation
BS Simulation
Tax Impact Analysis

Finance & HR

Financial Reporting
Finance Data Modeling
FP&A
Budgeting
Planning
Forecasting
P&L Reporting
Balance Sheet Reporting
Cash Flow Reporting
Budget vs Actual Analysis
Cost Center Reporting
Profitability Analysis
Cost Allocation
OPEX Allocation
Bonus Calculation
Incentive Management
HR Reporting
Payroll Integration

Riskmanagement

Data Quality Management
Reporting Reliability
Process Control
Governance
Auditability
Access Control
Operational Risk Reduction
Business-Critical Reporting
Data Reconciliation
Validation Controls

Compliance & Sicherheit Finanzwesen

Row-Level Security
Object-Level Security
Authorization Management
Access Governance
Role-Based Access Control
Entra Group-Based Access Control
Audit Logging
Approval Workflows
Data Privacy
Sensitive Data Handling
Governance Workflows

Managementerfahrung in Unternehmen

Team Leadership
Technical Leadership
Product Owner
Project Leadership
Delivery Management
Roadmap Definition
Resource Planning
Engineering Team Management
Stakeholder Management
R&D Management
Product Strategy

Personalverantwortung

Team Leadership
Team Building & Hiring
Engineering Team Leadership
Coaching
Resource Planning
Task Coordination
Delivery Coordination
Capability Development
Mentoring

Branchen

Branchen

I have strong industry expertise across business intelligence, data platforms, analytics, reporting, and data-driven business transformation initiatives in a wide range of enterprise environments.

One of my key strengths is my extensive business and domain knowledge. Because I have worked closely with business stakeholders throughout my career and started my professional journey in finance as a Financial Controller, I am able to understand business requirements and flaws in the process quickly and translate them into effective analytical and technical solutions. Business users often find it easy to communicate their needs to me, as I can speak both the language of business and the language of technology, helping bridge the gap between operational requirements and data-driven solutions.

My experience spans pharmaceuticals, retail, media, finance, automotive, banking, telecommunications, and customer experience / BPO sectors. Throughout my career, I have delivered solutions supporting financial management, sales performance analysis, operational reporting, customer analytics, master data governance, supply chain optimization, workforce performance management, and executive decision-making processes.

In pharmaceutical and life sciences organizations, I supported commercial effectiveness, sales performance monitoring, territory and market analysis, incentive management, financial performance tracking, operational planning, and data integration initiatives that enabled reliable and timely business insights.

In retail and consumer goods environments, I worked on customer experience improvement, loyalty and retention programs, campaign effectiveness analysis, customer segmentation, inventory optimization, replenishment planning, store performance management, order lifecycle visibility, and data-driven operational decision-making.

In finance, banking, and automotive finance organizations, I contributed to budgeting, forecasting, profitability analysis, financial performance management, cash flow monitoring, treasury processes, branch and channel performance analysis, regulatory reporting, risk and compliance reporting, and enterprise planning initiatives. Having started my career as a Financial Controller, finance remains one of my strongest domains. I have a deep understanding of management reporting, budgeting, forecasting, P&L analysis, balance sheet structures, cash flow management, cost allocation, profitability analysis, and financial planning processes, allowing me to work effectively with finance teams and senior management.

Across all industries, my focus has been on transforming business data into actionable insights, improving reporting and analytical capabilities, streamlining business processes, strengthening data quality and governance, and enabling more effective strategic and operational decision-making.

I combine this industry knowledge with deep technical expertise in Microsoft BI, Microsoft Fabric, Azure Synapse, Power BI, SQL Server, data warehousing, semantic modeling, and enterprise analytics platforms.

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.