Summary
Overview
Work History
Education
Skills
Timeline
Generic

ELIAS KEBERET

Rockville,MD

Summary

Experienced in Database Design, ETL, Data Warehousing (DWH), and Reporting Development using MS SQL Server 2017 to 2012, SSRS and Power BI. Worked with all phases of Software Development Life Cycle (SDLC). Collaborated and worked with business users and development staff like business analysts, data architects, back-end solutions developers, testers, DBA and application developers to understand/determine requirements for on time delivering and with scalability. Worked extensively with T-SQL and building OLTP/OLAP databases at conceptual, logical and physical design levels, normalizing and de-normalizing database tables for efficient relationships operation and analytic through ER diagrams. Strong RDBMS concepts and experience in creating and maintaining database objects, views, stored procedures, triggers, functions, indexes, and constraints. Wide experience in building static, dynamic and interactive reports; dashboards and story, report templates and formatting using BIDS and Report Builder. Experienced in data cleansing, accuracy and completeness validation, analysis, and modeling relationship. Experienced with full development cycle of a DWH, including requirements gathering design, implementing, and maintenance. Experienced in ETL solutions that extract data from heterogeneous sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS. Proficient in creating dynamic SSIS packages. Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS. Developed, configured, deployed and monitored SSIS packages for development, testing and production with parameter and environment variables and scheduled job in SQL Server Agent. An excellent team player and technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project and diligence helping business on unleashing technological power for decision making. Flexible and versatile to adapt new environment, team player, flexible and work on any project.

Overview

6
6
years of professional experience

Work History

SQL/Dashboard Developer

Gainwell Technologies
Nashville, TN
02.2021 - 03.2022
  • · Involved in creating functional and technical specification documents (TKD).
  • · Involved in requirement gathering with client and various vendors.
  • · Perform SSRS and Power BI Dashboard data load in all environments.
  • · Perform data validation against Production Dashboard data for various vendors.
  • · Set up ETL Jobs using SSIS to run monthly in SQL Server Agent.
  • · Troubleshoot ETL errors for production data load.
  • · Designed and developed ETL to pull data from source such as flat files and load it to the destination database using multiple transformations
  • · Unit tested SSIS package natively and with a master package.
  • · Deployed SSIS package to the server.
  • · Deployed SSIS package to integration services catalog.
  • · Modified and enhanced existing SSRS reports.
  • · Worked with OLAP, Data Warehouse application, and star schema dimensions
  • · Developed T-SQL Queries and SQL Scripts for data migration/schema change.
  • · Extracted data from various sources like SQL Server and Excel file and perform extensive data analysis.
  • · Created and modified database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, triggers, and Indexes in T-SQL based upon the functional specifications
  • · Involved in data analysis and design session for KPI Reporting.
  • · Extract files using SFTP connection.
  • · Familiar with Qlik Replicate.
  • · Navigate Healthcare financial and claims data.
  • · Collaborating with other Developers.
  • · Hybrid Agile Methodology
  • · Designated on-boarding buddy for new employees.
  • · Exposed to Azure migration concept and processes.
  • Environment: MS SQL Server 2012, Microsoft Visual Studio 2010 and MS Excel.

MS SQL/ETL Developer

Vanderbilt Medical Center/NTT Data Service
Nashville, TN
09.2018 - 12.2020
  • · Involved in creating functional and technical specification documents after gathering requirements from business.
  • · Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications
  • · Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules
  • · Designed complex ETL strategies to pull data from different sources, like SQL server, and flat files and load it to the destination database after using multiple transformations
  • · Extensively worked on developing database objects like Stored Procedures, Views, Indexes, Triggers and Functions using T-SQL and performance tuning of SQL Queries
  • · Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports
  • · Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on Inputs, scheduling the SSIS packages using SQL Server Agent Services
  • · Worked with OLTP, OLAP, Data Warehouse application, star schema dimensions
  • · Extract dataset from different data source including SQL Server, excel and flat file and prepare datasets for Power BI
  • · Designed and Developed Reports using Report Builder to easily generate reports by the user
  • · Set up ETL Jobs using SSIS to run daily in SQL Server Agent
  • · Configuring SSIS packages using package configuration wizard to allow Packages run on different environments
  • · Created PL/SQL stored procedures, functions and packages for moving data from staging area to data mart
  • · Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
  • · Created SSRS Parameterized, Drill Down, Drill Through, Sub, Chart, Dashboard and Scheduled Reports, with expressions to Calculate, Group and Filter data.
  • · Generated multiple reports from SQL Server Database (OLTP) and multidimensional data model (OLAP)
  • Environment: MS SQL Server 2016/2014,2012,2008 Microsoft Visual Studio 2015,2010, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows Server 2008.

MS SQL/ETL Developer

Ford Credit
Franklin, TN
03.2016 - 08.2018
  • · Worked closely with SME's end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues
  • · Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements
  • · Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
  • · (used CTE, temporary tables, user defined table types)
  • · Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer
  • · Extracted data from heterogeneous sources and transformed, processed the data using SSIS.
  • · Scheduled jobs for SSIS packages to run monthly/weekly/daily feeds
  • · Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations
  • · Deployed various types of SSIS Transforms in packages including slowly changing dimension, aggregate, sequence container, conditional split, row count, derived column.
  • · Used TFS for source code management of developed codes/version control
  • · Migrated SSIS 2012 version to 2014 and used custom created DLL for transfer files using SFTP connection
  • Environment: SQL Server 2008/ R2/2012/2014, BIDS, Visual Studio 2010/2013, T-SQL, MS Access, MS- Excel, SSIS, and SSRS.

Education

Bachelor of Science - Computer Information System

Middle Tennessee State University
Murfreesboro, TN
12.2015

Skills

  • Tools and Technology

RDBMS: SQL Server 2008/2008R2/ 2012/2014/2016

Microsoft Visual Studio 2010

Database/ETL Tools: SSIS

  • Reporting:

SQL Server Reporting Services (SSRS), Report Builder,

Power BI

  • Languages:

T-SQL

  • MS-Office:

Microsoft Office Tools

  • Operating Systems:

Windows Server 2012/2016

  • Other

TKDPythonTool

Timeline

SQL/Dashboard Developer

Gainwell Technologies
02.2021 - 03.2022

MS SQL/ETL Developer

Vanderbilt Medical Center/NTT Data Service
09.2018 - 12.2020

MS SQL/ETL Developer

Ford Credit
03.2016 - 08.2018

Bachelor of Science - Computer Information System

Middle Tennessee State University

Similar Profiles

CREATE PROFILE
ELIAS KEBERET