BI & Data Platform Architect | Microsoft Azure, Fabric & Power BI | Trusted Analytics, Semantic Models, Data Products, AI-Ready Analytics
Aktualisiert am 15.04.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
Business Fluent
German
C1

Einsatzorte

Einsatzorte

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

Projekte

Projekte

1 month
2026-04 - now

Advise clients on data platform strategy

BI and Data Solutions Architect and Senior Consultant
BI and Data Solutions Architect and Senior Consultant

Provide independent consulting services in business intelligence, data platform architecture, and analytics transformation, helping organizations design scalable, modern data solutions aligned with business goals.

  • Advise clients on data platform strategy, architecture, and modernization initiatives across Microsoft data technologies, including Azure, Microsoft Fabric, Power BI, and SQL Server.
  • Design end-to-end analytics and data engineering solutions covering data ingestion, transformation, modeling, semantic layer design, and reporting enablement.
  • Support organizations in building scalable Lakehouse, Warehouse, and Semantic Model architectures with a focus on performance, maintainability, governance, and reusability.
  • Deliver hands-on expertise in dimensional modeling, tabular modeling, Power BI optimization, and enterprise BI best practices for reporting and self-service analytics.
  • Lead client engagements from discovery and solution design to implementation guidance, stakeholder alignment, and technical delivery oversight.
  • Help teams improve development standards, deployment processes, and platform reliability by introducing structured engineering practices, automation, and architectural governance.
  • Act as a trusted advisor to business and technical stakeholders, translating analytical and operational requirements into practical, sustainable data solutions.
Independent
4 years 2 months
2022-02 - 2026-03

Modernized an existing Data Vault-based SQL Server/SSIS/SSAS

Lead Global BI and Data Solutions Architect
Lead Global BI and Data Solutions Architect

Led the modernization and global scaling of dentsu?s data and analytics platform, evolving from an on-prem SQL Server stack to a modern Azure-based architecture and, more recently, Microsoft Fabric.

  • Modernized an existing Data Vault-based SQL Server/SSIS/SSAS environment by migrating the tabular model to Azure Analysis Services and optimizing ETL and data warehouse structures to improve stability and performance.
  • Built a global Azure Synapse-based data platform using Dedicated and Serverless SQL capabilities, integrating data from over 250 operational systems across regions and time zones through ADLS Gen2 storage. Delivered continuously orchestrated workloads, ensuring data availability, daily, across regions.
  • Standardized dimensional modeling practices using Tabular Editor and applied best practices, enabling maintainable, performant, and reusable analytics solutions. Implemented aggregations, calculation groups, and custom incremental refresh automation to optimize semantic model refresh speed and efficiency.
  • Implemented version control and automated deployment workflows for analytics workloads using Azure DevOps and CI/CD pipelines, improving release reliability and repeatability across environments.
  • Productized the architecture and platform components to enable global rollout, collaborating with Microsoft CAT & Chris Webb on design validation and scalability.
  • Leading the migration to Microsoft Fabric, designing a Medallion Architecture-based lakehouse and warehouse to support reusable, domain-oriented data products, leveraging Spark-based processing patterns within Fabric for scalable data engineering workloads. Delivered Finance domain already and currently scaling architecture and governance to other domains.
dentsu
2 years
2020-02 - 2022-01

Designed and implemented data warehouse and ELT solutions

Senior Consultant BI & Data Management
Senior Consultant BI & Data Management

Delivered business intelligence solutions for media and retail clients, combining hands-on development with architectural design, project leadership, and stakeholder management.

  • Designed and implemented data warehouse and ELT solutions on on-premises SQL Server, leveraging SSIS and T-SQL for ingestion, transformation, and orchestration.
  • Built and optimized semantic models using SQL Server Analysis Services Tabular, incorporating aggregations, calculation groups, and custom incremental refresh automation to enhance performance, reduce processing time.
  • Developed Power BI dashboards and reporting layers, supporting operational and management reporting for business stakeholders.
  • Led architecture and delivery of BI projects end-to-end, coordinating requirements, timelines, engineering tasks, and client communication.
  • Improved stability, scalability, and automation in existing BI workloads by redesigning data models, refactoring ETL processes, and optimizing refresh patterns.
