Etl Developer Sql

Kelemwork Josef

Phone: 651-***-****: MN,

SUMMARY OF EXPERIENCE

Vast experience in IT specifically as Power BI, SQL developer, SSRS report developer, Tableau developer and on ETL process for about six years.

Developed various visualizations, slicers and tabular reports, and functional dashboards based on business requirements on SSRS, POWER BI Desktop and Microsoft Excel.

Used SSIS to import data from data warehouse and convert data into useable format to perform further advanced queries.

Using SQL Server Integration Service extract and transfer data into pre-stage database table and share to concerned department.

Worked on advanced T-SQL statements and implemented various codes and functions.

Experienced in working on temporary tables including Common Table Expression, Table Variable

Experienced in create project and deploy packages, data migration (ETL) from different sources for building of data warehouse and database migration using SSIS.

Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.

Well versed with Excel macros, functions, VLOOKUP, and pivot and used this for data cleansing and validation

Experience in RStudio statistical packages, data wrangling and building various visualization.

POWER BI DEVELOPER

08/2018– present SkyLight

Developed, maintained, and managing advanced reporting, analytics, dashboards, and BI solutions.

Developed advanced Power BI dashboards with quick/context/global filters, parameters, and calculated fields per KPI.

Optimizing modeling and data visualization to meet business standard using performance

analyzer, DAX studio, Dashboard, Power BI helper and other techniques

Experienced on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Powerbase, and DAX

Developed python scripts to pull date from various sources to big query.

Developed sets, groups, parameters, views, and data blending to analyze data.

Developed visualization of various reports per business requirements on and MS Excel.

Responsible to ensure the accuracy of the information that is being provided by carefully and continually scrutinizing the data to ensure the right information is portrayed in the reports being delivered

Experienced on accessing data from different data sources like SQL database, Analysis Service, Flat files to bring data for further analysis on Power BI/Tableau desktop and Tableau Prep.

Also used advanced T-SQL statements, and implemented different joins, aggregations, and prepared data for further manipulation.

Excel functions, VLOOKUP, and pivot for data cleansing and validation

SQL DEVELOPER

11/2017– 07/2018-Life Solution

Design and create database, table, various TSQL queries including store procedure, user defined functions, subqueries, join, pivot, running, merging, and developed power BI reports.

Developed power BI dashboard and reports.

Worked on Power BI to build model, manage relationship, implement visualization and slicers based on the standard and business requirement

Using SQL Server Integration Service extract and transfer data into pre-stage database table and share to concerned department.

Update master database table to keep records and further reference.

Perform analysis of original data against detail report and prepare summary report

Experienced in working on temporary tables including Common Expression Table, Table Variable

Write and debug T-SQL Queries, DMLs, DDLs, Stored Procedures, views, functions, indexes, and others

Working with development team on review requirement analysis, design and architecture and give feedback

Documentation, data analysis, data validation, and data mapping/design

SQL/ETL DEVELOPER

08/2014 – 09/2017- Ethio Telecom

Developed various visualizations, slicers and tabular report, and functional dashboards based on business requirements on SSRS and Microsoft Excel.

Used SSIS to import data from data warehouse and convert data into useable format to perform further advanced queries.

Managing data through extract, transfer, and load of from one source into another for the purpose of building data model and data warehouse.

Experience in building of tabular models that are compatible with warehouse standards and deploy package on SQL Server Integration Service catalog.

Perform analytical tasks on integration service including create measures, calculated columns, hierarchy, define relationship, define role and perspectives

Design and write various TSQL queries including store procedure, subqueries, join, merging and others.

Participated in a project to design, developed, and implement data warehouse.

Experienced in working on temporary tables including Common Expression Table, Table Variable

EDUCATION

Bachelor's in Information Technology - Addis Ababa University – August 2012

BSC, Date Science - Metropolitan State University -May 2022

CERTFICATIONS

Empire Data Systems Certificate: SQL server DBA/TSQL Training (90 hours), USA.

Udemy Certificate: SQL Server Reporting Services Part 1 (SSRS)

Udemy Certificate: Tableau 20 Advanced Training: Master Tableau in Data Science (10 hours)

Udemy Certificate: Tableau 2019&Tableau 2018: Tableau CA certification 2020. (13hours)

Udemy Certificate: Microsoft Excel from Beginner to Advanced (17.5 total hours)

Udemy Certificate: Power BI Masterclass/Advanced (9 total hours)

EXPERTISE AREA

SQL Server

MS SQL Server 2016/2014/2012/2008R2/2008

Analysis

Tableau Desktop & Prep,TSQL SQL Server Integration Services (SSIS), SSRS Visual Studio (SQL Server Data Tools), RStudio, SAP Lumira, Predictive Analytics,

Data

OLTP, OLAP (Data Warehouse)

Languages

T-SQL, Python, XML, HTML, JSON

Development Environment

Visual Studio.Net 2013/12/10/08/05

Data Modeling Tools

SQL Developer Data Modeler, ER studio, Erwin, Microsoft Visio

Microsoft Office Tools

Excel, Word, Outlook, Visio, Power Point, Publication

Contact this candidate