MUSTAFA TORER

Senior Data Consultant

Creating architectural design for end-to-end cloud solutions. Microsoft Fabric analytic platform migration and implementation. Designing semantic models and visualsing in Power BI. Producing project technical design documents

• ETI Data Warehouse Migration Project (SAP BW, On-Prem SQL Server, Databricks,PySpark, Power BI, DAX)

  Creating unity catalog in Databricks, managing Dev-Test-Prod environments via Azure DevOps, designing Power BI dashboards for a better customer experience

• Beko Europe Microsoft Fabric Imlementation and Governance Modelling (Google BigQuery, Microsoft Fabric, Power BI)

  Designed Enterprise Governance Model in Microsoft Fabric. Data from BigQuery into Fabric and creating Power BI reports

• Renault Indisol Microsoft Fabric Implementation Project (Oracle,Salesforce, Microsoft Fabric, PySpark,Power BI)

  Microsoft Fabric Implementation for data warehouse and reporting in Power BI

Senior Data Engineer

Dynamics 365 FnO Data Implementation in Azure Synapse Analytics using Synapse Link

• Designing Azure Synapse Data Pipelines that curates Dynamics 365 FnO data for BI reporting

• Implementing Medallion Architecture Bronze to Silver layer for 85 entities

• Azure DevOps was used implementing CI/CD for best practice

Senior Data Engineer

Designed end-to-end cloud solutions in Azure Synapse Analytics. Implemented process logging and alert mechanism. Developed Power BI dashboards

• Arvato Data Synapse Analytics Implementation Project (On-Prem SQL Server, Azure Synapse Analytics, Azure Data Factory, Logic App)

  Implementing around 100 tables data into dedicated Sql pool in Azure Synapse Analytics by using Data Factory. Designing data pipeline logging and alert mechanism and presenting in Power BI report.

• Unilever Power BI Reporting (Power BI, DAX, Azure SQL)

  Designing an Executive Summary Dashboard using existing DWH models and datamarts.

Azure Data Engineer

Designing architecture solutions on cloud or on-premise environment that supports complex data analytics services. Creating data models using SQL. Analysing client's data and visualising through reporting environments (Power BI, SSRS). Producing project technical design documents

• Nestle DWH Implementation (Azure Synapse Analytics, Data Lake, Data Factory, SQL Server 2016, TSQL, Procedures and Functions)

  Designed DWH solution in Azure Synapse Analytics. Migrated previous solution from SQL Server 2016 to Azure environment

• XYZ Reality Limited Power BI Dashboard (Power BI, DAX, Mongo DB)

  Created dashboards for the company’s website portal to provide a better customer experience

• Entek Energy Azure Synapse DWH Project (Azure Synapse Analytics, Data Lake, Data Factory, Spark Pool, PySpark, Scala, Azure Function, Logic Apps, Rest Api, Power BI, Power Apps, Power Automate)

  Structured and Unstructured data collected on Azure Data Lake Data and visualised by Power BI. Designed Power Apps for gathering customer parameters instead of Excel sheets. Email distribution which is attached report’s pdf file by Power Automate. Cost-effective process management by using Azure Functions. Transformed old fashion Excel reports into Power BI dashboards to simplify people’s workloads.

• BtcTurk Crypto Market DWH Design and Reporting on Azure (Synapse Analytics, Analysis Services, Azure Data Factory, Power BI)

  Data process and reporting workload effects on OLTP database were reduced completely.

• FLO Data Migration Project (On-Prem SQL Server, AWS, Azure Synapse Analytics, Azure Data Factory)

  Migrated more than 300 SSIS packaging into Data Factory. Data calculation and cube process time decreased 75%

Power BI Developer

Developing Power BI reports and dashboards. Designing and Maintaining SSAS Tabular Models. Gathering customer needs and managing business leaders expectations

• Aksigorta Insurance SSAS Tabular Project (SSAS Tabular Cube, Partitioning, Power BI, DAX, Oracle DB, PLSQL, SSIS)

  Automatised cube partition refreshing system. Created reports and dashboards in Power BI