Qunis GmbH
7 years 9 months
2012-01 - 2019-09

Designed and delivered data warehouse and master data management platforms

Co-Founder
Co-Founder

Led the transformation of Bicentrix from a consultancy into a product-focused software company, defining the technical vision, product roadmap, and delivery processes while managing R&D initiatives and engineering capacity.

  • Achieved Microsoft Gold Business Intelligence Partner status in Turkey, positioning the company as a recognized provider of BI and data analytics solutions.
  • Designed and delivered data warehouse and master data management platforms using .NET, SQL Server, and Azure SQL, enabling multi-source integration and centralized governance for finance and retail clients.
  • Architected retail analytics solutions including order management and tracking integrated with Microsoft Dynamics AX, SQL-based stock optimization models, automated stock distribution algorithms, campaign optimization workflows, and customer clustering using K-means, as well as sales and stock velocity calculations and seasonality-based demand estimations, improving operational efficiency and store performance.
  • Developed budgeting, planning, and reporting applications for banking and retail customers, supporting financial analysis, performance management, and operational decision-making.
  • Architected and delivered web and desktop applications using .NET and Azure Web Apps, utilizing Azure Functions as microservices to enable modular, scalable, and maintainable application components.
  • Directed R&D programs with the Scientific and Technological Research Council of Turkey (TÜB?TAK) on data analytics and forecasting, driving innovation and technology adoption.
  • Evaluated architectural options and presented technical tradeoffs, cost implications, and business impact to stakeholders, supporting informed decision-making and product direction.
  • Led a 10-person engineering team, overseeing product design, development lifecycle, resource planning, and capability development.
  • Delivered measurable business outcomes such as improved stock utilization, reduced operational cost, enhanced customer profiling, and increased process efficiency.
on request
2 years
2010-01 - 2011-12

Managed project planning, resource allocation

Senior Business Intelligence Consultant and Project Manager
Senior Business Intelligence Consultant and Project Manager

Worked as a senior consultant and project manager on Business Intelligence initiatives, delivering financial and operational analytics solutions and managing end-to-end project execution.

  • Led business-critical system integrations and implemented advanced financial forecasting and reporting solutions for enterprise clients.
  • Managed project planning, resource allocation, cost control, and stakeholder communication, ensuring timely and successful delivery.
  • Developed custom tools and automations in C# and Microsoft Office environments, extending reporting and process capabilities.
  • Supported pre-sales and sales activities, including solution scoping, proposal development, and client presentations.
  • Worked with Microsoft Consulting Services (MCS) as an external consultant on selected engagements, contributing architecture and delivery expertise to Microsoft-led projects in Banking Sector.
Nexum Bo?aziçi
2 years 6 months
2007-07 - 2009-12

Designed and developed budgeting and reporting solutions

Business Intelligence and ERP Consultant
Business Intelligence and ERP Consultant

Worked as a consultant in Business Intelligence (BI) projects focused on budgeting, reporting, and performance management. Responsibilities included understanding complex business processes, designing data warehouse structures, implementing ETL workflows, writing complex SQL scripts, and developing advanced analytical reports.

  • Designed and developed budgeting and reporting solutions using SQL Server, ETL tools, and enterprise reporting platforms.
  • Built data warehouse models and transformation pipelines to integrate financial and operational data from multiple sources.
  • Worked as a consultant in Microsoft Dynamics NAV (Navision) ERP projects, contributing to both conceptual design and application development.
  • Delivered custom reporting solutions and process automation for finance and operations teams.
  • Presented Report Builder during the SQL Server 2008 R2 official launch event organized by Microsoft Turkey, presented the live demonstration session of the newly announced Report Builder 2.0.
Nexum Bo?aziçi
1 year
2006-07 - 2007-06

