Selamawit Abdu

Olney, MD *****

adznx5@r.postjobfree.com

+1-301-***-****

www.linkedin.com/in/selam-abdu

Have 8+ years of working experience in Microsoft SQL Server suite of products like SSIS, SSAS, SSRS and T-SQL of MS SQL server.

Expert in new cloud technologies like Snowflake, Azure, Informatica Intelligent Cloud Services (IICS), Informatica Cloud Real Time (ICRT) and MuleSoft.

Good knowledge on Talend, which enables Extraction, Transformation and Loading of data to and from different sources like Excel, Flat File, Databases (Oracle and MS SQL Server) and Cloud Platforms like Snowflake and Google Cloud Platform Big Query.

Applied different models like Kimball to create an architecture and implement data warehouse structure using different tools like SQL and SSIS.

Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.

Expert in creating Visualization and reports using Tableau software and Creating Listing reports using Cognos.

Expert in Testing ETL and Reporting Solutions.

Experience in migration of Data from one SQL Server Database to another SQL Server Database using import export function and experience in developing, deploying packages, and extracting data using SSIS of MS SQL from OLTP to OLAP.

A quick learner, skilled and experienced using several programming languages, good time management, effective interpersonal communication, and efficient problem resolution.

Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.

Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Mastery in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.

Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Working with large databases, troubleshooting issues, and documenting the causes, on PostgreSQL database administration, include configuring Scheduled Tasks, Jobs for regular Database Backup and Maintenance Activities.

Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.

Created ETL pipeline to get data from AWS data lake based on business requirement and bring the data into redshift for creating reports.

Work Experience

Business Intelligence Engineer

Amazon.com - Maryland

August 2022 to April 2023

Amazon, or Amazon.com, is an online retail website considered the largest online retailer in the world. The company started off selling books and soon moved to movies. Eventually the catalog grew exponentially until the final product today, which sells just about any item a person could possibly want to buy. There are retail websites for Amazon in the United States, Germany, Canada, France, the United Kingdom, Italy, and many other countries. Despite the wide-spread nature of the business, the company headquarters is in the state of Washington.

Responsibilities

Design automated BI solutions for recurrent reporting (daily/weekly/monthly).

Design data pipelines and automated processes which enable in-depth analysis.

Design automated data validation and testing processes.

Created ETL pipeline to get data from AWS data lake based on business requirement and bring the data into redshift for creating reports.

Publish, analyze, and improve dashboards, operational business metrics decks and key performance indicators.

Creating multiple solutions using different queries like MS SQL and PostgreSQL, identifying, and troubleshooting performances.

Use Different AWS tools to create visualization and reports to business partners.

Create and monitor recurring jobs using AWS tools like Datanet, S3, QuickSight and Redshift that support operational functionalities.

Created ETL pipeline in Datanet to manipulate and transform data into the form that is required and store the data into redshift databases.

Created ETL processes in Datanet to move data between redshift databases and S3 buckets.

Created multiple reports using QuickSight Dashboard so that the business can analyze and make informed decisions.

Performed root cause analysis on failures, Resolved performance tuning related issues and PostgreSQL queries.

Document all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.

ETL Software Engineer

Adtalem Global Education - Remote

August 2021 to July 2022

Adtalem is a leading workforce solutions provider that partners with organizations to proactively address future workforce needs and empowers career development with access to world-class academic curriculums, certifications, and training programs across the medical and healthcare. Also, Adtalem provides global access to knowledge that transforms lives and enables careers.

Responsibilities

Developed projects to move data from various sources to different destinations and allowed business partners to gain clarity by performing Extractions, Transformations, and Loadings of critical data to and from various sources like Excel, Flat Files, Databases (Oracle and MS SQL Server), and Cloud Platforms like Snowflake and Google Cloud Platform BigQuery.

Created a design and layout for a new data warehouse and worked on creating the architecture of the dimension and fact tables.

Created data analysis, business intelligence data sources, and reporting solutions that meet the needs of various types of information users.

Used advanced features of T-SQL to design and tune T-SQL to interface the database and other applications in most efficient manner.

Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on a schedule.

Gathered and examined BI user requirements and evaluated their technical feasibility.

Participated in the architecture and design of multiple projects and oversaw the process manual test cases using a variety of testing techniques and using PostgreSQL.

Uses data analysis skills and the ability to track a data element from source to transformation to target.

Implements data models optimizing the data-mining performance function.

Implements Extract Transform Load (ETL) solutions using BI best practices and methodologies; identifies root causes of issues with data quality and other related issues.

Creating multiple solutions using different queries in PostgreSQL, identifying, and troubleshooting performances.

Assist a reporting team optimizing the ETL process to ensure that business requirements are met.

Provide on-call production support on a rotating basis to ensure the timely and successful delivery of ETL data and reports.

Created databases and schema objects including tables, indexes, stored procedures, and functions as a part of the data migration initiative.