• P&G Global Data Integration and Reporting Project (Data Integration, Azure SQL Database, Data Factory, Dynamics 365 Finance and Operations Entities by using BYOD, Power BI)

  Integrated Dynamics 365 Finance and Operation Entities by using BYOD to Azure SQL Database, created PowerBI reports and dashboards

• P&G Contractor's Performance Analysis Project (SQL Server 2016, Power BI Model & Visualization)

• P&G Daily Target Achievement Rate Project (SQL Server 2016, Power BI Model & Visualization)

Senior BI Developer

Working with the development team to create conceptual data models and ETL/ELT processes. Developing DHW modelling with Kimball methodology by coding PLSQL packages and procedures

• Mapfre IFRS Financial Reporting Project (IFRS 17 & Data Integration & Financial Reporting)

  Designed this report by combining all legacy systems ledger accounts, financial dimensions, sub-ledger balance, customer, vendor, products

• Mapfre Salesforce Data Integration Project(Data Integration, Data Warehouse & Data Mart Models in Oracle DB, ETL)

• CRM Data Governance Project (Data Quality, Data Validation)

  Defined required actions to take by company via validation rule sets for all applications’ data

• Technical Profit and Loss Project (Data Warehouse & Data Mart, Financial Reporting)

Business Intelligence and Reporting Specialist

Responsible for BI Management, Development, and Maintenance of the System

• Store Scorecard Dashboard (Data Integration, SSIS, Award winning project)

  Responsible for Data Integration activities from SAP ECC to DWH and the project was awarded the EuroCIS Retail Best Enterprise Solution

• SQL Server 2014 Migration Project (Data Migration, Upgrade BI System to MSSQL 2014)

  Implemented high availability and fail-over architecture in SQL Server 2014. Upgraded SSIS packages to 2014 version.

• Finance Reporting Project (SSAS Tabular Model, SSIS, Power BI)

• HR Retail Merchandising OLAP Cube Project (SSAS OLAP Cube, SSIS, Data Warehouse Models)

Business Intelligence and Data Warehouse Consultant

System Management and DWH Administration. Providing data to the auditors with high-level financial data analysis

• SayData Data Distribution Project (C#, Asp.Net Mvc, Html5, Css, Jquery, SQL Server 2012, Pentaho Data Integration)

• SayDap Computer Assisted Audit Project (Linux, VmWare ESX, PostgreSQL, Pentaho Data Integration)

Business Intelligence Engineer

Providing Data Warehouse development, ETL maintenance, Reporting, and Software Development

• DWH and OLAP Cube Projects (SQL Server 2012, SSIS, SSAS, SSRS) and Reporting Tool Development (Asp.Net, C#, DevEx)

• SQL Server 2008 R2 to SQL Server 2012 System Upgrade

Turgut Ozal University

• Analyzing Readability Level of Educational Content in Turkish Language, 2015
2015 Twelve International Conference on Electronics Computer and Computation(ICECCO)
Page(s):1-4 DOI: 10.1109/ICECCO.2015.7416875)
• Classifying Readability Level of Educational Content in Turkish Language,2015
Council of High Education, Master Thesis – Ref. Num: 10087998

Uludag University

• Designing Security System for Small Company, 2008

TRAININIG

• Entrepreneurship – Creating the Business, Alison, 2019
• IBM Cognos Analytics Training, Mapfre, 2018
• Designing BI Solution with Microsoft BI (SSIS, SSAS, SSRS, PowerBI), 2015
• Oracle Data Integrator 12c, LinkPlus, 2015
• Oracle Business Intelligence Suite EE 11g, LinkPlus, 2014
• IBM BigData Technical Professional, IBM, 2014
• IBM Content Analytics Product Technical Professional, IBM, 2013
• Linux, PostgreSQL and Pentaho Data Integrator Training, Tubitak, 2013
• Software and Database Expertise (C#, Asp.Net, Asp.Net MVC, SQL Server 2012), BilgeAdam, 2011