Summary
Overview
Work History
Education
Skills
Timeline
Generic

Tesfahun Tizale

Silver Spring,MD

Summary

Dynamic IT professional with over 7+ years of extensive experience in Database Design, Development, and Implementation of SQL Server, specializing in ETL/Business Intelligence applications leveraging Microsoft components. Proven expertise spans the full Software Development Life Cycle, from Analysis and Design to Testing, Implementation, and Maintenance of projects. Proactive ETL developer with 7+ years of experience carefully handling and transforming data loads to suit customer needs. Versed in all dominant information modeling designs and mapping technologies. Dedicated to flawless ETL integrity and impeccable data security during all database maintenance and modification tasks. Highly motivated employee with a desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills. Adept at crafting T-SQL Queries, including dynamic queries, sub-queries, and complex joins, to develop Stored Procedures, Triggers, Functions, Views, and Cursors. Extensive experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems, creating optimized Database Objects like tables, Constraints, and Indexes.

Overview

7
7
years of professional experience

Work History

MS SQL Database/ETL Developer

Wells Fargo
Remote, US
02.2021 - Current
  • Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
  • Analyzed large volumes of data to determine trends and patterns that can be used to improve business processes.
  • Resolved complex issues related to the ETL process through debugging existing code or writing new programs.
  • Performed unit testing of all the mappings developed in the ETL layer before delivering them to the production environment.
  • Applied conceptual, logical, physical, and dimensional/relational model designs to ETL tasks.
  • Worked closely with business analysts, system analysts, and data architects to gather requirements for developing ETL solutions.
  • Involved in creating database objects such as tables, views, and indexes based on business requirements.
  • Designed and developed stored procedures, functions, views, and triggers using T-SQL for efficient data transformation.
  • Performed troubleshooting of existing production jobs when needed.
  • Provided technical support to other team members regarding ETL development activities.
  • Optimized queries by analyzing query plans using the SQL Profiler tool.
  • Assisted BI developers in building cubes utilizing extracted and transformed data from the data warehouse.
  • Implemented best practices while developing ETL packages, like error handling and logging.
  • Created SQL Server Integration Services packages for incremental and full loads of data from various sources.
  • Monitored the performance of the ETL processes by creating log files with SSIS logging features.
  • Developed scripts for automating daily jobs like backups and reindexing.
  • Maintained source system metadata information in order to ensure the accuracy of the ETL process.
  • Configured SSIS package variables, parameters, and expressions for dynamic package execution.
  • Planned and installed database management system software upgrades to enhance systemic performance.

SQL/SSIS Developer

American Family Insurance
Remote, US
05.2017 - 01.2021
  • Designed and developed a custom logging framework using Event Handlers and Log Providers within SSIS packages to log progress of package execution.
  • Debugged errors were encountered during the development or testing phases of ETL processes.
  • Performed troubleshooting activities related to failed jobs or other issues occurring due to external factors like network outages.
  • Monitored the performance of all jobs running through scheduled jobs in the production environment regularly.
  • Deployed SSIS packages from the development environment to the QA, UAT, and production environments successfully.
  • Collaborated with database administrators to design database objects, including tables, views, stored procedures, and user-defined functions required for the ETL process.
  • Implemented Slowly Changing Dimensions in SSIS Packages to capture changes in the source data over time.
  • Involved in developing reports using SQL Server Reporting Services based on the requirements gathered from stakeholders.
  • Developed ETL packages for data loading from various sources, such as flat files, XML files, and Oracle databases, into the Data Warehouse using SSIS.
  • Configured error handling for all SSIS packages by establishing connection managers, event handlers, and logging to track package execution status.
  • Coordinated with business users and the project manager throughout the software development life cycle.
  • Tested ETL processes thoroughly prior to deployment in the production environment by writing test plans and executing unit tests.
  • Maintained version control system for all versions of ETL code deployed in different environments.
  • Generated automated reports that monitored the successful completion of ETL processes on a daily basis.
  • Created complex SSIS packages with multiple transformations such as derived columns, lookups, conditional splits, script tasks, and execute SQL tasks.
  • Optimized existing SSIS packages by performing performance tuning activities like reducing redundant operations and replacing Lookup and Merge Join with Hash Match.
  • Tested databases and performed bug fixes.
  • Wrote SQL queries using programs such as T-SQL and PL/SQL.
  • Designed and created database systems after reviewing end user's requirements.
  • Analyzed workflows and established priorities for daily operations.
  • Developed data security and disaster recovery procedures.

Education

Bachelor of Science - Cybersecurity And Information Technology

University of Maryland - College Park
College Park, MD

Skills

  • Database Design
  • Data Validation
  • Scripting Languages
  • Data Mapping
  • Data Migration
  • Data Modeling
  • Data Warehousing
  • Python Programming
  • RDMS Design
  • Teamwork and Collaboration
  • Problem-Solving
  • Adaptability and Flexibility
  • Time Management Abilities
  • SQL and Databases
  • Load Balancing
  • Team Collaboration
  • Relational Databases
  • Performance Improvements
  • SQL Reporting
  • Big Data Technologies

Timeline

MS SQL Database/ETL Developer

Wells Fargo
02.2021 - Current

SQL/SSIS Developer

American Family Insurance
05.2017 - 01.2021

Bachelor of Science - Cybersecurity And Information Technology

University of Maryland - College Park

Similar Profiles

  • PATRICIA M. SCHERER

    PATRICIA M. SCHERERPATRICIA M. SCHERER

    Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors

  • Andrew S. Hollenbach

    Andrew S. HollenbachAndrew S. Hollenbach

    Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA

  • Laxmikanth Chittampally

    Laxmikanth ChittampallyLaxmikanth Chittampally

    Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo

  • Mayank Oberoi

    Mayank OberoiMayank Oberoi

    Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)

  • Yesenia Cedillos

    Yesenia CedillosYesenia Cedillos

    Cook at The Seneca of RockvilleCook at The Seneca of Rockville

CREATE PROFILE
Tesfahun Tizale