Abreham Alemayehue

Arlington, VA ***** addg85@r.postjobfree.com 781-***-****

Professional Summary:

Over 8+ years of IT experience with expertise in analysis, design, development and implementation of data marts using Power BI, Tableau, ETL and RDBMS like Oracle 11g, MS SQL server.

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

Excellent experience in comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS) including MS solutions like MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013 Performance Point Server and ProClarity analysis server.

Strong ability to analyze user requirements, Business Requirement Specifications.

Expert in Data Preparation, Data Modeling and Data Blending.

Extensive experience with SQL Server with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.

Strong Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities.

3+ years of experience in Tableau, designed and developed multiple advanced visualization report and dashboard.

Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query.

experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau

Hands on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.

Generated context filters and data source filters while handling large volume of data using Power BI.

Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.

Hands on experience with MSBI (SSIS) to extract, transform and load data into database.

experience in Data Analysis, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools SSIS.

Experienced working with Excel Pivot, vlookup and other advance options.

Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.

Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed analytical, problem-solving skills and document function/process flows.

Good communication skills inter personal skills and proven ability to perform both as an individual and as a team player.

Education

Bachelor’s degree in computer science (2012)

University of Gondar, Ethiopia

Technical Skills:

Reporting Tools

Power BI Desktop (2.68), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools

SQL Server Integration Services (SSIS).

Databases

Oracle 10g/11g, MS SQL server 2014/16, Teradata 15 and Snowflake cloud database, Azure SQL DB

Hadoop Ecosystem

HDFS, Hive

Operating System

Windows, UNIX

Languages

C, C++, SQL, PL/SQL, T-SQL

Others

TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON,

Professional Experience:

CUNA Mutual Group Madison, WI Jan 2018-Present

Power BI Developer

Responsibilities:

Developed calculated columns and measures using DAX in Power BI

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

Created Power BI dashboard and generated reports.

Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.

Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.

Published Power BI Desktop to the cloud.

Experienced in Database Design, Development and administration of applications with Microsoft SQL Server 2016/2014/2008R2/2008 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in Development, Test and Production Environments and in diverse industries

Created interactive reports customized for the business using Power BI Desktop.

Installed and configured and maintained Power BI Report Server.

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

Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.

Developed complex SQL queries to obtain complex data from tables.

Read source data from HDFS, Azure SQL DB, CSV, ORACLE 11g, SQL Server 2016. through Power BI.

Read different formats of Source data from hive like JSON, ORC, TXT.

Generated context filters and data source filters while handling large volume of data.

Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.

Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.

Have used Z-order to overlap the reports on each other using Power BI.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.

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

Created multiple data model and used as a common data source for the reporting purpose.

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

In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.

Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.

Expert in using Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server and Efficient in migration from MS SQL Server 2012 to MS SQL Server 2016.

Created Row level security so based on role, the end user can view the data.

Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.

Created no of views, calculated tables, calculated columns and measures.

Created SQL Queries for testing the tableau Dashboards.

Hand on Experience in Unix to write basic commands, Moving files from HDFS to local and vice versa.

Environment: MS SQL Server 2012, MS SQL Server Analysis Services (SSAS), EDW, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, M Query.

Blue Cross Blue Shield, Detroit, MI Apr 2014- Dec 2017

Power BI Developer and Database Developer

Responsibilities:

Collaborated with the project team to outline project requirements in JRD meetings

Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.

Developed data reconciliation SQL queries to validate the overall data migration.

Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.

Expert in using Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server and Efficient in migration from MS SQL Server 2012 to MS SQL Server 2016.

Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Wrote DAX expressions to create new measures, calculations per business requirements.

Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.

Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS

Effectively used data blending, filters, actions, and hierarchies feature in Power BI.

Analyzed the data using Statistical features in Power BI to develop trend analysis.

Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.

Successfully integrated custom visuals based on business requirements in Power BI desktop.

Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down chart and tabular reports using SSRS.

Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, Bullets using Power BI.

Administrated and scheduled data-driven mailing subscriptions on SSRS Reporting Server.

Delivered reports with subscription functions in SSRS.

Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.

Environment: MS SQL Server, SSRS, SQL Server reporting services, MS SQL Server 2016T-SQL, DAX, SQL Server, Power BI Desktop, MDX, Microsoft Visual Studio 2014, Excel, Azure, SSMS.

Emergency Nurses Association, Schaumburg, Illinois Oct 2012-May 2014

Role: SQL Power BI Developer

Responsibilities:

Involved in gathering the user requirements.

Performed tasks like execute SQL task, data flow task, file system task for ETL process.

Worked Extensively on ETL process using SSIS package.

Used all types of container tasks such as for loop, foreach loop and sequence container in SSIS.

Created Backend validations using Insert/ Update and Delete triggers.

Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.

Configured SSIS Packages using Environment Variables for Dynamic selection of Development and

Production Environment.

Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions

tables.

Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.

Coordinated with DBA in creating and managing tables, indexes, triggers and privileges.

Designed production and sales dashboard for Sales and procurement departments using Power BI.

Using Microsoft Power BI for data visualization.

Created new measures and new calculated columns for reports and dashboard analysis.

Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI,

Map, Pie chart, custom visuals).

Published reports and dashboards to the Power BI service.

Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter,

Month, and Week.

Created Drill Down Reports, Drill Through Report by Region.

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL, Excel, etc.

Weekly presentation to the business users about the reports and their changes as required.

Worked on transformations that are available in Power BI query editor.

Participated in project planning sessions with project managers, business analysts and team members

to analyze business requirements and outline the proposed solution.

Shared the dashboards among multiple users in the group.

Implemented row level security by restricting the users for the data access.

Created Content packs that package up a dashboard, report, and dataset to share with users.

Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).

Used agile development Methodology.

Environment: SQL SERVER 2005/2008, Power BI, T-SQL, SSIS (2005), SSRS (2005), Business Objects, Windows Server 2008,

Visual Studio.

Contact this candidate