WONDATO WUDNEH

WONDATO WUDNEH

ETL /Data warehouse Developer

Dallas, Texas, United States.

About  

My name is Wondato Wudneh I’m a certified Business Intelligence developer with intensive experience in Data warehousing, as a BI Professional I have gained significant amount of experience in SQL, SSIS, SSRS and SSAS version 2012 to 2019. I currently work for Colaberry Inc. which is a consulting firm as ETL Developer. I have had the opportunity to complete multiple projects which revolved around Data Analytics and Business Intelligence implementation Agile Methodology. I have experience in different domains including Finance and Mortgage

Hours Available / Wk - 40 hrs

Employment History 

  • ETL /Data Warehouse Developer

    Colaberry INC
    March 2016 - Present

    • Created complex SSIS packages with error handling, using various tasks and transformations like Sequence Containers, For Loop and Foreach Loop Container, Script, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
    • Transferred data from various OLTP data sources, such as MS Excel, Json files, XML, Flat files, CSV files into SQL Server.
    • Scheduled jobs and alerts using SQL Server Agent.
    • Worked on SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using checkpoints.
    • Created Relational and Multidimensional data models for data warehouse with strong knowledge in Star and Snowflake Schemas.
    • Troubleshoot T-SQL, SSIS package errors and performance issues and addressed them as required.
    • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
    • Configured SQL Mail agent to send automatic emails when a SSIS Process has failed or succeeded.
    • Used indexing strategies and SQL Query optimization techniques for performance tuning.
    • Optimized stored procedures and long running queries using indexing strategies and query-optimization techniques.