Yavuz Celebi

Tools: MS Fabric Data Factory, Lakehouse, Warehouse, Notebooks, Paginated Reports (SSRS), Power BI, Tabular Editor, Measure Killer, JIRA

Tasks:

• Gathered business requirements by organizing and conducting meetings with business units.
• Designed logical and physical data models using dimensional modeling techniques (Star Schema).
• Implemented and managed the Medallion Architecture within Microsoft Fabric, organizing data across Bronze, Silver, and Gold layers to ensure data quality and traceability.
• Optimized Power BI reports for improved performance and usability.
• Fine-tuned DAX queries to support complex reporting and advanced analytics.
• Designed and developed Power BI dashboards following data visualization best practices.
• Implemented Power BI Deployment Pipelines and CI/CD workflows to enhance version control, minimize downtime, and standardize report deployment processes.
• Implemented Microsoft Fabric workspace security and Row-Level Security (RLS) to protect sensitive data across the organization.
• Delivered high-quality BI solutions within an Agile/Scrum framework, actively participating in daily stand-ups, sprint planning, and retrospectives to ensure timely project delivery.

Tools: Azure SQL Database, Azure Data Factory, MS Power BI

Tasks:

• Developed ETL pipelines using Azure Data Factory to support data integration and transformation processes.
• Optimized slow Power BI reports by reducing refresh times, model size, and improving overall report performance.
• Designed and developed interactive reports and dashboards in Power BI.
• Created data dictionary documentation for Power BI reports.

Tools: Oracle SQL Developer, MS SQL Server, SSIS, SSAS, SSRS, DAX Studio, Tabular Editor, SAP BO, Microsoft Power BI (Premium Capacity), JIRA

Tasks:

• Gathered business requirements by organizing and conducting meetings with business units.
• Designed logical and physical data models using dimensional modeling techniques (Star Schema).
• Developed ETL pipelines (incremental and full loads) using SSIS to support data integration and transformation processes.
• Created calculated columns, measures (DAX), and table relationships in SSAS.
• Created tables, views, indexes, and stored procedures in Microsoft SQL Server.
• Improved data refresh times, model size, and overall report performance.
• Migrated reports from SAP BO to Power BI.
• Administered the Power BI environment, including workspaces, user permissions, KPIs, alerts, email subscriptions, Row-Level Security (RLS), and semantic models.
• Provided ongoing Business Intelligence support for the entire BI department.
• Conducted training sessions for users across multiple departments to maximize the effective use of Power BI reports.

Tools: MS SQL Server, SSIS, MS Power BI (Premium Capacity)

Tasks:

• Gathered business requirements by organizing and conducting meetings with business units.
• Designed logical and physical data models using dimensional modeling techniques (Star Schema).
• Developed ETL pipelines using SSIS to support data integration and transformation processes.
• Created tables, views, indexes, and stored procedures in Microsoft SQL Server.
• Developed and optimized DAX measures in Power BI to answer real business questions.
• Created and optimized interactive reports and dashboards in Power BI.
• Provided ongoing Business Intelligence support across the organization.
• Administered Power BI Service, including workspaces, user permissions, KPIs, alerts, email subscriptions, Row-Level Security (RLS), and semantic models.
• Conducted training sessions for users across multiple departments to maximize the effective use of Power BI reports.

Tools: Azure SQL Database, Alteryx, MS Power BI

Tasks:

• Developed robust ETL pipelines using Alteryx to support seamless data integration and transformation.
• Designed and implemented logical and physical data models based on dimensional modeling principles.
• Developed dynamic stock and sales KPIs and interactive dashboards in Power BI to provide actionable insights for stakeholders.
• Prepared detailed source-to-target data mapping and data dictionary documentation.