OBJECTIVE: • Microsoft Certified Data Analyst Associate, seven plus years of

experience in the IT industry as a MS SQL Server Developer include

experience in design, development and implementation of database
systems using MS SQL Server 2016/ 2014/2012/2008 R2/2008 for
both OLTP & Data Warehousing Systems applications with various
business domains. • Experienced in all project phases using Agile and
Waterfall Methodologies. • Experienced in complete MSBI Stack with
SSIS, SSAS and SSRS. • Experienced in designing and developing BI
solutions utilizing SQL server and using Power BI, Power BI report
builder, Azure SQL Server, SSIS, SSAS, SSRS. • Integrated Custom
Visuals and KPI scorecards reports using Power BI desktop and
published and collaborated dashboards and reports in Power BI
Service. • Prepared and structured Query using Power Query M
Formula in the Query editor. • Developed complex calculated measures
using Data Analysis Expression (DAX). • Highly Proficient in creating
SQL Server Reports, handling sub-reports, and writing queries to
perform Drill through and drill down operations. • Extensive database
programming experience in writing T-SQL queries, Common Table
Expressions (CTE), User Defined Functions, Triggers, Views,
Temporary Tables Constraints, Indexes, and appropriate Stored
Procedures using DDL and DML command to facilitate data
manipulation and data consistency. • Practical understanding of
Conceptual, Logical and Physical Database design and data Modeling
(Dimensional & Relational) concepts like Star-Schema Modeling,
Snowflake Schema Modeling, Fact and Dimension tables. • Proficient
in Developing and designing of ETL (Extract, Transform and Load)
SSIS/DTS Packages for integrating data from heterogeneous sources
(Excel, Xml, Oracle, flat file, Text Format Data) to MS SQL Server
Datawarehouse • Create, backup and restore Azure SQL databases •
Migrate on prem SQL Server Databases to Azure SQL databases •
Conversant with all phase of Software Develop

EXPERIENCE: 1/2021 - Present Dunatek LLC

POWER BI DEVELOPER

3/2020 - 10/2020 PROCENTRIX

Contractor

BI DEVELOPER/POWER BI DEVELOPER • Participated BI

software development, deployment, and maintenance independently as
well as a proactive team member. • Generated and upgraded
Interactive, refresh scheduled Power BI and Paginated Reports and
Dashboards from SharePoint and SQL server databases. • Generated
Power BI and Paginated Power BI reports based on business
requirements and business logic. • Setting business requirements and
creating technical documentation for BI tools. • Translating business
requirements into technical documentation. • Create, design and view
power bi Paginated report by using Power BI Report Builder. • Upload
and save power bi paginated report to power BI Report Server •
Redesign power bi dashboards and paginated reports. • Involved in
Developing and Designing ETL process based on the schemas and
business requirement by using SSIS. • Creating and Publishing Power
Bi Paginated Reports in Power BI Service and Power BI report Server.
Tools & Technology in SEC: SharePoint; GitHub; Cisco Jabber; Cisco
WebEx; Microsoft teams; C#; VB; Agile; Python; Power Bi report
builder; service now; Azure DevOps.

12/2016 - 3/2020 QUEST

DIAGNOSTIC
SQL Server/ BI DEVELOPER / ETL DEVELOPER

• Worked in Developing and designing of ETL SSIS/DTS Packages for

integrating data from heterogeneous sources (Excel, Xml, Oracle, flat
file, Text Format Data) to MS SQL Server data warehouse. • Designed
the ETL process based on the schemas (snowflake and star schema) for
extraction and transformation of data from the source database and
loading on to the target database. • Resolved SSIS Performance, SSIS
package tuning by configuring data flow task using SQL Server
destination and fast load mode to resolve Performance issues, tuned a
process and brought down the process time from 6 hours to less than 30
minutes. • Implemented complex business rules using multiple
transformations like Conditional Split, Look up Transform, Derived
Column, and Union All. Also, handled errors efficiently. • Developed
several customized power BI reports, monitoring productivity in lab
test per turnaround time (TAT), resulting in dramatically decreased
TAT by 100%. • Integrated Custom Visuals and KPI scorecards using
Power BI desktop and published and collaborated in Power BI Service
• Prepared documents to show the details of packages and Reports
created for future reference. • Implemented the core business process
using T-SQL, Stored Procedures and Functions • Developed code,
perform reviews to advance application upgrade, extension, or other
development. Analyze application for data integrity issues. • Ability to
analyze and resolve performance issue with database code involving
SSIS and MS SQL Server 2005/ 2008. Tools & Technology in Quest:
ODATA API; MySQL; SharePoint; GitHub; Slack; Trello; Oracle Data
Modeler; C#; VB; SMTP; JSON; XML; HTML; Snowflake; Azure
SQL; ODBC; OLE DB; Data Cube; ADO.Net; Tableau; Data Factory;
GoToMeeting; Jira; Agile; Python and R, D3Java, SAS.

1/2012 - 8/2015 INTERNATIONAL

 CLINICAL
LABORATORIES
SQL Server/ ETL DEVELOPER

• Consolidated data from various sources into a common data

warehouse for reporting and analysis purpose using ETL (Extraction,
Transformation and Loading) • Designed ETL architecture for overall
data transfer from the OLTP to OLAP with the help of SSIS. • Created
SSIS packages using proper control and data flow elements with error
handling. • Enhancing and deploying the SSIS Packages from
development server to team foundation server (TFS). • Developed the
chart type, Tablix, matrix reports in SSRS (SQL Server Reporting
Services) like lab test status, specimens flow, department productivity
from the OLAP system. • Created reports with different features like
drill through capabilities. • Involved in modifying report content and
exporting reports in multiple formats based on the business
requirements. • Created derived columns on the final fact and
dimension tables as per the business requirements. Tools &
Technology in ICL: SQL Server; SQL Server Data Tools; Integration
Service; Reporting Service; Visio; Analysis Service; Data Profiler;
TFS; Team Viewer; Waterfall; DTSX

EDUCATION: 9/2003 - 7/2007 Addis Ababa

University AAU
Bachelor's Degree
Bachelor's in Business Administration and Information System
09/2003-07/2007 • Addis Ababa University AAU, Addis Ababa,
Ethiopia

9/1999 - 7/2001 Jimma University

Associate Degree
Bachelor's in Medical Laboratory Technology 09/1999-07/2001

CERTIFICATION: 3/2021
Microsoft Certified
Microsoft Certified in Azure Fundamentals

2/2021
Microsoft Certified-Power BI
Data Analyst Associate/Analyzing Data with Microsoft Power BI

Credential URL: https://www.udemy.com/certificate/UC-

KBUGM5JX

Udemy-Practical SQL Reporting With SSRS

Credential URL: https://www.udemy.com/certificate/UC-JN2K178Y

 Udemy-Azure-SQL

Credential URL: https://www.udemy.com/certificate/UC-

EYSMM7LU

Udemy-Python for Beginners (Python 3)

Credential URL:https://www.udemy.com/certificate/UC-45ODU8Y3

Udemy-Microsoft Power BI Complete Introduction

URL:https://www.udemy.com/certificate/UC-bf481d0a-93d2-424c-
81d8-5ba9bea22cde

Udemy-Data Visualization and Interactive Dashboards with Power BI

URL: https://www.youracclaim.com/badges/abe587db-32c3-445e-
b43a-db2b94044479?source=linked_in_profil

Additional Info  

Target Locations: Selected Locations: US-VA-McLean/Arlington

Relocate: Yes
Willingness to travel: No Travel Required