Muhammed Yildiz

Senior Business Intelligence Developer @Nic Inc

Achieved successful result on performance based on execution plan and creating optimal logic using T-SQL.· Optimized SQL queries, stored procedures, user defined functions, indexes, and views for maximum efficiency.· Improved the performance of packages by updating statistics and restructuring the indexes to improve the server efficiency in SQL.· Used Query, SQL, Merge, Case, Validation transforms to transform the data in the staging table before loading into the warehouse tables. · Creating Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily. · Hands on experience in creating several SSIS schedule tasks and monitor those tasks regularly.· Proficient in DAX and constructing of advanced calculations and M language.· Involved in designing, developing, maintaining, and delivering new Power BI reports (Scorecard, Summary, E2E, KTLO and so on) with complex DAX query measures, columns, drill down, drill through, hyperlink options, dynamic slicing and dicing features, custom tooltips and KPIs by using different visualization like charts, histograms, pie charts, matrices, doughnut charts, tabular and etc. · Independently implemented Row Level Security and Page Level Security to reports.· Used DAX to add required calculated columns and measures, keeping unnecessary columns hidden from report view in Power BI to have accurate data models.· Hands-on experience with components of Azure Data Factory 2 such as Data Flows, Integration Runtimes as well as all types of Activities. · Worked with Azure Storages like Blob Storage and Azure Data Lake Gen1 and Gen2 as well as File Storages.· Experienced with SQL Pool and SQL on-demand to build data warehouse in Azure Synapse.· Created pipelines to load data from on-prem and azure data storages as well as external data sources with APIs inside Synapse environment.