Y*HANNES KASAHUN REDA

Location: Alexandria Virgina

Number: 202-***-****

Email: adzy1j@r.postjobfree.com

Professional Summary:

BI. Developer with Over 6yrs experience in Data Warehousing, Transact-SQL query development, QA Testing, Data Mapping, Data Modeling, SSRS Drill through and Drill down reporting.

Proficient in installing, configuring, managing, monitoring, and troubleshooting MS SQL Server 2019/2016/2014/2012/2008.

Experience in writing T-SQL stored procedures, Triggers, Constraints, and indexes using various DDL and DML commands.

Extensive experience in Performing data cleaning and validation using (DAX) data analysis expression, power query, and Power Pivot.

Hands-on experience with designing and developing efficient Visualizations and Reports using Power BI Desktop using various data sources such as Microsoft SQL Server, Azure SQL DB, MS Excel, and CSV

Proficient Power BI Data Modelling and Data Warehousing concepts like Star Schema, Snow Flake Schema, Dimensions, and Fact Tables.

Proficient in designing/building complex stunning reports/dashboards using Filter (Slicers), Drill-down Reports, Sub reports, and Ad Hoc reports in Power BI Desktop

Experience with Power BI Service administration, Managing Workspaces, configuring Power BI Gateways in a Hybrid Cloud environment for refreshing from on-premise data sources

Expert at developing ETL interfaces using SSIS, Data Marts/Cubes using SSAS, and Enterprise Reports using Power BI and SSRS utilizing the latest versions and features.

Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join, and Sort and Derived Columns for cleaning bad data, and validating data.

Experience in working with containers like For Each Loop Container, For Loop Container, and Sequence Container.

Experience in creating the package in an optimized way, debugging (Data Viewers, Break Points), and deployment of the packages in Integrated Servers

Have hands-on experience in Performance Tuning and Query Optimization.

Strong verbal and written communication skills.

Able to interpret business needs and write them as Code to facilitate insights/reporting.

Solution implementation using Azure Blob, Data Lake and Data Factory

Technical Skills:

Database Languages: SQL, T-SQL, DAX, Visual Basic

Database:

SQL Server 2019/2016/2014/2012/2008R2/2008/2005

Data Modeling and Tools: E-R Modeling and Dimensional Modeling, ERWIN, Visio, and JIRA Team Foundation Server (TFS)

Source Code Control: Microsoft Visual Studio Team Foundation (TFS), Git/GitHub

Azure Cloud: Azure SQL Server, Azure SQL Database, Azure SQL Managed Instance, Azure SQL Data Warehouse, Data Lake Store, Azure Data Factory, Azure Virtual Networks, Azure Virtual Machine, and Azure Storage

BI Tools: SQL Server Management Studio, SSIS, SQL Profiler, SQL Server Agent, SQL Server Data Tools, Power BI, Extended Events, Query Store, DMV, and DMF.

Operating Systems: Windows Server 2016/2012/2008/2003, Windows 10/11, and Mac

Methodologies: Agile, and Scrum

Application Tools: MS Office 365, MS Visio

Other Skills: Root cause analysis, Failure Mode and Effect Analysis, Quality Management System, Manufacturing, Statistical Process Control SPC, Kaizen 5S, Advanced Product Quality Planning, ISO9001:2015, MS Project, AutoCAD, NDT (Ultrasonic, Radiography, Magnetic particle, liquid penetrant, and visual inspection techniques)

Education:

Master’s degree in business administration

Bachelor’s degree in industrial engineering

Work Experience:

Company Name - Data For Biz Pvt Ltd August 2019 - to Present.

(IT consulting company)

Role: Power BI Developer

Responsibilities

Gathering requirements, document analysis, business process descriptions, use business case scenarios, business analysis, task, and workflow analysis.

Creating Workspace and Apps in Power BI service and giving access to end users to Apps. Install and configure Power BI Gateways to keep the dashboards and reports refresh automatically.

Configure Power BI Report Server for SSRS, deployed and scheduled reports in Report Manager.

Create Row level security (RLS) and integrate it with Power BI service (SaaS) portal. Configure and maintains Premium capacity planning, updating, troubleshooting, access management and performance management.

Configure Capacity settings to assign users as Capacity Admins per capacity during initial setup of the capacity and later via User Permissions within the Premium settings.

Configure Tenant settings to give control over the PBI features such as (workspace settings, Export and sharing settings, Publish to web, Developer settings).

Using Azure Data Factory Designed, coded, and implemented pipelines, activities, integration runtime, parameterized linked services and data sets, triggers, created dynamic data sources and dynamic parameters, debugging all issues and solved different ETL projects. Managed and maintained various Pipelines.

Designing and developing complex Power BI report and visualization solutions for business requirement

Develop different reports utilizing SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS)

Ashland Inc Wayne, NJ (IT consulting company) May 2017 - June 2019

Power BI /SSIS ETL Developer

Responsibilities

Involved in requirement gathering meetings and documented business requirements and detailed business rules

Connect to multiple data sources like sources such as Microsoft SQL Server, Azure SQL DB, MS Excel, and CSV and transformed data in Power Query using both a graphical interface and M Languages

Developed SQL queries/scripts to validate the data such as checking duplicates, null values, and truncated values and ensuring correct data aggregations.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

Scheduled jobs for executing the stored SSIS package which was developed to update the database daily using SQL Server Agent

Configured the report viewing security for various users at various levels using Report Manager

Designed and developed data warehouse, data marts, and business intelligence using multi-dimensional models

Created different visualization like Stacked bar Charts, Clustered bar Charts, Line charts, Aria Scatter charts, Pie charts, Donut charts, maps, slicers, and some custom visualization charts in Power BI according to the requirements.

Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

Store all source code in the Team Foundation Server (TFS) and update the development status in the TFS timely

Awards & Acknowledgements

Best project coordinator 2022 by Data for Biz Pvt Ltd

Beast team member 2021 by Data for Biz Pvt Ltd

Best employee in 2018 Ashland Inc Wayne, NJ

Contact this candidate