Budgeting and Reporting implementations

Junior Business Intelligence Consultant
Junior Business Intelligence Consultant
  • Worked as a junior in Business Intelligence (BI) projects mainly for Budgeting and Reporting implementations, Accounting and Process Reengineering, conceptualization and implementation of financial solutions. 
  • Prepared benchmarking analyses of various BI products, including Microsoft BI Tools, MIS(Infor) Decisionware, Proclarity and Crystal Reports. 
Nexum Bo?aziçi
1 year 1 month
2005-06 - 2006-06

Prepared periodical Sales

Financial Controller
Financial Controller
  • Prepared periodical Sales, Workforce Performance, Accounting and Controlling Reports to CFO and Account Managers. 
  • Supporting CFO on IAS-Based Financial Reporting activities for Nexum Group Worldwide. 
Nexum Bo?aziçi

Aus- und Weiterbildung

Aus- und Weiterbildung

1996 ? 2002

Kadiköy Anatolian High School (Science College)


2002 ? 2006

BA in Economics (Major) with Econometrics (Minor), University of Istanbul


2008 ? 2010

MA in Technology and Industrial Economics, University of Istanbul


Certificates:

  • Microsoft Certified: Fabric Analytics Engineer Associate (DP600)
  • Microsoft Certified: Fabric Data Engineer Associate (DP700)
  • (Scheduled-June) Microsoft Certified: Azure Administrator Associate (AZ104)
  • (Planned-September) Microsoft Certified: Azure AI Engineer Associate (AI102)

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

Produkte / Standards / Erfahrungen / Methoden

Areas of Expertise

Analyzing Requirements, Modeling and Constructing Data Warehouses, Data Lakehouses, Designing Complex ETL Pipelines, Creating Analytical Reporting Layers, Developing Full Stack .NET Applications, Realizing the requirements of Performance and Management Reporting, Planning, Budgeting, Forecasting scenarios for Finance, Sales, HR Departments as well as the C-Level Management. Stakeholder Management, Project Management, Data Products.


Developed 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.


Technical Skills

  • Microsoft Fabric, Microsoft Azure Synapse
  • Microsoft Azure Cloud (Apps, Databases, Virtual Machines, Functions)
  • Microsoft On Premises SQL Server
  • All prior MS BI Stack - SSRS, SSIS, SSAS (Tabular and Multi-Dimensional)
  • Source Code Management Systems: Github, Azure Devops
  • Elastic Search, RabbitMQ, Redis
  • ORMs (like EF, AutoMapper, TinyORM etc.)
  • ASP, Winforms, ASP.NET, ASP.Net Core, WCF, WebApi, GraphQL, Bootstrap
  • MS Dynamics NAV (Navision ERP)
  • MS Office (All Versions including MS Access, MS Project and MS Visio)


Project Experience

2006 - 2006

Role: Management Reporting Project

Customer: Roche (Pharmaceuticals)


2006 - 2006

Role: Budgeting and Management Reporting Project

Customer: Collezione (Textile Retailer)


2007 - 2012

Role: Management Reporting Project

Customer: Metro AG (Retailer)


2007 - 2007

Role: MS Dynamics NAV &SQL 2005 CPM Project

Customer: Pharmasante/L?Occitane (Cosmetics Retailer)


2008 - 2008

Role: SQL 2005 Reporting and Analysis Support Project

Customer: Darty/fnac (Electronics)


2008 - 2010

Role: OLAP and ETL Digital Transformation Project

Customer: Pfizer (Pharmaceuticals)


2010 - 2010

Role: Master Data Management Project

Customer: Pfizer (Pharmaceuticals)


2010 - 2010

Role: IMS Sales and Field Force Performance Project

Customer: Pfizer (Pharmaceuticals)


2010 - 2010

Role: Oracle Peoplesoft - Local Payroll Integration Project

Customer: Pfizer (Pharmaceuticals)


2011 - 2011

Role: Financial Forecasting and Reporting Project

