ANDUALEM SHIMELS BULI

• 7+ years of experience in Database Design, Development, Implementation, and Tuning of Relational Database Systems using MS-SQL Server 2008R2/2012/2014/2016/2017/2019 • Experienced in managing SQL Server and writing T-SQL (DDL, DML and TCL) statements; and in creating and maintaining SQL Server database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors. • Experienced in optimization and performance tuning. • Skilled in using table variables and Common Table Expressions (CTEs). • Expertise in developing complex SQL queries and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Native tools. • Experience in Extraction, Transformation and Loading (ETL) tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), ETL package design, and RDBM systems. • Experienced in designing SSIS packages for different Data Flow and Control Flow processes. • Skilled in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, and Snowflake Schema. • Well experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. • Generated various Drill-Down Drill-Through reports, Parameterized reports, Tabular reports, and Matrix reports using SQL Server Reporting Services (SSRS). • Managing and securing reports using SSRS. Created report schedules. • Experienced in developing Business Intelligence (BI) solutions for Decision Support Systems using SSIS, SSRS, SSAS, and Power BI. • Expertise in Data Modeling using SSMS, Erwin. • Worked with stakeholders and end users to meet business requirements and experienced in the proper documentation of records. • Experienced in developing and maintaining data warehouse's functionality; and developed multi dimensional objects and Cubes using SQL Server Analysis Services (SSAS). • Experienced with working on Agile Projects with multiple Sprints Cycles and Scrum meetings, and on Water Fall projects with full Software (System) Development Life Cycle • Strong interpersonal and communication skills; competitive analytical, logical, and problem-solving skills; strong management, administrative and leadership skills; and active and self-learning abilities. • Detail oriented, working under pressure, and meeting short deadlines with exceptional problem solving and decision-making analytical skills and strong teamwork spirit.