*

Elias Tesfa

[202-***-****]

addakc@r.postjobfree.com

www.linkedin.com/in/Elias-Tesfa-MD

Project Types

Experienced working on Agile Projects with Multiple Sprints cycles and Scrum meetings

Experienced using Agile Project management tools like Trello and JIRA

Hands on experience working on Waterfall Projects with full SDLC Database Design

Experienced in analysis, design and development of software applications in SQL Server.

Practical knowledge in ER Diagram and design of logical and physical data modeling using Erwin tool and Visio.

Experienced in designing de-normalized data warehouse including Star Schema, Snowflake Schema and data flow diagrams.

ETL

Working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation Data Loading (ETL) in SSIS and Talend Open Studio.

Experienced in using SQL Server Data Tool (SSDT) and business intelligence development studio (BIDs)

Extensive experience in configuring Data Flow source and destination connection strings

Experienced in implementing event driven Error handlings and package logs.

Experienced in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.

Hands on Experience on SSIS package deployment and scheduling. SQL

Experienced in creating and using Stored Procedure, Views, Triggers, schemas and Complex queries on SQL Server Management Studio.

Work experience on Common Table Expressions, Cursors, Functions, User-Defined Types and Dynamic SQL.

Visualization

Worked on creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SSRS, Power BI and Tableau

Hands on developing Page level Reports, Dashboards, and Stories Using Microsoft Power BI.

Extensive experience in implementing self-service reporting capabilities using SQL Server Analysis service and Report Builder.

Installation and Configuration

Work experience on installing and configuring MS SQL Server 2005\2008\2008- R2\2012\2014

Hands on experience in configuring SQL Server Reporting Service, Report manager and Report Server

Worked on Configuring MS SQL Integration Service Catalogs Performance Tuning

Experienced in Database Optimization using SQL Profiler, Database Tuning Advisor, and windows performance monitor.

Experienced in Partitioning Administration. Creating and Managing Partitioned Tables and 2

Indexes.

Interpersonal & Communication skills

Experienced to translate reporting and analytical needs into technical solutions.

Strong interpersonal & communication skills, Competitive analytical, logical, and problem- solving skills, Strong management, administrative and leadership skills to work in team. TECHNICAL EXPERIENCE:

Databases

MS-SQL Server 2014/2012/ 2008R2/, Microsoft office suites BI Tools /Reporting

Tools

SSRS, SSAS, SSIS, SSDT, Tableau, Power BI, Oracle data base modeler PROFESSIONAL EXPERIENCE:

Terathink, DC, DOJ – EOUSA & DoD Projects May 2019 – Present Position: Sr. SQL Developer

• Supporting Application back end via building stored procedures, views and function to intake data entry

• Supporting Application back end via creating new tables for new forms and requirement changes

• Creating stored procedures for reports and dashboard

• Identify and redesign database tables to fix normalization and constraint issues

• Create store procedures for web data insertion and updates

• Develop, implement and optimize stored procedures and functions using T-SQL

• Review and interpret ongoing backend SQL sources

• Analyze existing SQL queries for performance improvements

• Provided support by troubleshooting and solving bugs in web application reports

• Worked on enhanced security feature encryption in transit and encryption at rest

• Setting and configuring automation for database backup and recovery

• Prepare documentations for encryption and backup maintenance

• Create physical and logical data models and reverse engineering

• Working with Project manager in requirement gathering and technical discussions

• Power BI reporting support

Telnet, Inc. Rockville, MD November 2017-April 2019 Position: MS SQL Developer/BI Developer

Responsibilities

• Designed and Developed complex SSIS packages for performing ETL process using SQL Server Integration Services.

• Created complex Stored Procedures, Functions, Views, Indexes, SQL joins and Sub queries for applications.

• Worked using integration services for transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV, Oracle, MS Access).

• Worked on Data Mapping extensively.

• Responsible for Data Profiling to determine data integrity for transformation of Data from Source to Target.

• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.

3

• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS and Tableau.

• Used Bulk Insert to load large data into staging table.

• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.

• Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling and also tested the packages for Incremental Data Load & duplications.

• Developed various types of reports like Drill down, Drill through, tabular, matrix and parameterized reports using SQL Server Reporting Services 2008 and Power BI.

• Performed different queries in MS access, exported data to excel for data analysis

• Analyzed data and generated different kinds of graphs, charts using Excel. Fundation Group LLC, Reston, VA February 2014-October 2017 Database Developer

Responsibilities

• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.

• Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.

• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, BULK INSERT etc.

• Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.

• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

• Created SQL server Analysis Projects; created Multidimensional databases cubes, facts and dimensions for the analysis of products in specific areas using SSAS.

• Deployed analysis projects using SSAS based on data volume, as well as developed of KPI's which helped the Business users for easy understanding.

• Design and Developed multiple Enterprise reports using SSRS from both OLTP and OLAP databases

• Developed MDX expressions for cube calculations and KPIs.

• Executed different Ad-hoc reports using MS SQL SSRS.

• Documented and delivered Functional Specification Document to the project team by using SQL Server.

• Tested the reports and fixed bugs in the stored procedures. Involved in scheduling the reports and setting security for reports.

• Administered interface to organize reports and data sources, schedule report execution and delivery, and track report history using SSRS.

Environment: MS SQL Server, T-SQL

United Ventures Consortium INC., Washington, DC December 2011-January 2014 SQL Developer

4

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

• Used various SSIS tasks such as Conditional Split, Derived Column, lookup, etc for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

• Developed and deployed data transfers packages to the appropriate destinations using SSIS.

• Worked in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.

• Created SQL server configurations for SSIS packages.

• Responsible for creating reports based on the requirements using SSRS 2012.

• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services.

• Defined the report layout and identified Datasets for report generation.

• Created different type of reports including Crosstab, Drill through, Drill-down, Sub reports, and parameterized reports.

• Created numbers of complex formula in sub report.

• Designed and created Report templates, bar graphs and pie charts based on the financial data.

• Scheduled the monthly/weekly/daily reports to run automatically.

• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.

• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.

• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

• Created Packages to group logically related column types and to transfer data.

• Involved in designing logical and physical data models.

• Documented and delivered Functional Specification Document to the project team by using SQL Server.

• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).

Education:

-Bachelor’s degree

- Microsoft Certification in Database Administration.

Contact this candidate