Customer: Phillip Morris (Tobacco)


2012 - 2012

Role: Datawarehouse & Budgeting Project

Customer: Mercedes Benz & Financials (Automotive)


2012 - 2012

Role: Dealer Performance Management Project

Customer: Peugeot (Automotive)


2012 - 2012

Role: Field Performance and Bonus Management Project

Customer: Pfizer (Pharmaceuticals)


2012 - 2012

Role: Management Reporting and Budgeting Project

Customer: Kuveytturk (Bank)


2012 - 2012

Role: Management Reporting and Datawarehouse Project

Customer: Azerfon (Telecom Operator)


2013 - 2013

Role: Order Processing and Management Project

Customer: Apollo/GrandVision (Optics Retailer)


2014 - 2014

Role: Field Data Entry and Synchronization Project

Customer: MSF/Doctors Without Borders (Non-Profit)


2014 - 2014

Role: Datawarehouse and Management Reporting Project

Customer: Domino?s Pizza (Food)


2014 - 2014

Role: Datawarehouse and Sales Reporting Project

Customer: Bayer (Pharmaceuticals)


2015 - 2015

Role: Customer and Retail Experience Management Project

Customer: Penti (Lingerie Retailer)


2016 - 2016

Role: Master Data Management Project

Customer: Penti (Lingerie Retailer)


2016 - 2016

Role: Store Shift/Timesheet Management Project

Customer: Penti (Lingerie Retailer)


2017 - 2017

Role: Replenishment and Allocation Management Project

Customer: Penti (Lingerie Retailer)


2018 - 2018

Role: Subscription Based BI & DWH Project

Customer: Comdata Group (Italian Call Center Company)


2018 - 2018

Role: Customer Experience and Loyalty Management Project

Customer: Apollo/GrandVision (Optics Retailer) 


2020 - 2020

Role: Financial Datawarehouse Project - Sensei

Customer: Dentsu Aegis Network Germany (Media Agency)


2024 - 2024

Role: Unified Data Platform Project ? UMS

Customer: Dentsu Europe (Media Agency)

Programmiersprachen

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

Einsatzorte

Einsatzorte

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

Projekte

Projekte

1 month
2026-04 - now

Advise clients on data platform strategy

BI and Data Solutions Architect and Senior Consultant
BI and Data Solutions Architect and Senior Consultant

Provide independent consulting services in business intelligence, data platform architecture, and analytics transformation, helping organizations design scalable, modern data solutions aligned with business goals.

  • Advise clients on data platform strategy, architecture, and modernization initiatives across Microsoft data technologies, including Azure, Microsoft Fabric, Power BI, and SQL Server.
  • Design end-to-end analytics and data engineering solutions covering data ingestion, transformation, modeling, semantic layer design, and reporting enablement.
  • Support organizations in building scalable Lakehouse, Warehouse, and Semantic Model architectures with a focus on performance, maintainability, governance, and reusability.
  • Deliver hands-on expertise in dimensional modeling, tabular modeling, Power BI optimization, and enterprise BI best practices for reporting and self-service analytics.
  • Lead client engagements from discovery and solution design to implementation guidance, stakeholder alignment, and technical delivery oversight.
  • Help teams improve development standards, deployment processes, and platform reliability by introducing structured engineering practices, automation, and architectural governance.
  • Act as a trusted advisor to business and technical stakeholders, translating analytical and operational requirements into practical, sustainable data solutions.
Independent
4 years 2 months
2022-02 - 2026-03

Modernized an existing Data Vault-based SQL Server/SSIS/SSAS

Lead Global BI and Data Solutions Architect
Lead Global BI and Data Solutions Architect

