Elshadai K

About Elshadai K

Over 7 years of experience in ETL development, reporting solution development, business intelligence solutions and enterprise data warehouses development involving multiple industries • Expert Knowledge in building and managing relational databases and tables normalization/denormalization using SQL Server Management Studio (SSMS)• Expert with producing highly efficient and project-oriented T-SQL query statements• Goal-oriented usage of features such as Dynamic SQLs, Cursors, Views, Stored Procedures, User-Defined Functions (UDFs), Triggers, Indexes, Temp Table in SSMS to provide convenience for front-end applications or reporting purposes• Proficient in tuning performance of query statements using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor • Profoundly experience in feature design and flexible usage of tabular charts, donut charts, histograms, and maps to express business solutions comprehensively using visualization tools including Tableau, PowerBI, MS SQL Server Reporting Service (SSRS) and Excel• Excellent knowledge of MS SQL Server Integration Service (SSIS) to perform ETL solutions for Data Migration, Data Conversion, Data Validation, Data Management, Reporting and supporting other analysis • Profound understanding of Enterprise Data Warehouses and Data Marts including OLTP/OLAP, Dimension/Fact Tables, Top-down/Bottom-up models, Star/Snowflake Schemas using Landing and Staging stages• Strong Skills in using SSIS Control Flow (Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.)• Substantial experience in usage of Event Handlers, Loggings, Checkpoints, Breakpoints and Debugging in SSIS• Proficient in using skills like Slow Changing (Type 0/1/2/3) and Change Data Capture to load and transform data dynamically • Highly skilled with Agile/Scrum/Waterfall working methodologies along with phases of Software Development Lifecycle (SDLC)• Effective problem solver with thorough analytics added to credible and concise presentations

Experience

1. Etl Developer

   First Republic

   Jul 2020 — Present

Education

• Addis Ababa University

  Bachelor's degree

  2004 — 2008