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
Programming Languages Such as Python and R
Data Visualization Tool Such as Tableau and Excel
Analytical mindset with a problem-solving approach
Conversant with T-SQL Coding and DAX Language
Ability to work independently and in a team
Attention to details
Communication and Writing Skill
Ability to work in a high-paced environment
Ability to learn and respond quickly to the fast-changing business environment
Self-motivated and eager to learn
Ability to work in an agile environment with a focus on continuous improvement
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