Tsegaye L.

About Tsegaye L.

Experienced Power BI Developer with over 7 years of experience in power Bi, Data warehousing projects and SQL Database Development, directly involved in gathering data from various sources and transforming it into insightful reports and dashboards.Proficient in data modeling and integrating reporting components from multiple data sources.Created Row Level Security with Power BI Desktop and integration with Power BI Service portal.Experienced in optimizing reports and setting up Power BI service, gateways, and scheduling data refresh.Created dataflows using different data sources like SharePoint folder, Web API, SQL database, excel, oracle database and text/Csv files.Demonstrated ability to collaborate with cross-functional teams, resulting in successful completion of projects within deadlines.Facilitated different stakeholder meetings and taking notes of conversion and action points.Designed and developed reports and dashboards using the Power BI platform. Gathered data from various sources including SAP and Excel.Worked as backend admin for the company SharePoint portal where many stakeholders have access to by building lists, event calendars(countdowns) and maintenance of the site according to the procedure.Expertise in writing T-SQL (DML & DDL) Code, Dynamic SQL, Query optimization & performance tuning using SQL Profiler, Execution plan, Performance Monitor, and DBCC commands.Experienced in Data analysis using Microsoft Excel (Lookup, power query, pivot table, conditional formatting)- Excellent backend skills in creating SQL objects like Tables, complex Stored Procedures, Views, Indexes, effective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.Experience utilizing DAX functions and understanding the Data modeling (Dimensional & Relational) concepts like Star Schema ModelingProficient in using Power BI data visualization tool to analyze and obtain insights from large datasets, creating visually compelling and actionable interactive reports and dashboards.

Experience

1. Senior Business Intelligence Developer

   Exelon

   Jan 2023 — Present · Baltimore, MD, US

   Designed and created innovative and valuable visualizations to identify patterns, trends and exceptions which enable the business stakeholders and senior leaders to make data driven decisions.Owned and managed multiple reports, dataflows, datasets in different workspacesCreated operational, business performance dashboards interpret the results, and summarize opportunities for improvement and make recommendations to senior leadership.Collaborated with internal and external stakeholders to gather requirements on new Power BI projects and visualize the outcomes through reports.

Education

• University of Gondar

  Master's degree

• Alemaya University

  Bachelor's degree

• Udemy Alumni

  Certificate, Power Bi master class (DAX)

• Coursera

  Google Data analytics professional certificate, Data analytics