Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

YISHAK TEKALIGNE TAYE

Seattle,WA

Summary

Certified Data Science Professional with over 5+ years of experience in MSBI Developer.

Excellent analytical and problem-solving skills for translating data into informative visuals and reports.

Possess in-depth knowledge of using data management technologies such as Power BI tools, SQL Server Integration Service (SSIS) platform, and MS SQL server.

Rich experience on data organization, visualization and analysis including deriving insights for successful business solutions.

Excellent Knowledge in RDBMS and Data Warehousing concepts.

Conversant with T-SQL Coding and Data Analysis Expression (DAX) Languages.

Solid Experience on creating Stored Procedures, Triggers, and Indexes.

Solid Experience in whole cycle of SSIS and designing packages for performing Data Transfers.

Effective in designing dynamic dashboards and enterprise reports.

Comprehensive knowledge of data design, data modeling, data management, and data visualization.

Overview

1
1
Certification
2
2
years of post-secondary education
6
6
years of professional experience

Work History

Power BI Developer

11.2017 - 07.2021
  • Understood business requirements in BI context and designed data models to transform raw data into meaningful insights.
  • Imported data from different sources including Files, SQL Server DB, and Online Services to Power BI to generate reports.
  • Developed SQL queries in SQL Server to support Power BI Reports.
  • Undertook ETL Process using the in-built Power Query Editor.
  • Developed calculated measures and Calculated Columns using Data Analysis Expression (DAX) Language.
  • Analyzed data and present data through reports that aid decision-making.
  • Designed Star Schema and Snowflake Schema data models for developing Power BI Reports.
  • Integrated Custom Visuals based on business requirements using Power BI Desktop.
  • Developed at least two-three visual options for each report for discussion with stakeholders & business users.
  • Created different visualizations (Stacked Bar chart, Clustered Bar Chart, Map Chart, Scatter Chart, Pie Chart etc.) in Power BI according to the business requirements.
  • Create customize charts and custom calculations as per requirements.
  • Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business requirements to support executive business needs.
  • Used SSIS to undertake the ETL Process for supporting the Power Bi Reports.
  • Published Power BI Reports from Power BI Desktop to Power BI Services.
  • Work with users and team members at all levels for performance improvement and suggestions.

SQL BI Developer

01.2015 - 02.2017
  • Created complex stored procedures, functions, indexes, tables, views, and other t-SQL codes in observing the business requirements.
  • Utilized joins and sub-queries to simplify complex queries involving multiple tables while optimizing procedures and triggers to be used in production.
  • Creating clustered and non-clustered indexes on the columns recommended by the query optimizer to improve the performance of the slow running queries and stored procedures.
  • Developed SSIS Packages to transfer clean data from different sources including Excel, Text file, and XML File to SQL Server.
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
  • Deployed different SSIS Packages from development server to Production server.
  • ACADEMIC QUALIFICATION MA, Economics (Applied Trade Policy Analysis), Addis Ababa University, Addis Ababa, Ethiopia, July 2009.

Education

MA, Applied Trade Policy Analysis

Addis Ababa University
Addis Ababa,Ethiopia
09.2007 - 07.2009

Skills

Data Management technologies such as Power BI, T-SQL and SSIS

undefined

Certification

Professional Certificate on Data Science Fundaments and Core (From Microsoft in collaboration with EDX, September 2019)

Timeline

Power BI Developer

11.2017 - 07.2021

SQL BI Developer

01.2015 - 02.2017

MA, Applied Trade Policy Analysis

Addis Ababa University
09.2007 - 07.2009

Similar Profiles

CREATE PROFILE
YISHAK TEKALIGNE TAYE