Led the modernization and global scaling of dentsu?s data and analytics platform, evolving from an on-prem SQL Server stack to a modern Azure-based architecture and, more recently, Microsoft Fabric.

  • Modernized an existing Data Vault-based SQL Server/SSIS/SSAS environment by migrating the tabular model to Azure Analysis Services and optimizing ETL and data warehouse structures to improve stability and performance.
  • Built a global Azure Synapse-based data platform using Dedicated and Serverless SQL capabilities, integrating data from over 250 operational systems across regions and time zones through ADLS Gen2 storage. Delivered continuously orchestrated workloads, ensuring data availability, daily, across regions.
  • Standardized dimensional modeling practices using Tabular Editor and applied best practices, enabling maintainable, performant, and reusable analytics solutions. Implemented aggregations, calculation groups, and custom incremental refresh automation to optimize semantic model refresh speed and efficiency.
  • Implemented version control and automated deployment workflows for analytics workloads using Azure DevOps and CI/CD pipelines, improving release reliability and repeatability across environments.
  • Productized the architecture and platform components to enable global rollout, collaborating with Microsoft CAT & Chris Webb on design validation and scalability.
  • Leading the migration to Microsoft Fabric, designing a Medallion Architecture-based lakehouse and warehouse to support reusable, domain-oriented data products, leveraging Spark-based processing patterns within Fabric for scalable data engineering workloads. Delivered Finance domain already and currently scaling architecture and governance to other domains.
dentsu
2 years
2020-02 - 2022-01

Designed and implemented data warehouse and ELT solutions

Senior Consultant BI & Data Management
Senior Consultant BI & Data Management

Delivered business intelligence solutions for media and retail clients, combining hands-on development with architectural design, project leadership, and stakeholder management.

  • Designed and implemented data warehouse and ELT solutions on on-premises SQL Server, leveraging SSIS and T-SQL for ingestion, transformation, and orchestration.
  • Built and optimized semantic models using SQL Server Analysis Services Tabular, incorporating aggregations, calculation groups, and custom incremental refresh automation to enhance performance, reduce processing time.
  • Developed Power BI dashboards and reporting layers, supporting operational and management reporting for business stakeholders.
  • Led architecture and delivery of BI projects end-to-end, coordinating requirements, timelines, engineering tasks, and client communication.
  • Improved stability, scalability, and automation in existing BI workloads by redesigning data models, refactoring ETL processes, and optimizing refresh patterns.
Qunis GmbH
7 years 9 months
2012-01 - 2019-09

Designed and delivered data warehouse and master data management platforms

Co-Founder
Co-Founder

Led the transformation of Bicentrix from a consultancy into a product-focused software company, defining the technical vision, product roadmap, and delivery processes while managing R&D initiatives and engineering capacity.

  • Achieved Microsoft Gold Business Intelligence Partner status in Turkey, positioning the company as a recognized provider of BI and data analytics solutions.
  • Designed and delivered data warehouse and master data management platforms using .NET, SQL Server, and Azure SQL, enabling multi-source integration and centralized governance for finance and retail clients.
  • Architected retail analytics solutions including order management and tracking integrated with Microsoft Dynamics AX, SQL-based stock optimization models, automated stock distribution algorithms, campaign optimization workflows, and customer clustering using K-means, as well as sales and stock velocity calculations and seasonality-based demand estimations, improving operational efficiency and store performance.
  • Developed budgeting, planning, and reporting applications for banking and retail customers, supporting financial analysis, performance management, and operational decision-making.
  • Architected and delivered web and desktop applications using .NET and Azure Web Apps, utilizing Azure Functions as microservices to enable modular, scalable, and maintainable application components.
  • Directed R&D programs with the Scientific and Technological Research Council of Turkey (TÜB?TAK) on data analytics and forecasting, driving innovation and technology adoption.
  • Evaluated architectural options and presented technical tradeoffs, cost implications, and business impact to stakeholders, supporting informed decision-making and product direction.
  • Led a 10-person engineering team, overseeing product design, development lifecycle, resource planning, and capability development.
  • Delivered measurable business outcomes such as improved stock utilization, reduced operational cost, enhanced customer profiling, and increased process efficiency.
on request
2 years
2010-01 - 2011-12

Managed project planning, resource allocation

