Summary
Overview
Work History
Education
Skills
Timeline
Generic

Yoseph Alemu

Woodstock,GA

Summary

More than 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 performing 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 gain experience 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.

Overview

7
7
years of professional experience

Work History

SQL/ETL Developer

Bank of the West
05.2022 - Current
  • Involved in all the phases of the project, including requirement gathering, analysis, design, development, validation, and deployment.
  • Designed and normalized the database and created different objects like Tables, Views, Stored Procedures, UDFs, Indexes, Rules, and defaults on MS SQL Server.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Adhered to best practices in creating a complete schema, including tables, relationships, stored procedures, views, clustered, non-clustered indexes, and import of data using SSIS packages.
  • Created documentation on the tables, stored procedures, views, and user-defined functions, and hands-on exposure on Normalization & De-normalization of databases.
  • Performed Data Analysis and Data Profiling using SSIS Data Profiling Task, SQL Queries, and Excel on a large volume of data.
  • Worked on updating a slowly running stored procedure with Query optimization techniques.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics, and Re-indexing.
  • Conducted research with team members to develop a high-level design, an impact analysis document outlining several solutions to the problem during implementation, and proposed a new system.
  • Developed several SSIS packages to import Flat files and CSV into data tables. These packages were scheduled in a regular time interval.
  • Applied various data transformations like Lookup, Sort, Multi-Casting, Conditional Split, Derived column, etcetera.
  • Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, and Script Task to achieve the business requirement in the control flow.
  • Built master and child packages, using Execute Package Task in SSIS control flow.
  • Designed and developed ETL packages using SQL Server Integration Services (SSIS) 2012 to load the data from different source systems (SQL Server, Oracle, flat files, CSV files).
  • Configured SQL mail agent for sending automatic emails when an SSIS package fails or succeeds.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code, as well as T-SQL code from developer and QA environments.
  • Scripted SQL Server Agent jobs to schedule the execution of SSIS ETL packages and cube processing packages.
  • Developed different kinds of reports per the requirement using SSRS reporting functionality.
  • Reviewed, analyzed, and implemented necessary changes in appropriate areas to enhance and improve existing systems.
  • Designed, developed, and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting to different data sources and databases.
  • As a Power BI and Tableau SME responsible for the design, development, and production support of interactive data visualizations used across the company.
  • Technical Environment: SQL Server Management Studio, Confidential Visual Studio, MS BIDS, SQL Server 2012 Data Tools, SSRS, SSIS, SSAS, MS Excel, MS SQL Server Integration Services SSIS, Team Foundation Server, SQL Profiler, Windows 2012 Advanced Server, Oracle

SQL/ETL Developer

Bank of Texas
08.2018 - 05.2023
  • Developed Stored Procedures and Functions used for inserting, updating, or transforming data. Also, created scripts for tuning and scheduling.
  • Created new tables and wrote stored procedures, triggers for Application Developers, and some user-defined functions. Created SQL scripts for tuning and scheduling.
  • Creating table indexes and constraints to ensure data integrity and enhance query processing, and come up with efficient data retrieval.
  • Extensively involved in creating SSIS packages to migrate data from different data sources to the data warehouse.
  • Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements, including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, and Snowflake Schemas.
  • Created SSRS Summary Reports, Sub Reports, and Drill-down Reports (on demand and periodic) by using Expressions.
  • Importing Source/Target tables from the respective databases by using Execute Package Task using Control Flow Tasks in SSIS.
  • Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Email Task, and Data Flow Tasks.
  • Involved in enhancing and deploying the SSIS Packages from the development server to the production server.
  • Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in the Data warehouse.
  • Scheduled the ETL Package, Email, and Stored Procedures.
  • Developed different reports and visualization solutions for internal and external reporting purposes.
  • Environment: MS SQL Server, MS Visual Studio (SSIS/SSRS), Power BI, Microsoft Excel, Outlook, MS SQL Profiler, Windows Server.

Education

Bachelor’s degree - Engineering

Addis Ababa University
Addis Ababa, Ethiopia
07.2013

Skills

  • MS-SQL Server
  • SQL Server Data Tools (SSDT)
  • SQL Server Integration Services (SSIS)
  • Data Transformation Services (DTS)
  • T-SQL
  • SQL Server Reporting Services (SSRS)
  • Power BI
  • PL/SQL
  • Microsoft SQL Server Management Studio
  • Visual Studio
  • Windows Server
  • MS Office
  • Outlook
  • Visio

Timeline

SQL/ETL Developer

Bank of the West
05.2022 - Current

SQL/ETL Developer

Bank of Texas
08.2018 - 05.2023

Bachelor’s degree - Engineering

Addis Ababa University

Similar Profiles

CREATE PROFILE
Yoseph Alemu