Built SSIS packages and scheduled jobs to migrate data from Legacy source Onyx to cloud based Salesforce using different tools like MS SQL, SSIS and DBAmp.

Created Stored Procedures, user-defined functions, views for handling business logic and functionality such as Email Alerts, Data Extracts built-in Excel.

Created visualizations using QuickSight that tells story for non-technical users that would make them understand the data.

ETL Software Engineer

Laureate Education Inc - Columbia, MD

October 2016 to August 2021

Laureate is a network of nearly 70 campus-based and online universities in 25 countries including Walden University, that offers certificate, undergraduate, graduate, and doctoral degree programs to over one million students worldwide. It is the largest global network of degree-granting higher education institutions, and the students are part of a diverse, international community. As Business Intelligence (BI) ETL Software Engineer I am a member of the data warehousing and reporting team. I support delivery of business intelligence solutions including data models, cubes, dashboards, and visualizations, along with designing, executing, and debugging manual test plans to ensure business requirements are met. I collaborate with business users to set requirements for reporting solutions which will meet business needs.

Responsibilities

Developed and tested multiple solutions in new cloud technologies like Snowflake, Azure, Informatica Intelligent Cloud Services (IICS), Informatica Cloud Real Time (ICRT) and MuleSoft.

Worked on projects in moving data from different sources to different targets, and enabling business partners get clear insight by performing Extraction, Transformation and Loading of key data to and from different sources like Excel, Flat File, Databases (Oracle and MS SQL Server) and Cloud Platforms like Snowflake and Google Cloud Platform BigQuery.

Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes, and views for the application.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.

Used advanced features of T-SQL to design and tune T-SQL to interface the database and other applications in most efficient manner.

Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on a schedule.

Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective.

Participate in the architecture, design, implementation, execution, and debug manual test cases using a variety of testing techniques.

Create test cases based on requirements.

Implements Extract Transform Load (ETL) solutions using BI best practices and methodologies; identifies root causes of issues with data quality and other related issues.

Supports the development of new software or enhances existing software and integrates into new or modified systems and/or operational environments.

Involved in designing, developing, and testing solutions that involve fetching data from an online source using OData, Rest API calls and Informatica Cloud Services.

Created and maintained multiple tables, warehouses, databases, and connections in the cloud database called Snowflake and Google Cloud Platform Big Query.

Created different kinds of visualizations by using tableau dashboard that would be beneficial for business making decisions.

Created multiple list reports using Cognos 10 and 11 so that the business can analyze and make informed decisions.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

Database ETL Developer

NeEd Trading PLC - Addis Ababa, ET

July 2012 to September 2015

NeEd Trading is a leading business service company that helps organizations control costs, save time, optimize their workforce, grow revenue, and minimize financial risk offering a comprehensive range of human resources, benefits, and payment solutions.

Responsibilities

Monitored the performance of the database and checked the execution time. Developed various SQL servers and ensured that they were properly maintained and supported.

Installing and configuring the necessary components to ensure that the database is accessible. Ensured that the existing data warehouses, reporting systems and various tools were adequately supported.

Researched on various database products and recommended the best ones. Experienced in critical problem solving, building tools to integrate and manage large sets of data.

Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS. Implemented failure alerts using email in SSIS. Used Snapshot Replication to synchronize the data between different Databases.

Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008/2012.

Generated daily, weekly, and monthly reports for the managers.

Maintain data quality by using the SCD and loading it into target database. Used sub reports functionality for complex report calculations.

Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.

Working with large databases, troubleshooting issues, and documenting the causes, on MS SQL Server database administration, include configuring Scheduled Tasks, Jobs for regular Database Backup and Maintenance Activities.

Create SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and stored procedure.

Expert in building Data Integration, Workflow solutions, and ETL solutions for data warehouse using SQL Server Integration Services (SSIS).

Education

Master of Science in Information Technology

Walden University - United States

Graduate Certificate in Information Systems

Walden University - United States

Bachelor of Science in Electrical Engineering

Bahir Dar University - Ethiopia

Business Skills / Technical Skills:

MS SQL server 2008/2012/2014, MS SQL server Integration Service 2012, SQL server analysis Services 2012, SQL server reporting services 2012, SQL Server Management Studio, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, T-SQL,

Visual Studio, SSDT, Open System Architect (OSA)

Informatica Cloud (ICS), Informatica Intelligent Cloud Services (IICS), Informatica Cloud Real Time (ICRT)

PostgreSQL

Snowflake, Azure

GCP (Google Cloud Platform- Big Query)

DBAmp

MuleSoft

Tableau

Cognos

OData

Rest API/ Postman

OLAP and OLTP

Agile (Rally, Version One, Devops, Jira)

Azure DevOps

Data Warehouse

SDLC

Git

AWS (Redshift, S3, QuickSight, Hubble, Datanet, Athena, Glue)

Contact this candidate