Senior Business Intelligence Consultant and Project Manager
Senior Business Intelligence Consultant and Project Manager

Worked as a senior consultant and project manager on Business Intelligence initiatives, delivering financial and operational analytics solutions and managing end-to-end project execution.

  • Led business-critical system integrations and implemented advanced financial forecasting and reporting solutions for enterprise clients.
  • Managed project planning, resource allocation, cost control, and stakeholder communication, ensuring timely and successful delivery.
  • Developed custom tools and automations in C# and Microsoft Office environments, extending reporting and process capabilities.
  • Supported pre-sales and sales activities, including solution scoping, proposal development, and client presentations.
  • Worked with Microsoft Consulting Services (MCS) as an external consultant on selected engagements, contributing architecture and delivery expertise to Microsoft-led projects in Banking Sector.
Nexum Bo?aziçi
2 years 6 months
2007-07 - 2009-12

Designed and developed budgeting and reporting solutions

Business Intelligence and ERP Consultant
Business Intelligence and ERP Consultant

Worked as a consultant in Business Intelligence (BI) projects focused on budgeting, reporting, and performance management. Responsibilities included understanding complex business processes, designing data warehouse structures, implementing ETL workflows, writing complex SQL scripts, and developing advanced analytical reports.

  • Designed and developed budgeting and reporting solutions using SQL Server, ETL tools, and enterprise reporting platforms.
  • Built data warehouse models and transformation pipelines to integrate financial and operational data from multiple sources.
  • Worked as a consultant in Microsoft Dynamics NAV (Navision) ERP projects, contributing to both conceptual design and application development.
  • Delivered custom reporting solutions and process automation for finance and operations teams.
  • Presented Report Builder during the SQL Server 2008 R2 official launch event organized by Microsoft Turkey, presented the live demonstration session of the newly announced Report Builder 2.0.
Nexum Bo?aziçi
1 year
2006-07 - 2007-06

Budgeting and Reporting implementations

Junior Business Intelligence Consultant
Junior Business Intelligence Consultant
  • Worked as a junior in Business Intelligence (BI) projects mainly for Budgeting and Reporting implementations, Accounting and Process Reengineering, conceptualization and implementation of financial solutions. 
  • Prepared benchmarking analyses of various BI products, including Microsoft BI Tools, MIS(Infor) Decisionware, Proclarity and Crystal Reports. 
Nexum Bo?aziçi
1 year 1 month
2005-06 - 2006-06

Prepared periodical Sales

Financial Controller
Financial Controller
  • Prepared periodical Sales, Workforce Performance, Accounting and Controlling Reports to CFO and Account Managers. 
  • Supporting CFO on IAS-Based Financial Reporting activities for Nexum Group Worldwide. 
Nexum Bo?aziçi

Aus- und Weiterbildung

Aus- und Weiterbildung

1996 ? 2002

Kadiköy Anatolian High School (Science College)


2002 ? 2006

BA in Economics (Major) with Econometrics (Minor), University of Istanbul


2008 ? 2010

MA in Technology and Industrial Economics, University of Istanbul


Certificates:

  • Microsoft Certified: Fabric Analytics Engineer Associate (DP600)
  • Microsoft Certified: Fabric Data Engineer Associate (DP700)
  • (Scheduled-June) Microsoft Certified: Azure Administrator Associate (AZ104)
  • (Planned-September) Microsoft Certified: Azure AI Engineer Associate (AI102)

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

Produkte / Standards / Erfahrungen / Methoden

Areas of Expertise

Analyzing Requirements, Modeling and Constructing Data Warehouses, Data Lakehouses, Designing Complex ETL Pipelines, Creating Analytical Reporting Layers, Developing Full Stack .NET Applications, Realizing the requirements of Performance and Management Reporting, Planning, Budgeting, Forecasting scenarios for Finance, Sales, HR Departments as well as the C-Level Management. Stakeholder Management, Project Management, Data Products.


Developed 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.


