Summary
Overview
Work History
Education
Skills
Timeline
Generic

Kidus Tesfaye

Silver Spring,MD

Summary

Experienced professional with 7+ years in reporting solution development, ETL, and business intelligence across diverse industries. Proven expertise in tuning query performance, managing relational databases, and crafting efficient T-SQL statements. Adept in enterprise data warehouse development, utilizing tools like Execution Plan, SQL Profiler, and Database Engine Tuning Advisor. Skilled in implementing normalization/denormalization methodologies in SQL Server Management Studio (SSMS). Goal-oriented with proficiency in Dynamic SQLs, Cursors, Views, Stored Procedures, UDFs, Triggers, Indexes, and Temp Tables for front-end applications. Expert in MS SQL Server Integration Services (SSIS) for Data Migration, Conversion, Validation, and Reporting, showcasing strong SSIS Control Flow and Data Flow skills.

Overview

7
7
years of professional experience

Work History

Data Engineer (SQL/SSIS Developer)

MGM Resorts International
10.2021 - Current
  • Gathered and documented project requirements from stakeholders and translated them into functional and non-functional specifications for BI reports and applications and transformed them into deliverable solutions
  • Participated in data mapping process, figuring out and documenting meanings of columns and tables as well as relationships among them
  • Responsible for extracting data from internal and external resources using T-SQL and PL/SQL based on business requirements such as Stored Procedures, User Defined Functions (UDFs) and Views
  • Tuned the performance of query statements by analyzing execution plans and logs/statistics in SQL Server Profiler/Database Engine Tuning Advisor
  • Designed and developed ETL packages to realize full loading and incremental loading to convert and migrate data, transform data using lookup, merge joins, derived columns, and built the target data warehouse and data marts based on Star Schema
  • Involved in designing ETL packages using breakpoints and analyzing progress to catch error information by SQL command in SSIS that sends an e-mail message when an error or a warning occurs or when a task fails
  • Developed reporting solutions for different stakeholders from mock-up demos till deployment to analyze different dimensions as claims, transactions, appointments, supply, assets, and properties both in SSRS and Tableau
  • Developed reporting solutions including tabular reports, matrix reports, using cascading parameters to achieve Drill-down Reports, Drill-through Reports, as well as Linked Reports for security concerns in SSRS for the front-end application usage
  • Worked with QA team, clarified and solved the issues, delivered to the project manager for approval and feedback
  • Optimized SSRS report performance by snapshots and indexes while writing query statements
  • Optimized report performance by refining queries in T-SQL, removing redundancies, retrieving only essential data and using SQL methods efficiently.

Database Developer

Petco
01.2020 - 09.2021
  • Gathered, analyzed, classified and documented project requirements from BI analysts and directors and completed data mapping process, related to claim history, property value, three financial sheets, and etc
  • Used T-SQL to create databases objects based on business specifications such as stored procedures, user-defined functions, views in SSMS
  • Involved in building Data Warehouse based on Star Schema and Data Marts
  • Developed ETL packages in SSIS to import data on a weekly basis from the OLTP system to the landing zone in the staging area and migrate it to Date Warehouse and data marts
  • Performed incremental loading task to migrate the data from heterogeneous sources to Data Warehouses and Data Marts as well as implementing the slowing changing dimension to protect or discard historical data based on requirements
  • Cleaned and validated the data in the staging area, corrected and unified the format, handled the missing values, transformed the data and split or combined columns based on specifications
  • Created multiple control flows based on specifications including data flow task for data migration or conversion, Script Task for dealing with variables, Foreach Loop Containers for realizing loop functions, File task for creating weekly records
  • Applied different types of transformations like Data Conversion, Lookup, Conditional Split, Derived Columns, Merge in SSIS
  • Troubleshooting and corrects production ETL issues
  • Optimizing stored procedures, T-SQL, views, and functions for the best performance
  • Refining and automates regular SQL processes, track issues, and document changes
  • Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server
  • Debugged the packages and identified error information and stored it by using breakpoints, analyzing processes, error output in SSIS as well as sending an error email message while a task fails
  • Worked with test team to operate unit testing on completed packages and Production Control Team to schedule the operation of the entire package
  • Used pages, cascading parameters, expressions and other features to create drill-down reports, drill-through reports, nested reports as operational reports in SSRS
  • Interacted with the Data Science team, developed risk management reports using Tableau for advanced visualizations.

Business Intelligence Developer

SunTrust Bank
12.2016 - 12.2019
  • Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL work flows to populate fact and dimension tables, and developed Cubes and reports for analysis
  • Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor
  • Troubleshooting and corrects production ETL issues
  • Optimizing stored procedures, T-SQL, views, and functions for the best performance
  • Refining and automates regular SQL processes, track issues, and document changes
  • Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server
  • Developed complex database objects like complex stored procedures and complex UDFs
  • Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models
  • Developed script for data manipulation and ensuring data integrity
  • Designed, developed and maintained a data warehouse
  • Creating Tabular reports with SQL Server Reporting Services (SSRS)
  • Generating parameterized reports, drill down drill through reports
  • Deployed reports, created report schedules and subscriptions
  • Managing and securing reports using SSRS.

Education

Skills

  • Languages: T-SQL, PL/SQL, xml, C#
  • Databases: MSSQL Server, MS Access, MYSQL, Oracle, DB2
  • ETL Tools: SSIS, DTS, SSDT, Data Quality Services, Talend, Informatica
  • Analysis/Reporting tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)Power BI
  • Data Warehouse/OLAP: SSAS, Power BI
  • Development Platforms: Visual Studio, JIRA, Slack, TFS
  • Database tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer

Timeline

Data Engineer (SQL/SSIS Developer)

MGM Resorts International
10.2021 - Current

Database Developer

Petco
01.2020 - 09.2021

Business Intelligence Developer

SunTrust Bank
12.2016 - 12.2019

Similar Profiles

CREATE PROFILE
Kidus Tesfaye