Esayas Tesfai

Over 5 year of IT Experience in Database Design and Bi development on MS SQL Server 2014, 2012,2008 versions on various development, test and production environments with various business domains. *Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS). *Proficient in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes Created various Complex Formula Reports to query the database for business Intelligence. *Strong DBA/Development skills writing T-SQL scripts, worked extensively on ETL process using DTS, SSIS packages, handling data quality issues and generating various types of reports using SSRS on OLAP databases. *Demonstrated expertise in MS SQL Server 2012/2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts. *Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan. *Evaluates and refine Business Intelligence goals, business objectives, decision support needs, data and performance requirements to meet departmental/project level objectives. *Provides design support for the development of business intelligence solutions. *Works on multiple tasks/projects as team member. *Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems. *Proficient in the use of query and reporting analysis tools. *Standardize data collection by developing methods for database design and validation reports. *Evaluates and validate quality of performance on completeness of Business Intelligence models and solutions. *Strong understanding of application systems, and business intelligence methods and the ability to quickly learn new software solutions. *Experience in deploying created reports in various sources like Web browser, XML and PDF. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. *Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.