Technical Skills

  • Microsoft Fabric, Microsoft Azure Synapse
  • Microsoft Azure Cloud (Apps, Databases, Virtual Machines, Functions)
  • Microsoft On Premises SQL Server
  • All prior MS BI Stack - SSRS, SSIS, SSAS (Tabular and Multi-Dimensional)
  • Source Code Management Systems: Github, Azure Devops
  • Elastic Search, RabbitMQ, Redis
  • ORMs (like EF, AutoMapper, TinyORM etc.)
  • ASP, Winforms, ASP.NET, ASP.Net Core, WCF, WebApi, GraphQL, Bootstrap
  • MS Dynamics NAV (Navision ERP)
  • MS Office (All Versions including MS Access, MS Project and MS Visio)


Project Experience

2006 - 2006

Role: Management Reporting Project

Customer: Roche (Pharmaceuticals)


2006 - 2006

Role: Budgeting and Management Reporting Project

Customer: Collezione (Textile Retailer)


2007 - 2012

Role: Management Reporting Project

Customer: Metro AG (Retailer)


2007 - 2007

Role: MS Dynamics NAV &SQL 2005 CPM Project

Customer: Pharmasante/L?Occitane (Cosmetics Retailer)


2008 - 2008

Role: SQL 2005 Reporting and Analysis Support Project

Customer: Darty/fnac (Electronics)


2008 - 2010

Role: OLAP and ETL Digital Transformation Project

Customer: Pfizer (Pharmaceuticals)


2010 - 2010

Role: Master Data Management Project

Customer: Pfizer (Pharmaceuticals)


2010 - 2010

Role: IMS Sales and Field Force Performance Project

Customer: Pfizer (Pharmaceuticals)


2010 - 2010

Role: Oracle Peoplesoft - Local Payroll Integration Project

Customer: Pfizer (Pharmaceuticals)


2011 - 2011

Role: Financial Forecasting and Reporting Project

Customer: Phillip Morris (Tobacco)


2012 - 2012

Role: Datawarehouse & Budgeting Project

Customer: Mercedes Benz & Financials (Automotive)


2012 - 2012

Role: Dealer Performance Management Project

Customer: Peugeot (Automotive)


2012 - 2012

Role: Field Performance and Bonus Management Project

Customer: Pfizer (Pharmaceuticals)


2012 - 2012

Role: Management Reporting and Budgeting Project

Customer: Kuveytturk (Bank)


2012 - 2012

Role: Management Reporting and Datawarehouse Project

Customer: Azerfon (Telecom Operator)


2013 - 2013

Role: Order Processing and Management Project

Customer: Apollo/GrandVision (Optics Retailer)


2014 - 2014

Role: Field Data Entry and Synchronization Project

Customer: MSF/Doctors Without Borders (Non-Profit)


2014 - 2014

Role: Datawarehouse and Management Reporting Project

Customer: Domino?s Pizza (Food)


2014 - 2014

Role: Datawarehouse and Sales Reporting Project

Customer: Bayer (Pharmaceuticals)


2015 - 2015

Role: Customer and Retail Experience Management Project

Customer: Penti (Lingerie Retailer)


2016 - 2016

Role: Master Data Management Project

Customer: Penti (Lingerie Retailer)


2016 - 2016

Role: Store Shift/Timesheet Management Project

Customer: Penti (Lingerie Retailer)


2017 - 2017

Role: Replenishment and Allocation Management Project

Customer: Penti (Lingerie Retailer)


2018 - 2018

Role: Subscription Based BI & DWH Project

Customer: Comdata Group (Italian Call Center Company)


2018 - 2018

Role: Customer Experience and Loyalty Management Project

Customer: Apollo/GrandVision (Optics Retailer) 


2020 - 2020

Role: Financial Datawarehouse Project - Sensei

Customer: Dentsu Aegis Network Germany (Media Agency)


2024 - 2024

Role: Unified Data Platform Project ? UMS

Customer: Dentsu Europe (Media Agency)

Programmiersprachen

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

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.