Amanuel Zewdie
ETL/SQL Developer
Washington,DC
Summary
Highly skilled database professional with extensive experience in SQL Server database design, development, and optimization. Proficient in implementing ETL processes, designing business intelligence solutions, and improving data analysis and visualization. Adept at managing full project lifecycles using Agile and Waterfall methodologies, with a strong focus on enhancing database performance and efficiency.
Overview
8
8
years of professional experience
Work History
SQL/ETL Developer
Fifth Third Bank
03.2021 - Current
- Gathered and validated project requirements to ensure alignment with project specifications. Created and updated documentation for bug fixes and software enhancements as part of support duties.
- Created and updated documentation for bug fixes and software enhancements as part of support duties.
- Managed the complete SDLC process from analysis to implementation.
- Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
- Strengthened data verification procedures for both new and pre-existing SQL elements within the database.
- Optimized stored procedures to boost efficiency and performance.
- Enhanced database performance by managing and optimizing indexes.
- Created SSIS packages to import different file formats and databases into SQL Server data warehouse utilizing SSIS.
- Participated in ETL procedures for data extraction, transformation, and loading between source and target systems.
- Created multi-dimensional models (like star schemas and snowflake schema) to generate reports using SSRS.
- Contributed to the improvement of data quality control through seamless ETL processes.
- Developed data mapping and performance tuning strategies for identifying bottlenecks in sources, mappings, targets, and sessions.
- Oversaw large-scale transfer of data from OLTP to Data Warehouse and Data Mart utilizing ETL packages.
- Created and implemented distinctive MS SQL Server reports employing SSRS technology.
- Designed SSIS packages incorporating advanced features like complex transformations (derived column, conditional split, lookup, aggregation), user variables, property expressions alongside script tasks.
- Implemented SSIS packages with diverse tasks and transformations, performed Incremental Load through Lookup, and planned SSIS scheduling.
- Achieved efficient daily data updates for renamed items and eliminated orphan documents by creating and deploying SSIS packages.
- Generated SSRS reports for internal and external customers, facilitating business performance monitoring and informed decision making.
- Designed and implemented parameterized stored procedures to enhance functionality of SSRS reports.
- Managed database object changes using DMA reports and deployed on Azure DevOps during DB migrations.
- Scripted test cases in Development and QA, aligned with Business Requirements Documentation/Functional specifications.
- Optimized Azure performance by managing database resources and scaling.
Database Developer
American Family Insurance
04.2019 - 03.2021
- Collaborated with stakeholders to gather and document project requirements, translating them into functional and non-functional specifications for BI reports and applications.
- Defined and documented column and table meanings through data mapping techniques.
- Extracted data from multiple sources such as EHR, EMR, and pharmacies utilizing T-SQL and PL/SQL. Aligned extracted data with business needs through the implementation of stored procedures, UDFs, and views.
- Enhanced query performance through the analysis of execution plans and logs in SQL Server Profiler and Database Engine Tuning Advisor.
- Constructed ETL packages to facilitate full and incremental loading, data conversion and migration, as well as data transformation through merge joins, lookup operations, and derived column formulas.
- Designed ETL packages with breakpoints and utilized SQL commands in SSIS to analyze progress, capturing error information. Implemented functionality to send email notifications for errors, warnings, and task failures.
- Created customized reports for multiple stakeholders including claims, transactions, appointments, supply chains, assets and properties.
- Created tabular and matrix reports in SSRS with cascading parameters to enhance application security.
- Collaborated with QA team to address and resolve issues, delivering solutions for project manager approval and feedback.
- Improved SSRS report performance through implementation of snapshots, indexes, and optimized query statements.
- Refined queries in T-SQL and eliminated redundancies, resulting in optimized report performance.
Database Developer
Premier Inc.
05.2016 - 03.2019
- Contributed to requirements gathering and played a key role in logical and physical data modeling.
- Developed complex SQL queries to enhance database performance.
- Troubleshot and resolved production ETL problems.
- Efficiently transferred SSIS packages between environments.
- Enhanced performance by optimizing stored procedures, views, T-SQL, and functions.
- Enhanced and automated routine SQL procedures while monitoring problems and recording modifications.
- Automated extraction and loading of data from diverse sources (e.g., flat files, MS Excel, CSV, and MS Access) into SQL Server using SSIS packages.
- Designed and implemented advanced database components, including stored procedures and UDFs.
- Developed database objects, such as tables, views, indexes, and triggers in MS SQL Server, to facilitate relational and dimensional database models.
Education
Computer Science -
George Mason University
Fairfax, VA07.2014
Skills
Relational Database Management System
- SQL Server
- Data Modeling
- Azure SQL Database
- Oracle
Languages/Tools
- TSQL
- SSDT (SQL Server Data Tools)
- C#
- Powershell
- Tableau
Modeling Tools
- MS Visio
- SQL Server Data Modeler
Export,Transfer, and Load Tools
- SSIS (SQL Server Integration Services)
- Azure Data Factory
Reporting Tools
- Power BI
- SSRS (SQL Server Reporting Services)
Analysis Tools
- SQL Server Analysis Services (Tubular and Multi-Dimensional)
Other Skills/Tools
- GitHub
- JIRA
- SSO
- Agile & Waterfall Methodologies
- Performance Tuning
Timeline
SQL/ETL Developer
Fifth Third Bank
03.2021 - Current
Database Developer
American Family Insurance
04.2019 - 03.2021
Database Developer
Premier Inc.
05.2016 - 03.2019
Computer Science -
George Mason University