Tsegaye Assefa

adye56@r.postjobfree.com

240-***-****

linkedin.com/in/assefa-tsegaye-76a5931

Summary POWER BI, SQL, SSIS and SSRS DEVELOPER

Experience Summary:

A Microsoft POWER BI Developer,SQL,SSIS,SSRS and with 7+ years IT experience: As a professional Database and power BI developer, I have implemented supported both OLTP and OLAP applications, created different database and database objects using SQL Server, created application integration and data transformation using SSIS packages and developed reports using SSRS, TABLEAU and POWER BI. Hands-on experience in Power BI platforms: Power bi desktop, Power Bi Service, power Bi report builder and power bi mobile app. Specializing in Data Warehouse, Power BI Reporting Service, SQL Server, Azure Cloud Computing, ADF (Azure Data Factory), Database and BI developer with SQL Server, Developing Complex SQL query SSMS and Data Modeling,Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization. Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers .Experience supporting Data Flow transformations:

Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All. Expertise in enhancing and deploying SSIS packages from development server to production server, Keen understanding of dimensional Star Schema and Snowflakes Schema.

I specialize in Microsoft Power BI to create a report using datasets and Power Bi desktop tools to understand the data in depth Experienced in Microsoft Power BI Premium, Power BI Pro, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.

Design and develop Power Bi report and dataset gathering, manipulating, and loading data. Building and Designing power bi reports and dashboards, developing data models creating custom visuals and calculations, connecting and integrated data, Designing and creating paginated reports, configuring data sources, building and designing reports layouts creating parameters and complex calculations.

Develop and deploy power bi solutions to support business processes and decision making, stay up-to-date with the latest power bi features and best practices and incorporate them into development processes. Adhere to compliance procedure and internal/operational risk controls in accordance with all applicable regulatory standards and policies Experience

Power bi developer

Light house mortgage HAUPPAUGE, NY, 2021 February.—present

Worked closely with Business Analyst and all team within the organization to understand business processes.

Developed complex SQL queries, stored procedures and views to be used in Power BI reports as well as for ETL workflows and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor. Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.

Used the tabular model cubes as the source in Power BI to visualize the data.

Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard. Created interactive reports customized for the business using Power BI Desktop.

Installed and configured and maintained Power BI Report Service, Worked on a project in the migration of Tableau reports to Power Bi report server.

Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog, imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.

Cleaning up datasets using Marge queries, append queries, and sort data column to properly fit our reports. Created Dax Queries to generated computed columns in Power BI, also applied DAX calculated measures and columns.

Design and develop Power Bi report and dataset gathering, manipulating, and loading data.

Building and Designing power bi reports and dashboards, developing data models creating custom visuals and calculations, connecting and integrated data.

Designing and creating paginated reports, configuring data sources, building and designing reports layouts creating parameters and complex calculations.

Generated computed tables in Power BI by using Dax

Involved in creating new stored procedures and optimizing existing queries and stored procedures. Created Azure Blob Storage for Import/Export data to/from .CSV File also access and analyze dataset and KPI’s to create reports.

Used Power BI to created visualization tools intended for diverse users.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Explore data in a variety of ways and across multiple visualizations using Power BI.

Used Power BI Gateways to keep the dashboards and reports up to date.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Published reports and dashboards using Power BI.

Power bi and Business Intelligence Developer

Highmark Health Pittsburgh, PA Jul 2018 - Jan 2021

Worked closely with SME’s end users/internal customers to understand project/requirement scope

Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes

Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements, and prepared documentation for same.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (Used CTE, temporary tables, user defined table types in codes developed)

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2014/2017.

Experience in Power BI and with different BI component like (Oracle, SQL, SSIS, SSRS, SSAS).

Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog.

Experience in automating tasks and work flows between applications and services using Microsoft Power Automate tool.

Imported data from Oracle DB, SQL Server DB and Azure SQL DB to Power BI to generate reports. Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.

Created Azure Blob Storage for Import/Export data to/from .CSV File, also assess and analyze dataset and KPI’s to create reports.

Used Power BI to create visualization tools intended for diverse users.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

SQL Business Intelligence Developer

EAGLE BANK Bethesda, MD Jul 2015 - NOVEMBER 2017

Worked closely with internal and external users to understanding and gathering business requirements. Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.

Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraint

Regularly monitored SQL server, analyzing the logs, troubleshooting SQL Server problems such as Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.

Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Implemented a DB maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and running, SQL Tracer and SQL Profiler.

Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.

Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher periodically.

Log shipping database for reporting server within the firms’ latency objective.

Mirrored one of our critical databases with zero latency/synchronized- with witness/for critical Database on SQL 2008.

Part of the team which configured Always On with availability group for one of our critical servers on SQL 2012 that was installed via nodes on WSFC (Window Server Failover cluster).

Performed full, differential and transaction log backups.

Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.

Used the SQL Server profiler to capture and store the execution plan.

Provided weekly, monthly, yearly quality control reports for work orders, service requests.

Represent reports in different forms using graphs, charts, tabular, area and pie charts as required. Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS). Worked with XML configuration files and variables for deploying SSIS packages into various environment Education Bachelor’s Degree, Information Technology Skills .net

automate

business analysis

business intelligence

business process

business systems analysis

charts

customer relations

data modeling

data transfer

Contact this candidate